Software Development  >  SQL for Beginners  >  OLTP vs OLAP

OLTP vs OLAP Notes | Study SQL for Beginners - Software Development

Document Description: OLTP vs OLAP for Software Development 2022 is part of SQL for Beginners preparation. The notes and questions for OLTP vs OLAP have been prepared according to the Software Development exam syllabus. Information about OLTP vs OLAP covers topics like and OLTP vs OLAP Example, for Software Development 2022 Exam. Find important definitions, questions, notes, meanings, examples, exercises and tests below for OLTP vs OLAP.

Introduction of OLTP vs OLAP in English is available as part of our SQL for Beginners for Software Development & OLTP vs OLAP in Hindi for SQL for Beginners course. Download more important topics related with notes, lectures and mock test series for Software Development Exam by signing up for free. Software Development: OLTP vs OLAP Notes | Study SQL for Beginners - Software Development
1 Crore+ students have signed up on EduRev. Have you?

Online Transaction Processing vs Online Analytical Processing

 Online Transaction Processing System:OLTP

OLTP System deals with operational data. Operational data are those data  involved in the operation of a particular system.

Example: In a banking System, you withdraw amount through an ATM. Then account Number,ATM PIN Number,Amount  you are withdrawing, Balance amount in account etc are operational data elements.

  • Operational Data

  • Operational data are usually of local relevance

  • Frequent Updates

  • Normalized Tables

  • Point Query

In an OLTP system data are frequently updated  and queried. To prevent data redundancy and to prevent update anomalies the database tables are normalized.Set of tables that are normalized are fragmented.Normalization makes the write operation in the database tables more efficient.Operational data are usually of local relevance.It involves Queries accessing individual tuple(individual record).These type of queries are termed as point queries.

Examples for OLTP Queries:

  • What is the Salary of Mr.John?

  • What is the address and email id of the person who is the head of maths department?

Online Analytical Processing:OLAP

OLAP deals with Historical Data or Archival Data. Historical data are those data that are archived over a long period of time.

Example: If we collect last 10 years data about flight reservation, The data can give us many meaningful information such as the trends in reservation. This may give useful information like peak time of travel, what kinds of people are traveling in various classes (Economy/Business)etc.

  • Historical Data or Archival Data

  • Infrequent updates

  • Analytical queries require huge number of aggregations

  • Integrated data set with a global relevance

Updates are very rare here.Analytical queries requires huge number of aggregations. In analytical queries the performance issue is mainly in query response time.Query need to access large amount of data and require huge number of aggregation.

OLAP Queries have significant importance in strategic decision making. This helps the top level management in decision making.

Examples for OLAP Queries

  • How is the profit changing over the years across different regions ?

Is it financially viable continue the production unit at location X?

The document OLTP vs OLAP Notes | Study SQL for Beginners - Software Development is a part of the Software Development Course SQL for Beginners.
All you need of Software Development at this link: Software Development
1 videos|3 docs|1 tests
Download as PDF

Download free EduRev App

Track your progress, build streaks, highlight & save important lessons and more!

Related Searches

shortcuts and tricks

,

Extra Questions

,

Sample Paper

,

MCQs

,

mock tests for examination

,

Semester Notes

,

Free

,

Important questions

,

Viva Questions

,

past year papers

,

pdf

,

Previous Year Questions with Solutions

,

study material

,

practice quizzes

,

Objective type Questions

,

OLTP vs OLAP Notes | Study SQL for Beginners - Software Development

,

Exam

,

OLTP vs OLAP Notes | Study SQL for Beginners - Software Development

,

OLTP vs OLAP Notes | Study SQL for Beginners - Software Development

,

video lectures

,

ppt

,

Summary

;