Lineage tracing for general data warehouse transformations

VLDB 2001 - Proceedings of 27th International Conference on Very Large Data Bases

Volumn , Issue , 2001, Pages 471-480

  Cui, Yingwei ^a   Widom, Jennifer ^a  

^a Stanford University   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

ALGEBRAIC OPERATIONS; DATA CLEANSING; DATA LINEAGE; DATA WAREHOUSING SYSTEMS; INTEGRATED INFORMATIONS; INTEGRATION PROCESS; LINEAGE TRACING; OPERATIONAL DATA;

DATA WAREHOUSES;

EID: 84944317721     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: None     Document Type: Conference Paper

References (29)

1. S. Abiteboul, S. Cluet, T. Milo, P. Mogilevsky, J. Simeon, and S. Zohar. Tools for data translation and integration. IEEE Data Engineering Bulletin, 22(1):3-8, March 1999.
2. P. Bernstein and T. Bergstraesser. Meta-data support for data transformations using Microsoft Repository. IEEE Data Engineering Bulletin, 22(1):9-14, March 1999.
3. P. Buneman, S.B. Davidson, K. Hart, G.C. Overton, and L. Wong. A data transformation system for biological data sources. In Proc. of the Twenty-first International Conference on Very Large Data Bases, pages 158-169, Zurich, Switzerland, September 1995.
4. S. Chaudhuri and U. Dayal. An overview of data warehousing and OLAP technology. SIGMOD Record, 26(1):65-74, March 1997.
5. K.T. Claypool and E.A. Rundensteiner. Flexible database transformations: The SERF approach. IEEE Data Engineering Bulletin, 22(1):19-24, March 1999.
6. Y. Cui. Lineage tracing in data warehouses. Ph.D. Thesis, Computer Science Department, Stanford University, 2001.
7. Y. Cui and J. Widom. Practical lineage tracing in data warehouses. In Proc. of the Sixteenth International Conference on Data Engineering, pages 367-378, San Diego, California, February 2000.
8. Y. Cui and J. Widom. Lineage tracing for general data warehouse transformations. Technical report, Stanford University Database Group, January 2001. http://dbpubs.stanford.edu/pub/2001-5.
9. Y. Cui, J. Widom, and J.L. Wiener. Tracing the lineage of view data in a warehousing environment. ACM Transactions on Database Systems, 25(2):179-227, June 2000.
10. IBM: DB2 OLAP Server. http://www.software.ibm.com/data/db2/.
11. C. Faloutsos, H.V. Jagadish, and N.D. Sidiropoulos. Recovering information from summary data. In Proc. of the Twenty-Third International Conference on Very Large Data Bases, pages 36-45, Athens, Greece, August 1997.
12. L.M. Haas, R.J. Miller, B. Niswonger, M.T. Roth, P.M. Schwarz, and E.L.Wimmers. Transforming heterogeneous data with database middleware: Beyond integration. IEEE Data Engineering Bulletin, 22(1):31-36, March 1999.
13. N. I. Hachem, K. Qiu, M. Gennert, and M. Ward. Managing derived data in the Gaea scientific DBMS. In Proc. of the Ninteenth International Conference on Very Large Data Bases, pages 1-12, Dublin, Ireland, August 1993.
14. Informix Formation Data Transformation Tool. http://www.informix.com/informix/products/integration/formation/formation.html.
15. T. Lee, S. Bressan, and S. Madnick. Source attibution for querying against semi-structured documents. In Proc. of the Workshop on Web Information and Data Management, pages 33-39, Washington, DC, November 1998.
16. W.J. Labio, H. Garcia-Molina, and J.L. Weiner. Efficient resumption of interrupted warehouse loads. In Proc. of the ACM SIGMOD International Conference on Management of Data, pages 46-57, Dallas, Texas, May 2000.
17. L. Lakshmanan, F. Sadri, and I.N. Subramanian. SchemaSQL - a language for interoperability in relational multi-database systems. In Proc. of the Twenty-Second International Conference on Very Large Data Bases, pages 239-250, India, September 1996.
18. D. Lomet and J.Widom, editors. Special Issue on Materialized Views and Data Warehousing, IEEE Data Engineering Bulletin 18(2), June 1995.
19. Microsoft SQL Server, Data Transformation Services. http://msdn.microsoft.com/library/psdk/sql/dtsovrw.htm.
20. Cognos: PowerPlay OLAP Data Analysis and Reporting Tool. http://www.cognos.com/powerplay/.
21. PPD Informatics: TableTrans Data Transformation Software. http://www.belmont.com/tt.html.
22. V. Raman and J. Hellerstein. Potters Wheel: An interactive framework for data cleaning. Technical report, U.C. Berkeley, 2000. http://control.cs.berkeley.edu/abc.
23. A. Rosenthal and E. Sciore. Propagating integrity information among interrelated databases. In Proc. of the Second Working Conference on Integrity and Internal Control in Information Systems, pages 5-18, Warrenton, Virginia, November 1998.
24. A. Rosenthal and E. Sciore. First class views: A key to usercentered computing. SIGMOD Record, 28(3):29-36, March 1999.
25. Sagent Technology. http://www.sagent.com/.
26. N.C. Shu. Automatic data transformation and restructuring. In Proc. of the Third International Conference on Data Engineering, pages 173-180, Los Angeles, California, February 1987.
27. C. Squire. Data extraction and transformation for the data warehouse. In Proc. of the ACM SIGMOD International Conference on Management of Data, pages 446-447, California, May 1995.
28. M. Stonebraker. Implementation of integrity constraints and views by query modification. In Proc. of the ACM SIGMOD International Conference on Management of Data, pages 65-78, California, May 1975.
29. A.Woodruff and M. Stonebraker. Supporting fine-grained data lineage in a database visualization environment. In Proc. of the Thirteenth International Conference on Data Engineering, pages 91-102, Birmingham, UK, April 1997.