Concepts of OLTP, OLAP and OLMP

 

Concepts of OLTP, OLAP and OLMP

• OLTP :  (Online Transaction Processing)

--> It covers mostly recent operations results, or mostly day to day records.

       Ex : purchasing, inventory, banking, payroll transactions etc.

--> It is customer-oriented and used for recent query processing.
--> Usually adopts an entity-relationship (ER) data model and application oriented database design.

--> View of OLTP is mostly detailed or flat file relations.

--> Also very important for daily sales analysis in industries.

--> Its number of access is in tens, and Number of users may be thousands.

• OLAP : (Online Analytic Processing)

--> It generally focuses on historical data.
--> Mostly used for long term operations.
--> Can provide summarized or multidimensional view.
--> Number of users in hundreds because it does not focuses on particular operation but it focus on bulk      
      of many results.
--> It is highly flexible and end-user autonomy.
--> Mostly read-only operations because most of the data warehouses store historical data.

• Difference between OLTP and OLAP

        Operations of OLAP :

(1) Roll-Up  :

- It performs aggregation by climbing up a concept hierarchy for a dimension or by dimension     reduction.
- performs by removing dimension
   Ex : street < city < province_or_state < country
- Here when roll-up is performed one or more dimensions are removed from above hierarchy.
- for example rather than grouping the data by city, the resulting cube can groups data by country.


(2) Drill-Down : 

- Drilling Down is the reverse of Roll-up.
- It navigates from less detailed data to more detailed data.
- Because it adds more detail to given data, It can be also performed by adding new dimension to a cube.


(3) Slice and Dice :

- Slice  performs a selection on one dimension of the given cube, resulting in a sub cube.
- Dice operation defines a sub cube by performing a selection on two or more dimensions.

(4) Pivot (Rotate) :

- It is a visualization operations that rotates data axes in view in order to provide an alternative presentation of the data.