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 10g Release 2 (10.2) New Features in Rules Manager and Expression Filter

1 Introduction

• What is a Rule?
• Developing Rules Applications

Part I Rules Manager

2 Rules Manager Concepts

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

3 Event Management Policies

• Consumption of Events
• Conflict Resolution
• Ordering of Rule Execution
• Duration of Events
• Equality
• Storage Properties
• AUTOCOMMIT
• DML Events
• Rule Class Property Dependencies and Defaults
• Rules Specified on Relational Tables
• Rules Conditions For XML Events
• Rule Conditions with Spatial Predicates
• Database State in Rule Conditions

4 Rule Conditions

• Support for Incremental Evaluation of Rules
• Rule Conditions with Sequencing
• Rule Conditions with Negation
• Rule Conditions with Set Semantics
• Rule Conditions with Any n Semantics

5 Rules Applications That Span Multiple Tiers

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

6 Rules Manager Object Types

7 DBMS_RLMGR Package

8 Rules Manager Views

• USER_RLMGR_EVENT_STRUCTS View
• USER_RLMGR_RULE_CLASSES View
• USER_RLMGR_RULE_CLASS_STATUS View
• USER_RLMGR_PRIVILEGES View
• USER_RLMGR_COMPRCLS_PROPERTIES View

9 Rules Manager Use Cases

• Law Enforcement Rules Application
• Order Management Rules Application

Part II Expression Filter

10 Oracle Expression Filter Concepts

• What Is Expression Filter?
  • Expression Filter Usage Scenarios
• Introduction to Expressions
  • Defining Attribute Sets
  • Defining Expression Columns
  • Inserting, Updating, and Deleting Expressions
• Applying the SQL EVALUATE Operator
• Evaluation Semantics
• Granting and Revoking Privileges
• Error Messages

11 Indexing Expressions

• Concepts of Indexing Expressions
• Indexable Predicates
• Index Representation
• Index Processing
• Predicate Table Query
• Index Creation and Tuning
• Index Usage
• Index Storage and Maintenance

12 Expressions with XPath Predicates

• Using XPath Predicates in Expressions
• Indexing XPath Predicates
  • Indexable XPath Predicates
  • Index Representation
  • Index Processing
  • Index Tuning for XPath Predicates

13 Expressions with Spatial Predicates

• Using Spatial Predicates in Expressions
• Indexing Spatial Predicates

14 Using Expression Filter with Utilities

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

15 SQL Operators and Statements

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

16 Object Types

17 Management Procedures Using the DBMS_EXPFIL Package

18 Expression Filter Views

• USER_EXPFIL_ASET_FUNCTIONS View
• USER_EXPFIL_ATTRIBUTES View
• USER_EXPFIL_ATTRIBUTE_SETS View
• USER_EXPFIL_DEF_INDEX_PARAMS View
• USER_EXPFIL_EXPRESSION_SETS View
• USER_EXPFIL_EXPRSET_STATS View
• USER_EXPFIL_INDEX_PARAMS View
• USER_EXPFIL_INDEXES View
• USER_EXPFIL_PREDTAB_ATTRIBUTES View
• USER_EXPFIL_PRIVILEGES View

A Managing Expressions Defined on One or More Database Tables

B Application Examples

C Internal Objects

• Attribute Set or Event Structure Object Type
• Expression Filter Internal Objects
  • Expression Validation Trigger
  • Expression Filter Index Objects
  • Expression Filter System Triggers

D Converting Rules Applications

• Differences Between Expression Filter and Rules Manager
• 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