Active Databases
Slides from
`Database System Concepts'A. Silberschatz, F. F. Korth, S. SudarshanConstraints 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 Rulesslides 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 Determinismslides