FTEC4001 Advanced Database Technologies

Course Code and Name: FTEC4001 Advanced Database Technologies
Course Objectives:

To support high-speed online payments, one important issue is efficiency and another important issue is reliability for millions of payments to be transferred among accounts. This course introduces the advanced topics in database systems. The topics include query processing and optimization, transaction management, concurrency control, recovery systems, parallel databases, and distributed database systems.
Course Outcomes:


At the completion of this course, students should be able to:
1. Conduct data analysis using query processing techniques over a large amount of data.
2. Achieve high efficiency by using advanced parallel and distributed querying processing techniques.
3. Build reliable systems to ensure all processing tasks are correct based on transaction processing, concurrency control.
4. Maintain a heavy system by understanding how to recovery from possible systems failures
Programme Outcomes:
(P1) The ability to apply knowledge of mathematics, science, and engineering appropriate to the degree discipline (K/S)
(P2) The ability to design and conduct experiments, as well as to analyze and interpret data (K/S)
(P3) The ability to design a system, component, or process to meet desired needs within realistic constraints, such as economic, environmental, social, political, ethical, health and safety, manufacturability and sustainability (K/S)
(P4) The ability to function in multi-disciplinary teams (S/V)
(P5) The ability to identify, formulate, and solve engineering problems (K/S)
(P6) The understanding of professional and ethical responsibility (V)
(P7) The ability to communicate effectively (S)
(P8) The ability to understand the impact of engineering solutions in a global and societal context, especially the importance of health, safety and environmental considerations to both workers and the general public (V)
(P9) The ability to recognize the need for, and to engage in life-long learning (V)
(P10) The ability to stay abreast of contemporary issues (S/V)
(P11) The ability to use the techniques, skills, and modern engineering tools necessary for engineering practice appropriate to the degree discipline (K/S)
(P12) The ability to use the computer/IT tools relevant to the discipline along with an understanding of their processes and limitations (K/S/V)
(P13) The ability to apply the skills relevant to the discipline of operations research and information technology and their applications in engineering and managerial decision making, especially in financial services, logistics and supply chain management, business information systems, and service engineering and management (K/S)

K = Knowledge outcomes
S = Skills outcomes
V = Values and attitude outcomes