Back to Current Issues

Selection and Maintenance of Materialized View using Genetic Algorithm

Ramesh S Gawali, Prof. Mrunali G. Vaidya,

Affiliations
BIT Ballarpur Gondwana University ,India
:10.22362/ijcert/2016/v3/i12/xxxx


Abstract
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


Citation
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.

References
 [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 :
  V3I1204.pdf


Refbacks : There are currently no refbacks

Quick Links


DOI:10.22362/ijcert


Science Central

Score: 13.30



Submit your paper to editorijcert@gmail.com

>