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.
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
3. Backup data saving into the Access database (Database Access backups) (obsolete)
- Saving all data into one *.mdb file on the disk. The data are saved subsequently into multiple tables in this file.
- Suitable for storing smaller data volumes
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 are saved subsequently into single table.
- Suitable for storing smaller data volumes
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.
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.
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.
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.
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.
10. Data saving into the file in the PROMOTIC format (Promotic binary file cyclic)
- Saving all data into one file on the disk. It is in the internal PROMOTIC data format, not readable by any other program.
- Suitable for storing smaller data volumes into one file on the disk.
- The saving/reading is very fast without the need of any database addons.