Oracle | DMP

Oracle DMP_SEC Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Data Mining Predictive Analytics Support Utilities

AUTHID DEFINER

Dependencies

ALL_MINING_MODELS	DBMS_DM_EXP_INTERNAL	DM_ITEMS
ALL_TABLES	DBMS_DM_MODEL_EXP	DM_QGEN
COL$	DBMS_DM_MODEL_IMP	MODELALG_SEQ$
COLTYPE$	DBMS_DM_UTIL	OBJ$
DBA_MINING_MODELS	DBMS_PREDICTIVE_ANALYTICS	ODM_MODEL_UTIL
DBA_MINING_MODEL_ATTRIBUTES	DBMS_STANDARD	ODM_UTIL
DBA_MINING_MODEL_TABLES	DBMS_STATS	ORA_MINING_VARCHAR2_NT
DBMS_ASSERT	DBMS_SYS_ERROR	PLITBLM
DBMS_DATAPUMP	DBMS_UTILITY	TAB$
DBMS_DATA_MINING	DMP_SYS	USER$
DBMS_DATA_MINING_INTERNAL	DMUTIL_LIB	V$PARAMETER
DBMS_DATA_MINING_TRANSFORM	DM_ITEM	_CURRENT_EDITION_OBJ

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtdmsu.plb

Subprograms

ADD_MODEL_TABLE	GET_FUNCTION_NAME	GET_MODEL_DETAILS_OC
CHECK_SCHEMA	GET_MODEL_COST_MATRIX	GET_MODEL_DETAILS_SVD
CREATE_EMPTY_MODEL	GET_MODEL_DETAILS_AI	GET_MODEL_DETAILS_SVM
DROP_ALGORITHM_INTERNAL	GET_MODEL_DETAILS_EM	GET_MODEL_DETAILS_TREE_XML
DROP_MODEL_TABLES	GET_MODEL_DETAILS_EM_COMP	GET_MODEL_TABLE
DROP_TABLE	GET_MODEL_DETAILS_EM_PROJ	GET_MODEL_TABLES
FETCH_ALG_SCHEMA_INTERNAL	GET_MODEL_DETAILS_GLM	INSERT_ALGORITHM
GATHER_MODEL_STATS	GET_MODEL_DETAILS_GLOBAL	LOAD_MODEL
GET_ALGORITHM_NAME	GET_MODEL_DETAILS_KM	MODEL_EXISTS
GET_ASSOCIATION_RULES	GET_MODEL_DETAILS_NB	RECKON_TABLE_SIZE
GET_FREQUENT_ITEMSETS	GET_MODEL_DETAILS_NMF

ADD_MODEL_TABLE

Undocumented dmp_sec.add_model_table( model_name IN VARCHAR2, table_type IN VARCHAR2, table_name IN VARCHAR2, owner_num IN NUMBER);

TBD

CHECK_SCHEMA

Undocumented dmp_sec.check_schema( schema_content IN VARCHAR2, schema_type IN NUMBER, res IN OUT BINARY_INTEGER);

TBD

CREATE_EMPTY_MODEL

Undocumented dmp_sec.create_empty_model( model_name IN VARCHAR2, mining_function IN VARCHAR2, algorithm IN VARCHAR2, target_attribute IN VARCHAR2, build_duration IN NUMBER, model_size IN NUMBER, build_version IN NUMBER, user_no IN NUMBER, user_name IN VARCHAR2);

TBD

DROP_ALGORITHM_INTERNAL

Undocumented dmp_sec.drop_algorithm_internal(algorithm_name IN VARCHAR2);

SELECT table_name

      FROM dba_tab_cols

      WHERE column_name = 'ALGORITHM_NAME'

      ORDER BY 1;

      

      TABLE_NAME

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

      ALL_MINING_ALGORITHMS

      DM_USER_MODELS

      GV_$RMAN_COMPRESSION_ALGORITHM

      V_$RMAN_COMPRESSION_ALGORITHM

      V_$RMAN_ENCRYPTION_ALGORITHMS

DROP_MODEL_TABLES

Drops the tables in a model by schema dmp_sec.drop_model_tables( model_name IN VARCHAR2, schema_name IN VARCHAR2);

TBD

DROP_TABLE

