Teaching team

Lecture

• Assoc. Prof. David Taniar: [email protected]

Tutors

• Arthur Lyu (Head Tutor): [email protected]
• Jay Zhou (Head Tutor): [email protected]

Topics - Data Engineeringand Geospatial Databases

Part I: Data Engineering (Week 1–6)

• Introduction to Data Engineering
• Data Transformation and Data Warehousing
• Data Cleaning and Data Preparation
• Data Granularity

Part II: Geospatial Data Processing (Week 7–12)

• Overview of Spatial Databases
• Spatial Querying and Functions
• Maps, Roads and Trajectories

Assessments

Assignment 1 (10%) – Data Engineering Online Quiz 1. Design and implementation of a simple star schema 2. Materials: lectures and labs from week 1-3

Assignment 2 (40%) – Data Engineering Assignment (Individual) 1. Report, poster and video presentation 2. Materials: lectures and labs from week 1-6

Assignment 3 (35%) – Geospatial Assignment (Individual) 1. Geospatial data analysis  2. Report and video presentation 3. Materials: lectures and labs from week 7-12

Assignment 4 (15%) – Geospatial Online Quiz 1. Spatial SQL, geospatial databases 2. Materials: lectures and labs from week 7-12

Sample work on geospatical analysis

Resources and Tools

Data Warehousing Book 1. The tutors will guide you in the first lab on how to access the book from the library.

Tools 1. Oracle DBMS 2. Any SQL client (e.g. DBeaver, VS Code, or SQL Developer) 3. PostGIS, DBeaver, QGIS 4. Docker 5. Trajectory Apps