Utilizing previously executed queries contributes in speeding up the performance of database in responding to future queries as it can reduce the number of database queries to be processed and sent back to the user. This technique avoids the re-evaluation and validation of the query being sent to the database. On the testing of the developed algorithm, shows that a one-time access of a certain query to the database was able to reused, respond and served the requirements of seven (7) different requested queries. The number could be higher if the number of fields in a query will be increased. In a scenario where the same information are to be accessed by a substantial number of users, a single access can be possibly cater the needs of the entire users which substantially reduced the amount of request being sent to the database. The process shifted some of the workloads to the application program that is usually processed by the database was achieved in the study which gives partial autonomy to the application program in terms of responding to users’ requests in the form of queries. The designed algorithm was able to fetched and reuse previously executed query to respond to future queries executed by the user which applies the principle of prefetching operation. Hence, database transparency is improved.
Ruben A. Parazo, Dr. James A. Esquivel (2018); Optimizing the Capability of SQL Queries Towards Improving Database Transparency;
Int J Sci Res Publ 8(1) (ISSN: 2250-3153). http://www.ijsrp.org/research-paper-0118.php?rp=P737114