LEADER 05522nam 2200733 a 450 001 9910824342703321 005 20240509193206.0 010 $a9781118732281 010 $a1118732286 010 $a9781118530771 010 $a1118530772 035 $a(MiAaPQ)EBC1313513 035 $a(PPN)261608258 035 $a(CaSebORM)9781118530801 035 $a(OCoLC)859154376 035 $a(OCoLC)ocn859154376 035 $a(CKB)2550000001105803 035 $a(OCoLC)857076649 035 $a(FINmELB)ELB179299 035 $a(EXLCZ)992550000001105803 100 $a20150303d2013 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 14$aThe data warehouse toolkit $ethe definitive guide to dimensional modeling /$fRalph Kimball, Margy Ross 205 $aThird edition 210 $aIndianapolis, Ind. $cWiley$dc2013 210 1$aIndianapolis, Ind. :$cWiley,$d[2013] 210 4$d©2013 215 $a1 online resource (601 p.) 300 $aIncludes index. 311 1 $a9781118530801 311 1 $a1118530802 311 1 $a9781299731844 311 1 $a1299731848 327 $aCover; Title Page; Copyright; Contents; 1 Data Warehousing, Business Intelligence, and Dimensional Modeling Primer; Different Worlds of Data Capture and Data Analysis; Goals of Data Warehousing and Business Intelligence; Publishing Metaphor for DW/BI Managers; Dimensional Modeling Introduction; Star Schemas Versus OLAP Cubes; Fact Tables for Measurements; Dimension Tables for Descriptive Context; Facts and Dimensions Joined in a Star Schema; Kimball's DW/BI Architecture; Operational Source Systems; Extract, Transformation, and Load System; Presentation Area to Support Business Intelligence 327 $aBusiness Intelligence ApplicationsRestaurant Metaphor for the Kimball Architecture; Alternative DW/BI Architectures; Independent Data Mart Architecture; Hub-and-Spoke Corporate Information Factory Inmon Architecture; Hybrid Hub-and-Spoke and Kimball Architecture; Dimensional Modeling Myths; Myth 1: Dimensional Models are Only for Summary Data; Myth 2: Dimensional Models are Departmental, Not Enterprise; Myth 3: Dimensional Models are Not Scalable; Myth 4: Dimensional Models are Only for Predictable Usage; Myth 5: Dimensional Models Can't Be Integrated; More Reasons to Think Dimensionally 327 $aAgile ConsiderationsSummary; 2 Kimball Dimensional Modeling Techniques Overview; Fundamental Concepts; Gather Business Requirements and Data Realities; Collaborative Dimensional Modeling Workshops; Four-Step Dimensional Design Process; Business Processes; Grain; Dimensions for Descriptive Context; Facts for Measurements; Star Schemas and OLAP Cubes; Graceful Extensions to Dimensional Models; Basic Fact Table Techniques; Fact Table Structure; Additive, Semi-Additive, Non-Additive Facts; Nulls in Fact Tables; Conformed Facts; Transaction Fact Tables; Periodic Snapshot Fact Tables 327 $aAccumulating Snapshot Fact TablesFactless Fact Tables; Aggregate Fact Tables or OLAP Cubes; Consolidated Fact Tables; Basic Dimension Table Techniques; Dimension Table Structure; Dimension Surrogate Keys; Natural, Durable, and Supernatural Keys; Drilling Down; Degenerate Dimensions; Denormalized Flattened Dimensions; Multiple Hierarchies in Dimensions; Flags and Indicators as Textual Attributes; Null Attributes in Dimensions; Calendar Date Dimensions; Role-Playing Dimensions; Junk Dimensions; Snowflaked Dimensions; Outrigger Dimensions; Integration via Conformed Dimensions 327 $aConformed DimensionsShrunken Dimensions; Drilling Across; Value Chain; Enterprise Data Warehouse Bus Architecture; Enterprise Data Warehouse Bus Matrix; Detailed Implementation Bus Matrix; Opportunity/Stakeholder Matrix; Dealing with Slowly Changing Dimension Attributes; Type 0: Retain Original; Type 1: Overwrite; Type 2: Add New Row; Type 3: Add New Attribute; Type 4: Add Mini-Dimension; Type 5: Add Mini-Dimension and Type 1 Outrigger; Type 6: Add Type 1 Attributes to Type 2 Dimension; Type 7: Dual Type 1 and Type 2 Dimensions; Dealing with Dimension Hierarchies 327 $aFixed Depth Positional Hierarchies 330 $aUpdated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing and business intelligence! The first edition of Ralph Kimball's The Data Warehouse Toolkit introduced the industry to dimensional modeling, and now his books are considered the most authoritative guides in this space. This new third edition is a complete library of updated dimensional modeling techniques, the most comprehensive collection ever. It covers new and enhanced star schema dimensional modeling patterns, adds two new chapters on ETL techniques, includes new an 517 3 $aDefinitive guide to dimensional modeling 606 $aGestor de dades$2lemac 606 $aEmpreses$xInformątica$2lemac 606 $aData warehousing 606 $aBusiness enterprises$xData processing 615 7$aGestor de dades 615 7$aEmpreses$xInformątica 615 0$aData warehousing. 615 0$aBusiness enterprises$xData processing. 676 $a658.40380285574 686 $a007.6$2njb/09 700 $aKimball$b Ralph$0148169 701 $aRoss$b Margy$0148170 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910824342703321 996 $aThe data warehouse toolkit$94103448 997 $aUNINA