Lineage Tracing for General Data Warehouse Transformations

Summary: Formalizes lineage tracing under general data warehouse transformations. Algorithms exploit known transformation structure when present, and cope with its absence, enabling a practical lineage tool and design guidance for efficient warehousing. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 8962
Venue: VLDB
Year: 2001
Pagerank: 0.00016139897
Overall Rank: 585 | 95.99%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Yingwei Cui (Stanford University)
2. Jennifer Widom (Stanford University)

BibTeX Citation

@article{cui_vldb01,
        title = {{Lineage Tracing for General Data Warehouse Transformations}},
        author = {Cui, Yingwei and Widom, Jennifer},
        journal = {PVLDB},
        series = {{VLDB} '01},
        pages = {41--51},
        year = {2001}
}

Incoming Citations (Sorted by Pagerank)

Showing 29 of 29 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
78	ULDBs: Databases with Uncertainty and Lineage	2006	VLDB	0.00036571789
125	Trio: A System for Integrated Management of Data, Accuracy, and Lineage	2005	CIDR	0.00030932014
201	Declarative Data Cleaning: Language, Model, and Algorithms	2001	VLDB	0.00025558602
314	Making Database Systems Usable	2007	SIGMOD	0.00021574636
385	Why Not?	2009	SIGMOD	0.00019455743
628	On the Provenance of Non-Answers to Queries over Extracted Data	2008	VLDB	0.00015630285
856	How to ConQueR Why-Not Questions	2010	SIGMOD	0.00013573466
1,162	Principles of Dataspace Systems	2006	PODS	0.00011866011
1,366	Provenance for Generalized Map and Reduce Workflows	2011	CIDR	0.00011016972
1,617	Titian: Data Provenance Support in Spark	2016	VLDB	0.00010209397
1,627	Efficient Provenance Storage	2008	SIGMOD	0.00010188097
2,134	Provenance Management in Curated Databases	2006	SIGMOD	9.1154913e-05
2,895	Answering Why-not Questions on Reverse Top-k Queries	2015	VLDB	7.9829449e-05
2,936	Materialized Views in Probabilistic Databases: For Information Exchange and Query Optimization	2007	VLDB	7.9437689e-05
3,843	Efficiently Incorporating User Feedback into Information Extraction and Integration Programs	2009	SIGMOD	7.0791732e-05
4,845	Explaining Outputs in Modern Data Analytics	2016	VLDB	6.4818607e-05
6,564	bdbms – A Database Management System for Biological Data	2007	CIDR	5.8383221e-05
6,913	Evaluation of Probabilistic Threshold Queries in MCDB	2010	SIGMOD	5.7405e-05
7,239	I4E: Interactive Investigation of Iterative Information Extraction	2010	SIGMOD	5.6645117e-05
8,145	You Say ‘What’, I Hear ‘Where’ and ‘Why’ — (Mis-)Interpreting SQL to Derive Fine-Grained Provenance	2018	VLDB	5.4790624e-05
8,714	Stale View Cleaning: Getting Fresh Answers from Stale Materialized Views	2015	VLDB	5.3778009e-05
8,970	Understanding Queries by Conditional Instances	2022	SIGMOD	5.3422757e-05
9,843	Debugging Missing Answers for Spark Queries over Nested Data with Breadcrumb	2021	VLDB	5.210037e-05
10,180	Query Answering Under Volume-Based Diversity Functions	2026	PODS	5.093636e-05
10,320	LPStream: Fine-grained Lazy Provenance for Stream Processing	2026	SIGMOD	5.093636e-05
10,701	Unified Lineage System: Tracking Data Provenance at Scale	2025	SIGMOD	5.093636e-05
11,842	Ariadne: Online Provenance for Big Graph Analytics	2019	SIGMOD	5.093636e-05
12,630	K-Relevance: A Spectrum of Relevance for Data Sources Impacting a Query	2007	SIGMOD	5.093636e-05
12,710	TRAC: Toward Recency and Consistency Reporting in a Database with Distributed Data Sources	2006	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
81	Implementation of Integrity Constraints and Views by Query Modification	1975	SIGMOD	0.00036443459
952	Recovering Information from Summary Data	1997	VLDB	0.00013010681
1,558	SchemaSQL - A Language for Interoperability in Relational Multi-database Systems	1996	VLDB	0.00010366362
3,220	Efficient Resumption of Interrupted Warehouse Loads	2000	SIGMOD	7.6272892e-05
3,915	A Data Transformation System for Biological Data Sources	1995	VLDB	7.0193727e-05
4,561	Data Extraction and Transformation for the Data Warehouse	1995	SIGMOD	6.6301106e-05
5,212	Managing Derived Data in the Gaea Scientific DBMS	1993	VLDB	6.3160954e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	9,125	Data Stream Warehousing	2013	SIGMOD
2	9,258	Data Stream Warehousing in Tidalrace	2015	CIDR
3	10,063	Keep Your Distributed Data Warehouse Consistent at a Minimal Cost	2023	SIGMOD
4	1,543	Data Warehouse Configuration	1997	VLDB
5	14,152	Data Warehousing Has More Colours Than Just Black & White	1999	VLDB
6	1,366	Provenance for Generalized Map and Reduce Workflows	2011	CIDR
7	10,701	Unified Lineage System: Tracking Data Provenance at Scale	2025	SIGMOD
8	4,561	Data Extraction and Transformation for the Data Warehouse	1995	SIGMOD
9	1,871	Efficient Lineage Tracking For Scientific Workflows	2008	SIGMOD
10	6,351	Tracing Lineage Beyond Relational Operators	2007	VLDB