Skip to content
Data Engine Thinking Samples
Search
Ctrl
K
Cancel
GitHub
Select theme
Dark
Light
Auto
Patterns
Introduction
Pattern Structure
Design Patterns
Introduction
Design Pattern - Data Vault - Hub
Design Pattern - Data Vault - Satellite
Design Pattern - Generic - Access Area
Design Pattern - Generic - Assertion and State Timelines
Design Pattern - Generic - Bitemporal Data
Design Pattern - Generic - Control Framework
Design Pattern - Generic - Fundamental Data Integration Requirements
Design Pattern - Generic - Handling Flat Files
Design Pattern - Generic - Initial Load and Reinitialisation
Design Pattern - Generic - Landing Area
Design Pattern - Generic - Loading Landing Area Tables Using Record Condensing
Design Pattern - Generic - Nontemporal Data
Design Pattern - Generic - Performance Area
Design Pattern - Generic - Persistent Staging Area
Design Pattern - Generic - Unitemporal Data
Design Pattern - Generic - Using Checksums for Row Comparison
Design Pattern - Core Business Concept
Design Pattern - Natural Business Relationship
Solution Patterns
Introduction
Solution Pattern - SQL Server Family - CDC and Replication
Solution Pattern - SQL Server Family - Compacting as a Post-Process
Solution Pattern - SQL Server Family - Functional Compacting
Solution Pattern - SQL Server Family - Combining Multiple Time-Variant Objects
Solution Pattern - SQL Server Family - Creating a Dimension from a PIT
Solution Pattern - SQL Server Family - Creating a Dimension from Integration Layer Objects
Solution Pattern - SQL Server Family - Creating a Fact Object
Solution Pattern - SQL Server Family - Data Vault Hub
Solution Pattern - SQL Server Family - Data Vault Link
Solution Pattern - SQL Server Family - Data Vault Satellite
Solution Pattern - SQL Server Family - Deriving End-Dating
Solution Pattern - SQL Server Family - Exception Bitmap
Solution Pattern - SQL Server Family - Joining Objects in the Persistent Staging Area
Solution Pattern - SQL Server Family - Joining Two Time-Variant Objects
Solution Pattern - SQL Server Family - Landing Area
Solution Pattern - SQL Server Family - Persistent Staging Area
Solution Pattern - SQL Server Family - Snapshot-Based PIT
Solution Pattern - SQL Server Family - Timeline-Based PIT
Sample Setup
Introduction
Setup - 10 Create Database
Setup - 20 Create Source Data Objects
Setup - 30 Create Staging Layer Data Objects
Setup - 40 Create Integration Layer Data Objects
Setup - 50 Create Presentation Layer Data Objects
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
GitHub
Select theme
Dark
Light
Auto
Solution Patterns
Delivering dimensional models from the integration layer is documented as solution patterns:
Solution Pattern - SQL Server Family - Creating a Dimension from a PIT
Solution Pattern - SQL Server Family - Creating a Dimension from Integration Layer Objects
Solution Pattern - SQL Server Family - Creating a Fact Object
