HOME
Full Articles List
Search by Author
Title: MICROTOOLS BASED ON THE RELATIONAL DATA MODEL ? REPRESENTATION OF ENTITIES IN A SPREADSHEET
BibTex 
Open this article in the author's DB |
|
MICROTOOLS BASED ON THE RELATIONAL DATA MODEL ? REPRESENTATION OF ENTITIES IN A SPREADSHEET
|
|
|
|
|
|
|
|
||
|
|
|
|
|
|
1314-2704
|
|
|
|
||
|
|
English
|
|
|
|
17
|
|
|
|
21
|
|
|
|
|
|
|
|
||
|
|
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.
|
|
|
|
conference
|
|
|
|
||
|
|
||
|
|
17th International Multidisciplinary Scientific GeoConference SGEM 2017
|
|
|
|
17th International Multidisciplinary Scientific GeoConference SGEM 2017, 29 June - 5 July, 2017
|
|
|
|
Proceedings Paper
|
|
|
|
STEF92 Technology
|
|
|
|
International Multidisciplinary Scientific GeoConference-SGEM
|
|
|
|
Bulgarian Acad Sci; Acad Sci Czech Republ; Latvian Acad Sci; Polish Acad Sci; Russian Acad Sci; Serbian Acad Sci & Arts; Slovak Acad Sci; Natl Acad Sci Ukraine; Natl Acad Sci Armenia; Sci Council Japan; World Acad Sci; European Acad Sci, Arts & Letters; Ac
|
|
|
|
447-454
|
|
|
|
29 June - 5 July, 2017
|
|
|
|
website
|
|
|
|
cdrom
|
|
|
|
2985
|
|
|
|
relational data model; spreadsheet; computer-based process support; process improvement; information processes
|
|
Download PDF