Metadata-Driven Audit Reporting with Dynamic Display Names
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing data auditing systems typically display audit data in its original format, lacking user-friendly display names, which can make it difficult for users to understand and analyze modifications to data over time.
Innovation Solution
A metadata-driven audit reporting system that retrieves and displays audit data with user-friendly display names from lookup tables, allowing users to search and query data using recognizable names instead of original data values.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If audit data is displayed in its original format, then the integrity and accuracy of the data is maintained, but the user-friendliness and ease of analysis is reduced
Solution Approach 1:
The patent introduces display name tables as intermediary structures that map between internal data values and user-friendly display names. These tables act as mediators between the raw audit data and the user interface, allowing the system to maintain original data integrity while presenting enhanced user-friendly information. The display name tables are queried during report generation to translate data values into meaningful display names, resolving the contradiction between data accuracy and user-friendliness.
2Ease of operation
If display name tables are added to provide user-friendly names, then ease of operation is improved, but device complexity increases
Solution Approach 1:
The display name tables serve multiple functions: they provide user-friendly names for audit reports, enable search functionality using display names, maintain data integrity by linking to original values, and support various report formats. This multi-functionality justifies the added complexity by delivering multiple benefits from a single structural addition.
Solution Approach 2:
The system performs preliminary action by pre-loading display name tables into memory during application startup or cache- ing frequently accessed display names. This preparation eliminates the need for real-time database queries during report generation, reducing the perceived complexity impact and improving performance. The display name tables are ready beforehand to be quickly referenced during audit report generation.
Data Source
AI summary
A system is provided that reports audit data. The system retrieves audit data that is stored in database tables, where the audit data includes a history of modifications to data, and where the audit data includes data values. The system further retrieves a display name that is stored in a lookup table, where the display name is associated with a data value of the data values within the lookup table. The system further displays the audit data within a user interface, where the display name is displayed within the user interface.