Principles of design and database structure of "Resort Manager" sanatorium software

Authors

  • Анатолій Павлович Моторний Vinnytsya national technical university Khmelnytske shosse 95, Vinnytsya, 21021, Ukraine
  • Сергій Макарович Злепко Vinnytsya national technical university Khmelnytske shosse 95, Vinnytsya, 21021, Ukraine
  • Леонід Григорович Коваль Vinnytsya national technical university Khmelnytske shosse 95, Vinnytsya, 21021, Ukraine
  • Сергій Володимирович Костішин Vinnytsya national technical university Khmelnytske shosse 95, Vinnytsya, 21021, Ukraine

DOI:

https://doi.org/10.15587/1729-4061.2013.12354

Keywords:

Spa facilities, software, management, information technology, system, optimization, automation, "Resort Manager"

Abstract

The present article deals with problems of the spa facilities management, and the database structure of modern sanatorium complex software, which automates the functions and activities and also improves the quality of institutions streamline information flows and brings customer’s service to a new higher level. The conclusions about the feasibility of using this system in the workflow institution.

The “Resort Manager" sanatorium software consists of 3 units: “The Settle”,”The Setting Procedures”and “Dining room”

Unit “The Settle” is designed to registrate customers in sanatorium database and to automatize all the proceses connected with it. For this purpose the database includes such tables as “customers”, “room”, “config”, “archive” and so on.

Unit “The Setting Procedures” is designed to generate customer’s medical procedures list with taking into consideration a lot of factors such as procedures incompatability, maximal procedures number per day and so on. For this purpose the database includes such tables as “procedures”, “incompetable procedures”, “config”, “archive” and so on.

Unit “Dining room” is designed to automatize calculation processes of needed ingredients for cooking, number of meals and general usage of foods for each day.  For this purpose the database includes such tables as “ingredients”, “meals”, “days” “config”, “archive” and so on

Author Biographies

Анатолій Павлович Моторний, Vinnytsya national technical university Khmelnytske shosse 95, Vinnytsya, 21021

Assistant

Department of general physics and photonics

Сергій Макарович Злепко, Vinnytsya national technical university Khmelnytske shosse 95, Vinnytsya, 21021

PhD, Professor

Department of medical-biological equipment design

Леонід Григорович Коваль, Vinnytsya national technical university Khmelnytske shosse 95, Vinnytsya, 21021

PhD, assistant professor

Department of medical-biological equipment design

Сергій Володимирович Костішин, Vinnytsya national technical university Khmelnytske shosse 95, Vinnytsya, 21021

Department of medical-biological equipment design

