Search-on-the-fly report generator

• US 20020133488A1
• Filed: 02/05/2002
• Published: 09/19/2002
• Est. Priority Date: 02/25/2000
• Status: Active Grant

• Current Assignee: Vilox Technologies LLC (Joseph L. De Bellis)
• Original Assignee: Joseph L. De Bellis
• Inventors: Bellis, Joseph De, Freire, Adriano A.
• Granted Patent: US 7,188,100 B2
• Time in Patent Office: Days
• US Class Current: 707/6
• CPC Class Codes: G06F 16/2425 Iterative querying; Query formulation based on the results of a preceding query
• CPC Class Codes: G06F 16/903 Querying for retrieval from the web G06F16/953
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

Sort-on-the-Fly/Search-on-the-Fly data retrieval or analysis provides an intuitive means for accessing databases, allowing a user to access or obtain information about data in the database without having to know anything about the database structure. The thus-obtained information may be formatted according to a report template and may be presented as a search report. The report template may be saved so that subsequent search reports having a consistent format may be generated. The subsequent search reports represent the charging, dynamic content of the database. The search report may be customized using fitters and plug-ins.

Claims

1. A method for creating a data report, comprising:

accessing one or more databases using a search engine;

generating a search result based on the database access, wherein the search result includes one or more descriptors indicating corresponding data categories; and

creating a template of the search result, wherein the template comprises links to the data categories described by the one or more descriptors.

2. The method of claim 1, wherein the one or more databases comprise more than one database schema, the method further comprising translating the more than one database schema into a consistent database schema.

3. The method of claim 1, further comprising:

generating a list of database fields;

receiving one or more selections from the list of database fields; and

integrating the one or more selections to create the template.

4. The method of claim 1, wherein the template is generated based on a default selection of database fields.

5. The method of claim 1, further comprising:

receiving a request to create the data report;

returning a report field menu;

receiving one or more menu selections based on the report field menu;

generating a defined query; and

searching the one or more databases using the defined query, whereby the search result is generated.

6. The method of claim 5, wherein generating the defined query, comprises:

generating a select clause based on the received one or more menu selections;

generating a from clause based on the select clause; and

combining the select clause and the from clause to generate the defined query.

7. The method of claim 1, further comprising:

sending a prompt to save the search result;

receiving a response to the save prompt; and

saving the search result based on the received response.

8. The method of claim 1, further comprising:

performing a subsequent database access using the template, whereby a subsequent search result is generated; and

saving the subsequent search result.

9. The method of claim 8, further comprising searching the search result and the subsequent search result using an alternate template.

10. The method of claim 1, further comprising receiving one or more changes to the template.

11. The method of claim 1, further comprising receiving user feedback based on the returned search result.

12. The method of claim 1, wherein the step of creating the search result comprises:

generating a list of data fields;

receiving a first data field selection from the list of data fields;

receiving a first constraint, wherein the first constraint is related to a data element in a data field; and

receiving one or more subsequent constraints, wherein search results are generated based on a combination of the first and the one or more subsequent constraints.

13. The method of claim 12, further comprising:

determining a first quantity indicative of a number of entries of the selected data field;

if the first quantity exceeds a specified limit, reducing a size of data to be displayed from the selected data field; and

displaying data from the selected data field.

14. The method of claim 13, wherein the specified limit is fixed.

15. The method of claim 13, wherein the specified limit is variable.

16. The method of claim 13, wherein the data are displayed on a terminal, and wherein the specified limit is determined dynamically, based on a characteristic of the terminal.

17. The method of claim 13, wherein the specified limit is a user-determined limit.

18. The method of claim 13, wherein the method for reducing the size of the data to be displayed from the selected data field comprises:

performing a truncation that reduces the size of the data to be displayed from the selected data field;

comparing the reduced size to the specified limit; and

if the reduced size exceeds the specified limit, repeating the truncation and comparing steps until the size of the data to be displayed from the selected data field is less than or equal to the specified limit.

19. The method of claim 18, wherein a parameter is related to the size of the data to be displayed from the selected data field, and wherein the truncation comprises decrementing or incrementing the parameter.

20. The method of claim 19, wherein the parameter is decremented or incremented by a value of one.

21. The method of claim 19, wherein a parameter is related to the size of the data to be displayed from the selected data field, and wherein the truncation comprises dividing the parameter by a value.

22. The method of claim 21, wherein the value is two.

23. The method of claim 18, wherein a parameter is related to the size of the data to be displayed from the selected data field, and wherein the truncation comprises multiplying the parameter by a value.

25. The method of claim 24, further comprising generating the query, comprising:

retrieving an existing where query clause;

generating a select clause;

generating a from clause; and

combining the select clause and the from clause to generate the query.

26. The method of claim 25, further comprising:

generating a reports fields menu based on the search results;

returning the reports field menu; and

receiving one or more selections from the reports field menu, whereby the select clause is generated.

27. The method of claim 24, further comprising reformatting the search template based on a user feedback.

28. The method of claim 27, further comprising saving a reformatted search template, whereby a prior search template is overwritten.

29. The method of claim 24, further comprising saving the search results.

24. A method for generating search result reports, comprising:

receiving a query, whereby the query comprises a database search request, and wherein the database is searched using an on-the-fly search;

searching a reports database for existence of a search template corresponding to the query;

if the search template is found;

retrieving the search template,

searching the database, whereby search-on-the-fly search results are generated, and

formatting the search results according to the search template; and

if the search template is not found, completing a new search, comprising;

displaying a search-on-the-fly search menu,

receiving search parameters, wherein the search parameters define a scope of the search, and

returning search-on-the fly search results, and

generating a second search template based on the returned search-on-the-fly search results.

30. An apparatus for generating search-on-the-fly search reports, wherein search results are provided by a search-on-the-fly search engine, the apparatus comprising:

a search-on-the-fly report generator that receives defined queries from the search-on-the-fly search engine and generates a search report and a search report template; and

a reports database coupled to the report generator, wherein the reports database comprises one or more search report templates, each search report template corresponding to a search result and identified by a unique identification.

31. The apparatus of claim 30, wherein the report generator, comprises:

a request selector that receives a report generation request;

a fields accessor, coupled to the request selector, that receives a create report request, and accesses the reports database to locate a search template corresponding to the requested create report request; and

a report serializer, coupled to the request selector, that receives a do report request, and initiates presentation of a corresponding search report, wherein the report generation request comprises the report generation request and the create report request.

32. The apparatus of claim 31, wherein the report serializer, comprises:

a fields serializer that obtains information related to fields in the databases to be searched;

a query serializer that receives the do report request;

a report package controller that receives the do report request from the query serializer, wherein the do report request includes a list of database fields, and that requests a report query and metadata related to the list of database fields, wherein the report package controller packages the report query and the metadata to create the search report template; and

a database updater that receives the search report template that saves the search report template in the reports database and obtains the unique report identification for the search report.

33. The apparatus of claim 32, wherein the report generator further comprises a report generator front end, comprising:

a reports database accessor that receives the report identification and uses the report identification to extract the search report template from the reports database;

a query tweaker that receives a raw query of a database and generates a defined query of the database;

a search database accessor that runs the defined query against one or more databases and produces a dataset object; and

a formatter that fetches records from the one or more databases according to the dataset object and formats the search report according to the information obtained by the fields serializer.

34. The apparatus of claim 33, further comprising a user feedback module, whereby the search report is modifiable by a user.

35. The apparatus of claim 34, wherein the user feedback module is operable to modify the search report template.