CS143: Introduction to Databases
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.
CS239: Temporal Databases, Temporal Logic and Dynamic Models
Syllabus
- Introduction
- Temporal issues in intelligent information systems
- An ontology of time
- Temporal constructs in SQL
- storage structures query optimization for temporal DBs
- Time-series
- Temporal logics, Datalog1S and logic based systems
- modeling database dynamics (petri nets state charts)
- midterm
- architectures and implementations
- advanced topics-- students' presentations.
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).
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.
CS249 Course by Professor John (Junghoo) Cho
The advent of powerful personal computers and the Internet resulted in exponential growth in digital information. Anyone can create rich contents using his or her own personal computer and make it available on the Web. Many high-quality data sources are also available online within a single click of mouse.
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.