This course covers the design and implementation of traditional relational database systems as well as advanced data analytics systems. The course will treat fundamental principles of databases such as the relational model, relational algebra, SQL, and schema refinement. We will also cover core database implementation issues including storage and indexing, query processing and optimization, and transaction management. Additionally, we will address challenges in big data analytics systems, including data exploration, data mining, machine learning for systems, and unified data analytics.
Course work will include homework assignments, a midterm exam, a paper review, and a course project.
Prerequisites: undergraduate-level courses on algorithms, databases and/or operating systems. 3 credits.
Course Time: |
Tue Thu 8:30 - 9:45 am EST, classed offered online in Zoom |
Professor: |
Yanlei Diao |
| Contact: |  |
| Office Hours: | Tue 10 - 11 am EST (priority given to research projects) Thu 7:30 - 8:30 am EST |
Teaching Assistants: |
|
| Matteo Brucato | |
| Contact: | matteo [at] cs [dot] umass [dot] edu |
| Office Hours: | Mon 8 - 9 am EST |
| Shivam Srivastava | |
| Contact: | shivam [at] cs [dot] umass [dot] edu |
| Office Hours: | Tue 11 am - 12 pm Wed 10:15 - 11:15 am |
| Kajal Tiwari and Nitin Srinivasan | |
| Contact: | kajaltiwari [at] umass [dot] edu, nitinsriniva [at] umass [dot] edu |
| Office Hours: | Fri 11 am - 12 pm |