Product Training Syllabus

Core Spatial Technology: Database Administration

Core Spatial Technology: Database Administration
What will I learn from this course?

The Database Administration Training course explains the concepts of a Smallworld database, and reinforces database administration (DBA) skills through lessons, discussion tasks and hands-on exercises.

Who Should Attend?

Database Administrators (DBAs)

Other personnel responsible for performing the Smallworld DBA function


Smallworld Core Spatial Technology System Administration Training

Practical experience of performing DBA tasks

A basic knowledge of Smallworld Magik is also useful

Course Duration

5 Days

Course Objectives

Understand how a Smallworld database operates

Plan strategies for maintaining a database

Perform core DBA activities such as backing up, compressing and restructuring a database, to ensure data is maintained and optimised

Course Agenda


Version managed datastore

Multi-user working

Smallworld Datastore Server

Managing the database

Monitoring performance

Backup and integrity

Problem solving and disaster recovery


Working top

Persistent cache

Managing remote data



Planning, strategies and recording

External databases


Managing large databases

Data model evolution