%0 Journal Article
%T A CONCURRENCY CONTROL MECHANISM BASED ON SQL<br>一个基于SQL的并发控制机制
%A Qu Yunyao
%A Shi Baile
%A <br>曲云尧
%A 施伯乐
%J 软件学报
%D 1995
%I 
%X 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.
%K Database
%K concurrency control
%K phantom
%K SQL language
%K two-phase locking<br>数据库，并发控制，幽灵问题，SQL语言，两段锁
%U http://www.alljournals.cn/get_abstract_url.aspx?pcid=5B3AB970F71A803DEACDC0559115BFCF0A068CD97DD29835&cid=8240383F08CE46C8B05036380D75B607&jid=7735F413D429542E610B3D6AC0D5EC59&aid=8036873F50D54ECBC11F9299CE4C4AB5&yid=BBCD5003575B2B5F&vid=B31275AF3241DB2D&iid=F3090AE9B60B7ED1&sid=90773C2285A2F0BB&eid=106103EB0EA31435&journal_id=1000-9825&journal_name=软件学报&referenced_num=0&reference_num=14