Article
A novel framework for synthesizing nested queries in SQL from business requirements language
Authors
Abstract
Different methods and systems were proposed in the past for translating Natural Language (NL) statements into Structured Query Language (SQL) queries. Translating statements resulting in ‘nested’ queries have always been a challenge and was not effectively handled. This work proposes a framework for translating requirement statements resulting in the construction of nested Queries. While translating nested scenarios; often there is a need to create sub-queries that execute in pipeline or in 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 are in pipeline, and to perform the required transformations on the intermediate expressions involving these, more advanced programming constructs are needed. This work recommends the use of advanced language constructs and adopts functional programming techniques for performing the required transformation at the intermediate language level.
Keywords
Citation
Published by: Engineering Journals