Drops any heap normal heap table. Presumably drops any table other than blockchain or immutable but other table types remain to be tested. dmp_sec.drop_table( table_name IN VARCHAR2, schema_name IN VARCHAR2);

CREATE TABLE c##uwclass.test AS

      SELECT * FROM user_tables;

      

      Table created.

      

      exec dmp_sec.drop_table('TEST', 'C##UWCLASS');

      

      SQL> desc c##safedba.test

      ERROR:

      ORA-04043: object c##uwclass.test does not exist

FETCH_ALG_SCHEMA_INTERNAL

Undocumented dmp_sec.fetch_alg_schema_internal RETURN CLOB;

SELECT dmp_sec.fetch_alg_schema_internal

      FROM dual;

      

      FETCH_ALG_SCHEMA_INTERNAL

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

      {

        "type": "object",

        "properties": {

          "algo_name_display": { "type" : "object", "properties" : { "language" : { "type" : "string","enum" : ["English", "Spanish", "French"], "default" : "English"}, "name" : { "type" : "string"}

              }

            },

          "function_language": {"type": "string" },

          "mining_function": {

            "type" : "object",

            "properties" :

              { "type" : "object",

                "properties" : {

                  "mining_function_name" : { "type" : "string"},

                  "build_function": {

                    "type": "object",

                    "properties": { "function_body": { "type": "CLOB," }

                      }

                    },

                  "detail_function": {

                    "type" : "array",

                    "items" : [

      ...

                "categorical choices" : { "type": "array",
      "items": {"type": "string"

                     }

                   },

                "description_display": { "type" : "object",

                  "properties" : { 

                    "language" : { "type" : "string",
      "enum" : ["English", "Spanish", "French"], "default" : "English"}, "name" : { "type" : "string"}}

                  }

                }

              }

            ]

          }

        }

      }

GATHER_MODEL_STATS

Undocumented dmp_sec.gather_model_stats( model_name IN VARCHAR2, schema_name IN VARCHAR2);

TBD

GET_ALGORITHM_NAME

Undocumented dmp_sec.get_algorithm_name( p_model_name IN VARCHAR2, p_user_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_ASSOCIATION_RULES

Undocumented dmp_sec.get_association_rules( model_name IN VARCHAR2, schema_name IN VARCHAR2, topn IN NUMBER, rule_id IN NUMBER, min_confidence IN NUMBER, min_support IN NUMBER, min_lift IN NUMBER, max_rule_length IN NUMBER, min_rule_length IN NUMBER, sort_order IN sys.ora_mining_varchar2_nt, antecedent_items IN sys.dm_items, 1consequent_items IN sys.dm_items, 1partition_name IN VARCHAR2, 1partitioned IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_FREQUENT_ITEMSETS

Undocumented dmp_sec.get_frequent_itemset( model_name IN VARCHAR2, schema_name IN VARCHAR2, topn IN NUMBER, max_itemset_length IN NUMBER, partition_name IN VARCHAR2, partitioned IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_FUNCTION_NAME

Undocumented dmp_sec.get_function_name( p_model_name IN VARCHAR2, p_user_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_COST_MATRIX

Undocumented dmp_sec.get_model_cost_matrix( model_name IN VARCHAR2, schema_name IN VARCHAR2, partitioned IN VARCHAR2, partition_name IN VARCHAR2, matrix_type IN VARCHAR2);

TBD

GET_MODEL_DETAILS_AI

Undocumented dmp_sec.get_model_details_ai( model_rec IN sys.odm_model_util.model_rec, model_name IN VARCHAR2, schema_name IN VARCHAR2, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_EM

Undocumented dmp_sec.get_model_details_em( model IN sys.odm_model_util.model_rec, schema_name IN VARCHAR2, cluster_id IN NUMBER, attribute IN VARCHAR2, centroid IN NUMBER, histogram IN NUMBER, rules IN NUMBER, attribute_subname IN VARCHAR2, topn_attributes IN NUMBER, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_EM_COMP

Undocumented dmp_sec.get_model_details_em_comp( model IN sys.odm_model_util.model_rec, model_name IN VARCHAR2, schema_name IN VARCHAR2, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_EM_PROJ

Undocumented dmp_sec.get_model_details_em_proj( model IN sys.odm_model_util.model_rec, model_name IN VARCHAR2, schema_name IN VARCHAR2, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_GLM

Undocumented dmp_sec.get_model_details_glm( model_name IN VARCHAR2, schema_name IN VARCHAR2, model_rec IN sys.odm_model_util.model_rec, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_GLOBAL

Undocumented dmp_sec.get_model_details_global( model IN sys.odm_model_util.model_rec, model_name IN VARCHAR2, schema_name IN VARCHAR2, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_KM

Undocumented dmp_sec.get_model_details_km( model IN sys.odm_model_util.model_rec, schema_name IN VARCHAR2, cluster_id IN NUMBER, attribute IN VARCHAR2, centroid IN NUMBER, histogram IN NUMBER, rules IN NUMBER, attribute_subname IN VARCHAR2, bulk_collect_num_rows IN OUT NUMBER, topn_attributes IN NUMBER, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_NB

Undocumented dmp_sec.get_model_details_nb( model_rec IN sys.odm_model_util.model_rec, model_name IN VARCHAR2, schema_name IN VARCHAR2, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_NMF

Undocumented dmp_sec.get_model_details_nmf( model_name IN VARCHAR2, schema_name IN VARCHAR2, model_rec IN sys.odm_model_util.model_rec, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_OC

Undocumented dmp_sec.get_model_details_oc( model IN sys.odm_model_util.model_rec, schema_name IN VARCHAR2, cluster_id IN NUMBER, attribute IN VARCHAR2, centroid IN NUMBER, histogram IN NUMBER, rules IN NUMBER, topn_attributes IN NUMBER, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_SVD

Undocumented dmp_sec.get_model_details_svd( model_name IN VARCHAR2, schema_name IN VARCHAR2, model_rec IN sys.odm_model_util.model_rec, matrix_type IN VARCHAR2, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_SVM

Undocumented dmp_sec.get_model_details_svm( model_name IN VARCHAR2, schema_name IN VARCHAR2, model IN sys.odm_model_util.model_rec, reverse_coef IN NUMBER, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_TREE_XML

Undocumented dmp_sec.get_model_details_tree_xml( model_name IN VARCHAR2, schema_name IN VARCHAR2, stmt IN OUT sys.dbms_sql.varchar2s, stmtlen IN OUT BINARY_INTEGER, stmt_scoredist IN OUT VARCHAR2, stmt_split IN OUT VARCHAR2, stmt_splitcnt IN OUT VARCHAR2, stmt_splitcat IN OUT VARCHAR2, basepred IN OUT sys.dbms_sql.varchar2s, basepredcnt IN OUT BINARY_INTEGER, partition_name IN VARCHAR2, partitioned IN VARCHAR2);

TBD

GET_MODEL_TABLE

Undocumented dmp_sec.get_model_table( p_model_name IN VARCHAR2, p_table_type IN VARCHAR2, p_user_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_TABLES

Undocumented dmp_sec.get_model_tables( p_model_name IN VARCHAR2, p_user_name IN VARCHAR2) RETURN sys.odm_model_util.model_tables_list;

TBD

INSERT_ALGORITHM

Undocumented dmp_sec.insert_algorithm( algorithm_name IN VARCHAR2, mining_function IN NUMBER, algorithm_type IN VARCHAR2, algorithm_metadata IN CLOB, algorithm_description IN VARCHAR2);

TBD

LOAD_MODEL

Undocumented dmp_sec.load_model( p_model_name IN VARCHAR2, p_owner_name IN VARCHAR2, p_partition_name_in IN VARCHAR2, p_partition_name_out OUT VARCHAR2, p_validate_pname IN BOOLEAN, p_load_settings IN BOOLEAN, p_load_xforms IN BOOLEAN) RETURN sys.odm_model_util.model_rec;

TBD

MODEL_EXISTS

Undocumented dmp_sec.model_exists( p_model_name IN VARCHAR2, p_user_name IN VARCHAR2) RETURN BOOLEAN,;

TBD

RECKON_TABLE_SIZE

Undocumented dmp_sec.reckon_table_size( user_name IN VARCHAR2, table_name IN VARCHAR2, has_stats IN NUMBER, block_size IN OUT NUMBER) RETURN NUMBER,;

TBD