relational database

(redirected from Relational databases)
Also found in: Dictionary, Thesaurus.
Related to Relational databases: SQL

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 ?
Prior to Oracle, he co-founded a relational database software company, and previously spent 5 years at IBM Research and IBM's Office Products Advanced Technology group.
It may seem strange to see MongoDB expanding the very features of the relational databases that it originally rejected.
Edgar Codd introduced the principles of relational databases while working at IBM in the early 1970s.
Relational databases are typically used for queries on single topics.
The method of applying the calculus of descriptive logics for identifying conflicts of entity-relationship conceptual schemes of relational databases allows us to reduce the process of identifying of semantic conflicts of metadata and the inconsistency of data which occurs when their integration, to solving of algorithmic problems of consistency and classification of terminology, and the consistency of the ontology of these data [7; 14; 15].
As mentioned before, Oracle XMLDB technology extends the possibilities of the relational database by offering all the features of an XML database and offers an independent structure for the storage and management of XML data.
Database Systems Design, Implementation and Management could serve as a good introduction to relational database management systems for the records and information management (RIM) professional who is familiar with them at the 10,000-foot level but needs to gain additional practical knowledge.
One of the key characteristics of a relational database is that it does not analyze data in its native or original form.
To avoid having the watermark data removed from the watermarked relational database when relational databases are updated or attacked, the following benign database updates and malicious attacks are discussed.
Latitude and longitude data deserve special care from inside relational databases to reflect their computation intensive nature and to keep up with the database performance.
The solution provides a bridge between the existing COBOL code and the new relational database such as Oracle or Microsoft SQL Server.

Full browser ?