CSCI 5817:
Database Systems
Mon., Wed. 5:30-6:45 PM
Spring 2003
Instructor:
Roger (Buzz) King
Topics:
Relational database overview:
relational model, SQL, transactions;
Object and object/relational
databases, and CORBA;
XML and data on the web;
Distributed databases and
heterogeneous, distributed databases;
Transaction processing systems and
monitors;
Isolation and alternative
concurrency control protocols;
Distributed transactions;
Security;
Active databases,
AI contributions to databases;
Temporal databases;
Mediated and agent-based
databases;
Data mining, data warehousing, and
OLAP.
Prerequisites:
Undergrad or intro
graduate database systems course or experience with database management
systems. If you are unsure of your
background, please talk to me. The
relational database overview at the beginning of the semester will be very
brief; we will then begin with the second half (part 3) of the text by
Lewis/Bernstein/Kifer.
Texts:
Databases and Transaction Processing, Lewis/Bernstein/Kifer, Addison-Wesley, 2002.
Intelligent Database Systems, Bertino/Catania/Zarri, Addison-Wesley, 2001.
Format of
the class:
Active class participation encouraged. We will move through the advanced material
in LBK, and then move into BCZ. I will
post an outline for the class. Most of
the time this outline will coincide with the order in which the books cover
topics. I will point out some important
examples, conclusions, and explanations in the textbooks. Please always bring your textbook to
class.
There will be two in-class exams and one project; each will decide 1/3 of your final grade. CATECS students will take their exams at their remote sites and CATECS students will be graded as a separate section of the class. Exam dates: March 10 and April 30. The project will be either a survey paper on an area not covered in class or a software project.