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

Please reload

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

Labs

Lab 1 - 2 weeks

Lab 2 - 1 week

Lab 3 - 2 weeks

Please reload

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%    

Please reload

Faculty of Mathematics and Computer Science

Babes-Bolyai University, Cluj-Napoca, Romania

  • Facebook Clean Grey
  • Twitter Clean Grey
  • LinkedIn Clean Grey