• Home
  • Project
    Introduction
    • Introduction
    • Background and Motivation
    • What is a Good Timetable?
    • Project Aims and Scope
  • Graph Data
    Model
    • Graph vs Relational Data Models
    • Graph Data Model for Timetabling
    • Early Insights
    • Model Expansion
    • Graphing Time
  • Data
    Pipeline
    • ETL Overview
    • Approach
    • Configuration and Logging
    • Extract
    • Transform
    • Google Drive Load
    • Neo4j Load
    • Reflection
  • Timetable
    Metrics
    • Timetable Metrics
    • Metric Aggregations
    • Implementing Metrics
    • TQI Summary
  • Final
    Thoughts
  • Appendices
    & Extras
    • Appendix Table of Contents
    • References
    • Acknowledgements
  • Word
  1. Appendix: Table of Contents
  • Home
  • Project Introduction
    • Introduction
    • Background and Motivation
    • What is a Good Timetable?
    • Project Aims and Scope
  • Graph Data Model
    • Graph vs Relational Data Models
    • Graph Data Model for Timetabling
    • Early Insights
    • Model Expansion
    • Graphing Time
  • Data Pipeline
    • ETL Overview
    • Approach
    • Configuration and Logging
    • Extract
    • Transform
    • Google Drive Load
    • Neo4j Load
    • Reflection
  • Timetable Metrics
    • Timetable Metrics
    • Metric Aggregations
    • Implementing Metrics
    • TQI Summary
  • Final Thoughts
  • Appendices
    • Random Graph Generator
    • Technology Stack
    • Configuration
    • Anonymisation
    • ETL Summary and Code
      • ETL Summary
      • ETL Code
      • Config and Misc
      • Extract-SQL
      • Extract
      • Google Drive Load
      • Transform
      • Neo4j Load
    • Neo4j & Cypher Code
      • Cypher Queries
      • Creating Nodes and Relationships
      • Deleting Nodes and Relationships
      • General Queries
      • Count Queries
      • Hard (timetabling) Constraints
      • Student Clashes
      • Soft Constraints
      • Rooms and Spaces
      • Perspectives
      • Blue Skies Opportunities
  • Supervision
    • Supervision
    • Notes Example 1
    • Notes Example 2
    • Notes Example 3
  • References
  • Acknowledgements

Appendix: Table of Contents

This project contains a significant amount of information in appendices. It was always my intention to provide well-documented code and detailed explanations of the data engineering process, the Cypher queries, etc.

The appendices are listed below:

General

A. Random Graph Generator

B. Technology Stack

C. Configuration

D. Anonymisation

Data Engineering

E. ETL Summary

F. ETL Code

G. Config and Misc

H. Extract-SQL

I. Extract

J. Google Drive Load

K. Transform

L. Neo4j Load

Cypher Queries

M. Cypher Queries

N. Creating Nodes and Relationships

O. Deleting Nodes and Relationships

P. General Queries

Q. Count Queries

R. Hard (timetabling) Constraints

S. Student Clashes

T. Soft Constraints

U. Rooms and Spaces

V. Perspectives

Supervision

W. Supervision

X. Notes Example 1

Y. Notes Example 2

Z. Notes Example 3

Copyright 2024, Petter Lövehagen

 

Built with Quarto