Towards a Framework for Information System Testing - A Model-driven Testing Approach

Federico Toledo Rodríguez, Beatriz Perez, Macario Polo Usaola


Testing has an important role within the development of a software system; the automation of testing tasks has been largely used with the goal of minimizing costs and increasing productivity. For some of those tasks –as it is the execution of test cases– well-known solutions already exist as the industry adopted them many years ago. This is not the case with test data generation, and even less for software that uses databases, where this task is particularly complex. In the present work we propose to generate test cases automatically to test information systems that use relational databases. We represent the data model with UML Data Modeling Profile, automatically extracted from the database with reverse engineering techniques. Then, applying model-driven testing, test cases are generated from the data model, represented with the standard UML Testing Profile. The test case generation also includes test data inputs, in order to accomplish certain coverage criteria defined on the schema.


  1. Alalfi, M. H., Cordy, J. R. & Dean, T. R. 2008. SQL2XMI: Reverse Engineering of UML-ER Diagrams from Relational Database Schemas. Working Conference on Reverse Engineering. IEEE Computer Society.
  2. Andrews, A., France, R., Ghosh, S. & Craig, G. 2003. Test adequacy criteria for UML design models. Software Testing, Verification and Reliability, 13, 95-127.
  3. Arasu, A., Kaushik, R. & Li, J. 2011. Data generation using declarative constraints. International conference on Management of data. ACM.
  4. Cornett. 2004. Code Coverage Analysis [Online]. Available: [Accessed 2012].
  5. Chays, D. & Deng, Y. 2003. Demonstration of AGENDA tool set for testing relational database applications. IEEE Computer Society.
  6. Chilenski, J. J. & Miller, S. P. 1994. Applicability of modified condition/decision coverage to software testing. Software Engineering Journal, 9, 193-200.
  7. Emmi, M., Majumdar, R. & Sen, K. 2007. Dynamic test input generation for database applications. ISSTA'07: Software Testing and Analysis.
  8. Fewster, M. & Graham, D. 1999. Software test automation: effective use of test execution tools, ACM Press/Addison-Wesley Publishing Co.
  9. García-Rodríguez, I., Polo, M. & Piattini, M. 2007. Using Model-Driven Pattern Matching to derive functionalities in Models. SEKE - Software Engineering and Knowledge Engineering
  10. García Rodríguez De Guzmán, I. 2007. Pressweb: un proceso para la reingeniería de sistemas heredados hacia servicios web. UCLM.
  11. Gornik, D. 2002. UML Data Modeling Profile. IBM, Rational Software.
  12. Haller, K. 2009. White-box testing for database-driven applications: A requirements analysis. ACM.
  13. Koomen, T., Van Der Aalst, L., Broekman, B. & Vroon, M. 2006. TMap Next, for result-driven testing, UTN Publishers.
  14. Neufeld, A., Moerkotte, G. & Loekemann, P. C. 1993. Generating consistent test data: Restricting the search space by a generator formula. The VLDB Journal, 2, 173-213.
  15. Omg 2005. Meta Object Facility 2.0 Query/View/Transformation Specification.
  16. Omg 2008. MOF Model to Text Transformation Language (MOFM2T), 1.0.
  17. Pérez-Castillo, R., García-Rodríguez De Guzmán, I., Caballero, I. & Piattini, M. 2012. Software Modernization by Recovering Web Services from Legacy Databases. Journal of Software: Evolution and Process, In Press.
  18. Pérez Lamancha, B., Mateo, P. R., Polo Usaola, M. & Caivano, D. 2011. Model-driven Testing - Transformations from Test Models to Test Code. ENASE. SciTePress.
  19. Polo, M., García-Rodríguez, I. & Piattini, M. 2007a. An MDA-based approach for database re-engineering. Journal of Software Maintenance and Evolution: Research and Practice, 19, 383-417.
  20. Polo, M., Tendero, S. & Piattini, M. 2007b. Integrating techniques and tools for testing automation. Software Testing Verification and Reliability, 17, 3-39.
  21. Sparks, G. 2001. Database modeling in UML. Methods & Tools.
  22. Tuya, J., Suárez-Cabal, M. J. & De La Riva, C. 2010. Full predicate coverage for testing SQL database queries. Software Testing Verification and Reliability, 20, 237- 288.
  23. Yin, S. & Ray, I. 2005. Relational database operations modeling with UML. AINA'05: Advanced Information Networking and Applications.
  24. Zielinski, K. & Szmuc, T. 2005. Data Modeling with UML 2.0. Frontiers in Artificial Intelligence and Applications, 63.

Paper Citation

in Harvard Style

Toledo Rodríguez F., Perez B. and Polo Usaola M. (2012). Towards a Framework for Information System Testing - A Model-driven Testing Approach . In Proceedings of the 7th International Conference on Software Paradigm Trends - Volume 1: ICSOFT, ISBN 978-989-8565-19-8, pages 172-177. DOI: 10.5220/0004067801720177

in Bibtex Style

author={Federico Toledo Rodríguez and Beatriz Perez and Macario Polo Usaola},
title={Towards a Framework for Information System Testing - A Model-driven Testing Approach},
booktitle={Proceedings of the 7th International Conference on Software Paradigm Trends - Volume 1: ICSOFT,},

in EndNote Style

JO - Proceedings of the 7th International Conference on Software Paradigm Trends - Volume 1: ICSOFT,
TI - Towards a Framework for Information System Testing - A Model-driven Testing Approach
SN - 978-989-8565-19-8
AU - Toledo Rodríguez F.
AU - Perez B.
AU - Polo Usaola M.
PY - 2012
SP - 172
EP - 177
DO - 10.5220/0004067801720177