Describe how relational databases are used in OLAP analysis

Describe how relational databases are used in OLAP analysis, data mining, and E-commerce website applications.

Solution

Describe how relational databases are used in OLAP analysis, data mining, and E-commerce website applications.

Answer :-

Online analytical processing (OLAP) is one of several ways that relational databases can be utilized toprovide in-depth information.

In this approach, data is stored in a relational database that is accessedby an OLAP application, also referred to as a data warehouse, which presents that data in a multi-dimensional format for the user (Ponniah, 2007).

The OLAP application essentially works as a go-between, allowing the user to request complex queries from the traditional relational-style database.

Data mining is a term applied to a group of techniques developed to extrapolate detailed informationfrom large data warehouses. Statistical analysis is a heavy inFuence on data mining (Colorado StateUniversity-Global Campus, 2010).Data mining techniques are applied to analyze the data in an OLAP.