Transaction Management in a Heterogeneous Database Environment

异构数据库环境中的事务管理

• 批准号: 9221301
• 负责人: Abraham Silberschatz
• 金额: $ 15.66万
• 依托单位: University of Texas at Austin
• 依托单位国家: 美国
• 项目类别: Continuing Grant
• 财政年份: 1993
• 资助国家: 美国
• 起止时间: 1993-09-01 至 1996-08-31
• 项目状态: 已结题
• 来源: https://www.nsf.gov/awardsearch/showAward?AWD_ID=9221301&HistoricalAwards=false
• 关键词: Transaction; Management; Heterogeneous; Database; Environment

9221301 Silberschatz Transaction Management in a Heterogeneous Database Environment This is the first year of a three-year continuing award. A multidatabase system (MDBS) consists of a number of sites which run distinct commercial database management systems (DBMSs). The goal of an MDBS is to integrate the DBMSs, allowing applications to access data from, without requiring modifications to, the individual DBMSs. The autonomous user organizations in a multidatabase system generally have invested substantial capital in the DBMS and may, rightly, be unwilling to modify or lose control over their DBMSs. Therefore, it is imperative to develop multidatabase transaction processing methods that allow a high degree of local autonomy, but support users' data in a consistent and reliable manner. This research investigates how to manage and guarantee consistency of data residing in heterogeneous DBMSs, while adhering to the autonomy requirements of the participant DBMSs. The MDBS transaction management schemes developed in this research have the following characteristics: (1) adapt to MDBS environments, existing techniques for ensuring database consistency based on preserving transaction atomicity and serializability; (2) utilize alternate correctness criteria that relax the serializability and atomicity requirements. Pilot systems developed for both the serializability and the relaxed serializability models are used to conduct performance evaluation to ascertain that the developed schemes permit a high degree of concurrency. The results of the research will provide the basic transaction management mechanisms necessary for the development of a complete multidatabase management system. ***

9221301异类数据库环境中的Silberschatz事务管理这是为期三年的连续奖项的第一年。多数据库系统(MDB)由多个运行不同商业数据库管理系统(DBMS)的站点组成。MDBS的目标是集成DBMS，允许应用程序访问来自各个DBMS的数据，而无需对其进行修改。多数据库系统中的自主用户组织通常在DBMS中投入了大量资本，并且可能不愿意修改或失去对其DBMS的控制，这是正确的。因此，开发多数据库事务处理方法势在必行，这些方法允许高度的本地自治，但以一致和可靠的方式支持用户数据。本研究探讨了如何管理和保证驻留在异质DBMS中的数据的一致性，同时遵循参与者DBMS的自治要求。本研究开发的MDBS事务管理方案具有以下特点：(1)适应MDBS环境，基于保持事务原子性和可串行化来确保数据库一致性的现有技术；(2)使用放宽可串行化和原子性要求的替代正确性准则。使用为可串行化和放松可串行化模型开发的试点系统来进行性能评估，以确定所开发的方案允许高度并发。研究结果将为开发一个完整的多数据库管理系统提供必要的基本事务管理机制。***