top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Difference between OLAP & OLTP?

+5 votes
372 views

Can anyone please explain difference between OLAP & OLTP in simple terms with an example?

posted Nov 22, 2013 by Majula Joshi

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+3 votes

OLTP is for transactional systems, such as you would find on a baseball coach's "play sheet". It shows every pitch, swing, etc. because the coach needs to look at that level of detail... They need to know which players bat well agains left handed pitchers and whne an opposing left fielder frequently fails to catch balls hit by right handed batters.

OLAP is for analytical systems, such as you'd see on the late night news. It shows the final scores of the games and possibly the team position in the league. At this level of detail, people are interested in which team won the game, and who is likely to play in the World Series.

The OLTP and OLAP systems track different information about the same system. The informaiton is at a different level of detail, and the OLAP system is derived from data in the OLTP system, but they are truly different systems tracking different information instead of just different levels of abstraction for a single thing.

answer Nov 23, 2013 by Neeraj Pandey
Similar Questions
+3 votes

As known, Database Design & Implementation is a skill rather than a tool; It is a transferable skill that be applied in any DBMS. Many online tutorials out there tend to jump to the tool right away without touching the necessary aspects of databases

  1. Are Data warehousing and Business Intelligence tools or transferable skills?

  2. What is the best DW/BI tool for beginners?

...