Generating a file with integral dynamic reports from queries to an external database

摘要

Records in databases or unstructured files are enriched with metadata and are indexed for retrieval by a search engine. In response to a search request, a graphical user interface (GUI) control based on the metadata associated with the search hits is constructed and displayed with the search results in a standard view. Selection of a metadata value via the GUI control filters the previously matched records down to those matching the value selected via the GUI control. The metadata in the search results is arranged in a tabular view which is embedded in the display of search results and rendered invisible until selected by the user. Reports can be constructed from an identifier each returned record set for presenting, analyzing and modifying the data, and for generating further reports.

主权项

1. A method of producing, on a user computer, a browser readable computer file including a dynamic report presenting the results of a query transmitted over a network to a structured database, said structured database having a plurality of data, comprising:
generating on a server computer, to which said user computer is connected over a network, a single browser readable computer file containing no other computer files for receiving said results of said query, passing to said single browser readable computer file an analytic/interactive software engine comprising a computer program executable in a browser on any computer on which the browser is operable, passing data comprising said results of said query to said single browser readable computer file wherein said data comprising said results of said query and the analytic/interactive software engine reside in the same file, saving said single browser readable computer file on said user computer, disconnecting said user computer from said network, and executing said computer program in said analytic/interactive engine on said user computer for manipulating said data comprising said results of said query while disconnected from said network, wherein said manipulating comprises one or more of the following, performing a calculation on the data comprising said results of said query in one view the result of which is displayed in another view, performing a calculation on the data comprising said results of said query in one view the result of which is displayed in another view as a sum of data displayed in said one view, pivoting said data comprising said results of said query in the rows and columns of a table displayed in one view for display in another view, filtering the data displayed in one view for display in another view of a subset of the data in said one view, rolling up the data displayed in one view for display in another view of a subset of the rows of data in said one view, nesting a subarray of the data displayed in one view in the display of data in another view, and/or providing a control in one view which when actuated presents the data as scrolling in another view.