Claim Missing Document
Check
Articles

Found 12 Documents
Search

DATA SECURITY STRATEGY BASED ON STORED PROGRAMS: A CASE STUDY OF DSS FOR TEACHING ASSISTANT SELECTION Ciptadi, Prahenusa Wahyu; Tri Hastono; Kharismajati, Gema; Syah, Firdiyan; Fahriza, Nayaka Anung
JTH: Journal of Technology and Health Vol. 2 No. 1 (2024): July: JTH: Journal of Technology and Health
Publisher : CV. Fahr Publishing

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.61677/jth.v2i3.371

Abstract

Data security is becoming increasingly crucial in information system management, especially in academic environments that handle sensitive information. The reliance on digital systems demands the protection of data integrity, confidentiality, and availability. High-level data security is also required in the Decision Support System (DSS) application for selecting Teaching Assistants at Universitas PGRI Yogyakarta. The DSS helps determine candidates based on GPA, experience, and skills. However, this system is vulnerable to threats such as unauthorized data modifications, access abuse, SQL Injection, and cyber-attacks that can impact decision-making. Stored Programs in databases provide an effective solution to enhance data security. This research aims to design Stored Programs as a security strategy for data input into database tables. The types of Stored Programs designed in this study include Stored Procedures, Functions, and control programs. The design methodology for the Stored Programs follows the waterfall method. The test results indicate that the Stored Programs function as expected and execute in a very short time. The execution of Stored Programs takes only 0.0059 seconds.
DATA SECURITY STRATEGY BASED ON STORED PROGRAMS: A CASE STUDY OF DSS FOR TEACHING ASSISTANT SELECTION Prahenusa Wahyu Ciptadi; Tri Hastono; Gema Kharismajati; Firdiyan Syah; Nayaka Anung Fahriza
JTH: Journal of Technology and Health Vol. 3 No. 2 (2025): October: JTH: Journal of Technology and Health
Publisher : CV. Fahr Publishing

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.61677/jth.v3i2.365

Abstract

Data security is increasingly crucial in managing information systems, especially in academic environments handling sensitive data. The reliance on digital systems demands protection of data integrity, confidentiality, and availability. Educational institutions must secure student, faculty, and administrative data to prevent unauthorized access and manipulation. One system requiring high security is the Decision Support System (DSS) for Teaching Assistant selection. DSS helps determine candidates based on GPA, experience, and skills. However, it is vulnerable to unauthorized data changes, access abuse, SQL Injection, and cyber threats that may affect decision accuracy. Stored Programs in databases provide an effective solution for enhancing data security. With Stored Procedures, Functions, Triggers, and Events, data management becomes more secure and structured. These features enable stricter access control, database operation automation, and direct validation to reduce errors and misuse. In the DSS case study, Stored Programs ensure that only authorized users can access and modify data. Authentication and authorization mechanisms restrict access based on user roles. This study analyzes security risks, system architecture design, Stored Program implementation, and its effectiveness in maintaining data integrity. Research results confirm that the developed Stored Programs meet expectations. The CRUD feature operates optimally with a processing time of 0.0059 seconds.