Lenses: An On-Demand Approach to ETL

Summary: General, extensible on-demand ETL using probabilistic query processing for incremental data curation and quality–effort trade-offs. UI and a greedy CPI ranking for on-demand curation tasks; shows applicability beyond Paygo/HLog and ETL feasibility. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: he404234a7ac66832
Venue: VLDB
Year: 2015
Pagerank: 5.8880755e-05
Overall Rank: 6,091 | 59.07%
DOI: 10.14778/2824032.2824055
PDF: Download (CC BY-NC-ND 3.0)

Incoming Non-self Citations Over Time

Authors

1. Ying Yang (State University of New York at Buffalo)
2. Niccolò Meneghetti (State University of New York at Buffalo)
3. Ronny Fehling (Oracle)
4. Zhen Hua Liu (Oracle)
5. Oliver Kennedy (State University of New York at Buffalo)

BibTeX Citation

@article{yang_vldb15,
        title = {{Lenses: An On-Demand Approach to ETL}},
        author = {Yang, Ying and Meneghetti, Niccolò and Fehling, Ronny and Liu, Zhen Hua and Kennedy, Oliver},
        journal = {PVLDB},
        series = {{VLDB} '15},
        volume = {8},
        number = {12},
        doi = {10.14778/2824032.2824055},
        url = {https://doi.org/10.14778/2824032.2824055},
        year = {2015}
}

Incoming Citations (Sorted by Pagerank)

Showing 11 of 11 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,241	Query Optimization for Dynamic Imputation	2017	VLDB	8.7704255e-05
4,451	Data Debugging and Exploration with Vizier	2019	SIGMOD	6.5922192e-05
4,870	Uncertainty Annotated Databases - A Lightweight Approach for Approximating Certain Answers	2019	SIGMOD	6.3718189e-05
4,920	Efficient Answering of Historical What-if Queries	2022	SIGMOD	6.3514733e-05
6,048	Your notebook is not crumby enough, REPLace it	2020	CIDR	5.9024167e-05
8,435	Efficient Uncertainty Tracking for Complex Queries with Attribute-level Bounds	2021	SIGMOD	5.3324907e-05
8,768	Beta Probabilistic Databases: A Scalable Approach to Belief Updating and Parameter Learning	2017	SIGMOD	5.2811408e-05
8,895	FastPDB: Towards Bag-Probabilistic Queries at Interactive Speeds	2025	SIGMOD	5.2534908e-05
9,383	Efficient Approximation of Certain and Possible Answers for Ranking and Window Queries over Uncertain Data	2023	VLDB	5.1843659e-05
10,183	Adaptive Schema Databases	2017	CIDR	5.063596e-05
11,608	Hardware-Efficient Data Imputation through DBMS Extensibility	2024	VLDB	4.9769913e-05

Outgoing Citations (Sorted by Pagerank)

Showing 19 of 19 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
9	Online Aggregation	1997	SIGMOD	0.00076265429
17	Provenance Semirings	2007	PODS	0.00059813669
245	MCDB: A Monte Carlo Approach to Managing Uncertain Data	2008	SIGMOD	0.00023251151
337	Trio: A System for Data, Uncertainty, and Lineage	2006	VLDB	0.00020613834
392	Data Exchange: Getting to the Core	2003	PODS	0.00019215652
696	MYSTIQ: A system for finding more answers by using probabilities	2005	SIGMOD	0.00014691377
842	BayesStore: Managing Large, Uncertain Data Repositories with Probabilistic Graphical Models	2008	VLDB	0.00013535734
888	Pay-as-you-go User Feedback for Dataspace Systems	2008	SIGMOD	0.00013250185
2,084	Orion 2.0: Native Support for Uncertain Data	2008	SIGMOD	9.0696396e-05
2,719	Partial Results in Database Systems	2014	SIGMOD	8.0942034e-05
2,806	MayBMS: A Probabilistic Database Management System	2009	SIGMOD	7.9800849e-05
3,916	Efficiently Incorporating User Feedback into Information Extraction and Integration Programs	2009	SIGMOD	6.9259328e-05
6,450	User Feedback as a First Class Citizen in Information Integration Systems	2011	CIDR	5.7796344e-05
7,002	When is Naive Evaluation Possible?	2013	PODS	5.6223434e-05
7,230	OASSIS: Query Driven Crowd Mining	2014	SIGMOD	5.5779439e-05
7,697	SPROUT2: A Squared Query Engine for Uncertain Web Data	2011	SIGMOD	5.4746748e-05
8,361	Jigsaw: Efficient Optimization Over Uncertain Enterprise Data	2011	SIGMOD	5.3456828e-05
9,358	Management of Flexible Schema Data in RDBMSs - Opportunities and Limitations for NoSQL	2015	CIDR	5.1872626e-05
9,772	IQ: The Case for Iterative Querying for Knowledge	2011	CIDR	5.1319406e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	282	Accelerating Machine Learning Inference with Probabilistic Predicates	2018	SIGMOD
2	1,980	Data Wrangling: The Challenging Journey from the Wild to the Lake	2015	CIDR
3	12,151	Query-Driven Learning for Next Generation Predictive Modeling & Analytics	2019	SIGMOD
4	11,396	A Demonstration of QueryArtisan: Real-Time Data Lake Analysis via Dynamically Generated Data Manipulation Code	2025	VLDB
5	10,344	QueryArtisan: Generating Data Manipulation Codes for Ad-hoc Analysis in Data Lakes	2025	VLDB
6	12,029	AnyOLAP: Analytical Processing of Arbitrary Data-Intensive Applications without ETL	2021	VLDB
7	3,580	On-the-Fly Entity-Aware Query Processing in the Presence of Linkage	2010	VLDB
8	7,263	Entity Resolution On-Demand	2022	VLDB
9	10,777	IncreQueryFusion: On-demand Data Fusion Framework in Dynamic Data Lakes	2026	VLDB
10	6,077	QoX-Driven ETL Design: Reducing the Cost of ETL Consulting Engagements	2009	SIGMOD