|1 Crore+ students have signed up on EduRev. Have you?|
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 are usually of local relevance
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
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?