dbTalk Databases Forums  

Modelling Disparate Computer Systems (with xrdb)

comp.databases.object comp.databases.object


Discuss Modelling Disparate Computer Systems (with xrdb) in the comp.databases.object forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Neo
 
Posts: n/a

Default Modelling Disparate Computer Systems (with xrdb) - 05-09-2005 , 05:10 PM






This example models 10 computer systems, each quite different than the
other. A portion of the script to create and select the first system is
shown below. Once entered, a user can view the details of each systems
by simply expanding tree nodes instead of having to perform joins. See
www.xrdb.com/example/ex123.asp for details. Would someone be willing to
model 10 or a 100 such systems in a traditional db to highlight their
advantages?

// Create a system that has a computer and speakers.
// The computer has a 20 GB IDE hard drive,
// and a 133 Mhz motherboard with dual 2.0 GHz processors.
// The motherboard has 3 slots,
// the first with 2/10 MBit network card,
// the second with audio card with 3 sampling rates.
// The third slot is empty.
// The 7.1 speaker system outputs 97 decibel per watt
// and can handle 1000 watts peak.
// See below script for additional specs.
(CREATE system inst *"system 1"
& it has (CREATE device inst *
& computer inst it
& deskTop inst it
& it mfg +dell
& it model# +"optiplex gx100"
& it serial# +DM6867A87
& it has (CREATE device inst *
& "hard drive" inst it
& it mfg +ibm
& it "drive type" +ide
& it capacity (CREATE spec inst *
& it qty +20
& it unit +gb)
& it "buffer size" (CREATE spec inst *
& it qty +2
& it unit +mb)
& it "rotational speed" (CREATE spec inst *
& it qty +10000
& it unit +rpm)
& it "seek time" (CREATE spec inst *
& it qty +10
& it unit +ms)
)
& it has (CREATE device inst *
& motherboard inst it
& it serial# +HG45U37Q
& it "bus speed" (CREATE spec inst *
& it qty +166
& it unit +mhz)
& it has (CREATE device inst *
& cpu inst it
& it mfg +intel
& it "cpu type" +pentium
& it serial# +VWR3786
& it "clock rate" (CREATE spec inst *
& it qty +2
& it unit +ghz)
)
& it has (CREATE device inst *
& cpu inst it
& it "cpu type" +pentium
& it serial# +VR3736
& it "clock rate" (spec inst *
& * qty 2
& * unit ghz)
)
& it has (CREATE slot inst *
& it position# +1st
& it "slot type" +pci
& it has (CREATE device inst *
& "network adapter" inst it
& it mfg +smc
& it serial# +Y683047
& it "transfer rate"
(CREATE spec inst *
& it qty +2
& it unit +mbit)
& it "transfer rate"
(CREATE spec inst *
& it qty +10
& it unit +mbit)
)
)
& it has (CREATE slot inst *
& it position# +2nd
& it "slot type" +pci
& it has (CREATE device inst *
& "audio adapter" inst it
& it mfg +"creative labs"
& it model# +SB6887i
& it "sampling rate"
(CREATE spec inst *
& it qty +22
& it unit +khz)
& it "sampling rate"
(CREATE spec inst *
& it qty +44
& it unit +khz)
& it "sampling rate"
(CREATE spec inst *
& it qty +88
& it unit +khz)
)
)
& it has (CREATE slot inst *
& it position# +3rd
& it "slot type" +scsi)
)
)
& it has (CREATE device inst *
& "speaker system" inst it
& it "speaker system type" +7.1
& it efficiency (CREATE spec inst *
& it qty +97
& it unit +db/watt)
& it "continuous power" (CREATE spec inst *
& it qty +200
& it unit +watt)
& it "peak power" (CREATE spec inst *
& it qty +1000
& it unit +watt)
)
)


// Find computer that has a mother board
// which has a cpu whose serial# is VR3736.
// Finds computer in system 1.
(SELECT computer inst * & * has (* has (* serial# VR3736)))


Reply With Quote
  #2  
Old   
Mikito Harakiri
 
Posts: n/a

Default Re: Modelling Disparate Computer Systems (with xrdb) - 05-09-2005 , 08:19 PM






Neo wrote:
Quote:
Modelling Disparate Computer
You meant "Desperate Computer"? or "Desperate Modelling"?



Reply With Quote
  #3  
Old   
Neo
 
Posts: n/a

Default Re: Modelling Disparate Computer Systems (with xrdb) - 05-10-2005 , 01:37 PM



Quote:
You meant "Desperate Computer"? or "Desperate Modelling"?
Both I also meant that each of the remaining 11 thru 100 computer
systems are to be considerably different and only known just before
adding the next one. The purpose of this scenario is to compare the
impact on different modelling methodologies.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.