Data bases (2) |
ter |
|||||
Teaching Staff in Charge |
Prof. ŢÂMBULEA Leon, Ph.D., leon@cs.ubbcluj.ro Lect. VARGA Viorica, Ph.D., ivarga@cs.ubbcluj.ro Lect. SUCIU Dan Mircea, Ph.D., tzutzu@cs.ubbcluj.ro Lect. TRÎMBITAS Gabriela, Ph.D., gabitr@cs.ubbcluj.ro Asist. ONET Adrian, adrian@cs.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 2001. |
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. |