LinkedDataHub - Relational model

Relational model

Relational model

The relational model (RM) 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.

Comment: enThe relational model (RM) 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.
Depiction
Has abstract: enThe relational model (RM) 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 database management system software take care of describing 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 a 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 , and Codd fiercely argued against deviations that compromise the original principles.
Hypernym: Approach
Is primary topic of: Relational model
Label: enRelational model
Link from a Wikipage to an external page: www.thethirdmanifesto.com/; archive.org/details/introductiontoda0000date; blogs.sun.com/bblfish/entry/why_binary_relations_beat_tuples; c2.com/cgi/wiki%3FRelationalModel
Link from a Wikipage to another Wikipage: Access plan; Alternate key; Arity; Armstrong's axioms; Attribute (computing); Attribute set; Bag (mathematics); Bijection; Candidate key; Cardinality (SQL statements); Cartesian product; Category:1969 in computing; Category:Articles with example pseudocode; Category:Programming paradigms; Category:Relational model; Christopher J. Date; Closed world assumption; Cloud database; Column (database); Commutative operation; Constraint (database); Data; Database; Database design; Database integrity; Database model; Database normalization; Database query; Database query language; Database schema; Database transaction; Data center; Data domain; Data type; DBMS; Declarative programming; Design; Domain relational calculus; Edgar F. Codd; Evaluation; Expressive power (computer science); Extension (predicate logic); File:Relational model concepts.png; Finite set; First normal form; First-order logic; Foreign key; Free variable; Functional dependency; Hierarchical database model; Hugh Darwen; Identifier; Information; Information Principle; Information retrieval; Information retrieval query language; Integrity constraint; International Organization for Standardization; Join (SQL); Law of excluded middle; List of relational database management systems; Logical equivalence; Logical schema; Many-to-many (data model); Massachusetts; Model (logic); Network model; Null (SQL); Object database; Object-oriented; One-to-many relationship; Operation (mathematics); Partial function; Performance tuning; Predicate (logic); Predicate (mathematical logic); Predicate logic; Preference; Primary key; Projection (relational algebra); Proper subset; Proposition; Query language; Query optimizer; Reasoning; Rel (DBMS); Relation (database); Relation (mathematics); Relational algebra; Relational calculus; Relational database; Relational database management system; Relational model; Relvar; Restriction condition; Role; Row (database); Set (mathematics); SQL; Standardization; Structure (mathematical logic); Subset; Superkey; System; Table (database); Three-valued logic; Truth value; Tuple; Tuple-versioning; Value (computer science); View (database); World Wide Web
SameAs: 4vvQ7; Base de datos relational; İlişkisel model; m.06jpb; Modèle relationnel; Model hubungan; Modello relazionale; Modelo relacional; Modelo relacional; Model relacional; Model relacyjny; Model relasional; Q755662; Relaatiomalli; Relācijas; Relacioni model; Relációs adatmodell; Relační model; Relasjonsmodellen; Relational model; Relational model; Relationeel model; Reliacinis modelis; Samhail choibhneasta; Əlaqəli model; Релациони модел; Реляционная модель данных; Реляциялық модель; Реляційна модель даних; مدل رابطه‌ای; தொடர்புசார் மாதிரி; 关系模型; 関係モデル; 관계형 모델
Subject: Category:1969 in computing; Category:Articles with example pseudocode; Category:Programming paradigms; Category:Relational model
Thumbnail
WasDerivedFrom: Relational model?oldid=1116513505&ns=0
WikiPageLength: 37662
Wikipage page ID: 26220
Wikipage revision ID: 1116513505
WikiPageUsesTemplate: Template:As of; Template:Bywhom; Template:Citation; Template:Citation needed; Template:Cite book; Template:Cn; Template:Commons category; Template:Database models; Template:Databases; Template:Div col; Template:Div col end; Template:Dmoz; Template:Main; Template:Nbsp; Template:Reflist; Template:Short description; Template:Unreferenced section