New Chapter 4. Data Modeling for Modern Applications
4.1 Introduction to Data Modeling
Why Data Modeling Matters
Conceptual, Logical, and Physical Models
Data-Centric Architecture
4.2 Relational Data Modeling
Entity-Relationship Models
Normalization and Denormalization
One-to-One, One-to-Many, and Many-to-Many Relationships
Keys and Constraints
4.3 Domain-Driven Data Modeling
Bounded Contexts
Aggregates and Entities
Value Objects
Event Modeling
4.4 Modeling for Microservices
Database-per-Service Pattern
Shared Database Anti-Pattern
Eventual Consistency
Saga Pattern
4.5 Document-Oriented Data Modeling
Embedding versus Referencing
Nested Documents
JSON and BSON Structures
Schema Design Principles
4.6 Key-Value Data Modeling
Session Stores
Caching Patterns
Object Serialization
Lookup Tables
4.7 Column-Family Data Modeling
Query-Driven Design
Partition Keys
Clustering Columns
Time-Series and Event Data
4.8 Graph Data Modeling
Nodes and Relationships
Property Graphs
RDF Triples
Modeling Social Networks and Knowledge Graphs
4.9 Time-Series Data Modeling
Measurements and Tags
Retention Policies
Compression Techniques
IoT and Monitoring Systems
4.10 Event-Based Data Modeling
Event Sourcing
Change Data Capture
Event Streams
CQRS
4.11 Data Warehousing Models
Star Schema
Snowflake Schema
Fact and Dimension Tables
OLAP Models
4.12 Modeling for AI and Machine Learning Applications
Feature Stores
Metadata Repositories
Embeddings
Vector Representations
4.13 Vector Data Modeling
Dense and Sparse Vectors
Metadata and Payloads
Similarity Search
Retrieval-Augmented Generation (RAG)
4.14 Polyglot Persistence
Combining SQL and NoSQL Databases
Data Synchronization Strategies
Hybrid Architectures
Data Ownership
4.15 Data Modeling Patterns
User Profiles
E-Commerce Systems
Social Networks
Content Management Systems
Recommendation Engines
IoT Platforms
4.16 Data Modeling Anti-Patterns
Over-Normalization
Excessive Joins
Hot Partitions
Unbounded Arrays
Shared Databases in Microservices
4.17 Case Studies
Netflix
Amazon
Uber
LinkedIn
Facebook
Revised Structure (First Part)
Part I. Foundations of Modern Database Systems
Introduction to Database Systems
Database Design Principles
Relational Database Fundamentals
Data Modeling for Modern Applications ★
Advanced SQL Programming
Query Processing and Optimization
Indexing Techniques
Transactions and Concurrency Control
Storage and Recovery Systems
Distributed Relational Databases