O'Reilly logo

DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals by Paulraj Ponniah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

16.8. EXERCISES

  1. Indicate if true or false:

    1. The extranet excludes outside business partners from accessing the company's data warehouse.

    2. Web technology in a data warehouse opens up multiple information formats to users.

    3. Better information delivery to users is the only reason for Web-enabling your data warehouse.

    4. Supergrowth is a rare phenomenon in a Web-enabled data warehouse environment.

    5. The Web promotes "self-service" access.

    6. The data Webhouse necessitates a distributed architecture.

    7. Web technology makes it easier to add more users to the data warehouse.

    8. The Web and its features are not compatible with the data warehouse.

    9. For its information interface, the Web-enabled data warehouse is unable to use both "push" and "pull" techniques.

    10. In a Web-enabled data warehouse, the standard HTML or XML file is the principal means for communication.

  2. Web-based information in a data warehouse results in "supergrowth." Discuss this phenomenal growth and describe how you will provide for supergrowth.

  3. Your project team has been directed to provide all report generation and delivery over the Internet. Create a plan for adopting the Web technology for all reporting from your data warehouse. Discuss all the implications.

  4. The Web-enabled data warehouse has no center. It is a distributed environment. Analyze the implications of these statements. From this perspective, what are the considerations for maintaining the dimension and fact tables?

  5. As the Web specialist on the project team, prepare a document highlighting ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required