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.8908642e-05
Overall Rank: 6,089 | 59.07%
DOI: 10.14778/2824032.2824055

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,239	Query Optimization for Dynamic Imputation	2017	VLDB	8.7745792e-05
4,449	Data Debugging and Exploration with Vizier	2019	SIGMOD	6.5953404e-05
4,868	Uncertainty Annotated Databases - A Lightweight Approach for Approximating Certain Answers	2019	SIGMOD	6.3748367e-05
4,919	Efficient Answering of Historical What-if Queries	2022	SIGMOD	6.3544814e-05
6,046	Your notebook is not crumby enough, REPLace it	2020	CIDR	5.9052121e-05
8,426	Efficient Uncertainty Tracking for Complex Queries with Attribute-level Bounds	2021	SIGMOD	5.3350162e-05
8,760	Beta Probabilistic Databases: A Scalable Approach to Belief Updating and Parameter Learning	2017	SIGMOD	5.283642e-05
8,886	FastPDB: Towards Bag-Probabilistic Queries at Interactive Speeds	2025	SIGMOD	5.2559789e-05
9,374	Efficient Approximation of Certain and Possible Answers for Ranking and Window Queries over Uncertain Data	2023	VLDB	5.1868213e-05
10,179	Adaptive Schema Databases	2017	CIDR	5.0659942e-05
11,602	Hardware-Efficient Data Imputation through DBMS Extensibility	2024	VLDB	4.9793485e-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.00076195956
17	Provenance Semirings	2007	PODS	0.00059752575
245	MCDB: A Monte Carlo Approach to Managing Uncertain Data	2008	SIGMOD	0.00023258672
337	Trio: A System for Data, Uncertainty, and Lineage	2006	VLDB	0.00020621631
392	Data Exchange: Getting to the Core	2003	PODS	0.0001922472
696	MYSTIQ: A system for finding more answers by using probabilities	2005	SIGMOD	0.00014697176
841	BayesStore: Managing Large, Uncertain Data Repositories with Probabilistic Graphical Models	2008	VLDB	0.00013541445
888	Pay-as-you-go User Feedback for Dataspace Systems	2008	SIGMOD	0.00013255989
2,082	Orion 2.0: Native Support for Uncertain Data	2008	SIGMOD	9.0732581e-05
2,717	Partial Results in Database Systems	2014	SIGMOD	8.0980367e-05
2,805	MayBMS: A Probabilistic Database Management System	2009	SIGMOD	7.9836802e-05
3,915	Efficiently Incorporating User Feedback into Information Extraction and Integration Programs	2009	SIGMOD	6.9290474e-05
6,447	User Feedback as a First Class Citizen in Information Integration Systems	2011	CIDR	5.7823613e-05
7,001	When is Naive Evaluation Possible?	2013	PODS	5.6250062e-05
7,228	OASSIS: Query Driven Crowd Mining	2014	SIGMOD	5.5805857e-05
7,691	SPROUT2: A Squared Query Engine for Uncertain Web Data	2011	SIGMOD	5.4772676e-05
8,357	Jigsaw: Efficient Optimization Over Uncertain Enterprise Data	2011	SIGMOD	5.3481669e-05
9,349	Management of Flexible Schema Data in RDBMSs - Opportunities and Limitations for NoSQL	2015	CIDR	5.1897188e-05
9,767	IQ: The Case for Iterative Querying for Knowledge	2011	CIDR	5.1343712e-05

Semantically Similar Papers

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