PROGRAMMING TRIGGERS FOR CRITICAL DATA SURVEILLANCE
Monday Okpoto Eze, Charles Okunbor, Ruth Chinkata Amanze, Deborah Aleburu · Indian Journal of Computer Science and Engineering · 2021
The ability of a Database Management System (DBMS) to detect fraudulent activities at the earliest possible time cannot be overemphasized.The concept of critical data surveillance is the ability of system to automatically watch over some selected database objects, and take cognizance of ensuing events.This work achieves this solution through the implementation of database triggers, which keeps track of the major database events.The focus of this work is on surveillance and protection against updates to critical database tables.The work implements real life audit-based surveillance of automated product sales enterprises database tables.The trigger was created from the scratch, and programmed to monitor the critical database object -the product pricing table, which keeps record of the price tagged on each the products in the supermarket.Thus, this work ensures that the trigger is fired accordingly, and that changes to the contents are reported to an audit table for further review by only authorized persons.This research was implemented using PostgreSQL.