An operational data store is basically a copy of an existing operational database. In the case of HECN AIS, while it will resemble the operational database, it is being stored in a different kind of database and on a different type of large computer. Where the operational data is stored in a hierarchical database (ADABAS) on the mainframe, the operational data store will be stored in a relational database (Oracle) on a Unix-based server. Operational data stores are often used to remove reporting from a production transaction-processing environment. This is done to eliminate the impact that reporting could have on day-to-day transaction processing. In the data warehouse environment, operational data stores are also used to organize data for loading into the warehouse. They can either be temporary storage areas, or as in the HECN AIS case, a persistent copy of the data that will be used for as hoc reporting.
A set of integrated, scrubbed data without history or summarization provided for tactical decision support. ODSs are also commonly used to populate data warehouses and data marts . ()
A type of database that serves as an interim area for a data warehouse in order to store time-sensitive operational data that can be accessed quickly and efficiently. In contrast to a data warehouse, which contains large amounts of static data, an ODS contains small amounts of information that is updated through the course of business transactions. An ODS will perform numerous quick and simple queries on small amounts of data, whereas a data warehouse will perform complex queries on large amounts of data. An ODS contains only current operational data while a data warehouse contains both current and historical data.
An ODS is an integrated database of operational data. Its sources include legacy systems and it contains current or near term data. An ODS may contain 30 to 60 days of information, while a data warehouse typically contains years of data.
An integrated database that contains current or near-term operational data, i.e., usually 30 to 90 days of information.
The place where operational data resides, such as a database or a log file. See also operational data.
the form that data warehouse takes in the operational environment. Operational data stores can be updated, do provide rapid and consistent time, and contain only a limited amount of historical data.
According to Bill Inmon, an operational data store (ODS) 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.