Generating structured queries from natural language text
View Patent ↗Generating structured queries from natural language text may include receiving, using a processor, a natural language text input directed to a database management system and, using the processor, performing natural language processing on the natural language text input using an Unstructured Information Management Architecture. The natural language processing may annotate the natural language text input according to a structure of the database management system. A database operation and query elements may be determined using a processor from the annotated natural language text input. A structured query may be created, using the processor, for the database management system that implements the database operation using the query elements.
1. A computer-implemented method, comprising:
receiving a natural language text input directed to a database management system;
performing natural language processing on the natural language text input by annotating the natural language text input with annotations that are based upon a query structure of the database management system;
determining, from the annotations, a database operation;
determining, from the annotations, query elements; and
creating, using the query elements determined from the annotations, a structured query that implements the database operation on the database management system, wherein
the query elements are directly included in the structured query.
2. The method of claim 1 , wherein:
the database management system is accessed using the structured query.
3. The method of claim 1 , wherein
the performing natural language processing includes analyzing the natural language text input using a plurality of annotators.
4. The method of claim 1 , wherein
the structured query is specified in Structured Query Language.
5. The method of claim 1 , wherein
the performing natural language processing includes:
determining a table of the database management system from the natural language text input using a table annotator; and
determining a column of the table of the database management system using a column annotator.
6. The method of claim 5 , wherein
the determining the database operation and query elements includes:
determining a database operation selected from the group consisting of a create, a read, an update, and a delete operation; and
determining Structured Query Language elements for the structured query according to the table and the column.
7. The method of claim 6 , wherein
the determining the database operation and query elements includes determining constraints applied by the Structured Query Language elements.
8. A computer hardware system, comprising:
a hardware processor programmed to initiate the following executable operations:
receiving a natural language text input directed to a database management system;
performing natural language processing on the natural language text input by annotating the natural language text input with annotations that are based upon a query structure of the database management system;
determining, from the annotations, a database operation;
determining, from the annotations, query elements; and
creating, using the query elements determined from the annotations, a structured query that implements the database operation on the database management system,
wherein
the query elements are directly included in the structured query.
9. The system of claim 8 , wherein:
the database management system is accessed using the structured query.
10. The system of claim 8 , wherein
the performing natural language processing includes analyzing the natural language text input using a plurality of annotators.
11. The system of claim 8 , wherein
the structured query is specified in Structured Query Language.
12. The system of claim 8 , wherein
the performing natural language processing includes:
determining a table of the database management system from the natural language text input using a table annotator; and
determining a column of the table of the database management system using a column annotator.
13. The system of claim 12 , wherein
the determining the database operation and query elements includes:
determining a database operation selected from the group consisting of a create, a read, an update, and a delete operation; and
determining Structured Query Language elements for the structured query according to the table and the column.
14. The system of claim 13 , wherein
the determining the database operation and query elements includes determining constraints applied by the Structured Query Language elements.
15. A computer program product, comprising:
a computer readable storage medium having program code stored thereon,
the program code executable by a computer hardware system to perform:
receiving a natural language text input directed to a database management system;
performing natural language processing on the natural language text input by annotating the natural language text input with annotations that are based upon a query structure of the database management system;
determining, from the annotations, a database operation;
determining, from the annotations, query elements; and
creating, using the query elements determined from the annotations, a structured query that implements the database operation on the database management system,
wherein
the query elements are directly included in the structured query.
16. The computer program product of claim 15 , wherein:
the database management system is accessed using the structured query.
17. The computer program product of claim 15 , wherein
the performing natural language processing includes analyzing the natural language text input using a plurality of annotators.
18. The computer program product of claim 15 , wherein
the structured query is specified in Structured Query Language.
19. The computer program product of claim 15 , wherein
the performing natural language processing includes:
determining a table of the database management system from the natural language text input using a table annotator; and
determining a column of the table of the database management system using a column annotator.
20. The computer program product of claim 19 , wherein
the determining the database operation and query elements includes:
determining a database operation selected from the group consisting of a create, a read, an update, and a delete operation; and
determining Structured Query Language elements for the structured query according to the table and the column.