Database and Big Data Systems (2021)
- When:
- Lectures: Monday 3-6pm
- Tutorials: Wednesday 9-11am (Cohort 1), 11.30-1.30pm (Cohort 2), Thursday 6-8pm (Cohort 3)
- Where: Zoom
- Instructors:
- Teaching Assistant: Daniel Petrus Reijsbergen
Course Description
Database systems manage data which is at the heart of modern computing applications. This course covers the fundamentals of traditional databases, such as Oracle and MySQL, and core ideas of recent big data systems.
Students will learn important problems in data management that these systems are designed to solve. They will experience with the internal design and implementation of relational databases. They will also understand the internals of state‐of‐the‐art big data platforms, namely Apache Spark, and use them on Amazon cloud (Amazon Web Service). The students will be able to determine the advantages and limitations of different database systems.
Resources
The main resources are lecture slides, tutorial sessions, and online documentations. There are no official textbooks. But the following are useful for reference and deeper understanding of some topics.
- Abraham Siberschatz, Henry Korth, S Sudarshan. Databse System Concepts. 6th edition.
- Raghu Ramakrishnan, Johannes Gehrke. Database management systems. 3rd edition
- Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom. Database systems, the complete book. 2nd edition.
Grading
Your final grade is computed as follows:
-
Homework: 12%
There will be 2 homework assignments, 6 points each.
-
Project: 60%
Group project, up to 3 per group. Unless notifying the instructors otherwise, all group members have the same grade for the project.
-
Class participation: 3%
Ask/answer questions during classes, spot mistakes, etc.
-
Final: 25%
Project
Check out the Project page for more details.
Contact
Email the instructors any questions regarding the course content and logistics. Email Daniel if you have questions or need help with homeworks and projects.
Late Policy
No late submission.
Academic Integrity
You can discuss solution and code with your friends. But you cannot copy other people’s code, including codes on the Internet. We will run project submission through a plagiarism checker.