Optimizing Database-Backed Applications with Query Synthesis

Channel:
Microsoft Research
Subscribers:
344,000
Published on ● Video Link: https://www.youtube.com/watch?v=gKXS2jibd5E


Duration: 1:03:49
189 views
3

Modern web applications are frequently built using object-relational mapping (ORM) frameworks. Such frameworks aim to provide transparent access to the database by allowing developers express persistent data accesses using the same language as the application. Unfortunately, due to a variety of reasons, developers often write application code that does not take advantage of the optimized relational implementations that database systems provide, and the ORM framework cannot optimize such code as it lacks knowledge about the application logic. In this talk, we present Query By Synthesis (QBS), a system that automatically identifies imperative program fragments and uses program synthesis to convert functionality written as imperative code into relational queries to be executed in the database. Using real-world examples, we show that QBS can convert a variety of imperative constructs into relational queries, and can improve application performance by orders of magnitude.



Other Videos By Microsoft Research


2016-07-27Developing Natural Language-based Software Analyses & Tools to Expedite Software Maintenance
2016-07-27Semi-Supervised Learning for Acoustic and Prosodic Modeling in Speech Recognition
2016-07-27Code Bubbles: Making the Vision Real
2016-07-27A novel framework of effective resource management for multi-hop wireless networks
2016-07-27Trajectories and the Extended User Experience
2016-07-27Programming Devices and Services with P - Lecture 1
2016-07-27Local Combinatorics, and Some Words on Local-to-Global Phenomena
2016-07-27Hastings-Levitov aggregation in the small-particle limit
2016-07-27Monitoring the Snowpack in Remote, Ungauged Mountains from Satellite and Computers
2016-07-27Self-Organizing Cellular Automata
2016-07-27Optimizing Database-Backed Applications with Query Synthesis
2016-07-27Introducing Microsoft Pix – A Smarter Camera App
2016-07-26Getting Ready for Change: Handling Concept Drift in Predictive Analytics
2016-07-26The Lab as Studio: Stories from Microsoft Research's first visiting artist
2016-07-26Distributed Optimization via Alternating Direction Method of Multipliers
2016-07-26Role of symbolic execution in software testing, debugging and repair
2016-07-26Can You Hide in an Internet Panopticon?
2016-07-26Intersection of two passions
2016-07-26Analysis of Boolean Functions: advances and challenges
2016-07-26Two basic problems in finite stochastic optimization
2016-07-26Decision Learning: Learning with Strategic Decision Making


Tags:
microsoft research