DBPapers
DOI: 10.5593/sgem2017/21/S07.057

MICROTOOLS BASED ON THE RELATIONAL DATA MODEL – REPRESENTATION OF ENTITIES IN A SPREADSHEET

B. Szczesniak
Wednesday 13 September 2017 by Libadmin2017

References: 17th International Multidisciplinary Scientific GeoConference SGEM 2017, www.sgem.org, SGEM2017 Conference Proceedings, ISBN 978-619-7408-01-0 / ISSN 1314-2704, 29 June - 5 July, 2017, Vol. 17, Issue 21, 447-454 pp, DOI: 10.5593/sgem2017/21/S07.057

ABSTRACT

Despite the common application of a wide variety of IT solutions in organisations, one may relatively frequently come across processes under which information is manually processed by employees, and even if specific IT tools are used for the processing, the extent of operations conducted manually remains considerable. In numerous cases, similar processes may be supported by tools created using spreadsheets. Such tools can be developed by means of a rather narrow array of embedded spreadsheet features and mechanisms by following the author’s signature concept referred to as Microtools Based on the Relational Data Model. This article addresses two available methods for implementation of entities identified beforehand, at the data model development stage, in a spreadsheet with reference to a problem being analysed. The choice of an approach is one of the most fundamental decisions to be made while creating such tools. Each of the methods in question has been illustrated using an adequate example. Both their advantages and disadvantages have been discussed along with solutions enabling automatic migration of data between the two systems proposed.

Keywords: relational data model, spreadsheet, computer-based process support, process improvement, information processes

Home | Contact | Site Map | Site statistics | Visitors : 1 / 353063

Follow site activity en  Follow site activity INFORMATICS  Follow site activity Papers SGEM2017   ?

CrossRef Member    Indexed in ISI Web Of Knowledge   Indexed in ISI Web Of Knowledge
   

© Copyright 2001 International Multidisciplinary Scientific GeoConference & EXPO SGEM. All Rights Reserved.

Creative Commons License