Oracle Spatial and Graph – technical tips, best practices, and news from the product team

Graph Database and Analytics for everyone

James Steiner
Vice President

In keeping with the Oracle mission to help people see data in new ways, discover insights, unlock endless possibilities, customers wishing to use the Machine Learning, Spatial, and Graph features of Oracle Database are no longer required to purchase additional licenses.

Oracle wants every developer, every data scientist and anyone who uses Oracle Database to be able to use graph analytics, graph models, and graph querying of their data.  For decades, Oracle Database has included industry-leading multi-model and analytic capabilities.  Oracle’s converged database architecture supports multiple data types and data models (e.g. spatial, graph, JSON, XML) and algorithms (e.g. machine learning, graph and statistical functions) and workload types (e.g. operational and analytical) within a single database.  While many of these capabilities are included in Oracle Database products and cloud services today, it is our goal that all developers have the ability to use these advanced development APIs.   

What you can do with Graphs

Graphs let you to model data based on relationships in a more natural, intuitive way.  They let you explore and discover connections and patterns in social networks, IoT, big data, data warehouses and complex transaction data for applications such as fraud detection in banking, customer 360, and smart manufacturing.  Graph algorithms – operations specifically designed to analyze relationships and behaviors among data in graphs – make it possible to understand things that are difficult to see with other methods.

For example, graph algorithms can identify what individual or item is most connected to others in social networks or business processes.   They can identify communities, anomalies, common patterns, and paths that connect individuals or related transactions.  Every Oracle Database now includes both property graph and RDF graph data models as well as algorithms, query languages, and visualization tools.  

Property graphs are often used to identify potentially fraudulent transactions.  Companies like Paysafe, a payment processing system, use Oracle property graph technologies to identify fraud patterns while ensuring flawless customer experience and real-time money transfer.  With traditional data models, it is almost impossible to see beyond individual accounts to the connections between them. Paysafe has implemented Oracle property graph, including its fast, built-in, in-memory graph analytics, to perform fast graph queries that identify patterns of fraud.

Public safely and intelligence agencies use Oracle property graph analysis to analyze suspicious travel patterns for early detection of potential threats.  A European police force models the Integrated Operations Management System and the Advance Passenger Information System data in Oracle property graph to look at passenger relationships to determine whether individuals are traveling with or have traveled with known persons of interest.

RDF graphs are widely used by statistics bureaus, pharmaceutical research and in EU Linked Open Data programs for knowledge graphs and to create a unified metadata layer for disparate applications that facilitates identification, integration, and discovery.  RDF graphs are central to knowledge management, publishing and social network applications common in the healthcare and life sciences, finance, media and intelligence communities.

All graph features are included

All Graph features are now included with Oracle Database licenses:  

  • Property Graph database
    • PGX in-memory graph engine
    • PGQL graph query language
    • 50+ Graph algorithms
    • Support for graph visualization 
  • RDF Graph database
    • SPARQL graph query language
    • Java APIs via open source Apache Jena 
    • W3C standards support for semantic data, ontologies and inferencing
    • RDF Graph views of relational tables

Developers and data scientists can use notebook, shell UI, and a rich Java API to work with graphs.  Watch this introductory video just a few of the things you can do with Oracle’s graph capabilities. 








Join the discussion

Comments ( 1 )
  • Dean Allemang Friday, December 6, 2019
    This is a great development, both in teens of licensing (I've always wondered why we're needed an extra license for the graph capabilities) as well as the combination of lpgs with rdf. I look forward to checking out it.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.