"Babes-Bolyai" University of Cluj-Napoca
Faculty of Mathematics and Computer Science

Databases (2)
Code
Semes-
ter
Hours: C+S+L
Type
Section
MI007
6
2+1+2
compulsory
Informatica
MI007
6
2+0+2
optional
Matematică-Informatică
Teaching Staff in Charge
Prof. ŢÂMBULEA Leon, Ph.D.,  leoncs.ubbcluj.ro
Assoc.Prof. VARGA Viorica, Ph.D.,  ivargacs.ubbcluj.ro
Lect. SUCIU Dan Mircea, Ph.D.,  tzutzucs.ubbcluj.ro
Lect. TRÎMBITAS Gabriela, Ph.D.,  gabitrcs.ubbcluj.ro
Asist. SABAU Andreea,  deiushcs.ubbcluj.ro
Asist. COSTA Ciprian,  costacs.ubbcluj.ro
Aims
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.
Content
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.
References
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. RAMAKRISHNAN, R., Database Manegement Systems. McGraw-Hill, 1998.
8. TAMBULEA, L. Baze de date, Litografiat Cluj-Napoca 2003.
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