Database Save settings

OLAP is an in-memory technology. For performance reasons, the data that you work with is held in active memory. Changes that you make to that data are held only in memory and are not saved in the event of a power loss. It is, therefore, good practice to save changed data back to disk regularly. This is distinct from backing up the database and is analogous to saving your files regularly when working with a word processing application, for example.

You can specify that an OLAP database is automatically saved to disk, and the minimum interval between saves. The database is not accessible during saving. You should, therefore, specify a save interval that keeps a balance between the likely number of data changes and the need to minimize disruption to users.

Note: When the system is under a high load, a save might be queued and executed only after other operations are finished.

You can save the database manually at any time that an automatic save is not in progress.

Saved databases are stored in the local directory location that is specified on the Directories tab of the Farm Expert.

  1. Select Dashboards > OLAP > Save and Backup.
    The Database Save widget shows the time at which the next save is scheduled, and the time elapsed since the last save.
  2. In the Databases widget, select the database to administer.
  3. In the Database Save widget, select Save Database Automatically.
  4. Select the appropriate time zone and specify this information:
    First Save At
    Select the time at which the database is first saved to disk and click Set Time.
    Save Interval
    Specify the interval after the first save, at which the database is saved automatically.
  5. Click Save Settings.
  6. Optionally, to save the database manually, click Save Database Now.
    The button is disabled while saving is in progress.