An Operational Data Store (ODS) is a common component implemented in a Data Warehouse architecture to support a company’s reporting requirements that cannot be met by the business applications’ reporting features. An ODS is simply a database that is meant to store current data from heterogeneous data sources that requires some sort of transformation or integration with other source system’s data.
An Operational Data Store has the following characteristics:
It should have current data as it is meant to support the company’s day-to-day operation
- It is volatile. It always has the same time window, which means that there is a process or other type of mechanism that deletes the data out of the defined time window.
- Since it supports the company’s day-to-day operation, its refresh frequency is very high.
- Transformations and integrations, which are required for reporting requirements, are done by an ETL/ELT process. This encourages the good practice of not having business logic implemented in the reporting layer and reuse of code or business logic.
Tech & more blog 
Leave a comment