|
Lecturer(s)
|
-
Borkovcová Monika, Ing. Ph.D.
|
|
Course content
|
1. Optimization techniques, execution plans and CBO. 2. The design and selection of suitable structures to data access methods. 3. Enteprise manager - advanced database administration. 4. Advanced database application development - JDBC&Hibernate. 5. Advanced PL/SQL - mapping of Java procedures to PL/SQL. 6. Oracle RAC. 7. Introduction to NoSQL databases, the motivation to use NoSQL databases, NoSQL databases categorization, Big Data 8. Key-value databases (Redis, Riak), categorization, caching, sharding 9. Document databases (MongoDB, CouchDB), access from higher programming language 10. Graph databases (Neo4j), recommendation systems, implementation of recommendation algorithms in graph database 11. Big Data and Map-reduce paradigm, history, architecture. Apache Hadoop, installation, configuration and architecture. 12. Apache Hadoop - programming of map-reduce tasks, performance analysis, map-reduce design patterns 13. Apache Hadoop - extensions (Apache Pig, Apache Hive and Apache Mahout).
|
|
Learning activities and teaching methods
|
|
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Demonstration, Work-related activities
|
|
Learning outcomes
|
The first aim of the course is to get studets acquainted with advanced work with classical RDBMS and with development of advanced database appliactions (ORM, Hibernate, JPA). The second aim is to acquaint students with NoSQL paradigma and Big Data processing.
Development of database appliactions. Database system optimalization. Basic knowledge of NoSQL and Big Date systems.
|
|
Prerequisites
|
Good knowledge of SQL language. Basic knowledge of Oracla Database system, PL/SQL languge a JDBC interface.
|
|
Assessment methods and criteria
|
Oral examination, Student performance assessment, Creative work analysis, Self project defence
Participation in exercises (min. 70%). Elaboration of all tasks assigned to exercise. Preparation and submission of semestral work. Pass the exam.
|
|
Recommended literature
|
-
HARRISON, Guy. Oracle performance survival guide. Upper Saddle River, NJ, 2010. ISBN 01-370-1195-4.
-
KYTE, Thomas. Expert Oracle. Signature ed. Apress, c2005, xviii,1297 p. ISBN 15-905-9525-4..
-
LAM, Chuck. Hadoop in action. Greenwich: Manning Publications, 2011, xxi, 312 S. ISBN 978-1-935182-19-1..
-
McCREARY, Dan - KELLY, Ann. Making sense of NoSQL: a guide for managers and the rest of us. Shelter Island, 2013. ISBN 978-161-7291-074..
-
ROBINSON, Ian - WEBBER Jim. Graph databases. First edition. Sebastopol, Calif, 2013. ISBN 978-144-9356-262.11.
-
WHITE, Tom. Hadoop: the definitive guide. 3rd ed. Sebastopol: O'Reilly, 2012. ISBN 978-1-449-31152-0..
|