17643448. GAINING INSIGHTS ON DATABASE SYSTEM TABLE CHANGES simplified abstract (INTERNATIONAL BUSINESS MACHINES CORPORATION)

From WikiPatents
Jump to navigation Jump to search

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.