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. As Internet applications such as the World Wide Web and social networks continue to produce new data management issues besides traditional database topics, this course will also provide an introduction to key technologies for managing and exchanging large amounts of data on the Internet.

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, and transaction management. In presenting advanced data management technology, we will cover web application development, big data analytics, and cloud computing.

Time and Place:

Tuesday and Thursday 11:30am - 12:45pm, LGRT 121

Professor:

Yanlei Diao
Contact:
Office Hours: Wednesday 4:50-6:00 pm, CS 232

Teaching Assistant:    

Haopeng Zhang
Office Hour:

Monday 4:50-6:00pm, CS 207

Contact instructor+TA: help-cs445@edlab-mail.cs.umass.edu

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.