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 Leads Allocation and Distribution
Sales force Training and Development
Sales Behavior
Sales Compensation Data Management
Sales Channel Data Management
  Customer Relationship Management
Customer Value and Profitability Tips and Actions
Customer Satisfaction & Retention- Data Management
Customer Service and Support Overview
Supply Chain for Customer Service and Support
What is Customer Segmentation?
  Human Resources & Leadership
Business and Financial Acumen
Fostering Innovation
Strategic Business Plan
Roles and Level based Competency Segregation
People become the way you treat them
Business Performance & Planning
strategy blueprint Rationalize Align and Publish
For important KPIs- Install first & Fix later
Stakeholder test for Scorecard
External Info Assessment Report
A KPI should be simple -but it depends
  Business Intelligence & Data Quality
Data Mart + Fact Table Grain Matrix
Do not separate parent and child data
Data Management Standards for Data Entities
Facts and Derived Facts Table
BI Competency Centre- Organization Model
  IT Vendors & Tools Management
Vendor Commercial Evaluation post Implementation
Commercial & Contractual Matrix
Vendor Company structure Evaluation
Business Intelligence Vendor Evaluation
Data Quality through Data Integration Tools