From relational ClassSheets to UML+OCL

Jácome Cunha, João Paulo Fernandes, João Saraiva
2012 Proceedings of the 27th Annual ACM Symposium on Applied Computing - SAC '12  
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
more » ... o 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.
doi:10.1145/2245276.2231957 dblp:conf/sac/CunhaFS12 fatcat:afwtuawuafehhddh33udqxxgf4