DWGeneral-1HighLevelOverview(二)

2014-11-24 11:52:02 · 作者: · 浏览: 2
eral dimension tables. The design of a data mart often starts with an analysis of what data the user needs rather than focusing on the data that already exists.

Operational data store

A subject-oriented system that is optimized for looking up one or two records at a time for decision making. An operational data store (ODS) is a hybrid form of data warehouse that contains timely, current, integrated information. Including the ODS in the data warehousing environment enables access to more current data more quickly, particularly if the data warehouse is updated by one or more batch processes rather than updated continuously. The data typically is of a higher level granularity than the transaction. You can use an ODS for clerical, day-to-day decision making. This data can serve as the common source of data for data warehouses.