Scholarly record
MICROTOOLS BASED ON THE RELATIONAL DATA MODEL - REPRESENTATION OF ENTITIES IN A SPREADSHEET
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.
Publication Impact Profile
Publication details
References14
Gajdzik B.,Sitko J., An analysis of the causes of complaints about steel sheets in metallurgical product quality management systems, Metalurgija, 2014 vol. 53 iss. 1, pp. 135-138
Restecka M., Wolniak R., IT systems in aid of welding processes quality management in the automotive industry, Archives of Metallurgy and Materials, 2016, vol. 61 iss. 4, pp. 1785-1792
Loska A., Remarks about modelling of maintenance processes with the use of scenario techniques, Eksploatacja i Niezawodnosc – Maintenance and Reliability, 2012, vol. 14, no 2, pp. 92-98
M. Zasadzien, K. Midor, Innovative application of quality management tools in a hard coal mine, 15th International Multidisciplinary Scientific GeoConference SGEM 2015, www.sgem.org, SGEM2015 Conference Proceedings, ISBN 978-619-7105-33-9 / ISSN 1314-2704, June 18-24, 2015, Book1 vol. 3, 415-422 pp
Oleński J., Ekonomika informacji. Podstawy, PWE, Warsaw, 2001
Oleński J., Ekonomika informacji. Metody, PWE, Warsaw, 2002
Carlberg C., Business Analysis with Microsoft Excel (3rd Edition), Que Publishing, Indianapolis 2007
Winston W. L., Microsoft Excel 2010. Data Analysis and Business Modeling. Third Edition, Microsoft Press, Washington 2011.
Matusek M., Zoleński W., Narzędzia informatyczne wspomagające zarządzanie wiedzą w przedsiębiorstwach przemysłu budowy maszyn, Zarządzanie Finansami, 2013, vol 4, no. 3, pp. 313-334.
Dohn K., Gumiński A., Matusek M., Zoleński W., Implementation of expert system in knowledge management in mechanical engineering enterprises, Information Systems in Management, 2013, vol. 2, no. 4, pp. 253-262
Knight G., Analyzing Business Data with Excel, O'Reilly Media, Sebastopol 2006
Flanczewski S., Excel z elementami VBA w firmie, Helion, Gliwice 2008.
Tyszkiewicz J., Spreadsheet As a Relational Database Engine, Proceedings of the 2010 ACM SIGMOD International Conference on Management of data, Indianapolis, IN, USA — June 06 - 11, 2010.
B. Szczesniak, R. Wolniak, Improving the process of car operating costs accounting using a spreadsheet-based tool – a case study, 16th International Multidisciplinary Scientific GeoConference SGEM 2016, www.sgem.org, SGEM2016 Conference Proceedings, ISBN 978-619-7105-58-2 / ISSN 1314-2704, June 28 - July 6, 2016, Book 2 vol. 1, pp. 239-246, DOI: 10.5593/SGEM2016/B21/S07.031
Citing literature
Number of times cited according to Crossref: 1
View or Download full articleAccess options
SWS access login
Login as SWS Scientific CommitteeLogin as SWS Scientific PartnerLogin as SWS AuthorAuthors and approved SWS contributors will read and export their own linked papers after identity matching by SWS profile, email and SGEM GlobalID.
For librarian assistance: [email protected]
Purchase Instant Access
- Article can be downloaded after successful payment.
- Article may be used according to SWS library access terms.
- Article cannot be redistributed.
