CMPSCI 445: Information Systems

subglobal1 link | subglobal1 link | subglobal1 link | subglobal1 link | subglobal1 link | subglobal1 link | subglobal1 link
subglobal2 link | subglobal2 link | subglobal2 link | subglobal2 link | subglobal2 link | subglobal2 link | subglobal2 link
subglobal3 link | subglobal3 link | subglobal3 link | subglobal3 link | subglobal3 link | subglobal3 link | subglobal3 link
subglobal4 link | subglobal4 link | subglobal4 link | subglobal4 link | subglobal4 link | subglobal4 link | subglobal4 link
subglobal5 link | subglobal5 link | subglobal5 link | subglobal5 link | subglobal5 link | subglobal5 link | subglobal5 link
subglobal6 link | subglobal6 link | subglobal6 link | subglobal6 link | subglobal6 link | subglobal6 link | subglobal6 link
subglobal7 link | subglobal7 link | subglobal7 link | subglobal7 link | subglobal7 link | subglobal7 link | subglobal7 link
subglobal8 link | subglobal8 link | subglobal8 link | subglobal8 link | subglobal8 link | subglobal8 link | subglobal8 link


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 11:15am-12:30pm, ELAB 323

Professor:

Yanlei Diao
Contact:
Office Hours: Tuesday 5:30-6:30pm, CS 142
Thursday 10:15-11:15am, CS 232
or by appointment

Teaching Assistant:    

Hong Yuan
Contact: hongyuan ~at~ cs.umass.edu
Office Hour:

Wednesday 3:00-4:00pm, CS 245

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.

Please note that whenever you send an 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 at the campus book store and on Amazon. The lecture notes will be posted online after each class.