CFP last date
20 January 2025
Call for Paper
February Edition
IJCA solicits high quality original research papers for the upcoming February edition of the journal. The last date of research paper submission is 20 January 2025

Submit your paper
Know more
The week's pick
Responsive image
SFLA-Based Line Balancing and Task Optimization in Master-Slave Controlled Hanger Transportation Systems for Garment Production

Duc Hoang Nguyen
Random Articles
Reseach Article

Estimation of Query Execution Time in Milli Seconds, Micro Seconds and Nano Seconds for Oracle, MsSQL and MsAccess Relational Databases

by Voore Subba Rao, V. Chandra Shekar Rao, Porika Sammulal
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 66 - Number 1
Year of Publication: 2013
Authors: Voore Subba Rao, V. Chandra Shekar Rao, Porika Sammulal
10.5120/11050-5945

Voore Subba Rao, V. Chandra Shekar Rao, Porika Sammulal . Estimation of Query Execution Time in Milli Seconds, Micro Seconds and Nano Seconds for Oracle, MsSQL and MsAccess Relational Databases. International Journal of Computer Applications. 66, 1 ( March 2013), 34-38. DOI=10.5120/11050-5945

@article{ 10.5120/11050-5945,
author = { Voore Subba Rao, V. Chandra Shekar Rao, Porika Sammulal },
title = { Estimation of Query Execution Time in Milli Seconds, Micro Seconds and Nano Seconds for Oracle, MsSQL and MsAccess Relational Databases },
journal = { International Journal of Computer Applications },
issue_date = { March 2013 },
volume = { 66 },
number = { 1 },
month = { March },
year = { 2013 },
issn = { 0975-8887 },
pages = { 34-38 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume66/number1/11050-5945/ },
doi = { 10.5120/11050-5945 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T21:21:12.514876+05:30
%A Voore Subba Rao
%A V. Chandra Shekar Rao
%A Porika Sammulal
%T Estimation of Query Execution Time in Milli Seconds, Micro Seconds and Nano Seconds for Oracle, MsSQL and MsAccess Relational Databases
%J International Journal of Computer Applications
%@ 0975-8887
%V 66
%N 1
%P 34-38
%D 2013
%I Foundation of Computer Science (FCS), NY, USA
Abstract

In this paper an attempt is made to develop a user friendly software to evaluate the query estimation time in milli seconds (10-3 sec. ), micro seconds (10-6 sec. ) and nano seconds (10-9 sec. ) for Oracle, Ms-SQL and Ms-Access Relational Databases. Most of the relational database application programs are written in high-level languages integrating a relational language. The Relational Languages offer generally a declarative interface (or declarative language like SQL) to access the data stored in a database. To execute the query in relational databases, the user interact with structural query language (SQL). For that, the user should aware the knowledge about the schema management, vocabulary of the SQL commands, entities and attributes of the database. The IT people have the knowledge about query of the Relational Databases and get the information. But normal users are not aware of querying the Relational Databases but like to know the calculation of query execution time in mill Seconds(10-3 sec. ), micro Seconds (10-6 sec. ) and nano Seconds (10-9 sec. ) in a user friendly way.

References
  1. Eric L. Barsness, Pine Islad,MN, John M. Santosuesso, Rochester "Estimating and Monitoring query Processing Time" IEEE 2012.
  2. Mustafa Jarrar, Marios D. Dikaiakos, "A Query Formulation Language for the Data Web" Journal of IEEE 2011.
  3. Lerina Aversano, Gerardo Canfora, Andrea De Lucia, Silvio Stefanucci, "Understanding SQL through Iconic Interfaces" Journal of IEEE.
  4. Mustafa Jarrar, Marios D. Dikaiakos "MashQL: A Query-by-Diagram Topping SPARQL -Towards Semantic Data Mashups", ONISW'08, October 30, 2008, Napa Valley, California, USA,1-15.
  5. M. Angelaccio, T. Catarci, and G. Santucci, "QBD: A Fully Visual Query System", Journal on Visual Languages and Computing, vol. 1,no. 2, 1990, pp 255-273.
  6. M. Angelaccio, T. Catarci, and G. Santucci, "QBD: A Graphical Query Language with Recursion", IEEETransactions on Software Engineering, vol. 16, no. 10, 1990, pp 1150-1163.
  7. ]M. M. Zloof, "Query-by-Example: A Database Language", IBM Systems Journal, vol. 16, no. 4, 1977, pp. 324-343.
  8. P. Reisner, "Query Languages", M. Helander ed. Handbook of Human- Computer Interaction, Elsevier Science Publ. ,1988, pp 257-280.
  9. P. Reisner, "Query Languages", M. Helander ed. Handbook of Human- Computer Interaction, Elsevier Science Publ. , 1988, pp 257-280.
  10. G. Ozsoyoglu, V. Mates, and Z. M. Ozsoyoglu, "Query Processing Techniques in the Summary-Table-by-example Database Query Language", ACM TODS, vol. 14, no. 4, Dec. 1989, pp. 526-573
  11. Catarci, M. F. Costabile, S. Levialdi, C. Batini, "Visual Query Systems for Databases: A Survey", Technical Report SI/RR-95/17 of Dipartimentodi Scienze dell' Informazione,University of Rome "La Sapienza", 1995.
Index Terms

Computer Science
Information Sciences

Keywords

Execution time Query execution User friendly query Time estimation application

Powered by PhDFocusTM