Skip to main content

OLTP vs OLAP

OLTP (Online transaction processing system) is a traditional term used for transaction system used to carry out day to day business functions such as ERP, CRM etc. OLTP system solved a critical business problem of automating daily business functions and running real time reports and analysis. But these systems were not designed for analysis and queries. Frustration started to build in Business management as OLTP systems could not provide the analysis on the data. Resource heavy management analytical queries started to affect performance of OLTP systems and users of OLTP system also got frustrated.


To answer these issues, OLAP (Online Analytical Processing) system was introduced. OLAPs were designed to provide analysis and queries efficiently as compared to real time transaction processing in OLTP. As heavy management queries were transferred to OLA
P, performance of OLTP system was not affected. OLAP uses multidimensional model, with the primary purpose of running complex analytical and ad-hoc queries.

  • Source of Data - OLAP gathers data from multiple systems (including OLTP systems). OLTP records data. OLAP gets data periodically from backend systems (such as OLTP). OLTP is updated regularly as transactions are recorded.

  • Purpose – Purpose of OLTP is to carry out day to day business functions. Purpose of OLAP is to support decision making and provide answers to business and management queries.

  • Reporting – OLTP reports tend to run on low volume of data and returns few records. OLAP queries typically run on huge volume of data.

  • Resource requirements – OLAP requires huge space and CPU resources to store volume of data and run complex queries. OLTP requires relatively less system resources.

  • Execution Speed – OLTP runs faster than OLAP as queries tends to be simple. However, for similar queries OLAP runs faster as OLAPs are designed to run complex queries.

As we can see, OLTP and OLAP target completely different needs.

Comments

  1. Very good explanation about this topic.

    ReplyDelete
  2. It is really a nice post and sufficing the requirements.

    ReplyDelete
  3. It would be right time for ERP vendors to admit that ERP systems simply can nor overcome production planning tasks, like production chain rescheduling over company boundaries. OLTP type of architecture does not simply allow not-in-real time planning and scheduling. These task are carried out using APS (Advanced Planning & Scheduling) software. But: poor end-users do not know this as the ERP vendors try to keep thirt party suppliers jealously out. There is a new term for this called "harmonization".

    ReplyDelete

Post a Comment

Leave a reply

Popular posts from this blog

Enterprise Digital Transformation: Top 10 Posts from Month Ending 7-Jan-2018

Is Bitcoin revolution real or fad? What did 2017 brought to India in terms of Bitcoin and Blockchain adoption? How did Air Canada analyze and revamped customer service? What is growth rate of digital transformation spending? What can companies learn from GE’s digital transformation journey? – We look at answers to these questions and much more in the monthly coverage of enterprise digital transformation posts.

26 Proven Work at Home Business Ideas You Can Run Part Time

If you are looking for work at home business ideas, then this list can help you. All of these can be done as part-time business, so you don’t have to leave your job until you are confident of making full time income from your Work at home business.

Enterprise Digital Transformation: Top 10 Posts from Month Ending 12-Nov-2017

What are some of the key trends to watch out for in automotive industry? Will fake news increase or decrease in future? Can AI replace humans in running governments? Can Disney disrupt itself and compete with Netflix and Amazon? – We look at answers to these questions and much more in this week’s coverage of digital transformation posts.