Class Notes for CS240A: Databases and Knowledge Bases

Active Databases

Slides from
`Database System Concepts'
A. Silberschatz, F. F. Korth, S. Sudarshan

Constraints in SQL2 slides

Chapter 2: Syntax and Semantics of Active Databases

2.1 Starburst
2.1.1 Syntax of the Starburst CREATE RULE Statement
2.1.2 Semantics of Active Rules in Starburst
2.1.3 Other Active Rule Commands
2.1.4 Examples of Active Rule Executions
2.2 Oracle
2.2.1 Syntax of the Oracle CREATE TRIGGER Statement
2.2.2 Semantics of Oracle Triggers
2.2.3 Example of Trigger Executions
2.3 DB2
2.3.1 Syntax of the DB2 CREATE TRIGGER Statement
2.3.2 Semantics of DB2 Triggers
2.3.3 Examples of Trigger Executions
slides

Chapter 3: Applications of Active Databases

3.1 Integrity Management
3.1.1 Rule Generation
3.1.2 Example
3.2 Derived Data Maintenance
3.2.1 Rule Generation
3.2.2 Example
3.3 Replication
3.4 Workflow Management
3.5 Business Rules
slides

4.0 Mapping from Deductive Rules to Active Rules

slides

Chapter 4: Active Rules Design

4.1 Properties of Active Rule Execution
4.1.1 Termination
4.1.2 Confluence
4.1.3 Observable Determinism

slides