SQLizer: query synthesis from natural language

N Yaghmazadeh, Y Wang, I Dillig, T Dillig - Proceedings of the ACM on …, 2017 - dl.acm.org
This paper presents a new technique for automatically synthesizing SQL queries from
natural language (NL). At the core of our technique is a new NL-based program synthesis …

Optimizing database-backed applications with query synthesis

A Cheung, A Solar-Lezama, S Madden - ACM SIGPLAN Notices, 2013 - dl.acm.org
Object-relational mapping libraries are a popular way for applications to interact with
databases because they provide transparent access to the database using the same …

Verified lifting of stencil computations

S Kamil, A Cheung, S Itzhaky, A Solar-Lezama - ACM SIGPLAN Notices, 2016 - dl.acm.org
This paper demonstrates a novel combination of program synthesis and verification to lift
stencil computations from low-level Fortran code to a high-level summary expressed using a …

Automatic partitioning of database applications

A Cheung, O Arden, S Madden, AC Myers - arXiv preprint arXiv …, 2012 - arxiv.org
Database-backed applications are nearly ubiquitous in our daily lives. Applications that
make many small accesses to the database create two challenges for developers: increased …

Building efficient query engines in a high-level language

A Shaikhha, Y Klonatos, C Koch - ACM Transactions on Database …, 2018 - dl.acm.org
Abstraction without regret refers to the vision of using high-level programming languages for
systems development without experiencing a negative impact on performance. A database …

Sloth: Being lazy is a virtue (when issuing database queries)

A Cheung, S Madden, A Solar-Lezama - ACM Transactions on Database …, 2016 - dl.acm.org
Many web applications store persistent data in databases. During execution, such
applications spend a significant amount of time communicating with the database for …

Extracting equivalent sql from imperative code in database applications

KV Emani, K Ramachandra, S Bhattacharya… - Proceedings of the …, 2016 - dl.acm.org
Optimizing the performance of database applications is an area of practical importance, and
has received significant attention in recent years. In this paper we present an approach to …

UDF to SQL translation through compositional lazy inductive synthesis

G Zhang, Y Xu, X Shen, I Dillig - … of the ACM on Programming Languages, 2021 - dl.acm.org
Many data processing systems allow SQL queries that call user-defined functions (UDFs)
written in conventional programming languages. While such SQL extensions provide …

Hadooptosql: a mapreduce query optimizer

MY Iu, W Zwaenepoel - Proceedings of the 5th European conference on …, 2010 - dl.acm.org
MapReduce is a cost-effective way to achieve scalable performance for many log-
processing workloads. These workloads typically process their entire dataset. MapReduce …

Type-and content-driven synthesis of SQL queries from natural language

N Yaghmazadeh, Y Wang, I Dillig, T Dillig - arXiv preprint arXiv …, 2017 - arxiv.org
This paper presents a new technique for automatically synthesizing SQL queries from
natural language. Our technique is fully automated, works for any database without requiring …