The structure of physical database, file organizations, the structure of the database catalog.
Index techniques (ISAM, hash, tree indexes, etc.).
The phases of query processing in databases.
- The cost model for query processing evaluation.
- The implementation of the SQL commands.
- Algorithms for the implementation of relational algebra operations:
selection, projection, join (nested loop, indexed nested loop, merge join), etc.
- DBMS statistics.
Algorithms for query optimization.
- Query optimization in System R.
Algorithms for transaction processing.
Physical database design.
Query optimization in MS SQL Server.
Query optimization in Oracle.
Created on 10/23/2006 09:18 AM by potyex
Updated on 02/23/2015 05:33 PM by potyex