DE602005002062D1 - Optimierung der Sperrgranularität mittels Bereichssperren - Google Patents

Optimierung der Sperrgranularität mittels Bereichssperren

Info

Publication number
DE602005002062D1
DE602005002062D1 DE602005002062T DE602005002062T DE602005002062D1 DE 602005002062 D1 DE602005002062 D1 DE 602005002062D1 DE 602005002062 T DE602005002062 T DE 602005002062T DE 602005002062 T DE602005002062 T DE 602005002062T DE 602005002062 D1 DE602005002062 D1 DE 602005002062D1
Authority
DE
Germany
Prior art keywords
optimization
range locks
locking granularity
locking
granularity
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.)
Active
Application number
DE602005002062T
Other languages
English (en)
Other versions
DE602005002062T2 (de
Inventor
Roman Rapp
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.)
SAP SE
Original Assignee
SAP SE
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 SAP SE filed Critical SAP SE
Publication of DE602005002062D1 publication Critical patent/DE602005002062D1/de
Application granted granted Critical
Publication of DE602005002062T2 publication Critical patent/DE602005002062T2/de
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

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
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99931—Database or file accessing
    • Y10S707/99938—Concurrency, e.g. lock management in shared database
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99931—Database or file accessing
    • Y10S707/99939—Privileged access

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)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Paper (AREA)
  • Measuring Pulse, Heart Rate, Blood Pressure Or Blood Flow (AREA)
  • Filters And Equalizers (AREA)
  • Lock And Its Accessories (AREA)
DE602005002062T 2004-02-19 2005-01-31 Optimierung der Sperrgranularität mittels Bereichssperren Active DE602005002062T2 (de)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
EP04003697 2004-02-19
EP04003697A EP1566744A1 (de) 2004-02-19 2004-02-19 Optimierung der Sperrgranularität mittels Bereichssperren

Publications (2)

Publication Number Publication Date
DE602005002062D1 true DE602005002062D1 (de) 2007-10-04
DE602005002062T2 DE602005002062T2 (de) 2008-05-21

Family

ID=34707317

Family Applications (1)

Application Number Title Priority Date Filing Date
DE602005002062T Active DE602005002062T2 (de) 2004-02-19 2005-01-31 Optimierung der Sperrgranularität mittels Bereichssperren

Country Status (6)

Country Link
US (2) US7529749B2 (de)
EP (2) EP1566744A1 (de)
JP (1) JP4235620B2 (de)
AT (1) ATE371218T1 (de)
AU (1) AU2005200742B2 (de)
DE (1) DE602005002062T2 (de)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111782669A (zh) * 2020-06-28 2020-10-16 百度在线网络技术（北京）有限公司 一种分布式锁的实现方法、装置及电子设备

