OLAP stands for On-Line Analytical Processing. It is used for analysis of database information from multiple database systems at one time such as sales analysis and forecasting, market research, budgeting and etc. Data Warehouse is the example of OLAP system.
OLTP stands for On-Line Transactional processing. It is used for maintaining the online transaction and record integrity in multiple access environments. OLTP is a system that manages very large number of short online transactions for example, ATM.
| Sr. No. | Key | OLAP | OLTP |
|---|---|---|---|
| 1 | Basic | It is used for data analysis | It is used to manage very large number of online short transactions |
| 2 | Database Type | It uses data warehouse | It uses traditional DBMS |
| 3 | Data Modification | It manages all insert, update and delete transaction | It is mainly used for data reading |
| 4 | Response time | Processing is little slow | In Milliseconds |
| 5 | Normalization | Tables in OLAP database are not normalized. | Tables in OLTP database are normalized. |
No comments:
Post a Comment
It’s all about friendly conversation here at small review :) I’d love to be hear your thoughts!
Be sure to check back again because I do make every effort to reply to your comments here.