ods operating data store - ghdrako/doc_snipets GitHub Wiki

ODS usually is positioned in between relational database(s) and DWH or EDWH components, and it is used to prepare data to be served to DWH through ETL, or other data architecture components used to process large amounts of raw data and create meaningful reports with aggregation and analytics on top large data sets. But it can be used also for:

• data consolidation — ingesting multiple data sources main advantage from other data stores like data lakes and warehouses is that it is light and fast and can be used to consolidate data across systems
• “real-time” reporting — being the data system with the freshest data ODS can be used for reporting based on freshest data, as it stores most recent data from other systems
• troubleshooting — again, as it has freshest data from various systems it can be used to troubleshoot data inconsistencies from various data sources
• system integration — since the data is ingested from various systems, business logic can be implemented to trigger new business process in another system