Difference Between Similar Terms and Objects

Difference Between OLAP and OLTP

OLAP vs OLTP

OLAP is Online Analytical Processing and OLTP is Online Transaction Processing. While OLAP is customer-oriented, OLTP is market oriented. The Online Analytical Processing is used for data analysis by clients, IT professionals and clerks, whereas the Online Transaction Processing is used for analysis of the data by executives and managers.

OLTP mainly manages current data. On the other hand, OLAP manages historical data and stores information for helping in the decision-making process. While Online Transaction Processing is based on the model of entity relationship and an application-oriented database, the Online Analytical Processing is based on the model of fact constellation and a subject-oriented database.

OLTP is characterized by short, online transactions like update, delete, and insert. The OLAP is mainly characterized by a low volume of transactions.

OLTP is operational data. They are considered the original source of data. OLAP is consolidation data and comes from OLTP databases. One of the main purposes of OLTP is to control/run fundamental business tasks. And the purpose of OLAP is to help with decision support, planning, and problem solving. The data of OLTP reveals an ongoing business process. On the contrary, OLAP reveals the multi-dimensional view of all types of business activities.

When talking about the processing speed, the OLTP is considered to be fast whereas OLAP may take many hours and depends on the data involved. Now considering the space requirements, the OLTP needs only a small space if the historical data are archived. But OLAP requires a larger space because of the historical data and aggregation structures.

Summary:

1. OLAP is Online Analytical Processing and OLTP is Online Transaction Processing.
2. The Online Analytical processing is used for data analysis by clients, IT professionals, and clerks whereas the Online Transaction Processing is used for analysis of the data by executives and managers.

3. One of the main purposes of OLTP is to control/run fundamental business tasks. The purpose of OLAP is to help with decision support, planning, and problem solving.

4. The data of OLTP reveals an ongoing business process. On the contrary, OLAP reveals the multi-dimensional view of all types of business activities.

5. While Online Transaction Processing is based on the model of Entity Relationship and an application-oriented data base, the Online Analytical processing is based on the model of fact constellation and subject-oriented database.

6. The OLTP needs only a small space if the historical data are archived. But OLAP requires a larger space because of the historical data and aggregation structures.


Search DifferenceBetween.net :

Custom Search



1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading ... Loading ...


Email This Post Email This Post : If you like this article or our site. Please spread the word. Share it with your friends/family.



See more about :

Leave a Response

Please note: comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.

Articles on DifferenceBetween.net are general information, and are not intended to substitute for professional advice. The information is "AS IS", "WITH ALL FAULTS". User assumes all risk of use, damage, or injury. You agree that we have no liability for any damages.


Protected by Copyscape Plagiarism Finder