Index (by topic area)

• Overview Papers
• Designing a Data Warehouse
• Extracting Data from Sources
• Warehouse Integration
• Warehouse Maintenance & Consistency
• Query Processing & Optimization
• Multi-dimensional Databases
• Data Mining
• Research Protoype Systems
• Commercial Data Warehousing Products
• Miscellaneous Data Warehousing Links

 

Overview Papers

• Larry Greenfield, Data Warehousing Information Center. (Web site)
• Jennifer Widom, Research Problems in Data Warehousing, Int'l Conf. on Information and Knowledge Management '95.
• Jeff Byard and Donovan Schneider, The Ins and Outs (and everything in between) of Data Warehousing. ACM SIGMOD 1996 Tutorial Notes, May 1996.
• Kimball, R., The Data Warehouse Toolkit. John Wiley, 1996.
• V. R. Gupta, "An Introduction to Data Warehousing," System Services Corporation, August 1997.
• W.H. Inmon, Building the Data Warehouse. John Wiley, 2nd edition, 1996.
• B. Devlin, Data Warehouse: From Architecture to Implementation. Addison-Wesley, 1997.
• M. Sweiger. "Optimal Machine Architectures for Parallel Query Scalability." Sequent Computer Systems.
• Surajit Chaudhuri and Umesh Dayal, An Overview of Data Warehousing and OLAP Technology, ACM SIGMOD Record 26(1), March 1997.
• M.C. Wu and A.P. Buchmann, Research Issues in Data Warehousing. In Proceedings of the BTW '97, Ulm, Germany, March, 1997.

Designing a Data Warehouse

• Stanford Technology Group. "Designing the Data Warehouse on Relational Database Systems." The Stanford Technology Group, an Informix Co., Menlo Park, CA, White Paper, 1996.
• Redbrick. "Star Schema Processing for Complex Queries." White Paper, Red Brick Systems, Los Gatos (CA), 1995.
• Redbrick. "Star Schemas and STARjoin Technology." White Paper, Red Brick Systems, Los Gatos (CA), 1995.
• C.J. Klumpp. "Surfing the World Wide Web to Make Every Data Warehouse Client a Data Expert." In CAUSE 1996.
• K. Aberer, K. Hemm. "A Methodology for Building a Data Warehouse in a Scientific Environment." In CoopIS 1996, 90-101.
• W. Labio, D. Quass, B. Adelberg. "Physical Database Design for Data Warehousing." In Proceedings of the International Conference on Data Engineering, Birmingham, UK, April, 1997.
• D. Theodoratos and T. Sellis. "Data warehouse configuration", Proc. VLDB '97, 126-135.
• H. Gupta and I. Mumick. "Selection of Views to Materialize Under a Maintenance-Time Constraint." Technical Note, 1997.
• H. Gupta and D. Srivastava. "Selecting and Maintaining Materialized Views for Message Management." Technical Note, 1997.
• H. Gupta, V. Harinarayan, A. Rajaraman, and J. Ullman. "Index Selection for OLAP." In Proceedings of the International Conference on Data Engineering, Binghamton, UK, April, 1997.
• H. Gupta. "Selection of Views to Materialize in a Data Warehouse." In Proceedings of the International Conference on Database Theory, Athens, Greece, January 1997.
• V. Harinarayan, A. Rajaraman, J. Ullman. "Implementing Data Cubes Efficiently." In Proceedings of ACM SIGMOD Conference, Montreal, Canada, June 1996.

Semistructured Data:

• Y. Papakonstantinou, H. Garcia-Molina, and J. Widom. Object Exchange Across Heterogeneous Information Sources. In Proceedings of the Eleventh International Conference on Data Engineering, pages 251-260, Taipei, Taiwan, March 1995. Note: one cut-and-paste figure is omitted from the postscript file.
• Robin Cover. The SGML/XML Web Page. OASIS - Organization for the Advancement of Structured Information Standards.
• W3 Consortium. eXtensible Markup Language (XML). W3 Architecture Domain.

