Back to Search Start Over

PG-Triggers: Triggers for Property Graphs

Authors :
Ceri, Stefano
Bernasconi, Anna
Gagliardi, Alessia
Martinenghi, Davide
Bellomarini, Luigi
Magnanimi, Davide
Source :
In Companion of the 2024 International Conference on Management of Data (SIGMOD/PODS '24). Association for Computing Machinery, New York, NY, USA, 373-385
Publication Year :
2023

Abstract

Graph databases are emerging as the leading data management technology for storing large knowledge graphs; significant efforts are ongoing to produce new standards (such as the Graph Query Language, GQL), as well as enrich them with properties, types, schemas, and keys. In this article, we introduce PG-Triggers, a complete proposal for adding triggers to Property Graphs, along the direction marked by the SQL3 Standard. We define the syntax and semantics of PG-Triggers and then illustrate how they can be implemented on top of Neo4j, one of the most popular graph databases. In particular, we introduce a syntax-directed translation from PG-Triggers into Neo4j, which makes use of the so-called {\it APOC triggers}; APOC is a community-contributed library for augmenting the Cypher query language supported by Neo4j. We also cover Memgraph, and show that our approach applies to this system in a similar way. We illustrate the use of PG-Triggers through a life science application inspired by the COVID-19 pandemic. The main objective of this article is to introduce an active database standard for graph databases as a first-class citizen at a time when reactive graph management is in its infancy, so as to minimize the conversion efforts towards a full-fledged standard proposal.<br />Comment: 13 pages, 5 figures, 4 tables

Subjects

Subjects :
Computer Science - Databases
cs.DB

Details

Database :
arXiv
Journal :
In Companion of the 2024 International Conference on Management of Data (SIGMOD/PODS '24). Association for Computing Machinery, New York, NY, USA, 373-385
Publication Type :
Report
Accession number :
edsarx.2307.07354
Document Type :
Working Paper
Full Text :
https://doi.org/10.1145/3626246.3653386