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
IJCERT is peer-reviewed scientific Research journal to endorse conservation. We have not put up a paywall to readers, But running a monthly journal costs is a lot. IJCERT has been changed the publication policy from Free publication to pay because of increasing the maintenance cost and other editorial charges. The understanding and cooperation of the author are highly solicited.we still need support to keep the journal flourishing. If our readers help fund it, our future will be more secure.