

DBMS
Code: MLR5027
Study cycle: Graduate
Specialization: Computer Science
Semester: 4
Hours: 2+1+1
Credits: 6

Summary
1. Transaction management
2. Evaluation of relational operations and query optimization
3. External sorting
4. Concurrency control.
5. Crash recovery.
6. Database security

Bibliography
1. Aho, A., Hopcroft, J., Ullman, J., Data Structures and Algorithms. Addison-Wesley, Reading, Massachusetts, 1983.
2. Date, C.J., An Introduction to Data Base Systems. Addison Wesley, Reading, MA, 1995.
3. Frentiu, M., Parv, B., Elaborarea programelor. Metode si tehnici moderne. Editura promedia, Cluj-Napoca, 1994.
4. Helman, P., The Science of Database Management. Richard D. IRWIN, Inc., 1994.
5. Korth, H.F., Silberschatz, A., Data Base System Concepts. McGraw-Hill Book Compagny, 1986.
6. Knuth, D.E., Tratat de programare a calculatoarelor. Algoritmi fundamentali. Ed.Tehnica, Bucuresti 1974.
7. Knuth, D.E., Tratat de programare a calculatoarelor. Sortare si cautare. Ed.Tehnica, Bucuresti 1976.
8. Ramakrishnan, R., Database Manegement Systems. McGraw-Hill, 1998.
9. Bjarne Stroustrup, The C++ Programming Language (second edition), Addison Wesley, 1991
10. Tambulea, L. Structuri de date si banci de date, Litografiat Cluj-Napoca 1992.
11. Tambulea, L., Access pentru programatori, Editura Promedia Plus, Cluj-Napoca 1996.
12. T. Themstrom, A. Webber, M. Hotek, MS SQL Server 2008 - Database Development, Self Paced Training Kit 2009


Courses
Course 1 - Introduction in DBMS
Course 2 - Transactions and Concurrency Management
Course 3 - Database Recovery 1
Course 4 - Database Recovery 2
Course 5 - Distributed Databases
Course 6 - Database Security
Course 7 - External Sorting
Course 8 - Evaluation of Relational Operators 1
Course 9 - Evaluation of Relational Operators 2
Course 10 - Query Optimisation
Course 11 - Spatial Data Management
Course 12 - Parallel DBMS
Course 13 - Problems

Seminars
Seminar 1 - ADO.NET 1
Seminar 2 - ADO.NET 2
Seminar 3 - Transactions & Concurrency Management in SQL Server
Seminar 4 - Multiversioning
Seminar 5 - MS SQL Server - Performance Tuning
Seminar 6 - Practical Exam Problem
Seminar 7 - More on Optimizationa

Assessment
Due to GDPR, the final grades will be added to Academic Info platform. You will be able to access them there starting Thursday morning. Thank you for understanding!
The final grade is given by:
- Laboratory activity and a practical test (in the last week of the semester) – 50%
- Written exam – 50%