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 02, 2018

15:00 UTC   Start Times Around the World

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.

Description

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

Your Experts

  • #SELECTION#
    Albert Godfrind

    Albert Godfrind   

    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.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Oskar van Rest

    Oskar van Rest   

    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.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Jean Ihm

    Jean Ihm   

    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.
    #MISC#
    #ACTIONS#

Questions

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 -