Graduate Project
 

Regression testing methodologies for spreadsheet languages

Öffentlich Deposited

Herunterladbarer Inhalt

PDF Herunterladen
https://ir.library.oregonstate.edu/concern/graduate_projects/rb68xm13m

Descriptions

Attribute NameValues
Creator
Abstract
  • Spreadsheet languages are widely used by end users for many different purposes. Previous research shows that spreadsheets often contain faults. To help end users test their spreadsheets, in previous research, a testing methodology for spreadsheets has been developed. Th.is methodology is supported by an automatic test case generation (ATCG) methodology. These methodologies help end users develop tests for their spreadsheets. After a spreadsheet is changed, however, it must be re-tested, and tests and debug information previously established for that spreadsheet are often still valuable for this retesting. This leads us to consider a regression testing methodology for spreadsheets, in which prior tests and test information are reused. Examining existing work on regression testing, however, we find that research in this field is directed at imperative languages and no discussion exists addressing regression testing for spreadsheet languages. To address this lack, in this project, we developed several regression testing methodologies for spreadsheet languages including two retest all approaches (which reuse an tests) and two selective retest approaches (which selectively reuse tests). We have prototyped our regression testing methodologies for spreadsheet languages and implemented them in the research spreadsheet language, Forms/3. Our methodologies support the incremental testing and regression testing of spreadsheets and operate seamlessly behind the scenes. To evaluate the feasibility of using our methodologies in retesting spreadsheets, we conducted a case study. The results of our study show that the two selective retest approaches were much more efficient than ATCG and the two retest all approaches, and they were also very effective. The results also suggest directions for future studies of our methodologies.
Resource Type
Date Issued
Degree Level
Degree Name
Degree Field
Degree Grantor
Commencement Year
Advisor
Committee Member
Academic Affiliation
Urheberrechts-Erklärung
Publisher
Peer Reviewed
Language

Beziehungen

Parents:

This work has no parents.

Artikel

Miniaturansicht Titel Hochladedatum Sichtbarkeit Aktionen
file details Jin_Dalai_2001_06_28.pdf 2023-02-03 Öffentlich Herunterladen