Understanding and Improving Database-backed Applications

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


Duration: 1:05:23
1,908 views
61

From online shopping to social media websites, many applications are built using imperative languages like Java, Python or Ruby while store its data in a persistent relational database. Such architecture enables fast development of application logic using object-oriented data model while leverages the convenient persistent-data management of relational databases. However, the separation between the application and the database often leads to performance issues.

In this talk, I will introduce our empirical studies on real-world applications’ performance, and our approaches in understanding and solving performance-related issues. In particular, I will present three projects: 1) Chestnut, a data layout designer to customize in-memory data layout and query processing for each application; 2) Quro, a compiler to optimize query order for transaction applications; and 3) Panorama, an interactive tool to help developers make webpage design-performance tradeoff. These projects include holistic optimizations of the application and the database which are transparent to the developer, as well as interactive solutions to help developer better understand and improve their application.

See more at https://www.microsoft.com/en-us/research/video/understanding-and-improving-database-backed-applications/



Other Videos By Microsoft Research


2020-05-13Diving into Deep InfoMax with Dr. Devon Hjelm | Podcast
2020-05-08An Introduction to Graph Neural Networks: Models and Applications
2020-05-07MSR Cambridge Lecture Series: Photonic-chip-based soliton microcombs
2020-05-07Multi-level Optimization Approaches to Computer Vision
2020-05-05How good is your classifier? Revisiting the role of evaluation metrics in machine learning
2020-05-05Fast and Flexible Multi-Task Classification Using Conditional Neural Adaptive Processes
2020-05-05Hypergradient descent and Universal Probabilistic Programming
2020-05-04Learning over sets, subgraphs, and streams: How to accurately incorporate graph context
2020-05-04An Ethical Crisis in Computing?
2020-04-21Presentation on “Beyond the Prototype” by Rushil Khurana
2020-04-20Understanding and Improving Database-backed Applications
2020-04-20Efficient Learning from Diverse Sources of Information
2020-04-08Project Orleans and the distributed database future with Dr. Philip Bernstein | Podcast
2020-04-07Reprogramming the American Dream: A conversation with Kevin Scott and J.D. Vance, with Greg Shaw
2020-04-01An interview with Microsoft President Brad Smith | Podcast
2020-03-30Microsoft Rocketbox Avatar library
2020-03-27Virtual reality without vision: A haptic and auditory white cane to navigate complex virtual worlds
2020-03-26Statistical Frameworks for Mapping 3D Shape Variation onto Genotypic and Phenotypic Variation
2020-03-26Can Machines Perceive Emotion?
2020-03-25Microsoft’s AI Transformation, Project Turing and smarter search with Rangan Majumder | Podcast
2020-03-19Enabling Rural Communities to Participate in Crowdsourcing, with Dr. Vivek Seshadri | Podcast


Tags:
database-backed applications
Yeye He
Cong Yan
relational database
object-oriented data model
microsoft research
database optimization