Undergraduate courses

The undergraduate database courses have recently been revised. The following are the courses that will be offered as of Fall 2006.

CS 338 Computer Applications in Business: Databases (0.50)

This course is designed primarily to meet the needs of students who are interested in the business or public sector of the economy. The course presents methods used for the storage, selection, and presentation of data. It is a service course that is not open to CS major students. Course home page

Prerequisites: CS 230 or 234 or 241 or 330. Not open to Computer Science students.
Antirequisite: CS 448, ECE 456.

CS 348 Introduction to Database Management (0.50)

The main objective of this course is to introduce students to fundamentals of database technology by studying databases from three viewpoints: those of the database user, the database designer, and the database administrator. It teaches the use of a database management system (DBMS) by treating it as a black box, focusing only on its functionality and its interfaces. Topics include: introduction to database systems, relational database systems, database design methodology, SQL and interfaces, database application development, concept of transactions, ODBC, JDBC, database tuning, database Administration, and current topics (distributed databases, data warehouses, data mining). [Note: Lab is not scheduled and students are expected to find time in open hours to complete their work. Offered: F,W,S]

Prerequisites: Prereq: CS 240 or SE 240; Computer Science students only.
Antirequisite: Antireq: CS 338, 448, ECE 456

CS 448 Database Systems Implementation (0.50)

The objective of this course is to introduce students to fundamentals of building a relational database management system. The course focuses on the database engine core technology by studying topics such as storage management (data layout, disk-based data structures), indexing, query processing algorithms, query optimization, transactional concurrency control, logging and recovery. [Note: Lab is not scheduled and students are expected to find time in open hours to complete their work. Offered: F,W,S]

Prerequisites: CS 240, 348 and (CS 350 or 354 or ECE 354); Computer Science students only.
Antirequisite: ECE 456


Graduate courses

CS 740 Database Engineering (0.50)

Project-oriented course that covers the implementation of relational database management systems. Topics include database system architecture; managing primary and secondary storage; query processing; metadata and catalog management; language processing; query optimization and plan generation; concurrency; failures and recovery; extensibility; client-server interactions. Course home page

CS 741 Non-Traditional Databases (0.50)

Management of non-relational databases, such as multimedia databases, text databases, temporal databases or spatial databases. Each offering will target a specific type of data. Topics include rationale for and common applications of non-relational database management; systems and standards; the abstract data model; data definition and manipulation languages; data storage and indexing; query processing and optimization; updates and transaction management. Course home page

Antirequisite: CS 748O, 748S

CS 742 Parallel and Distributed Database Systems (0.50)

Algorithms and architectures used in parallel database management systems, with a focus on relational systems. Topics include system architectures; parallel and distributed query processing; federated dtabase systems; distributed transactions; data replication. Course home page

Antirequisite: CS 748T, 748Q

CS 848 Advanced Topics in Databases (0.50)

This is a seminar course whose coverage changes depending on who teaches it. In recent years it has focused on "Adaptive Query Processing for Emerging Applications", "Information Integration", "Self-Managing Database Systems".

CS 856 Advanced Topics in Distributed Computing (0.50)

This is a seminar course that sometimes covers topics that are relevant to database students. In recent years, it has focused on "Web Data Management", and on "Internet-Scale Data Distribution".