Comparison of Stored Procedures on Relational Database Management System

Store procedure is a group of query stored in database catalogue which allows it to be recalled. Insert, update and delete data could performed using store procedure. Stored procedure is an alternative to optimize query performance and also to reduce security gap at interface level of a system. This research provides an overview implementation of stored procedure insert, update and deleting in two DBMS, MariaDB and PostgreSQL. Software developers prefer MariaDB and PostgreSQL because it is open-source, which means free. This research is an experimental research and descriptive analysis. This research data uses student data with amount of data 25000, 15000 and 5000 data. Research result show PostgreSQL require less processing time than MariaDB. Results of this research can used as a reference to design application programs which sometimes choose a DBMS is not a concern of developer

Analisis Faktor Risiko Tindakan Restrain pada Pasien Rawat Inap dengan Gangguan Jiwa

This literature review aims to summarize research results regarding risk factors for restraint in hospitalized mental disorder patients. The literature search used seven databases, namely PuBmed, EBSCOhost, ProQuest, ScienceDirect, Garuda; Google Scholar; and Wiley in the 2013-2023 range. As a result of the research, eleven studies were included in the review, where increased restraint risk factors were divided into three: 1) sociodemographic characteristics (immigrant patients, male, young age, married, rural background, and low socioeconomic); 2) clinical factors (active and aggressive behavior, psychotic/bipolar disorders, cognitive and mood disorders, previous psychiatric disorders, long hospitalization and previous hospitalization, and alcohol/drug dependence); 3) referral factors (forced referrals from emergency departments, from outpatient centers/private doctors, and police referrals). In conclusion, there are three factors that can increase the risk of restraint, namely: sociodemographic characteristics, patient clinical factors, and referral factors.   Keywords: Mental Disorder Patients, Hospitalization, Restrain

Analysis of Obstacles in the Implementation of the Clinical Pathway in Indonesia: Integrative Review

This review aims to analyze the obstacles in the implementation of clinical pathways in Indonesia. Integrative review refers to the Preferred Reporting Items for Systematic Review and Meta-Analyses checklist. Literature search used PubMed, ProQuest, DOAJ, Garuda and Google Scholar with the following criteria: 1) studies using a sample of health service staff; 2) studies that present the results of obstacles in the implementation of clinical pathways; 3) published in the last 5 years (2016-2021); and 4) studies conducted in Indonesia, both in Indonesian and English. Studies are excluded if: 1) do not have the full text; 2) duplicate articles; and 3) review articles. Assessment of study quality uses the Critical Appraisal Skills Program Qualitative-Checklist, Mixed Methods Appraisal Tool-Version-2018 and the Critical Appraisal Skills Program Case Study. Six articles were identified in this review, including three qualitative studies, two mixed-methods studies and one case study. We identified a number of obstacles in the implementation of clinical pathways in several hospitals in Indonesia, but the most reported obstacles were the lack of outreach and training related to the implementation of clinical pathways in hospitals and the lack of compliance of officers in implementing clinical pathways. In the implementation of clinical pathways in several hospitals in Indonesia, many obstacles were identified that caused the implementation of clinical pathways to be not optimal. Therefore, evaluation must be carried out routinely so that it can identify various obstacles in the implementation of clinical pathways in hospitals

Perempuan dan Komunikasi Politik pada Pemilihan Umum Daerah Istimewa Yogyakarta

