15.36 SEM_APIS.CREATE_MATERIALIZED_VIEW
Format
SEM_APIS.CREATE_MATERIALIZED_VIEW ( mv_name IN VARCHAR2, model_name IN VARCHAR2, compression IN BOOLEAN DEFAULT TRUE, inmemory IN BOOLEAN DEFAULT FALSE, values_as_vc IN BOOLEAN DEFAULT FALSE, refresh IN VARCHAR2 DEFAULT 'C', pred_list IN SYS.ODCIVARCHAR2LIST DEFAULT NULL, options IN VARCHAR2 DEFAULT NULL, network_owner IN VARCHAR2 DEFAULT NULL, network_name IN VARCHAR2 DEFAULT NULL, );
Description
Creates a materialized view for an RDF graph stored in Oracle Database.
Parameters
- mv_name
-
Name of the materialized view to create.
- model_name
-
Name of the model on which to create the materialized view.
- compression
-
Specifies whether the materialized view is compressed.
- inmemory
-
Specifies whether the materialized view is created in IMC format.
- values_as_vc
-
Specifies whether the values of G,S,P,O are created as virtual columns.
- refresh
-
The materialized view refresh method.
- pred_list
-
Specifies the predicates list.
- options
-
String specifying any options to use during the create materialized view operation.
Supported options are:
TABLESPACE= <name>:
materialized view is created in the named tablespace.PARALLEL= <degree>:
materialized view is created with the parallel degree <degree>.
- network_owner
-
Owner of the RDF network. (See Table 1-2.)
- network_name
-
Name of the RDF network. (See Table 1-2.)
Usage Notes
For conceptual and usage information, see RDF Support for Materialized Join Views.
For information about RDF network types and options, see RDF Networks.
Examples
The following example creates the materialized view MVX for the RDF model M0.
EXECUTE SEM_APIS.CREATE_MATERIALIZED_VIEW('MVX', 'M0');
The following example creates the materialized view MVX for the RDF virtual model VM0.
EXECUTE SEM_APIS.CREATE_MATERIALIZED_VIEW('MVX', 'VM0');
The following example creates the materialized view MVY for the RDF model M1 using the following supported options:
EXECUTE SEM_APIS.CREATE_MATERIALIZED_VIEW('MVY','M1',options=>' TABLESPACE=TBS_3 PARALLEL=2 ');
The following example creates the materialized view MVX for the RDF model M0 using a list of predicates.
EXECUTE SEM_APIS.CREATE_MATERIALIZED_VIEW('MVX','M0', pred_list=>sys.odcivarchar2list('http://www.w3.org/2002/07/owl#sameAs', 'http://foo-example.com/name/hasSSN'));
Parent topic: SEM_APIS Package Subprograms