News

All course materials are protected by copyright. Unauthorized sharing or use for commercial purposes constitutes copyright infringement. 

May 14:  Homework 5: XML Queries (Due: EXTENDED: 11:59pm EST,  May 16, 2025) 

April 21: Homework 4 posted. Due: midnight,  May 4.

April 15: Online tutorial via Zoom.

April 10: Recorded lecture: Apache Spark, by Dr. Furqan Baig.

April 4: Setup Hadoop, Spark and claim your Google Cloud Platform Credit.

Final exam: Humanities 1003, May 13th, 11:15-1:45pm

March 27 lecture will be recorded video.

Homework3 posted (Due: 11:59pm EST, April 7, 2025)

Homework 2 due extended to March 17, 2025 (11:59pm)

March 4: March 6 lecture will be a recorded lecture due to an invited talk at a workshop (no in-person meeting). Please watch the two recorded video on B+-Tree indexing at BrightSpace and post your questions.  

Feb 27: Homework2 stock price analysis Posted (Due: 11:59pm EST, March 16,2025)

Feb 20: No in-person lecture today due to sickness. Please watch the two recorded videos at BrightSpace and post your questions. 

Feb 17: Homework 1: Opioid pills analysis with SQL  (Due: 11:59pm EST, March 2,2025)

Feb 6:  No in-person lecture today due to poor road conditions. Please watch the two recorded videos at BrightSpace and post your questions.  

Jan 21: There is no class on Jan 28 and Jan 30 due to traveling at a conference at San Diego. 

We thank Google for generously supporting our use of Google Cloud Platform for this course.

Welcome to CSE532: Theory of Database Systems!

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.