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

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

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

III-COR: Collaborative Research: Graceful Evolution and HistoricalQueries in Information Systems-- a Unified ApproachDatabase schema evolution is a constant in the life-cycle ofInformation Systems (IS), and a source of major costs for maintenance,upgrading, and service down time. The traditional process ofinstalling a new schema, converting the database, and rewritingapplications is slow and laborious. Instead, this project developsthe novel technology whereby the schema evolution problem isreduced to coordinating mappings between multiple concurrentversions of schema, applications, and database. The project'sapproach consists of developing: (i) XML-based architectures forunifying the management of evolving data and metadata, (ii)methods for capturing evolution via schema mappings, (iii)efficient mapping techniques for queries and applications. Theseadvances will enable the development of the MetaManager, a systemthat supports: (a) preserving and querying database histories, and(b) better planning on how-to evolve current schema versions, viaevaluation and testing of ``what-if'' scenarios. Itsfunctionality and performance are validated using various testbeds,including the SDSC Storage Request Broker, which hosts scientificdata for research groups ranging from astrophysicists tobiologists.This novel and timely approach provides a solution to both theevolution and preservation of IS. Because of thekey role played by IS, a broad range of scientific, educational,and economic activities will benefit. Project funds supporttraining of PhD students while undergraduate research interns aretrained on schema-evolution scenarios using the MetaManager. Thetechnology is a part of database design courses. Results aredisseminated via publications, reports and demos which are available from:http://www.cs.ucr.edu/~tsotras/meta-managerhttp://wis.cs.ucla.edu/projects/meta-managerhttp://db.ucsd.edu/people/alin/meta-manager

III-COR：协作研究：信息系统中的优雅演化和历史查询——一种统一的方法数据库模式演化是信息系统（is）生命周期中的一个常量，也是维护、升级和服务停机时间的主要成本来源。安装新模式、转换数据库和重写应用程序的传统过程既缓慢又费力。相反，这个项目开发了一种新的技术，通过这种技术，模式演化问题被简化为在模式、应用程序和数据库的多个并发版本之间协调映射。该项目的方法包括开发：(i)基于xml的架构，用于统一管理不断演变的数据和元数据；（ii）通过模式映射捕获演变的方法；（iii）查询和应用程序的高效映射技术。这些进步将使MetaManager的开发成为可能，该系统支持：(a)保存和查询数据库历史，以及(b)通过评估和测试“假设”场景，更好地规划如何发展当前模式版本。它的功能和性能使用各种测试平台进行验证，包括SDSC存储请求代理，它为从天体物理学家到生物学家的研究小组提供科学数据。这种新颖而及时的方法为IS的进化和保存提供了一个解决方案。由于伊斯兰国所扮演的关键角色，广泛的科学、教育和经济活动将从中受益。项目资金支持博士生的培训，而本科生研究实习生则使用MetaManager进行模式演化场景的培训。该技术是数据库设计课程的一部分。研究结果通过出版物、报告和演示进行传播，可从http://www.cs.ucr.edu/~tsotras/meta-managerhttp://wis.cs.ucla.edu/projects/meta-managerhttp://db.ucsd.edu/people/alin/meta-manager获取