ODS or Operational Data Store are data store required when neither Data warehouse or OLTP systems supports organizations reporting need. ODS is neither Data Warehouse nor OLTP reporting systems, rather it can be viewed as data store that is between Data Warehouse and OLTP Database.
Generally ODS are set up when Data Warehouse can not provide real time reporting nor the OLTP systems.
example:
Call Center Datawarehouse can not feed reports to show real time call-in details of customer nor the OLTP due to performance consideration. In order to meet this reporting requirement, ODS can be setup which can take dimensional data from Datawarehouse and call details from OLTP and provide data for real time reports without burdening OLTP systems.
Careful decision should be made before setting up ODS, as sometimes reports can be fetched out of Data Warehouse (based on report need and data refresh in Data Warehouse). As setting up ODS can eat up your resources and burn budget too. ODS can also be considered as one of the data source for Data warehouse data in ETL process.
Generally ODS are set up when Data Warehouse can not provide real time reporting nor the OLTP systems.
example:
Call Center Datawarehouse can not feed reports to show real time call-in details of customer nor the OLTP due to performance consideration. In order to meet this reporting requirement, ODS can be setup which can take dimensional data from Datawarehouse and call details from OLTP and provide data for real time reports without burdening OLTP systems.
Careful decision should be made before setting up ODS, as sometimes reports can be fetched out of Data Warehouse (based on report need and data refresh in Data Warehouse). As setting up ODS can eat up your resources and burn budget too. ODS can also be considered as one of the data source for Data warehouse data in ETL process.
Comments
Post a Comment