Instructor: Zhuoyue Zhao, zzhao35 [at] buffalo [dot] edu, Davis Hall 338I.
Office hours are on demand. Email me for an appointment.
DuckDB Shell on IMDB sample database
DBTG data model on IMDB sample database
| Topic | Section A (Davis 101) | Section B (Hoch 114) | Section C (Knox 104) | Section D (Baldy 101) | Addt'l Readings |
|---|---|---|---|---|---|
| 1. A historical review of data modeling and query processing | 10/5/2026 | 10/26/2026 | 11/16/2026 | 9/14/2026 | Donald Chamberlin. 2024. 50 Years of Queries. Commun. ACM 67, 8 (August 2024), 110–121. https://doi.org/10.1145/3649887 |
| 2. Network Model and DBTG | 10/7/2026 | 10/28/2026 | 11/18/2026 | 9/16/2026 | Database System Concepts, 6th Edition, Appendix D |
| 3. Relational model and SQL | 10/14/2026 | 11/2/2026 | 11/23/2026 | 9/21/2026 | SQL SELECT Syntax in DuckDB |
| 4. RDBMS and NoSQL | 10/19/2026 | 11/4/2026 | 11/30/2026 | 9/23/2026 | |
| 5. Natural Language to SQL | 10/21/2026 | 11/9/2026 | 12/2/2026 | 9/28/2026 | X. Liu et al., "A Survey of Text-to-SQL in the Era of LLMs: Where Are We, and Where Are We Going?," in IEEE Transactions on Knowledge and Data Engineering, vol. 37, no. 10, pp. 5735-5754, Oct. 2025. |