Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
Operational data store
open-in-new
<p>An operational data store (ODS) is used for operational reporting and as a source of data for the <a href="/facts/Enterprise_data_warehouse/we5rblq9">enterprise data warehouse</a> (EDW). It is a complementary element to an EDW in a <a href="/facts/Decision_support/HPeJMlRM">decision support</a> environment, and is used for operational reporting, controls, and decision making, as opposed to the EDW, which is used for tactical and strategic decision support. </p><p>An ODS is a <a href="/facts/Database/VYcpkevb">database</a> designed to <a href="/facts/Data_integration/BU47JR28">integrate data</a> from multiple sources for additional operations on the data, for reporting, controls and operational decision support. Unlike a production <a href="/facts/Master_data_management/Qbyn0zR1">master data store</a>, the data is not passed back to <a href="/facts/Operational_system/jgtspHX9">operational systems</a>. It may be passed for further operations and to the <a href="/facts/Data_warehouse/we5rblq9">data warehouse</a> for reporting. </p><p>An ODS should not be confused with an enterprise <a href="/facts/Data_hub/V9a08NTg">data hub</a> (EDH). An operational data store will take transactional data from one or more production systems and loosely integrate it, in some respects it is still subject oriented, integrated and time variant, but without the volatility constraints. This integration is mainly achieved through the use of EDW structures and content. </p><p>An ODS is not an intrinsic part of an EDH solution, although an EDH may be used to subsume some of the processing performed by an ODS and the EDW. An EDH is a broker of data. An ODS is certainly not. </p><p>Because the <a href="/facts/Data/AUBFN97o">data</a> originates from multiple sources, the integration often involves <a href="/facts/Data_cleaning/FPVIcxV6">cleaning</a>, resolving redundancy and checking against <a href="/facts/Business_rule/9d4kYkDr">business rules</a> for <a href="/facts/Data_integrity/g3XGbKIH">integrity</a>. 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. </p>