Skip to main content
SpringerLink
Log in

A Review on Dynamic View Selection

  • Conference paper
  • First Online:
Proceedings of International Conference on ICT for Sustainable Development

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 409))

Abstract

Dynamic view selection approach selects materialized view set on runtime and takes into account the changing nature of users’ interests and query patterns. This paper provides a review of 24 studies based on this approach and categorizes results on parameters such as constraints, algorithms, and experiment platforms etc.

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 169.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 219.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

References

  1. Widom. J. (1995). Research problems in data warehousing. In CIKM, pp. 25–30.

    Google Scholar 

  2. Gupta, H., & Mumick, I. (2005). Selection of views to materialize in a data warehouse. IEEE Transactions on Knowledge and Data Engineering, 17(1), 24–43.

    Article  Google Scholar 

  3. Ashadevi, B., Navaneetham, P., & Balasubramanian, R. (2010). A framework for the view selection problem in data warehousing environment. International Journal on Computer Science and Engineering, 02(09), 2820–2826.

    Google Scholar 

  4. Choi, C.-H., Xu Yu, J., & Lu. H. (2003). Dynamic materialized view management based on predicates. In Web Technologies and Applications. Springer Berlin Heidelberg, pp. 583–594.

    Google Scholar 

  5. Wang, C., & Bo. X. (2011). Dynamic modulating strategy of materialized views in data warehouse. In 3rd International Conference on Data Mining and Intelligent Information Technology Applications (ICMiA), 2011 IEEE.

    Google Scholar 

  6. Chaudhari, M. S., & Dhote. C. (2012). Dynamic materialized view selection algorithm: a clustering approach. In Data Engineering and Management. Springer Berlin Heidelberg. pp. 57–66.

    Google Scholar 

  7. Mami, I., & Bellahsene, Z. (2012). A survey of view selection methods. SIGMOD Record, 41(1), 20–29.

    Article  Google Scholar 

  8. Ashadevi, B. (2011). Analysis of view selection problem in data warehousing environment. International Journal of Engineering and Technology, 3(6), 447–457.

    Google Scholar 

  9. Gosain, A., & Alka. (2013). A comparative study of materialised view selection in data warehouse environment. In 5th International Conference on Computational Intelligence and Communication Networks (CICN). IEEE.

    Google Scholar 

  10. Thakur, G., & Gosain, A. (2011) A comprehensive analysis of materialized views in a data warehouse environment. In International Journal of Advanced Computer Science and Applications (IJACSA) 2.5. (2011).

    Google Scholar 

  11. Kotidis, Y., & Roussopoulos, N. (1999). DynaMat: a dynamic view management system for data warehouses. In Proceedings of the 1999 ACM SIGMOD international conference on Management of data, pp. 371–382, Philadelphia, Pennsylvania, USA.

    Google Scholar 

  12. Bellahsène, Z., & Marot. P. (2000) Materializing a set of views: dynamic strategies and performance evaluation. In Proceedings of International Database Engineering and Applications Symposium, IEEE, Yokohoma, Japan.

    Google Scholar 

  13. Choi, C.-H., Xu Yu, J., & Lu, H. (2004). A simple but effective dynamic materialized view caching. Advances in Web-Age Information Management. Springer Berlin Heidelberg, pp. 147–156.

    Google Scholar 

  14. Luebcke, A., Geist, I., Bubke, R. (2008). Dynamic detection and administration of materialized views based on the query graph model. In Third International Conference on Digital Information Management. IEEE.

    Google Scholar 

  15. Gong, A., & Zhao, W. (2008). Clustering-based dynamic materialized view selection algorithm. In Fifth International Conference on Fuzzy Systems and Knowledge Discovery. FSKD’08. Vol. 5. IEEE.

    Google Scholar 

  16. Xu, W., Theodoratos, D., Zuzarte, C., Wu, X., & Oria, V. (2007). A dynamic view materialization scheme for sequences of query and update statements. In Data Warehousing and Knowledge Discovery (pp. 55–65). Berlin Heidelberg: Springer.

    Google Scholar 

  17. Lawrence, M., & Rau-Chaplin, A. (2006). Dynamic view selection for OLAP. In Data Warehousing and Knowledge Discovery (pp. 33–44). Berlin Heidelberg: Springer.

    Book  Google Scholar 

  18. Phan, T., & Li, W. S. (2008). Dynamic materialization of query views for data warehouse workloads. In 24th International Conference on Data Engineering, ICDE. IEEE.

    Google Scholar 

  19. Bellahsene, Z., Cart, M., & Kadi, N. (2010). A cooperative approach to view selection and placement in P2P systems. In On the Move to Meaningful Internet Systems. OTM. Springer, Berlin Heidelberg. pp. 515–522.

    Google Scholar 

  20. Yin, G., Yu, X., & Lin, L. (2007). Strategy of Selecting Materialized Views Based on Cache-updating. In IEEE International Conference on Integration Technology. ICIT’07.

    Google Scholar 

  21. Kalnis, P., Ng, W. S., Ooi, B. C., Papadias, D., & Tan, K. L. (2002). An adaptive peer-to-peer network for distributed caching of olap results. In Proceedings of the 2002 ACM SIGMOD international conference on Management of data. ACM.

    Google Scholar 

  22. Zhou, J., Larson, P. A., Goldstein, J., & Ding, L. (2007). Dynamic materialized views. In IEEE 23rd International Conference on Data Engineering, 2007. ICDE.

    Google Scholar 

  23. Theodoratos, D., & Sellis, T. (1999). Dynamic data warehouse design. In DataWarehousing and Knowledge Discovery (pp. 1–10). Berlin Heidelberg: Springer.

    Google Scholar 

  24. Daneshpour, N., & Barfourosh, A. A. (2012). Dynamic view management system for query prediction to view materialization. In Developments in Data Extraction, Management, and Analysis, p. 132.

    Google Scholar 

  25. Lijuan, Z., Xuebin, G., Linshuang, W., & Qian, S. (2009). Efficient materialized view selection dynamic improvement algorithm. In Sixth International Conference on Fuzzy Systems and Knowledge Discovery. FSKD’09 (Vol. 7.) IEEE.

    Google Scholar 

  26. Zhang, C., Yang, J., & Karlapalem, K. (2003). Dynamic materialized view selection in data warehouse environment. Informatica (Slovenia), 27(4), 451–460.

    MATH  Google Scholar 

  27. Rashid, A. B., Islam, M. S., & Hoque, A. L. (2011). Dynamic materialized view selection approach for improving query performance. In Computer Networks and Information Technologies (pp. 202–211). Berlin Heidelberg: Springer.

    Google Scholar 

  28. Zhu, C., Zhu,Q., Zuzarte, & C. (2010). Efficient processing of monotonic linear progressive queries via dynamic materialized views. In Proceedings of the 2010 Conference of the Center for Advanced Studies on Collaborative Research. IBM Corp.

    Google Scholar 

  29. Zhu, C., Zhu, Q., Zuzarte, C., & Ma, W. (2012). DMVI: a dynamic materialized view index for efficiently discovering usable views for progressive queries. CASCON.

    Google Scholar 

  30. Zhu, C., & Zuzarte, C. (2013). Developing a dynamic materialized view index for efficiently discovering usable views for progressive queries. Journal of Information Processing Systems, 9(4), 511–537.

    Article  Google Scholar 

  31. Zhu, C., Zhu, Q., & Zuzarte, C. (2014). Optimization of monotonic linear progressive queries based on dynamic materialized views. The Computer Journal, 57(5), 708–730.

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. USICT, GGSIPU, New Delhi, India

    Anjana Gosain &  Heena

