About Lesson
Database types are broadly classified into two.
They are
- OLAP(Online Transaction Processing system)
- OLTP(Online Analytical processing system)
The online Transaction Processing system
OLTP is an Online Transaction Processing system. The main focus of the OLTP system is to record the update, Insertion, and Deletion while transaction. The OLTP queries are simpler and short and hence require less time in processing, and also requires less space.
Online Analytical processing system
OLAP is an Online Analytical Processing system. OLAP database stores historical data that has been inputted by OLTP. It allows a user to view different summaries of multi-dimensional data. Using OLAP, you can extract information from a large database and analyze it for decision making.
Difference between OLTP and OLAP
| BASIS FOR COMPARISON | OLTP | OLAP |
| Basic | It is an online transactional system and manages database modification. | It is an online data retrieving and data analysis system. |
| Focus | Insert, Update, Delete information from the database. | Extract data for analyzing that helps in decision making. |
| Data | OLTP and its transactions are the original sources of data. | Different OLTPs database becomes the source of data for OLAP. |
| Transaction | OLTP has short transactions. | OLAP has long transactions. |
| Time | The processing time of a transaction is comparatively less in OLTP. | The processing time of a transaction is comparatively more in OLAP. |
| Queries | Simpler queries. | Complex queries. |
| Normalization | The tables in the OLTP database are normalized (3NF). | The tables in the OLAP database are not normalized. |
| Integrity | OLTP database must maintain data integrity constraints. | OLAP database does not get frequently modified. Hence, data integrity is not affected |