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 |