TU2983: Pangkalan Data Lanjutan

Kursus ini memperkenalkan prinsip lanjutan dalam reka bentuk dan pengurusan pangkalan data melalui konsep tambahan sistem pangkalan data hubungan, serta memperkenalkan konsep pengaturcaraan visual dalam 4GL. Antara kandungannya ialah: pangkalan data teragih, kawalan serempak, pengindeksan, pangkalan data berorientasikan objek, dan aplikasi pangkalan data terkini; Pembangunan aplikasi pangkalan data: takrifan borang kemasukan data dan struktur laporan, pengungkapan queri dalam atur cara 4GL; Pengurusan pangkalan data dan tugas DBA: pengesahan, kawalan dan penguncian transaksi, pengendalian serempak, penyelenggaraaan konsisten, dan baik pulih kerosakan; Pemprosesan queri dan pengurusan urusniaga dalam pelanggan-pelayan atau pangkalan data teragih.


TU2983: Advanced Databases

This course covers advanced concepts in database design and management, as it pertains to relational database systems, and introduces visual programming in 4GL.  Among the contents are: distributed databases, concurrency controls, indexing, object oriented databases, and the latest database applications;   Development of database applications includes: definition of data-entry forms, structured reports, and embedded queries in 4GL programming;  Database management and DBA tasks deals with: verification, transaction control and locking, concurrency control mechanisms, consistency maintenance, and data recovery from errors;  Also covered are query processing and transaction management in client-server systems and distributed database systems.