IJSRST196219 | Received : 01 March 2019 | Accepted : 09 March 2019 | March-April-2019 [ 6 (2) : 91-94] © 2019 IJSRST | Volume 6 | Issue 2 | Print ISSN: 2395-6011 | Online ISSN: 2395-602X Themed Section: Science and Technology DOI : https://doi.org/10.32628/IJSRST196219 91 Study of Query Optimization in Cloud Y. Supriya, K. Gayathri G. Pullaiah college of Engineering and Technology, Department of CSE, Kurnool, Andhra Pradesh, India ABSTRACT Cloud computing in very simple terms, is basically where a company uses someone else’s computing services (usually over the internet) instead of having to run that software on their own computers. Today, cloud computing plays an important role in service-oriented technologies. The main purpose of cloud computing is, it allows consumers and businesses to use applications without installation and access their personal files at any computer with internet access and it allow users to easily and efficiently calculate and save resources. The recent approach is to process data expression and search. To improve cloud performance, it is necessary to optimize the processing time. Our research provides a comprehensive overview of the different models and methods used to optimize queries to reduce execution time and improve resource utilization. We conducted various query optimization research activities for the classic SQL and Map Reduce platforms. Keywords : Cloud Computing, Map-Reduce, Service Level Agreement, Query optimization, Conventional SQL. I. INTRODUCTION Cloud computing is a very successful paradigm for service-oriented computing [1]. The most popular cloud services are Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS). Expanding this concept is a Database as a Service (DBaaS) or Storage as a Service. Cloud computing improves common computer and storage capacity for a number of database applications. "The observed number of applications that have affected multiple platforms in the clouds has greatly increased the amount of data generated and used by these applications" [2]. "Cloud is the basis for cloud computing applications and search algorithm and cloud organization and search algorithm." The new research topic was how to organize and manage this huge amount of data. Get users useful information about cloud computing "it's the core of the cloud application" [3] How to get data fast, accurate and secure Play an important role in a successful job data model in the cloud. In cloud computing, resources need to be automatically and quickly acquired and released during business hours to provide Service Level Agreements (SLAs) between the client and the cloud provider [4]. Using virtual machine clusters, cloud computing users can rent large amounts of resources for a short period of time to effectively execute large-scale complex queries [5]. Lease duration can be further reduced by using better query optimization techniques [6]. Therefore, it is necessary to investigate effective query optimization techniques to reduce query time and response time. It will also improve the use of computing resources in the cloud. “Query optimization leads to optimization of resource lease time in the cloud environment”. Query optimization techniques in centralized and distributed platforms are extensively researched in conventional SQL and Map Reduce methods. An example of processing a request in the cloud is shown