1 PACKAGE drvtmt AUTHID current_user AS
2
3 type col_phrases IS TABLE OF varchar2(200) INDEX BY BINARY_INTEGER;
4
5 FUNCTION noex_tabname(
6 l_owner IN varchar2,
7 prx IN varchar2) return VARCHAR2;
8
9 /* validate the result table, if not exists, create one
10 The table should have three columns
11 cat_id number,
12 type number,
13 rule blob
14 */
15 PROCEDURE model_tab(
16 tabname IN OUT varchar2);
17
18 /* validate the table, if not exists, create one
19 The table should have three columns
20 docid number -- document ID to identify a document
21 clusterid number -- the ID of the cluster the document is assigned to
22 score number -- the similarity score between document and cluster
23 */
24 PROCEDURE doccls_tab(
25 tabname IN OUT varchar2);
26
27 /* validate the table, if not exists, create one
28 The table should have three columns
29 clusterid number -- cluster ID to identify a cluster
30 descript varchar2(4000) -- a string to describe the cluster
31 label varchar2(200) -- a suggested label for the cluster
32 sze number -- number of documents assigned to the cluster
33 quality_score number -- the quality score of the cluster
34 parent number -- parent cluster id. negative means no parent
35 */
36 PROCEDURE cluster_tab(
37 tabname IN OUT varchar2);
38
39 /* verify the train document tables */
40 PROCEDURE verify_traindoc(
41 lv_doctab IN OUT varchar2,
42 docid IN varchar2);
43
44 PROCEDURE verify_traincat(
45 cattab IN OUT varchar2,
46 catdocid IN varchar2,
47 catid IN varchar2);
48
49 /* verify result model table */
50 PROCEDURE verify_modeltab (
51 lv_restab IN OUT varchar2 );
52
53 END drvtmt;