Distributed Real-Time Transaction Processing

分布式实时事务处理

• 批准号: 183943-2012
• 负责人: Haque, WaqarU
• 金额: $ 1.24万
• 依托单位: University of Northern British Columbia
• 依托单位国家: 加拿大
• 项目类别: Discovery Grants Program - Individual
• 财政年份: 2015
• 资助国家: 加拿大
• 起止时间: 2015-01-01 至 2016-12-31
• 项目状态: 已结题
• 来源: https://www.nserc-crsng.gc.ca/ase-oro/Details-Detailles_eng.asp?id=569672
• 关键词: Distributed; Real; Time; Transaction; Processing

Many real-world applications such as airline reservations and stock markets require real-time response while interacting with large, geographically distributed, databases. Transactions in such a system have deadlines, but there are no catastrophic events if a deadline is missed; however, a penalty must be paid for late completion (same concept as paying your taxes after the April 30 deadline). The primary goal is to meet the deadlines, but for transactions that miss it, the delay must be minimized. For instance, a typical requirement may be that 95% of transactions complete in less than 2 seconds. Prior to building large/expensive networks and distributed systems, efficient protocols must be designed and tested to demonstrate their optimal performance under a variety of conditions. To do this cost-effectively, we propose a modular approach for development and testing in a simulated environment. Among other things, the simulator should be capable of simulating low, moderate and high load conditions. An interactive graphical user interface would allow a combination of input parameters to define various system configurations and data visualization. The sheer volume of data that is generated makes data analysis a very tedious task. We propose to apply business intelligence tools to scientific data for gaining insight into the results. For instance, predictive analytics may generate an early warning of possible congestion that could lead to poor system performance. This information can then be used to prescribe remedial actions to avoid performance degradation. This concept is similar to predicting traffic congestion several minutes before it is going to happen and then taking corrective action to avoid the imminent congestion. Business intelligence concepts have never been applied to data of this nature. The proposed research has potential applications in areas such as automated manufacturing, multimedia databases, real-time process control, banking, airline reservations, and stock exchanges. The analytics and data visualization modules can also be used in other applications which generate large volumes of data.

许多现实世界的应用程序（例如航空公司预订和股票市场）在与大型、地理分布的数据库交互时需要实时响应。这种系统中的交易有最后期限，但如果错过最后期限，不会发生灾难性事件；但是，逾期完成必须缴纳罚款（与 4 月 30 日截止日期后缴税的概念相同）。主要目标是满足最后期限，但对于错过最后期限的交易，必须最大限度地减少延迟。例如，典型的要求可能是 95% 的事务在 2 秒内完成。在构建大型/昂贵的网络和分布式系统之前，必须设计和测试高效的协议，以证明其在各种条件下的最佳性能。为了经济高效地做到这一点，我们提出了一种在模拟环境中进行开发和测试的模块化方法。除此之外，模拟器应该能够模拟低、中和高负载条件。交互式图形用户界面将允许输入参数的组合来定义各种系统配置和数据可视化。 生成的数据量巨大，使得数据分析成为一项非常繁琐的任务。我们建议将商业智能工具应用于科学数据，以深入了解结果。例如，预测分析可以对可能导致系统性能不佳的拥塞产生早期预警。然后可以使用该信息来制定补救措施，以避免性能下降。这个概念类似于在交通拥堵即将发生前几分钟预测交通拥堵，然后采取纠正措施以避免即将发生的拥堵。商业智能概念从未应用于这种性质的数据。 拟议的研究在自动化制造、多媒体数据库、实时过程控制、银行、航空公司预订和证券交易所等领域具有潜在的应用。分析和数据可视化模块还可用于生成大量数据的其他应用程序。