Sales Management Customer Relationship Human Resources Business Performance BI & Data Quality IT Tools & Vendors

  Register
Establishing 'Making it Happen' as a 'Formal & Predictable' Discipline
Ask a question Listing Page

Operational Data Store vs Data Warehouse

What is the difference between an Operational Data Store and Data Warehouse?
This page of 'Ask a question' is linked to:  Data Warehousing, BI business intelligence end-to-end view, Data Analysis/OLAP, BI platform Tools Evaluation,

The definition of an operational data store is a data store, which is used for operational purposes. This data store could be getting updated online real time basis or could be done on offline basis (say once a day refresh). Operational data store is one among many applications of a Data Warehouse. We have mentioned in another question, that data warehouse can have multiple applications. A Data Warehouse can also act like an operational data store, if the dimensional model etc. is structured accordingly. It is also possible to have an operational data store separate from a data warehouse. For example, if data warehouse is also acting like an operational data store, it will need include some additional data (like detailed customer address), which otherwise, it might not have included.

Another question one may ask is that will the approach of creating an ODS and Data Warehouse be different?

The answer to this will be- Yes. If a data warehouse is going to be used as an operational data store as well, or you are creating an ODS separate from a data warehouse, here will be the differences:

  • The non-analytics data will be more extensively included. For example you would like to have the complete address of the customer (instead of pin code, state or city only).
  • The data modeling will be more relational. This is because you are running single record, OLTP kind of queries and not the kind of 'mass calculation and aggregation' queries.

Relevant Links to this page
Expert's Answers → Entry criteria to start DW project → Expert's Answers → Online data feed to Data Warehouse. → Expert's Answers → Data Warehouse- Big Bang or Incremental → Expert's Answers → Dimensional model vs Relational model → Expert's Answers → Interview sequence for DW business requirements → Expert's Answers → Pre-configured reports- Do they work? → Expert's Answers → Business Intelligence vs Business Performance → Expert's Answers → Integrating Data Marts to Data Warehouse → Expert's Answers → EAI vs Data Warehouse → Expert's Answers → Operational Data Store vs Data Warehouse → Expert's Answers → Source of Enterprise Reporting → Expert's Answers → Data Warehouse Source System approach → Expert's Answers → ROI of Data Warehouse → Expert's Answers → Partial Customer Information → Expert's Answers → Source system re-writing in parallel to Data Warehouse → Expert's Answers → Alignment between Source Systems and Data Warehouse → Expert's Answers → Maximizing usage of Data Warehouse → Expert's Answers → Simultaneous launch of source system and Data Warehouse → Expert's Answers → Security Matrix of a Data Warehouse → Expert's Answers → ETL phase taking too long → Expert's Answers → Should Data Warehouse wait for Meta-Data initiative → Expert's Answers → Mismatch in Source vs Data Warehouse reporting. → Expert's Answers → Data Warehouse vs Data Mart vs Data Mining → 
Relevant links to this page
Entry criteria to start DW project
Online data feed to Data Warehouse.
Data Warehouse- Big Bang or Incremental
Dimensional model vs Relational model
Interview sequence for DW business requirements
Pre-configured reports- Do they work?
Business Intelligence vs Business Performance
Integrating Data Marts to Data Warehouse
EAI vs Data Warehouse
Operational Data Store vs Data Warehouse
Source of Enterprise Reporting
Data Warehouse Source System approach
ROI of Data Warehouse
Partial Customer Information
Source system re-writing in parallel to Data Warehouse
Alignment between Source Systems and Data Warehouse
Maximizing usage of Data Warehouse
Simultaneous launch of source system and Data Warehouse
Security Matrix of a Data Warehouse
ETL phase taking too long
Should Data Warehouse wait for Meta-Data initiative
Mismatch in Source vs Data Warehouse reporting.
Data Warehouse vs Data Mart vs Data Mining
Additional Channels
Principles & Rules
Free Templates
Key Performance Indicators

Most Popular Zones with list of pages crossing 25000 hits  →→→ 
Maximising Sales Performance
Sales Channel Management System
Enhancing Sales Channel productivity
Sales productivity
Sales Compensation Data Management
Sales Synergies
  Customer Relationship Management
Customer Value and Profitability- BI
Customer Segmentation Actions
Customer Service and Support Overview
What is Customer Segmentation?
Customer Satisfaction and Retention- Overview
  Human Resources & Leadership
Competencies Definitions
Empower Front-line Employees
Fitting leadership dimension in employee performance
Lead Change
Deliver Results
Business Performance & Planning
Stakeholder test for Scorecard
External Info Assessment Report
Strategic Vision and Mission
Individual goal Sheet
strategy blueprint Rationalize Align and Publish
  Business Intelligence & Data Quality
Data Quality Organization Roles
OLAP Data Allocation Analysis
Avoid Pure MOLAP
Do not separate parent and child data
Dimensional Modeling vs. Relational Modeling
  IT Vendors & Tools Management
Collaboration and Administration Support
Vendor Commercial Evaluation- Billing structure
Vendor Delivery Support Model
OLAP Server write backs
Data Searching and Matching