Skip to content

Data Engine Thinking Samples

Select theme

Patterns
Sample Setup
Samples by Chapter
- Introduction
- Chapter 6 - Data Solution Architecture
  - Introduction
  - Architecture Overview
    
    Supporting Frameworks
    
    Introduction
    Data Logistics Control
    Testing
- Chapter 8 - Metadata, Automation, Code Generation
  - Introduction
  - Automating Delivery
    
    Introduction
    
    A Schema for Data Solution Automation
    
    Introduction
    
    Compilation and Code Generation
    
    Ways of Code Generation
    
    Templating Engines
    
    Introduction
    Running a Sample Template
    
    Domain-Specific Languages
    
    BIML
    
    Alternatives to Templating Engines
- Chapter 9 - Getting The Data In
  - Introduction
  - Staging Layer Implementation
    
    Landing Area
    
    Design Patterns
    Solution Patterns
    Data Type Mapping
    
    Persistent Staging Area
    
    Design Patterns
    Solution Patterns
    Schema Drift
  - Integration Layer Implementation
    
    Introduction
    
    Core Business Concepts
    
    Design Patterns
    Solution Patterns
    
    Natural Business Relationships
    
    Design Patterns
    Solution Patterns
    
    Context
    
    Design Patterns
    Solution Patterns
    Preparing the Satellite
    Loading a Unitemporal Satellite
    Loading a Bitemporal Satellite
    
    Other Integration Layer Considerations
    
    Joining Objects in the Persistent Staging Area
    
    Testing
    
    Introduction
    Uniqueness
    Completeness in Temporality
    Referential Integrity
    Test Generation Templates
    
    Notification
- Chapter 11 - Getting The Data Out
  - Introduction
  - Struggling with Time While Getting the Data Out
    
    Timelines
    Joining Two Time-Variant Objects
    Combining Multiple Time-Variant Objects
    Compacting in the Presentation Layer
    Snapshots
    Granularity and Redundancy
    Fidelity
  - Presentation Layer Implementation
    
    Performance Area
    
    Design Patterns
    Solution Patterns
    
    Access Area
    
    Design Patterns
    Solution Patterns
About
Taking the Next Step
License
Disclaimer

Select theme

On this page

Overview

On this page

Overview

Solution Patterns

Creating Point-In-Time (PIT) tables — the canonical performance area helper structures — is documented as solution patterns:

Solution Pattern - SQL Server Family - Timeline-Based PIT
Solution Pattern - SQL Server Family - Snapshot-Based PIT

Previous
Design Patterns Next
Design Patterns