The relational data model and query languages: relational algebra, and calculus, SQL, QBE. File organization and storage structures. Query processing and optimization. Integrity constraints and database design--ER model. Transactions, concurrency, and recovery. Distributed DBs and advanced topics.
Class Homepage (Fall 2004)
CS240A: Databases and Knowledge Bases
Advanced applications and Object-Relational databases. Deductive rules, knowledge representation, and recursion. Active databases, trigger rules and integrity constraints. Temporal databases. Decision support, OLAPs and Datamining Functions. Extensions and extensibility in OR systems. User-defined functions, tables, aggregates and indexes. Data Blades and XML-oriented DB extensions. (Prereq: CS143 or equivalent).
Class Homepage (Winter 2002)
Class Homepage (Winter 2005)
CS240B: Advanced Databases & Knowledge Bases
This covers research topics in databases and information systems (CS240A is required). Main topics include: logic-based query languages and nonmonotonic reasoning, data mining techniques and environments, and XML information systems. Other advanced topics might be covered in presentations by students.
Class Homepage (Spring 2005)
CS249 Course by Professor John
The growth of digital information, however, has brought in tremendous
challenges in managing, organizing and accessing such information. The
inherent heterogeneity of the information as well as the wide variety
of unstructured text, semistructured, and structured data make it challenging
to handle them. In this course, we will go over research papers to study
the main approaches that people have taken to manage information on
the Internet. In particular, the class will be structured around three
major themes: 1) Data extraction approach 2) Central indexing approach
and 3) Dynamic integration approach.
CS298: Research Seminar: Computer Science