Perempuan sering dianggap memiliki citra yang dipandang lemah dan tidak pantas untuk terjun ke dunia politik. Penelitian ini bertujuan untuk menganalisis peran perempuan dalam komunikasi politik pada pemilihan umum di Daerah Istimewa Yogyakarta. Penelitian ini menggunakan studi kasus tunggal dan pendekatan fenomenologis. Teori yang digunakan dalam penelitian ini adalah standpoint theory milik Sandra Harding dan Julian T. Wood yang memaparkan bahwa laki-laki dan perempuan mempunyai perspektif yang terpisah, dan tidak dipandang sebagai sesuatu yang setara. Hasil penelitian diperoleh bahwa: 1) adanya partisipasi politik perempuan dalam komunikasi politik di DIY (partisipasi affirmative action) yaitu menjadi vote getter, menjadi mitra setara bagi laki-laki dalam pengambilan kebijakan yang responsif gender, tegaknya hak asasi perempuan dalam panggung politik daerah; 2) perempuan sebagai komunikator politik dalam pemilihan umum DIY yaitu menjadi media penghubung ke masyarakat dan juga menjembatani kepentingan perempuan secara khusus, dan masyarakat secara umum; 3) faktor yang memengaruhi peran perempuan dalam pemilihan umum DIY yaitu faktor Internal dan eksternal (Empowering Role): tingkat pendidikan, kemandirian ekonomi, nilai budaya dan sistem politik. Penelitian ini memberikan kontribusi berupa rekomendasi kepada pemerintah dan masyarakat untuk peningkatan pemberdayaan perempuan dalam panggung politik daerah

Analisis Pelaksanaan Komunikasi Efektif SBAR Perawat dan Dokter

The aim of this research is to map research results related to the implementation of effective SBAR communication between nurses and doctors. The research method used, namely Scoping Review, was used to map the literature using PRISMA guidelines. The synthesis method uses PCC modification. Articles obtained from the Google Scholar search engine as well as the electronic databases PubMed and ScienceDirect. Search results, from 87 relevant articles with titles and abstracts, 6 articles were found that met the inclusion and exclusion criteria. The research results found that the analysis of the implementation of effective SBAR communication between nurses and doctors contained seven themes, namely patient safety and satisfaction, lack of self-confidence, environment, lack of interpersonal communication, lack of training, and work safety climate. In conclusion, effective communication and collaboration between doctors and nurses is very necessary in managing and limiting disturbances that can endanger patient safety and the continuity of safe care for at-risk patients.   Keywords: Implementation Analysis, Effective Communication, SBA

Implementasi Peran Public Relation Dalam Membangun Reputasi PT Cakrawala Dinamika Energi

This study aims to determine the implementation of the role of public relations in building the reputation of PT Cakrawala Dinamika Energi. This study uses the role theory of public relations (Cutlip 2002: 46) which consists of four roles, namely: communication technician, expert presciber, communication facilitator, and problem solving facilitator and the type of research used is qualitative research. The results of the study show that there are four public relations roles that support the implementation of the public relations role in building the reputation of PT Cakrawala Dinamika Energi, namely the first role of public relations as a communications technician is to build good communication between the public, internal, external and company partners, this is important to prevent adverse impact on the company's reputation in the event of a problem. Second, the role of public relations as an expert presiber is to liaise with a structured public relations department to communicate with the public if there are problems. Third, the role of public relations as a communication facilitator is as an intermediary who maintains a two-way flow of communication between the company and its public, including internal and external. And Fourth, problem solving facilitators in public relations must understand company policies, products, and procedures. The right communication strategy is needed so that the problem has a solution without hurting anyone's feelings

Evaluasi Pelaksanaan Discharge Planning pada Pasien Diabetes Melitus

The aim of this review is to map the discharge planning implementation model and its effects. The research method uses a literature review by searching for appropriate articles in scientific databases, namely PubMed, EBSCO, ScienceDirect and Garuda using keywords based on the Population method: Diabetes mellitus; Concept: Discharge Planning and Context: Hospital. As a result of the research, after searching for articles, 44 articles were found that matched the research questions and resulted in 20 articles to be included in this review. Evaluation of the discharge planning implementation model used a research design of 7 RCT studies, 5 quasi-experimental studies, 3 cross-sectional studies, 2 retrospective studies, 1 qualitative study, 1 cohort study, and 1 comparative descriptive study. We identified several models for evaluating the implementation of discharge planning in DM patients. In conclusion, the evaluation model for implementing discharge planning in the form of training and education can increase knowledge and compliance with treatment as well as glycemic control.   Keywords: Discharge Planning, DM Patients, Hospita

