KSII Transactions on Internet and Information Systems (TIIS)

Korean Society for Internet Information (한국인터넷정보학회)
권호 표지
DOI QR코드

DOI QR Code

Performance of Database Driven Network Applications from the User Perspective

  • Tang, Shanyu (Faculty of Computing, London Metropolitan University) ;
  • YongFeng, Huang (Department of Electronic Engineering, Tsinghua University) ;
  • Yip, Yau Jim (School of Computing and Engineering, University of Huddersfield)
  • Published : 2009.06.25
Download PDF
⟨ Previous Next ⟩

Abstract

An understanding of performance of database driven network applications is critical in combating slow performance of e-commerce web sites, besides efficient web page design, and high quality and well-maintained web server equipment. This paper describes a method of measuring performance from the user viewpoint, which can help enormously in making realistic assessment of true performance of database driven applications. The performance measurements were taken at user locations by using several specially designed JavaScript functions along with ASP scripts. A performance study is presented in this paper, comparing performance of data access using stored procedures with the traditional way of querying a database. It is generally believed that stored procedures have performance benefits as they are pre-compiled. However, our study shows that the data access approach using stored procedures provides significant benefits(by about 30%) over the traditional approach for querying a commercial MySQL database, only when retrieving a substantial amount of data(at least 10,000 rows of data).

Keywords

References

  1. C.S. Sohn, “Customer evaluation of Internet-based service quality and intention to re-use internet-based services,” Dissertation, Southern Illinois University, IL: Carbondale, 2000.
  2. C. Liu, and K.P. Arnett, “Exploring the Factors Associated with Web Site Success in the Context of Electronic Commerce,” Information & Management, Vol.38, No.1, pp.23-34, 2000. https://doi.org/10.1016/S0378-7206(00)00049-5
  3. P.J. Trocchia, and S. Janda, “How do consumers evaluate Internet retail service quality?” Journal of Services Marketing, Vol.17, No.3, pp.243-253, 2003. https://doi.org/10.1108/08876040310474800
  4. V. McKinney, K. Yoon, and F.M. Zahedi, “The Measurement of Web-Customer Satisfaction: An Expectation and Disconfirmation Approach,” Information Systems Research, Vol.13, No.3, pp.296-315, 2002. https://doi.org/10.1287/isre.13.3.296.76
  5. Z. Yang, R.T. Peterson, and L. Huang, “Taking the Pulse of Internet Pharmacies,” Marketing Health Services, summer, pp.5-10, 2001.
  6. J.W. Palmer, “Web Site Usability, Design and Performance Metrics,” Information Systems Research, Vol.13, No.2, pp.151-167, 2002. https://doi.org/10.1287/isre.13.2.151.88
  7. A.M. Aladwani, and P.C. Palvia, “Developing and validating an instrument for measuring user perceived web quality,” Information & Management, Vol.39, No.6, pp.467-476, 2002. https://doi.org/10.1016/S0378-7206(01)00113-6
  8. S. Ravi, “Measurement of User-Perceived Web Quality,” in Proc. of 12th European Conference on Information Systems (ECIS), Turku, Finland, 2004.
  9. G. Banga, and P. Druschel, “Measuring the capacity of a Web server under realistic loads,” World Wide Web, Vol.2, No.1-2, pp.69-83, 1999. https://doi.org/10.1023/A:1019292504731
  10. S. Elbaum, G. Rothermel, S. Karre, and M. Fisher, “Leveraging User Session Data to Support Web Application Testing,” IEEE Trans. Software Eng., Vol. 31, No. 3, pp. 187-202, 2005. https://doi.org/10.1109/TSE.2005.36
  11. A. Andrews, J. Offutt, and R. Alexander, “Testing Web Applications by Modelling with FSMs,” Software and Systems Modelling, Vol.4, No.3, pp.326-345, July 2005. https://doi.org/10.1007/s10270-004-0077-7
  12. M. Shams, D. Krishnamurthy, and B. Far, “A model-based approach for testing the performance of web applications,” in Proc. of the 3rd International Workshop on Software Quality Assurance, pp.54-61, 2006.
  13. Edward W. Felten, and Michael A. Schneider, “Timing Attacks on Web Privacy,” in Proc. of 7th ACM Conference on Computer and Communications Security, Nov. 2000.
  14. S. Jae Yang, Jason Nieh, and Naomi Novik, “Measuring Thin-Client Performance Using Slow-Motion Benchmarking,” ACM Transactions on Computer Systems, Vol. 21, No.1, pp.87-115, 2003. https://doi.org/10.1145/592637.592640
  15. A. Parasuraman, “Technology Readiness Index (TRI): A Multiple Item Scale to Measure Readiness to Embrace New Technologies,” Journal of Services Research, Vol.2, No.4, pp.307-320, 2000. https://doi.org/10.1177/109467050024001
  16. J. Song, and F.M. Zahedi, “Web Design in E-commerce: A theory and Empirical analysis,” in Proc. of Twenty-second International Conference on Information Systems, pp.205-219, 2001.
  17. R. Agarwal, and V. Venkatesh, “Assessing a Firm’s Web Presence: A heuristic Evaluation Procedure for the Measurement of Usability,” Information Systems Research, Vol.13, No.2, pp.168-186, 2002. https://doi.org/10.1287/isre.13.2.168.84
  18. J. Cox, and B.G. Dale, “Key quality factors in Web site design and use: an examination,” International Journal of Quality & Reliability Management, Vol.19, No.7, pp.862-888, 2002. https://doi.org/10.1108/02656710210434784
  19. T.M. Connolly, and C.E. Begg, Database Systems, Pearson Education, 2005, ISBN 0321210255.
  20. MySQL web site. Http://www.mysql.net/.
  21. Paul DuBois, MySQL Cookbook, O’Reilly Media, Inc., ISBN: 059652708X.
  22. Guy Harrison, and Steven Feuerstein, MySQL Stored Procedures Programming, O'Reilly Media, Inc., 2005.
  23. Russell Dyer, MySQL in a Nutshell, O'Reilly Media, Inc., ISBN: 0596007892.
  24. Jeremy Zawodny, and Derek Balling, High Performance MySQL, ISBN: 0596003064.
  25. S. Tang, W. Lu, and F. Marir, “Optimisation of interactive web data access,” in Proc. of International Conference on eCommerce Engineering, pp.16-21, 2001. ISBN 7-900066-54-3.
  26. S. Tang, T. Wang, and Y. Huang, “Evaluation of Web Data Access for an Enterprise Web Application Built on a .NET Platform,” in Proc. of 2nd International Conference on Internet Technologies and Application, 2007. ISBN: 978-0-9468-8154-3.
  27. P. Roy, S. Seshadri, S. Sudarshan and S. Bhobe, “Efficient and Extensible Algorithms for Multi Query Optimisation,” in Proc. of the SIGMOD’ 2000 International Conference, Dallas, 2000.
  28. Y. Huang, K. Zhou, Z. H. Wang, “Multiple Data Channel Data Hiding Mechanisms based on VOIP,” Journal of Harbin Industrial University, pp.38, 2006.
  29. Y. Huang, S. Tang, and Y. J. Yip, “A New Security Architecture for SIP Based P2P Computer Networks,” Journal of Computer Science, Informatics and Electrical Engineering, Vol.2, No.1, pp.63-73, 2008.

Cited by

  1. Real-time Estimation and Analysis of Time-based Accessibility and Usability for Ubiquitous Mobile-Web Services vol.5, pp.5, 2009, https://doi.org/10.3837/tiis.2011.05.004