This blog series(3) shows how to setup a fully-functioning RDF triplestore on the Oracle Public Cloud. We will show how configure Oracle Spatial and Graph – RDF Semantic Graph on an existing Oracle Database Cloud Service (DBCS) instance. In this example, we will use Oracle Database version 18.1.
Part 1 explains how to create a DBCS instance, refer to the tutorial link below and the HOW-TO document at the end of this blog. Subsequent posts in this blog series will show how to load a publicly-available RDF dataset and configure a W3C-standard SPARQL endpoint.
Part 2 will show how to use SQL Developer to load some publicly available RDF data into our DBCS instance and execute a few SPARQL queries with SQL Developer's SPARQL query editor.
Part 3 we will complete the setup of our RDF triplestore in the Oracle Public Cloud by configuring a W3C-standard SPARQL endpoint.
Expiring the announcement will not delete it but will remove it from the public announcement list. Are you sure you want to expire this announcement?
Are you sure you want to delete this announcement?
RDF Support in SQL Developer You can use Oracle SQL Developer to create RDF-related objects and use RDF and OWL features. This RDF support is available through the Connections navigator in SQL Developer. If you expand an Oracle Database connection, near the bottom of the child nodes for the connection is RDF Semantic Graph; and if you expand that, its child nodes are:
• Network Indexes (RDF_LINK$)
• Data Type Indexes (RDF_VALUE$)
• Bulk Load Traces
You can Create the Semantic Network In the Connections navigator (not the DBA navigator), expand the system connection and navigate to the RDF Semantic Graph node. Create the semantic network in the RDFTBS tablespace:
• Right-click RDF Semantic Graph and select Create Semantic Network (DBA).
• On the Prompts tab, for Tablespace select the tablespace for storing RDF data (for example, RDFTBS) and click Apply.
Go to https://www.oracle.com/database/technologies/appdev/sql-developer.html and download SqlDeveloper with Rdf Knowledge Graph support.
Go to https://docs.oracle.com/en/database/oracle/oracle-database/18/rdfrm/rdf-semantic-graph-overview.html#GUID-8663128B-C6A9-4B5A-97F0-3F521F7A3B1C for additional documention.
PGX is a fast, parallel, in-memory graph analytic framework. Using PGX, the users can load up graphs into main-memory, run various graph algorithms on them very efficiently, explore their results, and export them back into the file system.
Checkout our overview page for more details.
Or head straight to our download page to get started.
We have also prepared some easy to follow tutorials as part of initial documentation to get you going.
This is only the beginning, we have lots of cool things coming down the pipe. We would love to get feedback from the community on what they like, what things they think should be changed, and what missing features we should add in the future.
Have fun with PGX and all of us are looking forward to interacting with you on this OTN Community
Support for these open source technologies now includes Apache Jena 3.1.0 and Apache Jena Fuseki 2.4.0, both standalone and web application versions.
It also includes dynamic SPARQL endpoint and CSRF protection, updated support for Protege Desktop 5.0, optimized support for SPARQL 1.1 query syntax and a smart router for small to medium size RDF/OWL datasets.
This set of adapters and plugins provides a feature rich Java-based interface to RDF Knowledge Graph that implements the well-known Apache Jena Graph, Model, BulkUpdateHandler, and DatasetGraph APIs. It supports SPARQL 1.1 and OGC GeoSPARQL queries. It runs on Oracle WebLogic Server, as well as Apache Tomcat and JBoss Application Servers. It includes a SPARQL Gateway for tools that support an XML data source to query an RDF Graph in Oracle Database. New Oracle Support for Apache Jena and Fuseki, and Protégé Desktop with 19c support, look for March 2019 download
RDF Semantic Graph