Skip to Main Content

Graph Database and Analytics Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

May 31

15:00 UTC   Start Times Around the World


Gain Insights with Graph Analytics
Title: AskTOM Office Hours: Gain Insights with Graph Analytics

Held on May 31, 2018

In this session, we revealed the magic of graphs. Graph analysis can answer questions like detecting patterns of fraud or identifying influential customers, quickly and efficiently. With our 50+ prebuilt graph analytics, you can easily add graphs to your Oracle application, without being a graph expert.

Albert showed the Java API for graph analytics, and tools and code to invoke them (including Groovy shell and Zeppelin notebooks). Zhe then showed these in practice with 2 use case examples: a retail product recommender system, and a finance fraud detection system to identify circular payments.

Slides are available here:

This is the 3rd video in a series. Watch the previous sessions here:


00:00 – Welcome, the story so far. Jean recaps previous sessions (graph intro, architecture, use cases)

07:40 - APIs for graph analytics. Albert shows the “how”: tools/code to invoke graph analytic functions, including how to access the Java API from:

09:10 - Groovy shell
11:20 - Zeppelin notebooks
25:55 - PGQL query language

25:14 - List of the 50+ prebuilt graph analytic functions in Oracle Spatial and Graph, and their applications

28:20 - Graph Analytics in practice. Zhe shows the “what”: use cases and demos. Which graph analytics should we use, how do we invoke them, and what do the results look like? The use cases:

28:30 - Build a recommender system for retail, to recommend products that specific customers are likely to want
46:36 - Circular payment fraud detection – a real world finance use case from a Chinese tax authority

54:40 – Resources and wrapup

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.

Your Experts

Albert Godfrind
Albert Godfrind, Spatial and Graph Solutions Architect    
25 years of experience in designing, developing, and deploying IT applications. What I do: evangelizing the use of graphs and spatial information to Analytics, BI and GIS communities across Europe, consulting with partners and customers, speaking at conferences, and designing and delivering in-depth technical training. I am also one of the authors of the first book on Oracle Spatial: Pro Oracle Spatial - The essential guide to developing spatially enabled business applications.
Zhe Wu
Zhe Wu, Architect    
Zhe Wu is an architect working on semantic and graph technologies in Oracle USA. He leads the design, architecture, and development of the inference engine for W3C RDFS/SKOS/OWL in the database, Java APIs for RDF Semantic Graph, RDF triple-level security, SQL-based graph analytics, Property Graph for RDBMS and Hadoop, and more. As an Oracle representative, he has participated in the W3C OWL 2 working group, RDF working group, and UDDI standard committee. He has served as a member of the program committee for ESWC, OrdRing, ISWC, RR, and OWLED. Zhe has served as co-chair for JIST 2011 and he has served on the editorial board of SWJ 2010. He has been invited to attend Japan-America Frontiers of Engineering (JAFOE 2011). Zhe has publications in ISWC, WWW, AAAI, VLDB, ICDE, JCST, CP, ICTAI, ASAP, and more. He has over fifteen US/International patents granted. Zhe received his PhD in computer science from the University of Illinois at Urbana-Champaign in 2001. He received his BE from the Special Class for Gifted Young, USTC in 1996.
Jean Ihm
Jean Ihm, Product Manager    
Jean Ihm is a product manager for Oracle's spatial and graph technologies for database, big data, and cloud platforms. She interacts with customers and partners worldwide, works on product release activities, engages with presales, and helps organize user events. She serves as Oracle liaison to the Spatial and Graph SIG user group, and is a member of the BIWA conference committee. She received a bachelor's degree from MIT, and a law degree from the University of California, Berkeley. She is based at Oracle HQ in Redwood Shores, California.