Fundamental Database Maintenance

Last modified

Overview

Your SOFTWARE's Fundamental Data database is a large database in which large amounts of financial data are constantly being added and deleted.

Deleting data creates space for new data, but often new data must be split between a number of smaller locations. When that new data is later deleted and further data added, the new data will be put into those locations and often into other locations as well. Over time the data files becomes increasingly fragmented, i.e. spread over a number of locations in the database rather than being in one continuous file at a single location.

A fragmented database will run substantially slower than a defragmented one, both at time of data download and at the point of retrieval for calculation and display by Your SOFTWARE's pages and tools.

Fundamental Database Maintenance Tool

The Fundamental Database Maintenance tool is a three step process.

Data Base Resources Assessment

To perform the maintenance process requires a significant amount of free disk space. This is because the process first creates a new file, then copies data from the old file to the new file and then, when finished, removes the old file.

The process therefore requires there to be free hard disk space approximately 2 times the size of the current database.

The first step therefore is to ascertain the size of the existing database and then assess the size of available hard disc resources.

If there is insufficient free hard disk space a warning message will appear prompting you to create the necessary free space.

For more information on this warning and how to correct it, go to the Insufficient Disk Space section below.

Defragmentation

The tool will first defragment the database.

Depending on the level of fragmentation, the process can take up to thirty minutes.

The level of fragmentation is mainly dependent on the length of time since the last defragmentation, however, the size of the hard-drive, the number and types of other programs running on the PC, and other resource issues can also have their effect.

Compression

Once defragmentation is complete, the tool will have mapped the location of all files and fragments of files.

The tool will then reconstruct the database with all its current data in a more orderly compilation, then compress and save the newly reorganized database for maximum efficiency in the future.

Recommended Frequency

Users should run the Fundamental Database Maintenance every 2-3 months.

Note - The maintenance process can be performed as often as users like. The more frequent the maintenance, the shorter each maintenance session will take.

Running the Fundamental Database Maintenance tool

The Fundamental Database Maintenance tool's command is located in the Maintenance submenu of the Tools menu:

menubtn_toolsmainsmps_fund.gif

Click on the Fundamental Database Maintenance command to run the tool dialog.

Click Start Maintenance.

The Data Base Resources Assessment takes place in the behind the scenes, if there is insufficient space, a Warning dialog will appear and the maintenance process will be halted until sufficient space is made available.

Assuming there is sufficient disk space, the to begin the Defragmentation process will commence:

vg14_datamaintdefrag.gif

The process will automatically progress to the Compression stage:

vg14_datamaintcompres.gif

When the maintenance process is complete, the following Information dialog appears:

vg14_datamaintdone.gif

Click OK to close it, and then click Close to close the Database Maintenance Tool dialog.

Insufficient Disk Space

If the Data Base Resources Assessment detects that the currently free hard disk space is insufficient, the following warning will appear:

vg14_datamaintwarning.gif

The Fundamental Database Maintenance process will not be allowed to proceed until sufficient free disk space has been created.

Make a note of the amount of disk space required, then click OK to close this dialog and exit the Fundamental Database Maintenance process.

Remove Existing Data

Go to Windows Explorer and remove the amount of data files from the C: drive as indicated in the Warning dialog.

Restart the Fundamental Database Maintenance Process

Once sufficient free space has been created, restart the Fundamental Database Maintenance process.

If sufficient free space has been created, the Warning dialog will not appear, and the second step of the Fundamental Database Maintenance Process, the Defragmentation step, will begin.

Topics
Data Setup
Your SOFTWARE analyzes markets to help you trade better and provides both Price Data for technical analysis and Fundamental Data for fundamental analysis as well as news and market reports. In order to do this it needs up-to-date, reliable data from a wide range of exchanges, countries and information providers, in a format compatible with Your SOFTWARE.
Other
Page statistics
943 view(s) and 4 edit(s)
Social share
Share this page?

Tags

This page has no classifications.

Comments

You must to post a comment.

Attachments