Chapter 5. Database advanced administration

Table of Contents

EyeDB databases architecture
Managing datafiles
Creating, listing and deleting datafiles
Renaming and moving datafiles
Resizing and defragmenting datafiles
Managing dataspaces
Creating, listing, and deleting dataspaces
Updating and renaming dataspaces
Getting and setting current datafile

This chapter explains EyeDB databases advanced administration, namely the datafiles and dataspaces concepts that allow to create multi-volumes large EyeDB databases.

The first section describes EyeDB databases architecture; the following sections deal with datafiles and dataspaces management commands.

EyeDB databases architecture

EyeDB databases organisation is based on two concepts:

  • dataspaces: logical organization units for organizing where classes, objects, indexes... will be located

  • datafiles: physical files where data are stored

A database is composed of several dataspaces (at least one). When creating a database with no options, a dataspace named DEFAULT is automaticaly created.

A datafile is always associated to a single dataspace, whilst a dataspace can contain several datafiles (up to 32 datafiles currently). When creating a database with no options, a datafile named DEFAULT, whose filename is <<database_name>>.dat and size is 2 Gb, is automaticaly created; this datafile is associated with the default dataspace.

After database creation, new datafiles and dataspaces can be added at any time using the commands described in this section. Datafiles can be resized, moved, deleted and updated. Dataspaces can be deleted, renamed and updated.