Simplify Property Graphs Using SQL with Database 23ai
summary
Oracle Database 23ai adds SQL:2023 graph syntax that creates a graph view (no data copy) over tables so queries like “is account A connected to B in 1–3 hops” replace a 12‑join UNIONALL mess with concise MATCH patterns; examples show cycle detection for fraud, hierarchical product/category traversal, and community detection. Integrations: SQL Developer / VS Code extension, browser visualizer, and Graph Server for ML. Claims include sub‑millisecond on billions of nodes and support for DeepWalk / GraphSAGE embeddings and JSON/LLM RAG workflows.
AI-written summary · about
chapters (15)
- 0:00Introduction to graph data
- 1:36Graph data modeling concepts
- 2:26Analyzing connected data
- 3:30Graph views in SQL 2023
- 6:10Hierarchical data traversal
- 7:35Database features and security
- 9:24Performance and integration
- 10:30Querying paths and cycles
- 12:29Graph and relational synergy
- 14:10Real world use cases
- 17:57Graph visualization tools
- 19:49Machine learning with graphs
- 21:20Deep walk and graph algorithms
- 22:20Graph RAG and LLMs
- 23:46Summary and resources
related talks
31mWhen property graphs join SQL
29mAll about graphs in Database
30mAnalyze connections and find patterns in data with graphs
12mSolve Problems by Understanding Data and Graphs
19mUnraveling the Web of Relationships: Understanding Graph Data
27mExploring property graphs with SQL/PGQ in PostgreSQL
41mGraphGen: Conducting Graph Analytics over Relational Databases- 19mUnraveling the Web of Relationships: Understanding Graph Data