Data Warehousing

Our book chapter "Data Integration Services" (pdf file)  - N. Tatbul, O. Karpenko, C. Convey. May 2001

Data Warehousing  Bibliography

General

 Rick Noel "Data Warehouses. A look at where we are going."
          1. Larry Greenfield, Data Warehousing Information Center. (Web site)
        2. Data Warehousing Online. (Web site)
        3. Data Warehousing Knowledge Center. (Web site)
        4. Kimball, R., The Data Warehouse Toolkit, John Wiley, 1996. (And other books).
        5. "Microsoft Data Warehousing: Building Distributed Decision Support Systems" by Craig, Vivona, and Bercovitch         1. Jennifer Widom, Research Problems in Data Warehousing, Int'l Conf. on Information and Knowledge Management '95.
        2. M.C. Wu, A.P. Buchmann, Research Issues in Data Warehousing, BTW'97, Ulm, March, 1997.
        3. Surajit Chaudhuri and Umesh Dayal, An Overview of Data Warehousing and OLAP Technology, ACM SIGMOD Record 26(1), March 1997.
        4. Hector Garcia-Molina,Wilburt Juan Labio, Janet Wiener, Yue Zhuge. Distributed and Parallel Computing Issues in Data Warehousing. PODC '98.
        5.  Sunil Samtani, Mukesh K. Mohania, Vijay Kumar, Yahiko Kambayashi: Recent Advances and Research Problems in Data Warehousing. ER Workshops 1998: 81-92.
        6.  Panos Vassiliadis: Gulliver in the land of data warehousing: practical experiences and observations of a researcher. DMDW 2000: 12.

Modeling and Design
           1.  S. S. Chawathe and H. Garcia-Molina. "Meaningful Change Detection in Structured Data." In Proceedings of the ACM SIGMOD Conference, Tuscon, Arizona, May, 1997.
         2.  W. J. Labio and H. Garcia-Molina. "Efficient Snapshot Differential Algorithms for Data Warehousing.", Proceedings of VLDB Conference, Bombay, India, September 1996, pp. 63.
        3.  S. S. Chawathe, A. Rajaraman, H. Garcia-Molina, and J. Widom. "Change Detection in Hierarchically Structured Information." In Proceedings of the ACM SIGMOD Conference, Montreal, Canada, June 1996.
pers.  In  proceedings of the ACM SIGMOD Conference, Montreal, Canada, June 1996.         1.  Y. Papakonstaninou, A. Gupta, H. Garcia-Molina, and J. Ullman. A query translation scheme for rapid implementation of wrappers.  In  proceedings of the Fourth International Conference on Deductive and    Object-Oriented Databases, Singapore, December 1995.
        2. Diego Calvanese, Giuseppe De Giacomo, et. al, "Source Integration in Data Warehousing",  1997.

