International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
|
Volume 114 - Issue 4 |
Published: March 2015 |
Authors: Dhaval Patel, Pratik Patel |
![]() |
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 }, year = { 2015 }, volume = { 114 }, number = { 4 }, pages = { 16-18 }, doi = { 10.5120/19966-1812 }, publisher = { Foundation of Computer Science (FCS), NY, USA } }
%0 Journal Article %D 2015 %A Dhaval Patel %A Pratik Patel %T A Review Paper on Different Approaches for Query Optimization using Schema Object base View%T %J International Journal of Computer Applications %V 114 %N 4 %P 16-18 %R 10.5120/19966-1812 %I Foundation of Computer Science (FCS), NY, USA
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.