COSC430

Schedule

S1 2018

Week Topics toggle topics for , , or ) Total Marks
26 February
Data Models
Haibo Zhang
5 March
Relational Models
Haibo Zhang
12 March
NoSQL, Key-Value, Document
Paul Crane
  • 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.
19 March
Distributed
Haibo Zhang
  • 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.
26 March
Oracle Database Administration
Marks: None
  • Introduction to Database Adminstration with Oracle 8
2 April
9 April
Cassandra
Marks: None
  • An introduction on Cassandra (https://www.youtube.com/watch?v=5qEoEAfAer8)
  • An introduction on docker and vagrant (https://www.youtube.com/watch?v=9QGkJvbLpRA)
16 April
Data Mining
Haibo Zhang
23 April
Timeseries
Paul Crane
  • 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.
30 April
Graph
Paul Crane
  • 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
7 May
Neo4j
Marks: None
  • Introduction to graph databases using Neo4j
14 May
Embedded/ORM
Marks: None
21 May
Temporal/Geographic
Paul Crane
  • 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.
Hotch-potch
Paul Crane
  • Security & Privacy
  • Data warehouse
  • Real-time stream processing
  • Performance Issues
28 May
Guest Lecture TBA