Babes-Bolyai University of Cluj-Napoca
Faculty of Mathematics and Computer Science
Study Cycle: Graduate

SUBJECT

Code
Subject
MIH0003 Transaction Management and Distributed Databases
Section
Semester
Hours: C+S+L
Category
Type
Computer Science
4
2+1+1
speciality
compulsory
Information engineering
4
2+1+1
speciality
compulsory
Teaching Staff in Charge
Assoc.Prof. VARGA Viorica, Ph.D.,  ivargacs.ubbcluj.ro
Lect. SUCIU Dan Mircea, Ph.D.,  tzutzucs.ubbcluj.ro
Lect. SABAU Andreea, Ph.D.,  deiushcs.ubbcluj.ro
Lect. EGRI Edith,  egrieditcs.ubbcluj.ro
Aims
To get acquainted with the problems regarding the database security, stored procedures, client-server technology, concurrent access to the databases, database recovery, distributed databases.
Content
1. Database security.
2. Stored procedures.
3. Triggers.
4. Client/Server Database Architecture.
5. Transaction management.
5.1. The transaction’s main activities.
5.2. Concurrency control
5.2.1. Problems: lost update, dirty read, inconsistent analysis
5.2.2. Conflicts, serial and serializable shedules.
5.2.3. Lock-based concurrency control.
5.2.4. Strict two-phase locking.
5.2.5. Deadlock detection.
5.2.6. Optimistic concurrency control: using timestamps, multiversioning.
5.2.7. Transaction support in SQL.
5.3. Database recovery: Undo logging, Redo logging, Undo/Redo logging
6. Parallel database architectures.
7. Distributed databases.
7.1. Distributed database architectures.
7.2. Fragmentation.
7.3. Replication.
7.4. Catalog management.
7.5. Distributed concurrency control.
7.6. Distributed recovery
7.7. Query processing and optimization.
References
1. C. J. Date: An Introduction to Database Systems, 8th Edition, Pearson Education, Inc. Addison-Wesley Higher Education, 2004.
2. Dollinger, R., Baze de date si gestiunea tranzactiilor. Editura Albastra, Cluj-Napoca, 1997.
3. H. Garcia-Molina, J. D. Ullman, J. Widom: Database System Implementation, Prentice Hall Upper Saddle River, New Jersey, 2000.
4. H.T. Ozsu, P. Valduriez, Principles of Distributed Database Systems, Prentice Hall, 1997.
5. R. Ramakrishnan: Database Management Systems, WCB McGraw-Hill, Boston, 1998.
6. A. Silberschatz, H. Korth, S. Sudarshan: Database System Concepts, McGraw-Hill, New York, 2006.
7. Tambulea, L. Baze de date, Litografiat Cluj-Napoca 2003.
8. I. Varga: Adatbázisrendszerek (A relációs modelltől az XML adatokig), Editura Presa Universitară Clujeană, 2005.
Assessment
The laboratory work and a practical exam will represent 50% of the final grade. There will be a final written exam representing 50% of the final grade.
Links: Syllabus for all subjects
Romanian version for this subject
Rtf format for this subject