Tuesday, January 14, 2025

New Paper: CONCEPTUAL MODELING FOR DATABASE DESIGN - A Sound Guide



 


Table of Contents

Introduction

1. Information and Data

2. Object-properties Modeling

3. Properties and Relationships

4. Kinds of Properties

    4.1. Entity Properties 

           4.1.1. First Order Properties

                    4.1.1.1. Observed/Measured 1OPs

                    4.1.1.2. Inferred 1OPs

                 4.1.1.3. Primitive 1OPs

                    4.1.1.4. Properties in Context

           4.1.2. Metalogical Properties

                  4.1.2.1. Assertion “Property”

                   4.1.2.2 Designation “Property

           4.1.3  Second Order Properties

   4.2. Group Properties

          4.2.1. Uniqueness 3OPs

          4.2.2. Functional Dependency 3OPs

          4.2.3. Intra-aggregates 3OPs

          4.2.4. Meaning Criteria

   4.3. Multigroup Properties

          4.3.1. Inter-entities 4OPs

          4.3.2. Inter-aggregates 4OPs

5. Business Rules

    5.1. Property Rules

          5.1.1. 1OP BRs

          5.1.2. 1OPic BRs

   5.2. Entity 2OP Rules

   5.3. Group 3OP Rules

          5.3.1. Uniqueness BRs

          5.3.2. Functional Dependency BRs

          5.3.3. Intra-aggregates BRs

   5.4. Multigroup 4OP Rules

          5.4.1. Inter-entities BRs

          5.4.2. Inter-aggregates BRs

New Paper: RELATIONAL DATABASE DOMAINS - A Definitive Guide




Table of Contents

 

Introduction

1. Interpretation and Formalization

2. Entity Properties

2.1. Ontological Commitment

2.2. Kinds of Property

2.2.1. Observed/Measured Properties

2.2.2. Inferred Properties

2.2.3  Primitive Properties 

3. Relational Domains and Attributes

3.1. Domains As Data Types

3.1.1. RDM and Programming Data Types

3.1.2. Abstract Data Types

3.2. Domain Definition

3.2.1. Domain Predicate

3.2.2. Domain Operators

4. Kinds of Domain

4.1. Base and Derived Domains

4.2. Primitive Domains

5.3. Atomic ("Simple") Domains

5.4. Complex (Derived) Domains

5. RDM Type System

6. DBMS Domain Support

6.1. A Complex Domain Example

6.2. SQL Built-in Data Types

Conclusion

 


Monday, July 22, 2024

New Paper: THE FINAL NULL IN THE COFFIN - A RELATIONAL SOLUTION TO MISSING DATA




Table of Contents

Introduction
1. “Inapplicable Data”: Nothing's Missing
2. Missing Data: Into the Unknown
3. SQL NULL: What-Valued Logic?
4. Known Unknowns: Metadata
5. A Relational Solution
5.1. The Practicality of Theory
5.2. A Real World Example
5.3. Relation Proliferation
6. Questions/Comments/Objections
Conclusion
 

 

 

 

 

Sunday, July 14, 2024

New Paper: LOGICAL ACCESS, DATA SUBLANGUAGE, KINDS OF RELATIONS, DATABASE REDUNDANCY AND CONSISTENCY



 

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: INTERPRETATION AND REPRESENTATION OF DATABASE RELATIONS




 

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 Nonsimple Domains
3.2.1. Foreign Keys
Conclusion

Wednesday, June 26, 2024

New Paper: FIRST NORMAL FORM - A DEFINITIVE GUIDE



 Available from PAPERS page.

 



Table of Contents

Introduction
1.     The Normal Form
2.     First Normal Form
3.     Domain Decomposability & Value Atomicity
4.     1NF & Tables
5.     SQL & 1NF
5.1.   Repeating Groups & Repeated Attributes
5.2.   Information Principle & SQL

 


View My Stats