Study of Query Optimization Techniques using Different Schemas: A Review

Authors

  • Neha Agarwal
  • Manisha Raina

DOI:

https://doi.org/10.37591/joadms.v4i1.1004

Abstract

Abstract

Mining of Data is the extraction of concealed prognosticative data from vast databases or set of information, is a solid innovation with good imminent to help organizations concentrate on the most essential data in their information distribution centers. Query Optimization is a motivation behind numerous relational database management systems. The query optimizer experiments to manage the most productive approach to actualize a given question by looking at the conceivable query plans. In this paper, the diverse procedures is given for streamlining question utilizing blueprint based and emerged views in data distribution center to be specific view adjustment and synchronization, view determination and view support.

Keywords: Query optimization, materialized view, SQL

Cite this Article

Neha Agarwal, Manisha Raina. Study of Query Optimization Techniques using Different Schemas: A Review. Journal of Advanced Database Management & Systems. 2017; 4(1): 26–29p.


Downloads

Published

2017-05-11

Issue

Vol. 4 No. 1 (2017)

Section

Review Articles

License

Declaration and Copyright Transfer Form

(to be completed by authors)

I/ We, the undersigned author(s) of the submitted manuscript, hereby declare, that the above manuscript which is submitted for publication in the STM Journals(s), is not published already in part or whole (except in the form of abstract) in any journal or magazine for private or public circulation, and, is not under consideration of publication elsewhere.

  • I/We will not withdraw the manuscript after 1 week of submission as I have read the Author Guidelines and will adhere to the guidelines.
  • I/We Author(s ) have niether given nor will give this manuscript elsewhere for publishing after submitting in STM Journal(s).
  • I/ We have read the original version of the manuscript and am/ are responsible for the thought contents embodied in it. The work dealt in the manuscript is my/ our own, and my/ our individual contribution to this work is significant enough to qualify for authorship.
  •  I/We also agree to the authorship of the article in the following order:

Author’s name                                    

 

1. ________________

2. ________________

3. ________________

4. ________________

 

We  Author(s) tick this box and would request you to consider it as our signature as we agree to the terms of this Copyright Notice, which will apply to this submission if and when it is published by this journal.