Chapter 4

Developing the Logical Design

Review Questions

1. What are the disadvantages of using an OLTP system to conduct analytical processing?

It is difficult to design analytical reports; indexes reduce performance, and it is a complex data model.

2. Name the two table types that make up a dimensional schema.

Dimension and fact

3. Are aggregate schemas always necessary in OLAP system designs?

No. Some tools such as Microsoft OLAP Services build aggregations using an intelligent algorithm, which makes an aggregate schema unnecessary.

4. What are the disadvantages of using an OLTP system to conduct analytical processing?

It is difficult to design analytical reports, indexes reduce performance, and it is a complex data model.