Selection and Maintenance of Materialized View using Genetic Algorithm
Ramesh S Gawali, Prof. Mrunali G. Vaidya, , ,
Affiliations BIT Ballarpur Gondwana University ,India
Data warehouse is a repository of large amount of data collected from multiple heterogeneous and distributed data sources. Quick response time and accuracy are the key points for success of any database. Performance of query can be improved by different approaches like query optimization, use of proper data structure etc. But leaving all these alternatives we are planning to use materialized view approach
Ramesh S Gawali, ,Prof. Mrunali G. Vaidya," Selection and Maintenance of Materialized View using Genetic Algorithmâ€, International Journal Of Computer Engineering In Research Trends, 3(12):629-631,December-2016.
Keywords : data ware house, materialized view, optimization Query.
Dr.T.Nalini, Dr.A.Kumaravel , Dr.K.Rangarajan,â€A Novel Algorithm with IM-LSI Index For Incremental Maintenance of Materialized Viewâ€ JCS&T Vol. 12 No. 1 April 2012
 B.Ashadevi, R.Balasubramanian,â€ Cost Effective Approach for Materialized Views Selection in Data Warehousing Environmentâ€, IJCSNS International Journal of Computer Science and Network Security, VOL.8 No.10, October 2008
 Gupta, H. & Mumick, I., Selection of Views to Ma-terialize in a Data Warehouse. IEEE Transactions on Knowledge and Data Engineering, 17(1), 24-43, 2005.
 Yang, J., Karlapalem. K., and Li. Q. (1997). A framework for designing materialized views in a data warehousing environment. Proceedings of the Seven-tieth IEEE International Conference on Distributed Computing systems, USA, pp:458
 V.Harinarayan, A. Rajaraman, and J. Ullman.â€œImplementing data cubes efficientlyâ€. Pro-ceedings of ACM SIGMOD 1996 International Confer-ence on Management of Data, Montreal, Canada, pages 205--216, 1996.
 A. Shukla, P. Deshpande, and J. F. Naughton, â€œMa-terialized view selection for the multidimensional da-tasets,â€ in Proc. 24th Int. Conf. Very Large Data Bases, 1998, pp. 488â€“499.
 Y.D. Choudhari and Dr. S. K. Shrivastava, â€œCluster Based Approach for Selection of Materialized Viewsâ€, International Journal of Advanced Research in Com-puter Science and Software Engineering ,Volume 2, Issue 7, July 2012
Authors are not required to pay any article-processing charges (APC) for their article to be published open access in Journal IJCERT. No charge is involved in any stage of the publication process, from administrating peer review to copy editing and hosting the final article on dedicated servers. This is free for all authors.
News & Events
Latest issue :Volume 10 Issue 1 Articles In press
☞ INVITING SUBMISSIONS FOR THE NEXT ISSUE :
☞ LAST DATE OF SUBMISSION : 31st March 2023
☞ SUBMISSION TO FIRST DECISION : In 7 Days
☞ FINAL DECISION : IN 3 WEEKS FROM THE DAY OF SUBMISSION
All the authors, conference coordinators, conveners, and guest editors kindly check their articles' originality before submitting them to IJCERT. If any material is found to be duplicate submission or sent to other journals when the content is in the process with IJCERT, fabricated data, cut and paste (plagiarized), at any stage of processing of material, IJCERT is bound to take the following actions.
1. Rejection of the article.
2. The author will be blocked for future communication with IJCERT if duplicate articles are submitted.
3. A letter regarding this will be posted to the Principal/Director of the Institution where the study was conducted.
4. A List of blacklisted authors will be shared among the Chief Editors of other prestigious Journals
We have been screening articles for plagiarism with a world-renowned tool: Turnitin However, it is only rejected if found plagiarized. This more stern action is being taken because of the illegal behavior of a handful of authors who have been involved in ethical misconduct. The Screening and making a decision on such articles costs colossal time and resources for the journal. It directly delays the process of genuine materials.