Database Design and Modeling

  1. Advanced Data Modeling Concepts
    1. Temporal Data Modeling
      1. Time Dimensions
        1. Valid Time
          1. Transaction Time
            1. Bitemporal Data
            2. Temporal Tables
              1. System-Versioned Tables
                1. Application-Time Tables
                  1. History Tracking
                  2. Temporal Constraints
                    1. Temporal Keys
                      1. Temporal Foreign Keys
                        1. Temporal Integrity
                        2. Temporal Queries
                          1. Point-in-Time Queries
                            1. Period Queries
                              1. Temporal Joins
                            2. Data Warehouse Modeling
                              1. OLAP vs OLTP
                                1. Analytical vs Transactional
                                  1. Query Patterns
                                    1. Performance Requirements
                                    2. Dimensional Modeling
                                      1. Facts and Dimensions
                                        1. Star Schema Design
                                          1. Snowflake Schema Design
                                            1. Galaxy Schema
                                            2. Fact Tables
                                              1. Additive Facts
                                                1. Semi-Additive Facts
                                                  1. Non-Additive Facts
                                                    1. Factless Fact Tables
                                                      1. Granularity Decisions
                                                      2. Dimension Tables
                                                        1. Dimension Attributes
                                                          1. Dimension Hierarchies
                                                            1. Slowly Changing Dimensions
                                                              1. Type 0 (Retain Original)
                                                                1. Type 1 (Overwrite)
                                                                  1. Type 2 (Add New Record)
                                                                    1. Type 3 (Add New Attribute)
                                                                      1. Type 4 (History Table)
                                                                        1. Type 6 (Hybrid)
                                                                      2. Conformed Dimensions
                                                                        1. Shared Dimensions
                                                                          1. Data Integration
                                                                            1. Consistency Requirements
                                                                          2. NoSQL Data Modeling
                                                                            1. NoSQL vs Relational
                                                                              1. Schema Flexibility
                                                                                1. Scalability Differences
                                                                                  1. Consistency Models
                                                                                    1. Query Capabilities
                                                                                    2. Key-Value Modeling
                                                                                      1. Simple Key-Value Pairs
                                                                                        1. Value Structure Options
                                                                                          1. Access Patterns
                                                                                            1. Use Cases
                                                                                            2. Document Modeling
                                                                                              1. Document Structure
                                                                                                1. Embedded Documents
                                                                                                  1. Document References
                                                                                                    1. Schema Design Patterns
                                                                                                    2. Column-Family Modeling
                                                                                                      1. Wide Column Stores
                                                                                                        1. Column Families
                                                                                                          1. Row Keys and Column Keys
                                                                                                            1. Denormalization Strategies
                                                                                                            2. Graph Modeling
                                                                                                              1. Nodes and Relationships
                                                                                                                1. Property Graphs
                                                                                                                  1. Graph Traversal Patterns
                                                                                                                    1. Schema-Free Modeling
                                                                                                                  2. Object-Relational Modeling
                                                                                                                    1. Object-Relational Features
                                                                                                                      1. User-Defined Types
                                                                                                                        1. Object Tables
                                                                                                                          1. Nested Tables
                                                                                                                            1. Arrays and Collections
                                                                                                                            2. Inheritance Modeling
                                                                                                                              1. Type Hierarchies
                                                                                                                                1. Method Inheritance
                                                                                                                                  1. Substitutability
                                                                                                                                  2. Complex Data Types
                                                                                                                                    1. Structured Types
                                                                                                                                      1. Reference Types
                                                                                                                                        1. Collection Types

                                                                                                                                    Previous

                                                                                                                                    6. Physical Database Design

                                                                                                                                    Go to top

                                                                                                                                    Next

                                                                                                                                    8. Database Design Patterns and Best Practices