9.3 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; /
Parent topic: OPG_APIS Package Subprograms