FI:P064 Query Languages and Relational

P064 Query Languages and Relational Theory

Faculty of Informatics
Spring 1998

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

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

The course is also listed under the following terms Spring 1999, Spring 2000, Spring 2002.