História stránky

...

To ensure reliability and adequate performance, the archive is optimised for the use with 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 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 due to its price-performance ratio for all archives ranging from small to large (tested on 800 GB 2 TB archive database and over 12 TB of depository databases).

Besides the databases mentioned above, 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 application 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.

Note: SQLite and MySQL (and MySQL clones such as MariaDB and PerconaDB) are also supported experimentally. For more information, please contact Ipesoft.

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