SQL/PGQ & GQL STATUS Keith W. Hare Convenor, ISO/IEC JTC1 SC32 - - PowerPoint PPT Presentation

▶
sql pgq gql status
SMART_READER_LITE
LIVE PREVIEW

SQL/PGQ & GQL STATUS Keith W. Hare Convenor, ISO/IEC JTC1 SC32 - - PowerPoint PPT Presentation

May 31, 2023 13 likes •208 views

2019-03-05 W3C Workshop on Web Standardization for Graph Data 1 SQL/PGQ & GQL STATUS Keith W. Hare Convenor, ISO/IEC JTC1 SC32 WG3 Database Languages Senior Consultant, JCC Consulting, Inc. 2 W3C Workshop on Web Standardization for

slide-1
SLIDE 1

SQL/PGQ & GQL STATUS

Keith W. Hare Convenor, ISO/IEC JTC1 SC32 WG3 Database Languages Senior Consultant, JCC Consulting, Inc.

1

2019-03-05 W3C Workshop on Web Standardization for Graph Data

slide-2
SLIDE 2

Introduction

  • Brief History of the SQL Standards
  • ISO/IEC JTC1 process and structure
  • How does SQL/PGQ and GQL fit in this structure?
  • SQL/PGQ and GQL status and timing
  • Summary

2

2019-03-05 W3C Workshop on Web Standardization for Graph Data

slide-3
SLIDE 3

SQL Standards – a brief history

  • ISO/IEC 9075 Database Language SQL
  • SQL-87 – Transactions, Create, Read, Update, Delete
  • SQL-89 – Referential Integrity
  • SQL-92 – Internationalization, etc.
  • SQL:1999 – User Defined Types
  • SQL:2003 – XML
  • SQL:2008 – Expansions and corrections
  • SQL:2011 – Temporal
  • SQL:2016 – JSON, RPR, PTF, MDA (2019)
  • 30 years of support and expansion of the standard

2019-03-05

3

W3C Workshop on Web Standardization for Graph Data

slide-4
SLIDE 4

SQL:2016 Major Features

  • Row Pattern Recognition
  • Regular Expressions across sequences of rows
  • Support for Java Script Object Notation (JSON) objects
  • Store, Query, and Retrieve JSON objects
  • Polymorphic Table Functions
  • parameters and function return value can be tables whose shape is not known until compile

time

  • Additional analytics
  • Trigonometric and Logarithm functions
  • Multi-dimensional Arrays (2019)

2019-03-05

4

W3C Workshop on Web Standardization for Graph Data

slide-5
SLIDE 5

SQL:2016 Parts

Reference Document title ISO/IEC 9075-1 Information technology -- Database languages -- SQL -- Part 1: Framework (SQL/Framework) ISO/IEC 9075-2 Information technology -- Database languages -- SQL -- Part 2: Foundation (SQL/Foundation) ISO/IEC 9075-3 Information technology -- Database languages -- SQL -- Part 3: Call-Level Interface (SQL/CLI) ISO/IEC 9075-4 Information technology -- Database languages -- SQL -- Part 4: Persistent stored modules (SQL/PSM) ISO/IEC 9075-9 Information technology -- Database languages -- SQL -- Part 9: Management of External Data (SQL/MED) ISO/IEC 9075-10 Information technology -- Database languages -- SQL -- Part 10: Object language bindings (SQL/OLB) ISO/IEC 9075-11 Information technology -- Database languages -- SQL -- Part 11: Information and definition schemas (SQL/Schemata) ISO/IEC 9075-13 Information technology -- Database languages -- SQL -- Part 13: SQL Routines and types using the Java programming language (SQL/JRT) ISO/IEC 9075-14 Information technology -- Database languages -- SQL -- Part 14: XML-Related Specifications (SQL/XML) ISO/IEC 9075-15 Information technology -- Database languages -- SQL -- Part 15: Multi-dimensional Arrays (SQL/MDA) (2019)

2019-03-05 W3C Workshop on Web Standardization for Graph Data

5

slide-6
SLIDE 6

SQL Technical Reports – 19075

  • SQL Standards committees have accumulated a great deal of descriptive

material

  • Useful information (non-normative) but does not belong in the actual standard.
  • Started creating Technical Reports from this material
  • First was published in 2011
  • Total of seven are now published
  • Eighth will be published soon
  • Available from JTC1 Freely Available Standards page:
  • http://standards.iso.org/ittf/PubliclyAvailableStandards/index.html
  • Search for 19075
  • Must agree to single use license
  • The current list of Technical Reports is:

2019-03-05

6

W3C Workshop on Web Standardization for Graph Data

slide-7
SLIDE 7

SQL Technical Reports

