The week's pick
Random Articles
Reseach Article
An Association Rule Mining for Materialized View Selection and View Maintanance
| International Journal of Computer Applications |
| Foundation of Computer Science (FCS), NY, USA |
| Volume 109 - Number 5 |
| Year of Publication: 2015 |
| Authors: P.r.vishwanath, Rajyalakshmi, Sridhar Reddy |
10.5120/19184-0670
|
P.r.vishwanath, Rajyalakshmi, Sridhar Reddy . An Association Rule Mining for Materialized View Selection and View Maintanance. International Journal of Computer Applications. 109, 5 ( January 2015), 15-20. DOI=10.5120/19184-0670
Abstract
Data warehouse (DW) is a repository with query interface in support of Decision support systems. DW required answering many complex queries, managerial level queries and analytical queries, needing to develop advanced computing techniques. The DW system process involving data modeling, ETL process, query interface and reporting system. Materialized views (MV) are the pre calculated views which are used to increase the DW system performance. MV selection and maintenance need to adopt new trends and techniques. Data mining (DM) is the process of extracting hidden useful information from huge data bases . Literature of Data Mining (DM) involving algorithms and techniques related to association, classification and clustering. Recent researches shown Data mining can also be used in optimization of calculating MV's. In addition to DM techniques are also used in efficient calculation of Data cubes. This paper proposed frequent rule mining on of the Data mining approach for the selection and maintenance of MV'S. By using the advanced concepts of frequent mining algorithm the query response time can be decreased. The approach also combines the advanced techniques to accommodate the changes in updating the base data so as to increase the performance of existing MV'S selection and maintenance approaches.
References
- W. Inmon, "Building the data warehouse", Wiley publications, pp 23, 1991.
- Jiawei Han and MichelineKamber , "Data Mining Concepts and Techniques, 2nded. Morgan Kaufmann Publishers, March 2006. ISBN 1-55860-901-6
- Nalini, T, Kumaravel, A and Rangarajan, K ,"A Novel Algorithm With Im-Lsi Index For Incremental Maintenance Of Materialized Views". Proceedings of JCS&T Vol. 12 No. 1, April 2012SOURCE
- An Gong, Weijing Zhao, "Clustering-based Dynamic Materialized View Selection Algorithm" Proceedings of Fifth International Conference on Fuzzy Systems and Knowledge Discovery, 2008, China,pp391-395
- K. Aouiche, P. EmmanuelJouve, and J. Darmont ,"Clustering-Based Materialized View Selection in Data Warehouses"TechnicalReport, University of Lyon 2, 2007.
- T. Nalini,Dr. A. Kumaravel, Dr. K. Rangarajan ," An Efficient I-Mine Algorithm For Materialized Views In A Data Warehouse Environment", Ijcsi International Journal Of Computer ScienceIssues, Vol. 8, Issue 5, No 1, September 2011 Issn (Online):1694-0814
- D. Xin, J. Han, X. Li, and B. W. Wah. Star-cubing: Computing iceberg cubes by top-downand bottom-up integration. In Proc. 2003 Int. Conf. Very Large Data Bases (VLDB'03),Berlin, Germany, pages 476–487, Sept. 2003.
- T. V. Vijaykumar and KalyaniDevi,"Frequent queries identification for constructing materialized views",Journal of Computer Science & Technology (JCS&T);2012, Vol. 12 Issue 1s, p32.
- Yogeshree D. Choudhari,Dr. S. K. Shrivastava "Cluster Based Approach for Selection of Materialized Views " proceedings of International Journal of Advanced Research in Computer Science and Software Engineering (IJARCSSE)july2012
- P. R. Vishwanath Dr. D. Rajyalakshmi Dr. Sreedhar reddy "A Comparative Study of Data Mining Techniques in Maintenance of Data ", IJSER Volume 4, Issue 11, November 2013 Edition.
Index Terms
Keywords