International Journal of Scientific and Research Publications

Home
About Us
Editorial Board

Online Publication

Log In
New User?
       Register Now!
Forgot Password?
       Email Password!


Call For Papers

Call for Research Paper

Authors

Online Submission
Paper Submission Guidelines
Online Publication Charge
Print Publication Charge
How to publish research paper
Publication Certificate
Research Catalogue
Resources
FAQs

Reviewer

Join Reviewer Panel
Reviewer Guidelines

IJSRP Publications

E-Journal
Print Journal

Downloads

IJSRP Paper Format
Instructions

Contact Us

Feedback Form
Contact Us
Site Map

IJSRP, Volume 8, Issue 1, January 2018 Edition [ISSN 2250-3153]



      Ruben A. Parazo, Dr. James A. Esquivel

Abstract: 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.

[Reference this Paper]   [BACK]

Ooops! It appears you don't have a PDF plugin for this barrPostingser. you can click here to download the PDF file.

Reference this Research Paper (copy & paste below code):

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

IJSRP PUBLICATIONS

Home

About Us
Editorial Board
Call for Paper

Call for Research Paper
Paper Status
IJSRP Paper Format
Join Us

Download e-journal
Join Forum
Invite Friends
Subscribe
Get Social with Us!



Copyright © 2011-2016, IJSRP Inc., All rights reserved.