DWH Queries
If set up according to the documentation so far, a data warehouse with five schemas, "MONITORING", "STAGING", "CLEANSING", "CORE" and "MART" does exist.
In those schemas, in order to receive the data from the runs of the Moodle queries for the quiz and assignment activity, the according database tables have to be set up beforehand. This section of the documentation deals with those preliminary proceedings.
To enter the frontend to access the worksheet to insert the query to run to create the tables, first access the database as user ADMIN and then change to the STAGING user and STAGING schema with the "Open in new tab" option in a user tile.
As user STAGING, open the SQL Database Actions frontend.
Run the content of the SQL script create_staging_area_tables.sql.
As user CLEANSING, open the SQL Database Actions frontend and run the content of the SQL script create_cleansing_area_tables.sql.
As user CORE, open the SQL Database Actions frontend and run the content of the SQL script create_core_area_tables.sql.
As user MART, open the SQL Database Actions frontend and run the content of the SQL script create_mart_area_tables.sql.
As user MONITORING, open the SQL Database Actions frontend and run the content of the SQL script create_monitoring_area_tables.sql.
As user STAGING, open the SQL Database Actions frontend and run the content of the PLSQL script load_quiz_file_to_stag.plsql making sure a value for the l_CREDENTIAL_NAME has been filled in in line 9 beforehand. Then, run the content of the SQL script grant_to_load_quiz_file_to_stag.sql.