The data warehouse ETL toolkit : practical techniques for extracting, cleaning, conforming, and delivering data /

Annotation

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autores principales: Kimball, Ralph (Autor), Caserta, Joe, 1965- (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, IN : Wiley, [2004].
Temas:
Data warehousing.
Database design.
Entrepôts de données (Informatique)
Bases de données > Conception.
COMPUTERS > Desktop Applications > Databases.
COMPUTERS > Database Management > General.
COMPUTERS > System Administration > Storage & Retrieval.
Data-Warehouse-Konzept
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Requirements, Realities, and Architecture
  • Surrounding the Requirements
  • The Mission of the Data Warehouse
  • The Mission of the ETL Team
  • ETL Data Structures
  • To Stage or Not to Stage
  • Designing the Staging Area
  • Data Structures in the ETL System
  • Planning and Design Standards
  • Data Flow
  • Extracting
  • The Logical Data Map
  • Building the Logical Data Map
  • Integrating Heterogeneous Data Sources
  • The Challenge of Extracting from Disparate Platforms
  • Mainframe Sources
  • Flat Files
  • XML Sources
  • Web Log Sources
  • ERP System Sources
  • Extracting Changed Data
  • Cleaning and Conforming
  • Defining Data Quality
  • Assumptions
  • Design Objectives
  • Cleaning Deliverables
  • Screens and Their Measurements
  • Conforming Deliverables
  • Delivering Dimension Tables
  • The Basic Structure of a Dimension
  • The Grain of a Dimension
  • The Basic Load Plan for a Dimension
  • Flat Dimensions and Snowflaked Dimensions
  • Date and Time Dimensions
  • Big Dimensions
  • Small Dimensions
  • One Dimension or Two
  • Dimensional Roles
  • Dimensions as Subdimensions of Another Dimension
  • Degenerate Dimensions
  • Slowly Changing Dimensions
  • Type 1 Slowly Changing Dimension (Overwrite)
  • Type 2 Slowly Changing Dimension (Partitioning History)
  • Precise Time Stamping of a Type 2 Slowly Changing Dimension
  • Type 3 Slowly Changing Dimension (Alternate Realities)
  • Hybrid Slowly Changing Dimensions
  • Late-Arriving Dimension Records and Correcting Bad Data
  • Multivalued Dimensions and Bridge Tables.

Ejemplares similares