Topics in Database Systems: Topic: Main Memory and Embedded DBMS

CS 848, Waterloo, Spring '18

  Instructor:   David Toman (
  Lectures:     Tuesday 03:30-06:20 DC2568 
  Office:       DC 3344, x34777
  Class Info:


The focus of this class is enabling the use of database (mostly relational) technology in areas that are not well served by traditional relational implementations, such as Oracle or DB2. The central theme of the course be centered around conceptual vs. physical database design issues and will demonstrate how advanced physical designs can be used in non-traditional settings, such as main-memory databases and embedded systems. The class also introduces tools that allow executing queries/updates over such advanced physical designs with the goal of competing with hand-crafted C code in performance.


Fundamentals of Physical Design and Query Compilation, David Toman and Grant Weddell, Synthesis Lectures on Data Management, M. Tamer Özsu, Series Editor, Morgan and Claypool Publishers.

You can get an electronic (pdf) copy of the textbook here for free (while on UW campus network), or a hard-copy if you prefer from Amazon.

Class Schedule and Outlines: