Discuss the relationship between data warehousing and OLAP.

What will be an ideal response?


In the past few years, relational DBMS vendors have targeted the data warehousing market
and have promoted their systems as tools for building data warehouses. A data warehouse
stores operational data and is expected to support a wide range of queries from the relatively
simple to the highly complex. However, the ability to answer particular queries is dependent
on the types of end-user access tools available for use on the data warehouse. General-purpose
tools such as reporting and query tools can easily support ‘who?’ and ‘what?’ questions about
past events. A typical query submitted directly to a data warehouse is: ‘What was the total
revenue for Scotland in the third quarter of 2001?’. In this section we focus on a tool that can
support more advanced queries, namely online analytical processing (OLAP).
While OLAP systems can easily answer ‘who?’ and ‘what?’ questions, it is their ability to
answer ‘what if?’ and ‘why?’ type questions that distinguish them from general-purpose query
tools. OLAP enables decision-making about future actions.

Computer Science & Information Technology

You might also like to view...

Documents protected by XML security may be signed or encrypted long before anyone can predict who will be the ultimate recipients. What measures are taken to ensure that the latter have access to the algorithms used by the former?

What will be an ideal response?

Computer Science & Information Technology

The small squares and circles around a selected graphic, as shown in the accompanying figure, are called ____ handles.

A. sizing B. shape C. base D. dimension

Computer Science & Information Technology

Photoshop is a dedicated 3D modeling app.

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

Computer Science & Information Technology

__________ can be caused by harsh environmental abuse, manufacturing defects, and wear.

A. SEC errors B. Hard errors C. Syndrome errors D. Soft errors

Computer Science & Information Technology