Modern Data Warehousing Design

We use the contemporary Data Warehouse 3-Layers framework in the data warehouse design.

The staging layer enables the speedy ETL of operational systems data. The much of the complex data transformation and data-quality processing will occur in this layer.

Via another set of ETL processes the data are loaded into the foundation or integration layer (as usual 3NF design) where they take shape and provide some end-user application access.

The access layer represents data that most users' applications can understand. This layer is as usual represented by star schemas.

Aggregation of analytical data in a data warehouse using continuous or near real-time loads

Near-real time data warehousing when changes in multiple source databases are captured and propagated to one target warehouse database can be implemented through the Oracle GoldenGate product.