System and method for interactive reporting in computerized data modeling and analysis
An interactive reporting tool allows the user to define, modify, and selectively execute a sequence of queries in an interactive manner. A sequence of queries is entered into rows of an interactive query code table. When the user selects a given row i or a cell in a given row i, then the data table is updated to show the results of the queries 1 through i, such that the user effectively can step through the queries in any order (i.e., sequential or non-sequential, forward or backward) to see the results of each step.
1. A computer-implemented method for interactive database query reporting, the method comprising:
causing display, by a server, on a display screen of a computer of a user, of a first graphical user interface screen including an interactive query code table having a plurality of successive rows starting with a first row and ending with a last row, each row having displayed therein and associated therewith a database query;
receiving, by the server, a first user input associated with a given row of the interactive query code table; and
in response to the first user input, displaying, by the server, on the display screen of the computer of the user,
a first data table including results from execution of the queries associated with the first row of the interactive query code table through and including the given row of the interactive query code table, such that the server enables the user to select any given database query in the interactive query code table to view results through the given database query;
receiving, by the server, a second user input making a change to the database query associated with the given row;
executing, by the server, at least the changed database query associated with the given row; and
displaying, by the server, a second data table including the results from execution of the changed database query.
2. The method of claim 1 , further comprising:
invalidating, by the server, prior results from the database queries associated with the given row of the interactive query code table through and including the last row of the interactive query code table prior to executing at least the changed database query associated with the given row and displaying the second data table.
3. The method of claim 1 , wherein executing at least the changed database query associated with the given row comprises:
executing, by the server, the queries associated with rows the first row of the interactive query code table through and including the given row of the interactive query code table including the changed database query associated with the given row.
4. The method of claim 1 , further comprising:
placing a temporary lock on the rows of the interactive query code table to prevent the user from making inadvertent changes; and
allowing the user to override the temporary lock to provide the second user input.
5. The method of claim 4 , further comprising:
allowing the user to enter additional queries into additional rows of the interactive query code table but not change existing queries when the temporary lock is in place.
6. The method of claim 1 , wherein:
the interactive query code table includes a plurality of cells organized into rows and columns, each column representing a distinct query parameter from among a plurality of query parameters, each row representing a database query involving at least one of the distinct query parameters by way of a query operator in the column/cell corresponding to each distinct query parameter involved in the database query;
the first user input includes a selection of a given cell in the given row; and the second user input includes a change to the contents of the given cell to add a new query operator to the given cell or change a prior query operator in the given cell.
7. The method of claim 1 , wherein:
the interactive query code table includes a plurality of cells organized into rows and columns, each column representing a distinct query parameter from among a plurality of query parameters, each row representing a database query involving at least one of the distinct query parameters by way of a query operator in the column/cell corresponding to each distinct query parameter involved in the database query; and
the first user input includes a selection of a given cell in the given row.
8. A system for interactive database query reporting, the system comprising:
a computer system having stored thereon and executing interactive database query reporting computer processes comprising:
causing display, on a display screen of a computer of a user, of a first graphical user interface screen including an interactive query code table having a plurality of successive rows starting with a first row and ending with a last row, each row having displayed therein and associated therewith a database query
receiving a first user input associated with a given row of the interactive query code table; and
in response to the first user input, displaying, on the display screen of the computer of the user, a first data table including results from execution of the queries associated with the first row of the interactive query code table through and including the given row of the interactive query code table, such that the server enables the user to select any given database query in the interactive query code table to view results through the given database query;
receiving a second user input making a change to the database query associated with the given row;
executing at least the changed database query associated with the given row; and
displaying a second data table including the results from execution of the changed database query.
9. The system of claim 8 , wherein the interactive database query reporting computer processes further comprise:
invalidating prior results from the database queries associated with rows the given of the interactive query code table through and including the last row of
the interactive query code table prior to executing at least the changed database query associated with the given row and displaying the second data table.
10. The system of claim 8 , wherein executing at least the changed database query associated with the given row comprises:
executing the queries associated with the first row of the interactive query code table through and including the given row of the interactive query
code table including the changed database query associated with the given row.
11. The system of claim 8 , wherein the interactive database query reporting computer processes further comprise:
placing a temporary lock on the rows of the interactive query code table to prevent the user from making inadvertent changes; and
allowing the user to override the temporary lock to provide the second user input.
12. The system of claim 11 , wherein the interactive database query reporting computer processes further comprise:
allowing the user to enter additional queries into additional rows of the interactive query code table but not change existing queries when the temporary lock is in place.
13. The system of claim 8 , wherein:
the interactive query code table includes a plurality of cells organized into rows and columns, each column representing a distinct query parameter from among a plurality of query parameters, each row representing a database query involving at least one of the distinct query parameters by way of a query operator in the column/cell corresponding to each distinct query parameter involved in the database query;
the first user input includes a selection of a given cell in the given row; and the second user input includes a change to the contents of the given cell to add a new query operator to the given cell or change a prior query operator in the given cell.
14. The system of claim 8 , wherein:
the interactive query code table includes a plurality of cells organized into rows and columns, each column representing a distinct query parameter from among a plurality of query parameters, each row representing a database query involving at least one of the distinct query parameters by way of a query operator in the column/cell corresponding to each distinct query parameter involved in the database query; and
the first user input includes a selection of a given cell in the given row.
15. A computer program product comprising a tangible, non-transitory computer readable medium having stored thereon a computer program for interactive database query reporting, which, when run on a computer system, causes the computer system to execute interactive database query reporting computer processes comprising:
causing display, on a display screen of a computer of a user, of a first graphical user interface screen including an interactive query code table having a plurality of successive rows starting with a first row and ending with a last row, each row having displayed therein and associated therewith a database query;
receiving a first user input associated with a given row of the interactive query code table; and
in response to the first user input, displaying, on the display screen of the computer of the user,
a first data table including results from execution of the queries associated with the first row of the interactive query code table through and including the given row of the interactive query code table, such that the server enables the user to select any given database query in the interactive query code table to view results through the given database query;
receiving a second user input making a change to the database query associated with the given row;
executing at least the changed database query associated with the given row; and
displaying a second data table including the results from execution of the changed database query.
16. The computer program product of claim 15 , wherein the interactive database query reporting computer processes further comprise:
invalidating prior results from the database queries associated with the given row of the interactive query code table through and including the last row of the interactive query code table prior to executing at least the changed database query associated with the given row and displaying the second data table.
17. The computer program product of claim 15 , wherein executing at least the changed database query associated with the given row comprises:
executing the queries associated with the first row of the interactive query code table through and including the given row of the interactive query code table including the changed database query associated with the given row.
18. The computer program product of claim 15 , wherein the interactive database query reporting computer processes further comprise:
placing a temporary lock on the rows of the interactive query code table to prevent the user from making inadvertent changes; and
allowing the user to override the temporary lock to provide the second user input.
19. The computer program product of claim 18 , wherein the interactive database query reporting computer processes further comprise:
allowing the user to enter additional queries into additional rows of the interactive query code table but not change existing queries when the temporary lock is in place.
20. The computer program product of claim 15 , wherein:
the interactive query code table includes a plurality of cells organized into rows and columns, each column representing a distinct query parameter from among a plurality of query parameters, each row representing a database query involving at least one of the distinct query parameters by way of a query operator in the column/cell corresponding to each distinct query parameter involved in the database query;
the first user input includes a selection of a given cell in the given row; and the second user input includes a change to the contents of the given cell to add a new query operator to the given cell or change a prior query operator in the given cell.
21. The computer program product of claim 15 , wherein:
the interactive query code table includes a plurality of cells organized into rows and columns, each column representing a distinct query parameter from among a plurality of query parameters, each row representing a database query involving at least one of the distinct query parameters by way of a query operator in the column/cell corresponding to each distinct query parameter involved in the database query; and
the first user input includes a selection of a given cell in the given row.