Published inOracle DevelopersSchema-less Graphs Using SQLAs previously introduced in this article, the current SQL specification (SQL:2023) includes syntax for defining graphs based on table data…Sep 28, 202483Sep 28, 202483
Accelerate Vector Search with Indexing in Oracle 23aiIn the previous article, I introduced the vector distance-based search. Since then, many articles have provided more comprehensive…Sep 15, 20246Sep 15, 20246
Full-Text Search in JSON using SQLUsing the JSON function JSON_TEXTCONTAINS in SQL, you can search for JSON data containing specified strings.Jul 21, 202417Jul 21, 202417
Vector Search in Oracle 23aiAfter months of waiting, the Oracle Database update 23.4.0, which features vector search capabilities, has finally been released. It’s now…May 5, 202434May 5, 202434
Build Graph Server Container (23.4)(The procedure below was tested with Graph Server 23.4.0 and Oracle Database 23.3.0.)Nov 13, 2023431Nov 13, 2023431
Analyze Bank Transaction Data using Graph (Part 2/2)In Part 1, we explained that we can use Oracle Database 23c as a graph database to create property graphs from tables and execute graph…Jul 14, 202361Jul 14, 202361
Analyze Bank Transaction Data using Graph (Part 1/2)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…Jul 13, 202311Jul 13, 202311
User-Defined Functions (UDFs) in Oracle GraphOracle Graph provides an in-memory graph analysis engine called PGX, in addition to the ability to work with graphs on Oracle Database…May 30, 20232May 30, 20232
Count the Number of Parts Using GraphsIn my previous article, “Powerful Graph Search for Traceability in Manufacturing”, I introduced how Oracle Graph can achieve…May 26, 20231May 26, 20231
Graph Syntax in SQL 2023The new developer release, Oracle Database 23c Free, became available on April 3, 2023. This release supports the Property Graph syntax in…May 19, 2023151May 19, 2023151
Published inOracle DevelopersOracle Graph Quick Start (On-prem)This is a brief guide for the following users:Apr 10, 20231Apr 10, 20231
Published inOracle DevelopersPowerful graph search for traceability in manufacturingEstablishing traceability in supply chains is a challenge not only in manufacturing, where quality improvement is essential, but also in…Feb 4, 2023Feb 4, 2023
Published inOracle DevelopersBuild Oracle Graph on Docker (Part 2/2, version 22.4 and above)(The procedure below was tested with versions 22.4.2 and 23.1.0.)Jan 30, 20231Jan 30, 20231
Published inOracle DevelopersDetect Conflicts of Interest using GraphsThere are many patterns in conflict-of-interest transactions. Let us consider a case in which an employee of an organization approves a…Nov 16, 20221Nov 16, 20221
Published inOracle DevelopersBuild SPARQL Endpoint with Autonomous Database (Part 1/2 using Tomcat)What is SPARQL? The Resource Description Framework (RDF) is a general method to exchange data and metadata on the Web, and SPARQL is a…Nov 9, 2022Nov 9, 2022
Published inOracle DevelopersLinked Open Data Accelerates Citizen Data ScienceIt’s been a while since the LOD Challenge 2021 awards symposium was held in March 2022, but I would like to share some highlights about the…Sep 2, 2022Sep 2, 2022
Published inOracle DevelopersOracle Graph in Python (Setup Jupyter)Oracle Graph can be accessed through Python via Jupyter notebooks, enabling data analysts and developers to easily add powerful graph…May 16, 2022May 16, 2022
Published inOracle DevelopersSetup Oracle Graph on Cloud (DBCS)I described the setup procedure for Oracle Graph using Autonomous Database in a previous article. Oracle Graph can be used with all Oracle…May 15, 20221May 15, 20221
Published inOracle DevelopersSetup Oracle Graph on Cloud (ADB)(Updated for version 22.4 on Nov 24, 2022)May 14, 20221May 14, 20221
Published inOracle DevelopersContact Tracing using Oracle SpatialOracle Spatial, the spatial features of Oracle Database, provides a platform for managing, processing, and analyzing location-based and…Mar 4, 2022Mar 4, 2022