Description
A guide for database developers, designers, and managers to creating a database tailored for analytic and informational uses, different and separate from a database with the same information to be used in ordinary operations. Deals more with concepts, overall approaches, and issues rather than technical aspects. Among the topics are decision support systems that utilize data warehouses, environment and design, granularity, distributed data, executive information systems, external and unstructured data, and migration to the environment. No mention is made of the first edition or why a second was issued. Annotation c. by Book News, Inc., Portland, Or.
Read More
Everything you need to know to design, develop, and build your data warehouse The data warehouse solves the problem of getting information out of legacy systems quickly and efficiently. If designed and built right, data warehouses can provide significant freedom of access to data, thereby delivering enormous benefits to any organization. In this unique handbook, W. H. Inmon, "the father of the data warehouse," provides detailed discussion and analysis of all major issues related to the design and construction of the data ware-house, including granularity of data, partitioning data, metadata, lack of creditability of decision support systems (DSS) data, the system of record, migration, and more. This Second Edition of Building the Data Warehouse is revised and expanded to include new techniques and applications of data warehouse technology and update existing topics to reflect the latest thinking. It includes a useful review checklist to help evaluate the effectiveness of the design and explains * How to design and build a data warehouse-including step-by-step guidelines * Migration to the data warehouse from existing architectures * Techniques for using the data warehouse to provide companies with a powerful competitive edge * How to monitor the data warehouse * The role of the data warehouse in reengineering * How to get the most from both star joins and data models * How data marts and OLAP fit with data warehousing techniques * And much more Find out what a data warehouse can do for your company and how to build one tailored to your organization's needs in Building the Data Warehouse, Second Edition.
Read Less