Claim Missing Document
Check
Articles

Found 2 Documents
Search
Journal : Jurnal Teknik Informatika (JUTIF)

DATA WAREHOUSE MODELLING INFORMATION SECURITY LOG MANAGEMENT IN BUILDING A SECURITY OPERATION CENTER IN CENTRAL GOVERNMENT AGENCIES WITH KIMBALL METHOD Asmita, Maya; Henny, Henny; Samidi, Samidi
Jurnal Teknik Informatika (Jutif) Vol. 4 No. 4 (2023): JUTIF Volume 4, Number 4, August 2023
Publisher : Informatika, Universitas Jenderal Soedirman

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.52436/1.jutif.2023.4.4.649

Abstract

Central Government, is a government agency that manages important and confidential state data and information. The data that is managed needs to be maintained for reliability and security in order to avoid the risk of loss, leakage and misuse of information. To maintain this data, an optimal information security device is needed. Information security tools used today have a variety of functions resulting in many important logs that must be managed, analyzed and evaluated. The log data from each of these information security devices is still separate and must be processed manually to obtain simpler and more efficient data so that it can be monitored and presented to management. The purpose of this research is to make the right data warehouse modeling in order to assist in the process of presenting information quickly and accurately related to the processing of data logs of information security devices as a report that will be given to management in support of the Zero Tollerance data security policy. The method used in designing this data warehouse is using the Kimball 9 step method. The results obtained are in the form of a starflake schema and a data warehouse log of information security devices consisting of a malware fact table, intrusion facts and attack facts that can be used as centralized data monitoring that will be implemented at the Security Operation Center. Testing is done using Pentaho software tools. This data warehouse is expected to provide a quick, accurate, and continuous summary of information so that it can assist management in the decision-making process and policy making for the future.
COMPARISON OF INDEX, PARTITION, AND MATERIALIZED VIEW METHODS ON THE ORACLE DATABASE STUDY ON CENTRAL GOVERNMENT FINANCIAL REPORTS (LKPP) Rachman, M Harviandi; Samidi, Samidi; Aprianto, Eko
Jurnal Teknik Informatika (Jutif) Vol. 5 No. 4 (2024): JUTIF Volume 5, Number 4, August 2024
Publisher : Informatika, Universitas Jenderal Soedirman

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.52436/1.jutif.2024.5.4.1962

Abstract

The Indonesian Central Government Financial Report (LKPP) is a financial document prepared to increase transparency and accountability in the implementation of the State Revenue and Expenditure Budget (APBN). It is prepared within a tight schedule, hence changes made by each entity must be updated promptly. Therefore, this research focuses on the optimal table design for presenting financial reports. Query optimization is a major concern in database design, with the use of indexing concepts to increase data search speed. Table partitioning is also a strategy to consider, namely dividing a table into parts that form separate data ranges. The use of a Materialized View (MV) is another alternative, providing increased performance with the space-for-time trade-off principle. Experiments were carried out by comparing the response time of applying index, partition, and materialized views to produce financial report data. Experimental results indicate that materialized views can provide significant advantages when faced with large volumetric data. The decision to choose a materialized view can be considered contextually, depending on the specific needs and characteristics of the data encountered in a database system.