S1 2019

Week Topics toggle topics for , , or ) Total Marks
25 February
Data Modeling: An Overiew
Haibo Zhang
4 March
Relational Model
Haibo Zhang
11 March
Oracle Database Administration
Marks: None
  • Introduction to Database Adminstration with Oracle 8
18 March
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.
25 March
Distributed Models
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.
1 April
Marks: None
  • An introduction on Cassandra (
  • An introduction on docker and vagrant (
8 April
Haibo Zhang
15 April
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.
22 April
29 April
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
6 May
Marks: None
13 May
Marks: None
20 May
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.
David Eyers
  • Security & Privacy
  • Datalake
  • Real-time stream processing
  • Blockchain
  • Performance Issues
  • Future Research Topics
27 May
Guest Lecture TBA