文章基本信息

标题：Database Application Developer Tools Using Static Analysis and Dynamic Profiling
本地全文：下载
作者：Surajit Chaudhuri ; Vivek Narasayya ; Manoj Syamala 等
期刊名称：Bulletin of the Technical Committee on Data Engineering
出版年度：2014
卷号：37
期号：1
出版社：IEEE Computer Society
摘要：Database application developers use data access APIs such as ODBC, JDBC and ADO.NET to execute SQL queries. Although modern program analysis and code profilers are extensively used during appli- cation development, there is a significant gap in these technologies for database applications because these tools have little or no understanding of data access APIs or the database system. In our project at Microsoft Research, we have developed tools that: (a) Enhance traditional static analysis of pro- grams by leveraging understanding of database APIs to help developers identify security, correctness and performance problems early in the application development lifecycle. (b) Extend the existing DBMS and application profiling infrastructure to enable correlation of application events with DBMS events. This allows profiling across application, data access and DBMS layers thereby enabling a rich class of analysis, tuning and profiling tasks that are otherwise not easily possible.