OPG_APIS.CF_CLEANUP

Format

OPG_APIS.CF_CLEANUP(
     wt_l            IN/OUT  VARCHAR2, 
     wt_r            IN/OUT  VARCHAR2, 
     wt_l1           IN/OUT  VARCHAR2, 
     wt_r1           IN/OUT  VARCHAR2, 
     wt_i            IN/OUT  VARCHAR2, 
     wt_ld           IN/OUT  VARCHAR2, 
     wt_rd           IN/OUT  VARCHAR2, 
     options         IN      VARCHAR2 DEFAULT NULL);

Description

Preforms cleanup work after graph collaborative filtering has been done. All the working tables that hold intermediate tables and the output matrix factors are dropped.

Parameters

edge_tab_name: Name of the property graph edge table (GE$).
wt_l: Name of the working table that holds the left side of the matrix factorization.
wt_r: Name of the working table that holds the right side of the matrix factorization.
wt_l1: Name of the working table that holds the left side intermediate step in the gradient descent.
wt_r1: Name of the working table that holds the right side intermediate step in the gradient descent.
wt_I: Name of the working table that holds intermediate matrix product.
wt_ld: Name of the working table that holds intermediate left side delta in gradient descent.
wt_rd: Name of the working table that holds intermediate right side delta in gradient descent.
options: (Reserved for future use.)

Usage Notes

Call this procedure only when you have no interest in keeping the output matrix factors and the current progress of the algorithm for future use.

Do not call this procedure if more predictions will be made using the resulting product factors (wt_l and wt_r tables), unless you have previous made backup copies of these two tables.

See also the information about the OPG_APIS.CF procedure.

Examples

The following example drops the working tables that were created in the example for the OPG_APIS.CF_PREP procedure.

DECLARE
  wt_l varchar2(32)  = 'phonesge$$CFL57';
  wt_r varchar2(32)  = 'phonesge$$CFR57';
  wt_l1 varchar2(32) = 'phonesge$$CFL157';
  wt_r1 varchar2(32) = 'phonesge$$CFR157';
  wt_i varchar2(32)  = 'phonesge$$CFI57';
  wt_ld varchar2(32) = 'phonesge$$CFLD57';
  wt_rd varchar2(32) = 'phonesge$$CFRD57';
BEGIN
  opg_apis.cf_cleanup('phonesge$',wt_l,wt_r,wt_l1,wt_r1,wt_i,wt_ld,wt_rd);
END;
/