000 05559cam a22006854a 4500
001 u369742
003 SIRSI
005 20160812080009.0
006 m o d
007 cr cnu|||unuuu
008 041220s2004 inua o 001 0 eng d
040 _aNT
_beng
_cNT
_dOCLCQ
_dYDXCP
_dOCLCG
_dOCLCQ
_dOCLCO
_dOCLCQ
_dC6I
_dOCLCF
_dNTG
_dEXW
_dTEFOD
_dIDEBK
_dEBLCP
_dUMI
_dCEF
_dOCLCE
_dE7B
_dU5D
_dB24X7
_dDEBSZ
_dREDDC
019 _a57305952
_a61454230
_a71826424
_a354466131
_a488811608
_a606028809
_a608061498
_a645910244
_a775998448
020 _a0764579231 (electronic bk.)
020 _a9780764579233 (electronic bk.)
020 _a0764567578 (paper/website)
020 _a9780764567575 (paper/website)
042 _adlr
050 4 _aQA76.9.D37
_bK53 2004eb
082 0 4 _a005.74
_222
084 _aDAT 620f
_2stub
084 _aST 530
_2rvk
049 _aMAIN
100 1 _aKimball, Ralph.
245 1 4 _aThe data warehouse ETL toolkit
_h[recurso electrónico] :
_bpractical techniques for extracting, cleaning, conforming, and delivering data /
_cRalph Kimball, Joe Caserta.
260 _aIndianapolis, IN :
_bWiley,
_cc2004.
300 _a1 online resource (xxxiv, 491 p.) :
_bill.
336 _atext
_btxt
_2rdacontent
337 _acomputer
_bc
_2rdamedia
338 _aonline resource
_bcr
_2rdacarrier
500 _aIncludes index.
588 _aDescription based on print version record.
520 8 _aAnnotation
_bCowritten 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.
505 0 0 _tRequirements, Realities, and Architecture --
_tSurrounding the Requirements --
_tThe Mission of the Data Warehouse --
_tThe Mission of the ETL Team --
_tETL Data Structures --
_tTo Stage or Not to Stage --
_tDesigning the Staging Area --
_tData Structures in the ETL System --
_tPlanning and Design Standards --
_tData Flow --
_tExtracting --
_tThe Logical Data Map --
_tBuilding the Logical Data Map --
_tIntegrating Heterogeneous Data Sources --
_tThe Challenge of Extracting from Disparate Platforms --
_tMainframe Sources --
_tFlat Files --
_tXML Sources --
_tWeb Log Sources --
_tERP System Sources --
_tExtracting Changed Data --
_tCleaning and Conforming --
_tDefining Data Quality --
_tAssumptions --
_tDesign Objectives --
_tCleaning Deliverables --
_tScreens and Their Measurements --
_tConforming Deliverables --
_tDelivering Dimension Tables --
_tThe Basic Structure of a Dimension --
_tThe Grain of a Dimension --
_tThe Basic Load Plan for a Dimension --
_tFlat Dimensions and Snowflaked Dimensions --
_tDate and Time Dimensions --
_tBig Dimensions --
_tSmall Dimensions --
_tOne Dimension or Two --
_tDimensional Roles --
_tDimensions as Subdimensions of Another Dimension --
_tDegenerate Dimensions --
_tSlowly Changing Dimensions --
_tType 1 Slowly Changing Dimension (Overwrite) --
_tType 2 Slowly Changing Dimension (Partitioning History) --
_tPrecise Time Stamping of a Type 2 Slowly Changing Dimension --
_tType 3 Slowly Changing Dimension (Alternate Realities) --
_tHybrid Slowly Changing Dimensions --
_tLate-Arriving Dimension Records and Correcting Bad Data --
_tMultivalued Dimensions and Bridge Tables.
506 _3Use copy
_fRestrictions unspecified
_2star
_5MiAaHDL
533 _aElectronic reproduction.
_b[S.l.] :
_cHathiTrust Digital Library,
_d2010.
650 0 _aData warehousing.
650 0 _aDatabase design.
650 7 _aCOMPUTERS
_xDesktop Applications
_xDatabases.
_2bisacsh
650 7 _aCOMPUTERS
_xDatabase Management
_xGeneral.
_2bisacsh
650 7 _aCOMPUTERS
_xSystem Administration
_xStorage & Retrieval.
_2bisacsh
655 4 _aElectronic books.
650 7 _aData warehousing.
_2fast
_0(OCoLC)fst00888026
650 7 _aDatabase design.
_2fast
_0(OCoLC)fst00888032
650 4 _aElectronic book collection.
650 6 _aEntrepôts de données (Informatique)
650 6 _aBases de données
_xConception.
650 7 _aData warehousing.
_2local
650 7 _aDatabase design.
_2local
650 0 7 _aData-Warehouse-Konzept.
_2swd
700 1 _aCaserta, Joe,
_d1965-
776 0 8 _iPrint version:
_aKimball, Ralph.
_tData warehouse ETL toolkit.
_dIndianapolis, IN : Wiley, c2004
_z0764567578
_w(DLC) 2004016909
_w(OCoLC)56012371
856 4 0 _zLibro electrónico
_uhttp://148.231.10.114:2048/login?url=http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&an=124355
596 _a19
942 _cLIBRO_ELEC
999 _c197944
_d197944