Integration of documents with OLAP using search

• US 7,949,674 B2
• Filed: 08/24/2006
• Issued: 05/24/2011
• Est. Priority Date: 07/17/2006
• Status: Expired due to Fees

• Current Assignee: TARGIT A/S
• Original Assignee: TARGIT A/S
• Inventors: Middelfart, Morten
• Primary Examiner(s): Robinson; Greta L.
• Assistant Examiner(s): Wilcox; James J
• Application Number:
  US11/509,832
• Publication Number:
  US 20080016035A1
• Time in Patent Office: 1,734 Days
• Field of Search: None
• US Class Current: 707/769
• CPC Class Codes: G06F 16/242 Query formulation

Abstract

A computer-implemented method for providing a search result is disclosed. The method comprises, 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. The method also comprises 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.

Claims

1. A computer-implemented method, comprising:

making by a processor, on a display device, a presentation of a dataset with structured data, said structured data being selected from a first database based on a combination of metadata items that correspond to a respective dimension, measure or measure value;

automatically selecting by the processor a plurality of subsets of metadata items from the metadata items used to make the presentation, wherein said plurality of subsets are comprised of different combinations of the metadata used to make the presentation;

automatically converting by the processor each of the selected subsets of metadata items into a corresponding plurality of search requests;

submitting by the processor the search requests to a search engine to search for documents located in a second database; and

making by the processor, on the display device, a presentation of a plurality of search results corresponding to the search requests.

2. The computer-implemented method according to claim 1, wherein the searches are performed in a peripheral data source.

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

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

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

6. The computer-implemented method according to claim 1, comprising the step of converting the metadata items into search requests includes removing and/or altering the metadata items from the combination of metadata items, selected for the different search requests.

7. The 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. The 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-readable storage device encoded with a program which, when executed by a processor, causes the computer to 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; and

making a presentation of the search result;

wherein;

the search string is automatically prepared by taking a set of metadata items from a superset of metadata items that correspond to a respective dimension, measure or measure value; and

the combination of metadata items in the set of metadata items defines a dataset from within the data superset;

and wherein;

different search requests are automatically prepared from a plurality of subsets of the set of metadata items for different searches;

said plurality of subsets are comprised of different combinations of the metadata items from the set of metadata items; and

the search result comprises different result sets corresponding to the different search requests.

12. The 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. The computer-implemented method according to claim 11, wherein the search requests comprise requests directed to a search for metadata of documents.

14. The 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. The 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. The 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. The 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. The 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 data storage device encoded with a program which, when executed by a computer, makes the computer perform a method comprising:

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

making a presentation of the search result on a display device;

wherein;

the search string is automatically prepared by taking a set of metadata items from a superset of metadata items that correspond to a respective dimension, measure or measure value; and

the combination of metadata items in the set of metadata items defines a dataset from within the data superset;

and wherein;

different search requests are automatically prepared from a plurality of subsets of the set of metadata items for different searches;

said plurality of subsets are comprised of different combinations of the metadata items from the set of metadata items; and

the search result comprises different result sets corresponding to the different search requests.

20. A computer comprising:

a processor;

a computer-readable data storage device;

a first database;

a second database; and

a display device,

wherein the computer-readable data storage device is encoded with program instructions that, when executed by the processor, control the computer to perform a method of providing a search result, said 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 on a display device;

wherein;

the search string is automatically prepared by taking a set of metadata items from a superset of metadata items that correspond to a respective dimension, measure or measure value; and

the combination of metadata items in the set of metadata items defines a dataset from within the data superset;

and wherein;

different search requests are automatically prepared from a plurality of subsets of the set of metadata items for different searches;

said plurality of subsets are comprised of different combinations of the metadata items from the set of metadata items; and

the search result comprises different result sets corresponding to the different search requests.