relational data model

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
Copyright © 2003-2025 Farlex, Inc Disclaimer
All content on this website, including dictionary, thesaurus, literature, geography, and other reference data is for informational purposes only. This information should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional.