Abstract
The complex functionalities and high demands of software quality make manual testing of a web application ineffective. Automatic software testing methods can help to determine if a web application is working correctly, but existing methods are unable to test whether such an application interacts correctly with a back-end database. This paper elaborates an approach, called the Automatic Database Tester (AutoDBT), that extends the functional or black-box testing of a web database application to include database updates. AutoDBT takes as input a model of the application and a set of test criteria. The model consists of a state transition diagram showing how a user navigates among pages in the application, and a data specification which captures how data flows in the application and how the database is updated. AutoDBT uses the model along with the test criteria to generate test cases for functional testing of the application.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Andrews, A.A., Offutt, J., Alexander, R.T.: TestingWeb Applications By Modeling with FSMs. Accepted by Software and System Modeling. Springer, Heidelberg
Bodin, L., Tucker, A.: Model for Municipal Street Sweeping Operations. In: Modules in Applied Mathematics, Discrete and System Models, vol. 3, pp. 76–111 (1983)
Benedikt, M., Freire, J., Godefroid, P.: VeriWeb: Automatically Testing Dynamic Web Sites. In: Proceedings International WWW Conference 11, Honolulu, Hawaii, USA, pp. 654–668 (2002)
Chays, D., Dan, S., Frankl, P.G., Vokolos, F.I., Weyuker, E.J.: A Framework for Testing Database Applications. In: Proc. of the International Symposium on Software Testing and Analysis, pp. 147–157 (2000)
Chow, T.S.: Testing Software Design Modeled by Finite-State Machines. IEEE Transactions on Software Engineering SE-4(3), 178–187 (1978)
Fujiwara, S., Bochmann, G., Khendek, F., Amalou, M., Ghedasmi, A.: Test selection based on finite state models. IEEE Transactions on Software Engineering 17(6), 591–603 (1991)
Gray, J., Sundaresan, P., Englert, S., Baclawski, K., Weinberger, P.J.: Quickly Generating Billion Record Synthetic Databases. In: Proc. ACM SIGMOD, pp. 243–252 (1994)
Hower, R.: Web site test tools and site management tools. Software QA and Testing Resource Center (2002), http://www.softwareqatest.com/qatweb1.html (accessed, November 2003)
Jia, X., Liu, H.: Rigorous and Automatic Testing ofWeb Application. In: Proceedings of the 6th IASTED International Conference on Software Engineering and Applications (SEA 2002), Cambridge, MA, USA, November 2002, pp. 280–285 (2002)
Kung, D., Liu, C.H., Hsia, P.: Amodel-based approach for testing Web applications. In: Proc. of Twelfth International Conference on Software Engineering and Knowledge Engineering, Chicago, IL (July 2000)
Kung, D., Liu, C.H., Hsia, P.: An object-oriented Web test model for testing Web applications. In: Proc. of IEEE 24th Annual International Computer Software and Applications Conference (COMP-SAC 2000), Taipei, Taiwan, October 2000, pp. 537–542 (2000)
Lee, S.C., Offutt, J.: Generating test cases for XML-based Web component interactions using mutation analysis. In: Proceedings of the 12th International Symposium on Software Reliability Engineering, Hong Kong China, pp. 200–209. IEEE Computer Society Press, Los Alamitos (2001)
Offutt, J., Abdurazik, A.: Generating tests from UML specifications. In: France, R.B., Rumpe, B. (eds.) UML 1999. LNCS, vol. 1723, pp. 416–429. Springer, Heidelberg (1999)
Ofutt, J., Liu, S., Abdurazik, A., Ammann, P.: Generating test data from state-based specifications. The Journal of Software Testing, Verification, and Reliability 12(1), 25–53 (2003)
Ricca, F., Tonella, P.: Analysis and Testing of Web Applications. In: 23rd International Conference on Software Engineering (ICSE), Toronto, Ontario, Canada, pp. 25–34 (2001)
Slutz, D.: Massive stochastic testing of SQL. In: Proceedings of theTwenty-Fourth International Conference on Very-Large Databases, pp. 618–622. Morgan Kaufmann, San Francisco (1998)
Transaction Processing Performance Council. TPC-Benchmark C (1998)
Whittaker, J., Thomason, M.: A Markov Chain Model for Statistical Software Testing. IEEE Transactions on Software Engineering 20, 812–824 (1992)
Yang, J., Huang, J., Wang, F., Chu, W.: An object-oriented architecture supporting Web application testing. In: First Asian-Pacific Conference on Quality Software (APAQS 1999), Japan, December 1999, pp. 122–129 (1999)
Yang, J., Huang, J., Wang, F., Chu, W.: Constructing an object-oriented architecture forWeb application testing. Journal of Information Science and Engineering 18(1), 59–84 (2002)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Ran, L., Dyreson, C.E., Andrews, A. (2004). AutoDBT: A Framework for Automatic Testing of Web Database Applications. In: Zhou, X., Su, S., Papazoglou, M.P., Orlowska, M.E., Jeffery, K. (eds) Web Information Systems – WISE 2004. WISE 2004. Lecture Notes in Computer Science, vol 3306. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-30480-7_20
Download citation
DOI: https://doi.org/10.1007/978-3-540-30480-7_20
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-23894-2
Online ISBN: 978-3-540-30480-7
eBook Packages: Springer Book Archive