Selection of Views to Materialize Under a Maintenance Cost Constraint

  • Himanshu Gupta
  • Inderpal Singh Mumick
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1540)

Abstract

A data warehouse stores materialized views derived from one or more sources for the purpose of efficiently implementing decision-support or OLAP queries. One of the most important decisions in designing a data warehouse is the selection of materialized views to be maintained at the warehouse. The goal is to select an appropriate set of views that minimizes total query response time and/or the cost of maintaining the selected views, given a limited amount of resource such as materialization time, storage space, or total view maintenance time. In this article, we develop algorithms to select a set of views to materialize in a data warehouse in order to minimize the total query response time under the constraint of a given total view maintenance time. As the above maintenance-cost view-selection problem is extremely intractable, we tackle some special cases and design approximation algorithms. First, we design an approximation greedy algorithm for the maintenance-cost view-selection problem in OR view graphs, which arise in many practical applications, e.g., data cubes. We prove that the query benefit of the solution delivered by the proposed greedy heuristic is within 63% of that of the optimal solution. Second, we also design an A* heuristic, that delivers an optimal solution, for the general case of AND-OR view graphs. We implemented our algorithms and a performance study of the algorithms shows that the proposed greedy algorithm for OR view graphs almost always delivers an optimal solution.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. BPT97.
    E. Baralis, S. Paraboschi, and E. Teniente. Materialized view selection in a multidimensional database. In Proc. of the VLDB, 1997.Google Scholar
  2. CW91.
    S. Ceri and J. Widom. Deriving production rules for incremental view maintenance. In Proc. of the VLDB, 1991.Google Scholar
  3. GHRU97.
    H. Gupta, V. Harinarayan, A. Rajaraman, and J. Ullman. Index selection in OLAP. In Proc. of the Intl. Conf. on Data Engineering, 1997.Google Scholar
  4. GM95.
    A. Gupta and I.S. Mumick. Maintenance of materialized views: Problems, techniques, and applications. IEEE Data Eng. Bulletin, Special Issue on Materialized Views and Data Warehousing, 18(2), 1995.Google Scholar
  5. Gup97.
    H. Gupta. Selection of views to materialize in a data warehouse. In Proceedings of the Intl. Conf. on Database Theory, Delphi, Greece, 1997.Google Scholar
  6. HGMW+95._J. Hammer, H. Garcia-Molina, J. Widom, W. Labio, and Y. Zhuge. The Stanford Data Warehousing Project. IEEE Data Eng. Bulletin, Special Issue on Materialized Views and Data Warehousing, 1995.Google Scholar
  7. HRU96.
    V. Harinarayan, A. Rajaraman, and J. Ullman. Implementing data cubes efficiently. In Proceedings of the ACM SIGMOD, June 1996.Google Scholar
  8. IK93.
    W.H. Inmon and C. Kelley. Rdb/VMS: Developing the Data Warehouse. QED Publishing Group, Boston, Massachussetts, 1993.Google Scholar
  9. MQM97.
    I. Mumick, D. Quass, and B. Mumick. Maintenance of data cubes and summary tables in a warehouse. In Proceedings of the ACM SIGMOD International Conference of Management of Data, 1997.Google Scholar
  10. Nil80.
    Nils J. Nilsson. Principles of Artificial Intelligence. Morgan Kaufmann Publishers, Inc., 1980.Google Scholar
  11. Rou82.
    N. Roussopoulos. View indexing in relational databases. ACM Transactions on Database Systems, 7(2):258–290, June 1982.MATHCrossRefGoogle Scholar
  12. RSS96.
    K. A. Ross, Divesh Srivastava, and S. Sudarshan. Materialized view maintenance and integrity constraint checking: Trading space for time. In Proceedings of the ACM SIGMOD, 1996.Google Scholar
  13. TS97.
    D. Theodoratos and T. Sellis. Data warehouse configuration. In Proceedings of the 23rd Intl. Conf. on Very Large Data Bases, 1997.Google Scholar
  14. WGL+96._J. Wiener, H. Gupta, W. Labio, Y. Zhuge, H. Garcia-Molina, and J. Widom. A system prototype for warehouse view maintenance. In Workshop on Materialized Views: Techniques and Applications, 1996.Google Scholar
  15. Wid95.
    J. Widom. Research problems in data warehousing. In Proc. of the Intl. Conf. on Information and Knowledge Management, 1995.Google Scholar
  16. YKL97.
    J. Yang, K. Karlapalem, and Q. Li. Algorithms for materialized view design in data warehousing environment. In Proc. of the VLDB, 1997.Google Scholar
  17. ZGMHW95.
    Y. Zhuge, H. Garcia-Molina, J. Hammer, and J. Widom. View maintenance in a warehousing environment. In Proc. of the ACM SIGMOD International Conference on Management of Data, 1995.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1999

Authors and Affiliations

  • Himanshu Gupta
    • 1
  • Inderpal Singh Mumick
    • 2
  1. 1.Stanford UniversityStanfordUSA
  2. 2.Savera Systems, SummitNJUSA

Personalised recommendations