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".