Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

Documentation Accessibility

Related Documents

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

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 Conflict Resolution

3.3 Ordering of Rule Execution

3.4 Duration of Events

3.6 Storage Properties

3.9 Rule Class Property Dependencies and Defaults

3.10 Rules Specified on Relational Tables

3.11 Rules Conditions For XML Events

3.12 Rule Conditions with Spatial Predicates

3.13 Database State in Rule Conditions

4 Rule Conditions

4.1 Support for Incremental Evaluation of Rules

4.2 Rule Conditions with Sequencing

4.3 Rule Conditions with Negation

4.4 Rule Conditions with Set Semantics

4.5 Rule Conditions with Any n Semantics

5 Rules Applications That Span Multiple Tiers

5.1 Creating Rules Applications That Span Multiple Tiers

5.2 Modes of Operation

5.2.1 Single Tier Mode

5.2.2 Multitier Mode

5.2.2.1 Actions in the Mid-Tier

6 Rules Manager Object Types

7 DBMS_RLMGR Package

8 Rules Manager Views

8.1 USER_RLMGR_EVENT_STRUCTS View

8.2 USER_RLMGR_RULE_CLASSES View

8.3 USER_RLMGR_RULE_CLASS_STATUS View

8.4 USER_RLMGR_PRIVILEGES View

8.5 USER_RLMGR_COMPRCLS_PROPERTIES View

9 Rules Manager Use Cases

9.1 Law Enforcement Rules Application

9.2 Order Management Rules Application

Part II Expression Filter

10 Oracle Expression Filter Concepts

10.1 What Is Expression Filter?

10.1.1 Expression Filter Usage Scenarios

10.2 Introduction to Expressions

10.2.1 Defining Attribute Sets

10.2.2 Defining Expression Columns

10.2.3 Inserting, Updating, and Deleting Expressions

10.3 Applying the SQL EVALUATE Operator

10.4 Evaluation Semantics

10.5 Granting and Revoking Privileges

10.6 Error Messages

11 Indexing Expressions

11.1 Concepts of Indexing Expressions

11.2 Indexable Predicates

11.3 Index Representation

11.4 Index Processing

11.5 Predicate Table Query

11.6 Index Creation and Tuning

11.7 Index Usage

11.8 Index Storage and Maintenance

12 Expressions with XPath Predicates

12.1 Using XPath Predicates in Expressions

12.2 Indexing XPath Predicates

12.2.1 Indexable XPath Predicates

12.2.2 Index Representation

12.2.3 Index Processing

12.2.4 Index Tuning for XPath Predicates

13 Expressions with Spatial Predicates

13.1 Using Spatial Predicates in Expressions

13.2 Indexing Spatial Predicates

14 Using Expression Filter with Utilities

14.1 Bulk Loading of Expression Data

14.2 Exporting and Importing Tables, Users, and Databases

14.2.1 Exporting and Importing Tables Containing Expression Columns

14.2.2 Exporting a User Owning Attribute Sets

14.2.3 Exporting a Database Containing Attribute Sets

15 SQL Operators and Statements

ALTER INDEX REBUILD

ALTER INDEX RENAME TO

16 Object Types

17 Management Procedures Using the DBMS_EXPFIL Package

18 Expression Filter Views

18.1 USER_EXPFIL_ASET_FUNCTIONS View

18.2 USER_EXPFIL_ATTRIBUTES View

18.3 USER_EXPFIL_ATTRIBUTE_SETS View

18.4 USER_EXPFIL_DEF_INDEX_PARAMS View

18.5 USER_EXPFIL_EXPRESSION_SETS View

18.6 USER_EXPFIL_EXPRSET_STATS View

18.7 USER_EXPFIL_INDEX_PARAMS View

18.8 USER_EXPFIL_INDEXES View

18.9 USER_EXPFIL_PREDTAB_ATTRIBUTES View

18.10 USER_EXPFIL_PRIVILEGES View

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