Ryota YamanakaSchema-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 283Sep 283
Ryota YamanakaAccelerate 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 15Sep 15
Ryota YamanakaFull-Text Search in JSON using SQLUsing the JSON function JSON_TEXTCONTAINS in SQL, you can search for JSON data containing specified strings.Jul 21Jul 21
Ryota YamanakaVector 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 5May 5
Ryota YamanakaBuild Graph Server Container (23.4)(The procedure below was tested with Graph Server 23.4.0 and Oracle Database 23.3.0.)Nov 13, 2023Nov 13, 2023
Ryota YamanakaAnalyze 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, 2023Jul 14, 2023
Ryota YamanakaAnalyze 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, 2023Jul 13, 2023
Ryota YamanakaUser-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, 2023May 30, 2023
Ryota YamanakaCount 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, 2023May 26, 2023
Ryota YamanakaGraph 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, 20231May 19, 20231