Maintenance  (Creation and refreshing)

    1.  "Materialized Views : Techniques, Implementations, and Applications". Edited by Ashish Gupta, Inderpal Singh Mumick. MIT Press, June 1999.         1. V. Harinarayan, A. Rajaraman, and J.D. Ullman, Implementing Data Cubes Efficiently, Proc. ACM SIGMOD '96, 205-216.
        2. H. Gupta, Selection of Views to Materialize in a Data Warehouse, Proc.Intl. Conf. on Database Theory, January 1997.
        3. D. Theodoratos and T. Sellis, Data warehouse configuration, Proc. VLDB '97, 126-135.
        4. J . Yang, K. Karlapalem, Q. Li, Algorithms for materialized view design in data warehousing environment, Proc. VLDB '97, 136-145.
        5. E. Baralis, S. Paraboschi, E. Teniente, Materialized view selection in a multidimensional database, Proc. VLDB '97, 156-165.
        6. H. Gupta and I.S. Mumick. Selection of Views to Materialize Under a Maintenance-Time Constraint. International Conference on Database Theory, Jerusalam, Israel, January 1999.
        7. Yannis Kotidis and Nick Roussopoulos, DynaMat: A Dynamic View Management System for Data Warehouses. Proc. ACM/SIGMOD '99.
        8. D. Theodoratos, T. Sellis. Dynamic Data Warehouse Design. Proc. Intl. Conf. on Data Warehousing and Knowledge Discovery, (DaWaK'99), Florence Italy, August 1999, Springer LNCS 1676, pp. 1 - 10.
        9. D. Theodoratos, T. Sellis. Designing Data Warehouses. Data and Knowledge Engineering (DKE), 31, 3, Oct. 1999, pp. 279 - 301.         1. A. Gupta, and I. S. Mumick. Maintenance of Materialized Views: Problems, Techniques, and Applications, Data Engineering Bulletin, June 1995.
        2. Y. Zhuge, H. Garcia-Molina, J. Hammer, and J. Widom. View Maintenance in a Warehousing Environment, Proc. ACM SIGMOD '95, 316-327. Full version of the same paper.
        3. R. Hull and G. Zhou. A Framework for Supporting Data Integration Using the Materialized and Virtual Approaches, Proc. ACM SIGMOD '96, 481-492.
        4. G. Zhou, R. Hull and R. King. Generating Data Integration Mediators that Use Materialization, Journal of Intelligent Information Systems 3:2/3, May 1996, 99-221.
        5. N. Huyn. Efficient View Self-Maintenance, Proc. ACM Workshop on Materialized Views: Techniques and Applications, June 1996.
        6. D. Quass. Maintenance Expressions for Views with Aggregation, Proc. ACM Workshop on Materialized Views: Techniques and Applications, June 1996.
        7. P. Scheuermann, J. Shim, R. Vingralek. WATCHMAN: A Data Warehouse Intelligent Cache Manager. Proc. VLDB '96, 51-62.
        8 . W.J. Labio and H. Garcia-Molina. Efficient Snapshot Differential Algorithms for Data Warehousing. Proc. VLDB '96, 63-74. Technical report.
        9. M. Staudt and M. Jarke. Incremental Maintenance of Externally Materialized Views. Proc. VLDB '96, 75-86.
        10. D. Quass, A. Gupta, I.S. Mumick, and J. Widom. Making Views Self-Maintainable for Data Warehousing. Proc. Fourth Intl. Conf. on Parallel and Distributed Information Systems (PDIS '96), December 1996.
        11. Y. Zhuge, H. Garcia-Molina, and J. L. Wiener The Strobe Algorithms for Multi-Source Warehouse Consistency. Proc. Fourth Intl. Conf. on Parallel and Distributed Information Systems, (PDIS '96), December 1996.
        12. J.L. Wiener, H. Gupta, W.J. Labio, Y. Zhuge, H. Garcia-Molina, and J. Widom. A System Prototype for Warehouse View Maintenance. Proc. ACM Workshop on Materialized Views: Techniques and Applications, 26-33, June 1996.
        13. Y. Zhuge, J. L. Wiener and H. Garcia-Molina, Multiple View Consistency for Data Warehousing. Proc. ICDE '97.
        14. N. Huyn, Multiple-view self-maintenance in data warehousing environments, Proc. VLDB '97, 26-35.
        15. H.V. Jagadish, P.P.S. Narayan, S. Seshadri, S. Sudarshan, R. Kanneganti, Incremental organization for data recording and warehousing. Proc. VLDB '97, 16-25.
        16. I.S. Mumick, D. Quass, and B.S. Mumick, Maintenance of data cubes and summary tables in a warehouse, Proc. ACM SIGMOD '97, 100-111.
        17. D. Quass and J. Widom. On-Line Warehouse View Maintenance for Batch Updates. Proc. ACM SIGMOD '97, 393-404.
        18. J. Yang and J. Widom. Maintaining Temporal Views Over Non-Historical Information Sources For Data Warehousing. Technical Report, February 1997. Proc. ICDE '98.
        19.  Y. Zhuge and H. Garcia-Molina. Graph Structured Views and Their Incremental Maintenance. Proc. ICDE '98.
        20. Y. Zhuge, H. Garcia-Molina, and J. L. Wiener Consistency Algorithms for Multi-Source Warehouse View Maintenance. To appear in the Journal of Distributed and Parallel Databases, July, 1997.
        21. H. Garcia-Molina , W. Labio , J. Yang. Expiring Data in a Warehouse. Proc. VLDB '98.
Carlos Hurtado, Alberto Mendelzon, Alejandro Vaisman. Maintaining Data Cubes under Dimension Updates. Proc IEEE/ICDE '99.
        22. Wilburt Juan Labio, Ramana Yerneni, Hector Garcia-Molina. Shrinking the Warehouse Update Window . In Proc. ACM/SIGMOD '99.
        23. Carlos Hurtado, Alberto Mendelzon, and Alejandro Vaisman. Updating OLAP Dimensions DOLAP'99,Kansas City, November 1999, 60-66.
        24. P. Vassiliadis, M. Bouzeghoub, C. Quix. Towards Quality-Oriented Data Warehouse Usage and Evolution Proc. Intl. Conference on Advance Information Systems Engineering (CAiSE?99), Heidelberg, Germany, 1999 (best paper).
        25. M. Bouzeghoub, F. Fabret, M. Matulovic. Modeling Data Warehouse Refreshment Process as a Workflow Application. Proc. Intl. Workshop on Design and Management of Data Warehouses (DMDW?99), Heidelberg, Germany, June 1999
        26. Y. Cui and J. Widom. "Practical Lineage Trac ing in Data Warehouses." In Proceedings of the Sixteenth International Conference on Data Engineering, San Diego, California, February 2000.
        27. J. Yang and J. Widom. "Making Temporal Views Self-Maintainable for Data Warehousing." In Proceedings of the 7th International Conference on Extending Database Technology, Konstanz, Germany, March 2000.

Operation

  •    Query languages and processing
    •         1. W. Labio, D. Quass, B. Adelberg. Physical Database Design for Data Warehousing. Proc. ICDE '97. Full version.
            2.   H. Gupta, V. Harinarayan, A. Rajaraman, and J. Ullman. Index Selection for OLAP. Proc. ICDE '97.
            3. P. O'Neil, D. Quass, Improved query performance with variant indexes, Proc. ACM SIGMOD '97, 38-49. Longer version.
            4. Informix Corporation, INFORMIX-OnLine Extended Parallel Server and INFORMIX-Universal Server: A New Generation of Decision-Support Indexing for Enterprise Data Warehouses.
            5. T. Johnson and D. Shasha, Some Approaches to Index Design for Cube Forests, IEEE Data Engineering Bulletin, 20(1):27-35, March 1997.
            6. S. Sarawagi, Indexing OLAP Data, IEEE Data Engineering Bulletin, 20(1):36-43, March 1997.
            7. Yannis Kotidis, Nick Roussopoulos, An Alternative Storage Organization for ROLAP Aggregate Views Based on Cubetrees, Proc. ACM SIGMOD '98, 249-258.
            8. C.Y. Chan and Y.E. Ioannidis, Bitmap Index Design and Evaluation, Proc. ACM SIGMOD '98, 355-366.
            9. M.C. Wu, A.P. Buchmann, Encoded Bitmap Indexing for Data Warehouses, Proc. ICDE '98, 220-230.
           10. H. Lei and K. A. Ross. Faster Joins, Self-Joins and Multi-Way Joins Using Join Indices. International Workshop on Next Generation Information Technologies and Systems, June 1997. Extended version to appear in Data and Knowledge Engineering.
           1. W. J. Labio, J. Wiener, H. Garcia-Molina, V. Gorelik. "Efficient Resumption of Interrupted
        Warehouse Loads." Technical Reprot, Stanford University, 1998.

    Projects

    1. N. Roussopoulos, C.M. Chen, S. Kelley, A. Delis, and Y. Papakonstantinou, The Maryland ADMS Project: Views R Us. IEEE Data Engineering Bulletin, 18(2):19-28, June 1995.
    2. G. Zhou, R. Hull, R. King, and J.-C. Franchitti, Supporting Data Integration and Warehousing Using H2O.  IEEE Data Engineering Bulletin, 18(2):29-40, June 1995.
    3. J. Hammer, H. Garcia-Molina, W. Labio, J. Widom, and Y. Zhuge. The Stanford Data Warehousing Project. IEEE Data Engineering Bulletin, 18(2):41-48, June 1995.
    4. M. Jarke, Y. Vassiliou. Data Warehouse Quality Design: A Review of the DWQ Project. Invited Paper, Proc. 2nd Conference on Information Quality. Massachusetts Institute of Technology, Cambridge, 1997.
    5. H. Gupta and D. Srivastava. The Data Warehouse of Newsgroups. International Conference on Database Theory, Jerusalem, Israel, January 1999.
    6. Stefano Trisolini, Maurizio Lenzerini, Daniele Nardi. Data Integration and Warehousing in Telecom Italia Proc.
     Lots of information is taken from the sites of A.O. Mendelzon and Carlos Hurtado .
     mendel@db.toronto.edu, chl@cs.toronto.edu.