Skip to main content

Deterministic View Selection for Data-Analysis Queries: Properties and Algorithms

  • Conference paper

Part of the Lecture Notes in Computer Science book series (LNISA,volume 7503)

Abstract

The view-selection problem is a combinatorial optimization problem that arises in the context of on-line analytical processing (OLAP) in database management systems. We pose the problem as an integer programming (IP) model, study its structural properties, and propose effective techniques for reducing the search space of views and thus the size of the corresponding IP model. We then use these results to design both exact methods and heuristic algorithms that are effective for solving relatively large realistic-size instances of the problem.

Keywords

  • Execution Time
  • Search Space
  • Integer Program
  • Query Processing
  • Evaluation Cost

These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

This is a preview of subscription content, access via your institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (Canada)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (Canada)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (Canada)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Agrawal, S., Bruno, N., Chaudhuri, S., Narasayya, V.R.: AutoAdmin: Self-tuning database systems technology. IEEE Data Eng. Bull. 29(3), 7–15 (2006)

    Google Scholar 

  2. Agrawal, S., Chaudhuri, S., Narasayya, V.R.: Automated selection of materialized views and indexes in SQL databases. In: VLDB, pp. 496–505 (2000)

    Google Scholar 

  3. Asgharzadeh, Z.T.: Exact and inexact methods for solving the view and index selection problem for OLAP performance improvement. Ph.d. dissertation. North Carolina State University, USA (2010)

    Google Scholar 

  4. Asgharzadeh, Z.T., Chirkova, R., Fathi, Y.: Exact and inexact methods for solving the problem of view selection for aggregate queries. International Journal of Business Intelligence and Data Mining 4(3/4), 391–415 (2009)

    CrossRef  Google Scholar 

  5. Asgharzadeh, Z.T., Chirkova, R., Fathi, Y., Stallmann, M.: Exact and inexact methods for selecting views and indexes for OLAP performance improvement. In: EDBT, pp. 311–322 (2008)

    Google Scholar 

  6. Bruno, N., Chaudhuri, S.: Interactive physical design tuning. In: ICDE, pp. 1161–1164 (2010)

    Google Scholar 

  7. Chaudhuri, S., Dayal, U.: An overview of data warehousing and OLAP technology. SIGMOD Record 26(1), 65–74 (1997)

    CrossRef  Google Scholar 

  8. Chaudhuri, S., Dayal, U., Narasayya, V.R.: An overview of business intelligence technology. Commun. ACM 54(8), 88–98 (2011)

    CrossRef  Google Scholar 

  9. Chaudhuri, S., Narasayya, V.R., Weikum, G.: Database tuning using combinatorial search. In: Encyclopedia of Database Systems, pp. 738–741. Springer (2009)

    Google Scholar 

  10. de Souza, M.F., Sampaio, M.C.: Efficient materialization and use of views in data warehouses. SIGMOD Record 28(1), 78–83 (1999)

    CrossRef  Google Scholar 

  11. Gupta, H., Harinarayan, V., Rajaraman, A., Ullman, J.D.: Index selection for OLAP. In: ICDE, pp. 208–219 (1997)

    Google Scholar 

  12. Gupta, H., Mumick, I.S.: Selection of views to materialize in a data warehouse. IEEE Trans. Knowl. Data Eng. 17(1), 24–43 (2005)

    CrossRef  Google Scholar 

  13. Halevy, A.: Answering queries using views: A survey. VLDB J. 10, 270–294 (2001)

    CrossRef  MATH  Google Scholar 

  14. Harinarayan, V., Rajaraman, A., Ullman, J.D.: Implementing data cubes efficiently. In: The ACM SIGMOD Conference, pp. 205–216 (1996)

    Google Scholar 

  15. Huang, R., Chirkova, R., Fathi, Y.: Deterministic view selection for data-analysis queries: Properties and algorithms. Technical Report TR-2012-2, NCSU (2012), http://www.csc.ncsu.edu/research/tech/index.php

  16. ILOG. CPLEX 11.0 software (2007), http://www.ilog.com/products/cplex/

  17. Kalnis, P., Mamoulis, N., Papadias, D.: View selection using randomized search. Data Knowl. Eng. 42(1), 89–111 (2002)

    CrossRef  MATH  Google Scholar 

  18. Karloff, H.J., Mihail, M.: On the complexity of the view-selection problem. In: PODS, pp. 167–173 (1999)

    Google Scholar 

  19. Kimball, R., Ross, M.: The Data Warehouse Toolkit, 2nd edn. Wiley Computer Publishing (2002)

    Google Scholar 

  20. Kotidis, Y., Roussopoulos, N.: A case for dynamic view management. ACM TODS 26(4), 388–423 (2001)

    CrossRef  MATH  Google Scholar 

  21. Lawrence, M., Rau-Chaplin, A.: Dynamic view selection for olap. IJDWM 4(1), 47–61 (2008)

    Google Scholar 

  22. Lightstone, S.: Physical database design for relational databases. In: Encyclopedia of Database Systems, pp. 2108–2114. Springer (2009)

    Google Scholar 

  23. Papadomanolakis, S., Ailamaki, A.: An integer linear programming approach to database design. In: ICDE Workshops, pp. 442–449 (2007)

    Google Scholar 

  24. Shukla, A., Deshpande, P., Naughton, J.F.: Materialized view selection for multidimensional datasets. In: VLDB, pp. 488–499 (1998)

    Google Scholar 

  25. Theodoratos, D., Bouzeghoub, M.: A general framework for the view selection problem for data warehouse design and evolution. In: DOLAP, pp. 1–8 (2000)

    Google Scholar 

  26. Theodoratos, D., Xu, W.: Constructing search spaces for materialized view selection. In: DOLAP, pp. 112–121 (2004)

    Google Scholar 

  27. TPC-H Revision 2.1.0. TPC Benchmark H (Decision Support), http://www.tpc.org/tpch/spec/tpch2.1.0.pdf

  28. Yang, J., Karlapalem, K., Li, Q.: Algorithms for materialized view design in data warehousing environment. In: VLDB, pp. 136–145 (1997)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and Permissions

Copyright information

© 2012 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Huang, R., Chirkova, R., Fathi, Y. (2012). Deterministic View Selection for Data-Analysis Queries: Properties and Algorithms. In: Morzy, T., Härder, T., Wrembel, R. (eds) Advances in Databases and Information Systems. ADBIS 2012. Lecture Notes in Computer Science, vol 7503. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-33074-2_15

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-33074-2_15

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-33073-5

  • Online ISBN: 978-3-642-33074-2

  • eBook Packages: Computer ScienceComputer Science (R0)