Go to main content
1/36
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?
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 Continuous Query Notification (Formerly Database Change Notification)
4.8
Collection Events
4.8.1
Setting a Fixed Window Size or Length to Restrict the Number of Primitive Events
4.8.2
Using Collection Primitive Events to Form Composite Events
4.8.3
Collection Events Have NULL Values Stored in its rlm$CrtTime (Timestamp) Attribute
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
5.6.1
Setting a Fixed Window Size or Length to Restrict the Number of Primitive Events
5.6.2
More About Using the Having Clause
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
SQL Operators and Statements
EVALUATE
ALTER INDEX REBUILD
ALTER INDEX RENAME TO
CREATE INDEX
DROP INDEX
16
Using Expression Filter with Utilities
16.1
Bulk Loading of Expression Data
16.2
Exporting and Importing Tables, Users, and Databases
16.2.1
Exporting and Importing Tables Containing Expression Columns
16.2.2
Exporting a User Owning Attribute Sets
16.2.3
Exporting a Database Containing Attribute Sets
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
Scripting on this page enhances content navigation, but does not change the content in any way.