Families Citing this family (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP1566744A1 (de) 2004-02-19 2005-08-24 Sap Ag Optimierung der Sperrgranularität mittels Bereichssperren
EP1684194A1 (de) 2005-01-25 2006-07-26 Sap Ag Ein zentraler Sperrdienst für Datenbankanwendungen
EP1684193A1 (de) * 2005-01-25 2006-07-26 Sap Ag Zentraler Sperrdienst für Datenbankanwendungen
US20090006402A1 (en) * 2007-06-28 2009-01-01 Holger Bohle Methods and systems for the dynamic selection of a locking strategy
US8224799B2 (en) * 2009-04-22 2012-07-17 Microsoft Corporation Providing lock-based access to nodes in a concurrent linked list
US9529872B2 (en) * 2010-12-22 2016-12-27 Sap Se Asynchronous data processing
US9836549B2 (en) 2013-05-12 2017-12-05 Sap Se Collaboration adapter to exploit single-user web applications for collaborative work
US9466159B1 (en) 2015-04-10 2016-10-11 J. J. Keller & Associates, Inc. Methods and systems for automatically identifying a data source for an on-board recorder
US9875270B1 (en) * 2015-09-18 2018-01-23 Amazon Technologies, Inc. Locking item ranges for creating a secondary index from an online table
US10489386B2 (en) 2016-12-14 2019-11-26 Google Llc Managing transactions requesting non-existing index keys in database systems

Family Cites Families (39)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4716528A (en) * 1986-02-03 1987-12-29 International Business Machines Corporation Method for managing lock escalation in a multiprocessing, multiprogramming environment
JPS63191226A (ja) * 1987-02-03 1988-08-08 Ricoh Co Ltd Ｂ↑＋ｔｒｅｅ上における同時実行制御方式
JPH0827755B2 (ja) * 1991-02-15 1996-03-21 インターナショナル・ビジネス・マシーンズ・コーポレイション データの単位を高速度でアクセスする方法
JP2533266B2 (ja) * 1991-06-14 1996-09-11 インターナショナル・ビジネス・マシーンズ・コーポレイション 共用デ―タシステムにおけるデ―タ資源のロッキング方法及びシステム間のデ―タロック管理方法
US5414839A (en) * 1992-06-19 1995-05-09 Digital Equipment Corporation Hybrid lock escalation and de-escalation protocols
US5485607A (en) * 1993-02-05 1996-01-16 Digital Equipment Corporation Concurrency-control method and apparatus in a database management system utilizing key-valued locking
US5440732A (en) * 1993-02-05 1995-08-08 Digital Equipment Corp., Pat. Law Gr. Key-range locking with index trees
US5721943A (en) * 1993-10-14 1998-02-24 International Business Machines Corporation Negotiable locks for concurrent access of control data by multiple programs
US7480653B2 (en) * 1996-10-22 2009-01-20 International Business Machines Corporation System and method for selective partition locking
US5893157A (en) * 1997-05-28 1999-04-06 International Business Machines Corporation Blocking symbol control in a computer system to serialize accessing a data resource by simultaneous processor requests
US6216207B1 (en) * 1997-12-31 2001-04-10 Alcatel Usa Sourcing, L.P. Performance monitoring storage module for storing performance management data
US5983225A (en) * 1998-01-26 1999-11-09 Telenor As Parameterized lock management system and method for conditional conflict serializability of transactions
US6047283A (en) * 1998-02-26 2000-04-04 Sap Aktiengesellschaft Fast string searching and indexing using a search tree having a plurality of linked nodes
US6144983A (en) * 1998-06-09 2000-11-07 Oracle Corporation Method and apparatus for dynamic lock granularity escalation and de-escalation in a computer system
US6631366B1 (en) * 1998-10-20 2003-10-07 Sybase, Inc. Database system providing methodology for optimizing latching/copying costs in index scans on data-only locked tables
US6418438B1 (en) * 1998-12-16 2002-07-09 Microsoft Corporation Dynamic scalable lock mechanism
US6405274B1 (en) * 1998-12-30 2002-06-11 Oracle Corporation Anticipatory lock mode conversions in a lock management system
CA2279051C (en) * 1999-07-29 2004-12-28 Ibm Canada Limited-Ibm Canada Limitee Method and system for improving concurrency through early release of unnecessary locks
US7487152B1 (en) * 2000-05-31 2009-02-03 International Business Machines Corporation Method for efficiently locking resources of a global data repository
US6826570B1 (en) * 2000-07-18 2004-11-30 International Business Machines Corporation Dynamically switching between different types of concurrency control techniques to provide an adaptive access strategy for a parallel file system
KR100379949B1 (ko) * 2000-11-30 2003-04-16 한국과학기술원 상승불가능 로크 개념에 기반한 적응형 로크 상승방법
US7788335B2 (en) * 2001-01-11 2010-08-31 F5 Networks, Inc. Aggregated opportunistic lock and aggregated implicit lock management for locking aggregated files in a switched file system
US7328263B1 (en) * 2001-01-30 2008-02-05 Cisco Technology, Inc. Controlling access of concurrent users of computer resources in a distributed system using an improved semaphore counting approach
US6772155B1 (en) * 2001-04-04 2004-08-03 Ncr Corporation Looking data in a database system
US6944615B2 (en) * 2001-06-28 2005-09-13 International Business Machines Corporation System and method for avoiding deadlock situations due to pseudo-deleted entries
US7028300B2 (en) * 2001-11-13 2006-04-11 Microsoft Corporation Method and system for managing resources in a distributed environment that has an associated object
US6748470B2 (en) * 2001-11-13 2004-06-08 Microsoft Corporation Method and system for locking multiple resources in a distributed environment
AU2003273824A1 (en) 2002-09-09 2004-04-30 Sap Aktiengesellschaft Methods and systems for data moving using locks
US7225302B2 (en) * 2002-11-27 2007-05-29 Sap Ag Method and software application for avoiding data loss
US7254578B2 (en) * 2002-12-10 2007-08-07 International Business Machines Corporation Concurrency classes for shared file systems
US7730046B2 (en) * 2002-12-23 2010-06-01 Sap Ag Nomination locking system and method
US8577908B2 (en) * 2003-03-20 2013-11-05 International Business Machines Corporation Automatic lock management in an abstract database
EP1566744A1 (de) 2004-02-19 2005-08-24 Sap Ag Optimierung der Sperrgranularität mittels Bereichssperren
EP1684193A1 (de) * 2005-01-25 2006-07-26 Sap Ag Zentraler Sperrdienst für Datenbankanwendungen
EP1684194A1 (de) * 2005-01-25 2006-07-26 Sap Ag Ein zentraler Sperrdienst für Datenbankanwendungen
US7599908B2 (en) * 2005-11-18 2009-10-06 Sap Ag Logical locking for Java Data Objects
US7552121B2 (en) * 2006-06-22 2009-06-23 International Business Machines Corporation Autonomic lock escalation in an SQL environment
US7571165B2 (en) * 2006-09-28 2009-08-04 Sap Ag Method and system for providing locking behavior
US20080189240A1 (en) * 2007-02-05 2008-08-07 Mullins Ward R System, method and software for creating or maintaining local or distributed mapping and transparent persistence of complex data objects and their data relationships

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111782669A (zh) * 2020-06-28 2020-10-16 百度在线网络技术（北京）有限公司 一种分布式锁的实现方法、装置及电子设备
CN111782669B (zh) * 2020-06-28 2023-12-12 百度在线网络技术（北京）有限公司 一种分布式锁的实现方法、装置及电子设备

Also Published As

Publication number Publication date
AU2005200742B2 (en) 2006-12-21
US7529749B2 (en) 2009-05-05
JP4235620B2 (ja) 2009-03-11
EP1566744A1 (de) 2005-08-24
EP1566751A1 (de) 2005-08-24
US20050187933A1 (en) 2005-08-25
US20090210420A1 (en) 2009-08-20
AU2005200742A1 (en) 2005-09-08
ATE371218T1 (de) 2007-09-15
EP1566751B1 (de) 2007-08-22
US8078591B2 (en) 2011-12-13
JP2005235227A (ja) 2005-09-02
DE602005002062T2 (de) 2008-05-21

Similar Documents

Publication Publication Date Title
DE602005002062D1 (de) Optimierung der Sperrgranularität mittels Bereichssperren
DE502005002485D1 (de) Brille, insbesondere Arbeitsschutzbrille
GT200600478A (es) Compuestos utiles en terapia
CO6140059A2 (es) Derivados de imidazol-pirimidina para el tratamiento de enfermedades relacionadas con la glicogeno sintasa quinasa (gsk3)
EA200800840A1 (ru) Способ получения амидов
ATE491006T1 (de) Tintenzusammensetzung
CO6220952A2 (es) Nuevos derivados de 3-([1,2,4]triazolo[4,3-a]piridin-7-il)benzamida
ATE491097T1 (de) Karabinerhaken mit doppelverriegelung
DK1940789T3 (da) Fremgangsmåder og forbindelser til fremstilling af CC-1065-analoger
TW200705719A (en) Thin-film semiconductor-body
CY1105994T1 (el) Aναδιαταγμενες πεντανολες, μεθοδος για την παραγωγη αυτων και η χρηση αυτων ως αντιφλεγμονωδων
BR0212341A (pt) Processo para a preparação de hexaidro-furo[2,3-b]furan-3-ol
DK1858921T3 (da) Fotoproteiner med forbedret bioluminescens og anvendelse af disse som intracellulære calciumindikatorer
NO20071927L (no) Peptidsyklisering.
ATE539054T1 (de) Verfahren zur herstellung von dihydropyrrolderivaten als zwischenprodukte
DE60139706D1 (de) Brille mit einer Brückenanordnung zur Befestigung von einem zusätzlichen Rahmen
TW200602441A (en) Immersion liquid for liquid immersion lithography process, and resist-pattern forming method using immersion liquid
GB201320591D0 (en) Key and lock cylinder combination
BRPI0607720A2 (pt) processo aperfeiçoado para a preparação de diidrobenzofuranos substituìdos por (propenil dissubstituìdos) fenilalquila
ATE536396T1 (de) Tintenset und verfahren zur bilderzeugung
EP2239254A4 (de) Benzylpiperizinverbindung
CY1108819T1 (el) Μεθοδος για την παρασκευη παραγωγων θειονοφαινυλογλυκοσιδιου
BRPI0516932A (pt) processo para a preparação de compostos de purina
ATE548369T1 (de) Pyrrolopyridazinonverbindung als pde4 inhibitor
SE0402263D0 (sv) Ett låssystem samt ett förfarande vid ett låssystem

Legal Events

Date Code Title Description
8364 No opposition during term of opposition