CSCI 1270

Database Management Systems

Introduction

Welcome to CSCI 1270!

Link to previous course offering.

The concepts you will learn in this class include aspects of database design, database languages, and database-system implementation. The course textbook is Database Systems Concepts, Seventh Edition by Silberschatz, Korth, and Sudarshan. ISBN: 9780078022159. Lectures are held on Mondays and Wednesdays from 3:00 pm to 4:20 pm virtually via Zoom unless otherwise specified. Optional in-person seminars are held on Friday at the same time. Please stop on by!

If content is not showing up for you on the website, hard refresh the page (ctrl-shift-r)!

Shopping Period FAQ

Will this course be accessible to remote students?

What is the weekly workload for CSCI 1270? Any time commitment estimates?

I've heard this course will be run in Golang and SQL; should I prepare?

I need an override code! I need to enroll concurrently with another course! I have another special request that requires instructor permission!

Can I audit this class?

Can anyone attend the seminars?

{Any other question}

Assignments

Please note: the dates on this page are tentative and may change to correspond with changes in lecture pacing.

All weekly written and coding assignments should be turned in via Gradescope. All assignments will be released by 11:59 PM on the day listed. All assignments are due at 11:59 pm ET on the day listed. They will be graded and returned with solutions for the problems. Written assignments should be submitted as PDFs.

All quizzes will be available through Gradescope on the day listed below. Once you've started, you will have 90 minutes to complete the quiz.

Written Coding Out In
Setup - - Sep 20
Relational Algebra Go Sep 15 Sep 22
ER Diagrams SQL Sep 22 Sep 29
Constraints + Normalization Pager Sep 29 Oct 11
Quiz 1 - Oct 13 Oct 13
Storage + B-Trees B+Tree Oct 13 Oct 25
Hash + Join Algorithms Hash Oct 25 Nov 01
Query Optimization Query Nov 01 Nov 08
Quiz 2 - Nov 10 Nov 10
Latches + Transactions Concurrency Nov 10 Nov 24
Logging + Recovery Recovery Nov 29 Dec 06
Quiz 3 - Dec 14 Dec 14
Gearup Date Slides Recording
Go Sep 15 Slides Recording
SQL Sep 22 - -
Pager Sep 29 - -
B+Tree Oct 13 - -
Hash Oct 25 - -
Query Nov 1 - -
Concurrency Nov 10 - -
Recovery Nov 29 - -

Late Assignments

Each student gets 5 late days during the semester, in that they are not penalized for them. You may not use more than 2 late days on a single assignment. At the end of the semester, we will optimally distribute the late days over your projects. A late day used on either the written or code portion of an assignment counts as a late day for the assignment as a whole. After your five late days, we will take off 25% per late day, distributed optimally.

Solution Code Requests

Since projects in CSCI 1270 build atop one another, we recognize that if a student falls behind, later projects will be impossible. If you require solution code to continue in the course, please fill out the form linked here to request it. You will only receive solution code two days after the due date of the relevant project due date(s) at the earliest. Most importantly, note that distributing or making available solution code in any way, knowingly or unknowingly, is a violation of the Academic Code. This includes sharing code with a peer in the class, even if they have also filled out the request form. For the most up-to-date information on solution code requests, please see our Missive.

Lectures

Lectures are held on Mondays and Wednesdays from 3:00 pm to 4:20 pm virtually via Zoom unless otherwise specified. Lecture slides and recordings will be posted soon after lecture ends. You are highly encouraged to attend all lectures.

The following lecture schedule is very approximate. Please note that the schedule may be subject to change depending how quickly or slowly we are able to move through lectures.

Topic Date Slides Recording Book
Introduction to Databases Sep 08 Slides Recording TBA
Relational Model Sep 13 Slides Recording TBA
Relational Algebra Sep 15 Slides Recording TBA
Entity-Relationship Models Sep 20 Slides - TBA
SQL Sep 22 Slides - TBA
Constraints + Normalization Sep 27 1, 2 - TBA
Storage and Disks Sep 29 Slides - TBA
B-Trees Oct 04 Slides - TBA
B+Trees Oct 06 - - TBA
Hashing Oct 11 Slides - TBA
Quiz 1 Oct 13 - - -
Hashing cont. Oct 18 - - TBA
Query Processing Oct 20 Slides - TBA
Query Processing cont. Oct 25 - - TBA
Transactions Oct 27 Slides - TBA
Transactions cont. Nov 01 - - TBA
Concurrency Nov 03 Slides - TBA
Recovery Nov 08 Slides - TBA
Quiz 2 Nov 10 - - -
Distributed Databases Nov 15 - - TBA
Parallel Databases Nov 17 - - TBA
NoSQL Databases Nov 22 - - TBA
Thanksgiving (No class) Nov 24 - - -
Guest Lecture Nov 29 - - -
Guest Lecture Dec 01 - - -
Guest Lecture Dec 06 - - -
Guest Lecture Dec 08 - - -
Quiz 3 Dec 14 - - -

Seminars

To spread our love of databases and to expose you to cutting edge database concepts, the CSCI 1270 TAs run seminars on Fridays from 3:00 pm to 4:20 pm, in-person in the specified room. Recordings will be posted soon after the seminar ends. You are highly encouraged to attend any seminars that interest you!

The following seminar schedule is very approximate. Please note that the schedule may be subject to change depending on TA availability.

Topic Date Slides Recording
Efficient SQL Oct 15 - -
Time Series Databases Oct 08 - -
Denormalization & MongoDB Oct 15 - -
Advanced Tree Indices Oct 22 - -
TBD Oct 29 - -
Logica Nov 05 - -
Graph Databases Nov 12 - -
Blockchain Databases Nov 19 - -

Calendar

Zoom links are included in the Google Calendar event, as well as in the SignMeUp Queue.

Resources

Guides

Documents

Contact

Staff

Stan Zdonik

Professor | sbz

Desmond Cheong

HTA | dcheong

CS senior specializing in systems, powered by yakult and kaya toast.

🙃

Nick Young

HTA | nyoung10

Hi! I'm from Vancouver, Canada and I enjoy photography, badminton, and building mechanical keyboards!

🧋

Connor Luckett

GTA | cluckett

Hi, I'm Connor! I am in my third year as a Ph.D. student, mentored by Dr. Cetintemel. I love to think about how we can help others navigate GDPR/CCPA compliance. I am an avid drummer and a Private Pilot.

✈️

Aakansha Mathur

UTA | amathur7

I am a SCM CS student at Brown. My academic interests are databases, machine learning and natural language processing.

❄️

Huiyuan Wu

UTA | hwu62

Hi, i am Huiyuan Wu, a second year Master's student in computer science.

😅

Junchi Chu

UTA | jchu27

I love cooking, fishing, writing my novels. I like basketball, my favorite team is GSW!

😂

Sayan Chakraborty

UTA | schakr12

Hi! I'm an international CS grad student from India. I can speak 4 languages. In my spare time you can find me eating/cooking good food, listening to podcasts or sleeping (basically I'm the human form of a Panda).

😴

Solomon Boukman

UTA | sboukman

I use he/him pronouns, and I am from New Jersey. For fun I like playing basketball, videogames, skateboarding, and gardening. My interests with computer science are machine learning and data engineering.

💯