Oracle Rules Manager and Oracle Expression Filter components

 

1. Description of the Rules Manager and Expression Filter components

 

Before the description, we first use the following SQL statement to check the components in the database:

SQL> Col comp_id for A15

SQL> Col version for A15

SQL> Col comp_name for A30

SQL> select comp_id, comp_name, versionfrom dba_registry;

 

Comp_id comp_name version

------------------------------------------------------------

XDB Oracle XML database 11.2.0.3.0

Amd olap catalog 11.2.0.3.0

Em Oracle Enterprise Manager 11.2.0.3.0

SDO spatial 11.2.0.3.0

Ordim Oracle multimedia 11.2.0.3.0

Context Oracle Text 11.2.0.3.0

ODM Oracle Data Mining 11.2.0.3.0

Exf Oracle Expression Filter 11.2.0.3.0

RUL Oracle Rules Manager 11.2.0.3.0

Owm Oracle Workspace Manager 11.2.0.3.0

Catalog Oracle Database catalog views 11.2.0.3.0

 

Comp_id comp_name version

------------------------------------------------------------

Catproc Oracle database packages and t11.2.0.3.0

Ypes

 

JavaVM jserver Java Virtual Machine 11.2.0.3.0

XML Oracle xdk 11.2.0.3.0

Catjava Oracle Database Java packages 11.2.0.3.0

Xoq Oracle olap api 11.2.0.3.0

Aps olap analytic workspace 11.2.0.3.0

 

17 rows selected.

 

Mos:

Oracle 8i/9i/10g/11g component (components) Description

Http://blog.csdn.net/tianlesoftware/article/details/5937382

 

The 10i newfeature allows you to store conditional expressions as data in the database. the expression filter provides a mechanic that you use to place a constrainton A varchar2 column to ensure that the values stored are valid SQL whereclause expressions. the mechanic also identifies the set of attributes thatcan be referenced in the conditional expressions.

-- A new feature of Oracle 10 Gb is to allow us to store conditional expressions in the form of data in the database. The expression filter component provides a mechanism through which constraints can be added to columns of the varchar2 type to ensure that valid SQL where condition expressions are stored. This mechanism can also mark a set of attributes, which can be used for reference in conditional expressions.

 

Oracleexpression filter, a feature of Oracle Database 10g, is a component of rulesmanager that allows application developers to store, index, and evaluateconditional expressions (expressions) in one or more columns of A relationaltable. expressions are a useful way to describe interests in expected data.

-- Expression Filter is a component of Rules Manager. It allows developers to store, index, and evaluate conditional expressions in one or more columns of the relevant table.

 

Expressionfilter matches incoming data with expressions stored in a column to identifyrows of interest. it can also derive complex relationships by matching data inone table with expressions in a second table. expression Filter simplifies sqlqueries; allows expressions to be inserted, updated, and deleted withoutchanging the application; and enables reuse of conditional expressions in rulesby separating them from the application and storing them in the database. applications involving information distribution, demand analysis, and taskassignment can benefit from Expression Filter.

-- Expression Filter uses expressions in columns to match input data. Expressionfilter simplifies SQL queries and allows expressions to perform insert, update, and delete operations without changing applications.

 

The rulesmanager and Expression Filter features are the same in the standard andenterprise editions. Support for indexing expressions is available only in theenterprise edition because it requires bitmap index support.

 

Component User:

EXFSYS:

Each is suppliedas a set of PL/SQL packages, a Java package, a set of dictionary tables, andcatalog views. All these objects are created in a dedicated schema namedexfsys.

 

Official Website description:

Oracleexpression filter Concepts 10gr2

 

 

Ii. Component Reconstruction

Mos:

Note 258618.1-how to install anduninstall Expression Filter feature or EXFSYS Schema

 

Official Website:

Installing rules managerand Expression Filter 11gr2

Http://docs.oracle.com/cd/E11882_01/appdev.112/e14919/exprn_app_e.htm

 

 

2.1 installing the EXFSYS Schema:

 

1. login as sysdba

2 .@? /Rdbms/admin/catexf. SQL

Note:

1. Installing Expression Filter does notautomatically install Rules Manager.
This component has to be installed separately using thecatrul. SQL script

