Solve Problems by Understanding Data and Graphs
summary
Oracle Database 23ai creates a SQL property graph on top of five tables (customer_tickets, supplier, category, product, component) as a metadata-backed view called AUTO_GRAPH, with no data copy so updates are immediate. Demo shows Graph Studio and notebooks querying product relationships, highlighting electrical components as high sellers, identifying product_id 59 with two distinct bearing components and many tickets, and running PageRank to surface frequently used parts; supports OLTP, DW, spatial/JSON/vector.
AI-written summary · about
chapters (6)
- 0:00Introduction to graph analysis
- 1:01Graph modeling concepts
- 2:32Graph studio demonstration
- 5:26Under the hood architecture
- 8:24Advanced SQL graph queries
- 11:23Conclusion and resources
related talks
30mAnalyze connections and find patterns in data with graphs
29mAll about graphs in Database
25mSimplify Property Graphs Using SQL with Database 23ai
18mGraph analytics: From zero to hero
31mWhen property graphs join SQL
30mSelf-service data warehousing
23mRevolutionizing Data Access Using GraphQL in the Oracle Database
28mSimplify data analysis using analytic views