Skip to content

DWH Tables

Jump to bottom
Luca Bösch edited this page Jun 20, 2023 · 2 revisions

Documentation about the modeling of the tables inside the Data Warehouse

The tables inside the different areas of the data warehouse are modeled with purpose and they follow a logic sequence building up on each other.

In the STAGING area, the data from the quiz activity come in as large table with many rows. Then, when pulled into the following areas, the structure changes. Using the "Data vault" data warehouse modelling approach, tables for hubs, links and satellites are used. Hub tables are containing the main entities. Link tables provide the information needed to relate hubs to each others. In satellite tables, additional properties of the hub entities are saved, sometimes satellite tables can also refer to link tables.

Those are the tables in the "Cleansing" area that refer to Moodle quizzes, questions, and attempts:

Diagram of the tables in the CLEANSING area

Documentation:

  1. Wiki Home

  2. Moodle plugin installation
    Installation instructions for the Moodle plugin

  3. Data warehouse setup
    Setup instructions for the data warehouse

  4. Queries for the Data Warehouse side Queries available to be run in the Data Warehouse part of the system

  5. Queries for the Moodle side
    Queries available to be run in the Moodle part of the system

  6. Documentation regarding the Moodle Database and Moodle functionalities Documentation about the inner mechanics of the Moodle LMS system

  7. Structure of tables in the Data Warehouse Documentation about the modeling of the tables inside the Data Warehouse

Clone this wiki locally