Data Warehouse From Architecture to Implementation

Name: Data Warehouse From Architecture to Implementation
Price: 49.31 USD
Availability: InStock
ISBN: 9780201964257

ISBN-10: 0201964252

ISBN-13: 9780201964257

Edition: 1997

Authors: Barry Devlin

List price: $49.95

30 day, 100% satisfaction guarantee!

Marketplace

1 new & used from $49.31

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

Data warehousing is one of the hottest topics in the computing industry. Written by Barry Devlin, one of the world's leading experts on data warehousing, this book gives you the insights and experiences gained over 10 years and offers the most comprehensive, practical guide to designing, building, and implementing a successful data warehouse. Included in this vital information is an explanation of the optimal three-tiered architecture for the data warehouse, with a clear division between data and information. Information systems managers will appreciate the full description of the functions needed to implement such an architecture, including reconciling existing, diverse data and deriving…

Book details

List price: $49.95
Copyright year: 1997
Publisher: Addison Wesley Professional
Publication date: 11/4/1996
Binding: Hardcover
Pages: 448
Size: 8.00" wide x 9.75" long x 1.00" tall
Weight: 1.782
Language: English



Preface


Table of contents


Table of figures and tables



Introduction



Why this book?



Audience



Structure



The evolution of data warehousing



The data warehouse--a brief history



Prehistoric times--before the 1980s



The middle ages--mid- to late-1980s



The data revolution--the early 1990s



The era of information-based management--into the 21st century



What is a data warehouse?



Conclusions



Today's development environment



Fragmented application development



Operational application development



Application-driven decision support



The Info Center



Conclusions



Principles of data warehousing



Types of data and their uses



Types of data



Business data



Metadata



Data beyond the scope of the warehouse



Internal and external data



Conclusions



Conceptual data architecture



Business data architectures



The single-layer data architecture



The two-layer data architecture



The three-layer data architecture



A data architecture for metadata



Conclusions



Design techniques



Enterprise data modeling



Representing time in business data



Historical data



Data replication



Conclusions



Introduction to the logical architecture



Business data in the data warehouse



Business data--other considerations



External data



Metadata in the data warehouse



The data warehouse catalog



Operational systems



Data warehouse functionality



Conclusions



Creating the data asset



Business data warehouse design



Modeling the BDW--general design



Modeling the BDW--a segmented approach



Modeling the BDW--practical results



The structure of periodic data in the BDW



Archive and retrieval



The role of parallel databases



Conclusions



Populating the business data warehouse



BDW population--initial considerations



Capture--an introduction



From operational data to the BDW



Six data capture techniques



Output data structures from capture



Apply--an introduction



Apply during BDW creation



Apply during BDW maintenance



Refresh versus update of the BDW



Transformation--an introduction



Transformation in BDW population



BDW population--the overall process



Conclusions



Unlocking the data asset for end users



Designing business information warehouses



Types of business information warehouse



Modeling BIWs



Key influences on BIW design



BIW implementation



Historical data in BIWs



Archive and retrieval in BIWs



Conclusions



Populating business information warehouses



BIW population--an introduction



Capture from the BDW



Apply to the BIW



Comparing the performance of update and refresh modes of replication



Transformation



BIW population--implementation aspects



Conclusions



User access to information



The business information interface



Data access



Conclusions



Information--data in context



The business information guide--an introduction



Requirements for the BIG



The naive and sentimental user



Users of the BIG



Structure of the BIG



DWC population



Conclusions



Implementing the data warehouse



Obstacles to implementation



The size and scope of the warehouse



Justifying investment in a data warehouse



Organizational issues



Placement of the BDW and BIWs in the enterprise



Ongoing administration



Conclusions



Planning your implementation



Segmenting the data warehouse



Staging the warehouse implementation



Kick-starting the implementation process



Coordinating the data warehouse implementation process



Critical success factors



Conclusions



Justifying the warehouse



The traditional justification approach



Beyond cost avoidance



A new basis for competitiveness



Changing management structures



The automation of marketing



Data warehouse costs



Conclusions



Organizational implications of data warehousing



From planning to pilot



From initiation to roll-out



Conclusions



Physical structure of the data warehouse



The data warehouse environment--centralized versus distributed



Aligning the data warehouse with the organizational structure



Subsetting the BDW



Conclusions



Data warehouse management



Replication administration



From administration to runtime



Process management



Data transfer



Other database support functions



Conclusions



Looking to the future



A single information source



Distributed information availability



Information in a business context



Automated information delivery



Information quality and ownership



Concluding remarks


References


Index