CAREER: Integrating Programming Languages and Databases

集成编程语言和数据库使用数据库的程序是我们信息基础设施的核心。但是，由于过程语言和关系数据库基于不同的语义基础和优化策略，构建高效且可维护的面向数据的系统是困难的。此外，数据库和编程是分开教授的，因此在一个领域受过培训的开发人员可能不擅长另一个领域。最后，对不同集成方法的性能评价不够充分。该项目的目标是创建方法、语言和工具，使应用程序程序员能够轻松地为将数据库处理集成到过程程序中的应用程序开发高效且结构良好的程序。编程语言将得到扩展，以指定模块化和类型安全的数据库操作，同时利用数据库查询优化和并发控制。近期的研究将集中在将查询定义为现有系统上下文中的类型安全类。长期研究将集中于从程序程序中提取数据库查询。除了传统的性能基准测试之外，开源应用程序还将用于测试所提出解决方案的有效性。该项目还将探索整合数据库和编程课程的方法。综上所述，这些结果可以显著地改进将过程编程与关系数据库相结合的软件系统的开发。

CCF CAREER 0448128William R. CookUniversity of Texas at AustinIntegrating Programming Languages and Databases Programs that use databases are central to our information infrastructure. But building efficient and maintainable data-oriented systems is difficult because procedural languages and relational databases are based on different semantic foundations and optimization strategies. In addition, databases and programming are taught separately so that developers trained in one domain may not be expert in the other domain. Finally, there has not been sufficient evaluation of the performance of different integration approaches. The goal of this project is to create methods, languages and tools which enable application programmers to readily develop efficient and well-structured programs for applications that integrate database processinginto procedural programs. Programming languages will be extended to specify modular and type-safe database operations, while leveraging database query optimization and concurrency control. Near-term research will focus on defining queries as type-safe classes within the context of existing systems. Longer-term research will focus on extracting database queries from procedural programs. In additional to traditional performance benchmarking, open-source applications will be used to test the effectiveness of proposed solutions. The project will also explore ways to integrate database and programming courses. Taken together, these results can significantly improve the development of software systems that combine procedural programming withrelational databases.