US 11,886,454 B2
Systems and methods for storing and accessing database queries
Caglar Ergun, Plano, TX (US); Mahesh Senniappan, Plano, TX (US); Junbo Chen, Irving, TX (US); David Schaaf, McKinney, TX (US); and Mahadevan Sivaramakrishnan, Allen, TX (US)
Assigned to Capital One Services, LLC, McLean, VA (US)
Filed by Capital One Services, LLC, McLean, VA (US)
Filed on Jan. 25, 2018, as Appl. No. 15/880,238.
Prior Publication US 2019/0228095 A1, Jul. 25, 2019
Int. Cl. G06F 16/248 (2019.01); G06F 16/242 (2019.01); G06F 16/2455 (2019.01); G06F 16/951 (2019.01)
CPC G06F 16/248 (2019.01) [G06F 16/242 (2019.01); G06F 16/2455 (2019.01); G06F 16/951 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A system for resolving user inputs to query an underlying data platform, comprising:
memory storing instructions; and
one or more processors configured to execute the instructions to:
receive, via a user interface from a user device associated with a user, natural language user input related to querying a structured database system, the natural language user input including non-structured search terms;
identify, in a database storing a plurality of structured data queries and based on metadata identifiers relating the natural language user input with the structured data query, a structured data query associated with the natural language user;
determine, based on the natural language user input, a set of selective parameters associated with the identified structured data query, wherein the set of selective parameters includes at least one parameter comprising at least one of a table name, a column name, a logical operator, or a column value of the structured data query;
obtain a set of permissions associated with the user;
in response to determining that the set of permissions associated with the user is a first set of permissions, modify the set of selective parameters based on the first set of permissions and generate for display, via the user interface, an input field comprising text of the structured data query with the modified set of selective parameters, wherein the user is enabled to modify the text of the structured data query;
in response to determining that the set of permissions associated with the user is a second set of permissions that is more restrictive than different from the first set of permissions, modify the set of selective parameters based on the second set of permissions and generate for display, via the user interface, a corresponding input field for each selective parameter of the set of selective parameters, wherein each input field enables the user to select and deselect one or more selective parameter of the set of selective parameters;
receive, via the user interface, configuration information for configuring the one or more selective parameters;
configure an executable data query by configuring the one or more selective parameters for the identified structured data query based on the received configuration information;
execute the executable data query based on the configured one or more selective parameters; and
provide, via the user interface, data returned from the structured database system responsive to the execution of the executable data query.