Please support us

Monday, July 23, 2012

Difference between data warehouse and an operational database

When we go though the data warehouse and operational database we can identify number of differences. We can define those differences as follows,

Operational database

Data warehouse

Stored with a functional or process orientation

Stored with a subject orientation

In operational database data are stored with a functional or process orientation. But when we move to the data warehouse we can identify that data are stored with subject orientation that facilitates multiple views for data and decision making.

Operational database

Data warehouse

Different representation or meanings

Unified view of all data elements with a common definition and representation

Data warehouse concepts it unified view of all data elements with a common definition and representation.In operational database similar data are allowed different representations

Operational database

Data warehouse

Represent current transactions

Historic in natural

Data are historic in nature in data warehouse. Here a dimension is added to facilitate data analysis and time corporations. But if we turn our eye to the operational database we can recognize that in operational database model data represent in current transactions. So there is a big difference in this perspective

Operational database

Data warehouse

Update and delete

Add only periodically from operational system

In datawarehouse data are changed. But here data only added periodical from operational systems. But when we turn our eyes to the operational database perspective we can recongniz that data update and deleted are really common in operational database.

10 comments:

  1. not enough...........

    ReplyDelete
  2. Not bad... this author recognized the importance of the time component. A data warehouse should support comparison of like data across different time intervals, whereas an operational database is recording data as of "now."

    ReplyDelete
  3. i found this very informative thanks a lot for
    sharing

    ReplyDelete
  4. very nice way of presentation and informative too...thanks author.

    ReplyDelete
  5. An Oracle White Paper. May 2011. Evolving the Data Warehouse: The Next Generation for Financial Services. survival-warehouse.com reviews

    ReplyDelete
  6. An easy way to learn about the differences between data warehouse and an operational database. This is short but informative about the warehouse in which it will help us to learn more about this thing especially in data warehouse and in operational database. Now I know the differences of the two. Thanks for this tutorial you provided me.

    ReplyDelete
  7. Operational database Data ware house
    These are designed to support high volume transaction processing with mimal back ending reporting. Designed to support analytical processing (OLAP) and used for report generation.
    Process oriented and process driven. i.e. billing, registration etc. Subject oriented.
    Ex- revenue is subject oriented such a way that contain data from operational system that contain financial data.
    Concerned with current data Historical form of data.
    Updates required regularly Read only data
    Fast insertion of data Fast retrieval of data
    These are generally application specific.(billig data is not integrated with payroll data) Data ware house system are generally integrated at a layer above application layer to avoid data redundancy

    ReplyDelete
  8. Hope it is enough to get clear with the differences between them.....

    ReplyDelete

We need your comments