loading...
Testing Database Transaction Concurrency
Montreal, Quebec, Canada October 06-October 10
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ASE.2003.124030618th IEEE International Conference on ...
 This Article 
 
PDF
HTML
 
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Yuetang Deng, Polytechnic University, Brooklyn, NY
Phyllis Frankl, Polytechnic University, Brooklyn, NY
Zhongqiang Chen, Polytechnic University, Brooklyn, NY
Database application programs are often designed to be executed concurrently by many users. By grouping related database queries into transactions, DBMS systems can guarantee that each transaction satisfies the well-known ACID properties: Atomicity, Consistency, Isolation, and Durability. However, if a database application is decomposed into transactions in an incorrect manner, the application may fail when executed concurrently due to potential offline concurrency problems.
This paper presents a dataflow analysis technique for identifying schedules of transaction execution aimed at revealing concurrency faults of this nature, along with techniques for controlling the DBMS or the application so that execution of transaction sequences follows generated schedules. The techniques have been integrated into AGENDA, a tool set for testing relational database application programs. Preliminary empirical evaluation is presented.
Citation:
Yuetang Deng, Phyllis Frankl, Zhongqiang Chen, "Testing Database Transaction Concurrency," ase, pp.184, 18th IEEE International Conference on Automated Software Engineering (ASE'03), 2003
Usage of this product signifies your acceptance of the Terms of Use.