Authors
  1. Anjana Gosain
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Heena
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Heena .

Editor information

Editors and Affiliations

  1. Dept of Comp. Sci. & Engg, Anil Neerukonda Inst of Tech and Science, Visakhapatnam, India

    Suresh Chandra Satapathy

  2. Sabarkantha, Sabar Institute of Technology, Sabarkantha, Gujarat, India

    Amit Joshi

  3. Narsinhbhai Inst of Comp Studies & Mgmt, Gandhinagar, Gujarat, India

    Nilesh Modi

  4. Narsinhbhai Inst of Comp Studies & Mgmt, Gandhinagar, India

    Nisarg Pathak

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer Science+Business Media Singapore

About this paper

Cite this paper

Gosain, A., Heena (2016). A Review on Dynamic View Selection. In: Satapathy, S., Joshi, A., Modi, N., Pathak, N. (eds) Proceedings of International Conference on ICT for Sustainable Development. Advances in Intelligent Systems and Computing, vol 409. Springer, Singapore. https://doi.org/10.1007/978-981-10-0135-2_5

Download citation

  • DOI: https://doi.org/10.1007/978-981-10-0135-2_5

  • Published:

  • Publisher Name: Springer, Singapore

  • Print ISBN: 978-981-10-0133-8

  • Online ISBN: 978-981-10-0135-2

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics

Search

Navigation