OLAP

tags :

similar

OLTP

Acronym #

OnLine Analytical Processing (OLAP) consists of a type of software tool that is used for data analysis for business decisions. OLAP provides an environment to get insights from the database retrieved from multiple database systems at one time.

Examples #

Any type of Data Warehouse System is an OLAP system. The uses of the OLAP System are described below.

Spotify analyzed songs by users to come up with a personalized homepage of their songs and playlist. Netflix movie recommendation system.

Benefits of OLAP Services #

OLAP services help in keeping consistency and calculation. We can store planning, analysis, and budgeting for business analytics within one platform. OLAP services help in handling large volumes of data, which helps in enterprise-level business applications. OLAP services help in applying security restrictions for data protection. OLAP services provide a multidimensional view of data, which helps in applying operations on data in various ways.

Drawbacks of OLAP Services #

OLAP Services requires professionals to handle the data because of its complex modeling procedure. OLAP services are expensive to implement and maintain in cases when datasets are large. We can perform an analysis of data only after extraction and transformation of data in the case of OLAP which delays the system. OLAP services are not efficient for decision-making, as it is updated on a periodic basis.

OCR of Images #

2023-12-05_15-37-46_screenshot.png #

Business Branchl Branch2 Branch3 Web-Page Web-Page Web-Page Branch-Level Databases are OLTP Databases DB DB DB This is the OLAP Database to store the records of above databases for analysis Data ware House purpose OLAP