Course Catalogue

Advanced Database Design and Practice (UESTC) UESTCHN5004

  • Academic Session: 2026-27
  • School: School of Engineering
  • Credits: 10
  • Level: Level 5 (SCQF level 11)
  • Typically Offered: Semester 2
  • Available to Visiting Students: No
  • Collaborative Online International Learning: No
  • Curriculum For Life: No

Short Description

The course introduces new progress, new theories, and new technologies of database. Through the study of distributed database, object-oriented database, big data analytics, NoSQL, the basic theory of special databases, students can learn the basic principles of various databases, and apply them for specific particular applications.

Timetable

This course will be timetabled in blocks, typically one week in four.

Requirements of Entry

Mandatory Entry Requirements

None

Recommended Entry Requirements

Have studied the basic principles of relational databases and have a certain foundation in programming.

Excluded Courses

None

Co-requisites

None

Assessment

20% Homework (five homework assignments)

20% Course design and project (including the lab assignments and lab report)

10% Oral presentation (the oral presentation of the assignment and the project or research topic presentation)

55% Final exam (closed-book exam)

Main Assessment In: April/May

Course Aims

This course is aimed at collaborative education between industry and academia, combining advanced database software technology to cultivate graduate students' mastery of advanced database theory and system technology fundamentals, and establish advanced development capabilities in the field of database technology. The course content includes database management system implementation technology, object-based database, Parallel and distributed database, Big Data Analytics, NoSQL database, cloud based database, and new database software technologies. This course will expand the core knowledge of databases for graduate students, enabling them to not only master the theoretical foundation of databases, but also understand advanced technologies and development directions in the field of databases. It will combine basic technology, industry academia integration, and engineering practice, laying a solid professional foundation for graduate students to engage in database research and application development in the future.

Intended Learning Outcomes of Course

By the end of this course students will be able to:

1. Understand the development of database technology and the characteristics and directions of new database technologies, and be able to design and implement relational databases according to requirements.

2. Master the content of object-oriented data models and object-oriented database management systems, several methods for extending relational data models to relational object models, and their implementation principles and application.

3. Master the database and data transparency processing of distributed databases, and be able to design and implement applications of distributed database management systems.

4. Understand the relevant methods and technologies of big data storage and analysis, and be able to use data mining tools for data analysis.

5. Master the data models and implementation principles of mainstream NoSQL databases, and be able to complete the database model design and programming implementation of NoSQL database applications.

Minimum Requirement for Award of Credits

No exceptions