DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals

3.8. EXERCISES

1. Indicate if true or false:

   1. Data warehousing helps in customized marketing.

   2. It is more important to include unstructured data than structured data in a data warehouse.

   3. Dynamic charts are themselves user interfaces.

   4. MPP is a shared-memory parallel hardware configuration.

   5. ERP systems may be substituted for data warehouses.

   6. Most of a corporation's knowledge base contains unstructured data.

   7. The traditional data transformation tools are quite adequate for a CRM-ready data warehouse.

   8. Metadata standards facilitate deploying a combination of best-of-breed products.

   9. MDAPI is a data fusion standard.

   10. A Web-enabled data warehouse stores only the clickstream data captured at the corporation's Web site.

2. As the senior analyst on the data warehouse project of a large retail chain, you are responsible for improving data visualization of the output results. Make a list of your recommendations.

3. Explain how and why parallel processing can improve the performance for data loading and index creation.

4. Discuss three specific ways in which agent technology may be used to enhance the value of the data warehouse in a large manufacturing company.

5. Your company is in the business of renting DVDs and video tapes. The company has recently entered into e-business and the senior management wants to make the existing data warehouse Web-enabled. List and describe any three of the major tasks required for satisfying the management's directive.