Questions from Database Systems

Q: Explain ROLAP, and list the reasons you would recommend its use

Explain ROLAP, and list the reasons you would recommend its use in the relational database environment.

Q: Explain the use of facts, dimensions, and attributes in the

Explain the use of facts, dimensions, and attributes in the star schema.

Q: Create a query to find the customer balance characteristics for all customers

Create a query to find the customer balance characteristics for all customers, including the total of the outstanding balances. The results of this query are shown in Figure P7.39. FIGURE P7.39 Custo...

Q: Explain multidimensional cubes, and describe how the slice and dice technique

Explain multidimensional cubes, and describe how the slice and dice technique fits into this model.

Q: Describe the BI framework. Illustrate the evolution of BI.

Describe the BI framework. Illustrate the evolution of BI.

Q: In the star schema context, what are attribute hierarchies and aggregation

In the star schema context, what are attribute hierarchies and aggregation levels and what is their purpose?

Q: Discuss the most common performance improvement techniques used in star schemas.

Discuss the most common performance improvement techniques used in star schemas.

Q: What are decision support systems, and what role do they play

What are decision support systems, and what role do they play in the business environment?

Q: Explain how the main components of the BI architecture interact to form

Explain how the main components of the BI architecture interact to form a system. Describe the evolution of BI information dissemination formats.

Q: What are the most relevant differences between operational and decision support data

What are the most relevant differences between operational and decision support data?