Query Processing for Time Efficient Data Retrieval

Muhammad Qasim Memon (Beijing University of Technology)
Jingsha He (Beijing University of Technology)
Aasma Memon (Beijing University of Technology)
Khurram Gulzar Rana (Beijing University of Technology)
Muhammad Salman Pathan (Beijing University of Technology)

Indonesian Journal of Electrical Engineering and Computer Science
Vol 9, No 3: March 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.