A novel framework for synthesizing nested queries in SQL from business requirements language
Main Article Content
Abstract
Different methods and systems were proposed in the past for translating Natural Language (NL) statements in to Structured Query Language (SQL) queries. Translating statements resultingin‘nested’queries havealways been a challenge and was not effectively handled. This work proposes a framework for translating requirement statementsresulting inthe construction of nested Queries. While translating nested scenarios; often thereis a need to create sub-queriesthat execute inpipeline orin parallel or both operating together.Lambda Calculus is found to be effective in representing the intermediate expressions and helps in performing the transformations that are needed in translating specific predicates into SQL, but its inflexibility in combining parallel computations is a constraint. To represent clauses that are in parallel or arein pipeline,and to perform the required transformationson theintermediate expressions involving these,more advancedprogramming constructs are needed.This work recommends the use of advanced language constructs and adoptsfunctional programming techniques for performing the required transformation at the intermediate language level.
Downloads
Metrics
Article Details
You are free to:
- Share — copy and redistribute the material in any medium or format for any purpose, even commercially.
- Adapt — remix, transform, and build upon the material for any purpose, even commercially.
- The licensor cannot revoke these freedoms as long as you follow the license terms.
Under the following terms:
- Attribution — You must give appropriate credit , provide a link to the license, and indicate if changes were made . You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
- No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.
Notices:
You do not have to comply with the license for elements of the material in the public domain or where your use is permitted by an applicable exception or limitation .
No warranties are given. The license may not give you all of the permissions necessary for your intended use. For example, other rights such as publicity, privacy, or moral rights may limit how you use the material.