Automated Testing Framework for ODBC Driver
Author(s)
Dan Ye
ABSTRACT
At first, the core ideology, advantage and principle of Software Testing Automation Framework (STAF) are presented in this paper. Several automated testing frameworks are summarized and analyzed. In addition, date driven automation test framework is given more attention. Test script is the important composing part of software test automation. Then this paper introduces several technologies of script along with their characteristics. Every technology applies to different places. Moreover, an automated test system with an automated test script language XML which is implemented to solve the problems in current automatic testing solutions. The design and implantation of the test script automation framework based on apache ant is put forward. The proposed key technology details of framework are also introduced. We take the automation test methodology of database connectivity operations by ODBC data source as example for validation, using auto test script as the key technology. Finally, the results demonstrate that it can best increase software test effectiveness and reduce workloads as well as save more efforts.
At first, the core ideology, advantage and principle of Software Testing Automation Framework (STAF) are presented in this paper. Several automated testing frameworks are summarized and analyzed. In addition, date driven automation test framework is given more attention. Test script is the important composing part of software test automation. Then this paper introduces several technologies of script along with their characteristics. Every technology applies to different places. Moreover, an automated test system with an automated test script language XML which is implemented to solve the problems in current automatic testing solutions. The design and implantation of the test script automation framework based on apache ant is put forward. The proposed key technology details of framework are also introduced. We take the automation test methodology of database connectivity operations by ODBC data source as example for validation, using auto test script as the key technology. Finally, the results demonstrate that it can best increase software test effectiveness and reduce workloads as well as save more efforts.
Cite this paper
nullD. Ye, "Automated Testing Framework for ODBC Driver," Journal of Software Engineering and Applications, Vol. 4 No. 12, 2011, pp. 688-699. doi: 10.4236/jsea.2011.412081.
nullD. Ye, "Automated Testing Framework for ODBC Driver," Journal of Software Engineering and Applications, Vol. 4 No. 12, 2011, pp. 688-699. doi: 10.4236/jsea.2011.412081.
References
[1] D. J. Mosley and B. A. Posey, “Software Test Automation. Just Enough Software Test Automation,” B. Zheng L. J. Huang and Q. C. Cao Translated, Machinery Industry Press, Beijing, 2003. [2] W. Frakes and K. Kang, “Software Reuse Research: Status and Future,” IEEE Transactions on Software Engineering, Vol. 31. No. 7, 2005, pp. 529-536. doi:10.1109/TSE.2005.85 [3] W. Aresi and F. McGarry, “Defining Leverage Points for Increasing Reuse,” Minnowbrook Work Shop on Software Reuse, Blue Mountain Lake, New York, 1987. [4] M. R. Qureshi and S. A. Hussain, “A Reusable Software Component-Based Development Process Model,” Advances in Software Engineering, Vol. 39, No. 2, 2008, pp. 88-94. doi:10.10161/j.advengsoft.2007.01.021 [5] C. J. M. Geisterfer and S. Ghosh, “Software Component Specification: A Study in Perspective of Component Selection and Reuse,” Fifth International Conference on Commercial-off-the-Shelf (COTS) Based Software Systems, Washington, 13-16 February 2006, p. 9. [6] M. Kelly, “Choosing a Test Automation Framework,” 2003. http://www.128.ibm.com/developerworks/rational/library/591/html#N10223 [7] N. Carl, “Test Automation Frameworks,” 2000. http://safsdev.sourceforge.net/FRAMESDataDrivenTestAutomation Frameworks.htm [8] H. H. Sthamer, “The Automatic Generation of Software Test Data Automatically,” Proceedings of the International Conference on Automated Software Engineering, Linz, 20-25 September 2004, pp. 346-349. [9] J. Al-Dallal and P. Sorenson, “Testing Software Assets of Framework based Project Families,” During Application Engineering Stage Journal of Software, Vol. 3, No. 5, 2008, pp. 11-25. [10] S. A. Yahia, N. Koudas, A. Marian, D. Srivastava and D. Toman, “Structure and Content Scoring for XML,” Proceedings of the 31st VLDB Conference, Trondheim, August 2005, pp. 362-372. [11] T. S. Kin, J. H. Lee, J. W. Song and D. H. Kim, “Similarity Measurement of XML Documents Based on Structure and Contents,” International Conference on Computational Science (ICCS), Springer-Verlag, Heidelberg, 2007, pp. 902-905. [12] S. C. Haw and C. S. Lee, “Twing INLAB: A Decomposition-Matching—Mering Approach to Improving XML Query Processing,” American Journal of Applied Sciences, Vol. 5, No. 9, 2008, pp. 1199-1205. doi:10.3844/ajassp.2008.1199.1205 [13] V. Mihajlovic, G. Ramirez, T. WesterVeld, D. Hiemstra, H. E. Blok and A. P. deVries, “Vague Element Selection, Image Search, Overlap, and Relevance Feedback,” Lecture Notes in Computer Science, Vol. 3977, 2006, pp. 72-78. doi:10.1007/11766278_6 [14] P. O. Gilivie and J. Callan, “Parameter Estimation for a Sample Hierarchical Generative Model for XML Component Retrieval,” Lecture Notes in Computer Science, Vol. 3977, 2006, pp. 211-224. [15] B. Sigurbjournsson, J. Kamps and M. de Rijke, “The Effect of Structured Queries and Selective Indexing on XML Retrieval,” Lecture Notes in Computer Science, Vol. 3977, 2006, pp. 104-118. [16] B. Jeong, D. Lee, H. Cho and J. Lee, “A Novel Method for Measuring Semantic Similarity for XML Schema Matching,” Expert Systems with Applications, Vol. 24, 2008, pp. 1651-1658. doi:10.1016/j.eswa.2007.01.025 [17] H. Z. Wang, J. Z. Li, W. Wang and X. M. Lin, “Coding-Based Join Algorithm for Structure Queries on Graph-Structured XML Document,” World Wide Web, Vol. 11, No. 4, 2008, pp. 485-510. doi:10.1007/s11280-008-0050-4 [18] D. Ranjan and A. K. Tripathi, “Variablity-Based Models for Testablity Analysis of Frameworks,” Journal of Software Engineering and Applications, Vol. 3, No. 6, 2010, pp. 455-459. doi:10.4236/jsea.2010.35051 [19] D. D. Black, M. E. C. Hull and K. Jackson, “Systems Engineering and Safety-A Framework,” Software, Vol. 5, No. 1, 2011, pp. 43-53. [20] G. Butler, “Object-Oriented Frameworks,” 15th European Conference on Object-Oriented Programming, Tutorial Budapest, 18-22 June 2001, pp. 1-70. [21] J. Al-Dallal and D. Sorenson, “Estimating the Coverage of the Framework Application Reusable Cluster-Based Test Cases,” Information and Software Technology, Vol. 50, No. 6, 2008, pp. 595-604. doi:10.1016/j.infsof.2007.07.006 [22] T. Connolly and C. Begg, “Database Systems: A Practical Approach to Design, Implementation and Management,” Pearson Education, Upper Saddle River, 2004. [23] X. Wu and J. Feng, “A Framework and Implementation of Information Content Reasoning in a Database,” WSEAS Transactions on Information Science and Applications, Vol. 6, No. 4, 2009, pp. 579-588.
[1] D. J. Mosley and B. A. Posey, “Software Test Automation. Just Enough Software Test Automation,” B. Zheng L. J. Huang and Q. C. Cao Translated, Machinery Industry Press, Beijing, 2003. [2] W. Frakes and K. Kang, “Software Reuse Research: Status and Future,” IEEE Transactions on Software Engineering, Vol. 31. No. 7, 2005, pp. 529-536. doi:10.1109/TSE.2005.85 [3] W. Aresi and F. McGarry, “Defining Leverage Points for Increasing Reuse,” Minnowbrook Work Shop on Software Reuse, Blue Mountain Lake, New York, 1987. [4] M. R. Qureshi and S. A. Hussain, “A Reusable Software Component-Based Development Process Model,” Advances in Software Engineering, Vol. 39, No. 2, 2008, pp. 88-94. doi:10.10161/j.advengsoft.2007.01.021 [5] C. J. M. Geisterfer and S. Ghosh, “Software Component Specification: A Study in Perspective of Component Selection and Reuse,” Fifth International Conference on Commercial-off-the-Shelf (COTS) Based Software Systems, Washington, 13-16 February 2006, p. 9. [6] M. Kelly, “Choosing a Test Automation Framework,” 2003. http://www.128.ibm.com/developerworks/rational/library/591/html#N10223 [7] N. Carl, “Test Automation Frameworks,” 2000. http://safsdev.sourceforge.net/FRAMESDataDrivenTestAutomation Frameworks.htm [8] H. H. Sthamer, “The Automatic Generation of Software Test Data Automatically,” Proceedings of the International Conference on Automated Software Engineering, Linz, 20-25 September 2004, pp. 346-349. [9] J. Al-Dallal and P. Sorenson, “Testing Software Assets of Framework based Project Families,” During Application Engineering Stage Journal of Software, Vol. 3, No. 5, 2008, pp. 11-25. [10] S. A. Yahia, N. Koudas, A. Marian, D. Srivastava and D. Toman, “Structure and Content Scoring for XML,” Proceedings of the 31st VLDB Conference, Trondheim, August 2005, pp. 362-372. [11] T. S. Kin, J. H. Lee, J. W. Song and D. H. Kim, “Similarity Measurement of XML Documents Based on Structure and Contents,” International Conference on Computational Science (ICCS), Springer-Verlag, Heidelberg, 2007, pp. 902-905. [12] S. C. Haw and C. S. Lee, “Twing INLAB: A Decomposition-Matching—Mering Approach to Improving XML Query Processing,” American Journal of Applied Sciences, Vol. 5, No. 9, 2008, pp. 1199-1205. doi:10.3844/ajassp.2008.1199.1205 [13] V. Mihajlovic, G. Ramirez, T. WesterVeld, D. Hiemstra, H. E. Blok and A. P. deVries, “Vague Element Selection, Image Search, Overlap, and Relevance Feedback,” Lecture Notes in Computer Science, Vol. 3977, 2006, pp. 72-78. doi:10.1007/11766278_6 [14] P. O. Gilivie and J. Callan, “Parameter Estimation for a Sample Hierarchical Generative Model for XML Component Retrieval,” Lecture Notes in Computer Science, Vol. 3977, 2006, pp. 211-224. [15] B. Sigurbjournsson, J. Kamps and M. de Rijke, “The Effect of Structured Queries and Selective Indexing on XML Retrieval,” Lecture Notes in Computer Science, Vol. 3977, 2006, pp. 104-118. [16] B. Jeong, D. Lee, H. Cho and J. Lee, “A Novel Method for Measuring Semantic Similarity for XML Schema Matching,” Expert Systems with Applications, Vol. 24, 2008, pp. 1651-1658. doi:10.1016/j.eswa.2007.01.025 [17] H. Z. Wang, J. Z. Li, W. Wang and X. M. Lin, “Coding-Based Join Algorithm for Structure Queries on Graph-Structured XML Document,” World Wide Web, Vol. 11, No. 4, 2008, pp. 485-510. doi:10.1007/s11280-008-0050-4 [18] D. Ranjan and A. K. Tripathi, “Variablity-Based Models for Testablity Analysis of Frameworks,” Journal of Software Engineering and Applications, Vol. 3, No. 6, 2010, pp. 455-459. doi:10.4236/jsea.2010.35051 [19] D. D. Black, M. E. C. Hull and K. Jackson, “Systems Engineering and Safety-A Framework,” Software, Vol. 5, No. 1, 2011, pp. 43-53. [20] G. Butler, “Object-Oriented Frameworks,” 15th European Conference on Object-Oriented Programming, Tutorial Budapest, 18-22 June 2001, pp. 1-70. [21] J. Al-Dallal and D. Sorenson, “Estimating the Coverage of the Framework Application Reusable Cluster-Based Test Cases,” Information and Software Technology, Vol. 50, No. 6, 2008, pp. 595-604. doi:10.1016/j.infsof.2007.07.006 [22] T. Connolly and C. Begg, “Database Systems: A Practical Approach to Design, Implementation and Management,” Pearson Education, Upper Saddle River, 2004. [23] X. Wu and J. Feng, “A Framework and Implementation of Information Content Reasoning in a Database,” WSEAS Transactions on Information Science and Applications, Vol. 6, No. 4, 2009, pp. 579-588.