The Analyzed Erp System

Published Date: 02 Nov 2017

Refrence # 3: L. Frank. "Countermeasures against Consistency Anomalies in Distributed Integrated Databases with Relaxed ACID Properties."International Conference on Innovations in Information Technology, 2011, pp. 266-270.

Summary: L. Frank [3] used ACID properties of a DBMS in distributed and/or mobile databases and made the availability of data with optimization. The idea of Consistency anomalies is used for the inconsistencies caused by the missing consistency property in distributed integrated databases with relaxed ACID properties. Countermeasures against the consistency anomalies are also discussed to make it possible to reduce or avoid the consequences of the missing distributed consistency property. The countermeasures which are described have not been discussed in the scientific literature before but they may have been used in practice as the problems of the missing distributed integrity control may have been dealt with in practical implementations of extended transaction models.

Refrence # 4: D. Chkliaev, J. Hooman, P. Ven der Stok. "Mechanical Verification of Transaction Processing Systems." Third IEEE International Conference on Formal Engineering Methods, 2000, pp.89-97

Summary: D. Chkliaev et al [4] have presented formal specifications and mechanical verifications of transaction processing system aimed at distributed database system and the relationship of ACID properties among themselves. The protocols which are used for formal verification is two-phase locking, undo/redo recovery and two-phase commit. The locking and undo/redo mechanism at distributed sites is characterized by state machines, whereas the interaction between sites according to the two-phase commit protocol is precise by assertions.

Refrence # 5: Sylvia, Vibha, R.B.Patel. "Queue Sensing Distributed Real-time Commit Protocol: A New Dimension for Distributed Database System." International Conference on Advances in Recent Technologies in Communication and Computing International Conference on Advances in Recent Technologies in Communication and Computing International Conference on Advances in Recent Technologies in Communication and Computing, 2009, pp. 829-834.

Summary: Improvement in the performance of transactions in real time distributed system has been proposed by Sylvia et al [5] . The protocol used in the research paper is Queue Sensing Distributed Real-time Commit Protocol (QSDRCP) which ensures the maximum number of transactions is processed before the deadline expires and the ACID property of the transactions executed is preserved. Comparison of QSDRCP with other protocols which are working to improve the performance of transactions is also discussed.

Refrence # 6: B. Omar, A. Abdulaziz. "A Distributed Transaction Model for a Multi-database Management System". International Journal of Scientific and Engineering Research, Vol. 3., 2012.

Summary: B. Omar et al [6] has discussed the distributed transaction issues that are present in multi-database management systems (DBMSs) and how the distributed transaction in database technology differs from other distributed processing systems. Furthermore, transactions problems such as network problem, site failure and time failure is also discussed. This research paper proposed a new distributed transaction model for performing and managing transaction details more efficiently.

Refrence # 7: S.K. Madria, B. Bhargava. "A Transaction Model to Improve Data Availability in Mobile Computing". Distributed and Parallel Databases, Vol. 10., pp.127-160, 2001.

Summary: S.K. Madria et al [7] have proposed a technique of prewrites for mobile transactions. Prewrite values help in increasing accessibility as the transactions can be executed during disconnections both at mobile host (MH) and mobile service station (MSS) without blocking. The proposed technique allows a transaction’s execution to shift from the MH to MSS for database updates. Therefore it reduces the computing expenses. In this research paper algorithms for the proposed transaction processing model and the locking protocols are also discussed.

Refrence # 8: N. N. Taboudjemat, F. Chehbour. "On Performance Evaluation and Design of Atomic Commit Protocols for Mobile Transactions". Distributed and Parallel Databases, Vol. 2., pp.53-94, 2010.

Summary: N. N. Taboudjemat et al [8] have studied the impact of the various and fluctuant parameters of wireless and mobile systems on a set of ACPs for mobile environment. It highlights performance indices which give orientations to the design of an adaptable approach that supports different atomicity notions satisfying a wide range of applications and environment requirements[8]. This research paper focused on the atomic commit protocols for mobile transactions designed for infrastructure based mobile networks. Furthermore, evaluating a set of such protocols are also discussed and highlighted their performance indices.

Refrence # 9: Y. Jayanta, Y.S. Singh, A.Gaikwad, S.C.Mehrotra. "Dynamic Management of Transactions in Distributed Real-Time Processing System". International Journal of Databases Management Systems, Vol. 2., pp.161-170, 2010

Summary: Y. Jayanta et al [9] has discussed the transactions problems in real time distributed processing system. In this paper a series of simulation study have been performed to evaluate the performance under different transaction management situation such as different workloads, distribution methods, impact of dynamic slack factors to throughput. The arrangement of data accesses are done in order to meet their deadlines and to minimize the number of transactions that missed deadlines. The advantage of this paper is that, the system gives a significant improvement in performance.

Refrence # 10: B. Mu, X. Zhang, S. Yuan. "A Case Study for Distributed Business Transaction Coordination across Heterogeneous Platforms". International Conference on Electrical and Control Engineering, 2010, pp.4584-4589.

Summary: B. Mu et al [10] have been presented the technology of Web Service Atomic Transaction (WS-AT) for performance, workload and the architecture of distributed system. With WS-AT support we can completely ignore the differences of the heterogeneous platforms to reuse the legacy IT assets in modern systems and make existing EIS’s architecture more extendable, flexible, reliable and interoperable to enhance the system’s quality of service in an open SOA environment. The disadvantage of this technology is that it is not suitable for processing the transactions with long time duration and will in some cases increase the system’s workload.