RU2585973C2 - Способ и устройство управления операцией блокировки системы баз данных - Google Patents
Способ и устройство управления операцией блокировки системы баз данных Download PDFInfo
- Publication number
- RU2585973C2 RU2585973C2 RU2014133161/08A RU2014133161A RU2585973C2 RU 2585973 C2 RU2585973 C2 RU 2585973C2 RU 2014133161/08 A RU2014133161/08 A RU 2014133161/08A RU 2014133161 A RU2014133161 A RU 2014133161A RU 2585973 C2 RU2585973 C2 RU 2585973C2
- Authority
- RU
- Russia
- Prior art keywords
- lock
- state
- target
- value
- processing node
- Prior art date
Links
- 238000000034 method Methods 0.000 title claims abstract description 128
- 230000000903 blocking effect Effects 0.000 claims abstract description 324
- 230000008569 process Effects 0.000 abstract description 13
- 230000000694 effects Effects 0.000 abstract 1
- 239000000126 substance Substances 0.000 abstract 1
- 238000006243 chemical reaction Methods 0.000 description 78
- 230000009466 transformation Effects 0.000 description 21
- 230000006870 function Effects 0.000 description 17
- 238000010586 diagram Methods 0.000 description 16
- 238000004364 calculation method Methods 0.000 description 6
- 238000004422 calculation algorithm Methods 0.000 description 4
- 230000008859 change Effects 0.000 description 4
- 238000013507 mapping Methods 0.000 description 4
- 230000005540 biological transmission Effects 0.000 description 2
- 238000005266 casting Methods 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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; CALCULATING OR 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)
Applications Claiming Priority (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201310222370.5 | 2013-06-06 | ||
CN2013102223705A CN103336789A (zh) | 2013-06-06 | 2013-06-06 | 一种数据库系统的锁操作方法及设备 |
PCT/CN2014/071030 WO2014194678A1 (zh) | 2013-06-06 | 2014-01-21 | 一种数据库系统的锁操作方法及设备 |
Publications (2)
Publication Number | Publication Date |
---|---|
RU2014133161A RU2014133161A (ru) | 2016-03-10 |
RU2585973C2 true RU2585973C2 (ru) | 2016-06-10 |
Family
ID=49244954
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
RU2014133161/08A RU2585973C2 (ru) | 2013-06-06 | 2014-01-21 | Способ и устройство управления операцией блокировки системы баз данных |
Country Status (6)
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
RU2749339C1 (ru) * | 2018-01-05 | 2021-06-08 | Бейджин Кингсофт Клауд Нетворк Текнолоджи Ко., Лтд. | Способ управления оборудованием, кластерная система, электронное устройство и читаемый носитель данных |
Families Citing this family (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103336789A (zh) * | 2013-06-06 | 2013-10-02 | 华为技术有限公司 | 一种数据库系统的锁操作方法及设备 |
CN104252545B (zh) * | 2014-10-11 | 2017-05-31 | 南京国电南自维美德自动化有限公司 | 一种实时内存数据库的对象类型属性类型锁的实现方法 |
US10614039B2 (en) * | 2017-04-04 | 2020-04-07 | International Business Machines Corporation | Testing of lock managers in computing environments |
CN109376165A (zh) * | 2018-11-14 | 2019-02-22 | 深圳市金证科技股份有限公司 | 内存数据库锁的实现方法和装置及计算机可读存储介质 |
CN109933606B (zh) * | 2019-03-19 | 2021-04-27 | 上海达梦数据库有限公司 | 一种数据库修改方法、装置、设备及存储介质 |
CN110162532B (zh) * | 2019-05-09 | 2021-06-04 | 中国银行股份有限公司 | 交易数据处理方法和设备 |
Citations (5)
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 |
US6850938B1 (en) * | 2001-02-08 | 2005-02-01 | Cisco Technology, Inc. | Method and apparatus providing optimistic locking of shared computer resources |
RU2380748C2 (ru) * | 2003-06-25 | 2010-01-27 | Майкрософт Корпорейшн | Регистрация и извлечение информации об изменении таблицы базы данных, которая может использоваться для признания недействительными элементов кэша |
RU2413984C2 (ru) * | 2005-04-21 | 2011-03-10 | Майкрософт Корпорейшн | Системы и способы манипулирования данными в системе хранения данных |
CN102355473A (zh) * | 2011-06-28 | 2012-02-15 | 用友软件股份有限公司 | 分布式计算环境下的锁定控制系统和方法 |
Family Cites Families (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
KR100314879B1 (ko) | 1998-05-15 | 2002-02-28 | 이계철 | 주기억장치데이터베이스관리시스템을위한락관리방법 |
US6182186B1 (en) * | 1998-06-30 | 2001-01-30 | Sun Microsystems, Inc. | Method and apparatus that utilizes lock states 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 |
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 |
US8271437B2 (en) * | 2008-07-28 | 2012-09-18 | International Business Machines Corporation | Managing locks across distributed computing nodes |
CN101364230B (zh) * | 2008-09-24 | 2011-04-20 | 金蝶软件(中国)有限公司 | 一种并发访问控制方法及装置 |
CN102129391B (zh) * | 2011-03-14 | 2013-08-28 | 华中科技大学 | 一种数据库中自旋锁的实现方法 |
CN103336789A (zh) * | 2013-06-06 | 2013-10-02 | 华为技术有限公司 | 一种数据库系统的锁操作方法及设备 |
-
2013
- 2013-06-06 CN CN2013102223705A patent/CN103336789A/zh active Pending
-
2014
- 2014-01-21 WO PCT/CN2014/071030 patent/WO2014194678A1/zh active Application Filing
- 2014-01-21 EP EP14730727.6A patent/EP2876566A4/en not_active Ceased
- 2014-01-21 IN IN1340KON2014 patent/IN2014KN01340A/en unknown
- 2014-01-21 RU RU2014133161/08A patent/RU2585973C2/ru not_active IP Right Cessation
- 2014-07-03 US US14/323,546 patent/US9449041B2/en not_active Expired - Fee Related
Patent Citations (5)
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 |
US6850938B1 (en) * | 2001-02-08 | 2005-02-01 | Cisco Technology, Inc. | Method and apparatus providing optimistic locking of shared computer resources |
RU2380748C2 (ru) * | 2003-06-25 | 2010-01-27 | Майкрософт Корпорейшн | Регистрация и извлечение информации об изменении таблицы базы данных, которая может использоваться для признания недействительными элементов кэша |
RU2413984C2 (ru) * | 2005-04-21 | 2011-03-10 | Майкрософт Корпорейшн | Системы и способы манипулирования данными в системе хранения данных |
CN102355473A (zh) * | 2011-06-28 | 2012-02-15 | 用友软件股份有限公司 | 分布式计算环境下的锁定控制系统和方法 |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
RU2749339C1 (ru) * | 2018-01-05 | 2021-06-08 | Бейджин Кингсофт Клауд Нетворк Текнолоджи Ко., Лтд. | Способ управления оборудованием, кластерная система, электронное устройство и читаемый носитель данных |
US11416313B2 (en) | 2018-01-05 | 2022-08-16 | Beijing Kingsoft Cloud Network Technology Co., Ltd. | Equipment control method, cluster system , electronic device and readable storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN103336789A (zh) | 2013-10-02 |
WO2014194678A1 (zh) | 2014-12-11 |
US9449041B2 (en) | 2016-09-20 |
US20140372396A1 (en) | 2014-12-18 |
RU2014133161A (ru) | 2016-03-10 |
EP2876566A1 (en) | 2015-05-27 |
IN2014KN01340A (receveur-de-douche-rioja-anthracite-700-x-900-mm) | 2015-10-16 |
EP2876566A4 (en) | 2015-08-26 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
RU2585973C2 (ru) | Способ и устройство управления операцией блокировки системы баз данных | |
US9811684B1 (en) | Token-based storage service | |
CN107977376B (zh) | 分布式数据库系统及事务处理方法 | |
EP3631651B1 (en) | Method for efficient primary key based queries using atomic rdma reads on cache friendly in-memory hash index | |
US8949535B1 (en) | Cache updating | |
CN111061680B (zh) | 一种数据检索的方法和装置 | |
US9952940B2 (en) | Method of operating a shared nothing cluster system | |
WO2016118429A1 (en) | System for efficient processing of transaction requests related to an account in a database | |
US8209440B2 (en) | Device-configuration-information optimum arrangement method and device-configuration-information optimum arrangement system | |
CN113570460B (zh) | 在区块链中并发执行交易的方法和装置 | |
WO2016169237A1 (zh) | 数据处理方法及装置 | |
CN103973810A (zh) | 基于互联网协议ip盘的数据处理方法和装置 | |
JP2024177162A (ja) | 複数のチェーンを使用した共有キャッシュ内のオブジェクトの管理 | |
US8612464B2 (en) | Portable hash-based key location mechanism | |
WO2016101759A1 (zh) | 一种数据路由方法、数据管理装置和分布式存储系统 | |
US9467291B2 (en) | Information processing system, information processing method, and non-transitory computer readable medium for processing requests using an authority object | |
CN107203890B (zh) | 凭证数据发放方法、装置及系统 | |
JP2017027326A (ja) | ストレージシステムおよびストレージシステム用プログラム | |
US10185735B2 (en) | Distributed database system and a non-transitory computer readable medium | |
CN112463757B (zh) | 一种分布式系统的资源访问方法及相关装置 | |
US10452492B2 (en) | Method, apparatus, and computer program stored in computer readable medium for recovering block in database system | |
CN114048171A (zh) | 图像数据的存储方法、装置、介质和设备 | |
CN114443937B (zh) | 订单查询方法、装置、系统以及计算机可读存储介质 | |
JP2011232926A (ja) | 分散データベースシステム、デッドロック通知方法およびデッドロック通知プログラム | |
CN109491967A (zh) | 一种基于uuid的分布式文件管理方法和系统 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
MM4A | The patent is invalid due to non-payment of fees |
Effective date: 20190122 |