What is OLAP, and what types of OLAP tools are available?

What will be an ideal response?


OLAP stands for On-Line Analytical Processing. It is the use of a set of reporting and querying tools which allows the user to use simple windowing techniques to analyze multidimensional views of their data. The multidimensional view of the data can be thought of as a data cube. There are several variations of OLAP including: ROLAP (Relational OLAP) which uses SQL and view the database as a traditional relational database. MOLAP (Multidimensional OLAP) creates a data store where the data is viewed in its multidimensional format. Some less common tools are DOLAP, which builds OLAP into the query language, and HOLAP, which offers both multidimensional as well as relation query language access to the data.

Business

You might also like to view...

________ segmentation divides the market into segments based on variables such as age, life-cycle stage, gender, income, occupation, education, religion, ethnicity, and generation

A) Geographic B) Benefit C) Occasion D) Psychographic E) Demographic

Business

In the United States nearly half of the private workforce is represented by ________.

A. small business owners and their employees B. entrepreneurs C. corporations and their employees D. women and minorities

Business

Consider the Demand for Microwave Ovens data set. What is the total demand corresponding to random numbers 47, 9, 83, 79, 29, and 28?



A. 9
B. 10
C. 11
D. 12

Business

Working capital is an owner's share of the assets of a company.

Answer the following statement true (T) or false (F)

Business