Scholarly record
MICROTOOLS BASED ON THE RELATIONAL DATA MODEL - TRANSITION FROM TYPE II TO TYPE I OF ENTITY REPRESENTATION
Abstract
It takes adequate IT tools to implement and perform information processes in an organisation. Such tools can be developed by means of popular and frequently used programs, such as spreadsheets. The tools created in spreadsheets may be consistent with the author?s signature concept of Microtools Based on the Relational Data Model (MiRel). This concept delivers specific solutions intended for representation of identified entities and ensures integrity of both data and the assumed reports and collations assumed to be generated. These solutions are based on application of a relatively small number of spreadsheet features and components, without being forced to create code in any programming language. In accordance with the concept in question, the entities previously identified may be represented in one of two ways. Type I is based on an assumption that an entity is represented as a table, as in a traditional relational database. Type II representation assumes that values of primary keys and names of attributes that do not belong to the key are headers of columns and rows, the intersections of which contain corresponding values of attributes not belonging to the key. Type I is considered more convenient with regard to generation of certain reports, and therefore the solutions proposed under the MiRel concept enable transition from type II to type I of entity representation. Two solutions to this problem, previously described in the literature of the subject, have been discussed in the article. It also presents a new and improved mechanism of data transition between type II and type I. All the solutions discussed in the paper have been analysed and compared.
Publication Impact Profile
Publication details
References15
Korpus J., Ocena jakości środowiska pracy w przedsiębiorstwach produkcyjnych, in: J. Jakubowski, J. Wątroba (red.), Zastosowania metod statystycznych w badaniach naukowych III, StatSoft Polska, Kraków 2008
Jasińska J., Stosunki i warunki pracy, in: T. Listwan (red.), Zarządzanie kadrami, pp 235-259, Warszawa 2009
Jakimiuk, B., Środowisko pracy jako obszar budowania poczucia własnej wartości i relacji z innymi, Annales Universitatis Mariae Curie-Skłodowska, sectio J – Paedagogia-Psychologia, v. 29, n. 4, p. 43-54, june 2017
Bartnicka J., Knowledge-based ergonomic assessment of working conditions in surgical ward – A case study, Safety Science, vol. 71, part B, pp 178-188, January 2015
Midor K., Implementation of innovative project for monitoring and recording of distribution of explosive materials in bituminous coal mine, in: 17th International Multidisciplinary Scientific GeoConference. SGEM 2017, 29 June - 5 July 2017, Albena, Bulgaria. Conference proceedings. vol. 17, Science and technologies in geology, exploration and mining. iss. 13, Exploration and mining. Sofia : STEF92 Technology, 2017, pp 407-414
Gembalska-Kwiecień A., Improvement of the work safety management system in hard coal mining with special reference to the problem of workers participation. in: 17th International Multidisciplinary Scientific GeoConference. SGEM 2017, 29 June - 5 July 2017, Albena, Bulgaria. Conference proceedings. vol. 17, Science and technologies in geology, exploration and mining. iss. 13, Exploration and mining. Sofia : STEF92 Technology, 2017, pp 429-436
Wolniak R., The use of constraint teory to improve organization of work, in: 4th International Multidisciplinary Scientific Conference on Social Sciences and Arts. SGEM 2017, 24-30 August 2017, Albena, Bulgaria. Conference proceedings. Book 1, Modern science. vol. 5, Business and management. Sofia : STEF92 Technology, 2017, pp 1093-1100
Oleński J., Ekonomika informacji. Podstawy, PWE , Warszawa 2001
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
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.
Sroka J., Panasiuk A., Stencel K., Tyszkiewicz J., "Translating Relational Queries into Spreadsheets", IEEE Trans. On Knowledge and Data Engineering, vol. 27, no. 8, August 2015.
Szczęśniak B., Microtools Based on the Relational Data Model - representation of entities in a spreadsheet, in: 17th International Multidisciplinary Scientific GeoConference. SGEM 2017, 29 June - 5 July 2017, Albena, Bulgaria. Conference proceedings. vol. 17, Informatics, geoinformatics and remote sensing. iss. 21, Informatics, geoinformatics. Sofia : STEF92 Technology, 2017, pp 447-454
Zasadzień M., Szczęśniak B., Skotnicka-Zasadzień B., Implementation of maintenance employees' work time scheduling, in: Advances in Economics, Business and Management Research, vol. 33, Proceedings of the Second International Conference On Economic and Business Management (FEBM 2017), Atlantis Press 2017, pp 226-231.
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.
