CSE-4/562 Database Systems (Spring 2021)

Data Management Systems (including Relational Databases, Non-Relational Databases, and NoSQL storage systems) form the basis of the Big Data Economy we now live in.  A data management system is responsible for storing data, enabling efficient access to that data, as well as mediating concurrent modifications.  This class approaches the challenges of designing a data management system from a standpoint that is both principled and practical.  The course revolves around a term-long programming assignment, in which you will build a system that answers SQL queries efficiently.  Course lectures will focus on the conceptual basis for this system, and will discuss how the techniques you learn generalize (e.g., to the use of NoSQL systems)

In this course, you will learn...

Course Details

Lecture Schedule


I expect students in this class to show respect for each other and themselves. This includes, but is not limited to the following forms of respect:
Respect each other's humanity
Especially with us not meeting in person, it's easy to lose track of the fact that the folks you're interacting with (fellow students, TAs, and everyone else others) are humans too. Think how what you're saying will be interpreted before you speak/write. Avoid insulting language, and focus on the merits of the ideas being discussed. Avoid dismissing ideas outright (if you can't come up with a good counterargument, maybe it's not actually a bad idea?)
Respect each other's intent
Especially given how bad text is at communicating emotion, try to avoid assuming that others are attacking you personally. Try to view what others are saying to you in the best possible light. Always ask for clarification before you get angry.
Respect yourself and your limits
Most students in 4/562 put in a lot of work on this course, so unsurprisingly, occasionally students decide that the course is too much work. If and when this happens to you, talk to me or another member of the course staff. It may be something as simple as you spacing out and missing a critical bit of some lecture, and armed with this information you can proceed to ace the class! Maybe the course actually is too much work for you this semester, in which case we'll still be able to come up with some strategy that lets you move forward with your education. Whatever the case, talk to me or course staff and we will figure something out.
Respect each other's effort
The flip side of this is that since colleagues are putting in the effort, you should do the same. Do not unilaterally decide that you do not have to do the same work that they are. Do not copy code/answers from the internet or other students. If you do not complete the same work as your classmates, do not expect to earn the same grade.

Academic Integrity

Students may discuss and advise one another on their lab projects, but groups are expected to turn in their own work.  Discussing concepts is permitted.  Referencing another group's code is not.  Cheating on an exam or project submission will result in an grade of F in the course for all involved. It is the CSE department's policy not to provide financial support to any student disciplined for plagarism. University policies on academic integrity can be reviewed at:

CSE Departmental Policy on Academic Integrity

UB's University-Wide Undergraduate Academic Integrity Policy

The Graduate School Policy Library

Medical Emergencies

Accommodations for medical emergencies will be made on a case-by-case basis.  Requests for extensions based on medical emergencies must be accompanied by documentation of the emergency from student health services:

Student Health Services

Accessibility Resources

If you have a diagnosed disability (physical, learning, or psychological) that will make it difficult for you to carry out the course work as outlined, or that requires accommodations such as recruiting note-takers, readers, or extended time on exams or assignments, please advise the instructor during the first two weeks of the course so that we may review possible arrangements for reasonable accommodations. In addition, if you have not yet done so, contact:

The Office of Accessibility Resources.

This page last updated 2024-05-06 11:22:18 -0400