Active Databases

Overview of Integrity Constraints in SQL2 and Oracle (Notes from ``A first course in DB Systs'' , J. Ullman and J. Widom, Prentice Hall, 1997)
Constraints in SQL2	Slides
Constraints in Oracle	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
2.5 Taxonomy of Active Database Concepts (Informix, Ingres, RDB, Sybase)	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 3.5.1 A Case Study: Energy Management System (EMS) 3.5.2 Database Schema for the EMS Case Study 3.5.3 Business Rules for the EMS Case Study 3.6 Bibliographic Notes	Slides

Chapter 4: Active Rules Design
4.0 Mapping from Deductive Rules to Active Rules	Slides
4.1 Properties of Active Rule Execution 4.1.1 Termination 4.1.2 Confluence 4.1.3 Observable Determinism 4.2 Rule Modularization 4.3 Rule Debugging and Monitoring 4.4 IDEA Methodology 4.4.1 Active Rule Design 4.4.2 Active Rule Prototyping 4.4.3 Active Rule Implementation 4.4.4 Design Tools Supporting the IDEA Methodology 4.5 Summary and Open Problems 4.6 Bibliographic Notes	Slides

---