Volltext-Downloads (blau) und Frontdoor-Views (grau)

Implementing optimistic concurrency control for persistence middleware using row version verification

  • Modern web-based applications are often built as multi-tier architecture using persistence middleware. Middleware technology providers recommend the use of Optimistic Concurrency Control (OCC) mechanism to avoid the risk of blocked resources. However, most vendors of relational database management systems implement only locking schemes for concurrency control. As consequence a kind of OCC has to be implemented at client or middleware side. A simple Row Version Verification (RVV) mechanism has been proposed to implement an OCC at client side. For performance reasons the middleware uses buffers (cache) of its own to avoid network traffic and possible disk I/O. This caching however complicates the use of RVV because the data in the middleware cache may be stale (outdated). We investigate various data access technologies, including the new Java Persistence API (JPA) and Microsoft’s LINQ technologies for their ability to use the RVV programming discipline. The use of persistence middleware that tries to relieve the programmer from the low level transaction programming turns out to even complicate the situation in some cases.Programmed examples show how to use SQL data access patterns to solve the problem.

Download full text files

  • 2159.pdf

Export metadata

Additional Services

Share in Twitter Search Google Scholar


Author of HS ReutlingenLaux, Friedrich
Erschienen in:2010 Second International Conference on Advances in Databases, Knowledge, and Data Applications : (DBKDA 2010), Menuires, France, 11 - 16 April 2010
Place of publication:Piscataway, NJ
Editor:Friedrich LauxORCiD, Lena Strömbäck
Document Type:Conference Proceeding
Year of Publication:2010
Tag:caching; data access pattern; persistence middleware; row version verification
Page Number:6
First Page:45
Last Page:50
DDC classes:004 Informatik
Open Access?:Nein
Licence (German):License Logo  Lizenzbedingungen IEEE