loading
Papers

Research.Publish.Connect.

Paper

Paper Unlock

Author: Lars Frank

Affiliation: Copenhagen Business School, Denmark

ISBN: 972-8865-00-7

Keyword(s): ACID properties, database availability, short duration locks, multi-databases, client/server technology, ERP systems and E-commerce.

Related Ontology Subjects/Areas/Topics: Coupling and Integrating Heterogeneous Data Sources ; Data and Application Security and Privacy ; Database Security ; Databases and Information Systems Integration ; Enterprise Information Systems ; Enterprise Resource Planning ; Enterprise Software Technologies ; Enterprise-Wide Client-Server Architecture ; Information and Systems Security ; Legacy Systems ; Object-Oriented Database Systems ; Simulation and Modeling ; Simulation Tools and Platforms ; Software Engineering

Abstract: When many concurrent transactions like ERP and E-commerce orders want to update the same stock records, long duration locking may reduce the availability of the locked data. Therefore, transactions are often designed without analyzing the consequences of loosing the traditional ACID (Atomicity, Consistency, Isolation and Durability) properties. In this paper, we will analyze how low isolation levels, optimistic concurrency control, short duration locks, and countermeasures against isolation anomalies can be used to design transactions for databases with high performance and availability. Long duration locks are defined as locks that are held until a transaction has been committed, i.e. the data of a record is locked from the first read to the last update of any data used by the transaction. This will decrease the availability of locked data for concurrent transactions, and, therefore, optimistic concurrency control and low isolation levels are often used. However, in systems with rela tively many updates like ERP-systems and E-commerce systems, low isolation levels cannot solve the availability problem as all update locks must be exclusive. In such situations, we will recommend the use of short duration locks. Short duration locks are local locks that are released as soon as possible, i.e. data will for example not be locked across a dialog with the user. Normally, databases where only short duration locks are used do not have the traditional ACID properties as at least the isolation property is missing when locks are not hold across a dialog with the user. The problems caused by the missing ACID properties may be managed by using approximated ACID properties, i.e. from an application point of view the system should function as if all the traditional ACID properties had been implemented. (More)

PDF ImageFull Text

Download
CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 35.175.191.168

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
Frank L. and (2004). TRANSACTION DESIGN FOR DATABASES WITH HIGH PERFORMANCE AND AVAILABILITY.In Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-00-7, pages 222-226. DOI: 10.5220/0002598702220226

@conference{iceis04,
author={Lars Frank},
title={TRANSACTION DESIGN FOR DATABASES WITH HIGH PERFORMANCE AND AVAILABILITY},
booktitle={Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2004},
pages={222-226},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002598702220226},
isbn={972-8865-00-7},
}

TY - CONF

JO - Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - TRANSACTION DESIGN FOR DATABASES WITH HIGH PERFORMANCE AND AVAILABILITY
SN - 972-8865-00-7
AU - Frank, L.
PY - 2004
SP - 222
EP - 226
DO - 10.5220/0002598702220226

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.