dido:public:ra:xapend:xapend.a_glossary:r:relational_model
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dido:public:ra:xapend:xapend.a_glossary:r:relational_model [2021/07/30 15:27] murphy |
dido:public:ra:xapend:xapend.a_glossary:r:relational_model [2021/10/30 14:47] (current) nick |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Relational Model (RM) ====== | ====== Relational Model (RM) ====== | ||
| - | [[dido:public:ra:xapend:xapend.a_glossary| Return to Glossary ]] | + | [[dido:public:ra:xapend:xapend.a_glossary:start| Return to Glossary ]] |
| - | The **Relational Model (RM)** for database management is an approach to managing data using a structure and language consistent with first-order predicate logic, first described in 1969 by English computer scientist Edgar F. Codd, where all data is represented in terms of tuples, grouped into relations. A database organized in terms of the relational model is a relational database. | + | The **Relational Model (RM)** for [[dido:public:ra:xapend:xapend.a_glossary:d:database]] management is an approach to managing data using a structure and language consistent with first-order predicate logic, first described in 1969 by English computer scientist Edgar F. Codd, where all data is represented in terms of tuples, grouped into relations. A database organized in terms of the relational model is a relational database. |
| - | The purpose of the relational model is to provide a declarative method for specifying data and queries: users directly state what information the database contains and what information they want from it, and let the [[dido:public:ra:xapend:xapend.a_glossary:d:dbms]] software take care of describing [[dido:public:ra:xapend:xapend.a_glossary:d:datastructure|data structures]] for storing the data and retrieval procedures for answering queries. | + | The purpose of the relational model is to provide a [[dido:public:ra:xapend:xapend.a_glossary:d:declarative | Declarative]] method for specifying data and queries: users directly state what information the database contains and what information they want from it, and let the [[dido:public:ra:xapend:xapend.a_glossary:d:dbms]] software take care of describing [[dido:public:ra:xapend:xapend.a_glossary:d:datastructure|data structures]] for storing the data and retrieval procedures for answering queries. |
| - | Most relational databases use the SQL data definition and query language; these systems implement what can be regarded as an engineering approximation to the relational model. A table in an SQL database schema corresponds to a predicate variable; the contents of a table to a relation; key constraints, other constraints, and SQL queries correspond to predicates. However, SQL databases deviate from the relational model in many details, and Codd fiercely argued against deviations that compromise the original principles. | + | Most relational databases use the [[dido:public:ra:xapend:xapend.a_glossary:s:sql|SQL]] data definition and query language; these systems implement what can be regarded as an engineering approximation to the relational model. A table in an SQL database schema corresponds to a predicate variable; the contents of a table to a relation; key constraints, other constraints, and SQL queries correspond to predicates. However, SQL databases deviate from the relational model in many details, and Codd fiercely argued against deviations that compromise the original principles. |
| Source: [[https://en.wikipedia.org/wiki/Relational_model ]] | Source: [[https://en.wikipedia.org/wiki/Relational_model ]] | ||
dido/public/ra/xapend/xapend.a_glossary/r/relational_model.1627673250.txt.gz · Last modified: 2021/07/30 15:27 by murphy
