CAREER: Integrating Programming Languages and Databases

CCF CAREER 0448128William R. CookUniversity of Texas at Austin集成编程语言和数据库使用数据库的程序是我们信息基础设施的核心。 但是，由于过程语言和关系数据库基于不同的语义基础和优化策略，构建高效、可维护的面向数据系统是困难的。此外，数据库和编程是分开教授的，因此在一个领域受过训练的开发人员可能不是另一个领域的专家。最后，对不同的一体化方法的绩效没有进行充分的评价。该项目的目标是创建方法，语言和工具，使应用程序员能够轻松开发高效和结构良好的程序，将数据库处理集成到过程程序中。编程语言将扩展到指定模块化和类型安全的数据库操作，同时利用数据库查询优化和并发控制。近期的研究将集中在将查询定义为现有系统上下文中的类型安全类。长期的研究将集中在从过程程序中提取数据库查询。除了传统的性能基准之外，还将使用开放源码应用程序来测试拟议解决方案的有效性。该项目还将探讨如何将数据库和编程课程结合起来。总之，这些结果可以显着提高软件系统的开发，结合联合收割机过程编程与关系数据库。

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.