Claim Missing Document
Check
Articles

Found 4 Documents
Search
Journal : CogITo Smart Journal

Implementasi Metode Indexing dan Penggunaan Subquery untuk Optimalisasi Database Rawat Jalan Rumah Sakit Menggunakan Mysql Wilsen Grivin Mokodaser; Monica Dwijayanti; Samidi Samidi
CogITo Smart Journal Vol. 8 No. 2 (2022): Cogito Smart Journal
Publisher : Fakultas Ilmu Komputer, Universitas Klabat

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31154/cogito.v8i2.415.335-345

Abstract

The need for outpatient hospital services that can be accessed quickly by the community is a very important aspect. By looking at the downturn caused by the Covid-19 pandemic that has hit the world since 2019 and has an impact on various economic aspects including hospital services, digitizing the hospital system must be implemented to be a solution in providing fast services for patients who come for treatment. The information system is not without problems, as the amount of data increases so that the selection of the right database including the use of appropriate queries can help provide accurate and fast output. indexing method can be applied to tables with a large number of databases. the use of subqueries as with previous research shows an increase in data access performance.
Teknik Optimasi Database dengan Logic Execution Optimization pada Microservices Architecture Isnen Hadi Al Ghozali; Mohammad Shiddiq Antarressa; Samidi Samidi
CogITo Smart Journal Vol. 9 No. 1 (2023): Cogito Smart Journal
Publisher : Fakultas Ilmu Komputer, Universitas Klabat

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31154/cogito.v9i1.444.60-72

Abstract

Microservices architecture, a distributed framework architecture that allows changes to one module without interfering with other modules. The implementation of this architecture has its own challenges. The get-list-attachment API running on this architecture takes an average of 12.5 seconds to serve data. This needs to be considered because business processes require shorter access times to support decision making. The research objective is to obtain query response time efficiency for accounting applications. To achieve this, the research uses database optimization techniques with logic execution optimization microservices architecture. This study obtained the source of information from the Accounting Harmony Accounting Module, which has an API (get-list-attachment) with data sourced from Service Accounting (581253 records) and Service Users (2182 records). Based on a series of tests carried out, several services need to be added with APIs to improve the microservices architecture to accept bulk parameters that generate a list of objects so that data presentation is more optimal. After doing a series of engineering on microservices architecture and indexing application, query response time performance increased by 49.22% for Service Accounting module.
Eksplorasi Kerangka Manajemen Risiko Proyek untuk Perusahaan Teknologi Informasi Isnen Hadi Al Ghozali; Samidi Samidi; Andy Rio Handoko
CogITo Smart Journal Vol. 9 No. 2 (2023): Cogito Smart Journal
Publisher : Fakultas Ilmu Komputer, Universitas Klabat

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31154/cogito.v9i2.517.266-279

Abstract

 Based on CHAOS 2020: Beyond Infinity Overview, reported by the Standish Group, only 31% of  IT projects were successfully implemented, while 50% of projects were challenged and 19% of projects failed. Many project managers less awareness about SRM and have a partial understanding of risk. The purpose of this study is to develop a project risk management framework for listing companies in the information technology sector. The sample for this study is 35 annual reports of technology companies listed on IDX. This study identified 122 types of project risks from 33 companies' annual reports. This study uses an exploratory study approach. The proposed framework includes three stages, namely the root cause, risk assessment, and performance stages. At the root cause stage, the identification of risks from elements of the business environment becomes the basis for measuring risk treatment. In the next stage, the identified risk treatment is measured through identify, analysis, and verification activities with the support of communication, documentation, and evaluation. The measurement results are classified into three major dimensions, namely cost, time, and quality. The final stage of the framework is in the form of residual performance risk and a risk mitigation action plan.
Sentiment Classification of IT Service Feedback via TF-IDF Samidi, Samidi; Fatmawati, Devy
CogITo Smart Journal Vol. 10 No. 2 (2024): Cogito Smart Journal
Publisher : Fakultas Ilmu Komputer, Universitas Klabat

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31154/cogito.v10i2.701.403-417

Abstract

Handling user complaints and feedback is a key strategy of Pusintek, the Ministry of Finance of the Republic of Indonesia, to enhance user satisfaction. The challenge faced is the difficulty in accurately analyzing feedback due to differences in comments and categories chosen by users, which requires manual category correction. This study aims to automate feedback comment categorization using classification algorithms. Specifically, Naïve Bayes, Support Vector Machine (SVM), and K-Nearest Neighbors (K-NN) algorithms were applied to 11,108 user feedback records. The CRISP-DM framework was used, with dataset preparation involving sentiment analysis techniques (cleansing, case folding, normalization, filtering, and tokenization) and Term Frequency-Inverse Document Frequency (TF-IDF) weighting. Accuracy values for each algorithm were evaluated. Results show that the SVM algorithm performed the best, achieving an accuracy of 94.10% and consistently delivering the highest precision, recall, and f1-score across all sentiment categories. This research contributes to the development of an automatic feedback classification system that improves categorization accuracy, minimizes manual intervention, and optimizes user feedback analysis. It is expected to enrich the understanding of text classification and natural language processing techniques and open up opportunities for further research.