0

3.1kviews

Write difference between OLTP and OLAP.

written 8.7 years ago by aartisahitya • 160

modified 2.8 years ago by DevarenjiniP • 3.2k

data warehouse and mining

ADD COMMENT FOLLOW SHARE EDIT

1 Answer

0

32views

written 8.7 years ago by aartisahitya • 160

OLTP	OLAP
Hold current data.	Hold historical data.
Stores detailed data.	Stores detailed,lightly and highly summarized data.
Data is dynamic.	Data is largely static.
Repetitive processing.	Ad-hoc, unstructured and heuristic processing.
High level of transaction throughput.	Medium to low level of transaction throughput.
Predictable pattern usage.	Unpredictable pattern usage.
Transaction driven.	Analysis driven.
Application oriented.	Subject oriented.
Supports day-to-day decision.	Supports strategic decision.
Serves large number of clerical/ operating users.	Serves relatively low number of managerial users.
DB size 100 MB to GB	DB size 100 GB to TB
DB design is ER based and application-oriented.	DB design is star/snowflake,and subject-oriented.
Priority is high performance and,high availability	Priority is high flexibility and end-user autonomy.

BASIC OPERATIONS FOR OLAP:

• Drill down
  • Navigate to higher levels of details.
• Roll up
  • Navigate to lower levels of details.
• Slice
  • Cut through the cube so that users can focus on some specific perspectives.
• Dice
  • Get one cell from the cube.
• Pivot
  • Rotate the cube.

ADD COMMENT SHARE EDIT