Course: Architecture and Techniques of Database Systems

« Back
Course title Architecture and Techniques of Database Systems
Course code KIT/INADS
Organizational form of instruction Lecture + Lesson
Level of course Master
Year of study not specified
Semester Winter
Number of ECTS credits 5
Language of instruction Czech
Status of course Compulsory
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Borkovcová Monika, Ing. Ph.D.
  • Kavička Antonín, prof. Ing. Ph.D.
Course content
The architecture of database system, logical and physical storage (Automatic Storage Management). Memory structures (SGA, PGA). Proceses of database system. The connection establishing, session creation, instance. Database management, tools for database maintanance (Oracle Enterprise Manager). SQL processing, execution plan. Data access methods, optimizers (CBO). Transactions management, usage of undo table spaces. Transactional locks, competition, deadlock. Optimize of SQL query processing, partitiong. Index, the structure of index, proper index usage. Profiling, searching the bottlenecks of database applications (OWI, SQL Trace). ORM - proper way how to use databases.

Learning activities and teaching methods
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Demonstration, Projection, Skills training
Learning outcomes
The main aim of the course is to familiarize students with the architectures and techniques of database systems and to broaden knowledge of database design, development and administration on Oracle platform.
The overviews in Oracle database system architecture, processes and redo technologies. The ability to apply basic security rules, transactional mechanisms, work with execution plan.
Prerequisites
unspecified

Assessment methods and criteria
Written examination, Home assignment evaluation, Creative work analysis, Didactic test, Discussion

Credit is awarded on attendance at seminars, readiness, ability to solving problems and passing the tests during the semester. Examination is a an oral analysis of the topics discussed with emphasis on mastering basic principles of issue.
Recommended literature
  • ANTOGNINI, Christian. Troubleshooting Oracle performance. Berkeley, CA, 2011. ISBN 15-905-9917-9.
  • Conolly, Thomas. Mistrovství - databáze : profesionální průvodce tvorbou efektivních databází. Brno: Computer Press, 2009. ISBN 978-80-251-2328-7.
  • HARRISON, Guy. Oracle performance survival guide. Upper Saddle River, NJ, 2010. ISBN 01-370-1195-4.
  • Kyte, Thomas. Oracle : návrh a tvorba aplikací. Brno: CP Books, 2005. ISBN 80-251-0569-5.
  • LEWIS, Jonathan. Cost-based Oracle fundamentals. Berkeley, CA, 2007. ISBN 978-1-59059-636.
  • Loney, Kevin. Oracle Database : kompletní průvodce. Brno: Computer Press, 2010. ISBN 978-80-251-2489-5.
  • MORTON, Karen. Expert's voice in Oracle. New York, 2010. ISBN 14-302-3228-5.


Study plans that include the course
Faculty Study plan (Version) Branch of study Category Recommended year of study Recommended semester
Faculty of Electrical Engineering and Informatics Information Technology (2015) Informatics courses 1 Winter
Faculty of Electrical Engineering and Informatics Information Technology (2014) Informatics courses 1 Winter
Faculty of Electrical Engineering and Informatics Information Technology (2016) Informatics courses 1 Winter