0
2.9kviews
Write difference between OLTP and OLAP.
1 Answer
0
29views
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.
Please log in to add an answer.