|
|
relational database
<database> (RDBMS - relational database management system) A
database based on the relational model developed by
E.F. Codd. A relational database allows the definition of
data structures, storage and retrieval operations and
integrity constraints. In such a database the data and
relations between them are organised in tables. A table is
a collection of rows or records and each row in a table
contains the same fields. Certain fields may be designated
as keys, which means that searches for specific values of
that field will use indexing to speed them up.
Where fields in two different tables take values from the same
set, a join operation can be performed to select related
records in the two tables by matching values in those fields.
Often, but not always, the fields will have the same name in
both tables. For example, an "orders" table might contain
(customer_id, product_code) pairs and a "products" table might
contain (product_code, price) pairs so to calculate a given
customer's bill you would sum the prices of all products
ordered by that customer by joining on the product-code fields
of the two tables. This can be extended to joining multiple
tables on multiple fields. Because these relationships are
only specified at retreival time, relational databases are
classed as dynamic database management system.
The first commercial RDBMS was the Multics Relational Data
Store, first sold in 1978.
INGRES, Oracle, Sybase, Inc., Microsoft Access, and
Microsoft SQL Server are well-known database products and
companies. Others include PostgreSQL, SQL/DS, and RDB.
["Managing Data Bases, Four Critical Factors" Michael
M. Gorman, QED Information Sciences, Inc.].
["An Introduction To Database Systems" (6th ed) C. J. Date,
Addison Wesley (an excellent source of detailed info)].
["An End-User's Guide to Data Base" James Martin, Prentice
Hall (excellent place to begin learning about DBMS)].
(2002-06-10)
Try this search on OneLook / Google
Nearby terms:
relation « relational algebra « relational calculus « relational database » relational database management system » relational data model » relational DBMS
This article was derived from the Free Online Dictionary of Computers and is available under ther terms of the GNU Free Documentation License.
650VA/110V 2-Outlet Line Interactive UPS (Black)650VA/110V 2-Outlet Line Interactive UPS (Black) ** 650VA/110V 2-Outlet Line Interactive UPS **Protect your PC and peripherals against lightning and power outages with this 650VA Line-Interactive UPS. Features include 2 outlets, UPS Auto-shut down in 3 seconds, an audible alarm, and more! For a high level of protection and ease of use, orderthis UPS-650 650VA UPS!General Features:- Black- 650VA rating- 110Vac Voltage- Two (2) Outlets- Line interactive- Frequency: 60 Hz- Transfer time: < 10 ms including direction time- 320 joules energy rating- Overload: UPS Auto-shut down in 3 seconds- Audible alarmFront Panel Features:- Power button- Normal LED- Backup LEDRear Panel Features:- Two (2) Outlets- One (1) RS-232 portUnit Dimensions:- 13" x 4" x 6" (L x W x H, approximate)Regulatory Approvals:- UL- CEFactory Plain Box Includes:- 650VA UPS- Power cord- One (1) 9-pin RS-232 serial cable- UPS Monitoring & Automatic Shutdown Software- Spare fuseNotes:- Model: UPS-650 Compatibility/Requirements/Disclosures: ** Requirements *** Available power outlet * CD or DVD-ROM drive (to load software) More ...
iOPS F312 128MB MP3/FM Digital Audio Player (Sil)iOPS F312 128MB MP3/FM Digital Audio Player (Sil) ** iOPS Digital Audio Player **This keychain-size Vamp digital audio device delivers about 15 hours of FM radio or MP3/WMA/OGG playback on a full charge. With a full 128 MB memory built in. The iOPS-F312 features a voice recorder, a line-in jack and CD file synch support for MP3 recording, an orange and blue, full-graphic LED display, computer synching via direct USB 1.1 connection, 20-preset memory for radio, 7 EQ modes (normal/rock/jazz/pop/TruBass/SRS WOW/user EQ) and multi-language support.General Features:- Silver and mirrored finish (mirroring may have imperfections)- 128 MB built in flash memory- Built in FM tuner- Voice recording- Organic EL display with 2 colors and 16 tones- SRS WOW features surround effect- USB 1.1 interface- Internal Li-Ion battery- Multiple language settingsSpecifications:- File Support: MP3, WMA, OGG- MP3 - 8~320 kbps bit rate- VBR / WMA - 32~192 kbps bit rate- OGG - 44 (Q-1) ~ 500 kbps (Q10) bit rate- Sampling Frequency: 16KHz / 22.05KHz / 24KHz / 32KHz / 44.1KHz / 48KHz- Up to 6.4Mbps transfer speedAudio: - Frequency Range: 20Hz ~ 20KHz- Headphone Output: (L)13m W+(R)13mW 16- S/N Raito: 95 dBFM Tuner:- Frequency Range: 76.0 MHz ~ 90 MHz- Headphone Output: (L) 13mW +(R)13 mW 16- S/N Raito: 80 dB- Built in antennaRegulatory Approvals:- FCC- CERetail Package Includes:- iOPS-F312 Digital Audio Player- Carrying case- Line in cable- Neck strap- USB extension cable- Earphones- Software CD- User manualNotes:- Model: iOPS-F312- UPC: 8 71838 00040 7- There may be imperfections in the mirrored finish on thefront of this device, flaking, chipping or discoloration. Compatibility/Requirements/Disclosures: ** Requirements *** PC Requirements * Pentium II 233 MHz or better* Windows 98SE/ME/2000/XP* 128 MB RAM or better* CD-ROM* Available USB port* Macintosh Requirements:* OS 9.5 ~ OS X* 128 MB RAM or better* CD-ROM* Available USB port** Disclosures *** There may be imperfections in the mirrored finish on thefront of this device. Imperfections may include, flaking, chipping or discoloration of the mirror. More ...
100-Piece Paper CD Sleeve w Window - 2 for $6.99100-Piece Paper CD Sleeve w Window - 2 for $6.99 ** 100-Piece Paper CD Sleeve w Window - 2 for $6.99 **Protect CDs from dirt and scratches with this lightweight Paper CD Sleeve. It features a cellophane window for easy viewing and a 1-inch flap. It comes in a 100-Piece set (100 individual CD sleeves) and is a great choice for compact disc packaging. Get yours today!General Features:- Lightweight paper CD sleeve- 100-Piece- Cellophane window- 1-inch flap to secure CDPackage Includes:- 100-Piece Paper CD Sleeve 100-Piece Compatibility/Requirements/Disclosures:** Requirements *** The need for a CD sleeve More ...
52x 700MB CD-R Media 100-Pack - 2 for $2252x 700MB CD-R Media 100-Pack - 2 for $22 ** 52x 700MB CD-R Media 100-Pack - 2 for $22 **This 100-pack CD-R media makes burning discs easy! Featuring 700 MB data storage, 80 minutes of digital audio and a maximum 52x recording speed, disc creationonly takes minutes! General Features:- 80-minute audio capacity- 700 MB data capacity- Rated for use with 52x speeds - White labelNotes:- (2) 100-piece packs Compatibility/Requirements/Disclosures:** Requirements *** CD-R/RW drive More ...
USB 1.1 External Floppy Disk Drive (Silver)USB 1.1 External Floppy Disk Drive (Silver) ** USB External Floppy Disk Drive - Silver **This 1.44MB external floppy disk drive is ideal for notebook users everywhere! Featuring a USB 1.1 interfacethis drive can be packed away until needed!General Features:- Attractive silver case- USB 1.1 interface- 1.44 MB disk capacity- Perfect for notebook users- 14-inch USB cable- PC and Macintosh compatibleRegulatory Marks:- FCC- VCCI- CSA- RU- TUV- CEPart Numbers:- ASM -27L4226- FRU -05K9283 - ASM - 93C5622- FRU - 01N6542Package Includes:- 1.44 MB external USB floppy disk drive- Driver CD- User ManualNotes:- ASM and FRU numbers may vary- Color of eject button may be blue or black Compatibility/Requirements/Disclosures:** Requirements *** PC Requirements:* Windows 98/MW/2000/XP* Pentium 133 MHz or higher* USB port* CD-ROM to install drivers* Macintosh Requirements:* Apple iMac, iBook or Power Macintosh G3 or G4* OS 8.6 or better* 32MB RAM* 1MB free drive space* USB port More ...
Crosley 3-Speed Turntable &AM/FM Radio (Chrome)Crosley 3-Speed Turntable &AM/FM Radio (Chrome) ** Crosley Radio Vintage Autoram 3-Speed Belt Driven Turntable **Step back in time....This Autorama Record Player represents a vintage icon mimicking the clean, streamlined stylings of a classic 1950’s automobile. From the sleek illuminated center dial,to the chrome grill-side mounted speakers, this beauty takes you back to the days of drive-ins and diners. The Autorama features an AM/FM Radio, a 3-speed turntable and enough sophistication to render most enthusiasts speechless. Play all your favorite 33 1/3, 45 and 78 RPM records with this stylish, streamlined Vintage AutoRama record player! Own a piece of history - order yours now!General Features:- Brushed Chrome- 3-Speed Belt Driven Turntable- Plays 33 1/3, 45 and 78 RPM Records- AM/FM Radio- Illuminated Electronically Assisted Dial Tuner- External FM Antenna- Dynamic Full Range Stereo Speakers- Manual Return Tone Arm- Diamond Stylus Needle- Auxiliary Line OutSpecifications:- AM Frequency Range: 525 - 1710 KHz- FM Frequency Range: 87.5 - 108.5 MHz- Power Consumption: 17 Watts- Power Source: AC 120V ~ 60 Hz- Speaker: 4" Dynamic type x 2- Speaker ohms: 4 ohms- Output: 4 ohms- Output Wattage: 2 Watts per channelDimensions:- 13.25" x 15" x 6.75" (W x D x H)Regulatory Approvals:- UL listedRetail Package Includes:- Crosley Radio AutoRama 3-Speed Turntable- 45 spindle adapter- Instruction ManualNotes:- Model: CR711 Compatibility/Requirements/Disclosures: ** Requirements *** Available Power Outlet Informational Links: http://www.crosleyradio.com/products/art_deco_radios/cr_711.html More ...
|
