2 dépôts
Architectural patterns for data warehouses, including slowly changing dimensions and surrogate key generation.
Distinct from Data Warehouse Integrations: Covers the implementation of warehousing patterns rather than connectivity to or deployment of warehouse engines.
Explore 2 awesome GitHub repositories matching data & databases · Data Warehousing Patterns. Refine with filters or upvote what's useful.
This is a reference implementation library providing a collection of code samples, Transact-SQL scripts, and schemas for SQL Server, Azure SQL, and Azure Synapse. It focuses on providing standardized implementation patterns and reference code for building relational databases and cloud data warehouses. The library distinguishes itself by offering specialized guides and examples for deploying database instances within containerized environments and Azure cloud services. It includes specific reference databases and language extensions for integrating machine learning services and advanced analy
Implements standard architectural patterns for data warehousing and transactional processing.
Delta is a lakehouse table format that brings ACID transactions and data warehouse consistency to large scale data lakes on cloud object storage. It serves as an ACID transaction manager, coordinating atomic commits and serializable isolation for concurrent reads and writes across distributed compute engines. The project provides a multi-engine interoperability layer that uses format translation to allow diverse SQL engines and processing frameworks to read and write the same tables. It functions as a data versioning system, utilizing a transaction log to enable time travel, historical snapsh
Implements complex warehouse architectures using techniques such as slowly changing dimensions.