TY - CHAP U1 - Konferenzveröffentlichung A1 - Laiho, Martti A1 - Laux, Fritz ED - Laux, Fritz ED - Strömbäck, Lena T1 - Implementing optimistic concurrency control for persistence middleware using row version verification T2 - 2010 Second International Conference on Advances in Databases, Knowledge, and Data Applications : (DBKDA 2010), Menuires, France, 11 - 16 April 2010 N2 - 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. KW - persistence middleware KW - caching KW - data access pattern KW - row version verification Y1 - 2010 U6 - https://doi.org/10.1109/DBKDA.2010.25 DO - https://doi.org/10.1109/DBKDA.2010.25 SP - 45 EP - 50 S1 - 6 PB - IEEE CY - Piscataway, NJ ER -