Schema-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, 20243Sep 28, 20243
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, 2024Sep 15, 2024
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, 2024Jul 21, 2024
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, 2024May 5, 2024
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, 20231Nov 13, 20231
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, 20231Jul 14, 20231
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, 2023Jul 13, 2023
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, 2023May 30, 2023
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, 2023May 26, 2023
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, 20231May 19, 20231
