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

• Current Assignee: Amdocs Development Limited (Amdocs Ltd.), Amdocs Software Systems Limited (Amdocs Ltd.)
• Original Assignee: Amdocs Development Limited (Amdocs Ltd.), Amdocs Software Systems Limited (Amdocs Ltd.)
• Inventors: Fitzpatrick, Sr., Daniel William, Jones, Robert J., Zagorovski, Tatiana
• Primary Examiner(s): Perveen, Rehana
• Assistant Examiner(s): Khong, Alexander
• Application Number:
  US14/525,080
• Time in Patent Office: 1,149 Days
• CPC Class Codes: G06F 16/242 Query formulation
• CPC Class Codes: G06F 16/24524 Access plan code generation and invalidation; Reuse of access plans
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

A system, method, and computer program product are provided for automatically accessing data in a database based on query information. In use, query information is received from a user interface, the query information including at least one selection of a preconfigured set of queries that are grouped logically based on a team or an application and the query information further including input parameters defined by a user utilizing the user interface. Additionally, data to access in at least one database is identified based on the query information. Further, a connection with the at least one database is automatically established, the connection with the at least one database being established utilizing a predefined database connection for one or more environments with which the user interface is associated. Moreover, the data in the at least one database is automatically accessed based on the query information.

Claims

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, and

a 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.

2. The computer program product of claim 1, wherein the computer program product is operable such that the plurality of queries that are unique to the database include queries that are commonly used by users associated with the database.

3. The computer program product of claim 1, wherein the computer program product is operable such that the one of the queries selected by the user includes one or more configurable input parameters.

4. The computer program product of claim 3, wherein the computer program product is operable such that the input parameters received from the user configure the one or more configurable input parameters.

5. The computer program product of claim 1, wherein the computer program product is operable such that the one or more input options include one or more text fields.

6. The computer program product of claim 1, wherein the computer program product is operable such that the one or more input options are displayed in a dropdown list.

7. A method, comprising:

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, and

a 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;

providing, to a user, a first list of the databases;

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

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

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

responsive to the first selection and the second selection, 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;

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

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;

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

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;

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

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

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

displaying results of the executed query.

8. A system comprising:

a memory system; and

one or more processing cores coupled to the memory system and that are each configured to;

store, 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, and

a 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;

provide, to a user, a first list of the databases;

receive, from the user through the first list, a first selection of one of the databases;

provide, to the user, a second list of the teams or applications;

receive, from the user through the second list, a second selection of one of the teams or applications;

display, responsive to the first selection and the second selection, 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;

receive, from the user, a third selection of one of the queries in the subset of the plurality of queries;

display 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;

receive, from the user, a fourth selection of one of the database connections in the subset of the plurality of database connections;

present 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;

receive, from the user through the one or more input options, input parameters;

automatically establish a connection with the selected one of the databases, using the selected one of the database connections;

automatically execute, 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

display results of the executed query.