Extending the Database Relational Model to Capture More Meaning

Extending the Database Relational Model to Capture More Meaning

December 1979 | E. F. Codd
**Summary:** E. F. Codd's paper discusses extending the relational database model to better capture the meaning of data, aiming for more systematic database design and intelligent systems. The paper introduces atomic and molecular semantics, where atomic semantics refers to the smallest meaningful units, and molecular semantics refers to larger meaningful units. The relational model is extended with new rules for insertion, update, and deletion, as well as new algebraic operators to support these semantics. The relational model is based on time-varying tabular relations, with attributes and domains. It includes insert-update-delete rules, relational algebra, and concepts like nonloss joins, functional dependencies, and normal forms. The paper also addresses the handling of null values, introducing a three-valued logic to manage unknown or inapplicable values. The paper discusses various relational algebra operators, including theta-join, natural join, division, and outer joins, which allow for more flexible and powerful data manipulation. It also introduces the concept of entity domains and surrogates, which provide permanent identifiers for entities, and discusses the classification of entities into characteristic, associative, and kernel types. The paper further explores the relationship between the relational model and predicate logic, noting that the relational model is closely related to predicate logic. It also discusses the design of entity types and their immediate properties, introducing P-relations to represent these properties and ensuring that properties are tied to the existence of entities. The paper concludes with a classification of entity types and associations, emphasizing the importance of distinguishing between different types of entities and their relationships. It also discusses the use of nonentity associations to illustrate the limitations of associative entities in contrast to the relational model. Overall, the paper presents a comprehensive extension of the relational model to better capture the meaning of data and support more complex database operations.**Summary:** E. F. Codd's paper discusses extending the relational database model to better capture the meaning of data, aiming for more systematic database design and intelligent systems. The paper introduces atomic and molecular semantics, where atomic semantics refers to the smallest meaningful units, and molecular semantics refers to larger meaningful units. The relational model is extended with new rules for insertion, update, and deletion, as well as new algebraic operators to support these semantics. The relational model is based on time-varying tabular relations, with attributes and domains. It includes insert-update-delete rules, relational algebra, and concepts like nonloss joins, functional dependencies, and normal forms. The paper also addresses the handling of null values, introducing a three-valued logic to manage unknown or inapplicable values. The paper discusses various relational algebra operators, including theta-join, natural join, division, and outer joins, which allow for more flexible and powerful data manipulation. It also introduces the concept of entity domains and surrogates, which provide permanent identifiers for entities, and discusses the classification of entities into characteristic, associative, and kernel types. The paper further explores the relationship between the relational model and predicate logic, noting that the relational model is closely related to predicate logic. It also discusses the design of entity types and their immediate properties, introducing P-relations to represent these properties and ensuring that properties are tied to the existence of entities. The paper concludes with a classification of entity types and associations, emphasizing the importance of distinguishing between different types of entities and their relationships. It also discusses the use of nonentity associations to illustrate the limitations of associative entities in contrast to the relational model. Overall, the paper presents a comprehensive extension of the relational model to better capture the meaning of data and support more complex database operations.
Reach us at info@study.space