Search engine for searching research data

• US 20090144265A1
• Filed: 12/03/2007
• Published: 06/04/2009
• Est. Priority Date: 12/03/2007
• Status: Abandoned Application

• Current Assignee: Chartsource Incorporated
• Original Assignee: Chartsource Incorporated
• Inventors: Modzelewski, Christopher G.
• Application Number:
  US11/999,182
• Publication Number:
  US 20090144265A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques

Abstract

Searching research data includes receiving one or more search parameters describing desired data, identifying one or more columns or tables of one or more databases that comprise data relevant to the one or more search parameters, dynamically constructing a plurality of instructions for extracting the data from one or more databases, the one or more databases hosted on one or more platforms, and extracting the data from the one or more databases using the plurality of instructions.

Claims

1. A method comprising:

receiving one or more search parameters describing desired data;

identifying one or more columns or tables of one or more databases that comprise data relevant to the one or more search parameters;

dynamically constructing a plurality of instructions for extracting the data from one or more databases, the one or more databases hosted on one or more platforms; and

extracting the data from the one or more databases using the plurality of instructions.

2. The method of claim 1 wherein the plurality of instructions comprises one or more of:

an identification of one or more rows to extract data from;

an identification of one or more columns to extract data from;

an identification of one or more tables to extract data from;

an identification of one or more labels for use in one or more charts describing the desired data;

an identification of textual information for use in one or more charts describing the desired data;

an identification of configuration information for use in one or more charts describing the desired data; and

an identification of a chart type for use in one or more charts describing the desired data.

3. The method of claim 1, further comprising:

determining whether the one or more search parameters are in a cache; and

if the one or more search parameters are in the cache, presenting a pre-generated result for the one or more search parameters.

4. The method of claim 1, further comprising presenting the extracted data in a textual list-form.

5. The method of claim 1, further comprising generating meta-data based on the extracted data, the meta-data for use by a chart generator configured to generate a chart based on the meta-data.

6. The method of claim 1, further comprising logging data about the extracted data, the logged data for use in statistical tracking.

7. The method of claim 1, further comprising sorting the extracted data according to the similarity of the extracted data to the one or more search parameters.

8. The method of claim 1, further comprising indicating relatively high relevance to a dataset of the one or more databases wherein one or more keywords relevant to the one or more search parameters are found in one or more column-definitions or column-group definitions of the dataset.

9. The method of claim 1, further comprising indicating relatively low relevance to a dataset of the one or more databases wherein one or more keywords relevant to the one or more search parameters are found in one or more row of a column of the dataset.

10. The method of claim 1, further comprising indicating a lowest relevance to a dataset of the one or more databases wherein one or more keywords relevant to the one or more search parameters are found in a summary of the dataset.

11. The method of claim 1 wherein the one or more research-related parameters comprises one or more of:

a mathematical function to be executed;

a period of time for which data is sought;

a category for which data is sought;

a variable for which data is sought;

a geographic area for which data is sought;

a scale for use in expressing data which is sought; and

an interval into which data across a period is broken.

12. An apparatus comprising:

a memory; and

a processor configured to;

receive one or more search parameters describing desired data;

identify one or more columns or tables of one or more databases that comprise data relevant to the one or more search parameters;

dynamically construct a plurality of instructions for extracting the data from one or more databases, the one or more databases hosted on one or more platforms; and

extract the data from the one or more databases using the plurality of instructions.

13. The apparatus of claim 12 wherein the plurality of instructions comprises one or more of:

an identification of one or more rows to extract data from;

an identification of one or more columns to extract data from;

an identification of one or more tables to extract data from;

an identification of one or more labels for use in one or more charts describing the desired data;

an identification of textual information for use in one or more charts describing the desired data;

an identification of configuration information for use in one or more charts describing the desired data; and

an identification of a chart type for use in one or more charts describing the desired data.

14. The apparatus of claim 12 wherein the processor is further configured to:

determine whether the one or more search parameters are in a cache; and

if the one or more search parameters are in the cache, present a pre-generated result for the one or more search parameters.

15. The apparatus of claim 12 wherein the processor is further configured to present the extracted data in a textual list-form.

16. The apparatus of claim 12 wherein the processor is further configured to generate meta-data based on the extracted data, the meta-data for use by a chart generator configured to generate a chart based on the meta-data.

17. The apparatus of claim 12 wherein the processor is further configured to log data about the extracted data, the logged data for use in statistical tracking.

18. The apparatus of claim 12 wherein the processor is further configured to sort the extracted data according to the similarity of the extracted data to the one or more search parameters.

19. The apparatus of claim 12 wherein the processor is further configured to indicate relatively high relevance to a dataset of the one or more databases wherein one or more keywords relevant to the one or more search parameters are found in one or more column-definitions or column-group definitions of the dataset.

20. The apparatus of claim 12 wherein the processor is further configured to indicate relatively low relevance to a dataset of the one or more databases wherein one or more keywords relevant to the one or more search parameters are found in one or more row of a column of the dataset.

21. The apparatus of claim 12 wherein the processor is further configured to indicate a lowest relevance to a dataset of the one or more databases wherein one or more keywords relevant to the one or more search parameters are found in a summary of the dataset.

22. The apparatus of claim 12 wherein the one or more research-related parameters comprises one or more of:

a mathematical function to be executed;

a period of time for which data is sought;

a category for which data is sought;

a variable for which data is sought;

a geographic area for which data is sought;

a scale for use in expressing data which is sought; and

an interval into which data across a period is broken.

23. A program storage device readable by a machine, embodying a program of instructions executable by the machine to perform a method, the method comprising:

receiving one or more search parameters describing desired data;

identifying one or more columns or tables of one or more databases that comprise data relevant to the one or more search parameters;

dynamically constructing a plurality of instructions for extracting the data from one or more databases, the one or more databases hosted on one or more platforms; and

extracting the data from the one or more databases using the plurality of instructions.

24. An apparatus comprising:

means for receiving one or more search parameters describing desired data;

means for identifying one or more columns or tables of one or more databases that comprise data relevant to the one or more search parameters;

means for dynamically constructing a plurality of instructions for extracting the data from one or more databases, the one or more databases hosted on one or more platforms; and

means for extracting the data from the one or more databases using the plurality of instructions.