A brief history of SQL and the rise of graph queries

Click for: original source

GQL addresses the need for sophisticated queries that reflect the increasingly complex and connected nature of data in the real world. The benefits of graph databases not only exist in providing more intuitive and powerful ways to visualize and interrogate data relationships but also in storing and processing data more efficiently. By Jocelyn Hoppa.

Since the last major enhancement of Structured Query Language (SQL) decades ago, the database industry has introduced a new ISO/IEC standard language called Graph Query Language (opens in new tabGQL), marking a significant milestone.

In the article you will find:

  • A brief history of SQL, from the beginning up to:
    • SQL:2016 – Year: 2016 – Standardization: ISO/IEC 9075:2016 – Details: Added JSON support and advanced sharding capabilities.
    • SQL:2019 – Year: 2019 – Standardization: ISO/IEC 9075:2019 – Details: Extended functionality with enhancements in JSON, property graph queries, and temporal data.
    • SQL:2023 – Year: 2023 – Standardization: ISO/IEC 9075:2023 – Details: New features for property graph queries over tables tables and improved JSON support.
  • What is GQL?

GQL is a new standard marking the rise of graph queries alongside SQL’s evolution. Graph databases offer powerful ways to visualize and interrogate connected data, promising efficient storage and processing. Good read!

[Read More]

Tags apis cloud app-development software-architecture servers