> Detailanzeige

Kimball, Ralph [VerfasserIn] ; Ross, Margy [Sonstige Person, Familie und Körperschaft]

The data warehouse toolkit : the definitive guide to dimensional modeling - [3. ed.]

Literatur-
verwaltung

Zur
Merkliste

Lösche von
Merkliste

Per Whatsapp teilen

Schließen

Merkliste



Sie können Bookmarks mittels Listen verwalten, loggen Sie sich dafür bitte in Ihr SLUB Benutzerkonto ein.
  • Medientyp: E-Book
  • Titel: The data warehouse toolkit : the definitive guide to dimensional modeling
  • Enthält: 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
  • Beteiligte: Kimball, Ralph [VerfasserIn]; Ross, Margy [Sonstige Person, Familie und Körperschaft]
  • Erschienen: Indianapolis, Ind.: Wiley, 2013
  • Ausgabe: 3. ed.
  • Umfang: Online-Ressource
  • Sprache: Englisch
  • ISBN: 1118530802; 9781299731844; 1299731848; 9781118732281; 9781118732199; 9781118530771; 9781118530801
  • RVK-Notation: ST 530 : Data-warehouse-Konzept; Data mining
    QH 500 : Wirtschaftsinformatik. Datenverarbeitung. Allgemeines
  • Schlagwörter: Data-Warehouse-Konzept
  • Entstehung:
  • Anmerkungen:
  • Beschreibung: Updated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing and business intelligence!The first edition of Ralph Kimball'sThe Data Warehouse Toolkitintroduced 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 and expanded business matrices for 12 case studies, and more.Authored by Ralph Kimball and Margy Ross, known worldwide as educators, consultants, and influential thought leaders in data warehousing and business intelligenceBegins with fundamental design recommendations and progresses through increasingly complex scenariosPresents unique modeling techniques for business applications such as inventory management, procurement, invoicing, accounting, customer relationship management, big data analytics, and moreDraws real-world case studies from a variety of industries, including retail sales, financial services, telecommunications, education, health care, insurance, e-commerce, and moreDesign dimensional databases that are easy to understand and provide fast query response withThe Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition. RALPH KIMBALL, PhD, has been a leading visionary in the data warehouse and business intelligence industry since 1982. The Data Warehouse Toolkitbook series have been bestsellers since 1996.MARGY ROSS is President of the Kimball Group and the coauthor of five Toolkit books with Ralph Kimball. She has focused exclusively on data warehousing and business intelligence for more than 30 years.