Data warehouses and their architectures vary depending upon the
specifics of an organization's situation.
This illustrates three things:
This illustrates five things:
Data Warehouse Architecture (Basic)
shows a simple architecture for a data warehouse. End
users directly access data derived from several source systems through
the data warehouse.
Architecture of a Data Warehouse
This illustrates three things:
- Data Sources (operational systems and flat files)
- Warehouse (metadata, summary data, and raw data)
- Users (analysis, reporting, and mining)
The metadata and raw data of a traditional OLTP system is present, as
is an additional type of data, summary data. Summaries are very valuable
in data warehouses because they pre-compute long operations in advance.
For example, a typical data warehouse query is to retrieve something
like August sales. A summary in Oracle is called a materialized view.
Data Warehouse Architecture (with a Staging Area)
You need to clean and process your operational data before putting it
into the warehouse. You can do this programmatically although most data
warehouses use a Staging area instead. A staging area simplifies building summaries and general warehouse management.
Architecture of a Data Warehouse with a Staging Area
This illustrates four things:
- Data Sources (operational systems and flat files)
- Staging Area (where data sources go before the warehouse)
- Warehouse (metadata, summary data, and raw data)
- Users (analysis, reporting, and mining)
Data Warehouse Architecture (with a Staging Area and Data Marts)
Although the architecture in
is quite common, you may want to customize your warehouse's
architecture for different groups within your organization. You can do
this by adding data marts, which are systems designed for a particular line of business.Illustrates an example where purchasing, sales, and inventories are
separated. In this example, a financial analyst might want to analyze
historical data for purchases and sales.
Architecture of a Data Warehouse with a Staging Area and Data Marts
This illustrates five things:
- Data Sources (operational systems and flat files)
- Staging Area (where data sources go before the warehouse)
- Warehouse (metadata, summary data, and raw data)
- Data Marts (purchasing, sales, and inventory)
- Users (analysis, reporting, and mining)
No comments:
Post a Comment
Please do not enter any Spam link in the Comment box