IEEE Transactions on Knowledge and Data Engineering · 2018 · 10 citations · 27 references
ComputingComputer ScienceData ManagementData MiningDatabasesData ProvenanceDatabase ManagementProvenance ResearchQuery OptimizationQuery ProcessingCost-based Query OptimizationDatabase ProvenanceExecution PlansProvenance AnnotationProvenance CaptureProvenance ModelsProvenance Querying
A well-established technique for capturing database provenance as annotations on data is to instrument queries to propagate such annotations. However, even sophisticated query optimizers often fail to produce efficient execution plans for instrumented queries. We develop provenance-aware optimization techniques to address this problem. Specifically, we study algebraic equivalences targeted at instrumented queries and alternative ways of instrumenting queries for provenance capture. Furthermore, we present an extensible heuristic and cost-based optimization framework utilizing these optimizations. Our experiments confirm that these optimizations are highly effective, improving performance by several orders of magnitude for diverse provenance tasks.
27
The Volcano optimizer generator: extensibility and efficient search
Goetz Graefe, William J. McKenna · 2002 · 384 citations
Choice Reviews Online · 1994 · 307 citations
An annotation management system for relational databases
Deepavali Bhagwat, Laura Chiticariu, Wang-Chiew Tan et al. · The VLDB Journal · 2005 · 277 citations
Including Group-By in Query Optimization
Surajit Chaudhuri, Kyuseok Shim · 1994 · 200 citations