Oracle Rules Manager

Rules Manager is a feature of Oracle Database that uses the Expression Filter and object relational features to provide the features of a special-purpose rules engine with greater scalability and better operational characteristics.

Rules Manager and Expression Filter provide a SQL schema and PL/SQL and Java packages that store, retrieve, update, and query collections of expressions (rule conditions) in an Oracle Database. All these objects are created in a dedicated schema named EXFSYS.

Rules Manager and Expression Filter are installed automatically with Oracle Database Standard Edition and Oracle Database Enterprise Edition and higher.

Oracle Expression Filter, a feature beginning in Oracle Database 10g, is a component of Rules Manager that allows application developers to store, index, and evaluate conditional expressions (expressions) in one or more columns of a relational table. Expressions are a useful way to describe interests in expected data.

 

·        The script to install Rules Manager is named  :

catrul.sql under $ORACLE_HOME/rdbms/admin/directory.

·        Rules Manager can be uninstalled using :

catnorul.sql script in the same directory

·        The script to install the Expression Filter is named :

catexf.sql under $ORACLE_HOME/rdbms/admin/directory.

·        Expression Filter can be uninstalled using :

catnoexf.sql script in the same directory

·        Rules Manager  RUL and Expression Filter  EXF components :

SQL>select comp_id from dba_registry where comp_id in('EXF','RUL');
SQL> select comp_id, comp_name, version, status from dba_registry ;

NOTE: These scripts should be executed from a SQL*Plus session while connected as SYSDBA. Uninstalling Expression Filter implicitly uninstalls Rules Manager.


The Rules Manager and Expression Filter features are the same in the Standard and Enterprise Editions. Support for indexing expressions is available only in the Enterprise Edition because it requires bitmap index support.