| Basis |
OLTP |
OLAP |
| Data Source |
Operational or transactional data sources. These are the original source of data for any kind of data processing. |
It consists of consolidated data. OLAP data comes from the various OLAP data sources. |
| Purpose of data |
To record and manage fundament of business operations. |
To help with planning problem solving and decision support. |
| Type of data |
It consists of relational data that reveals a snapshot of ongoing business processes. |
It consists of multi-dimensional view of various kinds of business activities . |
| Insert and update |
Short and frequent insert and updates initiated by end user. |
Periodic long running batch jobs refresh the data only data addition is allowed and updation should be kept minimum. |
| Queries |
Simple and standardized queries which are of routine nature. They return relatively few records |
Complex, ad hoc and random queries involving aggregation returning large number of record. |
No comments