Impact Factor:6.549
 Scopus Suggested Journal: Tracking ID for this title suggestion is: 55EC484EE39417F0

International Journal
of Computer Engineering in Research Trends (IJCERT)

Scholarly, Peer-Reviewed, Open Access and Multidisciplinary

Welcome to IJCERT

International Journal of Computer Engineering in Research Trends. Scholarly, Peer-Reviewed,Open Access and Multidisciplinary

ISSN(Online):2349-7084                 Submit Paper    Check Paper Status    Conference Proposal

Back to Current Issues

Selection and Maintenance of Materialized View using Genetic Algorithm

Ramesh S Gawali, Prof. Mrunali G. Vaidya, , ,
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.

 [1]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 
[2] 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 
[3] 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. 
[4] 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
[5] 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. 
[6] 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. 
[7] 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 

DOI Link : Not yet assigned

Download :

Refbacks : There are currently no refbacks

Support Us

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.

Quick Links


Science Central

Score: 13.30

Submit your paper to