Publicação
Model-based programming environments for spreadsheets
| Resumo: | Spreadsheets can be seen as a flexible programming environment. However, they lack some of the concepts of regular programming languages, such as structured data types. This can lead the user to edit the spreadsheet in a wrong way and perhaps cause corrupt or redundant data. We devised a method for extraction of a relational model from a spreadsheet and the subsequent embedding of the model back into the spreadsheet to create a model-based spreadsheet programming environment. The extraction algorithm is specific for spreadsheets since it considers particularities such as layout and column arrangement. The extracted model is used to generate formulas and visual elements that are then embedded in the spreadsheet helping the user to edit data in a correct way. We present preliminary experimental results from applying our approach to a sample of spreadsheets from the EUSES Spreadsheet Corpus. Finally, we conduct the first systematic empirical study to assess the effectiveness and efficiency of this approach. A set of spreadsheet end users worked with two different model-based spreadsheets, and we present and analyze here the results achieved. |
|---|---|
| Autores principais: | Cunha, Jácome Miguel Costa |
| Outros Autores: | Mendes, Jorge; Saraiva, João Alexandre; Visser, Joost |
| Assunto: | Spreadsheets Model-driven engineering Model-driven spreadsheets Empirical validation |
| Ano: | 2014 |
| País: | Portugal |
| Tipo de documento: | artigo |
| Tipo de acesso: | acesso aberto |
| Instituição associada: | Universidade do Minho |
| Idioma: | inglês |
| Origem: | RepositóriUM - Universidade do Minho |
| _version_ | 1867438209706754048 |
|---|---|
| author | Cunha, Jácome Miguel Costa |
| author2 | Mendes, Jorge Saraiva, João Alexandre Visser, Joost |
| author2_role | author author author |
| author_facet | Cunha, Jácome Miguel Costa Mendes, Jorge Saraiva, João Alexandre Visser, Joost |
| author_role | author |
| contributor_name_str_mv | RepositóriUM - Universidade do Minho |
| country_str | PT |
| creators_json_txt | [{\"Person.name\":\"Cunha, Jácome Miguel Costa\"},{\"Person.name\":\"Mendes, Jorge\"},{\"Person.name\":\"Saraiva, João Alexandre\"},{\"Person.name\":\"Visser, Joost\"}] |
| datacite.contributors.contributor.contributorName.fl_str_mv | RepositóriUM - Universidade do Minho |
| datacite.creators.creator.creatorName.fl_str_mv | Cunha, Jácome Miguel Costa Mendes, Jorge Saraiva, João Alexandre Visser, Joost |
| datacite.date.Accepted.fl_str_mv | 2014-01-01T00:00:00Z |
| datacite.date.available.fl_str_mv | 2015-04-07T14:49:27Z |
| datacite.date.embargoed.fl_str_mv | 2015-04-07T14:49:27Z |
| datacite.rights.fl_str_mv | http://purl.org/coar/access_right/c_abf2 |
| datacite.subjects.subject.fl_str_mv | Spreadsheets Model-driven engineering Model-driven spreadsheets Empirical validation |
| datacite.titles.title.fl_str_mv | Model-based programming environments for spreadsheets |
| dc.contributor.none.fl_str_mv | RepositóriUM - Universidade do Minho |
| dc.creator.none.fl_str_mv | Cunha, Jácome Miguel Costa Mendes, Jorge Saraiva, João Alexandre Visser, Joost |
| dc.date.Accepted.fl_str_mv | 2014-01-01T00:00:00Z |
| dc.date.available.fl_str_mv | 2015-04-07T14:49:27Z |
| dc.date.embargoed.fl_str_mv | 2015-04-07T14:49:27Z |
| dc.format.none.fl_str_mv | application/pdf |
| dc.identifier.none.fl_str_mv | https://hdl.handle.net/1822/34740 |
| dc.language.none.fl_str_mv | eng |
| dc.publisher.none.fl_str_mv | Elsevier Science |
| dc.rights.none.fl_str_mv | http://purl.org/coar/access_right/c_abf2 |
| dc.subject.none.fl_str_mv | Spreadsheets Model-driven engineering Model-driven spreadsheets Empirical validation |
| dc.title.fl_str_mv | Model-based programming environments for spreadsheets |
| dc.type.none.fl_str_mv | http://purl.org/coar/resource_type/c_6501 |
| description | Spreadsheets can be seen as a flexible programming environment. However, they lack some of the concepts of regular programming languages, such as structured data types. This can lead the user to edit the spreadsheet in a wrong way and perhaps cause corrupt or redundant data. We devised a method for extraction of a relational model from a spreadsheet and the subsequent embedding of the model back into the spreadsheet to create a model-based spreadsheet programming environment. The extraction algorithm is specific for spreadsheets since it considers particularities such as layout and column arrangement. The extracted model is used to generate formulas and visual elements that are then embedded in the spreadsheet helping the user to edit data in a correct way. We present preliminary experimental results from applying our approach to a sample of spreadsheets from the EUSES Spreadsheet Corpus. Finally, we conduct the first systematic empirical study to assess the effectiveness and efficiency of this approach. A set of spreadsheet end users worked with two different model-based spreadsheets, and we present and analyze here the results achieved. |
| dirty | 0 |
| eu_rights_str_mv | openAccess |
| format | article |
| fulltext.url.fl_str_mv | https://repositorium.uminho.pt/bitstreams/788bebc9-6c23-498b-8120-e8e8a9ad0bbe/download |
| id | rum_f88198d0f44c61e0b4e310d6d007aa93 |
| identifier.url.fl_str_mv | https://hdl.handle.net/1822/34740 |
| instacron_str | repositorium |
| institution | Universidade do Minho |
| instname_str | Universidade do Minho |
| language | eng |
| network_acronym_str | rum |
| network_name_str | RepositóriUM - Universidade do Minho |
| oai_identifier_str | oai:repositorium.uminho.pt:1822/34740 |
| organization_str_mv | urn:organizationAcronym:repositorium |
| person_str_mv | Cunha, Jácome Miguel Costa Mendes, Jorge Saraiva, João Alexandre Visser, Joost |
| publishDate | 2014 |
| publisher.none.fl_str_mv | Elsevier Science |
| reponame_str | RepositóriUM - Universidade do Minho |
| repository_id_str | urn:repositoryAcronym:rum |
| service_str_mv | urn:repositoryAcronym:rum |
| spelling | engElsevier ScienceporSpreadsheets can be seen as a flexible programming environment. However, they lack some of the concepts of regular programming languages, such as structured data types. This can lead the user to edit the spreadsheet in a wrong way and perhaps cause corrupt or redundant data. We devised a method for extraction of a relational model from a spreadsheet and the subsequent embedding of the model back into the spreadsheet to create a model-based spreadsheet programming environment. The extraction algorithm is specific for spreadsheets since it considers particularities such as layout and column arrangement. The extracted model is used to generate formulas and visual elements that are then embedded in the spreadsheet helping the user to edit data in a correct way. We present preliminary experimental results from applying our approach to a sample of spreadsheets from the EUSES Spreadsheet Corpus. Finally, we conduct the first systematic empirical study to assess the effectiveness and efficiency of this approach. A set of spreadsheet end users worked with two different model-based spreadsheets, and we present and analyze here the results achieved.application/pdfporModel-based programming environments for spreadsheetsCunha, Jácome Miguel CostaMendes, JorgeSaraiva, João AlexandreVisser, JoostHostingInstitutionOrganizationalRepositóriUM - Universidade do Minhoe-mailmailto:repositorium@usdb.uminho.ptrepositorium@usdb.uminho.ptCITATIONCunha, J., Mendes, J., Saraiva, J., & Visser, J. (2014). Model-based programming environments for spreadsheets. Science of Computer Programming.ISSNIsPartOf0167-6423DOIIsPartOf10.1016/j.scico.2014.02.0022015-04-07T14:49:27Z20142014-01-01T00:00:00ZHandlehttps://hdl.handle.net/1822/34740http://purl.org/coar/access_right/c_abf2open accessSpreadsheetsModel-driven engineeringModel-driven spreadsheetsEmpirical validation804122 bytesliteraturehttp://purl.org/coar/resource_type/c_6501journal articlehttp://purl.org/coar/access_right/c_abf2application/pdffulltexthttps://repositorium.uminho.pt/bitstreams/788bebc9-6c23-498b-8120-e8e8a9ad0bbe/download |
| spellingShingle | Model-based programming environments for spreadsheets Cunha, Jácome Miguel Costa Spreadsheets Model-driven engineering Model-driven spreadsheets Empirical validation |
| status | SINGLETON |
| subject.fl_str_mv | Spreadsheets Model-driven engineering Model-driven spreadsheets Empirical validation |
| title | Model-based programming environments for spreadsheets |
| title_full | Model-based programming environments for spreadsheets |
| title_fullStr | Model-based programming environments for spreadsheets |
| title_full_unstemmed | Model-based programming environments for spreadsheets |
| title_short | Model-based programming environments for spreadsheets |
| title_sort | Model-based programming environments for spreadsheets |
| topic | Spreadsheets Model-driven engineering Model-driven spreadsheets Empirical validation |
| topic_facet | Spreadsheets Model-driven engineering Model-driven spreadsheets Empirical validation |
| url | https://hdl.handle.net/1822/34740 |
| visible | 1 |