17643448. GAINING INSIGHTS ON DATABASE SYSTEM TABLE CHANGES simplified abstract (INTERNATIONAL BUSINESS MACHINES CORPORATION)
GAINING INSIGHTS ON DATABASE SYSTEM TABLE CHANGES
Organization Name
INTERNATIONAL BUSINESS MACHINES CORPORATION
Inventor(s)
Pravin Kailashnath Kedia of Deonar (IN)
SHAILESH CHANDRA Jamloki of Noida (IN)
GAINING INSIGHTS ON DATABASE SYSTEM TABLE CHANGES - A simplified explanation of the abstract
This abstract first appeared for US patent application 17643448 titled 'GAINING INSIGHTS ON DATABASE SYSTEM TABLE CHANGES
Simplified Explanation
The patent application describes a method for studying changes made to database system tables while maintaining security and integrity. This is achieved by using risk aware database system triggers with read-only access to the relevant columns. These triggers can also be used to audit changes happening on the tables through views.
- Risk aware database system triggers are utilized to study changes made to database system tables.
- Triggers have read-only access to the columns of interest, ensuring security and integrity.
- Triggers can be used to audit changes happening on the tables using views.
Potential Applications
- Database management and analysis
- Data auditing and monitoring
- Security and integrity maintenance in database systems
Problems Solved
- Difficulty in studying changes made to database system tables
- Ensuring security and integrity while accessing and analyzing database tables
- Lack of efficient auditing mechanisms for database changes
Benefits
- Provides insights on the evolution of database system tables
- Maintains security and integrity of database system tables
- Enables efficient auditing of changes happening on the tables
Original Abstract Submitted
Obtaining insights on how database system tables are evolving. In some instances, risk aware database system triggers that have read only access to the columns of interest are utilized, thereby allowing a user to fully study the changes made to the database system tables while maintaining the security and integrity of these database system tables. Additionally, these database system triggers can be used to audit changes that are happening on the database system tables using views.