Transaction decomposition technique
A transaction is a collection of operations that performs a single logical function in a database application. Each transaction is a unit of both atomicity and consistency. Thus, transactions are required not to violate any database consistency constraints. In most cases, the update operations in a...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Universiti Utara Malaysia Press
2004
|
| Online Access: | http://psasir.upm.edu.my/id/eprint/34844/ http://psasir.upm.edu.my/id/eprint/34844/1/Transaction%20decomposition%20technique.pdf |
| _version_ | 1848847887381823488 |
|---|---|
| author | Ibrahim, Hamidah |
| author_facet | Ibrahim, Hamidah |
| author_sort | Ibrahim, Hamidah |
| building | UPM Institutional Repository |
| collection | Online Access |
| description | A transaction is a collection of operations that performs a single logical function in a database application. Each transaction is a unit of both atomicity and consistency. Thus, transactions are required not to violate any database consistency constraints. In most cases, the update operations in a transaction are executed sequentially. The effect of a single operation in a transaction potentially may be changed by another operation in the same transaction. This implies that the sequential execution sometimes does some redundant work. It is the transaction designer’s responsibility to define properly the various transactions so that it preserves the consistency of the database. In the literature, three types of faults have been identified in transactions, namely: inefficient, unsafe and unreliable. In this paper, we present a technique that can be applied to generate subtransactions to exploit parallelism. In our work, we have identified four types of relationships which can occur in a transaction. They are: redundancy, subsumption, dependent and independent. By analysing these relationships, the transaction can be improved and inefficient transactions can be avoided. Furthermore, generating subtransactions and executing them in parallel can reduce the execution time. |
| first_indexed | 2025-11-15T09:25:45Z |
| format | Article |
| id | upm-34844 |
| institution | Universiti Putra Malaysia |
| institution_category | Local University |
| language | English |
| last_indexed | 2025-11-15T09:25:45Z |
| publishDate | 2004 |
| publisher | Universiti Utara Malaysia Press |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | upm-348442016-10-10T04:19:52Z http://psasir.upm.edu.my/id/eprint/34844/ Transaction decomposition technique Ibrahim, Hamidah A transaction is a collection of operations that performs a single logical function in a database application. Each transaction is a unit of both atomicity and consistency. Thus, transactions are required not to violate any database consistency constraints. In most cases, the update operations in a transaction are executed sequentially. The effect of a single operation in a transaction potentially may be changed by another operation in the same transaction. This implies that the sequential execution sometimes does some redundant work. It is the transaction designer’s responsibility to define properly the various transactions so that it preserves the consistency of the database. In the literature, three types of faults have been identified in transactions, namely: inefficient, unsafe and unreliable. In this paper, we present a technique that can be applied to generate subtransactions to exploit parallelism. In our work, we have identified four types of relationships which can occur in a transaction. They are: redundancy, subsumption, dependent and independent. By analysing these relationships, the transaction can be improved and inefficient transactions can be avoided. Furthermore, generating subtransactions and executing them in parallel can reduce the execution time. Universiti Utara Malaysia Press 2004 Article PeerReviewed application/pdf en http://psasir.upm.edu.my/id/eprint/34844/1/Transaction%20decomposition%20technique.pdf Ibrahim, Hamidah (2004) Transaction decomposition technique. Journal of Information and Communication Technology, 3 (2). pp. 87-106. ISSN 1675-414X; ESSN: 2180-3862 http://www.jict.uum.edu.my/index.php/previous-issues/132-journal-of-information-and-communication-technology-jict-vol-3-no-2-dec-2004 |
| spellingShingle | Ibrahim, Hamidah Transaction decomposition technique |
| title | Transaction decomposition technique |
| title_full | Transaction decomposition technique |
| title_fullStr | Transaction decomposition technique |
| title_full_unstemmed | Transaction decomposition technique |
| title_short | Transaction decomposition technique |
| title_sort | transaction decomposition technique |
| url | http://psasir.upm.edu.my/id/eprint/34844/ http://psasir.upm.edu.my/id/eprint/34844/ http://psasir.upm.edu.my/id/eprint/34844/1/Transaction%20decomposition%20technique.pdf |