DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Cognos
|
|
|
Infor
|
|
|
Oracle corporation
|
|
|
All of the above
|
Detailed explanation-1: -Vendors for OLAP systems include: SAP Business Objects, Oracle, IBM Cognos, Infor, MicroStrategy, Microsoft, SAS, Pentaho, & Jaspersoft.
Detailed explanation-2: -OLAP products include IBM Cognos, Oracle OLAP and Oracle Essbase. OLAP features are also included in tools such as Microsoft Excel and Microsoft SQL Server’s Analysis Services). OLAP products are typically designed for multiple-user environments, with the cost of the software based on the number of users.
Detailed explanation-3: -Types of OLAP – ROLAP, MOLAP, HOLAP There are three different types of OLAP based on how data is stored in the database. ROLAP : stands for Relational Online Analytical Processing. It stores data in the form of rows and columns. ROLAP does not pre-compute data; it can be accessed through SQL queries on demand.
Detailed explanation-4: -7. Which of the following OLAP systems do not exist? Explanation: HOLAP means Hybrid OLAP, MOLAP means multidimensional OLAP, ROLAP means relational OLAP. This means all of the above OLAP systems exist.
Detailed explanation-5: -One of the main methods of accessing the OLAP Cube is using an Excel pivot table. Since pivot tables are more used by the business users, they can leverage the excel features by using the cubes.