Databases (2) |
ter |
||||
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 |