###
DOI:
Journal of Software:1995.6(10):582-592

一个基于SQL的并发控制机制
曲云尧,施伯乐
(复旦大学计算机科学系,上海,200433)
A CONCURRENCY CONTROL MECHANISM BASED ON SQL
Qu Yunyao,Shi Baile
()
Abstract
Chart / table
Reference
Similar Articles
Article :Browse 3150   Download 3056
Received:April 23, 1994    Revised:November 22, 1994
> 中文摘要: 传统的读写事务模型(由read(x)和write(x)序列组成)不能使调度机制充分利用应用程序的语义信息对事务进行灵活调度,从而不能有效提高系统的并发度.本文根据SQL语言的操作语义,给出了基于SQL的事务模型.利用这种事务模型并结合2PL方法,设计了并发控制机制:Condition—locking.这个机制可以:(1)避免数据库中的幽灵(phantom)问题,(2)利用应用程序的语义信息和完整性约束提高系统的并发度,(3)减少发生死锁的机会.因此,这是一个实用的并发控制机制.
Abstract:By the standard transaction model(composed of read and write operations),the scheduler can not exploit the semantics of application programs,thus not enhancing concurrency effectively.In this paper,a new transaction model based on SQL language are presented, which can exploit the semantics of high-level operations.Depending on the the transaction model and Two-Phase Locking method,the authors design a concurrency control mechanism-Condition-Locking, which can,(1)prevent phantoms from database,(2)exploit semantic information of application programs and the knowledge of the integrity constraints of the database system to enhance. cononrrency,(3)reduce the chances of producing deadlock.Hence,it is a practical concurrency control mechanism.
文章编号:     中图分类号:    文献标志码:
基金项目:本项目受到国家863高技术项目资助. 本项目受到国家863高技术项目资助.
Foundation items:
Reference text:

曲云尧,施伯乐.一个基于SQL的并发控制机制.软件学报,1995,6(10):582-592

Qu Yunyao,Shi Baile.A CONCURRENCY CONTROL MECHANISM BASED ON SQL.Journal of Software,1995,6(10):582-592