Database Management

This course prepares students to analyse and optimise the performance of queries and transactions in databases, manage large-scale relational and NoSQL databases, and apply database security, backup and recovery mechanisms. Study materials: Data Management (DM).

Topics

1. Architecture of database management systems
2. Query processing and optimisation
3. Indexing and performance tuning
4. Transaction management and concurrency control
5. Database backup and recovery
6. NoSQL databases
7. Replication and partitioning of large-scale databases

Each course outcome derives from one programme outcome.

1. CPMK-AIDE-02

   Students are able to build an applied decision basis by optimising computing performance through simultaneous processing, and apply the principles of computing ethics

   CPLP03
2. CPMK-AIDE-01

   Students are able to design and implement advanced artificial intelligence modelling to analyse diverse large-volume data through the management of structured data storage infrastructure.

   CPLP03

CPLP03

Develop advanced artificial intelligence models and manage big data, and build applied decision support with attention to optimal performance and computing ethics.