Computing and Decting Changes:

• S. Chawathe, S. Abiteboul, and J. Widom, Representing and Querying Changes in Semistructured Data, in Proceedings of the Fourteenth International Conference on Database Engineering, Orlando, Florida, February 1998.
• W. J. Labio and H. Garcia-Molina. "Efficient Snapshot Differential Algorithms for Data Warehousing." In Proceedings of VLDB Conference, Mumbai, India, September 1996, pp. 63-74.
• S. Chawathe, H. Garcia-Molina. "Meaningful Change Detection in Structured Data." In SIGMOD Conference, pages 26-37, 1997.
• S. Chawathe, A. Rajaraman, H. Garcia-Molina, and J. Widom. Change Detection in Hierarchically Structured Information. Proceedings of the ACM SIGMOD International Conference on Management of Data, pages 493-504, Montreal, Canada, June 1996.
• C3 Project Group. The C3 Project at Stanford.

Schema Extraction and Translation:

• S. Nestorov et al. "Extracting Schema from Semistructured Data." In Proceedings of 1998 ACM International Conference On Management of Data (SIGMOD'98), Seattle, Washington, June 1998.
• Y. Papakonstantinou, A. Gupta, H. Garcia-Molina, J. Ullman. "A Query Translation Scheme for Rapid Implementation of Wrappers". In International Conference on Deductive and Object-Oriented Databases, 1995.
• M. Tork-Roth, P. Schwarz. "Don't Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources." VLDB 1997, 266-275.
• J. Hammer, M. Breunig, H. Garcia-Molina, S. Nestorov, V. Vassalos, R. Yerneni. "Template-Based Wrappers in the TSIMMIS System". In Proceedings of the Twenty-Sixth SIGMOD International Conference on Management of Data, Tucson, Arizona, May 12-15, 1997.

Misc:

• R. Kimball. Mastering Data Extraction." In DBMS Magazine, June 1996. (Provides an overview of the process of extracting, cleaning, and loading data)
• K. Hammer. "Migrating Data from Legacy Systems: Challenges and Solutions." Evolutionary Technologies International.
• M. Sweiger. "Building High Data Quality into your Data Warehouse." Sequent Computer Systems.
• G. Zagelow. "Data Warehousing-Client/Server for the Rest of the Decade." IBM.

• W. Kent, The Many Forms of a Single Fact, in Proceedings of the Proceedings of the IEEE Spring Compcon, February 1989.
• A. Sheth and J. A. Larson, "Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases," ACM Computing Surveys, 22:3, pp. 183-236, 1990.
• Gio Wiederhold, "Value-added Middleware: Mediators." To appear in Database Programming & Design. 1999.

Multi-Source Data Management:

• S. Madnick. "Integrating Information from Global Systems: Challenges of Effectively Exploiting the Information SuperHighway," In Journal of Organizational Computing.
• E. Sciore, M. Siegel, and A. Rosenthal, "Using Semantic Values to Facilitate Interoperability Among Heterogeneous Information Systems," ACM Transactions on Database Systems, 19:2, pp. 254-290, 1994.
• A. Daruwala, C. H. Goh, S. Hofmeister, K. Hussein, S. Madnick and M. Siegel. "The Context Interchange Network." In Proceedings of the IFIP WG2.6 Sixth Working Conference on Database Semantics (DS-6), Atlanta, Georgia, May 30 to June 2, 1995.
• J. Widom. Data Management for XML - Research Directions. Working Document, April 1999.
• A. Levy. More on Data Management for XML. Working Document, May 1999.

Integration Systems:

• O. Duschka and M. Genesereth. Infomaster - An Information Integration Tool. In Proceedings of the International Workshop "Intelligent Information Integration" during the 21st German Annual Conference on Artificial Intelligence, KI-97. Freiburg, Germany, September 1997.
• Y. Papakonstantinou, H. Garcia-Molina, J. Ullman. "Medmaker: A Mediation System Based on Declarative Specifications". In International Conference on Data Engineering, pages 132 - 141, New Orleans, February, 1996.
• G. Zhou et al. "Data Integration and Warehousing Using H20." Technical report. University of Colorado, Boulder. 1995.

• J. Bakeley et al. "Efficiently updating materialized views." In SIGMOD, pages 61-71, June 1986.
• A. Gupta et al. "Maintaining views incrementally." In SIGMOD, pages 157-166, May 1993.
• Y. Zhuge, H. Garcia-Molina, J. Hammer, and J. Widom, "View Maintenance in a Warehousing Environment." In Proceedings of the ACM SIGMOD Conference, San Jose, California, May 1995.
• A. Gupta, I.S. Mumick. "Maintenance of Materialized Views: Problems, Techniques, and Applications." In IEEE Data Engineering Bulletin, Vol. 18, Number 2, pages 3-18, June 1995. [[good overview paper]]
• N. Roussopoulos et al. "The Maryland ADMS Project: Views R Us." In IEEE Data Engineering Bulletin, Vol. 18, Number 2, pages 19-28, June 1995.
• L. Colby et al. "Algorithms for defered view maintenance." In SIGMOD, pages 469-480, June 1996.
• D. Quass, A. Gupta, I. S. Mumick, and J. Widom "Making Views Self-Maintainable for Data Warehousing." In Proceedings of the Conference on Parallel and Distributed Information Systems , Miami Beach, FL, December 1996.
• Y. Zhuge, H. Garcia-Molina, and J. L. Wiener "The Strobe Algorithms for Multi-Source Warehouse Consistency." Proceedings of the Conference on Parallel and Distributed Information Systems , Miami Beach, FL, December 1996.
• Y. Zhuge, J. L. Wiener and H. Garcia-Molina, "Multiple View Consistency for Data Warehousing." In Proceedings of the International Conference on Data Engineering, Birmingham, UK, April, 1997.
• D. Quass and J. Widom. "On-Line Warehouse View Maintenance for Batch Updates." In Proceedings of the ACM SIGMOD Conference, Tuscon, Arizona, May, 1997.
• N. Roussopoulos. "Materialized Views and Data Warehouses." In Proceedings of the 4th Workshop KRDB-97, Athens, Greece, August 1997. (position paper)
• D. Agrawal, A. El Abbadi, A.K. Singh, T. Yurek. "Efficient View Maintenance at Data Warehouses." In SIGMOD Conference , pages 417-427, 1997.
• E. Baralis, S. Paraboschi, E. Teniente. "Materialized Views Selection in a Multidimensional Database." VLDB 1997, 156-165. Extended Abstract.
• J. Yang, K. Karlapalem, Q. Li. "Algorithms for Materialized View Design in Data Warehousing Environment." VLDB 1997: 136-145. Extended Abstract.

• Redbrick. "Star Schema Processing for Complex Queries." Red Brick Systems, Inc. Los Gatos, CA White paper, 1996.
• Redbrick. Decision-Makers, Business Data and RISQL, Informix, Los Gatos, CA, White Paper 1997.
• Informix. "Informix Decision Support Indexing for the Enterprise Data Warehousechema Processing for Complex Queries." Informix, Inc., Menlo Park, CA, White paper, 1996.
• Chatziantoniou, D., Ross, K. "Querying Multiple Features in Relational Databases." In Proceedings of VLDB, 1996.
• P. O'Neil, D. Quass. "Improved Query Performance with Variant Indexes." In Proceedings of SIGMOD International Conference on Management of Data, pages 38-49, Tucson, AZ, May 1997.
• Y. Cui, J. Widom and J. L. Wiener. "Tracing the Lineage of View Data in a Data Warehousing Environment." Technical note, 1997.

• E.F. Codd, S.B. Codd, and C.T. Salley. "Providing OLAP (on-line analytical processing) to user analysts: An IT mandate." Arbor Software now Hyperion Solutions Corp., White Paper, 1993.
• "Multidimensional Database Technology." Kenan Technologies. White paper, 1997.
• OLAP Council. What is OLAP?" OLAP Council, White Paper, 1997.
• R. Kimball, K. Strehlo. "Why decision support fails and how to fix it," reprinted in SIGMOD Record, 24(3), 1995.
• J. Gray, A. Bosworth, A. Layman, H. Pirahesh. "Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Total." ICDE 1996, 152-159. (There is also a nice PowerPoint presentation by the authors to go with the article.)
• V. Harinarayan, A. Rajaraman, J. Ullman. "Implementing Data Cubes Efficiently." Proceedings of ACM Sigmod Conference, Montreal, Canada, June 1996.
• S. Sarawagi, Indexing OLAP Data. In Bulletin of the Technical Comittee on Data Engineering, 20:1, pp. 36-44, 1997.
• C. Faloutsos, H.V. Jagadish, N. Sidiropoulos. "Recovering Information from Summary Data." In Proceedings of the Twenty-third International Conference of Very large Databases, Athens, Greece, August 1997, pages 36-45. Extended Abstract.

• S. Guha, R. Rastogi, and K. Shim, CURE: An Eficient Clustering Algorithm for Large Databases, in Proceedings of the ACM SIGMOD International Conference on Management of Data, Seattle, WA, pp. 73-84.
• R.T. Ng and J. Han, Efficient and Effective Clustering Methods for Spatial Data Mining, in Proceedings of the Twentieth International Conference on Very Large Databases, pp. 144-155, September 1994.
• J. Shafer, R. Agrawal, and M. Mehta, SPRINT: A Scalable Parallel Classifier for Data Mining, in Proceedings of the Twenty-Second International Conference on Very Large Databases, pp. 544-555, September 1996.
• H. Toivonen, Sampling Large Databases for Association Rules, in Proceedings of the Twenty-Second International Conference on Very Large Databases, pp. 134-145, September 1996.
• T. Zhang, R. Ramakrishnan, and M. Livny, BIRCH: An efficient data clustering method for very large databases, SIGMOD Record (ACM Special Interest Group on Management of Data), 25:2, pp. 103--114, 1996.
• H. Edelstein. Mining Data Warehouses." In Information Week, January 8, 1996. (Provides an overview of issues associated with data mining.)
• M.-S. Chen et al. Data Mining: An Overview from a database Perspective. In IEEE Transactions on Knowledge and Data Engineering, Vol. 8, No. 6, pages 866-883.
• U.M. Fayyad et al., Advances in Knowledge Discovery and Data Mining, AAAI/MIT Press, Menlo Park, CA, 1996.

• W. J. Labio, Y. Zhuge, J. L. Wiener, H. Gupta, H. Garcia-Molina, J. Widom. "The WHIPS Prototype for Data Warehouse Creation and Maintenance." In Proceedings of the ACM SIGMOD Conference, Tuscon, Arizona, May, 1997. Short overview.
• J. L. Wiener, H. Gupta, W. J. Labio, Y. Zhuge, H. Garcia-Molina, J. Widom. "A System Prototype for Warehouse View Maintenance." In Proceedings of the ACM Workshop on Materialized Views: Techniques and Applications, Montreal, Canada, June 7, 1996, pp. 26-33.

• Arbor Software
• Extract Toolsuite for extracting and cleansing data from Evolutionary Technologies International.
• Overview of IBM's Data Management Solutions
• Data Management White Papers (including data warehousing and data mining) from IBM
• Oracle
• Informix Data Warehousing Products (a.k.a. Redbrick)
• Data Warehousing White Papers from Informix/Redbrick
• MicroStrategy
• Microsoft Data Warehousing
• Overview of Microsoft's SQL Server
• Microsoft OLE DB for OLAP
• Information Advantage
• Pilot Software
• Business Objects
• Comshare
• OLAP Council
• SGI's new flagship data mining product called MineSet