CSE 132C – Database System Implementation (Online-Only Edition)!!! This website is archived. Please see the website of the latest edition of this course among the links listed here. !!! Lectures: MWF 1:00-1:50pm PT @ Zoom only (link posted on Piazza page) Instructor: Arun Kumar
Teaching Assistants:
Piazza: CSE 132C (Requires access code posted on Canvas) Announcements
Course Goals and ContentThis is a hands-on systems-focused course on the implementation of a database management system (DBMS), especially, a relational DBMS (RDBMS). RDBMSs are the cornerstone of large-scale data management in numerous application domains that define our modern world, including finance, insurance, retail, logistics, telecommunications, healthcare, governance, and education. Furthermore, concepts developed in the context of RDBMSs are indispensable for the underpinnings of the so-called Big Data and NoSQL systems that were developed for new applications such as Web search, e-commerce, social media analytics, and large-scale machine learning systems. This course will cover key systems topics in implementing an RDBMS: data storage, buffer management, indexing, sorting, relational operator implementations, a bit of query optimization, and a bit of transaction management and concurrency control. The implementation of newer Big Data systems such as Spark and MapReduce/Hadoop, as well as distributed NoSQL/key-value stores and in-memory RDBMSs will likely be covered too. A major component of this course is hands-on C++ programming to implement two key components of an RDBMS, a buffer manager and a B+ Tree index, on top of a basic RDBMS skeleton that will be provided. Course Format and Online-only Modality Instructions
Prerequisites
Textbooks
Exam Dates
Grading
CutoffsSince this is the very first online-only edition of this course, the grading scheme is a hybrid of absolute and relative grading to mitigate the "cold start" issue. The absolute cutoffs are based on your absolute total score. The relative bins are based on your position in the total score distribution of the class. The better grade among the two (absolute-based and relative-based) will be your final grade.
Non-Letter Grade Options: You certainly have the option of taking this course for a non-letter grade. As per the CSE department's guidelines, the policy for P in a P/F option is a pass-equivalent letter grade, i.e., D or better; the policy for S in an S/U option is a letter grade of B- or better. Classroom Rules
|