OLAP Vs OLTP

Introduction:

The constant growth of Data Analysis and Business Intelligence Applications, understanding OLAP and OLTP having the important Place.

The design of Data Warehouse and Online Analytical Processing (OLAP) cubes is basically different than OnLine Transactional Processing (OLTP).

OLTP:

Source of Data: OLTP is original Source of data that maintains the Day by Day transactions and processes for every Business.

Purpose of Data: To run and control the fundamental business task and record all the events inside.

OLTP Reveals the copy of the ongoing Business processes.

Insertion and Updation is very fast in OLTP and this operation is initiated by End Users. All the OLTP is Normalized one and Doesn't having any duplicate records in any situation.

In OLTP, the Query Processing is normally standardized and simple query that gives the result of few records.

The processing speed is very speed and the size of the OLTP Size (MB to GB) is very small compare with OLTP if historical data is archived.

Database design of OLTP is highly Normalized with many tables.

Backup & Recovery of OLTP:

Operation data is very critical to run the business and data loss is likely to entail and legal liablity.

OLAP:

The source of data of OLAP is OLTP, Consolidated from various OLTP Sources.

The Main aim of this data is to help reporting, Decision support, Data analyzing and for problem Solving.

This data reveals the Multi-Dimensional views of various kinds of business Activities.

Periodically Its long process to insert the data and update the data But retrieving the data from OLAP is easy.

Typicall the query processing in OLAP is long and tedious and often with complex queries involving aggregations.

The processing speed in OLTP depends upon the size of the data involved, that may batch processes and complex queries may take hours to one and query speed can be improved by creating Views ans Indexes.

The size of OLAP is very Large ( GB to TB) and It contains the consolidated data of OLTP with more aggregation structures and Historical data.

The database design of OLAP is in most cases de-normalized with the fewer tables and using Star or Snowflake schema.