Open Access   Article Go Back

An Approach Towards Designing Relational Database With Transaction Operations

Kunal Kumar1 , Sachindra Kumar Azad2

  1. Department of Statistics and Computer Applications, T. M. Bhagalpur University, Bhagalpur, India.
  2. Department of Statistics and Computer Applications, T. M. Bhagalpur University, Bhagalpur, India.

Correspondence should be addressed to: skazad@rediffmail.com.

Section:Research Paper, Product Type: Journal Paper
Volume-5 , Issue-12 , Page no. 267-272, Dec-2017

CrossRef-DOI:   https://doi.org/10.26438/ijcse/v5i12.267272

Online published on Dec 31, 2017

Copyright © Kunal Kumar, Sachindra Kumar Azad . This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

View this paper at   Google Scholar | DPI Digital Library

XML View
PDF Download

How to Cite this Paper

  • IEEE Citation
  • MLA Citation
  • APA Citation
  • BibTex Citation
  • RIS Citation

IEEE Style Citation: Kunal Kumar, Sachindra Kumar Azad, “An Approach Towards Designing Relational Database With Transaction Operations,” International Journal of Computer Sciences and Engineering, Vol.5, Issue.12, pp.267-272, 2017.

MLA Style Citation: Kunal Kumar, Sachindra Kumar Azad "An Approach Towards Designing Relational Database With Transaction Operations." International Journal of Computer Sciences and Engineering 5.12 (2017): 267-272.

APA Style Citation: Kunal Kumar, Sachindra Kumar Azad, (2017). An Approach Towards Designing Relational Database With Transaction Operations. International Journal of Computer Sciences and Engineering, 5(12), 267-272.

BibTex Style Citation:
@article{Kumar_2017,
author = {Kunal Kumar, Sachindra Kumar Azad},
title = {An Approach Towards Designing Relational Database With Transaction Operations},
journal = {International Journal of Computer Sciences and Engineering},
issue_date = {12 2017},
volume = {5},
Issue = {12},
month = {12},
year = {2017},
issn = {2347-2693},
pages = {267-272},
url = {https://www.ijcseonline.org/full_paper_view.php?paper_id=1614},
doi = {https://doi.org/10.26438/ijcse/v5i12.267272}
publisher = {IJCSE, Indore, INDIA},
}

RIS Style Citation:
TY - JOUR
DO = {https://doi.org/10.26438/ijcse/v5i12.267272}
UR - https://www.ijcseonline.org/full_paper_view.php?paper_id=1614
TI - An Approach Towards Designing Relational Database With Transaction Operations
T2 - International Journal of Computer Sciences and Engineering
AU - Kunal Kumar, Sachindra Kumar Azad
PY - 2017
DA - 2017/12/31
PB - IJCSE, Indore, INDIA
SP - 267-272
IS - 12
VL - 5
SN - 2347-2693
ER -

VIEWS PDF XML
571 288 downloads 204 downloads
  
  
           

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.

Key-Words / Index Term

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

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