CS734: Database Internals

Department of Computer Science

UMass Boston


Patrick O'Neil, email: poneil@cs.umb.edu, Office: S-3-167
Spring 2007 Office Hours: 3:30 PM to 3:50 PM or 5:50 PM until 6:50 PM or after class until no students remain, or by appointment


See the course syllabusPrerequisite:  CS630 and CS634, or strong experience with database and my permission.

NOTE: You are required to "apply" for cs734, EVEN IF YOU ALREADY HAVE A UNIX ID

Class Schedule

Spring 2007: Mon & Wed 7:00 PM - 8:15 PM, M-1-201

Grader is Xuedong Chen, email: xuedchen@cs.umb.edu


Bernstein, Hadzilacos, Goodman, Concurrency Control and Recovery in Database Systems, available free at http://research.microsoft.com/~philbe/ccontrol/

Patrick and Elizabeth O'Neil, "Database: Principles, Programming, and Performance," second edition

Getting Started

    Getting started using Oracle for CS734.

1.      Get a UNIX account for CS734 by running apply in S/3/158.  You will need to show ID to the operator if you are a new student.

2.      Once the account is activated, make sure you can log in to dbs1.cs.umb.edu, the DB server for courses.

3.      To log in from home, read the UMB online help described below under Useful Web Links.

4.      Your activated UNIX account for CS734 will cause an automatic request for an Oracle account on dbs1.  It may take a few days to get these are set up.  You will receive email from the DBA when this happens, with more instructions such as how to edit your .cshrc.

5.      Check for the existence of your Oracle account as soon as possible and test its basic functionality by creating a table with one integer column, inserting one row in it, and then displaying it—a “hello world” test of a database.

6.      Make a “CAPload” subdirectory of your cs734 directory, copy the CAP files to it (/data/htdocs/cs734/CAPload/* in the file system) read create.sql and *.ctl. Use sqlplus and sqlldr to load the CAP database into your Oracle account on dbs1.

7.      The makefile and related files for embedded C programming are available here (/data/htdocs/cs734/esql/* in the file system.)  You can find numerous online examples at the DBPPP textbook site linked above.

Lock Manager Project: Provided sources  LM Sources Handout  EDTs Handout

Useful Web Links

Online Oracle Documentation 9.2

UMB online help of particular interest. Start from the departmental homepage at http://www.cs.umb.edu/, select "Resources" and a menu pops down with various options. Here are the most useful:

CS734 Course Notes (TO COME -- in PDF)

Papers to Read

Practice Exams