Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Trend storage technology comparison

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

1. dBase backup data saving (Database dBase backups)

- Saving all the data into *.dbf files on the disc. 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 disc
- 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 can't be written) mode is supported. In this mode it is possible to connect only to archives created by the PmTrend 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 can't be written) mode is not supported.

3. Access backup data saving (Database Access backups) (obsolete)

- Saving all data into one *.mdb file on the disc. The data is being saved subsequently into multiple tables in this file.
- Suitable for saving smaller data volumes
- The Read only (new records can't be written) mode is not supported.

4. Access data saving into the one table (Database Access cyclic)

- Saving all data into one *.mdb file on the disc. The data is being saved subsequently into single table.
- Suitable for saving smaller data volumes
- The Read only (new records can't be written) mode is supported. In this mode, it is possible to connect to archives created by the PmTrend object and also to data saved into databases created by another programs.

5. MS SQL data saving into the one table (Database MS SQL server cyclic)

- Saving all data into one MS SQL server 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 can't be written) mode is supported. In this mode, it is possible to connect to archives created by the PmTrend object and also to data saved into databases created by another programs.

6. MySQL data saving into the one table (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 can't be written) mode is supported. In this mode, it is possible to connect to archives created by the PmTrend object and also to data saved into databases created by another programs.

7. FireBird data saving into the one table (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 can't be written) mode is supported. In this mode, it is possible to connect to archives created by the PmTrend object and also to data saved into databases created by another programs.

8. Oracle data saving into the one table (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 can't be written) mode is supported. In this mode, it is possible to connect to archives created by the PmTrend object and also to data saved into databases created by another programs.

9. Saving into the file in the PROMOTIC format (Promotic binary file cyclic)

- Saving the data into one file on the disc. 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 disc.
- The saving/reading is very fast without the need of any database addons.
- The Read only (new records can't be written) mode is supported. In this mode it is possible to connect only to archives created by the PmTrend object.
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice