• Data warehouse is subject-oriented, integrated, time-variant, and non-volatile collection of data in support of management’s decision-making process.
• a data warehouse is data management and data analysis
• goal: is to integrate enterprise wide corporate data into a single reository from which users can easily run queries
Subject-orientedàDWH is organized around the major subjects of the enterprise..rather than the major application areas.. This is reflected in the need to store decision-support data rather than application-oriented data
IntegratedàBecause the source data come together from different enterprise-wide applications systems. The source data is often inconsistent using..The integrated data source must be made consistent to present a unified view of the data to the users
Time-variantàthe source data in the DWH is only accurate and valid at some point in time or over some time interval. The time-variance of the data warehouse is also shown in the extended time that the data is held, the implicit or explicit association of time with all data, and the fact that the data represents a series of snapshots
Non-volatileàdata is not update in real time but is refresh from operational system on a regular basis.
Some Overlapping Terminology in Data warehouse
No comments:
Post a Comment