Promotic
WikipediaLinkedInYoutubeTwitterFacebook

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 is stored into separate files. A large quantity of such files may be created.
- It is useful for saving 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 is being saved subsequently into multiple tables.
- Suitable for saving 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 file on the disk. The data is being saved subsequently into multiple tables in this file.
- Suitable for saving 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 file on the disk. The data is being saved subsequently into single table.
- Suitable for saving 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 is being saved subsequently into single table.
- Suitable for saving 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 saving 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 saving 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 is saved into a single table.
- Suitable for saving 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 is saved into a single table.
- Suitable for saving 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 the data into one file on the disk. It is in the internal PROMOTIC data format, not readable by any other program.
- Suitable for saving smaller data volumes into one file on the disk.
- 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.

History:
Pm7.02.00: Created
PROMOTIC 9.0.10 SCADA system documentation - MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice