Gaining insights on database system table changes
View Patent ↗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.
1. A computer-implemented method (CIM) comprising:
receiving, from a first database, a database system table, with the database system table including substantive data of a first system, metadata of the first system, and a system trigger;
creating, by a user, a system table view, with the system table view being a sub-set of the entire database system table, and with the sub-set being chosen based on a set of viewing permissions associated with the user;
creating, by the user, a restricted proxy, with the restricted proxy being a trigger that is structured and configured to dynamically track changes made to the database system table;
determining, by the restricted proxy, that a set of changes made to the system table include a number of events that exceed a first events threshold;
responsive to the determination that the set of changes exceeds the first events threshold, determining, by the restricted proxy, substantive content of the set of changes shown in the system table view; and
responsive to the determination of the substantive content of the set of changes, generating a set of insights for the user based, at least in part, upon the substantive content of the set of changes shown in the system table view, with the set of insights including information predicting that the first database will imminently process a set of high-volume transactions.
2. The CIM of claim 1 wherein the database system table is a relational database table.
3. The CIM of claim 1 wherein the restricted proxy can be structured and configured to be disabled based, at least in part, upon the performance of the first database.
4. The CIM of claim 1 wherein the system table view is a logical window for the database system table.
5. The CIM of claim 1 wherein the system table view is created as a read-only view with the substantive content of the system table view being unalterable by the user.
6. The CIM of claim 1 wherein the set of insights generated allows the user to determine whether the first database is experiencing a process overload.
7. A computer program product (CPP) comprising:
a computer readable storage medium; and
computer code stored on the computer readable storage medium, with the computer code including instructions and data for causing a processor(s) set to perform operations including the following:
receiving, from a first database, a database system table, with the database system table including substantive data of a first system, metadata of the first system, and a system trigger,
creating, by a user, a system table view, with the system table view being a sub-set of the entire database system table, and with the sub-set being chosen based on a set of viewing permissions associated with the user,
creating, by the user, a restricted proxy, with the restricted proxy being a trigger that is structured and configured to dynamically track changes made to the database system table,
determining, by the restricted proxy, that a set of changes made to the system table include a number of events that exceed a first events threshold,
responsive to the determination that the set of changes exceeds the first events threshold, determining, by the restricted proxy, substantive content of the set of changes shown in the system table view, and
responsive to the determination of the substantive content of the set of changes, generating a set of insights for the user based, at least in part, upon the substantive content of the set of changes shown in the system table view, with the set of insights including information predicting that the first database will imminently process a set of high-volume transactions.
8. The CPP of claim 7 wherein the database system table is a relational database table.
9. The CPP of claim 7 wherein the restricted proxy can be structured and configured to be disabled based, at least in part, upon the performance of the first database.
10. The CPP of claim 7 wherein the system table view is a logical window for the database system table.
11. The CPP of claim 7 wherein the system table view is created as a read-only view with the substantive content of the system table view being unalterable by the user.
12. The CPP of claim 7 wherein the set of insights generated allows the user to determine whether the first database is experiencing a process overload.
13. A computer system (CS) comprising:
a processor(s) set;
a computer readable storage medium; and
computer code stored on the computer readable storage medium, with the computer code including instructions and data for causing the processor(s) set to perform operations including the following:
receiving, from a first database, a database system table, with the database system table including substantive data of a first system, metadata of the first system, and a system trigger,
creating, by a user, a system table view, with the system table view being a sub-set of the entire database system table, and with the sub-set being chosen based on a set of viewing permissions associated with the user,
creating, by the user, a restricted proxy, with the restricted proxy being a trigger that is structured and configured to dynamically track changes made to the database system table,
determining, by the restricted proxy, that a set of changes made to the system table include a number of events that exceed a first events threshold,
responsive to the determination that the set of changes exceeds the first events threshold, determining, by the restricted proxy, substantive content of the set of changes shown in the system table view, and
responsive to the determination of the substantive content of the set of changes, generating a set of insights for the user based, at least in part, upon the substantive content of the set of changes shown in the system table view, with the set of insights including information predicting that the first database will imminently process a set of high-volume transactions.
14. The CS of claim 13 wherein the database system table is a relational database table.
15. The CS of claim 13 wherein the restricted proxy can be structured and configured to be disabled based, at least in part, upon the performance of the first database.
16. The CS of claim 13 wherein the system table view is a logical window for the database system table.
17. The CS of claim 13 wherein the system table view is created as a read-only view with the substantive content of the system table view being unalterable by the user.
18. The CS of claim 13 wherein the set of insights generated allows the user to determine whether the first database is experiencing a process overload.