Integration of documents with OLAP using search

• US 20080016035A1
• Filed: 08/24/2006
• Published: 01/17/2008
• Est. Priority Date: 07/17/2006
• Status: Active Grant

• Current Assignee: TARGIT A/S
• Original Assignee: TARGIT A/S
• Inventors: Middelfart, Morten
• Granted Patent: US 7,949,674 B2
• Time in Patent Office: Days
• US Class Current: 707/3
• CPC Class Codes: G06F 16/242 Query formulation

Abstract

There is provided a computer-implemented method, comprising: making a presentation of a dataset with structured data; and storing metadata items that define the dataset from a data superset that is stored in a first database with structured data. Additionally comprising; converting the metadata items to a search request, submitting the search request to a search engine to search for documents located in second database; capturing the search result; and making a presentation of the search result.

Thereby it is possible to automatically search for documents by automatically preparing search requests from a context where data analysis of structured data is performed e.g. in an OLAP database. Consequently, the functionality of the database is greatly improved while efficiency is also improved.

Claims

1. A computer-implemented method, comprising:

making a presentation of a dataset with structured data;

storing metadata items that define the dataset from a data superset that is stored in a first database with structured data;

converting the metadata items to a search request;

submitting the search request to a search engine to search for documents located in a second database;

capturing the search result; and

making a presentation of the search result.

2. A computer-implemented method according to claim 1, wherein the data superset is stored in a first database and wherein the different searches are performed in a peripheral data source.

3. A computer-implemented method according to claim 1, wherein the search requests comprise requests directed to a search for metadata of documents.

4. A computer-implemented method according to claim 3, comprising the step of converting a metadata item related into a time dimension to a search request that address metadata of documents.

5. A computer-implemented method according to claim 1, comprising the step of converting metadata items to words and translating the words from one language into another language.

6. A computer-implemented method according to claim 1, comprising the step of preparing the different search requests by removing and/or altering the metadata items, from the metadata set, selected for the different search requests.

7. A computer-implemented method according to claim 1, further comprising modifying a document to supply it with content of a search request so as to ensure information co-occurring in the search request and the document.

8. A computer-implemented method according to claim 1, further comprising establishing a link from the search request to the document and/or from the document to the search request.

9. A computer-readable medium encoded with a program which, when loaded into a computer, makes the computer perform the method according to claim 1.

10. A computer encoded with a program which, when loaded into the computer, makes the computer perform the method according to claim 1.

11. A computer-implemented method, comprising:

requesting a search engine to perform a search assigned to a search string to provide a search result;

capturing the search result; and

making a presentation of the search result;

where the search string is prepared by taking a set of metadata items that defines a dataset from a data superset; and

preparing different search requests, from different subsets of the metadata items, for different searches; and

wherein the search result comprises different result sets.

12. A computer-implemented method according to claim 11, wherein the data superset is stored in a first database and wherein the different searches are performed in a peripheral data source.

13. A computer-implemented method according to claim 11, wherein the search requests comprise requests directed to a search for metadata of documents.

14. A computer-implemented method according to claim 13, comprising the step of converting a metadata item related to a time dimension into a search request that address metadata of documents.

15. A computer-implemented method according to claim 11, comprising the step of converting metadata items to words and translating the words from one language into another language.

16. A computer-implemented method according to claim 11, comprising the step of preparing the different search requests by removing and/or altering the metadata items, from the metadata set, selected for the different search requests.

17. A computer-implemented method according to claim 11, further comprising modifying a document to supply it with content of a search request so as to ensure information co-occurring in the search request and the document.

18. A computer-implemented method according to claim 11, further comprising establishing a link from the search request to the document and/or from the document to the search request.

19. A computer-readable medium encoded with a program which, when loaded into a computer, makes the computer perform the method according to claim 11.

20. A computer encoded with a program, which when loaded into the computer, makes the computer perform the method according to claim 11.