Abstract
Database auditing is a crucial part of database security and governance requirements. Database administrators must be better aware of the procedures used to preserve business data, as well as the standards and regulations that may be applied to the data. Database auditing is a capability for searching the use of database authority and resources at a high level. Every database action that is audited creates an audit trail of the information changes performed when auditing is enabled. Database synchronisation is a type of replication in which every copy of a database is convinced to have the same data. Database synchronisation allows us to do a variety of tasks, one of which is database auditing, which logs every database activity. The audit trails created by data operations allow DBAs (Database Administrators) to do periodic examination of access patterns and data updates in the database management system (Database Management System).
Highlights
It is critical for businesses to have the ability to execute analysis and report production from information systems in an effective, efficient, and integrated manner [1]
The following are the steps of research study for Database Auditing Implementation Using Database Management System (DBMS) Synchronization: 1. Defining the problem of the designed system. 2
Existing System Analysis The existing SIDEKA is a database auditing solution that was used as a case study (Village and Regional Information System)
Summary
It is critical for businesses to have the ability to execute analysis and report production from information systems in an effective, efficient, and integrated manner [1]. Many businesses want the analytical process to take as little time as feasible [2]. Information security arose in terms of authentication and authorisation when information was used for business processes. The notion protects information, it is of no use in investigations. Log files are presented as a way to track database and system access. The log file's primary goal, is to restore(recover) transactions. Database auditing is an option for investigating transactions that occur [3]. It is critical to conduct a database audit in order to detect malicious activities, maintain data quality, and optimise system performance [4]
Published Version (Free)
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have