InOracle DevelopersbyRyota Yamanaka·Sep 28, 2024Schema-less Graphs Using SQLAs previously introduced in this article, the current SQL specification (SQL:2023) includes syntax for defining graphs based on table data…A response icon3A response icon3
InOracle DevelopersbyRyota Yamanaka·Sep 15, 2024Accelerate 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…
Ryota Yamanaka·Jul 21, 2024Full-Text Search in JSON using SQLUsing the JSON function JSON_TEXTCONTAINS in SQL, you can search for JSON data containing specified strings.
InOracle DevelopersbyRyota Yamanaka·May 5, 2024Vector 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…
Ryota Yamanaka·Nov 13, 2023Build Graph Server Container (23.4)(The procedure below was tested with Graph Server 23.4.0 and Oracle Database 23.3.0.)A response icon1A response icon1
Ryota Yamanaka·Jul 14, 2023Analyze 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…A response icon1A response icon1
Ryota Yamanaka·Jul 13, 2023Analyze 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…
Ryota Yamanaka·May 30, 2023User-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…
Ryota Yamanaka·May 26, 2023Count the Number of Parts Using GraphsIn my previous article, “Powerful Graph Search for Traceability in Manufacturing”, I introduced how Oracle Graph can achieve…
InOracle DevelopersbyRyota Yamanaka·May 19, 2023Graph 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…A response icon1A response icon1
