首页> 外国专利> CONCURRENCY CONTROL IN A DISTRIBUTED DATABASE SYSTEM USING SERIALIZATION GRAPHS

CONCURRENCY CONTROL IN A DISTRIBUTED DATABASE SYSTEM USING SERIALIZATION GRAPHS

机译:序列化图在分布式数据库系统中的并发控制

摘要

A mechanism controls concurrency among database transactions through the use of serial ordering relations. The ordering relations are computed dynamically in response to patterns of use. An embodiment of the present invention serializes a transaction that accesses a resource before a transaction that modifies the resource, even if the accessor starts after the modifier starts or commits after the modifier commits. A method of concurrency control for a database transaction in a distributed database system stores an intended use of a database system resource by the database transaction in a serialization graph. A serialization ordering is asserted between the database transaction and other database transactions based on the intended use of the database system resource by the database transaction. The serialization ordering is then communicated to a node in the distributed database system that needs to know the serialization ordering to perform concurrency control. Cycles in the serialization graph are detected based on the asserted serialization order and in order to break such cycles and ensure transaction serializability a database transaction is identified that is a member of a cycle in the serialization graph.
机译:一种机制通过使用串行顺序关系来控制数据库事务之间的并发。排序关系是根据使用模式动态计算的。本发明的实施例在修改资源的事务之前对访问资源的事务进行序列化,即使访问器在修改器启动之后启动或在修改器提交之后提交也是如此。一种用于分布式数据库系统中的数据库事务的并发控制的方法,通过数据库事务在序列化图中存储数据库系统资源的预期用途。根据数据库事务对数据库系统资源的预期用途,在数据库事务和其他数据库事务之间声明序列化顺序。然后,将序列化顺序传送到分布式数据库系统中的一个节点,该节点需要知道序列化顺序以执行并发控制。基于断言的序列化顺序来检测序列化图中的循环,并且为了打破此类循环并确保事务可序列化,将数据库事务标识为序列化图中的循环成员。

著录项

相似文献

  • 专利
  • 外文文献
  • 中文文献
获取专利

客服邮箱:kefu@zhangqiaokeyan.com

京公网安备:11010802029741号 ICP备案号:京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有
  • 客服微信

  • 服务号