CFR3203

Physical database design and implementation

(IT)

C Clemence

6 points + 4 hours per week + Peninsula + Prerequisites: CFR2201 or equivalent + Prohibitions: CFR3002, COT3000, COT4430

Synopsis: Embedding SQL in a host language. PL/SQL; implicit and explicit error handling; programming with cursors; physical database design; logical access maps; transaction maps; trade-offs involved in designing for performance versus design for flexibility; query optimisation; internal forms, query trees, access path selection; heuristics versus systematic optimisation; database integrity mechanisms; recovery mechanisms and theory, concurrency mechanisms and theory; security mechanisms; distributed database management systems; problems of achieving distribution, current distributed systems; database trends and state-of-the-art data models; database research areas; object-oriented databases.

Assessment: Examination (2 hours): 50% + Practical work: 50%