15.23 SEM_APIS.BUILD_RESULT_TAB
Format
SEM_APIS.BUILD_RESULT_TAB ( query_pattern_type IN NUMBER, result_tab_name IN VARCHAR2, rdf_graph_name IN VARCHAR2, key_string IN VARCHAR2, prefixes IN VARCHAR2 DEFAULT NULL, tablespace_name IN DBMS_ID DEFAULT NULL, degree IN NUMBER DEFAULT NULL, options IN VARCHAR2 DEFAULT NULL, network_owner IN DBMS_ID DEFAULT NULL, network_name IN VARCHAR2 DEFAULT NULL);
Description
Creates a result table of the specified type for the specified RDF graph.
More information on these parameters are described in the following Parameters section.
Parameters
- query_pattern_type
-
Type of the result table.
The value can be one of the following:SEM_APIS.SPM_TYPE_SVP
SEM_APIS.SPM_TYPE_MVP
SEM_APIS.SPM_TYPE_PCN
- result_tab_name
-
String for use as part of the name of the result table.
Must be
NULL
for an MVP table because the name is auto-generated asId(<property>)
for the (single) property specified in thekey_string
parameter. - rdf_graph_name
-
Name of the RDF graph.
- key_string
-
Specifies the list of properties to be included. Each of the properties must be single-valued based on the data in the RDF graph. If a property is preceded by a ‘
+
’ then the table will include the columns for the lexical values. To include a reversed property, use a ‘^
’ before the property. Use of+^:fatherOf
, for example, includes lexical value information for the reversed property (intuitively equivalent to a:hasFather
property with lexical value information). - prefixes
-
Specifies the prefixes relevant to properties used in the
key_string
parameter. Syntax is same asPREFIX
syntax used in SPARQL queries. - tablespace_name
-
Name of the target tablespace for the result table.
- degree
-
Degree of parallelism to use during the operation.
- options
-
String specifying any options to use during the operation.
Supported option is:
INMEMORY=T
: Builds the in-memory SVP table with all predicates or in-memory MVP table.S_INDEX=F
: Skips creation of the nonunique index on the START_NODE_ID column of MVP and PCN tables.P_INDEXES=F
: Skips creation of the nonunique indexes on the individual property columns of PCN tables.
- network_owner
-
Owner of the RDF network. (See Table 1-2.)
- network_name
-
Name of the RDF network. (See Table 1-2.)
Usage Notes
- This operation has a DDL semantics.
- The invoker must be the owner of the RDF graph or the RDF network or both.
Examples
The following example creates an SVP table:
BEGIN SEM_APIS.BUILD_RESULT_TAB( query_pattern_type => SEM_APIS.SPM_TYPE_SVP , result_tab_name => 'FLHF' , rdf_graph_name => 'M1' , key_string => ' :fname :lname :height ^:fatherOf ' , prefixes => ' PREFIX : <http://www.example.com#> ' , network_owner => 'RDFUSER' , network_name => 'NET1' ); END; /
The following example creates a PCN table:
BEGIN SEM_APIS.BUILD_RESULT_TAB( result_tab_name => ‘GRANDPA’ , query_pattern_type => SEM_APIS.SPM_TYPE_PCN , rdf_graph_name => 'M1' , key_string => ' S :fatherOf :fatherOf ' , prefixes => ' PREFIX : <http://www.example.com#> ' , network_owner => 'RDFUSER' , network_name => 'NET1' ); END; /
The following example creates an MVP table:
BEGIN SEM_APIS.BUILD_RESULT_TAB( query_pattern_type => SEM_APIS.SPM_TYPE_MVP , result_tab_name => null /* must be NULL (the name is auto-generated based on id(property) */ , rdf_graph_name => 'M1' , key_string => ' :motherOf ' /* must have exactly one property */ , prefixes => ' PREFIX : <http://www.example.com#> ' , network_owner => 'RDFUSER' , network_name => 'NET1' ); END; /
Parent topic: SEM_APIS Package Subprograms