System for searching research data

• US 20090144318A1
• 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,183
• Publication Number:
  US 20090144318A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/3334 Selection or weighting of terms from queries, including natural language queries
• CPC Class Codes: G06F 16/88 Mark-up to mark-up conversion conversion for visualization in web browsing G06F16/9577

Abstract

Searching research data includes parsing research data according to a markup language to create one or more coded files, indexing the one or more coded files to create one or more indices, and providing a search interface to the one or more coded files via the one or more indices. The markup language describes how to access a database, the structure of the database, the content of the database, and the content of individual columns of the database. The parsing includes translating the structure and one or more keyword descriptions of the content into a hierarchical vocabulary.

Claims

1. A method for searching research data, comprising:

parsing research data according to a markup language to create one or more coded files, the markup language describing;

how to access a database;

the structure of the database;

the content of the database; and

the content of individual columns of the database;

the parsing further comprising translating the structure and one or more keyword descriptions of the content into a hierarchical vocabulary;

indexing the one or more coded files to create one or more indices; and

providing a search interface to the one or more coded files via the one or more indices.

2. The method of claim 1 wherein the parsing further comprises checking consistency between a first date and a second date, the first date comprised in the file and describing a date of the content of the database, the second date comprising a date of the content of the database.

3. The method of claim 1 wherein the parsing further comprises checking consistency between a first interval and a second interval, the first interval comprised in the file and describing an interval of the content of the database, the second interval comprising an interval of the content of the database.

4. The method of claim 1 wherein the parsing further comprises checking consistency between a first resolution and a second resolution, the first resolution comprised in the file and describing an resolution of the content of the database, the second resolution comprising an resolution of the content of the database.

5. The method of claim 1 wherein the parsing further comprises checking consistency between a first geolocation and a second geolocation, the first geolocation comprised in the file and describing an geolocation of the content of the database, the second geolocation comprising an geolocation of the content of the database.

6. The method of claim 1 wherein the parsing further comprises checking consistency between a first data type and a second data type, the first data type comprised in the file and describing an data type of the content of the database, the second data type comprising an data type of the content of the database.

7. The method of claim 1, further 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.

8. The method of claim 7 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.

9. The method of claim 7, 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.

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

11. An apparatus for searching research data, comprising:

a memory; and

a processor configured to;

parse research data according to a markup language to create one or more coded files, the markup language describing;

how to access a database;

the structure of the database;

the content of the database; and

the content of individual columns of the database;

the parsing further comprising translating the structure and one or more keyword descriptions of the content into a hierarchical vocabulary;

index the one or more coded files to create one or more indices; and

provide a search interface to the one or more coded files via the one or more indices.

12. The apparatus of claim 11 wherein the processor is further configured to check consistency between a first date and a second date, the first date comprised in the file and describing a date of the content of the database, the second date comprising a date of the content of the database.

13. The apparatus of claim 11 wherein the processor is further configured to check consistency between a first interval and a second interval, the first interval comprised in the file and describing an interval of the content of the database, the second interval comprising an interval of the content of the database.

14. The apparatus of claim 11 wherein the processor is further configured to check consistency between a first resolution and a second resolution, the first resolution comprised in the file and describing an resolution of the content of the database, the second resolution comprising an resolution of the content of the database.

15. The apparatus of claim 11 wherein the processor is further configured to check consistency between a first geolocation and a second geolocation, the first geolocation comprised in the file and describing an geolocation of the content of the database, the second geolocation comprising an geolocation of the content of the database.

16. The apparatus of claim 11 wherein the processor is further configured to check consistency between a first data type and a second data type, the first data type comprised in the file and describing an data type of the content of the database, the second data type comprising an data type of the content of the database.

17. The apparatus of claim 11 wherein the processor is further 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.

18. The apparatus of claim 17 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.

19. The apparatus of claim 17 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.

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

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

parsing research data according to a markup language to create one or more coded files, the markup language describing;

how to access a database;

the structure of the database;

the content of the database; and

the content of individual columns of the database;

the parsing further comprising translating the structure and one or more keyword descriptions of the content into a hierarchical vocabulary;

indexing the one or more coded files to create one or more indices; and

providing a search interface to the one or more coded files via the one or more indices.

22. An apparatus for searching research data, comprising:

means for parsing research data according to a markup language to create one or more coded files, the markup language describing;

how to access a database;

the structure of the database;

the content of the database; and

the content of individual columns of the database;

the means for parsing further comprising means for translating the structure and one or more keyword descriptions of the content into a hierarchical vocabulary;

means for indexing the one or more coded files to create one or more indices; and

means for providing a search interface to the one or more coded files via the one or more indices.