|
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.
|