1.

Record Nr.

UNINA9910452802803321

Autore

Kimball Ralph

Titolo

The data warehouse toolkit [[electronic resource] ] : the definitive guide to dimensional modeling / / Ralph Kimball, Margy Ross

Pubbl/distr/stampa

Indianapolis, Ind., : Wiley, c2013

ISBN

1-118-73228-6

1-118-53077-2

Edizione

[3rd ed.]

Descrizione fisica

1 online resource (601 p.)

Altri autori (Persone)

RossMargy

Disciplina

658.40380285574

Soggetti

Data warehousing

Business enterprises - Data processing

Electronic books.

Lingua di pubblicazione

Inglese

Formato

Materiale a stampa

Livello bibliografico

Monografia

Note generali

Includes index.

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

Sommario/riassunto

Updated 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



2.

Record Nr.

UNINA9910851985303321

Titolo

Human-Computer Interaction : 9th Iberoamerican Workshop, HCI-COLLAB 2023, Buenos Aires, Argentina, September 13–15, 2023, Revised Selected Papers / / edited by Pablo H. Ruiz, Vanessa Agredo-Delgado, Alicia Mon

Pubbl/distr/stampa

Cham : , : Springer Nature Switzerland : , : Imprint : Springer, , 2024

ISBN

3-031-57982-8

Edizione

[1st ed. 2024.]

Descrizione fisica

1 online resource (335 pages)

Collana

Communications in Computer and Information Science, , 1865-0937 ; ; 1877

Disciplina

004.019

Soggetti

User interfaces (Computer systems)

Human-computer interaction

Computer networks

Information technology - Management

Coding theory

Information theory

Software engineering

User Interfaces and Human Computer Interaction

Computer Networks

Computer Application in Administrative Data Processing

Coding and Information Theory

Software Engineering

Lingua di pubblicazione

Inglese

Formato

Materiale a stampa

Livello bibliografico

Monografia

Note generali

Includes index.

Nota di contenuto

A case study on teaching HCI to interactive art practitioners and learning from them -- A Multidisciplinary Approach to Developing a Digital Game to Enhance Social Cognition Skills in Adolescents with ASD -- A Multidisciplinary Approach to Developing a Digital Game to Enhance Social Cognition Skills in Adolescents with ASD -- Adaptive Videogames for Education An Initial Study -- An Approach to Cluster Scenarios According to their Similarity using Natural Language Processing -- Applying Design Thinking with Virtual Reality



Applications as a Support for Bachelor Students with Disabilities -- Approach for the feature models definition in software lines based on collaborative work -- Automation of Granollers Heuristic Evaluation Method Using a Developed Support System A Case Study -- Computational playful strategy to measure the level of technological acceptance by older adults -- Design Thinking Empowering Innovation and Transformation in Industry 4.0 Lessons Learned from Early Adoption in SMEs -- Development and Evaluation of a Non Conventional Interaction Wearable Device -- DUXAIT NG A Software for the Planning and Execution of User Experience Evaluations and Experiments -- Eye Tracking-Based Platform for Programming Teaching -- Facial Emotion Recognition with AI -- Human-Computer Interaction Research in Ibero America A bibliometric analysis -- Migration of legacy Java desktop applications to collaborative Web -- Mistakes Hold the Key: Reducing Errors in a Crowdsourced Tumor Annotation Task by Optimizing the Training Strategy -- Personalization and Accessibility in a Digital Repository -- Prompt Engineering An Alternative for Video Game Development -- Redesign of the Dashboard of a Web Telemetry System for decision support -- Scenarios, shared understanding, and group decision support to foster innovation networks -- Social Presence and User Experience The Influence of the Immersive Virtual Classroom in Synchronous Distance Learning -- The Adoption of Industry 4.0 Practices for Small and Medium-sized Companies A systematic mapping study.

Sommario/riassunto

This book constitutes the referred proceedings of the 9th Iberoamerican Workshop on Human-Computer Interaction, HCI-COLLAB 2023, held in Buenos Aires, Argentina, during September 13–15, 2023. The 23 full papers presented in this book were carefully reviewed and selected from 84 submissions. They cover a variety of topics related to HCI such as: Emotional Interfaces, Usability, Video Games and Gamification, Computational Thinking, Internet of Things (IoT), Software Engineering, ICT in Education, Augmented and Mixed Virtual Reality for Education, Emotional Interfaces, Adaptive Instructional Systems, Accessibility, Artificial Intelligence in HCI, Industry 4. 0 and HCI, Infotainment Systems, Intelligent Systems, Collaborative Work and Learning, Cognition, and Interaction, among others.