OLTP |
OLAP |
| On Line Transaction processing |
On Line Analytical processing |
| Continuously updates data |
Read Only Data |
| Tables are in normalized form |
Partially Normalized / Denormalized Tables |
| Single record access |
Multiple records for analysis purpose |
| Holds current data |
Holds current and historical data |
| Records are maintained using Primary key feild |
Records are baased on surogate keyfield |
| Delete the table or record |
Cannot delete the records |
| Complex data model |
Simplified data model |
