shopping cart
Save up to 30% on our Staff Picks
Call us: 800-878-7323 HELP
McAfee SECURE helps keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams.
Contributors | November 10, 2009

Zachary Lazar: IMG Evening's Empire

0 comments By Zachary Lazar

Without knowing it, I'd always had two unspoken arrangements with the world. The first was that I would not trouble it with unpleasant conversation... Continue »
  1. $17.49 Sale Hardcover add to wish list

    Evening's Empire: The Story of My Father's Murder

    Zachary Lazar

Data Warehousing: Architecture and Implementation with CDROM (Harris Kern's Enterprise Computing Institute)

by Mark Humphries

Data Warehousing: Architecture and Implementation with CDROM (Harris Kern's Enterprise Computing Institute) Cover

ISBN13: 9780130809025
ISBN10: 0130809020
Condition: Standard
All Product Details

Only 1 left in stock at $45.50!

Synopses & Reviews

Publisher Comments:

8090B-0

A start-to-finish process for deploying successful data warehouses.

This book delivers what every data warehousing project participant needs most: a thorough overview of today's best solutions, and a reliable step-by-step process for building warehouses that meet their objectives. It answers the key questions asked by everyone involved in a data warehouse initiative: project sponsors, developers, managers, and CIOs. And, with over 75 figures, it doesn't just tell you how to get the job done: it shows you.

  • Migration strategies and scenarios
  • Management and support: issue resolution, capacity planning, security, backup, and more
  • Specific answers for project sponsors, managers, and CIOs
  • 12 steps for implementation
  • Best techniques for schema design and metadata
  • Choosing the right hardware, software, and platforms
  • Evolving as new technologies mature

Rely on this book's up-to-date listings of vendors and Web resources. Learn to evolve your data warehouse as new technologies mature-including metadata interchange standards, Web solutions, and Windows …Ø NT. Whatever your goals, Data Warehousing for IT Professionals will help you achieve them faster and at lower cost.

Book News Annotation:

Provides an overview of solutions and step-by-step processes for building warehouses. Some of the topics covered include migration strategies and scenarios, warehouse management, maintenance and support, 12 steps for implementation, techniques for schema design and metadata, and criteria for selecting the right hardware, software, and platforms. A CD-ROM contains two software products: Warehouse Designer and R/OLAPXL. Annotation c. by Book News, Inc., Portland, OR (booknews@booknews.com)

Description:

"R/OLAPXL requires PC compatible systems with an Intell 486/100 or faster processor; Windows 95; MS Excel 7.0 or MS Excel 97; MS Access ODBC Driver (Level 2 compliant); 7.7 MB of hard-disk space"--About the CD. "Warehouse Designer requires PC compatible system with an Intel 486/100 or faster processor; Windows 95; MS Access Runtime and ODBC Driver (Level 2 compliant); 1.0 M B of hard-disk space"--About the CD. Includes "Online data warehousing resources" (p. 339-340) and index.
back to top

About the Author

Mark Humphries is President/CEO of Intranet Business Systems, Inc., The Philippines. He has 13 years experience in management and consulting throughout Europe, North America, and Asia, and led major warehousing projects for two U.S. utilities.

Michelle Dy, Business Analyst at Intranet Business Systems, Inc., specializes in methods consulting, BPR, planning, analysis, and design.

back to top

Table of Contents

I. INTRODUCTION.
1. The Enterprise IT Architecture.

The Past: Evolution of Enterprise Architectures. The Present: The IT Professional's Responsibility. Business Perspective. Technology Perspective. Architecture Migration Scenarios. Migration Strategy: How Do We Move Forward?
2. Data Warehouse Concepts.

Gradual Changes in Computing Focus. The Data Warehouse Defined. The Dynamic, Ad Hoc Report. The Purposes of a Data Warehouse. A Word about Data Marts. A Word about Operational Data Stores. Data Warehouse Cost-Benefit Analysis / Return On Investment.

II. PEOPLE.

3. The Project Sponsor.

How Will a Data Warehouse Affect our Decision-Making Processes? How Does a Data Warehouse Improve My Financial Processes? Marketing? Operations? When Is a Data Warehouse Project Justified? What Expenses Are Involved? What Are the Risks? Risk-Mitigating Approaches. Is My Organization Ready for a Data Warehouse? How Do I Measure the Results?
4. The CIO.

How Do I Support the Data Warehouse? How Will My Data Warehouse Evolve? Who Should Be Involved in a Data Warehouse Project? What Is the Team Structure Like? What New Skills Will My People Need? How Does Data Warehousing Fit into My IT Architecture? How Many Vendors Do I Need to Talk To? What Should I Look for in a Data Warehouse Vendor? How Does Data Warehousing Affect My Existing Systems? Data Warehousing and its Impact on Other Enterprise Initiatives. When Is a Data Warehouse Not Appropriate? How Do I Manage or Control a Data Warehouse Initiative?
5. The Project Manager.

How Do I Roll Out a Data Warehouse Initiative? How Important Is the Hardware Platform? What Technologies Are Involved? Do I Still Use Relational Databases for Data Warehousing? How Long Does a Data Warehousing Project Last? How Is a Data Warehouse Different from Other IT Projects? What Are the Critical Success Factors of a Data Warehousing Project?

III. PROCESS.

6. Warehousing Strategy.

Strategy Components. Determine Organizational Context. Conduct Preliminary Survey of Requirements. Conduct Preliminary Source System Audit. Identify External Data Sources (If Applicable). Define Warehouse Rollouts (Phased Implementation). Define Preliminary Data Warehouse Architecture. Evaluate Development and Production Environments and Tools.
7. Warehouse Management and Support Processes.

Define Issue Tracking and Resolution Process. Perform Capacity Planning. Define Warehouse Purging Rules. Define Security Measures. Define Backup and Recovery Strategy. Set Up Collection of Warehouse Usage Statistics.
8. Data Warehouse Planning.

Assemble and Orient Team. Conduct Decisional Requirements Analysis. Conduct Decisional Source System Audit. Design Logical and Physical Warehouse Schema. Produce Source-to-Target Field Mapping. Select Development and Production Environment and Tools. Create Prototype for This Rollout. Create Implementation Plan for this Rollout. Warehouse Planning Tips and Caveats.
9. Data Warehouse Implementation.

Acquire and Set Up Development Environment. Obtain Copies of Operational Tables. Finalize Physical Warehouse Schema Design. Build or Configure Extraction and Transformation Subsystems. Build or Configure Data Quality Subsystem. Build Warehouse Load Subsystem. Set-up Data Warehouse Schema. Set Up Data Warehouse Metadata. Set Up Data Access and Retrieval Tools. Perform the Production Warehouse Load. Conduct User Training. Conduct User Testing and Acceptance.

IV. TECHNOLOGY.

10. Hardware and Operating Systems.

Parallel Hardware Technology. Hardware Selection Criteria.
11. Warehousing Software.

Overview. Middleware and Connectivity Tools. Extraction Tools. Transformation Tools. Data Quality Tools. Data Loaders. Database Management Systems. Metadata Repository. Data Access and Retrieval Tools. Data Modeling Tools. Warehouse Management Tools. Source Systems.
12. Warehouse Schema Design.

OLTP Systems Use Normalized Data Structures. Dimensional Modeling for Decisional Systems. Two Types of Tables: Facts and Dimensions. A Schema Is a Fact Table and Its Related Dimension Tables. Facts Are Fully Normalized, Dimensions Are Denormalized. Dimensional Hierarchies and Hierarchical Drilling. The Time Dimension. The Grain of the Fact Table. The Fact Table Key Is the Concatenation of Dimension Keys. Aggregates or Summaries. Dimensional Attributes. Multiple Star Schemas. Core and Custom Tables.
13. Warehouse Metadata.

Metadata Are a Form of Abstraction. Why Are Metadata Important? Metadata Types. Versioning. Metadata as the Basis for Automating Warehousing Tasks.
14. Warehousing Applications.

The Early Adoptors. Types of Warehousing Applications. Specialized Applications of Warehousing Technology.

V. WHERE TO NOW?

15. Warehouse Maintenance and Evolution.

Regular Warehouse Loads. Warehouse Statistics Collection. Warehouse User Profiles. Security and Access Profiles. Data Quality. Data Growth. Updates to Warehouse Subsystems. Database Optimization and Tuning. Data Warehouse Staffing. Warehouse Staff and User Training. Subsequent Warehouse Rollouts. Chargeback Schemes. Disaster Recovery.
16. Warehousing Trends.

Continued Growth of the Data Warehouse Industry. Increased Adoption of Warehousing Technology by More Industries. Increased Maturity of Data Mining Technologies. Emergence and Use of Metadata Interchange Standards. Increased Availability of Web-Enabled Solutions. Popularity of Windows NT for Data Mart Projects. Availability of Warehousing Modules for Application Packages. More Mergers and Acquisitions Among Warehouse Players.

VI. Appendices.

Appendix A. R/olapXL¨ User,s Guide.

Appendix B. Warehouse Designer¨ User's Manual.

Appendix C. Online Data Warehousing Resources.

Appendix D. Tool and Vendor Inventory.

Appendix E. Software License Agreement.

VII. REFERENCES and FURTHER READING.

back to top
back to top

Product Details

ISBN:
9780130809025
Subtitle:
Architecture and Implementation [With *]
Other:
Humphries, Mark
Author:
Humphries, Mark W.
Author:
Humphries, Mark
Author:
Dy, Michelle C.
Author:
Dy, Michelle
Author:
Hawkins, Michael W.
Publisher:
Prentice Hall PTR
Location:
Upper Saddle River, N.J. :
Subject:
Information Management
Subject:
Industrial Management
Subject:
Information technology
Subject:
Database Management - General
Subject:
Database management
Subject:
Database Management - Data Warehousing and Data Mining
Subject:
Data warehousing
Subject:
Decision support systems
Subject:
Database Management - Data Warehousing
Copyright:
1999
Edition Description:
Trade paper
Series:
Harris Kern's Enterprise Computing Institute Series
Publication Date:
December 1998
Binding:
Paper Textbook
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Yes
Pages:
360
Dimensions:
25 cm. +
back to top

Other books you might like

  1. $25.00 New Trade Paper add to wish list

    IBM(R) Data Warehousing: With IBM Business Intelligence Tools

    Michael L Gonzales
back to top

Related Aisles

  • back to top

Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and eBooks — here at Powells.com.