TY - GEN
T1 - From relational ClassSheets to UML+OCL
AU - Cunha, Jácome
AU - Fernandes, João Paulo
AU - Saraiva, João
PY - 2012
Y1 - 2012
N2 - 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.
AB - 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.
KW - ClassSheets
KW - OCL
KW - spreadsheets
KW - UML
UR - http://www.scopus.com/inward/record.url?scp=84863587317&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=84863587317&partnerID=8YFLogxK
U2 - 10.1145/2245276.2231957
DO - 10.1145/2245276.2231957
M3 - Conference contribution
AN - SCOPUS:84863587317
SN - 9781450308571
T3 - Proceedings of the ACM Symposium on Applied Computing
SP - 1151
EP - 1158
BT - 27th Annual ACM Symposium on Applied Computing, SAC 2012
T2 - 27th Annual ACM Symposium on Applied Computing, SAC 2012
Y2 - 26 March 2012 through 30 March 2012
ER -