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

April 24

15:00 UTC   Start Times Around the World


How To Model and Construct Graphs with Oracle Database
How To Model and Construct Graphs with Oracle Database

To use property graphs, first, you’ll need a graph model. For a new user, modeling and generating a suitable graph for an application domain can be a challenge. In April’s session, Albert described key steps required to model a graph, using an HR example. Then Zhe showed how to construct a meaningful graph using ODI, Java/SQL APIs, or various utilities supporting various data sources (Database or other file formats).

NOTE: If you missed February’s session, please watch the recording prior to this session: ED98BAEBB81DD95ADED292AE0744349

Highlights [timestamps based on Steven's 5/2 edited version]:
00:00 - Speaker intros
01:40 - Graph Architecture Overview
04:52 - Designing Graphs: what is a graph model, comparison with relational, considerations on moving from a relational to a graph model, some graph modeling examples (HR and customer orders)
24:56 - Constructing Graphs – overview of available options
26:34 - Constructing Graphs using Oracle Data Integrator (demo starts at 29:55)
39:50 - Using DAL APIs to programmatically create a graph
41:00 - Read from a data source and use DAL APIs to programmatically create a graph
42:20 - Generate a Property Graph (.opv/.ope) directly from relational tables (views)
44:10 - Generate a Property Graph (.opv/.ope) directly from CSV Files
44:50 - Construct a property graph with SQL
47:05 - 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

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.
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.
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.