Data clone detection and visualization in spreadsheets

Proceedings - International Conference on Software Engineering

Volumn , Issue , 2013, Pages 292-301

  Hermans, Felienne ^a   Sedee, Ben ^a   Pinzger, Martin ^a   Van Deursen, Arie ^a  

^a DELFT UNIVERSITY OF TECHNOLOGY   (Netherlands)

Author keywords

clone detection; code smells; spreadsheet smells; spreadsheets

Indexed keywords

CLONE DETECTION; CLONE DETECTION ALGORITHMS; CODE SMELL; END USER PROGRAMMERS; ERROR PRONES; QUALITATIVE EVALUATIONS; QUANTITATIVE EVALUATION; SPREADSHEET ERRORS;

CLONING; DATA VISUALIZATION; ODORS; QUALITY CONTROL; SOFTWARE ENGINEERING;

SPREADSHEETS;

EID: 84883681660     PISSN: 02705257     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ICSE.2013.6606575     Document Type: Conference Paper

References (37)

1. L. Bradley and K. McDaid, "Using bayesian statistical methods to determine the level of error in large spreadsheets," in Proc. of ICSE '09, Companion Volume, 2009, pp. 351-354.
2. C. Scaffidi, M. Shaw, and B. A. Myers, "Estimating the numbers of end users and end user programmers," in Proc. of VL/HCC '05, 2005, pp. 207-214.
3. D. Bell and M. Parr, "Spreadsheets: A research agenda," SIGPLAN Notices, vol. 28, no. 9, pp. 26-28, 1993.
4. D. P. Ballou, H. L. Pazer, S. Belardo, and B. D. Klein, "Implication of data quality for spreadsheet analysis," DATA BASE, vol. 18, no. 3, pp. 13-19, 1987.
5. C. K. Roy, "Detection and analysis of near-miss software clones," in Proc. of ICSM '09, 2009, pp. 447-450.
6. J. H. Johnson, "Identifying redundancy in source code using fingerprints," in Proc. of CASCON '93, 1993, pp. 171-183.
7. M. Fisher and G. Rothermel, "The EUSES spreadsheet corpus: a shared resource for supporting experimentation with spreadsheet dependability mechanisms," ACM SIGSOFT Software Engineering Notes, vol. 30, no. 4, pp. 1-5, 2005.
8. P. O'Beirne, "Information and data quality in spreadsheets," in Proc. of Eusprig '08, 2008.
9. M. Bruntink, A. van Deursen, R. van Engelen, and T. Tourwé, "On the use of clone detection for identifying crosscutting concern code," TSE, vol. 31, no. 10, pp. 804-818, 2005.
10. S. Ducasse, M. Rieger, and S. Demeyer, "A language independent approach for detecting duplicated code," in Proc. of ICSM '99, 1999, pp. 109-118.
11. T. Kamiya, S. Kusumoto, and K. Inoue, "CCfinder: A multilinguistic token-based code clone detection system for large scale source code," TSE, vol. 28, no. 7, pp. 654-670, 2002.
12. B. S. Baker, "On finding duplication and near-duplication in large software systems," in Proc. of WCRE '95, 1995, pp. 86-95.
13. I. D. Baxter, A. Yahin, L. M. de Moura, M. Sant'Anna, and L. Bier, "Clone detection using abstract syntax trees," in Proc. of ICSM '98, 1998, pp. 368-377.
14. R. Komondoor and S. Horwitz, "Using slicing to identify duplication in source code," in Proc. of SAS '01, 2001, pp. 40-56.
15. J. Krinke, "Identifying similar code with program dependence graphs," in Proc. of WCRE '09, 2001, pp. 301-309.
16. C. K. Roy and J. R. Cordy, "Near-miss function clones in open source software: an empirical study," Journal of Software Maintenance, vol. 22, no. 3, pp. 165-189, 2010.
17. C. K. Roy, J. R. Cordy, and R. Koschke, "Comparison and evaluation of code clone detection techniques and tools: A qualitative approach," Science of Computer Programming, vol. 74, no. 7, pp. 470-495, 2009.
18. M. H. Alalfi, J. R. Cordy, T. R. Dean, M. Stephan, and A. Stevenson, "Models are code too: Near-miss clone detection for simulink models," in Proc. of ICSM '12, 2012, to appear.
19. M. Burnett, A. Sheretov, B. Ren, and G. Rothermel, "Testing homogeneous spreadsheet grids with the "what you see is what you test" methodology," TSE, vol. 28, no. 6, pp. 576-594, 2002.
20. N. Gold, J. Krinke, M. Harman, and D. Binkley, "Issues in clone classification for dataflow languages," in Proc. of IWSC '10, 2010, pp. 83-84.
21. F. Hermans, M. Pinzger, and A. van Deursen, "Supporting professional spreadsheet users by generating leveled dataflow diagrams," in Proc. of ICSE '11, 2011, pp. 451-460.
22. -, "Detecting and visualizing inter-worksheet smells in spreadsheets," in Proc of ICSE '12, 2012, pp. 441-451.
23. -, "Detecting code smells in spreadsheet formulas," in Proc of ICSM '12, 2012, to appear.
24. F. Hermans, "Exact and near-miss clone detection in spreadsheets," TinyToCS, vol. 1, no. 1, 2012.
25. J. Mayrand, C. Leblanc, and E. Merlo, "Experiment on the automatic detection of function clones in a software system using metrics," in Proc. of ICSM '96, 1996, pp. 244-.
26. E. J̈urgens, F. Deissenboeck, B. Hummel, and S. Wagner, "Do code clones matter?" in Proc. of ICSE '09, 2009, pp. 485-495.
27. C. J. Kapser and M. W. Godfrey, ""cloning considered harmful" considered harmful: patterns of cloning in software," Empirical Software Engineering, vol. 13, no. 6, pp. 645-692, 2008.
28. F. Hermans, M. Pinzger, and A. van Deursen, "Automatically extracting class diagrams from spreadsheets," in Proc. of ECOOP '10, 2010, pp. 52-75.
29. R. Abraham and M. Erwig, "Inferring templates from spreadsheets," in Proc. of ICSE '06, 2006, pp. 182-191.
30. J. Cunha, J. Saraiva, and J. Visser, "Discovery-based edit assistance for spreadsheets," in Proc. of VL/HCC '09, 2009, pp. 233-237.
31. B. Lagüe, D. Proulx, J. Mayrand, E. Merlo, and J. P. Hudepohl, "Assessing the benefits of incorporating function clone detection in a development process," in Proc. of ICSM '97, 1997, pp. 314-321.
32. R. Abraham and M. Erwig, "Header and unit inference for spreadsheets through spatial analyses," in Proc. of VL/HCC '04, 2004, pp. 165-172.
33. M. Erwig and M. M. Burnett, "Adding apples and oranges," in Proc. of PADL '02, 2002, pp. 173-191.
34. M. Godfrey and Q. Tu, "Tracking structural evolution using origin analysis," in Proc. of IWPSE '02, 2002, pp. 117-119.
35. L. Zou and M. W. Godfrey, "Detecting merging and splitting using origin analysis," in Proc. of WCRE '03, 2003, pp. 146-154.
36. M. Kim and D. Notkin, "Using a clone genealogy extractor for understanding and supporting evolution of code clones," in Proc. of MSR '05, 2005.
37. T. Bakota, "Tracking the evolution of code clones," in Proc. of SOFSEM '11, 2011, pp. 86-98.