Simple Steps to Create an RDF Graph in Graph Studio

Oracle Autonomous Database includes Graph Studio, which automates graph data management, making it simple to model, analyze and visualize data. Analysts and developers can use this tool to find connections, detect unusual patterns, and link data.

RDF graphs are particularly well-suited for knowledge graphs and data integration applications because URIs provide globally unique identifiers and the simple, schema-less triple structure makes it very easy to combine data from several different RDF graphs into a single graph.

This article will demonstrate how easy and fast it is to create an RDF graph in Graph Studio. I will be using pre-authenticated (PAR) object storage containing an RDF triple file with movie data. This hands-on workshop also goes over how to create an RDF graph and queries!

Prerequisites

• Deploy an Autonomous Database
• Create a Graph enabled user

This blog helps you execute the above steps.

• Have your dataset in an object storage bucket that can be accessed by a pre-authenticated URL (see here for details).

Note: An object storage bucket location with other types of credentials can also be used to store your data.

Let's jump right into creating our RDF Graph!

Create an RDF Graph in Graph Studio

1. Navigate to your Autonomous Database in the Oracle Cloud Infrastructure Console and open Tools.

2. Open Graph Studio and log in with the user name and password you created. (Steps on how to deploy an Autonomous Database and create a Graph user)

3. Click on Graphs on the navigation menu from the left to navigate the Graphs page.

4. In the Graph Type dropdown menu, select RDF and click the Create button on the top-right corner of the interface.

5. Create RDF Graph Wizard opens as shown:

6. Enter the OCI Object Storage URI path. In this example, we are using this PAR object storage URI.

7. Click No Credential (because we are using a PAR URI).

8. Click Next. The following dialog should appear; enter your graph name:

9. Click Create. The RDF graph creation job will be initiated. You can monitor the job on the Jobs page in Graph Studio.

When succeeded, the status will change from pending to succeeded, and logs can be viewed by clicking on the three dots on the right side of the job row and selecting See Log. The log for the job displays details as shown below:

Tue, Mar 1, 2022 08:21:04 AM
Finished execution of task Graph Creation - MOVIESTREAM.

Tue, Mar 1, 2022 08:21:04 AM
Graph MOVIESTREAM created successfully

Tue, Mar 1, 2022 08:21:04 AM
Optimizer Statistics Gathered successfully

Tue, Mar 1, 2022 08:20:50 AM
External table <graph-user>_TAB_EXTERNAL dropped successfully

Tue, Mar 1, 2022 08:20:49 AM
Data successfully bulk loaded from ORACLE_ORARDF_STGTAB

Tue, Mar 1, 2022 08:20:39 AM
Model MOVIESTREAM created successfully

Tue, Mar 1, 2022 08:20:37 AM
Network RDF_NETWORK created successfully

Tue, Mar 1, 2022 08:20:24 AM
Data loaded into the staging table ORACLE_ORARDF_STGTAB from <graph-user>_TAB_EXTERNAL

Tue, Mar 1, 2022 08:20:19 AM
External table <graph-user>_TAB_EXTERNAL created successfully

Tue, Mar 1, 2022 08:20:19 AM
Using the Credential MOVIES_CREDENTIALS

Tue, Mar 1, 2022 08:20:19 AM
Started execution of task Graph Creation - MOVIESTREAM.

Validate your RDF graph

You can explore and validate the newly created RDF graph on the Graphs page in Graph Studio as shown:

1. Navigate to the Graphs page and set the Graph Type to RDF using the dropdown menu. Select your graph row from the available RDF graphs, sample statements (triples or quads should appear), and use the three horizontal dots to resize these statements and bring them into view. Sample statements (triples or quads) from the RDF Graph are displayed on the bottom panel as shown:

Now you can go ahead and query and visualize your RDF graph!

Useful links to learn more about Oracle Graph:

• Medium (= all articles with Oracle Graph tag)
• Stack Overflow (= questions with oracle-graph tag)
• Slack AnDOUC (= invitation link, please visit #graph)
• Slack OracleDevRel (= invitation link, please visit #oracle-db-graph)

Want to discuss? Join our public Slack channel to talk to other Oracle developers!