Topics in Database Systems: main/in-memory database systems
CS 848, Waterloo, Spring '16
Instructor: David Toman (firstname.lastname@example.org)
Lectures: Wed 3:30-6:20 DC 2568
Office: DC 3344, x34777 by appointment
Class Info: http://cs.uwaterloo.ca/~david/cs848/
Course Description and Objectives
This course will focus on trends in main-memory (or in-memory)
database systems (IDMS) and on the ramifications of the availability of large
main memories in modern computer systems.
- Why simply using large memory with a traditional DBMS architectures doesn't work?
- How do IDMS target dierent workloads (e.g., OLTP vs. OLAP),
- How do large memories affect architectural issues related to
- data models and query languages (e.g., SQL vs. NoSQL vs. NewSQL),
- row vs. column stores (and how does this relate to physical data independence),
- query processing and data structures used to store data,
- parallelism for multi-CPU (core) systems,
- transactions and enforcement od ACID properties,
It will be run as a seminar course, meaning that we will be reading and discussing papers.
Projects: Preferred projects will be related to applying
(some) of the ideas presented in this class to your own area of
research: this can further your own research and may help you to
consider alternative views/approaches to what you have been thinking
- project proposal: one page due Lecture 6;
- project presentation: 20-25 minutes (depending on the number of projects) in Week 9-11;
- report (in pdf, up to 10 pages), source code (if applicable) within a week of last Lecture
If you don't see any relation to your own research, here are
a few alternative options.