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

October 2, 2018

PGQL: A Query Language for Graphs
In this session, we show how to query graphs using PGQL, an expressive and intuitive graph query language that's a lot like SQL. With PGQL, it's easy to get going writing graph analysis queries to the database in a very short time.

Slides are available here: https://www.slideshare.net/JeanIhm/pgql-a-language-for-graphs

This is the 5th video in a series. Watch the previous sessions here: https://www.youtube.com/playlist?list=PL3ZqpALcm8HNVrhEE2j6m-hTCv4zbdFwa

Sign up for future AskTOM graph sessions: https://devgym.oracle.com/pls/apex/dg/office_hours/3084

Highlights:

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

07:15 – How PGQL is executed - Albert shows shows how to execute PGQL from various environments: groovy shell, java, python, cytoscape

13:05 – Deep dive into PGQL - Oskar shows what the language is all about, what you can do with it.

55:20 – Resources, quick preview of Oracle OpenWorld / Code One 2018, and wrapup

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

Ask a Question

Ask The Experts - Right Now!

Do you have a question about PGQL: A Query Language for Graphs. you'd like our experts to answer in their next session? Sign in and submit it here.

Please note that we cannot guarantee to answer all questions. We cannot help you with open Service Requests or account/licensing issues.

Experts

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.
Oskar van Rest
Oskar van Rest, Principal Member of Technical Staff    
Oskar van Rest is a member of the Oracle Spatial and Graph team and focuses on the design of PGQL (Property Graph Query Language; http://pgql-lang.org/) as well as on the development of a graph query engine as part of PGX (Parallel Graph analytiX). He is also involved in the ongoing standardization efforts for graph query languages.
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.

Answers

Answers
Question
Hi, I would want to migrate spatial columns of data from SQL server to Oracle database server. Can you please provide how to begin. The sql developer tool does not support migration of spatial data. Could you provide appropriate tool/steps necessary. Can you assist in starting off.
Answer

Hi Angelica

(just to be clear: your question is not related to the topic of the AskTOM Show more.

Answered by Albert Godfrind -