relational data model

(database)

(Or "relational model") A data model introduced by E.F. Codd in 1970, particularly well suited for business data management. In this model, data are organised in tables. The set of names of the columns is called the "schema" of the table.

Here is an example table with the schema (account number, amount) and 3 lines.

account number amount -------------- --------- 12343243546456 +30000.00 23149875245824 +2345.33 18479827492874 -123.25

The data can be manipulated using a relational algebra. SQL is a standard language for talking to a database built on the relational model (a "relational database").

["A relational model for large shared data banks" Communications of ACM 13:6, pp 377-387].

This article is provided by FOLDOC - Free Online Dictionary of Computing (foldoc.org)

Mentioned in

References in periodicals archive

There are numerous temporal extensions that have been proposed and implemented by extending the relational data models [6], [8].

A new optimized model to handle temporal data using open source database

They can use SQL as they can use XPath to retrieve data from both XML and relational data model.

Querying XML and Relational Data

The recognition accuracy comparison results of relational data model and nonrelational data model to different events are listed in Table 5, finding that the relational data model has higher recognition accuracy compared with the nonrelational data model.

Identifying network public opinion leaders based on Markov Logic Networks

The students do not need expansion of the knowledge concerning the relational data model in the future, which, despite all the advances in IT, is nearly 100% presented in current DBMS.

Human resources preparation for digital information processing

Development of e relational data model is based on the transformation of the analytical models in the process of data modelling.

Identification of data content based on measurement of quality of performance

The functional dependency in the relational data model and the child-parent relationships in the hierarchical data model are typical examples.

Froglingo, a programming language empowered by a total-recursive-equivalent data model

Edgar ("Ted") Codd introduced a simpler model: the relational data model. A year after his original 1969 IBM research report on the subject, Codd published a revised version for a wider audience (Codd, 1970) where he first argued that relations should be normalized so that each data entry would be atomic--we now call this first normal form.

Information modeling and relational databases

Emphasis was put on constructing a relational data model supporting the above logic, see Figure 2.

Preliminary technical design methodology of manufacturing systems

Gartner defines RDBMS as a database management system that incorporates the relational data model, normally including a Structured Query Language (SQL) application programming interface.

IBM AND ORACLE TIE FOR TOP POSITION ON LICENSE REVENUE

With dozens or hundreds of normalized tables in a database, active archiving preserves data from even the most complex relational data model, maintaining its relational integrity with 100 percent accuracy.

Database strategy: active archiving

In contrast to other probabilistic data models (see Section 8) which are only loosely related to the relational data model, PRA is a generalization of relational algebra.

A probabilistic relational algebra for the integration of information retrieval and database systems