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 AI 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: network_owner and network_name Parameters.)

network_name

Name of the RDF network. (See Table: network_owner and network_name Parameters.)

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'));