- The data warehousing project group has invited you to provide an OLAP overview. The group’s members are particularly concerned about the OLAP client/server architecture requirements and how OLAP will fit the existing environment. Your job is to explain the main OLAP client/server components and architectures.
- One of your vendors recommends using an MDBMS. How would you explain this recommendation to your project leader?
- The project group is ready to make a final decision, choosing between ROLAP and MOLAP. What should be the basis for this decision? Why?
- The data warehouse project is in the design phase. Explain to your fellow designers how you would use a star schema in the design.
- Briefly discuss the OLAP architectural styles with and without data marts.
- Identify some bottlenecks in DBMS performance, and then propose some solutions used in DBMS performance tuning.
- What are typical activities in the maintenance of the DBMS and its utilities and applications? Would you consider application performance tuning to be part of the maintenance activities? Explain your answer.
- How do you normally define security? How is your definition similar to or different from the definition of database security in this chapter?
- How do you normally define security? How is your definition similar to or different from the definition of database security in this chapter?
- What are security vulnerabilities? What is a security threat? Give some examples of security vulnerabilities in different IS components.