A Review Paper on Different Approaches for Query Optimization using Schema Object base View
|
10.5120/19966-1812 |
Dhaval Patel and Pratik Patel. Article: A Review Paper on Different Approaches for Query Optimization using Schema Object base View. International Journal of Computer Applications 114(4):16-18, March 2015. Full text available. BibTeX
@article{key:article,
author = {Dhaval Patel and Pratik Patel},
title = {Article: A Review Paper on Different Approaches for Query Optimization using Schema Object base View},
journal = {International Journal of Computer Applications},
year = {2015},
volume = {114},
number = {4},
pages = {16-18},
month = {March},
note = {Full text available}
}
Abstract
Mining of Data is the extraction of hidden prognosticative information from large databases or set of data, is a strong new technology with great prospective to help companies focus on the most important information in their data warehouses. Query optimization is a purpose of many relational database management systems. The query optimizer experiments to dictate the most efficient way to implement a given query by examining the possible query plans. In this paper, the different techniques is given for optimizing query using schema based and materialized views in data warehouse namely- view adaptation & synchronization, view selection and view maintenance.
References
- Amol Deshpande, Lisa Hellerstein "Flow Algorithms for Parallel Query Optimization" IEEE 2008.
- Joshi Janki, "An Analysis on Query Optimization in Distributed Database" International Journal of Modern Trends in Engineering and Research 2014.
- T. Nalini, Dr. A. Kumaravel, Dr. K. Rangarajan "A comparative study analysis of materialized view for selection cost" International Journal of Computer Science & Engineering Survey (IJCSES) Vol. 3, No. 1, February 2012.
- A. Lee, A. Nica, and E. Rundensteiner, "The EVE approach view synchronization in dynamic distributed environments", In IEEE Transactions and Data Engineering, 14, 2002.
- Garima Thakur, Anjana Gosain " A Comprehensive Analysis of Materialized Views in a Data Warehouse Environment" (IJACSA) International Journal of Advanced Computer Science and Applications, Vol. 2, No. 5, 2011
- Deepika Kirti, Jaspreeti Singh "Assortment of Materialized View: A Comparative Survey in Data Warehouse Environment"International Journal of Computer Applications (0975 – 8887) Volume 96– No. 7, June 2014
- Ravindra N. Jogekar, Ashish Mohod "Design and Implementation of Algorithmsfor Materialized View Selection and Maintenance in Data Warehousing Environment" International Journal of Emerging Technology and Advanced Engineering Volume 3, Issue 9, September 2013
- S. Chen, X. Zhang, and E. Rundensteiner, "A compensation based approach for view maintenance in distributed environments", In IEEE transactions and data engineering, 18, 2006.
- Madhu Bhan, T. V. Suresh Kumar, K. Rajanikanth "Materialized view size estimation using sampling" IEEE International Conference on Computational Intelligence and Computing Research 2013 IEEE