CN103336789A - 一种数据库系统的锁操作方法及设备 - Google Patents

一种数据库系统的锁操作方法及设备 Download PDF

Info

Publication number
CN103336789A
CN103336789A CN2013102223705A CN201310222370A CN103336789A CN 103336789 A CN103336789 A CN 103336789A CN 2013102223705 A CN2013102223705 A CN 2013102223705A CN 201310222370 A CN201310222370 A CN 201310222370A CN 103336789 A CN103336789 A CN 103336789A
Authority
CN
China
Prior art keywords
lock
value
state
target
processing node
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN2013102223705A
Other languages
English (en)
Chinese (zh)
Inventor
聂愿愿
刘辉军
王传廷
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Huawei Technologies Co Ltd
Original Assignee
Huawei Technologies Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Huawei Technologies Co Ltd filed Critical Huawei Technologies Co Ltd
Priority to CN2013102223705A priority Critical patent/CN103336789A/zh
Publication of CN103336789A publication Critical patent/CN103336789A/zh
Priority to PCT/CN2014/071030 priority patent/WO2014194678A1/zh
Priority to EP14730727.6A priority patent/EP2876566A4/en
Priority to IN1340KON2014 priority patent/IN2014KN01340A/en
Priority to RU2014133161/08A priority patent/RU2585973C2/ru
Priority to US14/323,546 priority patent/US9449041B2/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23—Updating
    • G06F16/2308—Concurrency control
    • G06F16/2336—Pessimistic concurrency control approaches, e.g. locking or multiple versions without time stamps
    • G06F16/2343—Locking methods, e.g. distributed locking or locking implementation details
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23—Updating
    • G06F16/2365—Ensuring data consistency and integrity

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computer Security & Cryptography (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
CN2013102223705A 2013-06-06 2013-06-06 一种数据库系统的锁操作方法及设备 Pending CN103336789A (zh)

Priority Applications (6)

Application Number Priority Date Filing Date Title
CN2013102223705A CN103336789A (zh) 2013-06-06 2013-06-06 一种数据库系统的锁操作方法及设备
PCT/CN2014/071030 WO2014194678A1 (zh) 2013-06-06 2014-01-21 一种数据库系统的锁操作方法及设备
EP14730727.6A EP2876566A4 (en) 2013-06-06 2014-01-21 SPERROPERATION PROCEDURE OF A DATABASE SYSTEM AND DEVICE
IN1340KON2014 IN2014KN01340A (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html) 2013-06-06 2014-01-21
RU2014133161/08A RU2585973C2 (ru) 2013-06-06 2014-01-21 Способ и устройство управления операцией блокировки системы баз данных
US14/323,546 US9449041B2 (en) 2013-06-06 2014-07-03 Database system lock operation method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN2013102223705A CN103336789A (zh) 2013-06-06 2013-06-06 一种数据库系统的锁操作方法及设备

Publications (1)

Publication Number Publication Date
CN103336789A true CN103336789A (zh) 2013-10-02

Family

ID=49244954

Family Applications (1)

Application Number Title Priority Date Filing Date
CN2013102223705A Pending CN103336789A (zh) 2013-06-06 2013-06-06 一种数据库系统的锁操作方法及设备

Country Status (6)

Country Link
US (1) US9449041B2 (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html)
EP (1) EP2876566A4 (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html)
CN (1) CN103336789A (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html)
IN (1) IN2014KN01340A (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html)
RU (1) RU2585973C2 (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html)
WO (1) WO2014194678A1 (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2014194678A1 (zh) * 2013-06-06 2014-12-11 华为技术有限公司 一种数据库系统的锁操作方法及设备
CN104252545A (zh) * 2014-10-11 2014-12-31 南京国电南自美卓控制系统有限公司 一种实时内存数据库的对象类型属性类型锁的实现方法
CN109376165A (zh) * 2018-11-14 2019-02-22 深圳市金证科技股份有限公司 内存数据库锁的实现方法和装置及计算机可读存储介质
CN109933606A (zh) * 2019-03-19 2019-06-25 上海达梦数据库有限公司 一种数据库修改方法、装置、设备及存储介质
CN110162532A (zh) * 2019-05-09 2019-08-23 中国银行股份有限公司 交易数据处理方法和设备

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10614039B2 (en) * 2017-04-04 2020-04-07 International Business Machines Corporation Testing of lock managers in computing environments
CN110008031B (zh) 2018-01-05 2022-04-15 北京金山云网络技术有限公司 设备操作方法、集群系统、电子设备及可读取存储介质

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6343339B1 (en) * 1998-06-30 2002-01-29 Sun Microsystems, Inc. Method and apparatus that utilizes state locks to lock resources
US6658513B1 (en) * 2000-10-10 2003-12-02 International Business Machines Corporation Managing locks affected by planned or unplanned reconfiguration of locking facilities
CN101364230A (zh) * 2008-09-24 2009-02-11 金蝶软件（中国）有限公司 一种并发访问控制方法及装置
CN102129391A (zh) * 2011-03-14 2011-07-20 华中科技大学 一种数据库中自旋锁的实现方法
CN102355473A (zh) * 2011-06-28 2012-02-15 用友软件股份有限公司 分布式计算环境下的锁定控制系统和方法

Family Cites Families (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5596754A (en) * 1992-10-29 1997-01-21 Digital Equipment Corporation Method for performing private lock management
KR100314879B1 (ko) 1998-05-15 2002-02-28 이계철 주기억장치데이터베이스관리시스템을위한락관리방법
US6850938B1 (en) * 2001-02-08 2005-02-01 Cisco Technology, Inc. Method and apparatus providing optimistic locking of shared computer resources
US7624126B2 (en) 2003-06-25 2009-11-24 Microsoft Corporation Registering for and retrieving database table change information that can be used to invalidate cache entries
US7650360B2 (en) * 2004-04-16 2010-01-19 Microsoft Corporation System and methods for database lock with reference counting
US20050289143A1 (en) * 2004-06-23 2005-12-29 Exanet Ltd. Method for managing lock resources in a distributed storage system
US20060242104A1 (en) 2005-04-21 2006-10-26 Microsoft Corporation Systems and methods for manipulating data in a data storage system
US8271437B2 (en) * 2008-07-28 2012-09-18 International Business Machines Corporation Managing locks across distributed computing nodes
CN103336789A (zh) * 2013-06-06 2013-10-02 华为技术有限公司 一种数据库系统的锁操作方法及设备

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6343339B1 (en) * 1998-06-30 2002-01-29 Sun Microsystems, Inc. Method and apparatus that utilizes state locks to lock resources
US6658513B1 (en) * 2000-10-10 2003-12-02 International Business Machines Corporation Managing locks affected by planned or unplanned reconfiguration of locking facilities
CN101364230A (zh) * 2008-09-24 2009-02-11 金蝶软件（中国）有限公司 一种并发访问控制方法及装置
CN102129391A (zh) * 2011-03-14 2011-07-20 华中科技大学 一种数据库中自旋锁的实现方法
CN102355473A (zh) * 2011-06-28 2012-02-15 用友软件股份有限公司 分布式计算环境下的锁定控制系统和方法

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2014194678A1 (zh) * 2013-06-06 2014-12-11 华为技术有限公司 一种数据库系统的锁操作方法及设备
US9449041B2 (en) 2013-06-06 2016-09-20 Huawei Technologies Co., Ltd. Database system lock operation method and device
CN104252545A (zh) * 2014-10-11 2014-12-31 南京国电南自美卓控制系统有限公司 一种实时内存数据库的对象类型属性类型锁的实现方法
CN104252545B (zh) * 2014-10-11 2017-05-31 南京国电南自维美德自动化有限公司 一种实时内存数据库的对象类型属性类型锁的实现方法
CN109376165A (zh) * 2018-11-14 2019-02-22 深圳市金证科技股份有限公司 内存数据库锁的实现方法和装置及计算机可读存储介质
CN109933606A (zh) * 2019-03-19 2019-06-25 上海达梦数据库有限公司 一种数据库修改方法、装置、设备及存储介质
CN109933606B (zh) * 2019-03-19 2021-04-27 上海达梦数据库有限公司 一种数据库修改方法、装置、设备及存储介质
CN110162532A (zh) * 2019-05-09 2019-08-23 中国银行股份有限公司 交易数据处理方法和设备

Also Published As

Publication number Publication date
US9449041B2 (en) 2016-09-20
EP2876566A4 (en) 2015-08-26
EP2876566A1 (en) 2015-05-27
IN2014KN01340A (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html) 2015-10-16
RU2014133161A (ru) 2016-03-10
US20140372396A1 (en) 2014-12-18
RU2585973C2 (ru) 2016-06-10
WO2014194678A1 (zh) 2014-12-11

Similar Documents

Publication Publication Date Title
US11687555B2 (en) Conditional master election in distributed databases
US9218299B2 (en) Recovering data segment contents in a distributed shared memory
CN103336789A (zh) 一种数据库系统的锁操作方法及设备
US9800515B2 (en) Mechanism for controlling a process on a computing node based on the participation status of the computing node
US8935560B2 (en) System and method of file locking in a network file system federated namespace
JP4098233B2 (ja) マルチノードシステム内でのデータおよびロック転送中の呼出し時間およびメッセージトラフィックの減少
WO2017143824A1 (zh) 事务执行方法、装置及系统
CN101189581B (zh) 用于处理与锁定相关的不一致的方法
CN104461705A (zh) 一种业务访问的方法及存储控制器、集群存储系统
US20190050281A1 (en) Long-Running Storage Manageability Operation Management
US11281666B2 (en) Interception of database queries for delegation to an in memory data grid
JP2023065558A (ja) 操作応答方法、操作応答装置、電子機器及び記憶媒体
CN112799836B (zh) 一种分布式锁系统架构
CN115878550A (zh) 一种数据处理的方法、芯片、设备以及系统
CN114329636B (zh) 一种司法数据的访问控制方法、系统、设备及存储介质
JP2011232926A (ja) 分散データベースシステム、デッドロック通知方法およびデッドロック通知プログラム
CN119848059A (zh) 分布式系统的配置数据更新方法、装置、设备及存储介质
HK1137535A (en) Persistent locks/resources for concurrency control

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20131002