CFP last date
20 December 2024
Call for Paper
January Edition
IJCA solicits high quality original research papers for the upcoming January edition of the journal. The last date of research paper submission is 20 December 2024

Submit your paper
Know more
The week's pick
Responsive image
Improved Shuffled Frog Leaping Algorithm with Self-Adaptive Shuffling for Fuzzy Logic PD+G Controller Optimization in Robotic Manipulators

Duc Hoang Nguyen
Random Articles
Reseach Article

A Review Paper on Different Approaches for Query Optimization using Schema Object base View

by Dhaval Patel, Pratik Patel
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 114 - Number 4
Year of Publication: 2015
Authors: Dhaval Patel, Pratik Patel
10.5120/19966-1812

Dhaval Patel, Pratik Patel . A Review Paper on Different Approaches for Query Optimization using Schema Object base View. International Journal of Computer Applications. 114, 4 ( March 2015), 16-18. DOI=10.5120/19966-1812

@article{ 10.5120/19966-1812,
author = { Dhaval Patel, Pratik Patel },
title = { A Review Paper on Different Approaches for Query Optimization using Schema Object base View },
journal = { International Journal of Computer Applications },
issue_date = { March 2015 },
volume = { 114 },
number = { 4 },
month = { March },
year = { 2015 },
issn = { 0975-8887 },
pages = { 16-18 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume114/number4/19966-1812/ },
doi = { 10.5120/19966-1812 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T22:51:48.314574+05:30
%A Dhaval Patel
%A Pratik Patel
%T A Review Paper on Different Approaches for Query Optimization using Schema Object base View
%J International Journal of Computer Applications
%@ 0975-8887
%V 114
%N 4
%P 16-18
%D 2015
%I Foundation of Computer Science (FCS), NY, USA
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
  1. Amol Deshpande, Lisa Hellerstein "Flow Algorithms for Parallel Query Optimization" IEEE 2008.
  2. Joshi Janki, "An Analysis on Query Optimization in Distributed Database" International Journal of Modern Trends in Engineering and Research 2014.
  3. 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.
  4. A. Lee, A. Nica, and E. Rundensteiner, "The EVE approach view synchronization in dynamic distributed environments", In IEEE Transactions and Data Engineering, 14, 2002.
  5. 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
  6. 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
  7. 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
  8. 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.
  9. 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
Index Terms

Computer Science
Information Sciences

Keywords

Query optimization materialized view

Powered by PhDFocusTM