Patent ID: 11874945
Assignee: JPMORGAN CHASE BANK, N.A.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 9:
10. A computing apparatus for controlling access to a database, the computing apparatus comprising:
a processor;
a memory; and
a communication interface coupled to each of the processor and the memory,
wherein the processor is configured to:
receive, from a user via the communication interface, a first request for data that is accessible via the database, the first request including a first query;
analyze the first query to detemline whether the first query is potentially harmful;
when the first query is determined as not potentially harmful, forward, via the communication interface, the first request to a server configured to respond to the first request; and
when the first query is determined as being potentially harmful, transmit, to the user via the communication interface, a warning message,
wherein the analysis of the first query includes an application of at least one rule to the first query, and the at least one rule includes at least one from among a first rule that relates to a number of joins allowed, a second rule that relates to a number of sub-selects allowed, a third rule that relates to full outer joins, and a fourth rule that relates to a maximum amount of memory to be consumed by granting the first request, and
wherein the warning message includes information indicating that the first request is denied and that the first query is not to be executed, in conjunction with explanatory information indicating a reason for the denial of the first request, and
wherein the explanatory information includes at least one from among information that relates to the application of the at least one rule to the first query and a result of the analyzing fo the first query that relates to the application of the at least one rule to the first query.