Introduction / 1: |
Information Modeling / 1.1: |
Modeling Approaches / 1.2: |
Some Historical Background / 1.3: |
The Relevant Skills / 1.4: |
Summary / 1.5: |
Information Levels and Frameworks / 2: |
Four Information Levels / 2.1: |
The Conceptual Level / 2.2: |
Database Design Example / 2.3: |
Development Frameworks / 2.4: |
Conceptual Modeling: First Steps / 2.5: |
Conceptual Modeling Language Criteria / 3.1: |
Conceptual Schema Design Procedure / 3.2: |
CSDP Step 1: From Examples to Elementary Facts / 3.3: |
CSDP Step 2: Draw Fact Types, and Populate / 3.4: |
CSDP Step 3: Trim Schema / 3.5: |
Note Basic Derivations |
Uniqueness Constraints / 3.6: |
Arity Check / 4.1 CSDP Step 4: Uniqueness Constraints: |
Mandatory Roles / 4.2 Uniqueness Constraints on Unaries and Binaries: |
Introduction to CSDP Step 5 / 5.1: |
Mandatory and Optional Roles / 5.2: |
Reference Schemes / 5.3: |
Case Study: A Compact Disc Retailer / 5.4: |
Logical Derivation Check / 5.5: |
Value, Set-Comparison and Subtype Constraints / 5.6: |
CSDP Step 6: Value, Set-Comparison and Subtype constraints / 6.1: |
Basic Set Theory / 6.2: |
Value Constraints and Independent Objects / 6.3: |
Subset, Equality, and Exclusion Constraints / 6.4: |
Subtyping / 6.5: |
Generalization of Object Types / 6.6: |
Other Constraints and Final Checks / 6.7: |
CSDP Step 7: Other Constraints and Final Checks / 7.1: |
Occurrence Frequencies / 7.2: |
Ring Constraints / 7.3: |
Other Constraints and Rules / 7.4: |
Final Checks / 7.5: |
Entity Relationship Modeling / 7.6: |
Overview of ER / 8.1: |
Barker notation / 8.2: |
Information Engineering notation / 8.3: |
IDEF1X / 8.4: |
Mapping from ORM to ER / 8.5: |
Data Modeling in UML / 8.6: |
Object-Orientation / 9.1: |
Attributes / 9.3: |
Associations / 9.4: |
Set-Comparison constraints / 9.5: |
Other Constraints and Derivation Rules / 9.6: |
Mapping from ORM to UML / 9.8: |
Advanced Modeling Issues / 9.9: |
Join Constraints / 10.1: |
Deontic Rules / 10.2: |
Temporality / 10.3: |
Collection Types / 10.4: |
Nominalization and Objectification / 10.5: |
Open/Closed World Semantics / 10.6: |
Higher-Order Types / 10.7: |
Relational Mapping / 10.8: |
Implementing a Conceptual Schema / 11.1: |
Relational Schemas / 11.2: |
Relational Mapping Procedure / 11.3: |
Advanced Mapping Aspects / 11.4: |
Data Manipulation with Relational Languages / 11.5: |
Relational Algebra / 12.1: |
Relational Database Systems / 12.2: |
SQL: Historical and Structural Overview / 12.3: |
SQL: Identifiers and Data Types / 12.4: |
SQL: Choosing Columns, Rows, and Order / 12.5: |
SQL: Joins / 12.6: |
SQL: In, Between, Like, and Null Operators / 12.7: |
SQL: Union and Simple Subqueries / 12.8: |
SQL: Scalar Operators and Bag Functions / 12.9: |
SQL: Grouping / 12.10: |
SQL: Correlated and Existential Subqueries / 12.11: |
SQL: Recursive Queries / 12.12: |
SQL: Updating Table Populations / 12.13: |
SQL: Other Useful Constructs / 12.14: |
Using Other Database Objects / 12.15: |
SQL: Data Definition / 13.1: |
SQL: User Defined Functions / 13.2: |
SQL: Views and Computed Columns / 13.3: |
SQL: Triggers / 13.4: |
SQL: Stored Procedures / 13.5: |
SQL: Indexes / 13.6: |
Other Objects / 13.7: |
Exploiting 3GLs / 13.8: |
Exploiting XML / 13.9: |
Security and Meta-Data / 13.10: |
Concurrency / 13.11: |
Schema Transformations / 13.12: |
Schema Equivalence and Optimization / 14.1: |
Predicate Specialization and Generalization / 14.2: |
Nesting, Coreferencing, and Flattening / 14.3: |
Other Transformations / 14.4: |
Introduction / 1: |
Information Modeling / 1.1: |
Modeling Approaches / 1.2: |