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


Prerequisites

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

Introduction

Version managed datastore

Multi-user working

Smallworld Datastore Server

Managing the database

Monitoring performance

Backup and integrity

Problem solving and disaster recovery

Superfiles

Working top

Persistent cache

Managing remote data

Extracts

Replicas

Planning, strategies and recording

External databases

Rasters

Managing large databases

Data model evolution