Research Article Open Access

Empirical Performance Metrics Study of Execution of Database Queries in Implementation of Web Services

K. Velmurugan1 and M. A. Maluk Mohamed1
  • 1 Anna University, India
Journal of Computer Science
Volume 8 No. 8, 2012, 1346-1352

DOI: https://doi.org/10.3844/jcssp.2012.1346.1352

Submitted On: 10 February 2012 Published On: 30 July 2012

How to Cite: Velmurugan, K. & Mohamed, M. A. M. (2012). Empirical Performance Metrics Study of Execution of Database Queries in Implementation of Web Services. Journal of Computer Science, 8(8), 1346-1352. https://doi.org/10.3844/jcssp.2012.1346.1352

Abstract

Problem statement: Web services are increasingly being deployed in business applications, due to its unique features such as flexibility, interoperability and other features. Most of the business applications involve extensive use of database operations for data management in back end. Further business applications demand very high level of performance from software solutions and it is a continual and never-ending process. This study focuses on measurement and analysis of performance metrics of database queries in implementation of web services. Approach: In this experimentation, web services are implemented in two popular and standard platforms and database queries are realized through all commercial and standard databases. Performance measurement is done by implementing a common sample application on each realization and using a pair of performance metrics, response time and packet count, that is, number of packets involved in communication between the layers of implementation. Results and Conclusion: This novel study summarizes the various performance aspects of databases in web services with a basic set of database queries in the back end and concludes with firm results on optimum performance offered by database in execution of database queries in realization of web services.

  • 1,072 Views
  • 1,791 Downloads
  • 0 Citations

Download

Keywords

  • Performance metrics
  • web services
  • database support