COSC430

Schedule

S1 2020

Recordings of lectures are available through an Echo 360 section.

Week	Topics toggle topics for lectures, labs, or everything) Total Marks
1 (24 February)	Data Modeling: An Overiew David Eyers
2	Relational Model David Eyers
3	Oracle Database Administration Cathy Chandra Introduction to Database Adminstration with Oracle 8
4	Assignment 1 Due Submit by 4pm Friday Read Spanner before next class, come prepared to discuss the paper. NoSQL, Key-Value, Document David Eyers M. Stonebraker, et. al., “The End of an Architectural Era (It’s Time for a Complete Rewrite),” Vldb, vol. 12, no. 2, pp. 1150–1160, 2007. A. Pavlo and M. Aslett, “What’s Really New with NewSQL?,” ACM SIGMOD Rec., vol. 45, no. 2, pp. 45–55, 2016. G. DeCandia, et. al., “Dynamo: Amazon’s Highly Available Key-value Store,” Proc. Symp. Oper. Syst. Princ., pp. 205–220, 2007. L. Qiao, et. al., “On brewing fresh espresso: LinkedIn’s distributed data serving platform,” SIGMOD, 2013. A. Auradkar, et. al., “Data infrastructure at LinkedIn,” ICDE, 2012.
5	Part 1 of Assignment 2 Due Submit by 5pm Friday Discuss Spanner. The in class discussion is available as a recording. Distributed Models David Eyers Arthur L. Corcoran, John Hale, A genetic algorithm for fragment allocation in a distributed database system, Proceedings of the 1994 ACM symposium on Applied Computing.
6	Read Apriori before next class, come prepared to discuss the paper. Cassandra An introduction on Cassandra (https://www.youtube.com/watch?v=5qEoEAfAer8) An introduction on docker and vagrant (https://www.youtube.com/watch?v=9QGkJvbLpRA)
7	Read Gorilla before next class, come prepared to discuss the paper. Discuss Apriori. Notes taken during class. This file is provided for your interest only, and you must do your own work for any related assignment material. The content has not been curated. Also, the content can still be edited by anyone who creates a (free) HackMD account. Revisions are tracked, and the content has been backed up. Mining David Eyers
	Easter Break
8	Read Trinity before next class, come prepared to discuss the paper. Discuss Gorilla. Notes taken during class. This file is provided for your interest only, and you must do your own work for any related assignment material. The content has not been curated. Also, the content can still be edited by anyone who creates a (free) HackMD account. Revisions are tracked, and the content has been backed up. Timeseries David Eyers M. P. Andersen and D. E. Culler, “BTrDB: Optimizing Storage System Design for Timeseries Processing,” FAST, 2016. T. Dunning and E. Friedman, Time Series Databases New Ways to Store and Access Data. 2014.
9	ANZAC Day public holiday
10	Discuss Trinity. Notes taken during class. This file is provided for your interest only, and you must do your own work for any related assignment material. The content has not been curated. Also, the content can still be edited by anyone who creates a (free) HackMD account. Revisions are tracked, and the content has been backed up. Graph David Eyers N. Bronson, et. al., “TAO: Facebook’s distributed data store for the social graph,” Usenix ATC’13, pp. 49–60, 2013. Graph Databases: New Opportunities for Connected Data
11	Neo4j David Eyers
12	Part 2 of Assignment 2 Due Submit by 4pm Friday Embedded/ORM David Eyers
13	Assignment 3 Due Submit by 10am Monday Final Week Temporal/Geographic David Eyers R. Snodgrass, “Developing time-oriented database applications in SQL,” 2000. P. Vanroose, “Temporal Data & Time Travel in PostgreSQL,” no. January, 2015 F. Zemke, “What's new in SQL:2011,” ACM SIGMOD Rec., vol. 41, no. 1, p. 67, 2012. K. Kulkarni and J. Michels, “Temporal features in SQL: 2011,” ACM SIGMOD Rec., vol. 41, no. 3, pp. 34–43, 2012.