Data Mining vs Online Analytical Processing

Data Mining vs Online Analytical Processing

Hey Sarah,

• Data mining is a process where we extract the data from the data warehouse. Data warehouse is a repository of multiple heterogeneous data. It is designed for any specific theme like, customer, product, Employee. Data mining is important for making decisions to the higher authorities, as it provides better facts and statistics to them.
• There are two types of data mining:

1.OLAP(Online Analytical Processing)

2.OLTP(Online Transaction Processing)

So, OLAP is a part of data mining.

• An OLAP cube is a data structure that allows fast analysis of data. It can also manipulate and analyze data from different perspectives.
• For OLAP processing, a cube is generated and then we can view the data according to our need.

For e.g

                                    Computer Dept         IT Dept            Mechanical Dept

Average Salary                  90000                 800000                    50000

Employees                           90                        10                         88

This fields can be changed according to our need.

• According to the types of the data the OLAP processing can be done in three different manners that are:

1. ROLAP (Relational OLAP)
2. MOLAP (Multi dimensional OLAP)
3. HOLAP (Hybrid OLAP)

Hope it helped you.