Higher Ed. and Vocational >> Engineering and Computer Science >> Computer Science >> Database Systems


Data Warehousing in the Real World: A Practical Guide for Building Decision Support Systems

Data Warehousing in the Real World:   A Practical Guide for Building Decision Support Systems

Author(s):
  • Sam Anahory
  • Dennis Murray
  • Author: Sam Anahory
    • ISBN:9788131704592
    • 10 Digit ISBN:8131704599
    • Price:Rs. 950.00
    • Pages:368
    • Imprint:Pearson Education
    • Binding:Paperback
    • Status:Available


    Ratings:

    Data warehouses are the primary means by which businesses can gain competitive advantage through analyzing and using the information stored in their computerized systems. Data Warehousing in the Real World provides comprehensive guidelines and techniques for the delivery of decision support solutions using open-systems data warehouses. Written by practitioners for practitioners, this book describes each stage of the implementation process in detail.



    Read this book to:


    • Learn the fundamentals of designing large scale data warehouses using relational technology


    • Take advantage of product-independent comprehensive guidelines which cover all the issues you need to take into account when planning and building a data warehouse


    • Apply to your own situation the examples of real-life solutions taken from a variety of different business sectors


    • Make use of the templates for project-plans, system architectures and database designs


    Table of Content

    Part One: Introduction
    • Introduction
    • Delivery Process
    Part Two: Data Warehouse Architecture
    • System Process
    • Process Architecture
    Part Three: Design
    • Database Schemes
    • Partitioning Strategy
    • Aggregations
    • Data Marting
    • Metadata
    • System and Data Warehouse
    • Process Managers
    Part Four: Hardware and Operational Design
    • Hardware Architecture
    • Physical Layout
    • Security
    • Backup and Recovery
    • Service Level Agreement
    • Operating the Data Warehouse
    Part Five: Capacity Planning, Tuning and Testing
    • Capacity Planning
    • Tuning the Data Warehouse
    • Testing the Data Warehouse
    Part Six: Futures
    • Data Warehouse Futures

    Salient Features

    • learn the fundamentals of designing large-scale data warehouses using relational technology
    • take advantage of product-independent comprehensive guidelines which cover all the issues you need to take into account when planning and building a data warehouse
    • benefit from the authors' experience distilled into helpful hints and tips
    • apply to your own situation the examples of real-life solutions taken from a variety of different business sectors
    • make use of the templates for project-plans, system architectures and database designs.