The data warehouse toolkit [[electronic resource] ] : the definitive guide to dimensional modeling / / Ralph Kimball, Margy Ross |
Autore | Kimball Ralph |
Edizione | [3rd ed.] |
Pubbl/distr/stampa | Indianapolis, Ind., : Wiley, c2013 |
Descrizione fisica | 1 online resource (601 p.) |
Disciplina | 658.40380285574 |
Altri autori (Persone) | RossMargy |
Soggetto topico |
Data warehousing
Business enterprises - Data processing |
Soggetto genere / forma | Electronic books. |
ISBN |
1-118-73228-6
1-118-53077-2 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; 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
Business 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 Agile 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 Accumulating 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 Conformed 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 Fixed Depth Positional Hierarchies |
Record Nr. | UNINA-9910452802803321 |
Kimball Ralph | ||
Indianapolis, Ind., : Wiley, c2013 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
The data warehouse toolkit : the definitive guide to dimensional modeling / / Ralph Kimball, Margy Ross |
Autore | Kimball Ralph |
Edizione | [Third edition] |
Pubbl/distr/stampa | Indianapolis, Ind. : , : Wiley, , [2013] |
Descrizione fisica | 1 online resource (601 p.) |
Disciplina | 658.40380285574 |
Altri autori (Persone) | RossMargy |
Soggetto topico |
Gestor de dades
Empreses - Informàtica Data warehousing Business enterprises - Data processing |
ISBN |
1-118-73228-6
1-118-53077-2 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; 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
Business 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 Agile 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 Accumulating 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 Conformed 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 Fixed Depth Positional Hierarchies |
Record Nr. | UNINA-9910779708303321 |
Kimball Ralph | ||
Indianapolis, Ind. : , : Wiley, , [2013] | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
The data warehouse toolkit : the definitive guide to dimensional modeling / / Ralph Kimball, Margy Ross |
Autore | Kimball Ralph |
Edizione | [Third edition] |
Pubbl/distr/stampa | Indianapolis, Ind., : Wiley, c2013 |
Descrizione fisica | 1 online resource (601 p.) |
Disciplina | 658.40380285574 |
Altri autori (Persone) | RossMargy |
Soggetto topico |
Gestor de dades
Empreses - Informàtica Data warehousing Business enterprises - Data processing |
ISBN |
9781118732281
1118732286 9781118530771 1118530772 |
Classificazione | 007.6 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; 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
Business 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 Agile 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 Accumulating 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 Conformed 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 Fixed Depth Positional Hierarchies |
Altri titoli varianti | Definitive guide to dimensional modeling |
Record Nr. | UNINA-9910824342703321 |
Kimball Ralph | ||
Indianapolis, Ind., : Wiley, c2013 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
The Kimball Group reader : relentlessly practical tools for data warehousing and business intelligence : remastered collection / / Ralph Kimball [and four others] |
Autore | Kimball Ralph |
Edizione | [2nd ed.] |
Pubbl/distr/stampa | Indianapolis, Indiana : , : Wiley, , 2016 |
Descrizione fisica | 1 online resource (966 p.) |
Disciplina | 658.40380285574 |
Soggetto topico |
Data warehousing
Business intelligence |
Soggetto genere / forma | Electronic books. |
ISBN |
1-119-23879-X
1-119-22891-3 1-119-21659-1 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Table of Contents; Introduction; Intended Audience and Goals; Preview of Contents; Navigation Aids; Terminology Notes; Chapter 1: The Reader at a Glance; Setting Up for Success; Tackling DW/BI Design and Development; Chapter 2: Before You Dive In; Before Data Warehousing; Historical Perspective; Dealing with Demanding Realities; Chapter 3: Project/Program Planning; Professional Responsibilities; Justification and Sponsorship; Kimball Methodology; Chapter 4: Requirements Definition; Gathering Requirements; Organizing around Business Processes; Wrapping Up the Requirements
Chapter 5: Data ArchitectureMaking the Case for Dimensional Modeling; Enterprise Data Warehouse Bus Architecture; Agile Project Considerations; Integration Instead of Centralization; Contrast with the Corporate Information Factory; Chapter 6: Dimensional Modeling Fundamentals; Basics of Dimensional Modeling; Dos and Don'ts; Myths about Dimensional Modeling; Chapter 7: Dimensional Modeling Tasks and Responsibilities; Design Activities; Design Review Activities; Chapter 8: Fact Table Core Concepts; Granularity; Types of Fact Tables; Parent-Child Fact Tables Fact Table Keys and Degenerate DimensionsMiscellaneous Fact Table Design Patterns; Chapter 9: Dimension Table Core Concepts; Dimension Table Keys; Date and Time Dimension Considerations; Miscellaneous Dimension Patterns; Slowly Changing Dimensions; Chapter 10: More Dimension Patterns and Considerations; Snowflakes, Outriggers, and Bridges; Dealing with Hierarchies; Customer Issues; Addresses and International Issues; Industry Scenarios and Idiosyncrasies; Chapter 11: Back Room ETL and Data Quality; Planning the ETL System; Data Quality Considerations; Populating Fact and Dimension Tables Supporting Real TimeChapter 12: Technical Architecture Considerations; Overall Technical/System Architecture; Presentation Server Architecture; Front Room Architecture; Metadata; Infrastructure and Security Considerations; Chapter 13: Front Room Business Intelligence Applications; Delivering Value with Business Intelligence; Implementing the Business Intelligence Layer; Mining Data to Uncover Relationships; Dealing with SQL; Chapter 14: Maintenance and Growth Considerations; Deploying Successfully; Sustaining for Ongoing Impact; Chapter 15: Final Thoughts; Key Insights and Reminders A Look to the FutureArticle Index; Index; End User License Agreement |
Record Nr. | UNINA-9910136431203321 |
Kimball Ralph | ||
Indianapolis, Indiana : , : Wiley, , 2016 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
The Kimball Group reader : relentlessly practical tools for data warehousing and business intelligence : remastered collection / / Ralph Kimball [and four others] |
Autore | Kimball Ralph |
Edizione | [2nd ed.] |
Pubbl/distr/stampa | Indianapolis, Indiana : , : Wiley, , 2016 |
Descrizione fisica | 1 online resource (966 p.) |
Disciplina | 658.40380285574 |
Soggetto topico |
Data warehousing
Business intelligence |
ISBN |
1-119-23879-X
1-119-22891-3 1-119-21659-1 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Table of Contents; Introduction; Intended Audience and Goals; Preview of Contents; Navigation Aids; Terminology Notes; Chapter 1: The Reader at a Glance; Setting Up for Success; Tackling DW/BI Design and Development; Chapter 2: Before You Dive In; Before Data Warehousing; Historical Perspective; Dealing with Demanding Realities; Chapter 3: Project/Program Planning; Professional Responsibilities; Justification and Sponsorship; Kimball Methodology; Chapter 4: Requirements Definition; Gathering Requirements; Organizing around Business Processes; Wrapping Up the Requirements
Chapter 5: Data ArchitectureMaking the Case for Dimensional Modeling; Enterprise Data Warehouse Bus Architecture; Agile Project Considerations; Integration Instead of Centralization; Contrast with the Corporate Information Factory; Chapter 6: Dimensional Modeling Fundamentals; Basics of Dimensional Modeling; Dos and Don'ts; Myths about Dimensional Modeling; Chapter 7: Dimensional Modeling Tasks and Responsibilities; Design Activities; Design Review Activities; Chapter 8: Fact Table Core Concepts; Granularity; Types of Fact Tables; Parent-Child Fact Tables Fact Table Keys and Degenerate DimensionsMiscellaneous Fact Table Design Patterns; Chapter 9: Dimension Table Core Concepts; Dimension Table Keys; Date and Time Dimension Considerations; Miscellaneous Dimension Patterns; Slowly Changing Dimensions; Chapter 10: More Dimension Patterns and Considerations; Snowflakes, Outriggers, and Bridges; Dealing with Hierarchies; Customer Issues; Addresses and International Issues; Industry Scenarios and Idiosyncrasies; Chapter 11: Back Room ETL and Data Quality; Planning the ETL System; Data Quality Considerations; Populating Fact and Dimension Tables Supporting Real TimeChapter 12: Technical Architecture Considerations; Overall Technical/System Architecture; Presentation Server Architecture; Front Room Architecture; Metadata; Infrastructure and Security Considerations; Chapter 13: Front Room Business Intelligence Applications; Delivering Value with Business Intelligence; Implementing the Business Intelligence Layer; Mining Data to Uncover Relationships; Dealing with SQL; Chapter 14: Maintenance and Growth Considerations; Deploying Successfully; Sustaining for Ongoing Impact; Chapter 15: Final Thoughts; Key Insights and Reminders A Look to the FutureArticle Index; Index; End User License Agreement |
Record Nr. | UNINA-9910830844203321 |
Kimball Ralph | ||
Indianapolis, Indiana : , : Wiley, , 2016 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
The Kimball Group reader [[electronic resource] ] : relentlessly practical tools for data warehousing and business intelligence / / Ralph Kimball, Margy Ross ; with Bob Becker, Joy Mundy, and Warren Thornthwaite |
Autore | Kimball Ralph |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianpolis, IN, : Wiley, c2010 |
Descrizione fisica | 1 online resource (747 p.) |
Disciplina | 005.74 |
Altri autori (Persone) | RossMargy <1959-> |
Soggetto topico |
Data warehousing
Business intelligence |
Soggetto genere / forma | Electronic books. |
ISBN |
0-470-63392-1
1-282-48211-4 9786612482113 0-470-63053-1 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence; About the Authors; Contents at a Glance; Contents; Introduction; Chapter 1: The Reader at a Glance; Chapter 2: Before You Dive In; Chapter 3: Project/Program Planning; Chapter 4: Requirements Definition; Chapter 5: Data Architecture; Chapter 6: Dimensional Modeling Fundamentals; Chapter 7: Dimensional Modeling Tasks and Responsibilities; Chapter 8: Fact Table Core Concepts; Chapter 9: Dimension Table Core Concepts; Chapter 10: More Dimension Patterns and Case Studies
Chapter 11: Back Room ETL and Data Quality Chapter 12: Technical Architecture Considerations; Chapter 13: Front Room Business Intelligence Applications; Chapter 14: Maintenance and Growth Considerations; Article Index; Index |
Record Nr. | UNINA-9910457250203321 |
Kimball Ralph | ||
Indianpolis, IN, : Wiley, c2010 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
The Kimball Group reader [[electronic resource] ] : relentlessly practical tools for data warehousing and business intelligence / / Ralph Kimball, Margy Ross ; with Bob Becker, Joy Mundy, and Warren Thornthwaite |
Autore | Kimball Ralph |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianpolis, IN, : Wiley, c2010 |
Descrizione fisica | 1 online resource (747 p.) |
Disciplina | 005.74 |
Altri autori (Persone) | RossMargy <1959-> |
Soggetto topico |
Data warehousing
Business intelligence |
ISBN |
0-470-63392-1
1-282-48211-4 9786612482113 0-470-63053-1 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence; About the Authors; Contents at a Glance; Contents; Introduction; Chapter 1: The Reader at a Glance; Chapter 2: Before You Dive In; Chapter 3: Project/Program Planning; Chapter 4: Requirements Definition; Chapter 5: Data Architecture; Chapter 6: Dimensional Modeling Fundamentals; Chapter 7: Dimensional Modeling Tasks and Responsibilities; Chapter 8: Fact Table Core Concepts; Chapter 9: Dimension Table Core Concepts; Chapter 10: More Dimension Patterns and Case Studies
Chapter 11: Back Room ETL and Data Quality Chapter 12: Technical Architecture Considerations; Chapter 13: Front Room Business Intelligence Applications; Chapter 14: Maintenance and Growth Considerations; Article Index; Index |
Record Nr. | UNINA-9910781052703321 |
Kimball Ralph | ||
Indianpolis, IN, : Wiley, c2010 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
The Kimball Group reader : relentlessly practical tools for data warehousing and business intelligence / / Ralph Kimball, Margy Ross ; with Bob Becker, Joy Mundy, and Warren Thornthwaite |
Autore | Kimball Ralph |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianpolis, IN, : Wiley, c2010 |
Descrizione fisica | 1 online resource (747 p.) |
Disciplina | 005.74 |
Altri autori (Persone) | RossMargy <1959-> |
Soggetto topico |
Data warehousing
Business intelligence |
ISBN |
9786612482113
9780470633922 0470633921 9781282482111 1282482114 9780470630532 0470630531 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence; About the Authors; Contents at a Glance; Contents; Introduction; Chapter 1: The Reader at a Glance; Chapter 2: Before You Dive In; Chapter 3: Project/Program Planning; Chapter 4: Requirements Definition; Chapter 5: Data Architecture; Chapter 6: Dimensional Modeling Fundamentals; Chapter 7: Dimensional Modeling Tasks and Responsibilities; Chapter 8: Fact Table Core Concepts; Chapter 9: Dimension Table Core Concepts; Chapter 10: More Dimension Patterns and Case Studies
Chapter 11: Back Room ETL and Data Quality Chapter 12: Technical Architecture Considerations; Chapter 13: Front Room Business Intelligence Applications; Chapter 14: Maintenance and Growth Considerations; Article Index; Index |
Record Nr. | UNINA-9910819175303321 |
Kimball Ralph | ||
Indianpolis, IN, : Wiley, c2010 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|