Part 3: Types of Data Warehouse Architectures

Data Warehouse Architectures In this series, the previous post was about Part 2: Data Warehousing Concepts - OLTP Vs Data Warehouse. Please go through it if you did not read. Below are some of the widely used Data Warehouse architectures. Basic Data Warehouse Architecture Data Warehouse Architecture with Staging Area Data Warehouse Architecture with Staging Area and Data Marts Basic Data Warehouse Architecture In the Basic Data...

Read More

Part 2: Data Warehousing Concepts - OLTP Vs Data Warehouse

OLTP Vs Data Warehouse In this series, the previous post was about Part 1: Data Warehousing Concepts. Please go through it if you did not read. OLTP and Data Warehouse have many differences in the architecture, process and performance. Here are the differences on various aspects. Performance Data Modification Design Operation Historical Data Performance Data Warehouse are developed to accommodate adhoc queries. So data warehouse...

Read More

Part 1: Data Warehousing Concepts

What is a Data Warehouse ? A data warehouse is a relational database that is designed for faster querying and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources. In addition to a relational database, a data...

Read More