Graph Database and Graph Analytics
Graph databases, part of Oracle’s converged database offering, eliminate the need to set up a separate database and move data. Analysts and developers can perform fraud detection in banking, find connections and link to data, and improve traceability in smart manufacturing, all while gaining enterprise-grade security, ease of data ingestion, and strong support for data workloads.
Oracle Autonomous Database includes Graph Studio, with one-click provisioning, integrated tooling, and security. Graph Studio automates graph data management and simplifies modeling, analysis, and visualization across the graph analytics lifecycle.
Oracle is named a leader.
See how Oracle's graph database makes it easy to explore relationships and discover connections in data by providing support for different graph structures, powerful analytics, and intuitive visualization.
Discover graph use cases across industries and categories, including financial services, manufacturing, and machine learning research.
Why a graph database from Oracle?
Complete graph database
Oracle provides support for both property and RDF knowledge graphs, and simplifies the process of modeling relational data as graph structures. Interactive graph queries can run directly on graph data or in a high-performance in-memory graph server. Extensive integration with Oracle Database, Oracle Autonomous Database, and third-party and open-source features make it simpler to apply and use graph analytics.
Comprehensive graph analytics
Explore relationships with more than 60 prebuilt algorithms. Use SQL, native graph languages, Java and Python APIs, and Oracle Autonomous Database features to create, query, and analyze graphs. Then, display connections easily in data to discover insights like customer trends and fraud detection, and then use interactive tools to publish and share analysis results.
Enterprise-level scalability and security
Gain fine-grained security, high availability, easy manageability, and integration with all other data in business applications. Oracle provides sophisticated, multilevel access control for property graphs vertices and edges, and RDF triples. Oracle also aligns with applicable ISO and Worldwide Web Consortium standards for representing and defining graphs and graph query languages.
Graph database and graph technologies
Graph Studio in Oracle Autonomous Database
With Graph Studio, almost anyone can get started with graphs to explore relationships in data. Graph Studio removes barriers to entry by automating complicated setup and management, making data integration seamless, and by providing step-by-step examples for getting started, all while offering powerful algorithms, a speedy in-memory analytics server, and advanced visualization.
Key features include:
- Automated graph modeling
- Automated install, upgrade, and provisioning
- Autosave, backup, and checkpoint data restoration features
- Advanced notebooks and visualization
- Ability to schedule analysis
- Sample notebooks and workflows for different use cases
Graph in Oracle Database
Oracle Graph Server and Client enables developers, analysts, and data scientists to use graphs within Oracle Database. It may also be used as a user managed graph environment with Oracle.
It includes a high-speed, in-memory, parallel server for property graph query and analytics, an RDF graph server and query UI to run SPARQL queries, and client components such as command-line shells for working with the graph API, a plugin for SQLcl to run PGQL queries, a Python client for Jupyter notebooks, interpreters for Apache Zeppelin notebook, and a graph visualization tool.
Oracle Graph Server and Client includes:
- Graph Server
- Graph Client
- Graph Client for Apache Zeppelin
- Graph HDFS Connector
- PGQL Plugin for SQLcl
- RDF Server and Query UI
- Property Graph Server
- Property Graph Client
- Property Graph Client for Apache Zeppelin
- Property Graph HDFS Connector
- PGQL Plugin for SQLcl
- RDF Graph Server
- RDF Query UI
Get started with graph in Oracle Autonomous Database for free.
Read about our customers
Certegy uses Oracle Graph Studio to apply pattern recognition and statistical analysis of complex relationships to track and block accounts with fraudulent activity.
"Queries that used to take minutes, hours, or even days now run in sub-seconds with Oracle’s graph features.”
Yavor Ivanov, Head of Database Administration, Paysafe Group
Toshihiro Yamashita, CEO, Amenidy Inc.
Dan Vlamis, President, Vlamis Software Solutions
Gianni Ceresa, Managing Director of DATAlysis and Oracle ACE Director
Graph database use cases
-
Money laundering detection for financial services
Create a graph of all bank accounts, then run graph queries to find all customers who have information that reveals criminal activity.
-
Master data management in manufacturing
Use an RDF graph to create a metadata layer that helps determine whether the manufacturing names for parts indicate the same item, the items are related, or the items can be used interchangeably because of their similarities. Use a graph database to connect all relationships among different manufacturing parts and highlight connections and relevant information with graph algorithms.
-
Data lineage tracking for GDPR
The various steps in the data lifecycle can be tracked and navigated, vertex by vertex, by following the edges in a graph. Follow the data’s path, see where the information originally resided, was copied, and utilized, so data professionals can fulfil GDPR requests.
-
Product recommendations in marketing
Relationships between customers and the products they buy can be laid out in a graph database—so it becomes fast and easy to run algorithms through the data to discover recommendations.
-
Feature engineering for machine learning
Building machine learning models requires augmented data, which can be created by running graph algorithms on a dataset that has been loaded into a graph database, and creating enriched data which can then be used for machine learning.
Graph Database and Graph Analytics pricing
Oracle’s graph technologies are included in on-premises database licenses and Autonomous Database.
Use Database Functions in PGQL (Graph) Queries!
Melliyal Annamalai, Distinguished Product Manager, OracleIn Oracle Graph Server and Client 21.4 any database function (including user-defined functions) can be used in a PGQL query over a Property Graph view that gives developers the ability to create graphs on existing data in relational tables. This opens a lot of interesting possibilities, enabling powerful database functions to be used with graph queries.
Resources
Ebook
Technical documentation
Video
Related products
Oracle Cloud Infrastructure Data Science
Open-source libraries to build ML models
Get started with Graph Database and Graph Analytics
Try a graph workshop
Explore graph features at no cost.
Try Oracle Cloud Free Tier
Oracle’s graph technologies are included free of charge.
Contact us
Interested in learning more? Contact one of our industry-leading experts.