MIH0003 | Transaction Management and Distributed Databases |
Mathematics-Computer Science - in Hungarian |
||||
Teaching Staff in Charge |
Assoc.Prof. VARGA Viorica, Ph.D., ivargacs.ubbcluj.ro Lect. SUCIU Dan Mircea, Ph.D., tzutzucs.ubbcluj.ro Lect. SABAU Andreea, Ph.D., deiushcs.ubbcluj.ro |
Aims |
To get acquainted with the problems regarding the database security, stored procedures, client-server technology, concurrent access to the databases, database recovery, distributed databases.
|
Content |
1. Database security.
2. Stored procedures. 3. Triggers. 4. Client/Server Database Architecture. 5. Transaction management. 5.1. The transaction’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. |
References |
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. |
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 |