The week's pick
Random Articles
Reseach Article
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 |
| 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
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
- Eric L. Barsness, Pine Islad,MN, John M. Santosuesso, Rochester "Estimating and Monitoring query Processing Time" IEEE 2012.
- Mustafa Jarrar, Marios D. Dikaiakos, "A Query Formulation Language for the Data Web" Journal of IEEE 2011.
- Lerina Aversano, Gerardo Canfora, Andrea De Lucia, Silvio Stefanucci, "Understanding SQL through Iconic Interfaces" Journal of IEEE.
- 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.
- 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.
- 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.
- ]M. M. Zloof, "Query-by-Example: A Database Language", IBM Systems Journal, vol. 16, no. 4, 1977, pp. 324-343.
- P. Reisner, "Query Languages", M. Helander ed. Handbook of Human- Computer Interaction, Elsevier Science Publ. ,1988, pp 257-280.
- P. Reisner, "Query Languages", M. Helander ed. Handbook of Human- Computer Interaction, Elsevier Science Publ. , 1988, pp 257-280.
- 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
- 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
Keywords