Course Goals and Topics

Database systems are at the core of large-scale information management, providing the most efficient mechanism for storing, updating, and retrieving structured data. This course will provide an introduction to the design and use of database systems, as well as the key issues in building such systems. The World Wide Web is the largest distributed information management system. In addition to database topics, this course will also provide an introduction to key technologies for managing and exchanging data on the World Wide Web.

In presenting the fundamental principles of databases we will cover the relational model, conceptual design, and query languages. We will also cover core database implementation issues including storage and indexing, query processing and optimization, transaction management and recovery. In presenting modern Internet-based data management we will cover a set of technologies for XML data management and web application development.

Time and Place:	Tuesday and Thursday 2:30pm-3:45pm, LGRT 101
Professor:	Yanlei Diao
Contact:
Office Hours:	Tuesday 4:00pm-5:00pm or by appointment, CMPS 232
Teaching Assistant:
	Ravishankar Rajamony
Contact:	rravi ~at~ cs.umass.edu
Office Hour:	Tuesday 5pm - 6pm, Common Room, Computer Science Department
Contact instructor+TA:	cs445-help@edlab-mail.cs.umass.edu

Broadcast Mailing List:

We have created a course broadcast email address, cs445@edlab-mail.cs.umass.edu, for use by course participants. The instructor and TA will send all course related announcements (e.g., clarifications of homework or programming assignments, questions/answers of general interest, etc.) to this mailing list.

By default, email is sent to your edlab account. It is your responsibility to forward the mail to some other account if you want it to go somewhere else. To forward mail, create a file called '.forward' in your home directory on the edlab machines. The only line in the file should contain the alternate email address. All mail to your edlab account will then be forwarded to the alternate address.

Please note that whenever you send email to cs445@edlab-mail.cs.umass.edu, your email message will be broadcast to the entire class, so use the address carefully. A question/comment or some information you want to share with the class would be an appropriate email to send to cs445@edlab-mail.cs.umass.edu. A request for a due date extension would not be appropriate.

Textbook:

The textbook for this course is the 3rd Edition of "Database Management Systems" by Ramakrishnan and Gehrke. The textbook is available from Amazon. The lecture notes will be posted online after each class.