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)
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