Table of Contents
Fetching ...

Evaluation of Provenance Serialisations for Astronomical Provenance

Michael A. C. Johnson, Marcus Paradies, Hans-Rainer Klöckner, Albina Muzafarova, Kristen Lackeos, David J. Champion, Marta Dembska, Sirko Schindler

TL;DR

The paper addresses how to store and query astronomical provenance at petascale scales by comparing turtle (RDF) and JSON (graph-annotation) serialisations using Fuseki and Neo4j. It generates provenance from two imaging pipelines, scales it with provenance mitosis, and evaluates query accuracy, timing, and upload efficiency across both DBMSs. Findings indicate RDF/Turtle is more storage- and upload-efficient, while SPARQL queries are faster for simple retrieval and Cypher/Cypher-based queries offer advantages for complex pattern matching at larger sizes; the choice of serialisation should depend on intended use cases. The work informs provenance practices for next-generation facilities like the Vera Rubin Observatory and SKA, guiding efficient data provenance storage and querying strategies in big data astronomy.

Abstract

Provenance data from astronomical pipelines are instrumental in establishing trust and reproducibility in the data processing and products. In addition, astronomers can query their provenance to answer questions routed in areas such as anomaly detection, recommendation, and prediction. The next generation of astronomical survey telescopes such as the Vera Rubin Observatory or Square Kilometre Array, are capable of producing peta to exabyte scale data, thereby amplifying the importance of even small improvements to the efficiency of provenance storage or querying. In order to determine how astronomers should store and query their provenance data, this paper reports on a comparison between the turtle and JSON provenance serialisations. The triple store Apache Jena Fuseki and the graph database system Neo4j were selected as representative database management systems (DBMS) for turtle and JSON, respectively. Simulated provenance data was uploaded to and queried over each DBMS and the metrics measured for comparison were the accuracy and timing of the queries as well as the data upload times. It was found that both serialisations are competent for this purpose, and both have similar query accuracy. The turtle provenance was found to be more efficient at storing and uploading the data. Regarding queries, for small datasets ($<$5MB) and simple information retrieval queries, the turtle serialisation was also found to be more efficient. However, queries for JSON serialised provenance were found to be more efficient for more complex queries which involved matching patterns across the DBMS, this effect scaled with the size of the queried provenance.

Evaluation of Provenance Serialisations for Astronomical Provenance

TL;DR

The paper addresses how to store and query astronomical provenance at petascale scales by comparing turtle (RDF) and JSON (graph-annotation) serialisations using Fuseki and Neo4j. It generates provenance from two imaging pipelines, scales it with provenance mitosis, and evaluates query accuracy, timing, and upload efficiency across both DBMSs. Findings indicate RDF/Turtle is more storage- and upload-efficient, while SPARQL queries are faster for simple retrieval and Cypher/Cypher-based queries offer advantages for complex pattern matching at larger sizes; the choice of serialisation should depend on intended use cases. The work informs provenance practices for next-generation facilities like the Vera Rubin Observatory and SKA, guiding efficient data provenance storage and querying strategies in big data astronomy.

Abstract

Provenance data from astronomical pipelines are instrumental in establishing trust and reproducibility in the data processing and products. In addition, astronomers can query their provenance to answer questions routed in areas such as anomaly detection, recommendation, and prediction. The next generation of astronomical survey telescopes such as the Vera Rubin Observatory or Square Kilometre Array, are capable of producing peta to exabyte scale data, thereby amplifying the importance of even small improvements to the efficiency of provenance storage or querying. In order to determine how astronomers should store and query their provenance data, this paper reports on a comparison between the turtle and JSON provenance serialisations. The triple store Apache Jena Fuseki and the graph database system Neo4j were selected as representative database management systems (DBMS) for turtle and JSON, respectively. Simulated provenance data was uploaded to and queried over each DBMS and the metrics measured for comparison were the accuracy and timing of the queries as well as the data upload times. It was found that both serialisations are competent for this purpose, and both have similar query accuracy. The turtle provenance was found to be more efficient at storing and uploading the data. Regarding queries, for small datasets (5MB) and simple information retrieval queries, the turtle serialisation was also found to be more efficient. However, queries for JSON serialised provenance were found to be more efficient for more complex queries which involved matching patterns across the DBMS, this effect scaled with the size of the queried provenance.
Paper Structure (18 sections, 1 equation, 4 figures, 2 tables)

This paper contains 18 sections, 1 equation, 4 figures, 2 tables.

Figures (4)

  • Figure 1: Provenance mitosis
  • Figure 2: Query accuracy
  • Figure 3: Use case timings
  • Figure 4: Upload timings