Tous nos rayons

Déjà client ? Identifiez-vous

Mot de passe oublié ?

Nouveau client ?

CRÉER VOTRE COMPTE
Data Warehousing in the Real World
Ajouter à une liste

Librairie Eyrolles - Paris 5e
Indisponible

Data Warehousing in the Real World

Data Warehousing in the Real World

A Practical Guide for Building Decision Support Systems

Sam Anahory, Dennis Murray

464 pages, parution le 15/08/1997

Résumé

Written by practitioners for practitioners, this book takes a "cookbook" approach and describes each stage of the implementation process in detail: from project planning and requirements analysis, through architecture and design, to administrative issues such as user access, security, back-up, and recovery. Using examples from their real-world experiences in a variety of different business sectors, Sam Anahory and Dennis Murray provide helpful guidelines and tips that help you create the best data warehouse for your own situation.

Table of contents

PART I INTRODUCTION

INTRODUCTION
Background
What is a Data Warehouse?
Why Read This Book?
Road Map
One Final Point

DELIVERY PROCESS
Introduction
Data Warehouse Delivery Method

PART II DATA WAREHOUSE ARCHITECTURE

SYSTEM PROCESSES
Introduction
Overview
Typical Process Flow Within a Data Warehouse
Extract and Load Process
Clean and Transform Data
Backup and Archive Process
Query Management Process

PROCESS ARCHITECTURE
Introduction
Load Manager
Warehouse Manager
Query Manager
Detailed Information
Summary Information
Metadata
Data Marting
To Summarize

PART III DESIGN

DATABASE SCHEMA
Introduction
Starflake Schemas
Identifying Facts and Dimensions
Designing Fact Tables
Designing Dimension Tables
Designing the Starflake Schema
Query Redirection
Other Schemas

PARTITIONING STRATEGY
Introduction
Horizontal Partitioning
Vertical Partitioning
Hardware Partitioning

AGGREGATIONS
Introduction
Why Aggregate?
What is an Aggregation?
Designing Summary Tables
Which Summaries to Create

DATA MARTING
Introduction
When is a Data Mart Appropriate?
Designing Data Marts
Costs of Data Marting

METADATA
Introduction
Data Transformation and Load
Data Management
Query Generation
Metadata and Tools

SYSTEM AND DATA WAREHOUSE PROCESS MANAGERS
Introduction
Why You Need Tools to Manage a Data Warehouse
System Managers
Data Warehouse Process Managers
Load Manager
Warehouse Manager
Query Manager

PART IV HARDWARE AND OPERATIONAL DESIGN

HARDWARE ARCHITECTURE
Introduction
Process
Server Hardware
Network Hardware
Client Hardware

PHYSICAL LAYOUT
Parallel Technology
Disk Technology
Database Layout
Filesystems

SECURITY
Introduction
Requirements
Performance Impact of Security
Security Impact on Design

BACKUP AND RECOVERY
Introduction
Definitions
Hardware
Software
Backup Strategies
Testing the Strategy
Disaster Recovery

SERVICE LEVEL AGREEMENT
Introduction
Definition of Types of System
Is the Data Warehouse an Operational System of Not?
Defining the SLA

OPERATING THE DATA WAREHOUSE
Day-to-Day Operations of the Data Warehouse
Overnight Processing

PART V CAPACITY PLANNING, TUNING AND TESTING

CAPACITY PLANNING
Introduction
Process
Estimating the Load

TUNING THE DATA WAREHOUSE
Introduction
Assessing Performance
Tuning the Data Load
Tuning Queries

TESTING THE DATA WAREHOUSE
Introduction
Developing the Test Plan
Testing Backup Recovery
Testing the Operational Environment
Testing the Database
Testing the Application
Logistics of the Test

PART VI FUTURES

DATA WAREHOUSE FUTURES

APPENDICES
Methodology
Accessing the Data Warehouse

Caractéristiques techniques

  PAPIER
Éditeur(s) Addison Wesley
Auteur(s) Sam Anahory, Dennis Murray
Parution 15/08/1997
Nb. de pages 464
EAN13 9780201175196

Avantages Eyrolles.com

Livraison à partir de 0,01 en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
satisfait ou remboursé
Satisfait ou remboursé
Paiement sécurisé
modes de paiement
Paiement à l'expédition
partout dans le monde
Livraison partout dans le monde
Service clients sav@commande.eyrolles.com
librairie française
Librairie française depuis 1925
Recevez nos newsletters
Vous serez régulièrement informé(e) de toutes nos actualités.
Inscription