Regression Testing of Database Applications
Database applications features such as Structured Query Language or SQL, exception programming, integrity constraints, and table triggers pose difficulties for maintenance activities; especially for regression testing that follows modifications to database applications. In this work, we address thes...
محفوظ في:
| المؤلف الرئيسي: | |
|---|---|
| مؤلفون آخرون: | , |
| التنسيق: | article |
| منشور في: |
2002
|
| الوصول للمادة أونلاين: | http://hdl.handle.net/10725/5191 http://libraries.lau.edu.lb/research/laur/terms-of-use/articles.php https://www.researchgate.net/profile/Ramzi_Haraty/publication/220373723_Regression_Testing_of_Database_Applications/links/5491446d0cf214269f27e7a5.pdf |
| الوسوم: |
إضافة وسم
لا توجد وسوم, كن أول من يضع وسما على هذه التسجيلة!
|
| _version_ | 1864513465364774912 |
|---|---|
| author | Haraty, Ramzi A. |
| author2 | Mansour, Nashat Daou, Bassel A. |
| author2_role | author author |
| author_facet | Haraty, Ramzi A. Mansour, Nashat Daou, Bassel A. |
| author_role | author |
| dc.creator.none.fl_str_mv | Haraty, Ramzi A. Mansour, Nashat Daou, Bassel A. |
| dc.date.none.fl_str_mv | 2002 2017-02-06T13:15:03Z 2017-02-06T13:15:03Z 2017-02-06 |
| dc.identifier.none.fl_str_mv | 1063-8016 http://hdl.handle.net/10725/5191 Haraty, R. A., Mansour, N., & Daou, B. A. (2002). Regression testing of database applications. Journal of Database Management, 13(2), 31-42 http://libraries.lau.edu.lb/research/laur/terms-of-use/articles.php https://www.researchgate.net/profile/Ramzi_Haraty/publication/220373723_Regression_Testing_of_Database_Applications/links/5491446d0cf214269f27e7a5.pdf |
| dc.language.none.fl_str_mv | en |
| dc.relation.none.fl_str_mv | Journal of Database Management |
| dc.rights.*.fl_str_mv | info:eu-repo/semantics/openAccess |
| dc.title.none.fl_str_mv | Regression Testing of Database Applications |
| dc.type.none.fl_str_mv | Article info:eu-repo/semantics/publishedVersion info:eu-repo/semantics/article |
| description | Database applications features such as Structured Query Language or SQL, exception programming, integrity constraints, and table triggers pose difficulties for maintenance activities; especially for regression testing that follows modifications to database applications. In this work, we address these difficulties and propose a two-phase regression testing methodology. In phase 1, we explore control flow and data flow analysis issues of database applications. Then, we propose an impact analysis technique that is based on dependencies that exist among the components of database applications. This analysis leads to selecting test cases from the initial test suite for regression testing the modified application. In phase 2, further reduction in the regression test cases is performed by using reduction algorithms. We present two such algorithms. The Graph Walk algorithm walks through the control flow graph of database modules and selects a safe set of test cases to retest. The Call Graph Firewall algorithm uses a firewall for the inter-procedural level. Finally, a maintenance environment for database applications is described. Our experience with this regression testing methodology shows that the impact analysis technique is adequate for selecting regression tests and that phase 2 techniques can be used for further reduction in the number of theses tests. |
| eu_rights_str_mv | openAccess |
| format | article |
| id | LAURepo_601a4885bbb497a7d8c8a6449e9a87af |
| identifier_str_mv | 1063-8016 Haraty, R. A., Mansour, N., & Daou, B. A. (2002). Regression testing of database applications. Journal of Database Management, 13(2), 31-42 |
| language_invalid_str_mv | en |
| network_acronym_str | LAURepo |
| network_name_str | Lebanese American University repository |
| oai_identifier_str | oai:laur.lau.edu.lb:10725/5191 |
| publishDate | 2002 |
| repository.mail.fl_str_mv | |
| repository.name.fl_str_mv | |
| repository_id_str | |
| spelling | Regression Testing of Database ApplicationsHaraty, Ramzi A.Mansour, NashatDaou, Bassel A.Database applications features such as Structured Query Language or SQL, exception programming, integrity constraints, and table triggers pose difficulties for maintenance activities; especially for regression testing that follows modifications to database applications. In this work, we address these difficulties and propose a two-phase regression testing methodology. In phase 1, we explore control flow and data flow analysis issues of database applications. Then, we propose an impact analysis technique that is based on dependencies that exist among the components of database applications. This analysis leads to selecting test cases from the initial test suite for regression testing the modified application. In phase 2, further reduction in the regression test cases is performed by using reduction algorithms. We present two such algorithms. The Graph Walk algorithm walks through the control flow graph of database modules and selects a safe set of test cases to retest. The Call Graph Firewall algorithm uses a firewall for the inter-procedural level. Finally, a maintenance environment for database applications is described. Our experience with this regression testing methodology shows that the impact analysis technique is adequate for selecting regression tests and that phase 2 techniques can be used for further reduction in the number of theses tests.PublishedN/A2017-02-06T13:15:03Z2017-02-06T13:15:03Z20022017-02-06Articleinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/article1063-8016http://hdl.handle.net/10725/5191Haraty, R. A., Mansour, N., & Daou, B. A. (2002). Regression testing of database applications. Journal of Database Management, 13(2), 31-42http://libraries.lau.edu.lb/research/laur/terms-of-use/articles.phphttps://www.researchgate.net/profile/Ramzi_Haraty/publication/220373723_Regression_Testing_of_Database_Applications/links/5491446d0cf214269f27e7a5.pdfenJournal of Database Managementinfo:eu-repo/semantics/openAccessoai:laur.lau.edu.lb:10725/51912021-03-19T10:00:53Z |
| spellingShingle | Regression Testing of Database Applications Haraty, Ramzi A. |
| status_str | publishedVersion |
| title | Regression Testing of Database Applications |
| title_full | Regression Testing of Database Applications |
| title_fullStr | Regression Testing of Database Applications |
| title_full_unstemmed | Regression Testing of Database Applications |
| title_short | Regression Testing of Database Applications |
| title_sort | Regression Testing of Database Applications |
| url | http://hdl.handle.net/10725/5191 http://libraries.lau.edu.lb/research/laur/terms-of-use/articles.php https://www.researchgate.net/profile/Ramzi_Haraty/publication/220373723_Regression_Testing_of_Database_Applications/links/5491446d0cf214269f27e7a5.pdf |