|
You can get the structure of the Enterprise Server DB via the init.sql script, located in the etc subfolder of the Enterprise Server installation folder. |
As a database for Enterprise Server you can use the following variants:
◆internal DBMS (IntDB);
◆external DBMS.
Internal DBMS
When setting access to DBMS for storage and processing of data, use the parameters described below for internal DBMS.
Built-in DBMS (IntDB) parameters
Name |
Default value |
Description |
|---|---|---|
DBFILE |
dbinternal.dbs |
Path to the database file |
CACHESIZE |
2000 |
Database cache size in pages |
SYNCHRONOUS |
FULL |
Mode of synchronous logging of changes in the database to the disk: •FULL — fully synchronous logging to the disk, •NORMAL — synchronous logging of critical data, •OFF — asynchronous logging. |
External DBMS
The following database management systems may be used to arrange the external database for Enterprise Server:
◆Oracle. The settings are given in Appendix B2. Setting Up the Database Driver for Oracle.
◆Microsoft SQL Server Compact Edition (SQL CE). The settings are given in Appendix B3. Setting Up the Database Driver for SQL CE.
◆PostgreSQL. The settings necessary for PostgreSQL are given in Appendix В4. Using the PostgreSQL DBMS.
◆Microsoft SQL Server/Microsoft SQL Server Express. To access these DBMS, an ODBC driver may be used (setting up the parameters of the ODBC driver for Windows is given in Appendix B1. Setting Up the ODBC Driver).
|
With Microsoft SQL Server 2005 it is necessary to use the ODBC driver supplied with this DBMS.
Using of Microsoft SQL Server 2005 (SP4) and later is supported.
It is strongly recommended to install latest service packs for used DB server.
Microsoft SQL Server Express DB is not recommended for anti-virus network with a large number of stations (from 100 and more). |
Comparison Characteristics
|
An internal DB can be used, if at most 200-300 stations are connected to the Server. If the hardware configuration of the computer with Enterprise Server and the load level of other executing tasks are permissible, up to 1000 stations can be connected. Otherwise, you must use an external DB. If you use an external DB and more than 10 000 stations are connected to the Server, it is recommended to perform the following minimal requirements: ◆3 GHz processor CPU, ◆RAM at least 4 Gb for the Enterprise Server and at least 8 Gb for the DB server, ◆UNIX system-based OS. |
When choosing between an internal and external database, take into account the following peculiar parameters of DMBS:
◆In large anti-virus networks (of over 200-300 stations), it is recommended to use an external DB, which is more fault-resistant than internal DBs.
◆The internal DBMS (IntDB) is considerably faster than the external analogs and is recommended mainly for the typical use of databases.
◆You may use an external database in case it will be necessary to work through a DBMS and access the DB directly. To facilitate access, standard APIs may be used, such as OLE DB, ADO.NET or ODBC. Though it is to be noted that there is no ODBC driver for Microsoft SQL CE at present. Still, working in applications with this DBMS may be facilitated by implementing ADO.NET technologies and the LINQ language, which allows using all the possibilities of the .NET Framework platform including the report generation system CrystalReports.