This tutorial describes how you can quickly get started with RDF data in Autonomous Database.

1. Connect to your autonomous database instance as a user with administrative privileges and create a network owner user.

   CREATE USER rdfuser
   IDENTIFIED BY <password-for-rdfuser>
   QUOTA 5G ON DATA;

   Note:

   If you are using Database Actions, then you must REST Enable the user in order to enable the new user to access Database Actions. See Create User for more details.
2. Grant the required privileges to the newly created network owner user.
   You must be connected as a user with administrative privileges to run the following statement:

   GRANT CONNECT, RESOURCE, CREATE VIEW TO rdfuser;

   Note:

   If you are using Database Actions to create the new user in the preceding step, then the CONNECT and the RESOURCE privileges are provided by default. Hence, you must only grant the CREATE VIEW privilege to the new user.
3. Connect as the network owner user.

   CONNECT rdfuser/<password-for-rdfuser>

4. Create an RDF network by calling SEM_APIS.CREATE_RDF_NETWORK.

   You must create an RDF network as the intended owner of the schema-private network on the tablespace DATA.

   The following example creates a schema-private RDF network named net1 owned by network owner user rdfuser using the DATA tablespace.

   EXECUTE SEM_APIS.CREATE_RDF_NETWORK('DATA', network_owner=>'rdfuser', network_name=>'net1');

5. Create an RDF graph by calling SEM_APIS.CREATE_RDF_GRAPH.
   The following example creates an RDF graph named articles in the net1 schema-private network.

   EXECUTE SEM_APIS.CREATE_RDF_GRAPH('articles', NULL, NULL, network_owner=>'rdfuser', network_name=>'net1');
   

6. Insert triples into the RDF graph using one of the following options.
   • Use the SEM_APIS.UPDATE_RDF_GRAPH procedure to insert data:

     Note:

     The SEM_APIS.UPDATE_RDF_GRAPH function is supported only if Oracle JVM is enabled on your Oracle Autonomous Database Serverless deployments. To enable Oracle JVM, see Use Oracle Java in Using Oracle Autonomous Database Serverless for more information.

     You can insert triples into an RDF graph using SEM_APIS.UPDATE_RDF_GRAPH as shown in the examples in RDF Graph Management Examples (PL/SQL and Java).

   • Use the SQL INSERT statement to insert data:

     For example:

     INSERT INTO rdfuser.net1#rdft_articles(triple) VALUES (
       SDO_RDF_TRIPLE_S ('articles','<http://nature.example.com/Article1>',
         '<http://purl.org/dc/elements/1.1/title>','"All about XYZ"',
         network_owner=>'RDFUSER', network_name=>'NET1'));
     
     INSERT INTO rdfuser.net1#rdft_articles(triple) VALUES (
       SDO_RDF_TRIPLE_S ('articles','<http://nature.example.com/Article1>',
         '<http://purl.org/dc/elements/1.1/creator>','"Jane Smith"',
         network_owner=>'RDFUSER', network_name=>'NET1'));
     
     INSERT INTO rdfuser.net1#rdft_articles(triple) VALUES (
       SDO_RDF_TRIPLE_S ('articles',
         '<http://nature.example.com/Article1>',
         '<http://purl.org/dc/terms/references>',
         '<http://nature.example.com/Article2>',
         network_owner=>'RDFUSER', network_name=>'NET1'));
     
     INSERT INTO rdfuser.net1#rdft_articles(triple) VALUES (
       SDO_RDF_TRIPLE_S ('articles','<http://nature.example.com/Article2>',
         '<http://purl.org/dc/elements/1.1/title>','"A review of ABC"',
         network_owner=>'RDFUSER', network_name=>'NET1'));
     
     INSERT INTO rdfuser.net1#rdft_articles(triple) VALUES (
       SDO_RDF_TRIPLE_S ('articles','<http://nature.example.com/Article2>',
         '<http://purl.org/dc/elements/1.1/creator>','"Joe Bloggs"',
         network_owner=>'RDFUSER', network_name=>'NET1'));
     
     INSERT INTO rdfuser.net1#rdft_articles(triple) VALUES (
       SDO_RDF_TRIPLE_S ('articles',
         '<http://nature.example.com/Article2>',
         '<http://purl.org/dc/terms/references>',
         '<http://nature.example.com/Article3>',
         network_owner=>'RDFUSER', network_name=>'NET1'));

7. Execute SPARQL queries on the inserted data using one of the following options as applicable.
   • Query RDF data with the SEM_MATCH table function:

     Note:

     The SEM_MATCH table function is supported only if Oracle JVM is enabled on your Oracle Autonomous Database Serverless deployments. To enable Oracle JVM, see Use Oracle Java in Using Oracle Autonomous Database Serverless for more information.

     You can query the inserted triples data using the SEM_MATCH table function as shown in the examples in RDF Graph Management Examples (PL/SQL and Java).

   • Query RDF data using RDF Graph Server and Query UI:

     See Deploying RDF Graph Server and Query UI from Oracle Cloud Marketplace to launch the RDF Query UI application.

     You can query the inserted data by running SPARQL queries on the SPARQL query page in RDF Graph Query UI.

     Figure 2-1 Running SPARQL Query in RDF Graph Query UI

     
   • Query using SPARQL editor in SQL Developer:

     You can also run SPARQL queries using SPARQL editor in SQL Developer.

     Note:

     SQL Developer versions earlier than 21.2 is supported only if Oracle JVM is enabled on your Oracle Autonomous Database Serverless deployments. To enable Oracle JVM, see Use Oracle Java in Using Oracle Autonomous Database Serverless for more information.

     See Connect Oracle SQL Developer with a Wallet for creating a connection to your autonomous database instance using Cloud Wallet.