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: hc47ab360c1d75718
Venue: VLDB
Year: 2001
Pagerank: 0.0001583562
Overall Rank: 592 | 96.04%
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
85	ULDBs: Databases with Uncertainty and Lineage	2006	VLDB	0.00035848027
127	Trio: A System for Integrated Management of Data, Accuracy, and Lineage	2005	CIDR	0.00030337791
206	Declarative Data Cleaning: Language, Model, and Algorithms	2001	VLDB	0.00025121652
321	Making Database Systems Usable	2007	SIGMOD	0.00021093212
389	Why Not?	2009	SIGMOD	0.00019254758
624	On the Provenance of Non-Answers to Queries over Extracted Data	2008	VLDB	0.00015438077
790	How to ConQueR Why-Not Questions	2010	SIGMOD	0.00013929166
1,120	Principles of Dataspace Systems	2006	PODS	0.00011920747
1,393	Provenance for Generalized Map and Reduce Workflows	2011	CIDR	0.00010784123
1,562	Titian: Data Provenance Support in Spark	2016	VLDB	0.00010192248
1,621	Efficient Provenance Storage	2008	SIGMOD	0.00010039235
2,186	Provenance Management in Curated Databases	2006	SIGMOD	8.8910881e-05
2,975	Answering Why-not Questions on Reverse Top-k Queries	2015	VLDB	7.7807277e-05
2,996	Materialized Views in Probabilistic Databases: For Information Exchange and Query Optimization	2007	VLDB	7.7548593e-05
3,924	Efficiently Incorporating User Feedback into Information Extraction and Integration Programs	2009	SIGMOD	6.9044317e-05
4,963	Explaining Outputs in Modern Data Analytics	2016	VLDB	6.3234324e-05
6,705	bdbms – A Database Management System for Biological Data	2007	CIDR	5.6870494e-05
7,073	Evaluation of Probabilistic Threshold Queries in MCDB	2010	SIGMOD	5.5920064e-05
7,389	I4E: Interactive Investigation of Iterative Information Extraction	2010	SIGMOD	5.5209957e-05
7,840	You Say ‘What’, I Hear ‘Where’ and ‘Why’ — (Mis-)Interpreting SQL to Derive Fine-Grained Provenance	2018	VLDB	5.4260988e-05
8,894	Stale View Cleaning: Getting Fresh Answers from Stale Materialized Views	2015	VLDB	5.2415191e-05
9,090	Understanding Queries by Conditional Instances	2022	SIGMOD	5.2092307e-05
10,067	Debugging Missing Answers for Spark Queries over Nested Data with Breadcrumb	2021	VLDB	5.074247e-05
10,230	LPStream: Fine-grained Lazy Provenance for Stream Processing	2026	SIGMOD	5.0432098e-05
10,235	Ariadne: Online Provenance for Big Graph Analytics	2019	SIGMOD	5.0432098e-05
10,474	Query Answering Under Volume-Based Diversity Functions	2026	PODS	4.9605343e-05
11,203	Unified Lineage System: Tracking Data Provenance at Scale	2025	SIGMOD	4.9605343e-05
12,968	K-Relevance: A Spectrum of Relevance for Data Sources Impacting a Query	2007	SIGMOD	4.9605343e-05
13,048	TRAC: Toward Recency and Consistency Reporting in a Database with Distributed Data Sources	2006	VLDB	4.9605343e-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
87	Implementation of Integrity Constraints and Views by Query Modification	1975	SIGMOD	0.00035589793
971	Recovering Information from Summary Data	1997	VLDB	0.00012748313
1,580	SchemaSQL - A Language for Interoperability in Relational Multi-database Systems	1996	VLDB	0.00010153792
3,290	Efficient Resumption of Interrupted Warehouse Loads	2000	SIGMOD	7.4383411e-05
3,994	A Data Transformation System for Biological Data Sources	1995	VLDB	6.8544209e-05
4,637	Data Extraction and Transformation for the Data Warehouse	1995	SIGMOD	6.475203e-05
5,343	Managing Derived Data in the Gaea Scientific DBMS	1993	VLDB	6.1589396e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	9,327	Data Stream Warehousing	2013	SIGMOD
2	9,468	Data Stream Warehousing in Tidalrace	2015	CIDR
3	10,301	Keep Your Distributed Data Warehouse Consistent at a Minimal Cost	2023	SIGMOD
4	1,550	Data Warehouse Configuration	1997	VLDB
5	14,508	Data Warehousing Has More Colours Than Just Black & White	1999	VLDB
6	1,393	Provenance for Generalized Map and Reduce Workflows	2011	CIDR
7	11,203	Unified Lineage System: Tracking Data Provenance at Scale	2025	SIGMOD
8	4,637	Data Extraction and Transformation for the Data Warehouse	1995	SIGMOD
9	1,923	Efficient Lineage Tracking For Scientific Workflows	2008	SIGMOD
10	6,453	Tracing Lineage Beyond Relational Operators	2007	VLDB