Update cookies preferences
Promotic

Trend storage technology comparison

The saving technology comparation, that can be selected in the PmaTrendGroup object in the "Storage type" configurator can be found below.

1. Backup data saving into the dBase database (Database dBase backups)

- Saving all the data into *.dbf files on the disk. The data are saved into separate files. A large quantity of such files may be created.
- It is useful for storing large amounts of data into separate files on the disk.
- The management of these files is very easy. Compared to another technologies it is sufficiet for example to manually move the old files into the backup folder or delete.
- It can be displayed easily in Excel
- The saving/reading is very fast without the need of any database addons.
- The Read only (new records cannot be written) mode is supported. In this mode it is possible to connect only to archives created by the PmaTrendGroup object.

2. MS SQL backup data saving (Database MS SQL server backups) (obsolete)

- Saving all data into one MS SQL server database. The data are saved subsequently into multiple tables.
- Suitable for storing large data volumes
- The Read only (new records cannot be written) mode is not supported.

3. Backup data saving into the Access database (Database Access backups) (obsolete)

- Saving all data into one *.mdb disk file. The data are saved subsequently into multiple tables in this file.
- Suitable for storing smaller data volumes
- The Read only (new records cannot be written) mode is not supported.

4. Data saving into the one table of the Access database (Database Access cyclic)

- Saving all data into one *.mdb disk file. The data are saved subsequently into single table.
- Suitable for storing smaller data volumes
- The Read only (new records cannot be written) mode is supported. In this mode, it is possible to connect to archives created by the PmaTrendGroup object and also to data saved into databases created by another programs.

5. Data saving into the one table of the MS SQL database (Database MS SQL server cyclic)

- Saving all data into one MS SQL database. The data are saved subsequently into single table.
- Suitable for storing large data volumes into one database table.
- The Read only (new records cannot be written) mode is supported. In this mode, it is possible to connect to archives created by the PmaTrendGroup object and also to data saved into databases created by another programs.

6. Data saving into the one table of the MySQL database (Database MySQL cyclic)

- Saving all data into one MySQL database. All date is saved into single table.
- Suitable for storing large data volumes into one database table.
- The Read only (new records cannot be written) mode is supported. In this mode, it is possible to connect to archives created by the PmaTrendGroup object and also to data saved into databases created by another programs.

7. Data saving into the one table of the FireBird database (Database FireBird cyclic)

- Saving all data into one FireBird database. All date is saved into single table.
- Suitable for storing large data volumes into one database table.
- The Read only (new records cannot be written) mode is supported. In this mode, it is possible to connect to archives created by the PmaTrendGroup object and also to data saved into databases created by another programs.

8. Data saving into the one table of the Oracle database (Database Oracle cyclic)

- Saving all data into one Oracle database. The data are saved into a single table.
- Suitable for storing large data volumes into one database table.
- The Read only (new records cannot be written) mode is supported. In this mode, it is possible to connect to archives created by the PmaTrendGroup object and also to data saved into databases created by another programs.

9. Data saving into the one table of the PostgreSQL database (Database PostgreSQL cyclic)

- Saving all data into one PostgreSQL database. The data are saved into a single table.
- Suitable for storing large data volumes into one database table.
- The Read only (new records cannot be written) mode is supported. In this mode, it is possible to connect to archives created by the PmaTrendGroup object and also to data saved into databases created by another programs.

10. Data saving into the file in the PROMOTIC format (Promotic binary file cyclic)

- Saving all data into one disk file. It is in the internal PROMOTIC data format, not readable by any other program.
- Suitable for storing smaller data volumes into one disk file.
- The saving/reading is very fast without the need of any database addons.
- The Read only (new records cannot be written) mode is supported. In this mode it is possible to connect only to archives created by the PmaTrendGroup object.
PROMOTIC 9.0.31 SCADA system documentation MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r.o.