BUSINESS ADMINISTRATION
MANAGEMENT INFORMATION SYSTEM
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
SQL
|
|
|
Data mining
|
|
|
OLAP
|
|
|
Databases
|
Detailed explanation-1: -According to a popular opinion from OLAP Council, a data warehouse is usually based on relational technology, while OLAP uses a multidimensional view of aggregate data to provide quick access to strategic information for further analysis.
Detailed explanation-2: -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-3: -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-4: -MOLAP Implementes operation in multidimensional data.
Detailed explanation-5: -Multidimensional OLAP (MOLAP) uses array-based multidimensional storage engines for multidimensional views of data.