GENERATING SQL QUERIES FROM DECLARATIVE QUERIES FOR SEMI-STRUCTURED DATA

• US 20170024432A1
• Filed: 07/24/2015
• Published: 01/26/2017
• Est. Priority Date: 07/24/2015
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Behnen, Marion E.
• Application Number:
  US14/808,191
• Publication Number:
  US 20170024432A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2452 Query translation
• CPC Class Codes: G06F 16/24534 Query rewriting; Transformation
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

A method for generating database queries from declarative queries having a known syntax. The method includes a query preparation software receiving a declarative query for a relational database management system, in a known system form. The query preparation software then analyzes the declarative query to build a set of generic query tasks with identified data types. The query preparation software then optimizes the set of generic query tasks and builds a target database query from the optimized generic query tasks reflecting features of a target database. The method further includes submitting the target database query to the targeted database and receiving results from the target database query.

Claims

1. A method for generating database queries from declarative queries having a known syntax comprising:

receiving, by one or more processors, a declarative query in a known system form;

analyzing, by one or more processors, the declarative query to build a set of generic query tasks with identified data types;

optimizing, by one or more processors, the set of generic query tasks; and

building, by one or more processors, a target database query from the optimized generic query tasks reflecting features of a target database.

2. The method of claim 1, further comprising:

submitting, by one or more processors, the target database query to the targeted database; and

receiving, by one or more processors, results from the target database query.

3. The method of claim 1, wherein the optimizing of the set of generic query tasks comprises performing actions selected from a group comprising adding tasks, re-arranging tasks, and combining subsets of tasks.

4. The method of claim 1, wherein the declarative query in the known system form is a set of JavaScript Object Notation (JSON) query statements and the target database supports Structured Query Language (SQL) queries.

5. The method of claim 4, further comprising:

providing, by one or more processors, a validation of mappings between fields in the set of JSON query statements to attributes in the generated language-independent query tasks; and

assigning, by one or more processors, one or more data types to attributes in the generated query tasks.

6. The method of claim 1, further comprising:

providing, by one or more processors, a user with an interface for adjusting specific features and/or properties in order to customize generation of the target database query.

7. The method of claim 1, further comprising:

receiving, by one or more processors, a second declarative query in a second known system form;

analyzing, by one or more processors, the second declarative query to build a set of second generic query tasks with identified data types;

optimizing, by one or more processors, the set of second generic query tasks; and

building, by one or more processors, a second target database query from the optimized set of second generic query tasks reflecting features of the target database.

8. A computer program product for generating database queries from declarative queries having a known syntax, the computer program product comprising:

one or more computer readable storage media and program instructions stored on the one or more computer readable storage media, the program instructions comprising;

program instructions to receive a declarative query in a known system form;

program instructions to analyze the declarative query to build a set of generic query tasks with identified data types;

program instructions to optimize the set of generic query tasks; and

program instructions to build a target database query from the optimized generic query tasks reflecting features of a target database.

9. The computer program product of claim 8, further comprising:

program instructions to submit the target database query to the targeted database; and

program instructions to receive results from the target database query.

10. The computer program product of claim 8, wherein the optimizing of the set of generic query tasks comprises performing actions selected from a group comprising adding tasks, re-arranging tasks, and combining subsets of tasks.

11. The computer program product of claim 8, wherein the declarative query in the known system form is a set of JavaScript Object Notation (JSON) query statements and the target database supports Structured Query Language (SQL) queries.

12. The computer program product of claim 11, further comprising:

program instructions to provide a validation of mappings between fields in the set of JSON query statements to attributes in the generated language-independent query tasks; and

program instructions to assign one or more data types to attributes in the generated query tasks.

13. The computer program product of claim 8, further comprising:

program instructions to provide a user with an interface for adjusting specific features and/or properties in order to customize generation of the target database query.

14. The computer program product of claim 8, further comprising:

program instructions to receive a second declarative query in a second known system form;

program instructions to analyze the second declarative query to build a set of second generic query tasks with identified data types;

program instructions to optimize the set of second generic query tasks; and

program instructions to build a second target database query from the optimized set of second generic query tasks reflecting features of the target database.

15. A computer system for generating database queries from declarative queries having a known syntax, the computer system comprising:

one or more computer processors;

one or more computer readable storage media;

program instructions stored on the computer readable storage media for execution by at least one of the one or more processors, the program instructions comprising;

program instructions to receive a declarative query in a known system form;

program instructions to analyze the declarative query to build a set of generic query tasks with identified data types;

program instructions to optimize the set of generic query tasks; and

program instructions to build a target database query from the optimized generic query tasks reflecting features of a target database.

16. The computer system of claim 15, further comprising:

program instructions to submit the target database query to the targeted database; and

program instructions to receive results from the target database query.

17. The computer system of claim 15, wherein the optimizing of the set of generic query tasks comprises performing actions selected from a group comprising adding tasks, re-arranging tasks, and combining subsets of tasks.

18. The computer system of claim 15, wherein the declarative query in the known system form is a set of JavaScript Object Notation (JSON) query statements and the target database supports Structured Query Language (SQL) queries.

19. The computer system of claim 18, further comprising:

program instructions to provide a validation of mappings between fields in the set of JSON query statements to attributes in the generated language-independent query tasks; and

program instructions to assign one or more data types to attributes in the generated query tasks.

20. The computer system of claim 15, further comprising:

program instructions to receive a second declarative query in a second known system form;

program instructions to analyze the second declarative query to build a set of second generic query tasks with identified data types;

program instructions to optimize the set of second generic query tasks; and

program instructions to build a second target database query from the optimized set of second generic query tasks reflecting features of the target database.