Tuesday, January 21, 2025

Revision 1 (6/25) of CONCEPTUAL MODELING FOR DATABASE DESIGN - A Sound Guide



 


Table of Contents

Introduction
1 Information Representation
2 Conceptual Modeling
2.1 Ontological Commitment
2. 2 Properties and Relationships
3. Entity Properties  
3.1 First Order Properties
3.2 Assertion Predicates
3.3 Second Order Properties
4 Group Properties
4.1 Third Order Properties
4.1.1 Entity Uniqueness
4.1.2 1OP (in Context) Dependencies
4.1.3 Aggregates Relationships
4.1.4 Meaning Criteria and ESS Relationships
4.1.5 Designation “Property”
5 Multigroup Fourth Order Properties
5.1 Inter-group Entity Relationships
5.2 Inter-group Aggregates Relationships
6. Business Rules
6.1 Entity Type Rules
6.2 Group Type Rules
6.3 Multigroup Type Rules
Conclusion
Appendix: PoM/OCP and RDM





Revision 1 (7/25) of RELATIONAL DATABASE DOMAINS: A Definitive Guide






Table of Contents

Introduction
1 Formal Theory and Interpretation
2 Database Domains
2.1 Domains As Data Types
2.1.1 RDM and Programming Data Types
2.1.2 Abstract Data Types
2.2 Domain Definition
2.2.1 Type Specification
2.2.2 Domain Operators
3 Kinds of Domains
3.1 Base and Derived Domains
3.2 Primitive Domains
3.3 Atomic ("Simple") Domains
3.4 Complex (Derived) Domains
4 RDM Type System
5 DBMS Domain Support
Appendix 1: A Complex Domain Example
Appendix 2: A Note on SQL Built-in Data Types


 

 

 

Sunday, July 14, 2024

New Paper: UNDERSTANDING THE REAL RDM - E.F. Codd 1969-70 Papers Part 2



 



Table of Contents


 

Introduction
1. Logical Symmetric Access
2. Universal Data Sublanguage
2.1. FOPL vs. SOL
2.2. Relational Completeness
2.3. Computational Completeness and Hosting
3. Kinds of Relations
3.1. Expressible and Named Relations
3.2. Derived Relations
3.3. Data Storage
4. Derived Relations and Redundancy
4.1. Database Consistency
5. Database Catalog
Conclusion





View My Stats