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: 11223
Venue: VLDB
Year: 2015
Pagerank: 6.0243066e-05
Overall Rank: 5,971 | 59.04%
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,208	Query Optimization for Dynamic Imputation	2017	VLDB	8.9512455e-05
4,373	Data Debugging and Exploration with Vizier	2019	SIGMOD	6.738145e-05
4,805	Efficient Answering of Historical What-if Queries	2022	SIGMOD	6.5003306e-05
4,811	Uncertainty Annotated Databases - A Lightweight Approach for Approximating Certain Answers	2019	SIGMOD	6.4983069e-05
5,931	Your notebook is not crumby enough, REPLace it	2020	CIDR	6.0369708e-05
8,260	Efficient Uncertainty Tracking for Complex Queries with Attribute-level Bounds	2021	SIGMOD	5.4574671e-05
8,597	Beta Probabilistic Databases: A Scalable Approach to Belief Updating and Parameter Learning	2017	SIGMOD	5.4049137e-05
8,724	FastPDB: Towards Bag-Probabilistic Queries at Interactive Speeds	2025	SIGMOD	5.3766157e-05
9,194	Efficient Approximation of Certain and Possible Answers for Ranking and Window Queries over Uncertain Data	2023	VLDB	5.3058708e-05
10,003	Adaptive Schema Databases	2017	CIDR	5.1814573e-05
11,275	Hardware-Efficient Data Imputation through DBMS Extensibility	2024	VLDB	5.093636e-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.00077458002
17	Provenance Semirings	2007	PODS	0.00059843817
238	MCDB: A Monte Carlo Approach to Managing Uncertain Data	2008	SIGMOD	0.0002369322
331	Trio: A System for Data, Uncertainty, and Lineage	2006	VLDB	0.00020936658
377	Data Exchange: Getting to the Core	2003	PODS	0.00019643793
683	MYSTIQ: A system for finding more answers by using probabilities	2005	SIGMOD	0.00015005338
820	BayesStore: Managing Large, Uncertain Data Repositories with Probabilistic Graphical Models	2008	VLDB	0.00013814535
866	Pay-as-you-go User Feedback for Dataspace Systems	2008	SIGMOD	0.00013519288
2,042	Orion 2.0: Native Support for Uncertain Data	2008	SIGMOD	9.2691675e-05
2,663	Partial Results in Database Systems	2014	SIGMOD	8.2818137e-05
2,775	MayBMS: A Probabilistic Database Management System	2009	SIGMOD	8.1359291e-05
3,843	Efficiently Incorporating User Feedback into Information Extraction and Integration Programs	2009	SIGMOD	7.0791732e-05
6,330	User Feedback as a First Class Citizen in Information Integration Systems	2011	CIDR	5.9109104e-05
6,852	When is Naive Evaluation Possible?	2013	PODS	5.7540317e-05
7,081	OASSIS: Query Driven Crowd Mining	2014	SIGMOD	5.7086247e-05
7,547	SPROUT2: A Squared Query Engine for Uncertain Web Data	2011	SIGMOD	5.6022651e-05
8,192	Jigsaw: Efficient Optimization Over Uncertain Enterprise Data	2011	SIGMOD	5.4698006e-05
9,216	Management of Flexible Schema Data in RDBMSs - Opportunities and Limitations for NoSQL	2015	CIDR	5.3051647e-05
9,588	IQ: The Case for Iterative Querying for Knowledge	2011	CIDR	5.2521703e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	8,072	Operational Analytics Data Management Systems	2016	VLDB
2	295	Accelerating Machine Learning Inference with Probabilistic Predicates	2018	SIGMOD
3	1,947	Data Wrangling: The Challenging Journey from the Wild to the Lake	2015	CIDR
4	11,845	Query-Driven Learning for Next Generation Predictive Modeling & Analytics	2019	SIGMOD
5	11,025	A Demonstration of QueryArtisan: Real-Time Data Lake Analysis via Dynamically Generated Data Manipulation Code	2025	VLDB
6	10,109	QueryArtisan: Generating Data Manipulation Codes for Ad-hoc Analysis in Data Lakes	2025	VLDB
7	11,720	AnyOLAP: Analytical Processing of Arbitrary Data-Intensive Applications without ETL	2021	VLDB
8	3,514	On-the-Fly Entity-Aware Query Processing in the Presence of Linkage	2010	VLDB
9	7,743	Entity Resolution On-Demand	2022	VLDB
10	5,979	QoX-Driven ETL Design: Reducing the Cost of ETL Consulting Engagements	2009	SIGMOD