Abstract
Spreadsheets are widely used to support software development activities. They have been used to collect requirements and software defects, to capture traceability information between requirements and test cases, and in general, to fill in gaps that are not covered satisfactorily by more specialised tools. Despite their widespread use, spreadsheets have received little attention from researchers in the field of Model Driven Engineering. In this paper, we argue for the usefulness of model management support for querying and modifying spreadsheets, we identify the conceptual gap between contemporary model management languages and spreadsheets, and we propose an approach for bridging it. We present a prototype that builds atop the Epsilon and Google Drive platforms and we evaluate the proposed approach through a case study that involves validating and transforming software requirements captured using spreadsheets.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Firesmith, D.: Common requirements problems, their negative consequences, and industry best practices to help solve them. Journal of Object Technology 6, 17–33 (2007)
Steinberg, D., Budinsky, F., Paternostro, M., Merks, E.: EMF: Eclipse Modelling Framework, 2nd edn. Eclipse Series. Addison-Wesley Professional (December 2008)
Kolovos, D.S., Rose, L.M., Williams, J., Matragkas, N., Paige, R.F.: A lightweight approach for managing xml documents with mde languages. In: Vallecillo, A., Tolvanen, J.-P., Kindler, E., Störrle, H., Kolovos, D. (eds.) ECMFA 2012. LNCS, vol. 7349, pp. 118–132. Springer, Heidelberg (2012)
Jouault, F., Kurtev, I.: Transforming Models with ATL. In: Bruel, J.-M. (ed.) MoDELS 2005. LNCS, vol. 3844, pp. 128–138. Springer, Heidelberg (2006)
Muller, P.-A., Fleurey, F., Jézéquel, J.-M.: Weaving executability into object-oriented meta-languages. In: Briand, L.C., Williams, C. (eds.) MoDELS 2005. LNCS, vol. 3713, pp. 264–278. Springer, Heidelberg (2005)
Kolovos, D.S., Paige, R.F., Polack, F.A.C.: The Epsilon Object Language (EOL). In: Rensink, A., Warmer, J. (eds.) ECMDA-FA 2006. LNCS, vol. 4066, pp. 128–142. Springer, Heidelberg (2006)
Eclipse Foundation. Epsilon Modeling GMT component, http://www.eclipse.org/gmt/epsilon
Sun Microsystems. Meta Data Repository, http://mdr.netbeans.org
Woodcock, J., Davies, J.: Using Z: Specification, Refinement, and Proof. Prentice Hall (March 1996)
Community Z Tools, http://czt.sourceforge.net
The Apache Ant Project, http://ant.apache.org
Kolovos, D.S., Paige, R.F., Polack, F.A.C.: A Framework for Composing Modular and Interoperable Model Management Tasks. In: Proc. Workshop on Model Driven Tool and Process Integration (MDTPI), ECMDA, Berlin, Germany (June 2008)
OMG, Systems Modeling Language, SysML (2012), http://www.omg.org/spec/SysML/1.3/PDF/
Graphviz - Graph Visualization Software, Official Web-Site, http://www.graphviz.org
Hermans, F., Pinzger, M., van Deursen, A.: Detecting and visualizing inter-worksheet smells in spreadsheets. In: ICSE, pp. 441–451. IEEE (2012)
Raymond, R.: Panko. Spreadsheet Errors: What We Know. What We Think We Can Do. In: Proceedings of the Spreadsheet Risk Symposium, European Spreadsheet Risks Interest Group (EuSpRIG) (July 2000)
Engels, G., Erwig, M.: Classsheets: automatic generation of spreadsheet applications from object-oriented specifications. In: Proceedings of the 20th IEEE/ACM International Conference on Automated Software Engineering, ASE 2005, pp. 124–133. ACM, New York (2005)
Rothermel, G., Burnett, M., Li, L., Dupuis, C., Sheretov, A.: A methodology for testing spreadsheets. ACM Trans. Softw. Eng. Methodol. 10(1), 110–147 (2001)
Prabhakararao, S., Cook, C., Ruthruff, J., Creswick, E., Main, M., Durham, M., Burnett, M.: Strategies and behaviors of end-user programmers with interactive fault localization. In: Proceedings of the 2003 IEEE Symposium on Human Centric Computing Languages and Environments, HCC 2003, pp. 15–22. IEEE Computer Society, Washington, DC (2003)
Burnett, M., Cook, C., Pendse, O., Rothermel, G., Summet, J., Wallace, C.: End-user software engineering with assertions in the spreadsheet paradigm. In: Proceedings of the 25th International Conference on Software Engineering, ICSE 2003, pp. 93–103. IEEE Computer Society, Washington, DC (2003)
Sajaniemi, J.: Modeling spreadsheet audit: A rigorous approach to automatic visualization. Journal of Visual Languages & Computing 11(1), 49–82 (2000)
Cunha, J., Fernandes, J.P., Ribeiro, H., Saraiva, J.: Mdsheet: A framework for model-driven spreadsheet engineering. In: 34th International Conference on Software Engineering (ICSE), pp. 1395–1398 (June 2012)
Cunha, J., Fernandes, J.P., Ribeiro, H., Saraiva, J.: A bidirectional model-driven spreadsheet environment. In: 2012 34th International Conference on Software Engineering (ICSE), pp. 1443–1444 (June 2012)
Cunha, J., Fernandes, J.P., Ribeiro, H., Saraiva, J.: Towards a catalog of spreadsheet smells. In: Murgante, B., Gervasi, O., Misra, S., Nedjah, N., Rocha, A.M.A.C., Taniar, D., Apduhan, B.O. (eds.) ICCSA 2012, Part IV. LNCS, vol. 7336, pp. 202–216. Springer, Heidelberg (2012)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Francis, M., Kolovos, D.S., Matragkas, N., Paige, R.F. (2013). Adding Spreadsheets to the MDE Toolkit. In: Moreira, A., Schätz, B., Gray, J., Vallecillo, A., Clarke, P. (eds) Model-Driven Engineering Languages and Systems. MODELS 2013. Lecture Notes in Computer Science, vol 8107. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-41533-3_3
Download citation
DOI: https://doi.org/10.1007/978-3-642-41533-3_3
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-41532-6
Online ISBN: 978-3-642-41533-3
eBook Packages: Computer ScienceComputer Science (R0)