Data archiving in the D2000 system

A part of the D2000 system is the efficient archiving and balancing system (D2000 Industrial SQL Archive), that provides the following functions: 

1. Archiving of object values in the system (primary archive).
2. Calculation of archived values using a statistical function (statistical archive).
3. Calculation of archived values using defined expression (calculated archive).
4. Script-filled archive (Value warehouse).

Each object of the Historical value type has a configuration parameter specifying the archive history depth. Values older then than the depth are automatically deleted. Checking the option Depository causes the value to be stored also in the depository database. In some cases, it may be important to know that the archive process was not running. For this purpose, the archive process writes special values with the START and STOP attributes flags - if the option "Write Start/Stop must be " option is checked. The The Archive option Archive enables/disables writing into the archive database.

...

To ensure reliability and adequate performance, the archive is optimised optimized for the use with PostgreSQL, Oracle, AND Sybase Adaptive Server Anywhere , PostgreSQL and Oracle databases. Oracle database must be used on the OpenVMS platform (a Sybase port doesn't exist) and is recommended tested for the use in large-scale systems (terrabyte terabyte archives). Using Sybase Adaptive Server Anywhere is recommended for archives under 10 GB when using SQL Anywhere 9.0 and under 50 GB when using SQL Anywhere 12.0.
Using PostgreSQL is recommended for middle-sized archives (tested on 800 GB archive databasedue to its price-performance ratio for all archives ranging from small to large (used in production on 2 TB archive database and over 14 TB of depository databases).

Besides the databases mentioned above, the D2000 system also supports the MS SQL server (see the topic Support of MS SQL 2000, MSDE 2000, SQL Server 2005 Express, and MS SQL 2008 express edition).
For the ''LITE'' version, which has small applications with low requirements for the archive subsystem performance, it is possible to use a freely available database MSDE (Microsoft Desktop Engine) - it is a version of the MS SQL server with limited performance. For more information on MS SQL and MSDE see the topic Support of MS SQL 2000, MSDE 2000, SQL Server 2005 Express, and MS SQL 2008 express edition.

...

Using the standard SQL databases provides the possibility to analyse analyze and process historical values by means of external tools, e.g. Microsoft Excel.