Chris Pollett> CS157b
( Print View )

Student Corner:
[Lecture Notes]
[Discussion Board]

Course Info:
[Texts & Links]
[Course Outcomes]
[Outcomes Matrix]
[Course Schedule]
[Class Protocols]
[Exam Info]
[University Policies]

HW Assignments:
[Hw1] [Hw2] [Hw3]
[Hw4] [Hw5] [Quizzes]

Practice Exams:
[Midterm] [Final]

CS157b Spring 2024 Sec1 Home Page/Syllabus

Database Management Systems II

Instructor: Chris Pollett
Office: MH 214
Phone Number: (408) 924 5145
Office Hours: MW 3:00-4:15pm in MH214
Class Meets:
Sec1 MW 4:30-5:45pm in ISB 878


To take this class you must have taken:
with a grade of C- or better.

Texts and Links

Required Texts: Database Systems: The Complete Book. Hector Garcia-Molina, Jeff Ullman, and Jennifer Widom
Online References and Other Links: Postgres.
Maria DB (MySql fork).


The catalog description is: Object-oriented data model, definition language, query language. Object relational database systems. Database trends like active, temporal, multimedia, deductive databases. Web database topics, namely, architectures, introduction to interface languages. Team projects. Unfortunately, the catalog description needs to be updated (will ask for the update) as it does it match the departments internal canonical description/syllabus. Here is a more updated description: This class continues where CS157A left off. To begin data storage will be considered. This includes a discussion of how disks works, a discussion of algorithms for disk scheduling and sorting, and a discussion of how RAID systems work. Then indexes, B+-trees, record structures, multi-dimensional indexes, etc will be discussed. The focus will then switch to how query evaluation is implemented. Next we will cover database recovery algorithms. This will be followed with some lectures on transaction processing and concurrency control techniques and then a discussion on combining data from different databases. The semester will conclude with a discussion of data mining and databases and the internet.

Course Learning Outcomes (CLOs)

By the end of this course, a student should be able to:

CLO1 -- Know common database record formats

CLO2 -- Given an index structure based on a B-tree or extensible hashing be able to figure out the effect of performing an insert or a delete

CLO3 -- Create a simple query transaction in a modern DBMS system.

CLO4 -- Tune queries and know how to perform query performance evaluations

CLO5 -- Know database recovery techniques

CLO6 -- Be able to use isolation levels for concurrency control in a popular DBMS

CLO7 -- Be able to create or deploy a query mediator for a system with at least two data sources.

CLO8 -- Be able to determine how the A Priori algorithm would operate on a toy dataset

CLO9 -- Design and deploy analytical databases for OLAP

Course Schedule

Below is a tentative time table for when we'll do things this quarter:

Week 1:Jan 22, Jan 24 Start Ch 13 Secondary Storage Management.
Week 2:Jan 29, Jan 31 Finsh Ch 13, Start Ch 14 Index Structures
Week 3:Feb 5, Feb 7 Finish Ch 14
Week 4:Feb 12(Hw1), Feb 14 Ch 15 Query Execution
Week 5:Feb 19, Feb 21 Ch 16 The Query Compiler
Week 6:Feb 26, Feb 28 Ch 17 Coping With System Failure
Week 7:Mar 4(Hw2), Mar 6 Ch 18 Concurrency Control
Week 8:Mar 11, Mar 13(Midterm) Review
Week 9:Mar 18, Mar 20 Ch 19 Transaction Management
Week 10:Mar 25, Mar 27(Hw3) Ch 20 Parallel and Distributed Databases
Week 11:Apr 1, Apr 3 Spring Recess
Week 12:Apr 8, Apr 10 Start Ch 21 Information Integration
Week 13:Apr 15, Apr 17 Finish Ch 21
Week 14:Apr 22(Hw4), Apr 24 Ch 22 Data Mining
Week 15:Apr 29, May 1 Start Ch 10 OLAP
Week 16:May 6, May 8 Finish Ch 10
Week 17:May 13(Hw5) Review
The final will be Friday, May 17 2:45-5:00 PM


HWs and Quizzes 50%
Midterm 20%
Final 30%

Grades will be calculated in the following manner: The person or persons with the highest aggregate score will receive an A+. A score of 55 will be the cut-off for a C-. The region between this high and low score will be divided into 8 equal-sized regions. From the top region to the low region, a score falling within a region receives the grade: A, A-, B+, B, B-, C+, C, C-. If the boundary between an A and an A- is 85, then the score 85 counts as an A-. Scores below 55 but above 50 receive the grade D. Those below 50 receive the grade F.

If you do better than an A- in this class and want me to write you a letter of recommendation, I will generally be willing provided you ask me within two years of taking my course. Be advised that I write better letters if I know you to some degree.

Course Requirements, Homework, Quiz Info, and In-class exercises

