Course: Advanced Database Systems

» List of faculties » FAI » AUPKS
Course title Advanced Database Systems
Course code AUPKS/AE9PD
Organizational form of instruction Lecture + Lesson
Level of course Master
Year of study not specified
Semester Winter and summer
Number of ECTS credits 4
Language of instruction Czech, English
Status of course unspecified
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Beltran Prieto Luis Antonio, MSc.
  • Šilhavý Petr, doc. Ing. Ph.D.
  • Prokopová Zdenka, doc. Ing. CSc.
Course content
- Introduction to "advanced" databases - from SQL to NoSQL - Principles of NoSQL databases - scalability, sharding, replication etc. - Distributed data processing - MapReduce - Key-value NoSQL database - Document NoSQL databases - Column NoSQL databases - Graph NoSQL databases - Multi-model databases - Other Big Data processing options - Query languages in NoSQL - MongoDB - installation and configuration - MongoDB - basic operations, creation and use of indexes - MongoDB - support for database aggregation and modeling - MongoDB - management and use of roles and users, regular expressions

Learning activities and teaching methods
Monologic (Exposition, lecture, briefing), Dialogic (Discussion, conversation, brainstorming), Demonstration, Exercises on PC, Practice exercises
prerequisite
Knowledge
Knowledge from relational database systems - relational model, normal forms, SQL language, data security.
Knowledge from relational database systems - relational model, normal forms, SQL language, data security.
learning outcomes
define the concept of Big Data
define the concept of Big Data
characterize the methods of distributed data processing
characterize the methods of distributed data processing
explain the principle of the CAP theorem
explain the principle of the CAP theorem
list the different types of NoSQL databases
list the different types of NoSQL databases
describe other BigData processing options
describe other BigData processing options
Skills
design a document database model
design a document database model
install and configure MongoDB
install and configure MongoDB
create a database, a collection, a document and save the document to the collection
create a database, a collection, a document and save the document to the collection
find the required data by querying
find the required data by querying
apply the use of indexes, MapReduce, Replication
apply the use of indexes, MapReduce, Replication
teaching methods
Knowledge
Exercises on PC
Dialogic (Discussion, conversation, brainstorming)
Demonstration
Practice exercises
Practice exercises
Demonstration
Monologic (Exposition, lecture, briefing)
Dialogic (Discussion, conversation, brainstorming)
Monologic (Exposition, lecture, briefing)
Exercises on PC
assessment methods
Oral examination
Oral examination
Grade (Using a grade system)
Grade (Using a grade system)
Written examination
Written examination
Analysis of the student's performance
Analysis of the student's performance
Systematic observation of the student
Systematic observation of the student
Recommended literature
  • BANKER, K., et al. MongoDB in action.. New York, 2016.
  • EDWARD, S.G. Practical MongoDb : architecting, developing, and administering MongoDB. Expert's voice in open source.. New York, 2015.
  • ERL, Thomas; KHATTAK, Wajid; BUHLER, Paul. Big Data Fundamentals. New York, 2016.
  • HOLUBOVÁ, Irena, et al. Big Data a NoSQL databáze.. Praha, 2015.
  • PLUGGE, E., et al. The Definitive Guide to MongoDB: A complete guide to dealing with Big Data using MongoDB.. New York, 2015.
  • SADALAGE, Pramod J.; FOWLER, Martin. NoSQL distilled: a brief guide to the emerging world of polyglot persistence.. Pearson Education, 2013.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester