Loading…
Welcome to Analytics and Data Summit 2020.
  • Sessions appear in the color of their primary track and can be filtered using Products on the right
  • Use the Search bar for more flexibility
See this link for hints on how to search the schedule
Back To Schedule
Thursday, February 27 • 1:55pm - 2:20pm
How to develop Graph Database applications with SQL/PGQ

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Tweet Share
Feedback form is now closed.
Property graphs enjoy an ever-increasing popularity in applications that deal with connected components of all varieties; e.g., social networks, fraud detection, etc. Today there are a number of stand-alone languages used with Property Graphs including Apache Tinkerpop Gremlin, Neo4j Cypher, Tigergraph GSQL and Oracle PGQL as well as a proposal for another stand-alone language under consideration by ISO, GQL. It is well known that SQL is the most widely used database language and is the language of choice for database application developers. To support graph creation and querying, the ISO SQL 202x standard will include new extensions for graph databases, SQL/PGQ. We will show how SQL/PGQ will integrate with SQL to allow users to define property graphs based on data stored in existing tables and to query those graphs. The query part will use a combination of familiar SQL as well as a new built-in operator, which significantly simplifies typical graph queries compared to existing SQL.
Speakers
avatar for Jan Michels

Jan Michels

Principal Member of Technical Staff, Oracle
Jan Michels represents Oracle on the ANSI and ISO committees responsible for standardizing SQL, while working closely with the Oracle database server development teams. He has been involved in designing extensions for the SQL language for 20 years. Jan is chair of the DM32.2 Ad Hoc... Read More →
avatar for Andy Witkowski

Andy Witkowski

Oracle
Managing Experience: Managing a group of 35-40 engineers in critical area of SQL Execution: all SQL Operators & Functions, Parallel Execution, DML+Load+ETL, Materialized Views, SQL Access Advisors, On-Line redefinition.Architecture Experience: Designed Critical SQL Analytic Components... Read More →

Thursday February 27, 2020 1:55pm - 2:20pm PST
Bldg 23- Rm 1740 .
  Spatial and Graph, Half Session (25 minutes)