Data #1: Introduction

Click to Print


The Data section in Spry is used to contain and manage mine site reserve information through a collection of Tables. Each Table is a tree-oriented data structure whose purpose is to store and organise reserve data (e.g. source and destination) as well as calendars or any other data that could be considered Constant, as opposed to Variable. Constant data can be defined as any value that should not change when running a mine schedule and/or haulage analysis.

Examples of Constants:

  • Volumes
  • 3D Solids
  • Centroids
  • Qualities

Variable data is discussed later but can be considered to be calculated or user defined data, such as the quantity of coal moved in a month or the distance of a truck haul.

Conceptually, Tables are similar – but not identical to – tables in Relational Database Management Systems (e.g. Microsoft Access, MySQL, SQLite). Where a RDBMS table stores data in rows, in Spry rows are replaced with Nodes, which are organised into a user-defined tree structure. The branches of the tree are called Levels which is discussed in the next section.

Regarding saving your work, although Spry will save your model every time you run a Scenario, because we haven’t yet created or run one you should either hit Ctrl-S on your keyboard or left-click the Save icon at the top left of the screen intermittently as you build your model! There is also a Backup option for your model which will allow you to save a full (or light) version of your model as a different file.

Practical application

To create a new Table, right-click Data in the Project Explorer window and choose New Table. You can also sort your Tables into folders if you wish.

To create a Spry model backup, right click the project name at the top of the Project Explorer tree and left-click Create Project Backup. Default options (nothing ticked on) will create a full backup of the model. Removing items from the database will reduce the size of the backup and may be requested by Precision Mining Support to assist with model transfer (Solids and Triangulations take up a significant portion of most models).