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.00015888097
Overall Rank: 591 | 96.03%
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
84	ULDBs: Databases with Uncertainty and Lineage	2006	VLDB	0.00035963861
126	Trio: A System for Integrated Management of Data, Accuracy, and Lineage	2005	CIDR	0.00030439683
204	Declarative Data Cleaning: Language, Model, and Algorithms	2001	VLDB	0.00025190386
319	Making Database Systems Usable	2007	SIGMOD	0.00021164857
391	Why Not?	2009	SIGMOD	0.00019238698
622	On the Provenance of Non-Answers to Queries over Extracted Data	2008	VLDB	0.00015484312
791	How to ConQueR Why-Not Questions	2010	SIGMOD	0.00013976192
1,114	Principles of Dataspace Systems	2006	PODS	0.00011964697
1,388	Provenance for Generalized Map and Reduce Workflows	2011	CIDR	0.00010821908
1,564	Titian: Data Provenance Support in Spark	2016	VLDB	0.00010222394
1,610	Efficient Provenance Storage	2008	SIGMOD	0.00010076616
2,170	Provenance Management in Curated Databases	2006	SIGMOD	8.924429e-05
2,955	Answering Why-not Questions on Reverse Top-k Queries	2015	VLDB	7.8102237e-05
2,984	Materialized Views in Probabilistic Databases: For Information Exchange and Query Optimization	2007	VLDB	7.7830089e-05
3,915	Efficiently Incorporating User Feedback into Information Extraction and Integration Programs	2009	SIGMOD	6.9290474e-05
4,940	Explaining Outputs in Modern Data Analytics	2016	VLDB	6.345789e-05
6,686	bdbms – A Database Management System for Biological Data	2007	CIDR	5.7085095e-05
7,050	Evaluation of Probabilistic Threshold Queries in MCDB	2010	SIGMOD	5.6132096e-05
7,365	I4E: Interactive Investigation of Iterative Information Extraction	2010	SIGMOD	5.5415736e-05
7,819	You Say ‘What’, I Hear ‘Where’ and ‘Why’ — (Mis-)Interpreting SQL to Derive Fine-Grained Provenance	2018	VLDB	5.4466474e-05
8,870	Stale View Cleaning: Getting Fresh Answers from Stale Materialized Views	2015	VLDB	5.2601766e-05
9,061	Understanding Queries by Conditional Instances	2022	SIGMOD	5.2289882e-05
10,024	Debugging Missing Answers for Spark Queries over Nested Data with Breadcrumb	2021	VLDB	5.0934925e-05
10,194	LPStream: Fine-grained Lazy Provenance for Stream Processing	2026	SIGMOD	5.0623376e-05
10,196	Ariadne: Online Provenance for Big Graph Analytics	2019	SIGMOD	5.0623376e-05
10,396	Query Answering Under Volume-Based Diversity Functions	2026	PODS	4.9793485e-05
11,135	Unified Lineage System: Tracking Data Provenance at Scale	2025	SIGMOD	4.9793485e-05
12,920	K-Relevance: A Spectrum of Relevance for Data Sources Impacting a Query	2007	SIGMOD	4.9793485e-05
13,000	TRAC: Toward Recency and Consistency Reporting in a Database with Distributed Data Sources	2006	VLDB	4.9793485e-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.00035719146
967	Recovering Information from Summary Data	1997	VLDB	0.00012794553
1,578	SchemaSQL - A Language for Interoperability in Relational Multi-database Systems	1996	VLDB	0.00010187094
3,278	Efficient Resumption of Interrupted Warehouse Loads	2000	SIGMOD	7.4661193e-05
3,981	A Data Transformation System for Biological Data Sources	1995	VLDB	6.8772513e-05
4,620	Data Extraction and Transformation for the Data Warehouse	1995	SIGMOD	6.4993395e-05
5,321	Managing Derived Data in the Gaea Scientific DBMS	1993	VLDB	6.1818042e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	9,292	Data Stream Warehousing	2013	SIGMOD
2	9,432	Data Stream Warehousing in Tidalrace	2015	CIDR
3	10,268	Keep Your Distributed Data Warehouse Consistent at a Minimal Cost	2023	SIGMOD
4	1,547	Data Warehouse Configuration	1997	VLDB
5	14,463	Data Warehousing Has More Colours Than Just Black & White	1999	VLDB
6	1,388	Provenance for Generalized Map and Reduce Workflows	2011	CIDR
7	11,135	Unified Lineage System: Tracking Data Provenance at Scale	2025	SIGMOD
8	4,620	Data Extraction and Transformation for the Data Warehouse	1995	SIGMOD
9	1,913	Efficient Lineage Tracking For Scientific Workflows	2008	SIGMOD
10	6,451	Tracing Lineage Beyond Relational Operators	2007	VLDB