This semester we will have five homeworks, weekly quizzes, and weekly in-class exercises.

Every Monday this semester, except the first day of class, the Midterm Review Day, and holidays, there will be a quiz on the previous week's material. The answer to the quiz will either be multiple choice, true-false, or a simple numeric answer that does not require a calculator. Each quiz is worth a maximum of 1pt with no partial credit being given. Out of the total of thirteen quizzes this semester, I will keep your ten best scores.

On Wednesday's, we will spend 15-20 minutes of class on an in-class exercise. You will be asked to post your solution to these exercises to the class discussion board. Doing so is worth 1 "insurance point" towards your grade. A "insurance point" can be used to get one missed point back on a midterm or final, up to half of that test's total score. For example, if you scored 0 on the midterm and have 10 insurance points, you can use your insurance points, so that your midterm score is a 10. On the other hand, if you score 18/20 on the midterm, you can use at most 1 insurance point since half of what you missed (2pts) on the midterm is 1pt. In addition, to the weekly in-class exercises, one insurance point is available if in the week before the midterm you can convince me I know your name, and in the week before the final, I still know your name (Please help me improve my memory).

Links to the current list of homeworks and quizzes can be found on the left hand side of the class homepage. After an assignment has been returned, a link to its solution (based on the best student solutions) will be placed off the assignment page. Material from assignments may appear on midterms and finals. For homeworks you are encouraged to work in groups of up to three people. Only one person out of this group needs to submit the homework assignment; however, the members of the group need to be clearly identified in all submitted files.

Homeworks for this class will be submitted and returned completely electronically using the Canvas link for the name of the homework. Hardcopies or e-mail versions of your assignments will be rejected and not receive credit. Homeworks will always be due by midnight according to the Canvas server on the day their due. Late homeworks will not be accepted and missed quizzes cannot be made up; however, your lowest score amongst the first four homeworks and your quiz total will be dropped. Homework 5 can't be substituted for.

When doing the programming part of an assignment please make sure to adhere to the specification given as closely as possible. Names of files should be as given, etc. Failure to follow the specification may result in your homework not being graded and you receiving a zero for your work.

Classroom Protocol

I will start lecturing close to the official start time for this class modulo getting tangled up in any audio/visual presentation tools I am using. Once I start lecturing, please refrain from talking to each other, answering your cell phone, etc. If something I am talking about is unclear to you, feel free to ask a question about it. Typically, on practice tests days, you will get to work in groups, and in so doing, turn your desks facing each other, etc. Please return your desks back to the way they were at the end of class. This class has an online class discussion board which can be used to post questions relating to the homework and tests. Please keep discussions on this board civil. This board will be moderated. Class and discussion board participation, although not a component of your grade, will be considered if you ask me to write you a letter of recommendation.


The midterm will be during class time on: Mar 13.

The final will be: Friday, May 17 2:45-5:00 PM.

All exams are closed book, closed notes and in this classroom. You will be allowed only the test and your pen or pencil on your desk during these exams. The final will cover material from the whole semester although there will be an emphasis on material after the last midterm. No make ups will be given. The final exam may be scaled to replace a midterm grade if it was missed under provably legitimate circumstances. These exams will test whether or not you have mastered the material both presented in class or assigned as homework during the quarter. My exams usually consist of a series of essay style questions. I try to avoid making tricky problems. The week before each exam I will give out a list of problems representative of the level of difficulty of problems the student will be expected to answer on the exam. Any disputes concerning grades on exams should be directed to me, Professor Pollett.


If you believe an error was made in the grading of your program or exam, you may request in person a regrade from me, Professor Pollett, during my office hours. I do not accept e-mail requests for regrades. A request for a regrade must be made no more than a week after the homework or a midterm is returned. If you cannot find me before the end of the semester and you would like to request a regrade of your final, you may see me in person at the start of the immediately following semester.

University Policies and Procedures

SJSU adheres to required safety measures from the California Department of Public Health and the Santa Clara County Public Health Department. Please refer to our SJSU Health Advisories website for the latest information and updates.

Per University Policy S16-9, relevant university policy concerning all courses, such as student responsibilities, academic integrity, accommodations, dropping and adding, consent for recording of class, etc. and available student services (e.g. learning assistance, counseling, and other resources) are listed on Syllabus Information web page ( Make sure to visit this page to review and be aware of these university policies and resources. Below are some brief comments on some of these policies as they pertain to this class.

Academic Integrity

For this class, you should obviously not cheat on tests. For homeworks, you should not discuss or share code or problem solutions between groups! At a minimum a 0 on the assignment or test will be given. Faculty members are required to report all infractions to the Office of Student Conduct and Ethical Development.


If you need a classroom accommodation for this class, and have registered with the Accessible Education Center, please come see me earlier rather than later in the semester to give me a heads up on how to be of assistance.