Distributed Analytical Search Utilizing Semantic Analysis of Natural Language

• US 20160171050A1
• Filed: 11/20/2015
• Published: 06/16/2016
• Est. Priority Date: 11/20/2014
• Status: Abandoned Application

• Current Assignee: Subrata Das
• Original Assignee: Subrata Das
• Inventors: Das, Subrata
• Application Number:
  US14/947,060
• Publication Number:
  US 20160171050A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/90332 Natural language query formulation or dialogue systems

Abstract

A distributed Analytical search for data irrespective of location, content or format for querying multiple data sources by users who have no foreknowledge of the location or content of the data or metadata. Distributed Analytical Search (DAS) allows a user to pose natural language questions to multiple data stores of both structured and unstructured data of any size simultaneously without the user needing to know anything about the metadata of the source or sources and without any specialized knowledge of SQL or other computing technologies. Natural language queries are translated into machine recognizable queries and sub-queries based on database wrapper and then automatically executed on all or selected nodes in the domain, with the data owner(s) maintaining autonomy over their respective data stores.

Claims

1. A method for searching structured and unstructured data in at least one database to generate query results, comprising:

accepting at least one query from a user in natural language;

translating the natural language query into machine recognizable queries;

optimizing the machine recognizable queries;

executing a search of the database; and

generating at least one query result.

2. The method of claim 1 further including spawning at least one query agent with embedded code and itinerary.

3. The method of claim 2 wherein the query agent is dispatched to a first site, selects specified data and creates a first table.

4. The method of claim 3 wherein the query agent carries the first table to a second site and performs a join operation with additional data.

5. The method of claim 1 wherein the machine recognizable queries include at least one XML query plan.

6. The method of claim 1 wherein translating the natural language query includes preparing at least one initial SQL query.

7. The method of claim 6 further including representing the initial SQL query in natural language to the user and requesting feedback from the user for the accuracy of the initial SQL query.

8. A system for searching structured and unstructured data in at least one database to generate query results, comprising:

at least one user interface capable of accepting at least one query from a user in natural language;

a translation module capable of translating the natural language query into machine recognizable queries;

a query planning and optimization module capable of optimizing the machine recognizable queries; and

a query execution module capable of executing a search of the database and generating at least one query result.

9. The system of claim 8 wherein the translation module is capable of preparing at least one initial SQL query and then representing the initial SQL query in natural language to the user and requesting feedback from the user for the accuracy of the initial SQL query.

10. A system for searching structured and unstructured data in at least one database to generate query results, including at least one user interface and at least one processor executing a program performing the steps of:

accepting at least one query, from a user via the user interface, in natural language;

translating the natural language query into machine recognizable queries;

optimizing the machine recognizable queries;

executing a search of the database;

generating at least one query result; and

transmitting the query result to the user.

11. The system of claim 10 further including spawning at least one query agent with embedded code and itinerary.

12. The system of claim 11 wherein the query agent is dispatched to a first site, selects specified data and creates a first table, and wherein the query agent carries the first table to a second site and performs a join operation with additional data.

13. The system of claim 12 wherein the machine recognizable queries include at least one XML query plan.

14. The system of claim 13 wherein the program is capable of preparing at least one initial SQL query and then representing the initial SQL query in natural language to the user and requesting feedback from the user for the accuracy of the initial SQL query.