Universitatea Babeş-Bolyai Cluj-Napoca
Facultatea de Matematică şi Informatică
Ciclul de studii: Licenţă
Domeniul: Informatică
Programul de studii: Informatică - în limba engleză
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+1	speciality	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
1. To get acquainted with the problems regarding the distributed data bases, the concurrent access to the data bases, the client-server technology.
2. To get acquainted with the file storing methods.
2. Database gestion in Delphi.	

IV. Course contents
1. Concurrency control. Transactions.
2. File structure. Physical schema for database. File organizations. Sequential access. ISAM file structures. 2,3-trees. B-trees. Hashing. Multiple attribute search keys. 
3. Query optimization. Implementing relational operators.
4. Database in Delphi.
5. Semistructured data and XML.	

V. Bibliography
1. DATE, C.J., An Introduction to Data Base Systems. Addison Wesley, Reading, MA, 1995.
2. DOLLINGER, R., Baze de date si gestiunea tranzactiilor. Editura Albastra, Cluj-Napoca, 1997.
3. HELMAN, P., The Science of Database Management. Richard D. IRWIN, Inc., 1994.
4. KNUTH, D.E., Tratat de programare a calculatoarelor. Algoritmi fundamentali. Ed.Tehnica, Bucuresti 1974.
5. Knuth, D.E., Tratat de programare a calculatoarelor. Sortare si cautare. Ed.Tehnica, Bucuresti 1976.
6. PHILIPS, L.A., XML, Editura Teora, Bucuresti 2000.
7. TAMBULEA, L. Baze de date, Litografiat Cluj-Napoca 2003.	

VI. Thematic of didactic activities per weeks
Week 1 - Course Brief Presentation. Physical Structure of Database Files
Week 2 - Storage and Indexing
Week 3 - Tree Structured Files
Week 4 - Hash-Based Files
Week 5 - External Sorting
Week 6 - Spatial Data Management
Week 7 - Evaluation of Relational Operations
Week 8 - Relational Query Optimization
Week 9 - Distributed Databases
Week 10 - Transaction Management. 
Week 11 - Concurrency Control
Week 12 - Database Recovery
Week 13 - XML
Week 14 - Course Overview. Problems	

VII. Didactic methods used
- Description, explanation, heuristic conversation, creative discovery	

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.	

IX. Additional references
1. RAMAKRISHNAN, R., Database Manegement Systems. McGraw-Hill, 1998.	

	Date,							Course responsible,
	16-04-2007						Lect. SUCIU Dan Mircea, Ph.D.