III-COR: Collaborative Research: Graceful Evolution and Historical Queries in Information Systems--a Unified Approach

III-COR：协作研究：信息系统中的优雅进化和历史查询——统一方法

• 批准号: 0705345
• 负责人: Carlo Zaniolo
• 金额: $ 20.47万
• 依托单位: University of California-Los Angeles
• 依托单位国家: 美国
• 项目类别: Standard Grant
• 财政年份: 2007
• 资助国家: 美国
• 起止时间: 2007-09-01 至 2010-08-31
• 项目状态: 已结题
• 来源: https://www.nsf.gov/awardsearch/showAward?AWD_ID=0705345&HistoricalAwards=false
• 关键词: III; COR; Collaborative; Research; Graceful

III-COR: Collaborative Research: Graceful Evolution and Historical Queries in Information Systems-- a Unified Approach Database schema evolution represents a constant in the life cycle of Information Systems, and is the source of major costs for maintenance, upgrading, and service down time. The traditional schema revision process depends on the installation of a new schema along with the revised database, and a converted set of applications (laboriously rewritten to work with this schema). Instead, this project develops the novel enabling technology whereby the schema evolution problem is reduced to coordinating mappings between multiple concurrent versions of the schema, applications, and the database. This is realized by the Meta-Manager system which provides integrated management of evolving (i) data, and (ii) metadata, and efficiently supports the (iii) mappings, and (iv) software artifacts needed for graceful schema evolution. Further, the Meta-Manager allows for preservation and querying of database history while it assists the user in planning how to evolve the current schema version with ``what-if'' evolution scenarios. The functionality and performance of the system is validated using various testbeds, such as, the San Diego Supercomputing Center's Storage Request Broker, which hosts scientific data for various research groups ranging from astrophysicists to biologists. This novel and timely approach provides a unified solution to both the evolution and preservation of information systems. Because of the key role played by information systems, a broad range of scientific, educational, and economic activities will benefit from these advances. Results are disseminated via publications, reports and demos available from the project web sites: http://www.cs.ucr.edu/~tsotras/meta-manager http://wis.cs.ucla.edu/projects/meta-manager http://db.ucsd.edu/people/alin/meta-manager

III-COR：协作研究：信息系统中的优雅演化和历史查询——统一方法数据库模式演化代表了信息系统生命周期中的一个常量，并且是维护、升级和服务停机时间的主要成本来源。传统的模式修订过程依赖于新模式以及修订后的数据库的安装，以及转换后的一组应用程序（费力地重新编写以使用该模式）。相反，这个项目开发了一种新的启用技术，通过这种技术，模式演化问题被简化为在模式、应用程序和数据库的多个并发版本之间协调映射。这是由Meta-Manager系统实现的，该系统提供了对进化(i)数据和（ii）元数据的集成管理，并有效地支持（iii）映射和（iv）优雅模式进化所需的软件工件。此外，元管理器允许保存和查询数据库历史，同时它帮助用户规划如何使用“假设”进化场景来进化当前模式版本。系统的功能和性能使用各种测试平台进行验证，例如，圣地亚哥超级计算中心的存储请求代理，它为从天体物理学家到生物学家的各种研究小组提供科学数据。这种新颖而及时的方法为信息系统的发展和保存提供了统一的解决方案。由于信息系统所起的关键作用，广泛的科学、教育和经济活动将受益于这些进步。研究结果通过项目网站（http://www.cs.ucr.edu/~tsotras/meta-manager http://wis.cs.ucla.edu/projects/meta-manager http://db.ucsd.edu/people/alin/meta-manager）上的出版物、报告和演示文稿进行传播