Patents by Inventor Robert MACANDREW

Robert MACANDREW has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Patent number: 11874945
    Abstract: A method and a system for dynamically scanning, filtering, and blocking harmful database queries that would otherwise consume significant resources and adversely impact overall system performance are provided. The method includes: receiving a user request for data from a database, the first request including a query; applying database access rules to the query in order to determine whether the query is potentially harmful; when the query is determined as not potentially harmful, forwarding the request to a server configured to respond to the request; and when the first query is determined as being potentially harmful, transmitting a warning message to the user. The database access rules may include a maximum memory consumption rule and a maximum CPU consumption rule. Machine learning techniques are used for adjusting the database access rules based on historical data.
    Type: Grant
    Filed: July 15, 2020
    Date of Patent: January 16, 2024
    Assignee: JPMORGAN CHASE BANK, N.A.
    Inventors: Robert MacAndrew, Miklos Kalman, Joel Klein
  • Patent number: 11809579
    Abstract: A method and a system for validating a proposed change to a configuration of an application are provided. The method includes: receiving a user request for changing a setting of one or more parameters of the configuration of the application; retrieving, from a memory, a set of rules that relate to permissible settings for the parameters; comparing the request to the retrieved rules; determining whether the request is acceptable based on a result of the comparison; and when the request is determined as being acceptable, validating the request. The rules may be applicable across an entirety of an organization or specific to a particular line of business. The parameters may relate to report formats or digital dashboards that are generated by executing the application.
    Type: Grant
    Filed: October 7, 2020
    Date of Patent: November 7, 2023
    Assignee: JPMORGAN CHASE BANK, N.A.
    Inventors: Robert MacAndrew, Miklos Kalman, Joel Klein, Remya Gangadharan
  • Patent number: 11379596
    Abstract: A method and a system for providing a bridging solution in order to ensure that a current authentication protocol remains effective when a new authentication protocol is to be introduced but has not yet been implemented at both ends of an interaction between a requesting application and a database are provided. The method includes determining whether a first authentication protocol that is currently implemented by the application is the same protocol as a second authentication protocol that is currently implemented by the database. When the two protocols are different, the first protocol is used to validate a request for data submitted by the application in conjunction with authentication information; the authentication information is converted into a format that is usable by the second protocol; and the converted information is used with the second protocol to generate information that indicates that the request has been authenticated.
    Type: Grant
    Filed: July 15, 2020
    Date of Patent: July 5, 2022
    Assignee: JPMORGAN CHASE BANK, N.A.
    Inventors: Robert Macandrew, Miklos Kalman, Joel Klein
  • Publication number: 20220108029
    Abstract: A method and a system for validating a proposed change to a configuration of an application are provided. The method includes: receiving a user request for changing a setting of one or more parameters of the configuration of the application; retrieving, from a memory, a set of rules that relate to permissible settings for the parameters; comparing the request to the retrieved rules; determining whether the request is acceptable based on a result of the comparison; and when the request is determined as being acceptable, validating the request. The rules may be applicable across an entirety of an organization or specific to a particular line of business. The parameters may relate to report formats or digital dashboards that are generated by executing the application.
    Type: Application
    Filed: October 7, 2020
    Publication date: April 7, 2022
    Applicant: JPMorgan Chase Bank, N.A.
    Inventors: Robert MACANDREW, Miklos KALMAN, Joel KLEIN, Remya GANGADHARAN
  • Publication number: 20220019679
    Abstract: A method and a system for providing a bridging solution in order to ensure that a current authentication protocol remains effective when a new authentication protocol is to be introduced but has not yet been implemented at both ends of an interaction between a requesting application and a database are provided. The method includes determining whether a first authentication protocol that is currently implemented by the application is the same protocol as a second authentication protocol that is currently implemented by the database. When the two protocols are different, the first protocol is used to validate a request for data submitted by the application in conjunction with authentication information; the authentication information is converted into a format that is usable by the second protocol; and the converted information is used with the second protocol to generate information that indicates that the request has been authenticated.
    Type: Application
    Filed: July 15, 2020
    Publication date: January 20, 2022
    Applicant: JPMorgan Chase Bank, N.A.
    Inventors: Robert MACANDREW, Miklos KALMAN, Joel KLEIN
  • Publication number: 20220019684
    Abstract: A method and a system for dynamically scanning, filtering, and blocking harmful database queries that would otherwise consume significant resources and adversely impact overall system performance are provided. The method includes: receiving a user request for data from a database, the first request including a query; applying database access rules to the query in order to determine whether the query is potentially harmful; when the query is determined as not potentially harmful, forwarding the request to a server configured to respond to the request; and when the first query is determined as being potentially harmful, transmitting a warning message to the user. The database access rules may include a maximum memory consumption rule and a maximum CPU consumption rule. Machine learning techniques are used for adjusting the database access rules based on historical data.
    Type: Application
    Filed: July 15, 2020
    Publication date: January 20, 2022
    Applicant: JPMorgan Chase Bank, N.A.
    Inventors: Robert MACANDREW, Miklos KALMAN, Joel KLEIN