Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Relational Model

  • David W. Embley
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_306

Synonyms

Relational database

Definition

The Relational Model describes data as named relations of labeled values. For example, customer ID’s can relate with customer names and addresses in the relational model as Customer: {<(CustomerID, 11111), (Name, Pat), (Address, 12 Maple)>, <(CustomerID, 22222), (Name, Tracy), (Address, 44 Elm)>}. In this example, there is a name for the relation - Customer; label-value pairs - e.g., (CustomerID, 11111), which provide the labeled values; and tuples - e.g., <(CustomerID, 11111), (Name, Pat), (Address, 12 Maple)>, which are the tuples of the named relation.

Usually, the relations of the relational model are viewed as tables. Fig. 1 shows an example of several relations viewed as tables. Together, they constitute a relational database. The first table in Fig. 1 is the table view of the relation described in the previous paragraph.
This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Atzeni P, De Antonellis V. Relational database theory. Redwood City: The Benjamin/Cummings Publishing Company, Inc.; 1993.zbMATHGoogle Scholar
  2. 2.
    Codd EF. A relational model for large shared data banks. Commun ACM. 1970;13(6):377–487.zbMATHCrossRefGoogle Scholar
  3. 3.
    Elmasri R, Navathe SB. Fundamentals of Database Systems. 5th ed. Boston: Addison-Wesley; 2007.zbMATHGoogle Scholar
  4. 4.
    Maier D. The theory of relational databases. Rockville: Computer Science Press, Inc.; 1983.zbMATHGoogle Scholar
  5. 5.
    Silberschatz A, Korth HF, Sudarshan S. Database system concepts. 5th ed. New York: McGraw-Hill; 2006.zbMATHGoogle Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Brigham Young UniversityProvoUSA

Section editors and affiliations

  • David W. Embley
    • 1
  1. 1.Brigham Young UniversityProvoUSA