Skip to main content
SpringerLink
Log in

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

  • Conference paper
Advances in Databases and Information Systems (ADBIS 2012)

Part of the book series: Lecture Notes in Computer Science ((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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • 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

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)

    Article  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)

    Article  Google Scholar 

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

    Article  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)

    Article  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)

    Article  Google Scholar 

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

    Article  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)

    Article  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)

    Article  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

  1. Operations Research Program, NC State University, Raleigh, NC, 27695, USA

    Rong Huang & Yahya Fathi

  2. Computer Science Department, NC State University, Raleigh, NC, 27695, USA

    Rada Chirkova

Authors
  1. Rong Huang
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Rada Chirkova
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Yahya Fathi
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Institute of Computing Science, Poznań University of Technology, Piotrowo 2, 60-965, Poznań, Poland

    Tadeusz Morzy

  2. Department of Computer Science, AG DBIS, University of Kaiserslautern, Germany, P.O. Box 3049, 67653, Kaiserslautern, Germany

    Theo Härder

  3. Institute of Computing Science, Poznan University of Technology, Piotrowo 2, 60-965, Poznan, Poland

    Robert Wrembel

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)

Publish with us

Policies and ethics

Search

Navigation