Universitatea Babeş-Bolyai Cluj-Napoca
Facultatea de Matematică şi Informatică
Ciclul de studii: Licenţă
Domeniul: Calculatoare şi tehnologia informaţiei
Programul de studii: Ingineria informatiei - in limba engleza
Limba de predare: Engleză

SYLLABUS

I. General data
Code	Subject	
MIH0003	Transaction Management and Distributed Databases	

Semester	Hours: C+S+L	Category	Status	
4	2+1+2		compulsory	

II. Full status faculty members
Name and	Scientific	Didactic	Chair	Type of activity	
surname	title	title		C	S	L	
SUCIU Dan Mircea	Ph.D.	Lect.	Computer Systems	*			

Associated faculty members
Name and	Scientific	Institution	Type of	Type of activity	
surname	title		position	C	S	L	

III. Course objectives
To get acquainted with the problems regarding the database security, stored procedures, client-server technology, concurrent access to the databases, database recovery, distributed databases.

IV. Course contents
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.

V. 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.

VI. Thematic of didactic activities per weeks

VII. Didactic methods used

VIII. 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.
Detailed information regarding assessment and evaluation could be found at:
            https://www.cs.ubbcluj.ro/~tzutzu/Didactic/TrasactionsDistributedDBEn.htm	

IX. Additional references

	Dean,							Chair head,

	Date,							Course responsible,
								Lect. SUCIU Dan Mircea, Ph.D.