Thursday, December 17, 2009

Data Warehouse Architecture (with a Staging Area and Data Marts)

Data Warehouse Architecture (with a Staging Area and Data Marts)




•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

1 comment:

  1. The technical architecture of data warehouses is somewhat similar to other systems, but does have some special characteristics. survival-warehouse.com reviews

    ReplyDelete