References

  1. Linking environmental and health care databases: Assessing the health effects of environmental pollutants [Текст] / Brooks, J., Renz K., Kattoua, S., et al. // International Journal of Bio-Medical Computing. - 1993. - Vol. 32, Issues 3–4. - P. 279–288.
  2. Моторний, А.П. Структура та принцип побудови універсальної МІС для задач доказової медицини [Текст] / А.П. Моторний // Восточно-европейский журнал передовых технологий. – 2012. – № 2/2 (56). – С. 22–24.
  3. Public access defibrillation–designing a universal report form and database for a national programme [Текст] / Colquhoun, M., Sian Davies, C., Harris, S., Harris, R., Chamberlain D. // Resuscitation. - 2004.- Vol. 61, Issue 1. - P. 49–54.
  4. Axelsson, R. Intersectoral problems in the Russian organisation of public health [Текст] / Axelsson, R., Bihari-Axelsson S. // Health Policy. - 2005. - Vol. 73, Issue 3. - P. 285–293.
  5. Health care professional workstation: software system construction using DSSA scenario-based engineering process [Текст] / Hufnagel, S., Harbison, K., Silva, J., Mettala, E. // International Journal of Bio-Medical Computing. - 1994. - Vol. 34, Issues 1–4. - P. 375–386.
  6. Metabolic syndrome in outpatients receiving antipsychotic therapy in routine clinical practice: A cross-sectional assessment of a primary health care database [Текст] / Sicras-Mainara, A., Blanca-Tamayob, M., Rejas-Gutierrezc, J., Navarro-Artiedad, R. // European Psychiatry. - 2008. - Vol. 23, Issue 2. - P. 100–108.
  7. Agarwal, S. Social exclusion and English seaside resorts [Текст] / Agarwal, S., Brunt, P. // Tourism Management. - 2006. - Vol. 27, Issue 4. - P. 654–670
  8. Moreno, A. Software agents in health care [Текст] / A. Moreno, C. Garbay // Artificial Intelligence in Medicine. - 2003. - Vol. 27, Issue 3. - P. 229–232.
  9. Свід. про реєстр. автор. права на твір № 28524 Комп’ютерна програма «Курорт Менеджер» [Текст] / С. М. Злепко, Л. Г. Коваль, С. В. Костішин, А. П. Моторний. – К. : Державний департамент інтелектуальної власності України. — Дата реєстрації 23.04.2009.
  10. Програмний комплекс «Курорт Менеджер»: модуль 1 «Поселення і бухгалтерія» [Текст] / Злепко С.М., Коваль Л.Г., Моторний А.П., Костішин С.В. // ІІІ Международный радиоэлектронный форум «Прикладная радиоэлектроника. Состояния и перспективы развития» МРФ-2008. Сборник научниых трудов. Том IV. Конференция «Актуальные проблемы биомединженерии». – Харьков: АНПРЭ, ХНУРЭ, 2008. – С. 221–224.
  11. Програмний комплекс «Курорт Менеджер»: модуль 2 «Призначення, розподіл і контроль виконання лікувальних процедур» [Текст] / Злепко С.М., Коваль Л.Г., Моторний А.П., Бондарчук В.В. // ІІІ Международный радиоэлектронный форум «Прикладная радиоэлектроника. Состояния и перспективы развития» МРФ-2008. Сборник научниых трудов. Том IV. Конференция «Актуальные проблемы биомединженерии». – Харьков : АНПРЭ, ХНУРЭ, 2008. – С. 224–228.
  12. Brooks, J., Renz K., Kattoua, S., et al. (1993). Linking environmental and health care databases: Assessing the health effects of environmental pollutants. International Journal of Bio-Medical Computing, 32, 279–288.
  13. Motornyy, A. (2012). Structure and principle of universal MIS for EBM problems. Eastern-European Journal of Enterprise Technologies, 2, 22–24.
  14. Colquhoun, M., Sian Davies, C., Harris, S., Harris, R., Chamberlain D. (2004). Public access defibrillation – designing a universal report form and database for a national programme. Resuscitation, 61, 49–54.
  15. Axelsson, R., Bihari-Axelsson S. (2005). Intersectoral problems in the Russian organisation of public health. Health Policy, 73, 285–293.
  16. Hufnagel, S., Harbison, K., Silva, J., Mettala, E. (1994). Health care professional workstation: software system construction using DSSA scenario-based engineering process. International Journal of Bio-Medical Computing, 34, 375–386.
  17. Sicras-Mainara, A., Blanca-Tamayob, M., Rejas-Gutierrezc, J., Navarro-Artiedad, R. (2008). Metabolic syndrome in outpatients receiving antipsychotic therapy in routine clinical practice: A cross-sectional assessment of a primary health care database. European Psychiatry, 23, 100–108.
  18. Agarwal, S., Brunt, P. (2006). Social exclusion and English seaside resorts. Tourism Management, 27, 654–670
  19. Moreno, A., Garbay, C. (2003). Software agents in health care. Artificial Intelligence in Medicine, 27, 229–232.
  20. Zlepko S., Koval L., Motornyy A., Kostíshyn S. The "Resort Manager" software. Ukraine Patent #28524.
  21. Zlepko S., Koval L., Motornyy A., Kostíshyn S. (2008). The "Resort Manager" software: Module 1 "Settlement and Accounting". 3rd International radio-electronic forum "Applied Electronics. State and prospects of development "MRF-2008, 4, 221-224.
  22. Zlepko S., Koval L., Motorniy A., Bondarchuk V. (2008). The "Resort Manager" software: Module 2 " Appointment, distribution and monitoring of treatments". 3rd International radio-electronic forum "Applied Electronics. State and prospects of development "MRF-2008, 4, 224-228.

Downloads

Published

2013-04-25

How to Cite

Моторний, А. П., Злепко, С. М., Коваль, Л. Г., & Костішин, С. В. (2013). Principles of design and database structure of "Resort Manager" sanatorium software. Eastern-European Journal of Enterprise Technologies, 2(2(62), 39–42. https://doi.org/10.15587/1729-4061.2013.12354

Issue

Vol. 2 No. 2(62) (2013): Information technology

Section

Information technology

License

Copyright (c) 2014 Анатолій Павлович Моторний, Сергій Макарович Злепко, Леонід Григорович Коваль, Сергій Володимирович Костішин

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

The consolidation and conditions for the transfer of copyright (identification of authorship) is carried out in the License Agreement. In particular, the authors reserve the right to the authorship of their manuscript and transfer the first publication of this work to the journal under the terms of the Creative Commons CC BY license. At the same time, they have the right to conclude on their own additional agreements concerning the non-exclusive distribution of the work in the form in which it was published by this journal, but provided that the link to the first publication of the article in this journal is preserved.

A license agreement is a document in which the author warrants that he/she owns all copyright for the work (manuscript, article, etc.).
The authors, signing the License Agreement with TECHNOLOGY CENTER PC, have all rights to the further use of their work, provided that they link to our edition in which the work was published.
According to the terms of the License Agreement, the Publisher TECHNOLOGY CENTER PC does not take away your copyrights and receives permission from the authors to use and dissemination of the publication through the world's scientific resources (own electronic resources, scientometric databases, repositories, libraries, etc.).
In the absence of a signed License Agreement or in the absence of this agreement of identifiers allowing to identify the identity of the author, the editors have no right to work with the manuscript.
It is important to remember that there is another type of agreement between authors and publishers – when copyright is transferred from the authors to the publisher. In this case, the authors lose ownership of their work and may not use it in any way.