PA152 Efficient Use of Database Systems

Faculty of Informatics
Spring 2017
Extent and Intensity
2/0. 2 credit(s) (plus extra credits for completion). Recommended Type of Completion: zk (examination). Alternate Types of Completion: z (credit).
Teacher(s)
doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
RNDr. Petra Budíková, Ph.D. (assistant)
Supervisor
doc. RNDr. Eva Hladká, Ph.D.
Department of Computer Systems and Communications - Faculty of Informatics
Supplier department: Department of Computer Systems and Communications - Faculty of Informatics
Timetable
Tue 10:00–11:50 D3
Prerequisites
Knowledge of problems in the extent of PB154 Database Systems (or PB168) and PV062 File Organization courses.
Course Enrollment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
Fields of study the course is directly associated with
there are 20 fields of study the course is directly associated with, display
Course objectives
The aim of this course is to teach students principles of database systems from the perspective of physical database design, optimization and tuning.
Syllabus
  • Introduction
  • Data storage: efficient use of secondary storage, records, blocks. Searching: index structures, sequential files, trees, hashing, multidimensional indexes.
  • Query execution: evaluation plan, algebraic laws, cost estimation, algorithms for operators, sorting and joining relations, query execution and pipelining.
  • Query optimization: contribution of indexes, referential integrity, materialized views, table partitioning, disk storage.
  • Database optimization: relational schema tuning, index optimization, database monitoring tools.
  • Transaction management: properties and their implementation, concurrency control, scheduling, data and index locking, logging and recovery from failures.
  • Database security: access rights, data security.
  • Spatial databases: indexes, operators.
  • Analytical tools.
Literature
    recommended literature
  • SILBERSCHATZ, Abraham, Henry F. KORTH and S. SUDARSHAN. Database system concepts. 5th ed. Boston: McGraw-Hill, 2006. xxvi, 1142. ISBN 0072958863. info
  • GARCIA-MOLINA, Hector, Jeffrey D. ULLMAN and Jennifer WIDOM. Database system implementation. Upper Saddle River: Prentice Hall, 2000. xv, 653 s. ISBN 0-13-040264-8. info
Teaching methods
Lectures given in Czech, course materials in Czech.
Assessment methods
Lectures, home assignments, written exam. Home assignments are mandatory and their assessment is included in the final grade.
Language of instruction
Czech
Follow-Up Courses
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Autumn 2002, Autumn 2003, Autumn 2004, Autumn 2005, Autumn 2006, Autumn 2007, Autumn 2008, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2018.
  • Enrollment Statistics (recent)
  • Permalink: https://is.muni.cz/course/fi/spring2017/PA152

Go to top | Current date and time: 24. 5. 2017 23:22, Week 21 (odd)

Contact: istech(zavináč/atsign)fi(tečka/dot)muni(tečka/dot)cz, Office for Studies, access rights administrators, is-technicians, e-technicians, IT support | Use of cookies | learn more about Information System