2 posts tagged with "optimization"

Query-by-Synthesis (QBS) [@cheung2013optimizing] is a system developed to optimize database applications via static analysis. It is a very powerful system that, in the end, converts sections of code that would otherwise perform relational-query-like operations on the application server to a semantically equivalent SQL query that can be run on the DBMS.

A lot of developer work on database applications goes into making sure the interaction between the application layer and the database layer is efficient. In my experience in industry, this work is mostly done manually, and in an ad-hoc fashion. [@ramachandra2014database] give an account about some ways this can be done manually.