Summarized Data
Summarized data is classified into two: Lightly summarized and highly summarized. Lightly summarized data are the hallmark of lightly summarized data for every enterprise element .An enterprise element may have access to both detailed and summarized data, but together this will be much less than the total stored in current detail. Highly summarized data are primarily for enterprise executives. Highly summarized data can come from either the lightly summarized data used by enterprise elements or from current detail. Data volume at this level is much less than other levels and represents an electric collection supporting a wide variety of needs and interests. In addition to access to highly summarized data executives also have the capability of accessing levels of detail through a "drill down" process.
Current Detail
The art of a Data Warehouse is its current detail, where the bulk of data resides. Current detail comes directly from operational systems and may be stored as raw data or as aggregafrons of raw data. Current detail, organized by subject area, represents the entire enterprise, rather than a given application.Current detail is lowest level of data granularity in th~ Data Warehouse. Every
data entity in current detail is a snapshot, at a moment in time, representing the instance when the data are accurate. Current detail is typically two or five years old. Current detail refreshment occurs as frequently as necessary to support enterpnse requlrements.
System of Record
A system of record is the source of the data that feed the Data Warehouse. Data in Data Warehouse differ from operational systems data in that they can only be read, not modified. Thus, it is necessary thacomplete, accurate and have the best structural conformance to the Data Warehouse. Often, these data are closest to the source of entry into the production environment. In other cases, a system of record may be one, which contains already summarized data.
|
