3.6. CHAPTER SUMMARY

  • Data warehousing is becoming mainstream with the spread of high-volume data warehouses and the rapid increase in the number of vendor products.

  • To be effective, modern data warehouses need to store multiple types of data: structured and unstructured, including documents, images, audio, and video.

  • Data visualization deals with displaying information in several types of visual forms: text, numerical arrays, spreadsheets, charts, graphs, and so on. Tremendous progress has been made in data visualization.

  • Data warehouse performance may be improved by using parallel processing with appropriate hardware and software options.

  • It is critical to adapt data warehousing to work with ERP packages, knowledge management, and customer relationship systems.

  • Data warehousing industry is seriously seeking agreed-upon standards for metadata and OLAP. The end is perhaps in sight.

  • Web-enabling the data warehouse means using the Web for information delivery and integrating the clickstream data from the corporate Web site for analysis. The convergence of data warehousing and the Web technology is crucial to every business in the 21st century.

Get DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.