Advanced databases 1000-2N09ZBD
The course will cover various issues which have not fit into the basic database course. Furthermore, the database research domain is so huge that it would not fit into any basic course. The subjects of lectures will be relational database tuning, object-relational mapping (e.g. Hibernate), columnar data stores (e.g. MonetDB, X100 and Infobright), NOSQL stores (key-value - BerkeleyDB, wide-column Cassandra and ScyllaDB, document - MongoDB, graph – neo4j), advanced server programming (e.g. PL/SQL and PL/pgSQL) and distributed databases.
The lecture will covet the theoretical stuff, while the labs will be extremely practical.
Type of course
Prerequisites (description)
Course coordinators
Assessment criteria
Each laboratory is concluded with a homework assignment that must be done within 5 days. Homeworks are discussed in the next week. Each homework is worth the same number of points. The written exam is worth up to 50% of the total points of laboratories. The grade for the course is awarded on the basis of the total number of points. 90% points gives 5, 80% - 4.5, 70% - 4, 60% - 3.5 and 50% - 3. Less than 50% score means failing the course.
Bibliography
1. Jeffrey Ullman, and Jennifer Widom.First course in database systems, Third edition, Prentice Hall, 2007
2. Hector Garcia-Molina, Jeffrey Ullman, Jennifer Widom, Database Systems: The Complete Book (2nd Edition), 2008
3. Dennis Shasha, Philippe Bonnet, Database Tuning: Principles, Experiments, and Troubleshooting Techniques, Morgan Kaufman, 2002.
4. Sullivan, Dan. NoSQL for mere mortals. Addison-Wesley Professional, 2015.
Additional information
Information on level of this course, year of study and semester when the course unit is delivered, types and amount of class hours - can be found in course structure diagrams of apropriate study programmes. This course is related to the following study programmes:
- Bachelor's degree, first cycle programme, Computer Science
- Master's degree, second cycle programme, Computer Science
Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system: