This blog post is a follow-up to Jayant Sharma’s Get Started with Property Graphs in Oracle Database 23c Free – Developer Release, published in April 2023. Given the focus on AI in this database release, we decided to change the database’s name from Oracle Database 23c to Oracle Database 23ai, and Oracle Database 23ai has been released on Oracle Database Cloud Services, Oracle Database@Azure, Oracle Database@Google Cloud, Oracle Database@AWS, and Oracle Cloud Infrastructure (OCI). On-premises, we have released Oracle Database 23ai on Exadata Cloud@Customer, Compute Cloud@Customer, Oracle Exadata Database Machine, Oracle Database Appliance, and Oracle Private Cloud Appliance. This blog introduces a LiveLab Sprint on how you can get started with property graphs using Autonomous Database on Oracle Free Tier.
Operational Property Graph supports creating and querying property graphs in SQL using constructs, such as GRAPH_TABLE and MATCH, defined in SQL:2023. Operational Property Graph enables you to write simple SQL queries to follow connections in data. This greatly simplifies the way you analyze data and expands Oracle Database’s graph capabilities, which already support property graphs via PGQL and RDF graphs.
The Scenario
The sample data consists of two CSV files containing synthetic bank accounts and money transfers. The goal is to determine if there are any circular payment chains, i.e., a chain of money transfers that start and end at the same account after going through 3, 4, or 5 intermediate accounts.
Sounds like a too complex problem to solve? Don’t worry – The use of Property Graph makes it simple and easy to analyze connections in data that are seemingly difficult to do. Try it out here!
We’d love to hear from you – Please discuss your experiences, post ideas, or ask questions on the public Oracle Database Free or Oracle Database Discussions forum. If you want another hands-on experience, try our LiveLab: Explore Operational Property Graphs in Oracle Database 23ai. Or check out our Oracle Graph Learning Path blog.