1. Database Architecture, Logical and Physical Storage (Automatic Storage Management), Directory structure of Oracle. 2. Memory structures (SGA, PGA), table spaces, data files, data segments. 3. Database server processes, utilities, Oracle database management tools. 4. Listener, connection establishment, session creation, instance, EZConnect, modes of database startup and shutdown. 5. Database administration - users, schemas, database objects, user profiles, quotas. 6. SQL Processing, Execution Plan. 7. Data Access Methods, Optimizers (CBO). 8. Transaction Management, use of return tablespaces, nested transactions, savepoints. 9. Transaction locking, deadlock, isolation levels, read-consistency. 10. SQL optimizing, Query Optimization Techniques for Partitioned Tables 11. Index, index structure, index usage, hint, b-tree, bitmap, hardparse, softparse, bing query, library cache. 12. Profiling, finding bottlenecks of database applications (OWI, SQL trace), transport monitor, signed tracing session. 13. Backup, archive mode, flashback queries, RMAN.
|
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Work with text (with textbook, with book), Skills training
- Preparation for an exam
- 38 hours per semester
- Contact teaching
- 65 hours per semester
- Home preparation for classes
- 25 hours per semester
- Team project
- 22 hours per semester
|
The aim of the subject is to extend the knowledge of design, development and administration of databases on Oracle platforms. The student will gain orientation in the architecture of the Oracle database system, running processes and returning technologies. Furthermore, the ability to apply selected security principles, transaction mechanisms, work with the execution plan to optimize the SQL queries.
The graduate will acquire information about database architecture and basic knowledge of the administration of the Oracle database system.
|
Oral examination, Written examination, Home assignment evaluation, Self project defence
The conditions of successful completion of the subject are fulfillment of qualified requirements (ability to solve the assigned tasks independently, to process practical tasks in the team, analyzing of discussed topics and ability of practical application.
|