Tuesday, January 14, 2025

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



 


Table of Contents

 Introduction

1. Information and Data

2. Ontological Commitment

3. Object-properties Modeling

4. Properties and Relationships

5. Kinds of Properties

    5.1. Entity Properties 

           5.1.1. First Order Properties

                    5.1.1.1. Observed/Measured 1OPs

                    5.1.1.2. Inferred 1OPs

                    5.1.1.3. Properties in Context

           5.1.2. Second Order Properties

   5.2. Group Properties

          5.2.1. Uniqueness 3OPs

          5.2.2. Functional Dependency 3OPs

          5.2.3. Aggregates Relationships 3OPs

          5.2.4. Meaning Criteria

   5.3. Multi-group Properties

          5.3.1. Inter-entity 4OPs

          5.3.2. Inter-aggregates 4OPs

6. Business Rules

    6.1. Property Rules

          6.1.1. 1OP Rules

         6.1.2. 1Opic Rules

   6.2. Entity 2OP Rules

   6.3. Group Rules

          6.3.1. Uniqueness 3OP Rules

          6.3.2. Functional Dependency 3OP Rules

          6.3.3. Aggregate 3OP Rules

   6.4. Multi-group Rules

          6.4.1. Inter-entities 4OP Rules

          6.4.2. Inter-aggregates 4OP Rules

 Appendix A: Meta-Logical Properties

1.      Designation “Property”

2.      Assertion “Property”

Appendix B: Primitive 1OPs

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

 


View My Stats