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

(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 ?
Limited by the file system and tied to relational databases, today's ILM and related solutions, including SRM, HSM, ECM (Enterprise Content Management), DLM (Data Lifecycle Management), e-mail archiving, data migration, CAS (Content Addressed Storage), tiered storage, etc.
Melton 1998) This new database query language will allow traditional relational database management system products to model and access objects in an "object-oriented manner.
When the vendors have implemented DRDA, customers will have the ability to access data in the four IBM relational database products as well as the database products from the other vendors.
Key features include the capability to extract test data that may reside in multiple relational databases, handling data compatibility and translation issues and providing federated data access.
Active archiving is database independent, allowing IT organizations to manage archived data across the leading relational database platforms (Oracle, DB2/UDB, Sybase, SQL Server, and Informix).
SeqStore's analysis manager allows users to build analysis pipelines using Wisconsin Package or third-party tools that take data through a series of analyses, automatically recording results to the relational database and notifying researchers if certain criteria have been met.
The small-footprint PointBase database offers developers full relational database functionality, integrated installation with VisualCafe, data synchronization and near-zero administration, enabling the creation of extremely portable multi-threaded applications that can function autonomously on a wide variety of platforms.
SELECT Database Wrapper is an add-on product for SELECT's enterprise-class data modeling tool SELECT SE(TM), which allows users to integrate relational databases with new component-based applications.
Alternatively, developers can utilize a relational deployment option with Oracle, SQL Server or other relational databases, if that is the preferred deployment environment.
InterSystems Corporation today announced the addition of an online demonstration of new MultiValue capabilities for the CACHEe post relational database.
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.
Yendluri will apply his more than 25 years of leadership experience in all aspects of relational database development to lead new and ongoing development programs for ANTs software inc.

Full browser ?