Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in Rules Manager and Expression Filter?

• Oracle Database 11g Release 1 (11.1) New Features in Rules Manager and Expression Filter

1 Introduction to Rules Manager

• 1.1 What is a Rule?
• 1.2 Developing Rules Applications

Part I Rules Manager

2 Rules Manager Concepts

• 2.1 Rules Terminology
• 2.2 Database Representation of a Rule Class and Rules
• 2.3 Creating Rules Applications That Use Simple or Non-Composite Events
• 2.4 Creating Rules Applications That Use Composite Events
  • 2.4.1 How to Create a Rules Application That Uses Composite Events
  • 2.4.2 Evaluating Composite Events Using Complex Rule Conditions
• 2.5 Setting Event Management Policies (Rule Class Properties) for Rule Applications
• 2.6 Creating Rules Applications That Span Multiple Tiers
• 2.7 Using Rules Manager with SQL*Loader and Export/Import Utilities
  • 2.7.1 SQL*Loader
  • 2.7.2 Export/Import

3 Event Management Policies

• 3.1 Consumption of Events
• 3.2 Ordering of Rule Execution
• 3.3 Duration of Events
• 3.4 Equality
  • 3.4.1 Single Equal Specification for a Rule Class
  • 3.4.2 Alternate Equal Specifications
• 3.5 Storage Properties
• 3.6 AUTOCOMMIT
• 3.7 DML and CNF Events
• 3.8 Rule Class Property Dependencies and Defaults

4 Event and Rule Class Configurations

• 4.1 Rules Specified on Relational Tables
• 4.2 Rule Conditions For XML Events
• 4.3 Rule Conditions with Spatial Predicates
• 4.4 Rule Conditions for Text Events
• 4.5 Disabling and Enabling Rules
• 4.6 Shareable Primitive Rule Conditions
• 4.7 Events Through Database Change Notification
• 4.8 Collection Events
• 4.9 Performance Tuning
• 4.10 Database State in Rule Conditions
• 4.11 Resetting Events for Development Environments

5 Rule Conditions

• 5.1 Support for Incremental Evaluation of Rules
• 5.2 Rule Conditions with Sequencing
• 5.3 Rule Conditions with Negation
• 5.4 Rule Conditions with Set Semantics
• 5.5 Rule Conditions with Any n Semantics
• 5.6 Rule Conditions with Collection Events

6 Rules Applications That Span Multiple Tiers

• 6.1 Creating Rules Applications That Span Multiple Tiers
• 6.2 Modes of Operation
  • 6.2.1 Single Tier Mode
  • 6.2.2 Multitier Mode
    • 6.2.2.1 Actions in the Mid-Tier

7 Rules Manager Object Types

8 DBMS_RLMGR Package

9 Rules Manager Views

• 9.1 USER_RLMGR_EVENT_STRUCTS View
• 9.2 USER_RLMGR_RULE_CLASSES View
• 9.3 USER_RLMGR_RULE_CLASS_STATUS View
• 9.4 USER_RLMGR_PRIVILEGES View
• 9.5 USER_RLMGR_COMPRCLS_PROPERTIES View

10 Rules Manager Use Cases

• 10.1 Law Enforcement Rules Application
• 10.2 Order Management Rules Application
• 10.3 Use of Collections in an Order Management Application

Part II Expression Filter

11 Oracle Expression Filter Concepts

• 11.1 What Is Expression Filter?
  • 11.1.1 Expression Filter Usage Scenarios
• 11.2 Introduction to Expressions
  • 11.2.1 Defining Attribute Sets
  • 11.2.2 Defining Expression Columns
  • 11.2.3 Inserting, Updating, and Deleting Expressions
• 11.3 Applying the SQL EVALUATE Operator
• 11.4 Evaluation Semantics
• 11.5 Granting and Revoking Privileges
• 11.6 Error Messages

12 Indexing Expressions

• 12.1 Concepts of Indexing Expressions
• 12.2 Indexable Predicates
• 12.3 Index Representation
• 12.4 Index Processing
• 12.5 Predicate Table Query
• 12.6 Index Creation and Tuning
• 12.7 Index Usage
• 12.8 Index Storage and Maintenance

13 Expressions with XPath Predicates

• 13.1 Using XPath Predicates in Expressions
• 13.2 Indexing XPath Predicates
  • 13.2.1 Indexable XPath Predicates
  • 13.2.2 Index Representation
  • 13.2.3 Index Processing
  • 13.2.4 Index Tuning for XPath Predicates

14 Expressions with Spatial and Text Predicates

• 14.1 Expressions with Spatial Predicates
  • 14.1.1 Using Spatial Predicates in Expressions
  • 14.1.2 Indexing Spatial Predicates
• 14.2 Expressions with Text Predicates

15 Using Expression Filter with Utilities

• 15.1 Bulk Loading of Expression Data
• 15.2 Exporting and Importing Tables, Users, and Databases
  • 15.2.1 Exporting and Importing Tables Containing Expression Columns
  • 15.2.2 Exporting a User Owning Attribute Sets
  • 15.2.3 Exporting a Database Containing Attribute Sets

16 SQL Operators and Statements

• EVALUATE
• ALTER INDEX REBUILD
• ALTER INDEX RENAME TO
• CREATE INDEX
• DROP INDEX

17 Object Types

18 Management Procedures Using the DBMS_EXPFIL Package

19 Expression Filter Views

• 19.1 USER_EXPFIL_ASET_FUNCTIONS View
• 19.2 USER_EXPFIL_ATTRIBUTES View
• 19.3 USER_EXPFIL_ATTRIBUTE_SETS View
• 19.4 USER_EXPFIL_DEF_INDEX_PARAMS View
• 19.5 USER_EXPFIL_EXPRESSION_SETS View
• 19.6 USER_EXPFIL_EXPRSET_STATS View
• 19.7 USER_EXPFIL_INDEX_PARAMS View
• 19.8 USER_EXPFIL_INDEXES View
• 19.9 USER_EXPFIL_PREDTAB_ATTRIBUTES View
• 19.10 USER_EXPFIL_PRIVILEGES View
• 19.11 USER_EXPFIL_TEXT_INDEX_ERRORS

A Managing Expressions Defined on One or More Database Tables

B Application Examples

C Internal Objects

• C.1 Attribute Set or Event Structure Object Type
• C.2 Expression Filter Internal Objects
  • C.2.1 Expression Validation Trigger
  • C.2.2 Expression Filter Index Objects
  • C.2.3 Expression Filter System Triggers

D Converting Rules Applications

• D.1 Differences Between Expression Filter and Rules Manager
• D.2 Converting an Expression Filter Application to a Rules Manager Application

E Installing Rules Manager and Expression Filter

F XML Schemas

G Implementing Various Forms of Rule Actions With the Action Callback Procedure

Index