AKUNTANSI PEMBIAYAAN AR - RAHN PADA PT. PEGADAIAN SYARIAH (PERSERO) UNIT BATOH ACEH BESAR

Banda Ace

PERAN REFLEKSI DIRI DAN PEMAHAMAN KONSEP BIOLOGI TERHADAP KEMAMPUAN PEDAGOGICAL CONTENT KNOWLEDGE CALON GURU BIOLOGI

Refleksi diri dan pemahaman konsep merupakan komponen penting untuk meningkatkan kemampuan Pedagogical Content Knowledge (PCK). Penelitian ini bertujuan untuk mengetahui bagaimana peran refleksi diri dan pemahaman konsep biologi terhadap kemampuan PCK calon guru biologi. Metode yang digunakan adalah metode deskriptif, dengan desain triangulasi dimana peneliti mengumpulkan secara bersama data kualitatif dan kuantitatif, membandingkan hasilnya, dan kemudian menggunakan hasil temuan tersebut untuk melihat apakah saling memvalidasi satu sama lain. Subjek pada penelitian ini adalah mahasiswa semester 6 pada prodi pendidikan biologi UPI, yang mengambil mata kuliah Kapita Selekta Biologi 2. Sampel diambil menggunakan teknik purposive sample dengan 13 orang mahasiswa pada tiap materi yang diberikan (Genetika, Hereditas, Bioteknologi). Data dikumpulkan melalui pemberian angket refleksi diri, tes pemahaman konsep, Content Representation (CoRes) yang diberikan sebelum dan sesudah pembelajaran. Tes pemahaman konsep berupa three tier-test. Disamping itu, mahasiswa membuat Rencana Pelaksanaan Pembelajaran (RPP) dan dilakukan wawancara. Hasil analisis data menunjukkan bahwa Refleksi diri berperan untuk meningkatkan kemampuan PCK calon guru biologi dengan ditunjukkan nilai N-gain angket pra hingga post 0,37; 0,39; 0,36 untuk (genetika, hereditas, bioteknologi). Seiring dengan hal tersebut nilai CoRes dari sebelum hingga sesudah pembelajaran mengalami peningkatan dari kategori pra menjadi growing. Nilai pemahaman konsep ketiga materi juga meningkat (N-gain genetika, hereditas, bioteknologi berturut-turut: 0,31; 0,35; 0,36). Peningkatan juga terjadi pada nilai RPP dan pelaksanaan simulasi pembelajaran dari kategori cukup menjadi baik atau sangat baik. ;---Self-reflection and understanding concept is an important component to improve the ability of Pedagogical Content Knowledge (PCK). This study aims to determine how the role of self-reflection and understanding concept of biology to ability PCK of biology teachers candidate. The method used is descriptive method, with design of triangulation where researchers gather together qualitative and quantitative data, compare the results, and then use those findings to see if mutual validate each another. Subjects in this study were students of the 6th semester at the department of biology education UPI, who took a course Kapita Selekta Biology 2. Samples were taken using purposive sample with 13 students in each of the material (Genetics, Heredity, Biotechnology). Data were collected through questionnaires of self-reflection, test understanding concepts, Content Representation (CoRes) given before and after lessons. Test understanding concept in the form of a three-tier test. In addition, students create lesson plan (RPP) and conducted interviews. The results of data analysis showed that self reflection role is to enhance the ability of PCK biology teachers candidate with the indicated value of the N-gain pre questionnaires to post 0.37; 0.39; 0.36 in (genetics, heredity, biotechnology). Along with this value CoRes from before to after the learning has increased from a pre to be growing category. The value of understanding concept also increased (N-gain genetics, heredity, biotechnology respectively: 0.31; 0.35; 0.36). The increase also occurred in the value of RPP and simulation learning implementation from category sufficient to be good or excellent