SQL Graph

What is a graph database?

A graph database is a collection of nodes (or vertices) and edges (or relationships). A node represents an entity (for example, a person or an organization) and an edge represents a relationship between the two nodes that it connects (for example, likes or friends). Both nodes and edges may have properties associated with them. Here are some features that make a graph database unique:

• Edges or relationships are first class entities in a Graph Database and can have attributes or properties associated with them.
• A single edge can flexibly connect multiple nodes in a Graph Database.
• You can express pattern matching and multi-hop navigation queries easily.
• You can express transitive closure and polymorphic queries easily.

Create graph objects

CREATE TABLE Person (ID INTEGER PRIMARY KEY, Name VARCHAR(100), Age INT) AS NODE;

CREATE TABLE friends (StartDate date) AS EDGE;

Query language extensions

New MATCH clause is introduced to support pattern matching and multi-hop navigation through the graph. The MATCH function uses ASCII-art style syntax for pattern matching.