Operational data store

from Wikipedia, the free encyclopedia

The term Operational Data Store (ODS) comes from information management in business administration .

An operational data store is a database that is used to integrate data from one or more data sources. For this purpose, the relevant data is extracted from the data sources and, if necessary, adjusted and transformed because of redundancies and violated integrity conditions . In the operational data store, the data is usually made available for real-time evaluations, which are difficult or impossible in the source systems. An application example is the preparation of offers depending on real-time stock exchange prices.

William H. Inmon defines an operational data store as follows:

"An operational data store is a subject-oriented, integrated, volatile, current-valued, detailed-only collection of data in support of an organization's need for up-to-the-second, operational, integrated, collective information."

"An operational data store is a topic-oriented, integrated, non-permanent or non- persistent detailed collection of data in order to support an organizational unit when it needs current, operational, integrated and holistic information."

- Inmon

According to this, an operational data store differs from a data warehouse in that there is no historical data, more frequent updates and finer data granularity .

With the trend towards real-time data warehouses and more powerful database management systems , the operational data store should merge with the data warehouse.

See also

literature

  • William H. Inmon: Building the Operational Data Store . John Wiley & Sons, 1999, ISBN 0-471-32888-X .
  • William H. Inmon, Richard D. Hackathorn: Using the Data Warehouse . John Wiley & Sons, 1994, ISBN 0-471-05966-8 .

Web links