Sunday, January 25, 2026

WHAT MEANING MEANS: BUSINESS RULES, PREDICATES, CONSTRAINTS, AND SEMANTIC CONSISTENCY



If we step back and look at what RDBMS is, we’ll no doubt be able to conclude that, as its name suggests (i.e., Relational Database Management System), it is a system that specializes in managing the data in a relational fashion. Nothing more. Folks, it’s important to keep in mind that it manages the data, not the MEANING of the data! And if you really need a parallel, RDBMS is much more akin to a word processor than to an operating system. A word processor (such as the much maligned MS Word, or a much nicer WordPress, for example) specializes in managing words. It does not specialize in managing the meaning of the words ... So who is then responsible for managing the meaning of the words? It’s the author, who else? Why should we tolerate RDBMS opinions on our data? We’re the masters, RDBMS is the servant, it should shut up and serve. End of discussion.” --Alex Bunardzik, Should Database Manage The Meaning?

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


 

 

 

View My Stats