-- Installing Expression Filter does not automatically install Rules Manager. All rulesmanagers must be installed independently using catrul. SQL.

2. When reinstalling Expression Filter, you may have to run utlrp. SQL torecompile some invalid objects.

-- When uninstalling Expression Filter, urlrp. SQL must be used to compile invalid objects.

 

During installation of oracledatabase, a demonstration script is installed for both the Rules Manager and Expression Filter features. the scripts ruldemo. SQL (Rules Manager demo) andexfdemo. SQL (Expression Filter demo) are located in the $ ORACLE_HOME/rdbms/demo/directory.

 

 

2.2 uninstalling the EXFSYS Schema:

1. login as sysdba

2 .@? /Rdbms/admin/catnoexf. SQL

Note:

1. uninstalling Expression Filter implicitly uninstallrules manager.

-- When the expression filter component is uninstalled, the Rules Manager component is automatically uninstalled.

 

2. The catnoexf. SQL script may not droppublic synonyms created by catexf. SQL.
However, with 11.2, it was verified no public synonyms fortable_owner = 'exfsys 'were left.

-- The catnoexf. SQL script does not delete public synonyms generated by catexf. SQL. However, starting from Oracle 11gr2, it verifies whether there is a public sysnonyms.

 

The followingscript can be used to drop all public synonyms created for Rules Manager andexpression filter when needed:

-- The following script deletes the public synonyms of all EXFSYS users:

 

Declare
Cursor cur1 is select synonym_name from all_synonyms where owner = 'public' and table_owner = 'exfsys ';
Begin
For C1 in cur1 Loop
Execute immediate 'drop public synonym' | dbms_assert.enquote_name (c1.synonym _ name, false );
End loop;
End;
/

 

In someversions before 10.2, or if you do not have the dbms_assert package, thefollowing script can be used instead:

-- If the dbms_assert package is not available before Oracle 10gr2, you can use the following script to delete public synonyms:

 

Declare
Cursor cur1 is select synonym_name from all_synonyms where owner = 'public' and table_owner = 'exfsys ';
Begin
For C1 in cur1 Loop
Execute immediate 'drop public synonym "'| c1.synonym _ name | '"';
End loop;
End;
/

 

Thefollowing is a list of the public synonyms that may remain after justrunning catnoexf. SQL and these wocould be dropped by running one of the abovescripts:

-- Catanoexf. SQL: the list of public synonyms that cannot be deleted is as follows:

Exf $ indexmetadata
Exf $ attribute
Exf $ attribute_list
Exf $ table_alias
Exf $ xpath_tag
Exf $ xpath_tags
Evaluate
Dbms_expfil
User_expfil_attribute_sets
All_expfil_attribute_sets
User_expfil_attributes
All_expfil_attributes
User_expfil_def_index_params
All_expfil_def_index_params
User_expfil_index_params
All_expfil_index_params
User_expfil_aset_functions
All_expfil_aset_functions
User_expfil_indexes
All_expfil_indexes
User_expfil_predtab_attributes
All_expfil_predtab_attributes
User_expfil_expression_sets
All_expfil_expression_sets
User_expfil_privileges
User_expfil_exprset_stats
All_expfil_exprset_stats
Rlm $ eventids
Rlm $ table_alias
Dbms_rlmgr
User_rlmgr_event_structs
All_rlmgr_event_structs
User_rlmgr_rule_classes
All_rlmgr_rule_classes
User_rlmgr_rule_class_status
All_rlmgr_rule_class_status
User_rlmgr_privileges
Adm_rlmgr_privileges
User_rlmgr_comprcls_properties
All_rlmgr_comprcls_properties
User_rlm4j_event_structs
User_rlm4j_rule_classes

 

 

 

 

 

 

Bytes -------------------------------------------------------------------------------------------------------

All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!

Skype: tianlesoftware

Email: tianlesoftware@gmail.com

Blog: http://www.tianlesoftware.com

WEAVER: http://weibo.com/tianlesoftware

Twitter: http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

LinkedIn: http://cn.linkedin.com/in/tianlesoftware

 

 

------- Add a group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, reject the application ----

Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)

Super DBA group: 63306533 (full); dba4 group: 83829929 dba5 group: 142216823

Dba6 group: 158654907 dba7 group: 172855474 DBA group: 104207940