期刊文献+

内存数据库事务的混合并发控制研究 被引量:2

Hybrid Concurrency Control Study of In-memory Database Transaction
下载PDF
导出
摘要 随着数据的增长和主流服务器的内存增长,内存数据库作为一种新的数据处理方式受到越来越多的关注.通过研究现有的内存数据库以及其中常见的两种并发控制机制,乐观并发控制(OCC)与悲观并发控制(PCC),分析各自的特点与适应场景.同时提出一种基于已有并发控制的混合并发控制机制(HCC),其中主要包括具体解决两种原有并发控制的兼容问题,并且设计相应的场景信息获取方法以及并发控制的切换方式.最后利用实验比较在静态场景和动态场景下混合并发控制以及两种原有并发控制的性能,具体而言混合并发控制能够在静态场景下接近两种原有并发控制的最优者,而在动态场景下相对于两种原有的并发控制有20%-30%的性能提升. Due to the data explosion and the memory growth on main-stream servers,the in-memory database is getting more and more attention as a newdata processing method. Based on the study of two common concurrency control mechanisms for in-memory databases,optimistic concurrency control( OCC) and pessimistic concurrency control( PCC),this work finds out their features and suitable scenarios. Meanwhile,this work proposes a hybrid concurrency control( HCC) on the previous concurrency control mechanisms,which mainly includes the solution to fix the compatibility problem,the mechanism of scenario information collection and the switchover mechanism. Finally this work uses experiments to compare the specific performance of HCC and two previous concurrency control mechanisms in both static and dynamic scenarios,showing that HCC makes suitable choices of the concurrency control mechanisms in static scenarios and achieves 20%-30% performance improvement in dynamic scenarios.
作者 易涵 陈海波
出处 《小型微型计算机系统》 CSCD 北大核心 2016年第3期459-463,共5页 Journal of Chinese Computer Systems
关键词 内存数据库 事务并发控制 混合并发控制 并发控制切换 in-memory database transaction concurrency control hybrid concurrency control concurrency control switchover
  • 相关文献

参考文献4

二级参考文献76

  • 1肖迎元,刘云生,廖国琼.一种基于移动环境的混合乐观实时事务处理策略[J].小型微型计算机系统,2005,26(6):1023-1028. 被引量:1
  • 2[1]Jeffrey O Kephart,David M Chess.The vision of autonomic computing.IEEE Computer,2003,36(1):41-50
  • 3[2]Gerhard Weikum,Axel Moenkeberg,Christof Hasse,et al.Self-tuning database technology and information services:From wishful thinking to viable engineering.The 28th Int'l Conf on Very Large Data Bases,Hong Kong,China,2002
  • 4[3]An Oracle White Paper.The Self-Managing Database:Guided Application & SQL Tuning.http://www.oracle.com/technology/products/manageability/database/sq1.html,2003
  • 5[4]The Auto Admin Project.http://research.microsoft.com/dmx/autoadmin/,1997
  • 6[5]Xiaoyi Xu,Patrick Martin,Wendy Powley.Configuring buffer pools in DB2 UDB.The 2002 Conf of the Centre for Advanced Studies on Collaborative Research,Toronto,Ontario,Canada,2002
  • 7[6]An Oracle White Paper.The Self-Managing Database:Automatic SGA Memory Management.http://www.oracle.com/technology/products/manageability/database/sga.html,2003
  • 8[8]An Oracle White Paper.Oracle Database 10g:The Self-Managing Database.http://www.oracle.com/technology/products/manageability/database/sq1.html,2003
  • 9[9]Daniel C Zilio,Jun Rao,Sam Lightstone,et al.DB2 design advisor:Integrated automatic physical database design.The 30th Int'l Conf on Very Large Data Bases,Toronto,Canada,2004
  • 10[10]Sanjay Agrawal,Surajit Chaudhuri,Lubor Kollar,et al.Database tuning advisor for microsoft SQL server 2005.The 30th Int'l Conf on Very Large Data Bases,Toronto,Canada,2004

共引文献294

同被引文献17

引证文献2

二级引证文献6

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部