Abstract
In central databases the consistency of data is normally implemented by using the ACID (Atomicity, Consistency, Isolation and Durability) properties of a DBMS (Data Base Management System). This is not possible if distributed and/or mobile databases are involved and the availability of data also has to be optimized. Therefore, we will in this paper use so called relaxed ACID properties across different locations. The objective of designing relaxed ACID properties across different database locations is that the users can trust the data they use even if the distributed database temporarily is inconsistent. It is also important that disconnected locations can operate in a meaningful way in socalled disconnected mode.
A database is DBMS consistent if its data complies with the consistency rules of the DBMS's metadata. If the database is DBMS consistent both when a transaction starts and when it has been committed and completed, the execution has the consistency property.
The above definition of the consistency property is not useful in distributed databases with relaxed ACID properties because such a database is almost always inconsistent.
In the following, we will use the concept Consistency anomalies for the inconsistencies caused by the missing consistency property in distributed integrated databases with relaxed ACID properties.
In this paper, we will describe countermeasures against the consistency anomalies to make it possible to reduce or prevent the consequences of the missing distributed consistency property. We will also illustrate how to use the countermeasures against the consistency anomalies in ERP systems integrated with heterogeneous E-commerce systems and the databases of mobile salesman ERP modules.
The methods described in this paper may be used in so called CAP optimization where Availability and Partition-tolerance are optimized on the expense of Consistency
A database is DBMS consistent if its data complies with the consistency rules of the DBMS's metadata. If the database is DBMS consistent both when a transaction starts and when it has been committed and completed, the execution has the consistency property.
The above definition of the consistency property is not useful in distributed databases with relaxed ACID properties because such a database is almost always inconsistent.
In the following, we will use the concept Consistency anomalies for the inconsistencies caused by the missing consistency property in distributed integrated databases with relaxed ACID properties.
In this paper, we will describe countermeasures against the consistency anomalies to make it possible to reduce or prevent the consequences of the missing distributed consistency property. We will also illustrate how to use the countermeasures against the consistency anomalies in ERP systems integrated with heterogeneous E-commerce systems and the databases of mobile salesman ERP modules.
The methods described in this paper may be used in so called CAP optimization where Availability and Partition-tolerance are optimized on the expense of Consistency
| Original language | English |
|---|---|
| Title of host publication | Proceedings of the 8th International Conference on Ubiquitous Information Management and Communication |
| Editors | Dongsoo S. Kim, Sang-Wook Kim |
| Number of pages | 7 |
| Place of Publication | New York |
| Publisher | Association for Computing Machinery |
| Publication date | 2014 |
| Article number | 30 |
| ISBN (Print) | 9781450326445 |
| DOIs | |
| Publication status | Published - 2014 |
| Event | The 8th International Conference on Ubiquitous Information Management and Communication - Siem Reap, Cambodia Duration: 9 Jan 2014 → 11 Jan 2014 Conference number: 8 http://www.imcom.org/ |
Conference
| Conference | The 8th International Conference on Ubiquitous Information Management and Communication |
|---|---|
| Number | 8 |
| Country/Territory | Cambodia |
| City | Siem Reap |
| Period | 09/01/2014 → 11/01/2014 |
| Other | (ICUIMC) |
| Internet address |