Online Analytical Processing (OLAP) –
Online Analytical Processing consists of a type of software tools that are used for data analysis for business decisions. OLAP provides an environment to get insights from the database retrieved from multiple database systems at one time.
Examples – Any type of Data warehouse system is an OLAP system. Uses of OLAP are as follows:
- Spottily analyzed songs by users to come up with the personalized homepage of their songs and playlist.
- Netflix movie recommendation system.
Online transaction processing (OLTP) –
Online transaction processing provides transaction-oriented applications in a 3-tier architecture. OLTP administers day to day transaction of an organization.
Examples – Uses of OLTP are as follows:
- ATM center is an OLTP application.
- OLTP handles the ACID properties during data transaction via the application.
- It’s also used for Online banking, Online airline ticket booking, sending a text message, add a book to the shopping cart.
Comparisons of OLAP vs OLTP –
|OLAP (Online analytical processing)||OLTP (Online transaction processing)|
|Consists of historical data from various Databases.||Consists only operational current data.|
|It is subject oriented. Used for Data Mining, Analytics, Decision making,etc.||It is application oriented. Used for business tasks.|
|The data is used in planning, problem solving and decision making.||The data is used to perform day to day fundamental operations.|
|It reveals a snapshot of present business tasks.||It provides a multi-dimensional view of different business tasks.|
|Large amount of data is stored typically in TB, PB||The size of the data is relatively small as the historical data is archived. For ex MB, GB|
|Relatively slow as the amount of data involved is large. Queries may take hours.||Very Fast as the queries operate on 5% of the data.|
|It only need backup from time to time as compared to OLTP.||Backup and recovery process is maintained religiously|
|This data is generally managed by CEO, MD, GM.||This data is managed by clerks, managers.|
|Only read and rarely write operation.||Both read and write operations.|
Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.
- OLAP Operations in DBMS
- Types of OLAP Systems in DBMS
- Online Transaction Processing (OLTP) and Online Analytic Processing (OLAP)
- On Line Transaction Processing (OLTP) System in DBMS
- Difference between Data Mining and OLAP
- Difference between Data Warehousing and Online transaction processing (OLTP)
- OLAP Guidelines (Codd's Rule)
- Difference between 2NF and 3NF in DBMS
- Difference between DDL and DML in DBMS
- Difference between 1NF and 2NF in DBMS
- Difference between BCNF and 4NF in DBMS
- Difference between 3NF and BCNF in DBMS
- Difference between Database and DBMS
- Difference between RDBMS and DBMS
- Difference between Generalization and Specialization in DBMS
- Difference between File System and DBMS
- Difference between Cursor and Trigger in DBMS
- Difference between Trigger and Procedure in DBMS
- Difference between Classification and Clustering in DBMS
- Difference between Assertions and Triggers in DBMS
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.