FI:P064 Query Languages and Relational - Course Information

P064 Query Languages and Relational Theory

Extent and Intensity

2/0. 2 credit(s). Recommended Type of Completion: zk (examination). Other types of completion: k (colloquium), z (credit).

Teacher(s)

Jaroslav Pokorný (lecturer)

Course Enrolment Limitations

The course is also offered to the students of the fields other than those the course is directly associated with.

fields of study / plans the course is directly associated with

• Informatics (programme FI, B-IN)
• Informatics (programme FI, M-IN)
• Upper Secondary School Teacher Training in Informatics (programme FI, M-IN)
• Upper Secondary School Teacher Training in Informatics (programme FI, M-SS)
• Information Technology (programme FI, B-IN)

Syllabus

• Query languages. Database model as a typing system for a query language. Expressive power of query languages, relational completeness, extendibility of query languages: arithmetic, aggregation functions, recursion. Query optimization. Examples: INFORMIX, ORACLE, SYBASE, INGRES.
• Text databases.
• Implementation techniques of query evaluation.
• Algorithms for relation operations and their complexity. Parallel query evaluation and optimization in parallel computer architectures.
• Transaction processing, data distribution, replications.
• Distributed adatabases. Queries as transactions.

Language of instruction

Czech

Further Comments

The course is taught annually.
The course is taught: every week.

• Enrolment Statistics (Spring 1999, recent)
  
• Permalink: https://is.muni.cz/course/fi/spring1999/P064