The search result changed since you submitted your search request. Documents might be displayed in a different sort order.
  • search hit 10 of 148
Back to Result List

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
    eng

Export metadata

Additional Services

Share in Twitter Search Google Scholar
Metadaten
Name:Laux, Friedrich
DOI:https://doi.org/10.1109/DBKDA.2010.25
Erschienen in:2010 Second International Conference on Advances in Databases, Knowledge, and Data Applications : (DBKDA 2010), Menuires, France, 11 - 16 April 2010
Publisher:IEEE
Place of publication:Piscataway, NJ
Editor:Friedrich Laux, Lena Strömbäck
Document Type:Conference Proceeding
Language:English
Year of Publication:2010
Tag:caching; data access pattern; persistence middleware; row version verification
Pagenumber:6
First Page:45
Last Page:50
Dewey Decimal Classification:004 Informatik
Open Access:Nein
Licence (German):License Logo  Lizenzbedingungen IEEE