×

System, method, and computer program for automatically accessing data in a database based on query information

  • US 9,846,723 B1
  • Filed: 10/27/2014
  • Issued: 12/19/2017
  • Est. Priority Date: 10/27/2014
  • Status: Active Grant
First Claim
Patent Images

1. A computer program product embodied on a non-transitory computer readable medium, comprising:

  • computer code for storing, for each of a plurality of databases;

    a plurality of queries that are unique to the database and that are grouped logically according to teams or applications, anda plurality of database connections for different user environments that are associated with the database and that are grouped logically according to the teams or the applications, wherein the plurality of database connections that are associated with the database each include details for connecting to the database, the details including an indication of a server, a username and a password, wherein the database stores data related to the teams or applications;

    computer code for providing, to a user, a first list of the databases;

    computer code for receiving, from the user through the first list, a first selection of one of the databases;

    computer code for providing, to the user, a second list of the teams or applications;

    computer code for receiving, from the user through the second list, a second selection of one of the teams or applications;

    computer code, responsive to the first selection and the second selection, for displaying a subset of the plurality of queries that are unique to the selected one of the databases and that are grouped logically according to the selected one of the teams or applications;

    computer code for receiving, from the user, a third selection of one of the queries in the subset of the plurality of queries;

    computer code for displaying a subset of the plurality of database connections that are associated with the selected one of the databases and that are grouped logically according to the selected one of the teams or applications;

    computer code for receiving, from the user, a fourth selection of one of the database connections in the subset of the plurality of database connections;

    computer code for presenting one or more input options for the user, based on the one of the queries selected by the user, wherein the one or more input options include a time frame from within to search;

    computer code for receiving, from the user through the one or more input options, input parameters;

    computer code for automatically establishing a connection with the selected one of the databases, using the selected one of the database connections;

    computer code for automatically executing, on the selected one of the databases through the connection, the selected one of the queries according to the input parameters, including filtering the data in the database by the selected one of the teams or applications; and

    computer code for displaying results of the executed query.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×