An Approach Towards Designing Relational Database With Transaction Operations

Authors

  • Kumar K Department of Statistics and Computer Applications, T. M. Bhagalpur University, Bhagalpur, India
  • Kumar Azad S Department of Statistics and Computer Applications, T. M. Bhagalpur University, Bhagalpur, India

DOI:

https://doi.org/10.26438/ijcse/v5i12.267272

Keywords:

Serial Schedule, Relational Database, Normalization, Shared Lock, Exclusive Lock

Abstract

A transaction processing on relational database perform as single logical unit of work, which either executed completely or not at all on database system. A transaction processing on database perform mainly two basic operations read and write operation on the database system. Read operations fetch the content of the database using some standard SQL query and retrieve the data from database to the local logical buffer in main memory. In other hand, write operations, update of the local logical buffer and send back the data from the local main memory to database system for permanent storage. In this paper, we are going to know various applications of transactions schedules and how to resolve the various issues that implicitly generated during the transaction schedule generation. Every transaction has many operations on it; all these operations may or may not be of same duration.

References

[1] A.Waqas, A.W. Mahessar, N. Mahmood, Z. Bhatti, M..Karbasi, A. Shah, February 2015 , “Transaction management techniques and practices in current cloud computing environments: a survey”, IJDMS ) Vol.7, No.1,

[2] Deng, Yuetang Frankl, Phyllis Chays, David, “Testing database transaction consistency”, Technical Report TRC-IS-2003, Page No .184-195, 2003

[3] Elmasri, R. and Navathe, S.B.2007: Fundamentals of Database Systems, 5th Ed., Addison Wesley.

[4] R. G. Tiwari, S. B. Navathe, and G. J. Kulkarni, September 2010. “Towards Transactional Data Management over the Cloud,” 2010 Second Int. Symp. Data, Privacy, E-Commerce, pp. 100–106

[5] S. Das and A. El Abbadi, 2010 “G-Store: A Scalable Data Store for Transactional Multi key Access in the Cloud,” in SoCC’, Indianapolis, Indiana, USA, , pp. 163–174.

[6] Codd E. F., 1970, “A relational model of data for large shared data banks”, Communications of the ACM. vol. 13, No.6, pp. 377–387.

[7] Ravula, R ,2014-2015 "Database : Transactions and concurrency control", online Lecture series , E- Classes by R Ravula. ravindrababuravula.com

[8] Connolly, Thomas, Carolyn Begg, 2005, : Database Systems. A Practical Approach to Design, Implementation, and Management, Pearson Education, 3rd edition.

[9] R. Kaula, and J. Chin, April 1993 “A database approach towards flexiblemanufacturing: A conceptual framework, “ in Computers and Industrial Engieering, Vol 24, No 2, pp. 131-141,1993

[10] Elmagarmid, Ahmed K, “Database Transaction Modelsfor Advanced Applications”, Database, 611, 1992

[11] Gray, Jim Lamport, Leslie, “Consensus on transaction commit”, ACM Transactions on Database Systems, 133-160, Vol – 31, Issue -1 , 2006

Downloads

Published

2025-11-12
CITATION
DOI: 10.26438/ijcse/v5i12.267272
Published: 2025-11-12

How to Cite

[1]
K. Kumar and S. Kumar Azad, “An Approach Towards Designing Relational Database With Transaction Operations”, Int. J. Comp. Sci. Eng., vol. 5, no. 12, pp. 267–272, Nov. 2025.

Issue

Vol. 5 No. 12 (2017): IJCSE December Edition

Section

Research Article

License

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

Authors contributing to this journal agree to publish their articles under the Creative Commons Attribution 4.0 International License, allowing third parties to share their work (copy, distribute, transmit) and to adapt it, under the condition that the authors are given credit and that in the event of reuse or distribution, the terms of this license are made clear.