Tuesday, January 21, 2025

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





Monday, July 8, 2024

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




 

Table of Contents

Series Preface
Introduction
1. Interpretation of Database Relations
1.1. Attributes as Constrained Domains
1.2. Time-Varying Relations
2. Representation of Database Relations
2.1. Physical Data Independence
2.1.1. Uniquely Named Attributes
2.1.2. Primary Keys
2.1.3. Relations and R-tables
3. Normalization
3.1. First Normal Form and “Simple” Domains
3.2. Normalization and Non-simple Domains
3.2.1. Foreign Keys
Conclusion

View My Stats