SubZero: A fine-grained lineage system for scientific databases

  • Authors:
  • Eugene Wu;Samuel Madden;Michael Stonebraker

  • Affiliations:
  • CSAIL, MIT 32 Vassar St, Cambridge, MA, USA 02139;CSAIL, MIT 32 Vassar St, Cambridge, MA, USA 02139;CSAIL, MIT 32 Vassar St, Cambridge, MA, USA 02139

  • Venue:
  • ICDE '13 Proceedings of the 2013 IEEE International Conference on Data Engineering (ICDE 2013)
  • Year:
  • 2013

Quantified Score

Hi-index 0.00

Visualization

Abstract

Data lineage is a key component of provenance that helps scientists track and query relationships between input and output data. While current systems readily support lineage relationships at the file or data array level, finer-grained support at an array-cell level is impractical due to the lack of support for user defined operators and the high runtime and storage overhead to store such lineage. We interviewed scientists in several domains to identify a set of common semantics that can be leveraged to efficiently store fine-grained lineage. We use the insights to define lineage representations that efficiently capture common locality properties in the lineage data, and a set of APIs so operator developers can easily export lineage information from user defined operators. Finally, we introduce two benchmarks derived from astronomy and genomics, and show that our techniques can reduce lineage query costs by up to 10x while incuring substantially less impact on workflow runtime and storage.