DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Online analytical processor
|
|
|
Offline analytical processing
|
|
|
Online analytical processing
|
|
|
Online analysis processing
|
Detailed explanation-1: -Online analytical processing (OLAP) is a technology that organizes large business databases and supports complex analysis. It can be used to perform complex analytical queries without negatively affecting transactional systems.
Detailed explanation-2: -OLAP, or online analytical processing, is a method in computing that solves complex analytical programs. This business intelligence tool processes large amounts of data from a data mart, data warehouse or other data storage unit. OLAP uses cubes to display multiple categories of data.
Detailed explanation-3: -OLAP stands for Online Analytical Processing Server. It is a software technology that allows users to analyze information from multiple database systems at the same time. It is based on multidimensional data model and allows the user to query on multi-dimensional data (eg. Delhi-> 2018-> Sales data).
Detailed explanation-4: -An Example of OLAP: The combination of analyzed data from various databases into a meaningful report. OLAP is used to find the relevant information when looking at a database. An Example of OLAP: The transformation of raw data so it can be stored in the data warehouse.