15.48 SEM_APIS.CREATE_SPARQL_UPDATE_TABLES

Format

SEM_APIS.CREATE_SPARQL_UPDATE_TABLES();

Description

Creates global temporary tables in the caller’s schema for use with SPARQL Update operations.

Parameters

None.

Usage Notes

Invoking SEM_APIS.UPDATE_MODEL with STREAMING=F, FORCE_BULK=T, or DEL_AS_INS=T option requires that the following temporary tables exist in the caller’s schema: RDF_UPD_DEL$, RDF_UPD_INS$, and RDF_UPD_INS_CLOB$. These tables are created with the following definitions , where MAX_STRING_SIZE is the maximum VARCHAR size for the database:

  CREATE GLOBAL TEMPORARY TABLE RDF_UPD_DEL$ (
    RDF$STC_GRAPH VARCHAR2(4000),
    RDF$STC_SUB   VARCHAR2(4000),
    RDF$STC_PRED  VARCHAR2(4000),
    RDF$STC_OBJ   VARCHAR2(MAX_STRING_SIZE),
    RDF$STC_CLOB  CLOB
  ) ON COMMIT PRESERVE ROWS';
  CREATE GLOBAL TEMPORARY TABLE RDF_UPD_INS$ (
    RDF$STC_GRAPH VARCHAR2(4000),
    RDF$STC_SUB   VARCHAR2(4000),
    RDF$STC_PRED  VARCHAR2(4000),
    RDF$STC_OBJ   VARCHAR2(MAX_STRING_SIZE)
  ) ON COMMIT PRESERVE ROWS';
  CREATE GLOBAL TEMPORARY TABLE RDF_UPD_INS_CLOB$ (
    RDF$STC_GRAPH VARCHAR2(4000),
    RDF$STC_SUB   VARCHAR2(4000),
    RDF$STC_PRED  VARCHAR2(4000),
    RDF$STC_OBJ   VARCHAR2(MAX_STRING_SIZE),
    RDF$STC_CLOB  CLOB
  ) ON COMMIT PRESERVE ROWS';

If you need to drop these tables, use the SEM_APIS.DROP_SPARQL_UPDATE_TABLES.

For more information, see Support for SPARQL Update Operations on an RDF Graph.

Examples

The following example creates the necessary global temporary tables in the caller’s schema for use with SPARQL Update operations.

EXECUTE SEM_APIS.CREATE_SPARQL_UPDATE_TABLES;