Shadow Audit Module for Cross-Platform Database Auditing
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database auditing tools are limited to specific application databases and do not support multiple database platforms, requiring manual design and implementation of audit tables and triggers, which is inefficient and lacks cross-platform compatibility.
Innovation Solution
A shadow audit module automates the generation and implementation of data auditing functionality across multiple database platforms by creating audit SQL code and audit triggers, replicating data modifications in shadow audit data tables, and tracking historical changes, allowing for centralized auditing across different database systems.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If manual design and implementation of audit tables with triggers is used, then auditing functionality can be achieved for a specific database, but the process is time-consuming and cannot support multiple database platforms
Solution Approach 1:
The patent creates a universal auditing system that generates platform-specific audit tables and triggers through automated code generation. The system uses a configuration file to define auditing parameters and automatically generates the appropriate SQL code for different database platforms (Oracle, SQL Server, DB2, etc.), making the auditing functionality universal across multiple platforms without requiring manual redesign for each platform
Solution Approach 2:
The system performs preliminary actions by automatically generating the audit table schemas, trigger code, and SQL statements before actual auditing begins. The configuration file is processed in advance to create all necessary database objects and auditing infrastructure, so that when auditing starts, the complete platform-specific implementation is already in place, eliminating time-consuming manual setup
2Productivity
If automated shadow audit module is used, then auditing can be implemented across multiple platforms efficiently, but requires generation and management of audit SQL code and configuration files
Solution Approach 1:
The patent introduces a configuration file as an intermediary between the automated shadow audit module and the database platforms. This configuration file contains all the auditing parameters, table names, and platform-specific settings in a standardized format. The shadow audit module reads this intermediary configuration to generate the appropriate SQL code, simplifying the system by centralizing complexity in a manageable configuration file rather than requiring direct complex interactions with multiple database platforms
Solution Approach 2:
The system uses copying by generating template-based SQL code that is replicated and adapted for different database platforms. The shadow audit module maintains templates for audit table structures and trigger implementations, then automatically copies and customizes these templates for each target platform based on the configuration file, significantly reducing the complexity of manual implementation across multiple platforms
Data Source
AI summary
Systems and methods are provided for generating and implementing data auditing functionality supporting multiple database platforms. A database management computer system can engage a shadow audit module to automate and optimize the implementation of data auditing functionality for multiple database platforms that may be utilized by an enterprise application to record data interactions (e.g., insertions, updates, deletions, etc). The shadow audit module may run generated audit SQL code to create an audit trigger in the selected main data tables. Each audit trigger may be a procedure and/or a flag that is stored in the main data table to run or transmit a signal indicating a change may have occurred on the record indicating the required replication of the modification in the shadow audit data table.