From relational ClassSheets to UML+OCL

• Type: Article in International Conference Proceedings Book
• Date: 2012

Authors

Cunha, J (Author) Other; Joao Paulo Fernandes (Author) FEUP; Saraiva, J (Author) Other

Conference proceedings International

Title: Proceedings of the ACM Symposium on Applied Computing

Pages: 1151-1158

27th Annual ACM Symposium on Applied Computing, SAC 2012

Trento, 26 March 2012 through 30 March 2012

Indexing

Scopus - 17 Citations

Scientific classification

FOS: Engineering and technology > Electrical engineering, Electronic engineering, Information engineering

Other information

Authenticus ID: P-008-4S6

DOI: 10.1145/2245276.2231957

Abstract (EN): Spreadsheets are among the most popular programming languages in the world. Unfortunately, spreadsheet systems were not tailored from scratch with modern programming language features that guarantee, as much as possible, program correctness. As a consequence, spreadsheets are populated with unacceptable amounts of errors. In other programming language settings, model-based approaches have been proposed to increase productivity and program effectiveness. Within spreadsheets, this approach has also been followed, namely by ClassSheets. In this paper, we propose an extension to ClassSheets to allow the specification of spreadsheets that can be viewed as relational databases. Moreover, we present a transformation from ClassSheet models to UML class diagrams enriched with OCL constraints. This brings to the spreadsheet realm the entire paraphernalia of model validation techniques that are available for UML. © 2012 ACM.

Language: English

Type (Professor's evaluation): Scientific