OLAP | OLTP |
---|---|
Designed for read-only analysis of historical data | Designed for real-time inserting, updating, and deleting of current data |
Stores the data in dimensions | Stores data in relational tables |
Built to be queried | Built for transaction processing |
Denormalized format | Normalized format |
Heavily indexed | Limited indexing |
False. OLAP systems often contain summaries of orders, but they seldom contain individual orders. The best place to query order status is the OLTP system that originated the order.
Attribute | OLAP | OLTP |
---|---|---|
Consolidated | X | |
Consistent | X | X |
Read-write | X | |
Subject oriented | X | |
Historical | X | |
Read-only | X | |
Detailed | X | |
Granular | X |
It is difficult to design analytical reports, indexes reduce performance, and it is a complex data model.