ODS is a source like database that collects data from variety of operational systems with a minor enhancements.
Unlike a master data store, the data is not passed back to operational systems. It may be passed for further operations and to the data warehouse for reporting.
Because the data originates from multiple sources, the integration often involves cleaning, resolving redundancy and checking against business rules for integrity. An ODS is usually designed to contain low-level or atomic (indivisible) data (such as transactions and prices) with limited history that is captured "real time" or "near real time" as opposed to the much greater volumes of data stored in the data warehouse generally on a less-frequent basis.
The Primary purpose of the ODS is to collect, integrate, and distribute current information about the subject and to provide an enterprise view of this subject. The subject can be any that is important for the organization. For example, the customer ODS will typically house the most current information on a customer as well as information on all recent customer interaction with the organization including product ownership and summary usage statistics, statement information, summary-level contacts and other related information.
Unlike a master data store, the data is not passed back to operational systems. It may be passed for further operations and to the data warehouse for reporting.
Because the data originates from multiple sources, the integration often involves cleaning, resolving redundancy and checking against business rules for integrity. An ODS is usually designed to contain low-level or atomic (indivisible) data (such as transactions and prices) with limited history that is captured "real time" or "near real time" as opposed to the much greater volumes of data stored in the data warehouse generally on a less-frequent basis.
The Primary purpose of the ODS is to collect, integrate, and distribute current information about the subject and to provide an enterprise view of this subject. The subject can be any that is important for the organization. For example, the customer ODS will typically house the most current information on a customer as well as information on all recent customer interaction with the organization including product ownership and summary usage statistics, statement information, summary-level contacts and other related information.
No comments:
Post a Comment