# US 2018/0322165 A1 · Systems and methods for database active monitoring > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 2018/0322165 A1 - Document ID: US20180322165A1 - Status: Published application - Kind: A1 - Application number: 15/969,900 - Filed: 2018-05-03 - Published: 2018-11-08 - Earliest claimed: 2017-05-04 - Assignees: JPMorgan Chase Bank, N.A. - Applicants: JPMorgan Chase Bank, N.A. - Inventors: Prakash Konkimalla; Christopher Medved - Web page: https://patentgrep.com/patent/US20180322165A1 ## CPC - G06F 16/2365: {Ensuring data consistency and integrity} - G06F 11/3433: {for load management (allocation of a server based on load conditions G06F9/505; load rebalancing G06F9/5083; redistributing the load in a network by a load balancer H04L67/1029)} - G06F 21/604: {Tools and structures for managing or administering access control systems} - G06F 21/554: {involving event detection and direct action} - G06F 2201/80: Database-specific techniques - G06N 20/00: Machine learning - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) - G06N: COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS ## Abstract System and methods for database active monitoring are disclosed. In one embodiment, in an information processing device comprising at least one computer processor, a method for database activity monitoring may include: (1) a database monitor monitoring data from a database system and a user session with the database system; (2) the database monitor comparing the monitored data to at least one threshold; (3) the database monitor executing an automated action in response to the monitored data breaching one of the thresholds; and (4) the database monitor initiating an alert based on the breached threshold. ## Claims ### Claim 1 A method for database activity monitoring, comprising: in an information processing device comprising at least one computer processor: a database monitor monitoring data from a database system and a user session with the database system; the database monitor comparing the monitored data to at least one threshold; the database monitor executing an automated action in response to the monitored data breaching one of the thresholds; and the database monitor initiating an alert based on the breached threshold. ### Claim 2 (depends on 1) The method of claim 1, wherein the database system comprises a Teradata database. ### Claim 3 (depends on 1) The method of claim 1, wherein the user session is monitored for at least one of a blocked user session, a high CPU user session, a hung loads, a long running load, and a long running user session. ### Claim 4 (depends on 1) The method of claim 1, further comprising: receiving the at least one threshold related to the user session from at least one property file. ### Claim 5 (depends on 4) The method of claim 4, wherein the at least one property file comprises data related to at least one of a blocked user session, a high CPU user session, a hung loads, a long running load, and a long running user session. ### Claim 6 (depends on 1) The method of claim 1, wherein the automated action comprises at least one of aborting the user session, maintaining the user session, and changing a priority level of the user session. ### Claim 7 (depends on 1) The method of claim 1, wherein the database system is monitored for at least one of abort statements, blocking user sessions, blocking on a system table, system database free space, excessive delay for the user session, and an availability of storage for user queries. ### Claim 8 (depends on 1) The method of claim 1, further comprising: receiving the at least one threshold related to the monitored database system from at least one property file. ### Claim 9 (depends on 8) The method of claim 8, wherein the at least one property file comprises data related to abort statements, blocking user sessions, blocking on a system table, system database free space, excessive delay for the user session, and the availability of storage for user queries. ### Claim 10 (depends on 1) The method of claim 1, wherein the at least one threshold is set based on machine learning. ### Claim 11 (depends on 1) The method of claim 1, further comprising: the database monitor retrieving custom data to process the alert. ### Claim 12 (depends on 11) The method of claim 11, wherein the alert comprises an identification of the breached threshold, an identification of the automated action taken, and an identification of a potential impact on the user session or database system. ### Claim 13 (depends on 1) The method of claim 1, wherein the step of monitoring data from the least one user session and the database system is continuous. ### Claim 14 A system for database activity monitoring, comprising: a database system having a user session therewith; and a database monitor comprising at least one computer processor; wherein: the database monitor monitors data from the user session and the database system; the database monitor compares the monitored data to at least one threshold; the database monitor executes an automated action in response to the monitored data breaching one of the thresholds; and the database monitor initiates an alert based on the breached threshold. ### Claim 15 (depends on 14) The system of claim 14, wherein the database system comprises a Teradata database. ### Claim 16 (depends on 14) The system of claim 14, wherein the user session is monitored for at least one of a blocked user session, a high CPU user session, a hung loads, a long running load, and a long running user session. ### Claim 17 (depends on 14) The system of claim 14, wherein the at least one threshold related to the user session is received from at least one property file, the at least one property file comprises data related to at least one of a blocked user session, a high CPU user session, a hung loads, a long running load, and a long running user session. ### Claim 18 (depends on 14) The system of claim 14, wherein the automated action comprises at least one of aborting the user session, maintaining the user session, and changing a priority level of the user session. ### Claim 19 (depends on 14) The system of claim 14, wherein the database system is monitored for at least one of abort statements, blocking user sessions, blocking on a system table, system database free space, excessive delay for the user session, and an availability of storage for user queries. ### Claim 20 (depends on 14) The system of claim 14, wherein the at least one threshold related to the monitored database system is received from at least one property file, the at least one property file comprises data related to abort statements, blocking user sessions, blocking on a system table, system database free space, excessive delay for the user session, and the availability of storage for user queries.