scholarly journals Perancangan Data Warehouse Rumah Sakit Berbasis Online Analytical Processing (OLAP)

2021 ◽  
Vol 8 (5) ◽  
pp. 1077
Author(s):  
Joko Purwanto ◽  
Renny Renny

<p class="BodyCxSpFirst">Pemanfaatan teknologi informasi sangat penting bagi rumah sakit, karena berpengaruh pula terhadap kualitas pelayanan kesehatan yang secara manual diubah menjadi digital dengan menggunakan teknologi informasi.Dalam penelitian ini penulis menggunakan metodologi <em>Nine step</em> sebagai acuan dalam merancang suatu <em>data warehouse</em><em>,</em> untuk pemodelan menggunakan skema konstelasi fakta dengan 3 tabel fakta dan 11 tabel dimensi. Perbedaan penelitian ini dengan penelitian sebelumnya terletak pada sumber data yang diekstrak langsung dari <em>database</em> SIMRS yang digunakan rumah sakit, sehingga tidak ada ekstraksi data secara manual.Penelitian ini bertujuan untuk menghasilkan desain data warehouse berbasis Online Analytical Processing (OLAP) sebagai sarana penunjang kualitas pelayanan kesehatan rumah sakit. OLAP yang dihasilkan akan berupa desain data warehouse dengan berbagai dimensi yang akan menghasilkan tampilan informasi berupa Chart maupun Grafik sehingga informasinya mudah dibaca dan dipahami oleh berbagai pihak.</p><p class="BodyCxSpFirst"> </p><p class="BodyCxSpFirst"><em><strong>Abtract</strong></em></p><p class="BodyCxSpFirst"><em>The use of information technology is very important for hospitals, because it also affects the quality of health services, which manualy changed to digital using information technology. In this study, the authors used the Nine step methodology as a reference in designing a data warehouse for modeling using a fact constellation schema with 3 fact tables and 11 dimension tables. the different in this study from previous research is that the data source was taken directly from the SIMRS database used by the hospital, so there is no manual data extraction.</em><em>The aim of this research is to be able to produce a Data Warehouse design based on Online Analytical Processing (OLAP) as a means of supporting the quality of hospital health services. The resulting OLAP will be a data warehouse design with various dimensions will produce the displays information in the form of a graph or chart so that the information is easy to read and understand by various parties.</em></p><p class="BodyCxSpLast"><em> </em></p><p class="BodyCxSpFirst"><em><strong><br /></strong></em></p>

2005 ◽  
Vol 21 (3) ◽  
pp. 173-181
Author(s):  
Francisco Gil ◽  
Jesús Sanz ◽  
María Paz García-Vera ◽  
José M. León ◽  
Silvia Medina ◽  
...  

Abstract. The quality of health services depends on the contribution of all the professionals involved in the system, including certain groups, usually forgotten and underrated, such as the health-transport technicians (HTT). With the aim of improving this group's performance, an intervention program, focusing on the development of the workers' technical and social skills, was designed in a collective of enterprises. Information about the first stage of this program, consisting of the assessment of these workers' social skills, is offered in this study. A specific questionnaire was developed: The Health-Transport Technicians Social Skills Questionnaire (HTT-SSQ), made up of three scales (assertive, passive, and aggressive behavior). It was administered to a large sample (N = 530) from the above-mentioned association. The psychometric properties of the questionnaire were analyzed, with quite satisfactory indexes of internal consistency and factor validity, and the group's deficiencies (excess or deficit) were evaluated.


Author(s):  
Claudia Rokx ◽  
John Giles ◽  
Elan Satriawan ◽  
Puti Marzoeki ◽  
Pandu Harimurti

2016 ◽  
Vol 31 (1) ◽  
pp. 19-27 ◽  
Author(s):  
Luciana Torquati ◽  
Toby Pavey ◽  
Tracy Kolbe-Alexander ◽  
Michael Leveritt

Objective. To systematically review the effectiveness of intervention studies promoting diet and physical activity (PA) in nurses. Data Source. English language manuscripts published between 1970 and 2014 in PubMed, Scopus, CINAHL, and EMBASE, as well as those accessed with the PICO tool, were reviewed. Study Inclusion and Exclusion Criteria. Inclusion criteria comprised (1) nurses/student nurses working in a health care setting and (2) interventions where PA and/or diet behaviors were the primary outcome. Exclusion criteria were (1) non–peer-reviewed articles or conference abstracts and (2) interventions focused on treatment of chronic conditions or lifestyle factors other than PA or diet in nurses. Data Extraction. Seventy-one full texts were retrieved and assessed for inclusion by two reviewers. Data were extracted by one reviewer and checked for accuracy by a second reviewer. Data Synthesis. Extracted data were synthesized in a tabular format and narrative summary. Results. Nine (n = 737 nurses) studies met the inclusion criteria. Quality of the studies was low to moderate. Four studies reported an increase in self-reported PA through structured exercise and goal setting. Dietary outcomes were generally positive, but were only measured in three studies with some limitations in the assessment methods. Two studies reported improved body composition without significant changes in diet or PA. Conclusions. Outcomes of interventions to change nurses’ PA and diet behavior are promising, but inconsistent. Additional and higher quality interventions that include objective and validated outcome measures and appropriate process evaluation are required.


Sign in / Sign up

Export Citation Format

Share Document