When we go though the data warehouse and operational database we can identify number of differences. We can define those differences as follows,
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.
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
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
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.