loading
Documents

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Domenico Amalfitano 1 ; Anna Rita Fasolino 1 ; Porfirio Tramontana 1 ; Vincenzo De Simone 1 ; Giancarlo Di Mare 2 and Stefano Scala 2

Affiliations: 1 Università Federico II, Italy ; 2 Fiat Group Automobiles S.p.A, Italy

ISBN: 978-989-758-035-2

Keyword(s): Information Extraction, Legacy Systems, Spreadsheets, Automotive

Abstract: Nevertheless spreadsheets were originally designed for computing purposes and for commercial applications, they are often used in industry to implement Information Systems, thanks to the functionalities offered by integrated scripting languages and ad-hoc frameworks (e.g., Visual Basic for Applications). This technological solution allows the adoption of Rapid Application Development processes for the quickly development of Spreadsheets-based Information Systems, but the resulting systems are quite difficult to be maintained and very difficult to be migrated to other architectures such as Database-oriented Informative Systems or Web applications. In this paper we present an approach for reverse engineering the data model from an Excel spreadsheet-based information system. The approach exploits a set of heuristic rules that are automatically applied in a seven-steps process. The applicability of the process has been shown in an industrial context where it was used to obtain the UML cl ass diagrams representing the conceptual data models of three spreadsheet-based information systems. (More)

PDF ImageFull Text

Download
CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 34.204.176.189

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
Amalfitano, D.; Fasolino, A.; Tramontana, P.; De Simone, V.; Di Mare, G. and Scala, S. (2014). Information Extraction from Legacy Spreadsheet-based Information System - An Experience in the Automotive Context.In Proceedings of 3rd International Conference on Data Management Technologies and Applications - Volume 1: KomIS, (DATA 2014) ISBN 978-989-758-035-2, pages 389-398. DOI: 10.5220/0005139603890398

@conference{komis14,
author={Domenico Amalfitano. and Anna Rita Fasolino. and Porfirio Tramontana. and Vincenzo De Simone. and Giancarlo Di Mare. and Stefano Scala.},
title={Information Extraction from Legacy Spreadsheet-based Information System - An Experience in the Automotive Context},
booktitle={Proceedings of 3rd International Conference on Data Management Technologies and Applications - Volume 1: KomIS, (DATA 2014)},
year={2014},
pages={389-398},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005139603890398},
isbn={978-989-758-035-2},
}

TY - CONF

JO - Proceedings of 3rd International Conference on Data Management Technologies and Applications - Volume 1: KomIS, (DATA 2014)
TI - Information Extraction from Legacy Spreadsheet-based Information System - An Experience in the Automotive Context
SN - 978-989-758-035-2
AU - Amalfitano, D.
AU - Fasolino, A.
AU - Tramontana, P.
AU - De Simone, V.
AU - Di Mare, G.
AU - Scala, S.
PY - 2014
SP - 389
EP - 398
DO - 10.5220/0005139603890398

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.