Reference Document title Publication Date ISO/IEC TR 19075-1 Information technology -- Database languages -- SQL Technical Reports -- Part 1: XQuery Regular Expression Support in SQL 2011-07-06 ISO/IEC TR 19075-2 Information technology -- Database languages -- SQL Technical Reports -- Part 2: SQL Support for Time- Related Information 2015-07-01 ISO/IEC TR 19075-3 Information technology -- Database languages -- SQL Technical Reports -- Part 3: SQL Embedded in Programs using the Java TM programming language 2015-07-01 ISO/IEC TR 19075-4 Information technology -- Database languages -- SQL Technical Reports -- Part 4: SQL with Routines and types using the JavaTM programming language 2015-07-01 ISO/IEC TR 19075-5 Information technology -- Database languages -- SQL Technical Reports -- Part 5: Row Pattern Recognition in SQL 2016-12-14 ISO/IEC TR 19075-6 Information technology -- Database languages -- SQL Technical Reports -- Part 6: SQL support for JSON 2017-03-29 ISO/IEC TR 19075-7 Information technology -- Database languages -- SQL Technical Reports - Part 7: SQL Support for Polymorphic Table Functions 2017-03-29 ISO/IEC TR 19075-8 Information technology -- Database languages -- SQL Technical Reports -- Part 8: SQL Support for multi dimensional arrays 2019

2019-03-05

7

W3C Workshop on Web Standardization for Graph Data

slide-8
SLIDE 8

ISO/IEC JTC1 Standardization Process

2019-03-05 W3C Workshop on Web Standardization for Graph Data

8

NWIP or Project Split Development Working Draft Ready? CD Ballot Comment Resolution Done? DIS Ballot Comment Resolution Done? FDIS Ballot International Standard Yes Yes Yes No No No

Thanks to Jan Michels

slide-9
SLIDE 9

International Standards Hierarchy

ISO

International Organization for Standardization

IEC

International Electrotechnical Commission

JTC 1

Information Technology

SC 32

Data Management and Interchange

WG 3

Database Languages

9

slide-10
SLIDE 10

International Standards Hierarchy mirrored in the US

ISO

International Organization for Standardization

IEC

International Electrotechnical Commission

JTC 1

Information Technology

SC 32

Data Management and Interchange

WG 3

Database Languages

10

ANSI

American National Standards Institute

INCITS

InterNational Committee for Information Technology Standards

DM 32

Data Management and Interchange

DM 32.2

Database

slide-11
SLIDE 11

International Standards Hierarchy mirrored in the US

ISO

International Organization for Standardization

IEC

International Electrotechnical Commission

JTC 1

Information Technology

SC 32

Data Management and Interchange

WG 3

Database Languages

11

ANSI

American National Standards Institute

INCITS

InterNational Committee for Information Technology Standards

DM 32

Data Management and Interchange

DM 32.2

Database

DM 32.2 Ad Hoc

specific short-term task(s) SQL extensions for property graphs

slide-12
SLIDE 12

SQL, SQL/PGQ, and GQL

2019-03-05 W3C Workshop on Web Standardization for Graph Data

12

SQL GQL

SQL/ PGQ

slide-13
SLIDE 13

SQL and SQL/PGQ

2019-03-05 W3C Workshop on Web Standardization for Graph Data

13

SQL/Framework SQL/Foundation SQL/Schemata SQL Project Arrows indicate dependencies SQL/XML SQL/PSM SQL/MDA SQL/PGQ

slide-14
SLIDE 14

SQL/MDA SQL/PSM SQL/XML

SQL and GQL Projects

2019-03-05 W3C Workshop on Web Standardization for Graph Data

14

SQL/Framework SQL/Foundation SQL/Schemata SQL/PGQ GQL Foundation GQL Proper SQL Project GQL Project

Thanks to Fred Zemke, Modified by WG3

Arrows indicate dependencies Read GQL

slide-15
SLIDE 15

SQL/PGQ Status

  • Project Split exists – 9075-16 SQL/PGQ
  • 48 month project (maximum)
  • Timer starts when we have a working draft – June 2019
  • Informal Working Draft exists
  • Some detailed content exists
  • More detailed contented needed
  • Potential Timeframe?

2019-03-05 W3C Workshop on Web Standardization for Graph Data

15

slide-16
SLIDE 16

GQL Status

  • New project – Need New Work Item Proposal (NWIP)
  • Submitted by national body (USA) to SC32
  • Probably vote after June 2019 SC32 plenary
  • 48 Month project (maximum)
  • Timer starts when NWIP approved
  • Outline of Working Draft exists
  • List of potential Content exists
  • Potential Timeframe?

2019-03-05 W3C Workshop on Web Standardization for Graph Data

16

slide-17
SLIDE 17

From Cypher, PGQL, GSQL, SQL/PGQ to GQL

2019-03-05 W3C Workshop on Web Standardization for Graph Data

17

All aligned with basic data types, infrastructure, and expressions of the SQL database Support for basic tabular manipulation (projection, sorting, grouping etc)

http://tiny.cc/gql-scope-and-features

slide-18
SLIDE 18

Summary

  • Momentum is building to make this happen

2019-03-05 W3C Workshop on Web Standardization for Graph Data

18

slide-19
SLIDE 19

Questions?

SELECT * FROM Graph GRAPH_TABLE ( MATCH(who:AudienceMember) –[has:Questions]

  • >(for:Speaker)

COLUMNS who.name AS audience, who.question AS question, for.name as speaker );

2019-03-05 W3C Workshop on Web Standardization for Graph Data

19