Provenance-based refresh in data-oriented workflows
Authors:
Open Access
- 24 October 2011
- conference paper
- Published by Association for Computing Machinery (ACM)
- p. 1659-1668
Abstract
We consider a general workflow setting in which input data sets are processed by a graph of transformations to produce output results. Our goal is to perform efficient selective refresh of elements in the output data, i.e., compute the latest values of specific output elements when the input data may have changed. We explore how data provenance can be used to enable efficient refresh. Our approach is based on capturing one-level data provenance at each transformation when the workflow is run initially. Then at refresh time provenance is used to determine (transitively) which input elements are responsible for given output elements, and the workflow is rerun only on that portion of the data needed for refresh. Our contributions are to formalize the problem setting and the problem itself, to specify properties of transformations and provenance that are required for efficient refresh, and to provide algorithms that apply to a wide class of transformations and workflows. We have built a prototype system supporting the features and algorithms presented in the paper. We report preliminary experimental results on the overhead of provenance capture, and on the crossover point between selective refresh and full workflow recomputation. © 2011 ACMKeywords
This publication has 12 references indexed in Scilit:
- Explaining missing answers to SPJUA queriesProceedings of the VLDB Endowment, 2010
- Provenance in Databases: Why, How, and WhereFoundations and Trends® in Databases, 2009
- Provenance and scientific workflows2008
- Provenance semirings2007
- A survey of data provenance in e-scienceACM SIGMOD Record, 2005
- Lineage retrieval for scientific data processing: a surveyACM Computing Surveys, 2005
- Lineage tracing for general data warehouse transformationsThe VLDB Journal, 2003
- Conceptual modeling for ETL processes2002
- Tracing the lineage of view data in a warehousing environmentACM Transactions on Database Systems, 2000
- Efficiently updating materialized views1986