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	Sem.	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., ivarga@cs.ubbcluj.ro
Lect. SUCIU Dan Mircea, Ph.D., tzutzu@cs.ubbcluj.ro
Lect. SABAU Andreea, Ph.D., deiush@cs.ubbcluj.ro
Lect. EGRI Edith, egriedit@cs.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&#8217;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.
	
Bibliography	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.