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
state
value
lock
target
locked
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 RU2014133161/08A priority patent/RU2585973C2/ru
Priority to PCT/CN2014/071030 priority patent/WO2014194678A1/zh
Priority to IN1340KON2014 priority patent/IN2014KN01340A/en
Priority to EP14730727.6A priority patent/EP2876566A4/en
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 一种数据库系统的锁操作方法及设备
RU2014133161/08A RU2585973C2 (ru) 2013-06-06 2014-01-21 Способ и устройство управления операцией блокировки системы баз данных
PCT/CN2014/071030 WO2014194678A1 (zh) 2013-06-06 2014-01-21 一种数据库系统的锁操作方法及设备
IN1340KON2014 IN2014KN01340A (https=) 2013-06-06 2014-01-21
EP14730727.6A EP2876566A4 (en) 2013-06-06 2014-01-21 SPERROPERATION PROCEDURE OF A DATABASE SYSTEM AND DEVICE
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 (https=)
EP (1) EP2876566A4 (https=)
CN (1) CN103336789A (https=)
IN (1) IN2014KN01340A (https=)
RU (1) RU2585973C2 (https=)
WO (1) WO2014194678A1 (https=)

Cited By (6)

* 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 中国银行股份有限公司 交易数据处理方法和设备
CN116483778A (zh) * 2023-03-03 2023-07-25 阿里巴巴（中国）有限公司 目录树操作方法、文件系统、电子设备及存储介质

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 (10)

* 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 中国银行股份有限公司 交易数据处理方法和设备
CN116483778A (zh) * 2023-03-03 2023-07-25 阿里巴巴（中国）有限公司 目录树操作方法、文件系统、电子设备及存储介质
CN116483778B (zh) * 2023-03-03 2026-03-27 阿里巴巴（中国）有限公司 目录树操作方法、文件系统、电子设备及存储介质

Also Published As

Publication number Publication date
WO2014194678A1 (zh) 2014-12-11
RU2014133161A (ru) 2016-03-10
EP2876566A1 (en) 2015-05-27
RU2585973C2 (ru) 2016-06-10
EP2876566A4 (en) 2015-08-26
US9449041B2 (en) 2016-09-20
US20140372396A1 (en) 2014-12-18
IN2014KN01340A (https=) 2015-10-16

Similar Documents

Publication Publication Date Title
CN103336789A (zh) 一种数据库系统的锁操作方法及设备
CN105516230B (zh) 一种数据处理方法及装置
CN113570460B (zh) 在区块链中并发执行交易的方法和装置
US10838875B2 (en) System and method for managing memory for large keys and values
CN106789249B (zh) 热更新方法、客户端及服务器
CN103678556A (zh) 列式数据库处理的方法和处理设备
JP6079876B2 (ja) 分散処理システム
US20170308574A1 (en) Method and apparatus for reducing query processing time by dynamically changing algorithms and computer readable medium therefor
CN113269538B (zh) 并行审批节点的转交方法、装置、设备及存储介质
CN116974251A (zh) 酿酒工艺参数控制方法、装置、酿酒系统和电子设备
JP2016100405A (ja) レシピｉｄ管理サーバ、レシピｉｄ管理システム、および端末装置
US20170235781A1 (en) Method, server and computer program stored in computer readable medium for managing log data in database
JP6834715B2 (ja) 更新処理プログラム、装置、及び方法
US8688867B2 (en) System and methods for communicating between serial communications protocol enabled devices
JP2008243147A (ja) クライアント・サーバシステム、検索サーバ、検索方法及び検索プログラム
KR102214697B1 (ko) 데이터베이스 관리 시스템에서 데이터 저장을 위한 공간 관리를 제공하는 컴퓨터 프로그램
GB2506539B (en) Interception of database queries for delegation to an in memory data grid
CN109408278B (zh) 数据处理方法及装置
JP7709895B2 (ja) アダプタ装置、ファイル交換システム、ファイル交換方法、及び、プログラム
US20150172131A1 (en) Method and system for verifying quality of server
US20170308562A1 (en) System and Method for Multi-Master Synchronous Replication Optimization
US7290085B2 (en) Method and system for flexible and efficient protocol table implementation
CN102541743A (zh) 用于存储管理的方法、设备和系统
CN110413617B (zh) 一种根据数据量的大小动态调节哈希表组的方法
JPS61128649A (ja) ネツトワ−クシステムにおけるアドレス管理方式

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

Application publication date: 20131002

RJ01 Rejection of invention patent application after publication