System and method for on-demand analysis of unstructured text data returned from a database

• US 20060248087A1
• Filed: 04/29/2005
• Published: 11/02/2006
• Est. Priority Date: 04/29/2005
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Mehta, Kiran, Negi, Sumit, Agrawal, Neeraj, Holmes, Scott R.
• Application Number:
  US11/118,538
• Publication Number:
  US 20060248087A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/3344 using natural language analysis

Abstract

A system and method of retrieving data from a database comprising unstructured data comprises specifying a text analytic component in an unstructured text query at query runtime; submitting the unstructured text query to a web service database; filtering unstructured text data in the web service database based on constraints defined in the text analytic component in the query; and receiving the filtered unstructured text data based on the submitted query from the web service database, wherein the text analytic component comprises metadata requirements. Preferably, the constraints comprise any of positive sentiments regarding an unstructured text document and negative sentiments regarding the unstructured text document. Alternatively, the constraints may comprise any of name spotting constraints, address spotting constraints, date spotting constraints, and entity spotting constraints. The filtering preferably occurs using a web-based callback service specified in a WFQL XML document. The database is preferably run on a WebFountain platform.

Claims

1. A method of retrieving data from a database comprising unstructured data, said method comprising:

specifying a text analytic component in an unstructured text query at query runtime;

submitting said unstructured text query to a web service database;

filtering unstructured text data in said web service database based on constraints defined in said text analytic component in said query; and

receiving the filtered unstructured text data based on the submitted query from said web service database.

2. The method of claim 1, wherein said constraints comprise any of positive sentiments regarding an unstructured text document and negative sentiments regarding said unstructured text document.

3. The method of claim 1, wherein said constraints comprise any of name spotting constraints, address spotting constraints, date spotting constraints, and entity spotting constraints.

4. The method of claim 1, wherein said filtering occurs using a web-based callback service specified in a WebFountain Query Language (WFQL) extensible Markup Language (XML) document.

5. The method of claim 1, wherein said database is run on a WebFountain platform.

6. The method of claim 1, wherein said specifying of said text analytic component comprises adding metadata requirements to said unstructured text query.

7. The method of claim 4, further comprising:

parsing said WFQL XML document;

initializing at least one query tag object;

formatting said WFQL XML document based on said query tag object;

parsing the formatted WFQL XML document as query results; and

generating a return XML document to a client server based on the parsed results.

8. A program storage device readable by computer, tangibly embodying a program of instructions executable by said computer to perform a method of retrieving data from a database comprising unstructured data, said method comprising:

specifying a text analytic component in an unstructured text query at query runtime;

submitting said unstructured text query to a web service database;

filtering unstructured text data in said web service database based on constraints defined in said text analytic component in said query; and

receiving the filtered unstructured text data based on the submitted query from said web service database.

9. The program storage device of claim 8, wherein said constraints comprise any of positive sentiments regarding an unstructured text document and negative sentiments regarding said unstructured text document.

10. The program storage device of claim 8, wherein said constraints comprise any of name spotting constraints, address spotting constraints, date spotting constraints, and entity spotting constraints.

11. The program storage device of claim 8, wherein said filtering occurs using a web-based callback service specified in a WebFountain Query Language (WFQL) eXtensible Markup Language (XML) document.

12. The program storage device of claim 8, wherein said database is run on a WebFountain platform.

13. The program storage device of claim 11, wherein said method further comprises:

parsing said WFQL XML document;

initializing at least one query tag object;

formatting said WFQL XML document based on said query tag object;

parsing the formatted WFQL XML document as query results; and

generating a return XML document to a client server based on the parsed results.

14. The program storage device of claim 8, wherein said specifying of said text analytic component comprises adding metadata requirements to said unstructured text query.

15. A system for retrieving data from a database comprising unstructured data, said system comprising:

a processor adapted to specify a text analytic component in an unstructured text query at query runtime;

a server adapted to submit said unstructured text query to a web service database;

a filter adapted to filter unstructured text data in said web service database based on constraints defined in said text analytic component in said query; and

a graphic user interface adapted to receive the filtered unstructured text data based on the submitted query from said web service database.

16. The system of claim 15, wherein said constraints comprise any of positive sentiments regarding an unstructured text document and negative sentiments regarding said unstructured text document.

17. The system of claim 15, wherein said constraints comprise any of name spotting constraints, address spotting constraints, date spotting constraints, and entity spotting constraints.

18. The system of claim 15, wherein said filter comprises a web-based callback service specified in a WebFountain Query Language (WFQL) eXtensible Markup Language (XML) document.

19. The system of claim 15, wherein said database is run on a WebFountain platform, and wherein said text analytic component comprises metadata requirements.

20. The system of claim 18, further comprising:

means for parsing said WFQL XML document;

means for initializing at least one query tag object;

means for formatting said WFQL XML document based on said query tag object;

means for parsing the formatted WFQL XML document as query results; and

means for generating a return XML document to a client server based on the parsed results.