1. Data Modelling (10%)
The assignment specification is available in PDF form.
2. Oracle Database Administration (10%)
Part 1 (6 marks)
Due 4pm Friday April 20
Part 2 (14 marks)
Due 4pm Friday May 11
Acting in all respects in the role of a (solitary) DBA working for a commercial company, you must complete tasks and solve problems as presented by your manager and clients. Assessment is formative - the problems presented will build on experience gained in solving previous problems. It runs over a number of weeks, and you will need to establish a working database in the early stages in order to have time to progress through the problems. Part 1 (due April 20th) is worth 6 marks and Part 2 (due on May 11th) is worth 14 marks - a total of 20 marks for 10% of marks towards finals.
3. Project (20%)
To understand some of the latest developments in the field of Database research and to develop: critical thinking and logical, structured, coherent writing.
You must choose one of the following topics for your project.
- Distributed Databases
- Spanner: Google's globally distributed database (Google)
- Data Mining
- Fast Algorithms for Mining Association Rules
- Timeseries Databases
- Gorilla: A Fast, Scalable, In-Memory Time Series Database (Facebook)
- Graph Databases
- Trinity: A distributed graph engine on a memory cloud (Microsoft)
Your assignment for this project involves researching one of the above topics in more detail. You will need to perform the following tasks:
- Read the required reading
- Contribute to the in-class discussion
- Write a report on the reading
- Find a recent (in the last 5 years) research article (from one of the sources below) that describes a new technique with respect to the topic at hand
- Write a review
Submit for assessment the report, your chosen article, and your review. You must submit your report as a PDF (we suggest you use LaTeX for this task). Your references/citations must follow the IEEE Citation Style.
You should find your articles from the following journals and/or conferences.
- ACM Transactions on Database Systems
- Data and Knowledge Engineering
- ACM Special Interest Group on Management of Data
- ACM Principles of Database Systems
- Very Large Databases
- IEEE International Conference on Data Engineering
Your projects would be assessed based on your explanation and your understanding of the problem in the given paper, your review of relevant research, and your ability to present their argument. In other words it is less about the practical ability.