Patrick Koch
Current Organizations / Institutes
The organizations/institutes from the scholar's latest article
Previous Organizations / Institutes
The organizations / institutes from the scholar's other articles in the past ten years
Research Subjects
Patrick Koch has a total of 5 co-authors. Here are the top co-authors by number of shared publications:
- Birgit Hofer
Graz University of Technology, Austria
4 shared publications - Franz Wotawa
Graz University of Technology
4 shared publications - Dietmar Jannach
University of Klagenfurt, Klagenfurt, Austria
2 shared publications - Konstantin Schekotihin
Department of Artificial Intelligence and Cybersecurity, University of Klagenfurt, Klagenfurt, Austria
2 shared publications - Thomas Schmitz
TU Dortmund
1 shared publication
Latest Publications
- Open Access
- 4 October 2019
- Published by Institute of Electrical and Electronics Engineers (IEEE) in IEEE Transactions on Software Engineering
- Vol. 47 (10) , 2195-2207
Metric-Based Fault Prediction for Spreadsheets
Electronic spreadsheets are widely used in organizations for various data analytics and decision-making tasks. Even though faults within such spreadsheets are common and can have significant negative consequences, today's tools for creating and handling spreadsheets provide limited support for fault detection, localization, and repair. Being able to predict whether a certain part of a spreadsheet is faulty or not is often central for the implementation of such supporting functionality. In this work, we propose a novel approach to fault prediction in spreadsheet formulas, which combines an extensive catalog of spreadsheet metrics with modern machine learning algorithms. An analysis of the individual metrics from our catalog reveals that they are generally suited to discover a wide range of faults. Their predictive power is, however, limited when considered in isolation. Therefore, in our approach we apply supervised learning algorithms to obtain fault predictors that utilize all data provided by multiple spreadsheet metrics from our catalog. Experiments on different datasets containing faulty spreadsheets show that particularly Random Forests classifiers are often effective. As a result, the proposed method is in many cases able to make highly accurate predictions whether a given formula of a spreadsheet is faulty.
- 4 October 2019
- Published by Institute of Electrical and Electronics Engineers (IEEE) in IEEE Transactions on Software Engineering
- Vol. 47 (10) , 2195-2207
Open AccessMetric-Based Fault Prediction for Spreadsheets
Electronic spreadsheets are widely used in organizations for various data analytics and decision-making tasks. Even though faults within such spreadsheets are common and can have significant negative consequences, today's tools for creating and handling spreadsheets provide limited support for fault detection, localization, and repair. Being able to predict whether a certain part of a spreadsheet is faulty or not is often central for the implementation of such supporting functionality. In this work, we propose a novel approach to fault prediction in spreadsheet formulas, which combines an extensive catalog of spreadsheet metrics with modern machine learning algorithms. An analysis of the individual metrics from our catalog reveals that they are generally suited to discover a wide range of faults. Their predictive power is, however, limited when considered in isolation. Therefore, in our approach we apply supervised learning algorithms to obtain fault predictors that utilize all data provided by multiple spreadsheet metrics from our catalog. Experiments on different datasets containing faulty spreadsheets show that particularly Random Forests classifiers are often effective. As a result, the proposed method is in many cases able to make highly accurate predictions whether a given formula of a spreadsheet is faulty.
- Open Access
- 22 December 2018
- Published by Springer Nature in Automated Software Engineering
- Vol. 26 (1) , 203-239
Fragment-based spreadsheet debugging
- 22 December 2018
- Published by Springer Nature in Automated Software Engineering
- Vol. 26 (1) , 203-239
Open AccessFragment-based spreadsheet debugging
- Open Access
On the Refinement of Spreadsheet Smells by means of Structure Information
Spreadsheet users are often unaware of the risks imposed by poorly designed spreadsheets. One way to assess spreadsheet quality is to detect smells which attempt to identify parts of spreadsheets that are hard to comprehend or maintain and which are more likely to be the root source of bugs. Unfortunately, current spreadsheet smell detection techniques suffer from a number of drawbacks that lead to incorrect or redundant smell reports. For example, the same quality issue is often reported for every copy of a cell, which may overwhelm users. To deal with these issues, we propose to refine spreadsheet smells by exploiting inferred structural information for smell detection. We therefore first provide a detailed description of our static analysis approach to infer clusters and blocks of related cells. We then elaborate on how to improve existing smells by providing three example refinements of existing smells that incorporate information about cell groups and computation blocks. Furthermore, we propose three novel smell detection techniques that make use of the inferred spreadsheet structures. Empirical evaluation of the proposed techniques suggests that the refinements successfully reduce the number of incorrectly and redundantly reported smells, and novel deficits are revealed by the newly introduced smells.
Open AccessOn the Refinement of Spreadsheet Smells by means of Structure Information
Spreadsheet users are often unaware of the risks imposed by poorly designed spreadsheets. One way to assess spreadsheet quality is to detect smells which attempt to identify parts of spreadsheets that are hard to comprehend or maintain and which are more likely to be the root source of bugs. Unfortunately, current spreadsheet smell detection techniques suffer from a number of drawbacks that lead to incorrect or redundant smell reports. For example, the same quality issue is often reported for every copy of a cell, which may overwhelm users. To deal with these issues, we propose to refine spreadsheet smells by exploiting inferred structural information for smell detection. We therefore first provide a detailed description of our static analysis approach to infer clusters and blocks of related cells. We then elaborate on how to improve existing smells by providing three example refinements of existing smells that incorporate information about cell groups and computation blocks. Furthermore, we propose three novel smell detection techniques that make use of the inferred spreadsheet structures. Empirical evaluation of the proposed techniques suggests that the refinements successfully reduce the number of incorrectly and redundantly reported smells, and novel deficits are revealed by the newly introduced smells.
- 1 October 2016
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- Vol. 30, 167-174
Static Spreadsheet Analysis
Spreadsheets are the most prominent example of end-user programs. Unfortunately, spreadsheets often contain faults. In this paper, we propose a static analysis approach that can be used in a variety of spreadsheet quality assurance techniques. Our approach automatically detects groups of related formula cells and input cells, computation blocks, and the headers of the input and formula cells for a given spreadsheet. In the empirical evaluation, we show that 99% of the blocks of the investigated spreadsheets and more than 76% of the headers can be detected. Furthermore, we explain how the results of the static analysis approach can be used to improve existing spreadsheet smells and we propose four new spreadsheet smells.
- 1 October 2016
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- Vol. 30, 167-174
Static Spreadsheet Analysis
Spreadsheets are the most prominent example of end-user programs. Unfortunately, spreadsheets often contain faults. In this paper, we propose a static analysis approach that can be used in a variety of spreadsheet quality assurance techniques. Our approach automatically detects groups of related formula cells and input cells, computation blocks, and the headers of the input and formula cells for a given spreadsheet. In the empirical evaluation, we show that 99% of the blocks of the investigated spreadsheets and more than 76% of the headers can be detected. Furthermore, we explain how the results of the static analysis approach can be used to improve existing spreadsheet smells and we propose four new spreadsheet smells.