VERSION-BASED TABLE LOCKING

Techniques are disclosed relating to concurrently processing transactions. A computer system may maintain a database table having a plurality of versions. Each of the versions may identify a corresponding portion of the database table that transactions associated with that version are permitted to a...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: SHAH PUNIT B, COHEN JEFFREY IRA, RIELAU SERGE PHILIPPE
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:Techniques are disclosed relating to concurrently processing transactions. A computer system may maintain a database table having a plurality of versions. Each of the versions may identify a corresponding portion of the database table that transactions associated with that version are permitted to access. The computer system may receive a first request to perform a first transaction to modify a definition of the database table. The computer system may receive a second request to perform a second transaction to modify data stored in the database table. In response to determining that the first and second transactions are associated with different versions of the plurality of versions, the computer system may concurrently process the first and second transactions. 公开了并行处理事务相关的技术。计算机系统可以保存具有若干版本的数据库表。每一个版本都可以识别数据库表的对应部分,允许与所述版本相关联的事务访问该对应部分。该计算机系统可以接收第一请求以执行第一事务来修改数据库表的定义。该计算机系统可以接收第二请求以执行第二事务来修改数据库表的定义。响应于确定第一事务和第二事务与若干版本中的不同版本相关联,该计算机系统可以并行处理第一事务和第二事务。