Skip to content

Instantly share code, notes, and snippets.

@shenli

shenli/OLD-vs-DW.csv

Created October 27, 2023 16:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save shenli/dba039569792e30a4a7074ffea36a41b to your computer and use it in GitHub Desktop.
Save shenli/dba039569792e30a4a7074ffea36a41b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
OLD-vs-DW.csv
Feature/Functionality Operational Data Layer Data Warehouse
Purpose Real-time operational support In-depth analysis and reporting
Data Latency Near real-time Typically batch-loaded (daily/weekly)
Data Freshness Current, transient data Historical, aggregated data
Update Frequency Frequently (real-time or near real-time) Infrequently (during ETL processes)
Schema Design Typically normalized Star, snowflake, or galaxy schema
Primary Users Business operations, front-line applications Business analysts, data scientists
Query Complexity Simple, operational queries Complex, ad-hoc analytical queries
Data Lifespan Short-term, constantly updated Long-term, provides historical view
Integration Process Minimal transformation, quick integration Extensive ETL processes, deeper integration
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment