Modelling Disparate Computer Systems (with xrdb)

From: Neo <neo55592_at_hotmail.com>
Date: 9 May 2005 15:10:29 -0700
Message-ID: <1115676629.888914.215560_at_o13g2000cwo.googlegroups.com>



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))) Received on Tue May 10 2005 - 00:10:29 CEST

Original text of this message