relational database


Also found in: Dictionary, Thesaurus, Medical, Legal, Wikipedia.
Related to relational database: SQL, relational database management system

relational database

[ri′lā·shən·əl ′dad·ə‚bās]
(computer science)

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)].

relational database

A database that maintains a set of separate, related files (tables), but combines data elements from the files for queries and reports when required. The concept was developed in 1970 by Edgar Codd, whose objective was to accommodate a user's ad hoc request for selected data. Most every business database management system (DBMS), including Oracle, DB2, SQL Server, MySQL, etc., is a relational DBMS (RDBMS) (see DBMS).

Hierarchical, Network and Object Databases
In non-relational "hierarchical" and "network" databases, records in one file contain embedded pointers to the locations of records in another, such as customers to orders and vendors to purchases. These are fixed links set up ahead of time to speed up daily processing. Another type of non-relational database is the "object database," which stores data consistent with their object model (see object database).

Comparing and Joining
Routine queries to a relational database often require data from more than one file. For example, to obtain the names of customers who purchased a particular product, data must be extracted from both the customer and order files. A relational DBMS has the flexibility to "join" two or more files by comparing key fields such as account number and name and generating a new file from the records that meet the matching criteria (see join).

Indexes Are Used
In practice, a pure relational query can be very slow. In order to speed up the process, indexes are built and maintained on the key fields used for matching. Sometimes, indexes are created "on the fly" when the data are requested.

Relational Terms       Common Term

  Table or Relation      File

  Row or Tuple           Record

  Column or Attribute    Field



References in periodicals archive ?
How does one do that with solutions tied to relational databases that are inflexible to business value changes--if you didn't plan for it in advance, you probably can't do it.
Indexes to records within relational databases may be stored separately from the actual database files containing data records.
HSM manages relational data at the table or dataset level (a relational database table is physically stored as a file), and active archiving manages relational data at the row or record level.
ANTs will also be showing its flagship ANTs Data Server in Booth S304 in the Anaheim Convention Center, demonstrating how applications can be migrated from traditional relational databases, such as Oracle, Sybase and SQL Server, as well as the performance and cost advantages of doing so.
OTCBB: ANTS), based in California's Silicon Valley, develops and sells the ANTs Data Server, an affordable, high-performance relational database that is compatible with popular databases.
The Hitachi America Embedded Business Group, part of the company's Information Division, was recently formed to market and sell Hitachi's Entier relational database software.
Teradata distinguishes between growth in relational database software used for general purposes and growth pertaining specifically to enterprise data warehousing - its central information platform, marketed globally to Fortune 3,000 companies.
The report, Worldwide RDBMS 2005 Vendor Shares: Preliminary Results for the Top 5 Vendors Show Continued Growth (IDC #201692), examines the preliminary 2005 revenue data for the worldwide relational database management systems (RDBMS) software market and presents a view as to how the top 5 vendors, and the market overall, fared that year.
Relational database pioneer Jim Starkey, the creator of InterBase, has joined MySQL AB as Senior Software Architect.
The Unify NXJ Composer solution can quickly migrate Lotus Notes applications to J2EE, but just as important, it provides an easy-to-use graphical development environment for relational database and J2EE platforms that offers an easy transition for Lotus Notes developers," said Bill McNaughton, CEO of Turnpike Systems.
Our rich heritage in relational database and developer productivity solutions enabled us to be first to market with a response to customer demand for a Lotus Notes migration solution.

Full browser ?