Abstract
A data warehouse can be seen as a set of materialized views defined over remote base relation. When the query is posed, it is evaluated locally using the materialized view without accessing the original database. The paper proposes clustering based dynamic materialized view selection algorithm. The base of the paper is to propose similarity function, clustering materialized view and then dynamically adjusting the materialized view.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Aouiche, K., Emmanuel Jouve, P., Darmont, J.: Clustering-Based Materialized View Selection in Data Warehouses. Technical Report, University of Lyon 2 (2007)
Mahboubi, H., Aouiche, K., Darmont, J.: Materialized View Selection by Query Clustering in XML Data Warehouses. In: Fourth International Conference on Computer Science and Information Technology, Jordan
Gupta, H., Mummick, I.S.: Selection of Views to Materialize in a Data Warehouse. IEEE Transaction on Knowledge and Data Engineering 17, 24–43 (2005)
Ashadevi, B., Balasubramaniam, R.: Optimized Cost effective Approach for Materialized View Selection in Data Warehousing. CST&V 9(1), 21–26 (2009)
Dhote, C.A., Ali, M.S.: Materialized View Selection Algorithm in Data Warehouse. In: International Conference on Information Technology (ITNG 2007) (2007)
Gong, A., Zhao, W.: Clustering-based Dynamic Materialized View Selection Algorithm. In: Proceedings of Fifth International Conference on Fuzzy Systems and Knowledge Discovery, China, pp. 391–395 (2008)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Chaudhari, M.S., Dhote, C. (2012). Dynamic Materialized View Selection Algorithm: A Clustering Approach. In: Kannan, R., Andres, F. (eds) Data Engineering and Management. ICDEM 2010. Lecture Notes in Computer Science, vol 6411. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-27872-3_9
Download citation
DOI: https://doi.org/10.1007/978-3-642-27872-3_9
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-27871-6
Online ISBN: 978-3-642-27872-3
eBook Packages: Computer ScienceComputer Science (R0)