一句话：系统研究 ORM 数据库 Web 应用中的常见性能反模式、性能影响与修复建议。
许多 Web 应用使用数据库进行持久化存储，并常借助对象关系映射（ORM）框架开发。ORM 隐藏了底层查询的生成与执行，使开发者难以编写高效程序；随着持久化数据规模增长，性能问题愈发严重。已有研究仅关注 ORM 性能问题的特定方面，缺乏对真实应用中常见性能反模式的系统性认识。本文对数据库支撑的 Web 应用开展系统性研究，旨在识别常见性能反模式，分析它们如何影响应用性能，并总结相应的修复与改进措施，为开发者实践和后续研究提供参考。
Many web applications use databases for persistent data storage, and using Object Relational Mapping (ORM) frameworks is a common way to develop such database-backed web applications. Unfortunately, developing efficient ORM applications is challenging, as the ORM framework hides the underlying database query generation and execution. This problem is becoming more severe as these applications need to process an increasingly large amount of persistent data. Recent research has targeted specific aspects of performance problems in ORM applications. However, there has not been any systematic study to identify common performance anti-patterns in real-world such applications, how they affect resulting application performance, and remedies for them.
DOI 原文 ·
@inproceedings{paperbot4538,
title = {How
<i>not</i>
to structure your database-backed web applications},
author = {Junwen Yang and Pranav Subramaniam and Shan Lu and Cong Yan and Alvin Cheung},
booktitle = {ICSE},
year = {2018},
doi = {10.1145/3180155.3180194}
}