Turkish Journal of Computer and Mathematics Education
Journal license

Journal

Turkish Journal of Computer and Mathematics Education


Volume
& Issue

Volume 12, Issue 2


Published
on

April 5, 2021


Pages

2680-2691


DOI

Article

A novel framework for synthesizing nested queries in SQL from business requirements language


Authors

Mathew George Affiliation:
Department of Computer Science CHRIST, Bangalore
and Dr. Rohini V Affiliation:
Department of Computer Science CHRIST, Bangalore


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

Bags, Combinator, Initial Algebra, Orthogonal, Structural Recursion, Monad Comprehensions, Folds


Citation

George, M. & V, D. R. (2021). A novel framework for synthesizing nested queries in SQL from business requirements language. Turkish Journal of Computer and Mathematics Education, 12(2), 2680–2691.

Published by: Engineering Journals

Engineering Journals Logo