SEM_APIS.SPARQL_TO

Format

SEM_APIS.SPARQL_TO_SQL(
    sparql_query  IN CLOB,
    models        IN RDF_MODELS DEFAULT NULL, 
    rulebases     IN RDF_RULEBASES DEFAULT NULL,
    aliases       IN RDF_ALIASES DEFAULT NULL, 
    index_status  IN VARCHAR2 DEFAULT NULL, 
    options       IN VARCHAR2 DEFAULT NULL
    graphs        IN RDF_GRAPHS DEFAULT NULL,
    named_graphs  IN RDF_GRAPHS DEFAULT NULL,
    network_owner IN VARCHAR2 DEFAULT NULL,
    network_name  IN VARCHAR2 DEFAULT NULL) RETURN CLOB;

Description

Translates a SPARQL query into a SQL query string that can be executed by an application program.

Parameters

sparql_query: A string literal with one or more triple patterns, usually containing variables.
models: The model or models to use.
rulebases: One or more rulebases whose rules are to be applied to the query
aliases: One or more namespaces to be used for expansion of qualified names in the query pattern.
index_status: The status of the relevant entailment for this query.
options: Options that can affect the results of queries.
graphs: The set of named graphs from which to construct the default graph for the query.
named_graphs: The set of named graphs that can be matched by a GRAPH clause.
network_owner: Owner of the semantic network. (See Table 1-2.)
network_name: Name of the semantic network. (See Table 1-2.)

Usage Notes

Before using this procedure, be sure you understand the material in Using the SEM_APIS.SPARQL_TO_SQL Function to Query RDF Data.

For information about semantic network types and options, see RDF Networks.

Examples

The following example translates a SPARQL query into a SQL query string.

DECLARE
  sparql_stmt clob;
  sql_stmt    clob;
BEGIN
  sparql_stmt := '{?x :grandParentOf ?y . ?x rdf:type :Male}';
  sql_stmt := sem_apis.sparql_to_sql(
                sparql_stmt,
                sem_models('family'),
                SEM_Rulebases('RDFS','family_rb'),
                SEM_ALIASES(SEM_ALIAS('','http://www.example.org/family/')),
                null);
  execute immediate
    'create table gf_table as 
     select x grandfather, y grandchild from('|| sql_stmt || ')';
END;
/