Building and Maintaining a Data Warehouse

Building and Maintaining a Data Warehouse

Fon Silvers

Language: English

Pages: 328

ISBN: 1420064622

Format: PDF / Kindle (mobi) / ePub


As it is with building a house, most of the work necessary to build a data warehouse is neither visible nor obvious when looking at the completed product. While it may be easy to plan for a data warehouse that incorporates all the right concepts, taking the steps needed to create a warehouse that is as functional and user-friendly as it is theoretically sound, is not especially easy. That’s the challenge that Building and Maintaininga Data Warehouse answers.

Based on a foundation of industry-accepted principles, this work provides an easy-to-follow approach that is cohesive and holistic. By offering the perspective of a successful data warehouse, as well as that of a failed one, this workdetails those factors that must be accomplished and those that are best avoided.

Organized to logically progress from more general to specific information, this valuable guide:

  • Presents areas of a data warehouse individually and in sequence, showing how each piece becomes a working part of the whole
  • Examines the concepts and principles that are at the foundation of every successful data warehouse
  • Explains how to recognize and attend to problematic gaps in an established data warehouse
  • Provides the big picture perspective that planners and executives require

Those considering the planning and creation of a data warehouse, as well as those who’ve already built one will profit greatly from the insights garnered by the author during his years of creating and gathering information on state-of-the-art data warehouses that are accessible, convenient, and reliable.

Building a Home Security System with Raspberry Pi

Trading Systems: Theory and Immediate Practice (Perspectives in Business Culture)

Nginx HTTP Server (2nd Edition)

Tori Amos: Piece by Piece

The Playboy Interview: Music Men

The Subversive Copy Editor: Advice from Chicago (or, How to Negotiate Good Relationships with Your Writers, Your Colleagues, and Yourself)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

One Version of the Truth: ETL applications reference only the one gold standard for every data element. n Long-Term Investment: Populate data into a data warehouse, realizing the long-term flexibility of the data warehouse design. Data Availability The data inside a data warehouse is of no use to a business without a way to use that data. Business Intelligence Reporting, also known as BI Reporting, is a set of applications by which a business can harness data and information in a data warehouse.

intersection of multiple Core data elements. For example: n Project Team: Multiple people from disparate departments brought together to achieve a single goal. The Core entities are the individual people. n Product Offering: Multiple individual products merchandised as one logical unit. The Core entities are the individual products. n Facility Groups: Multiple individual facilities from various geographic regions, which are grouped together based on common shared demographic criteria. The Core

Remarks.......................................................................................258 References.................................................................................................258 9 Metadata..............................................................................................259 Introduction.............................................................................................259 Types of

Relational data definition. n Define the structure within the layout. − Define the meaning of each field or column. AU6462.indb 173 2/7/08 9:53:39 AM 174  n  Building and Maintaining a Data Warehouse − Define the accepted domain, range, and relational integrity for each field or column. − Determine the expected cardinality of the dataset. n Attach data to the interior of the dataset. − Insert data using the COBOL copybook, XML layout, or relational data definition. − Verify the data conforms

Fortier, and Anthony Jones. I thank J.D. and Sue Anderson for allowing the children to spend the summer with them, so I could have the peace and quiet necessary to write this book. I thank God for making this book possible in so many ways. And, I thank Steve Olive, who years ago recognized a rookie who was in over his head and helped me succeed. Finally, I thank Auerbach Publishing for this opportunity. xvii AU6462.indb 17 2/7/08 9:41:58 AM AU6462.indb 18 2/7/08 9:41:58 AM The Author Fon

Download sample

Download