I described the setup procedure for Oracle Graph using Autonomous Database in a previous article. Oracle Graph can be used with all Oracle Database editions (except 12.2 and later), both on-premises or on-cloud, so let me also share the setup procedure using Database Cloud Service (DBCS) here. …

In this article, I will share a brief overview of the setup procedure for Oracle Graph using an Autonomous Database. The steps are explained more comprehensively in this workshop, so please see it for more details. Oracle Graph can be used with any edition of Oracle Database, on-premises or in…

Oracle Spatial, the spatial features of Oracle Database, provides a platform for managing, processing, and analyzing location-based and geospatial information. The platform enables people to understand and make better decisions based on the location relationships of their business entities, such as activities, incidents, events, and assets. In this article, I…

In Part 1, we have set up the environment to create a SPARQL endpoint using an Autonomous Database instance and a compute instance, both running as a part of the Always Free Services, which you can sign up for today.. In this part, we will upload an example RDF dataset…

What is SPARQL? The Resource Description Framework (RDF) is a general method to exchange data and metadata on the Web, and SPARQL is a standard query language to retrieve the data stored in RDF format. For publishing and linking data, many organizations provide SPARQL endpoints. This article will show you…

In Part 1 and Part 2, we explained that we can use Oracle Database itself as a graph database to store property graph datasets and execute PGQL queries. Also, for seamless integration, the CREATE PROPERTY GRAPH statement provides a declarative mapping method to convert datasets from tables to graphs. In…

In Part 1, I showed how to use the graph database API (PGQL as an alternative to SQL) to represent bank transaction data as a graph, and how to add nodes and edges and search against them using pattern matching. We’ll now look at a different approach: creating a graph…

In this article, as a first step in using Oracle Graph, we will look at how to manage bank transaction data as a graph and what kind of analysis can be done. Fraud detection in financial institutions is one of the major use cases for graph databases. …

In Part 1, I explained how to run Oracle Database on a container and use it as a graph database. …