Overview of Locking Mechanisms (310)
In general, multiuser databases use some form of data locking to solve the problems
associated with data concurrency, consistency, and integrity. Locks are mechanisms
that prevent destructive interaction between transactions accessing the same resource.
Resources include two general types of objects:
■ User objects, such as tables and rows (structures and data)
■ System objects not visible to users, such as shared data structures in the memory
and data dictionary rows
鎖機制
1. 鎖是一種防止多個事務訪問同一資源時產生破壞性的相互影響的機制
2. 這樣的資源可以分為兩類:
* 使用者物件,例如表及資料行
* 使用者不可見的系統物件,例如記憶體中的共享資料結構和資料字典中的資訊
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-988273/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How Oracle Locking WorksOracle
- Modes of Locking (334)
- KBP310-ASEMI新能源整流橋KBP310
- Flutter OverviewFlutterView
- 淺談mysql innodb lockingMySql
- Explicit (Manual) Data Locking (364)
- REFERENTIAL INTEGRITY AND LOCKING [ID 33453.1]
- dart class overviewDartView
- Stormstarter-OverviewORMView
- Overview of PartitioningView
- Overview of Database CheckpointsViewDatabase
- Overview of Unix ResourcesView
- oracle function overviewOracleFunctionView
- Item Import OverviewImportView
- Overview of Extents(11)View
- Overview of Partitioned IndexesViewIndex
- Overview of Tablespaces (38)View
- Overview of Views (174)View
- Overview of Datafiles (62)View
- Overview of Segments (22)View
- 高通USB overviewView
- MySQL 5.5 -- Metadata Locking Within TransactionsMySql
- 力扣(LeetCode)310力扣LeetCode
- Overview of Availability in a CDBViewAI
- 2.4 Overview of Services in a CDBView
- 7-Overview-namesView
- 8-Overview-NamespacesViewnamespace
- 10-Overview-AnnotationsView
- [英] TensorFlow OverviewView
- Deadlock Overview and DiscussionView
- Overview of Data Blocks(二)ViewBloC
- Overview of Clusters (238)View
- Overview of Tables (154)View
- Overview of Dimensions (191)View
- Overview of Synonyms (193)View
- Overview of Indexes (194)ViewIndex
- 如何查詢 library locking 問題
- Mysql next-locking 間隙鎖MySql