Search-Based Detection of Deviation Failures in the Migration of Legacy Spreadsheet Applications

by M. Mohammad Almasi, Hadi Hemmati, Gordon Fraser, Phil McMinn, and Janis Benefelds

International Conference on Software Testing and Analysis (ISSTA 2018)



Many legacy financial applications exist as a collection of formulas implemented in spreadsheets. Migration of these spreadsheets to a full-fledged system, written in a language such as Java, is an error-prone process. While small differences in the outputs of numerical calculations from the two systems are inevitable and tolerable, large discrepancies can have serious financial implications. Such discrepancies are likely due to faults in the migrated implementation, and are referred to as deviation failures. In this paper, we present a search-based technique that seeks to reveal deviation failures automatically. We evaluate different variants of this approach on two financial applications ... [more]


Reference

M. Mohammad Almasi, Hadi Hemmati, Gordon Fraser, Phil McMinn, and Janis Benefelds. Search-Based Detection of Deviation Failures in the Migration of Legacy Spreadsheet Applications. International Conference on Software Testing and Analysis (ISSTA 2018), pp. 266–275, 2018


Bibtex Entry
@inproceedings{Almasi2018,
  author    = "Almasi, M. Mohammad and Hemmati, Hadi and Fraser, Gordon and McMinn, Phil and Benefelds, Janis",
  title     = "Search-Based Detection of Deviation Failures in the Migration of Legacy Spreadsheet Applications",
  booktitle = "International Conference on Software Testing and Analysis (ISSTA 2018)",
  pages     = "266--275",
  year      = "2018",
  publisher = "ACM"
}