Abstract
The need for an automated testing tool to test the correctness of the database applications is crucial in our current day since databases play an important role in almost all organizations. Also, database’s behavior need to be verified in order to avoid costly errors and false information being extracted from them. The main aim of this paper was to create a component-based tester called DBSoft that tests the correctness of database application systems. The DBSoft toolkit consists of five tools as follows: information collection with the Parser tool, test case generation with the Input Generator tool, test case implementation with the Output Generator tool, test case validation with the Output Validator tool and report generation with the Report Generator tool.
Keywords
References
- Bati, H., Giakoumakis, L., Herbert, S. & Surna, A. (2007). A genetic approach for random testing of database systems, Proceedings of the 33rd international conference on Very large data bases, 2007.
- Binnig, C., Kossmann, D., Lo, E. & Özsu, M. T. (2007). QAGen: generating query-aware test databases, Proceedings of the 2007 ACM SIGMOD international conference on Management of data, 2007.
- Bruno, N. & Chaudhuri, S. (2005). Flexible database generators, Proceedings of the 31st international conference on Very large data bases, 2005.
- Chays, D. & Deng, Y. (2003). Demonstration of AGENDA Tool Set for Testing Relational Database, ICSE '03 Proceedings of the 25th International Conference on Software Engineering, 2003.
- Chays, D., Deng, Y., Frankl, P. G., Dan, S., Vokolos, F. I. & Weyuker, E. J. (2004). An AGENDA for testing relational database applications. Software Testing, verification and reliability, 2004.
- Chen, T. Y., Poon, P. L. & Tse, T. H. (2003). A Choice Relation Framework for Supporting Category-Partition Test Case Generation, IEEE Transactions on Software Engineering, 29(7), 577-593.
- Deng, Y., Frankl, P. & Chays, D. (2005). Testing database transactions with AGENDA, Proceedings of the 27th international conference on Software engineering, 2005.
- Haftmann, F., Kossmann, D. & Kreutz, A. (2005). Efficient regression tests for database applications. Conference on Innovative Data Systems Research (CIDR), 95-106, 2005.
- Haftmann, F., Kossmann, D. & Lo, E. (2007). A Framework for efficient regression tests on database applications. The VLDB Journal — The International Journal on Very Large Data Bases, 16(1), 145-164.
- JDBC Drive (Online) http://jdbc.postgresql.org/ [Accessed on 10/12/2012].
- Lo, E., Binnig, C., Kossmann, D., Ozsu, M. T. & Hon, W. K. (2010). A Framework for Testing DBMS Features. VLDB Journal, 19(2), 203–230.
- Lyons, N. R. (1977). An automatic data generating system for data base simulation and testing. ACM SIGMIS Database, 8(4), 10-13.
- Mishra, C., Koudas, N. & Zuzarte, C. (2008). Generating targeted queries for database testing, Proceedings of the 2008 ACM SIGMOD international conference on Management of data, 2008.
- PostgreSQL. (2012). online http://www.postgresql.org/ [Retrieved on 20/12/2012]
- Tuya, J., Cabal, M. J. S. & Riva, C. D. l. (2007). Mutating database queries. Information and Software Technology, 49(4), 398-417.
Downloads
No downloads have been recorded for this article yet. Figures appear here once readers begin downloading the full text.
How to Cite
Share this article
License
Copyright (c) 2013 Zuhoor A. Al-Khanjari, Sara Al-Kindy (Author)
This work is licensed under a Creative Commons Attribution 4.0 International License.
Author (s) should affirm that the material has not been published previously. It has not been submitted and it is not under consideration by any other journal. At the same time author (s) need to execute a publication permission agreement to assume the responsibility of the submitted content and any omissions and errors therein. After submission of revised paper in the light of suggestions of the reviewers, the editorial team edits and formats manuscripts to bring uniformity and standardization in published material.
This work will be licensed under Creative Commons Attribution 4.0 International (CC BY 4.0) and under condition of the license, users are free to read, copy, remix, transform, redistribute, download, print, search or link to the full texts of articles and even build upon their work as long as they credit the author for the original work. Moreover, as per journal policy author (s) hold and retain copyrights without any restrictions.
Keywords
Section
Published
Submissions
Have research to publish? Information Management and Business Review welcomes submissions.
Make a Submission