Difference between OLTP & OLAP.

76views

written 7.3 years ago by

OLTP	OLAP
It works on operational data & provides operational information.	It works on data collected from operational system & provides straight information.
Operation information provided by this system is used to run day to day business operation.	Strategic information provided by this system is used to analyse how well business is running & what to do to improve business.
It uses traditional DBMS.	It uses data warehousing.
It’s also called as OLTP assuming that operation system.	It is also called as OLAP assuming that information system.
It performs normal operation, insert, delete, update etc.	It performs complex analysis on collected data.
The size of the database is comparatively small(100MB-1GB).	The size of the data base is more compared to OLTP(100GB-1TB)
It contains current data.	It contains current as well as historic data.
It has more no. of users.	It has less no. of users.
Access frequency of data is high.	Access frequency of data is low.
Type of use is predictive and repetitive.	Type of use is ad-hoc.
It may update or delete data.	It rarely updates, never deletes data.
Response time is in milli-second.	Response time in is terms of seconds to minutes.
Types of users are clerk, DBA & Data Base professionals.	Types of users are knowledge workers, managers and CEO.
DB design is application oriented.	DB design is subject oriented.
DB design is subject oriented.	It provides query throughput.
At a time, limited no. of records can be retrieved.	At a time, millions of records can be retrieved.
It is used to control and run fundamental tasks.	It is used to help in planning, problem solving decision support and reporting.
ER model is used.	Dimensional modelling is used.
Allows read/write operations.	Only read and rarely write.
Provides high performance.	Provides high flexibility.

ADD COMMENT EDIT