Method and system for context-oriented association of unstructured content with the result of a structured database query

• US 20060047636A1
• Filed: 08/26/2004
• Published: 03/02/2006
• Est. Priority Date: 08/26/2004
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Roy, Prasan, Mohania, Mukesh K.
• Application Number:
  US10/927,346
• Publication Number:
  US 20060047636A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data

Abstract

A method, system, and program storage device for implementing the method of retrieving relevant unstructured data based on a result of a relational query on a structured database, wherein the method comprises retrieving a context from the structured database by the relational query; analyzing the retrieved context from the structured database; identifying an additional relevant term for a query on an unstructured database according to a result of the analyzing; and retrieving a desired data from the unstructured database according to a search with the additional relevant term.

Claims

1. A method of retrieving relevant unstructured data based on a result of a relational query on a structured database, said method comprising:

retrieving a context from said structured database by said relational query;

analyzing the retrieved context from said structured database;

identifying an additional relevant term for a query on an unstructured database according to a result of said analyzing; and

retrieving a desired data from said unstructured database according to a search with said additional relevant term.

2. The method of claim 1, wherein said analyzing further comprises:

assigning weights to said context from said structured database by said relational query;

computing an overall weight for each term of said context; and

selecting terms with high overall weights.

3. The method of claim 1, further comprising characterizing said context of said relational query as a set of terms in a query result that said relational query is focused on.

4. The method of claim 3, further comprising quantifying a query focus on said set of terms as a ratio of a rarity of a term in said structured database to a rarity of said term in said query result.

5. The method of claim 1, further comprising identifying terms most relevant to said relational query from all terms contained in said query result.

6. The method of claim 1, further comprising identifying terms from said unstructured database which are relevant to said relational query and excluded in said query result.

7. The method of claim 6, wherein said identifying comprises augmenting said relational query with additional joins.

8. The method of claim 7, wherein in said augmenting, said additional joins allow a search of a relevant immediate area of said relational query in said structured database for additional relevant terms.

9. The method of claim 1, further comprising computing said context of said relational query.

10. The method of claim 9, wherein said computing further comprises:

using available database statistics from said structured database; and

eliminating multiple executions of said relational query in various stages of augmentation.

11. A method of integrating relevant unstructured data based on a result of a relational query on a structured database, said method comprising:

receiving a query;

augmenting said query by identifying a set of relevant keywords as a query context based on metadata information supplied by said structured database;

generating a query result based on the augmented query;

sending said query context to a search engine;

said search engine retrieving relevant documents of said query context from an unstructured database; and

consolidating said relevant documents with said query result.

12. A program storage device readable by computer, tangibly embodying a program of instructions executable by said computer to perform a method of retrieving relevant unstructured data based on a result of a relational query on a structured database, said method comprising:

retrieving a context from said structured database by said relational query;

analyzing the retrieved context from said structured database;

identifying an additional relevant term for a query on an unstructured database according to a result of said analyzing; and

retrieving a desired data from said unstructured database according to a search with said additional relevant term.

13. The program storage device of claim 12, wherein said analyzing further comprises:

assigning weights to said context from said structured database by said relational query;

computing an overall weight for each term of said context; and

selecting terms with high overall weights.

14. The program storage device of claim 13, wherein said method further comprises characterizing said context of said relational query as a set of terms in a query result that said relational query is focused on.

15. The program storage device of claim 14, wherein said method further comprises quantifying a query focus on said set of terms as a ratio of a rarity of a term in said structured database to a rarity of said term in said query result.

16. The program storage device of claim 12, wherein said method further comprises identifying terms most relevant to said relational query from all terms contained in said query result.

17. The program storage device of claim 12, wherein said method further comprises identifying terms from said unstructured database which are relevant to said relational query and excluded in said query result.

18. The program storage device of claim 17, wherein said identifying comprises augmenting said relational query with additional joins.

19. The program storage device of claim 18, wherein in said augmenting, said additional joins allow a search of a relevant immediate area of said relational query in said structured database for additional relevant terms.

20. The program storage device of claim 12, wherein said method further comprises computing said context of said relational query.

21. The program storage device of claim 20, wherein said computing further comprises:

using available database statistics from said structured database; and

eliminating multiple executions of said relational query in various stages of augmentation.

22. A system for retrieving relevant unstructured data based on a result of a relational query on a structured database, said system comprising:

means for retrieving a context from said structured database by said relational query;

means for analyzing the retrieved context from said structured database;

means for identifying an additional relevant term for a query on an unstructured database according to a result of said analyzing; and

means for retrieving a desired data from said unstructured database according to a search with said additional relevant term.

23. The system of claim 22, further comprising:

means for assigning weights to said context from said structured database by said relational query;

means for computing an overall weight for each term of said context; and

means for selecting terms with high overall weights.

24. The system of claim 22, further comprising means for characterizing said context of said relational query as a set of terms in a query result that said relational query is focused on.

25. The system of claim 24, further comprising means for quantifying a query focus on said set of terms as a ratio of a rarity of a term in said structured database to a rarity of said term in said query result.

26. The system of claim 22, further comprising means for identifying terms most relevant to said relational query from all terms contained in said query result.

27. The system of claim 22, further comprising means for identifying terms from said unstructured database which are relevant to said relational query and excluded in said query result.

28. The system of claim 27, further comprising means for augmenting said relational query with additional joins.

29. The system of claim 28, further comprising means for searching a relevant immediate area of said relational query in said structured database for additional relevant terms.

30. The system of claim 22, further comprising means for computing said context of said relational query.

31. The system of claim 30, further comprising:

means for using available database statistics from said structured database; and

means for eliminating multiple executions of said relational query in various stages of augmentation.

32. A system for integrating relevant unstructured data based on a result of a relational query on a structured database, said system comprising:

a user interface;

a data broker adapted to manage an integration of structured and unstructured data, said data broker comprising;

a query handler adapted to receive a query from said user interface and to send a query result and relevant documents based on said query result to said user interface; and

a context handler adapted to receive a query from said query handler and to send said query result and a query context to said query handler;

a structured data management system adapted to receive an augmented query from said context handler;

an unstructured content management system; and

a search engine coupled to said unstructured content management system, wherein said search engine is adapted to receive said query context and directives from said query handler and to send relevant documents based on said query result to said query handler.

33. The system of claim 32, wherein said query comprises a structured query language (SQL) query.

34. The system of claim 32, wherein said query handler is adapted to receive directives from said user interface, wherein said directives comprise any of conditions on document metadata and additional keywords for said query.

35. The system of claim 32, wherein said structured data management system is adapted to send metadata to said context handler.

36. The system of claim 32, wherein said query context comprises terms that occur in greater proportion in said query result as compared to said structured data management system.

37. The system of claim 36, wherein said query context comprises keywords.

38. A system for integrating relevant unstructured data based on a result of a relational query on a structured database, said system comprising:

means for receiving a query;

means for augmenting said query by identifying a set of relevant keywords as a query context based on metadata information supplied by said structured database;

means for generating a query result based on the augmented query;

means for sending said query context to a search engine;

means for said search engine to retrieve relevant documents of said query context from an unstructured database; and

means for consolidating said relevant documents with said query result.