Indonesian Journal of Electrical Engineering and Computer Science Vol. 9, No. 3, March 2018, pp. 784~788 ISSN: 2502-4752, DOI: 10.11591/ijeecs.v9.i3.pp784-788  784 Journal homepage: http://iaescore.com/journals/index.php/ijeecs Query Processing for Time Efficient Data Retrieval Muhammad Qasim Memon, Jingsha He, Aasma Memon, Khurram Gulzar Rana, Muhammad Salman Pathan School of software Engineering, Beijing University of Technology, 100124, Beijing, China Beijing Engineering Research Center for IoT Software and Systems, Beijing University of Technology, 100124, Beijing, China Article Info ABSTRACT Article history: Received Oct 27, 2017 Revised Jan 30, 2018 Accepted Feb 17, 2018 In database management system (DBMS) retrieving data through structure query language is an essential aspect to find better execution plan for performance. In this paper, we incorporated database objects to optimize query execution time and its cost by vanishing poorly SQL statements. We proposed a method of evolving and inserting database constraints as database objects embedded with queries either to add them for the sake of transactions required by user to detect those queries for the betterment of performance. We took analysis on several databases while processing queries itself and assimilate real time database workload with the bunch of transactions are invoked in comparison with tuning approaches. These database objects are coded in procedural language environment pertaining rules to make it worth and are merged into queries offering improved execution plan. Keywords: Database tuning Query execution Query processing Copyright © 2018 Institute of Advanced Engineering and Science. All rights reserved. Corresponding Author: Muhammad Qasim Memon, School of software Engineering, Beijing University of Technology, 100124, Beijing, China. Email: memon_kasim@yahoo.com 1. INTRODUCTION For optimizing database, it is necessary for performance to tune queries. Although it is also important as compare to optimize the other phases of database server installation such as configuration of software and hardware causes the performance as well. If database server manipulated with eminent powerful hardware that have all i/o resources with processing speed with at least one bad query pertaining poor performance affects the speed of execution [1]. It is distinctively stated about any database server after optimizing all hardware configurations, remaining issues may appear to lessen performance of database those are: expensive and time consuming queries, reminiscence of indexes, inappropriate statistics, debugging of queries and uses of cursors [2]. In this work, we focus on two important phases of tuning queries. First, to tune poorly performing queries such as analyzing execution plan, optimizing execution plan and its estimated cost. Secondly, inclusion of database constraints to restrict or acquire data from the database based on defined rules. In this work, our focus is to evolve procedural language functionalities invoked in runtime environment through queries rather relying on modifying SQL structure, access design amendments and employing local constraints within queries. There are many databases and tools offers tuning into to two ways. First, tuning offered by commercial databases known as automatic and externally tuning by venders tool into to optimize queries known as manual tuning. This simplifies our comparison analysis resembles between both types of tuning approaches. We devote our method of deploying this tuning comparison with a bunch of queries in several databases. Internal tuning offered by databases like oracle, MySQL, DB2 named as automatic tuning, and external tuning named as SQL tuning offered by different vendors tools into databases like Microsoft SQL Server developer 8.0 and Oracle SQL developer. This simplifies our comparison analysis resembles over automatic and SQL tuning. We devote our methods of deploying two phases of tuning as we mentioned above, and bunch of queries in different commercial databases [3].