CSE532: Theory of Database Systems

Fall 2023

Stony Brook University

News

Final exam: 12/21/2023: 11:15 AM-1:45 PM. Room: Javits 101  and Frey Hall 100.

Homework 5: XML queries for DBLP. Due: 11:59pm, Dec 15. 

Invited talk on Nov 14: Zoom: https://stonybrook.zoom.us/j/97282144073?pwd=bXYwWlArRDVGSU9RUXFONnRhZW01UT09

Recorded lecture on Nov 12: MapReduce Examples: Video; NoSQL: Video 

Homework 4 posted: TEDS data analysis. Due: 11:59pm, Nov 26. 

Nov 7 and 9: Apache Spark and tutorials on Hadoop/Spark/GCP (Zoom only), by. Dr. Furqan Baig (email: fbaig AT cs .stonybrook. edu). 


Homework 1 and 2 review posted at BrightSpace (Content).

Homework 3. posted. Due: 11:59pm, November 1(Oct 29).

Midterm will be on October 24 at the same classroom and time (1-3pm, Engr 145, October 24). 

Homework 2 posted.  Due: 11:59pm, Oct 15.

A guide on installing Db2 on Ubuntu is posted (thank Huy Anh Nguyen for sharing!)

Homework 1 posted. Due: 11:59pm, Sep 26.

Overview

This course covers recent advances in data management systems. Topics include complex queries and optimizations, XML data management, spatial data management, distributed and parallel databases, NoSQL databases, and MapReduce based data processing systems. We will discuss the foundations of data models, transaction models, storage, indexing and querying methods for these data management systems.