Estimation of Query Execution Time in Milli Seconds, Micro Seconds and Nano Seconds for Oracle, MsSQL and MsAccess Relational Databases
Voore Subba Rao, Vidya Rao, Porika Sammulal · International Journal of Computer Applications · 2013
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.