Kids Library Home

Welcome to the Kids' Library!

Search for books, movies, music, magazines, and more.

Available items only
Author Kimball, Ralph.

Title The data warehouse ETL toolkit : practical techniques for extracting, cleaning, conforming, and delivering data / Ralph Kimball, Joe Caserta.

Imprint Indianapolis, IN : Wiley, ©2004.


Location Call No. OPAC Message Status
 Axe Books 24x7 IT E-Book  Electronic Book    ---  Available
Description 1 online resource (xxxiv, 491 pages) : illustrations
text txt rdacontent
computer c rdamedia
online resource cr rdacarrier
Note Print version record.
Summary Annotation Cowritten by Ralph Kimball, the world's leading data warehousing authority, whose previous books have sold more than 150,000 copiesDelivers real-world solutions for the most time- and labor-intensive portion of data warehousing-data staging, or the extract, transform, load (ETL) processDelineates best practices for extracting data from scattered sources, removing redundant and inaccurate data, transforming the remaining data into correctly formatted data structures, and then loading the end product into the data warehouseOffers proven time-saving ETL techniques, comprehensive guidance on building dimensional structures, and crucial advice on ensuring data quality.
Contents 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.
Access Use copy Restrictions unspecified star MiAaHDL
Reproduction Electronic reproduction. [S.l.] : HathiTrust Digital Library, 2010. MiAaHDL
System Details Master and use copy. Digital master created according to Benchmark for Faithful Digital Reproductions of Monographs and Serials, Version 1. Digital Library Federation, December 2002. MiAaHDL
Processing Action digitized 2010 HathiTrust Digital Library committed to preserve pda MiAaHDL
Subject 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 warehousing.
Database design.
Data warehousing. (OCoLC)fst00888026
Database design. (OCoLC)fst00888032
Genre/Form Electronic books.
Added Author Caserta, Joe, 1965-
Other Form: Print version: Kimball, Ralph. Data warehouse ETL toolkit. Indianapolis, IN : Wiley, ©2004 0764567578 (DLC) 2004016909 (OCoLC)56012371
ISBN 0764579231 (electronic bk.)
9780764579233 (electronic bk.)
0764567578 (paper/website)
9780764567575 (paper/website)
Standard No. AU@ 000043265327
AU@ 000053224531
CHBIS 006152507
CHBIS 009921570
CHVBK 171213386
CHVBK 302162070
DEBSZ 355428644
DEBSZ 396058892
DKDLA 820120-katalog:000576040
HEBIS 291499864
NZ1 13925117

Available items only