Study of Query Optimization Techniques using Different Schemas: A Review

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.