What are Trends

Trending is storing values of selected variables with a timestamp into memory and to disk of the computer (this is done by the PmaTrendGroup object).
These values can be consequentially displayed in a graphic or table form as time flows of these variables (this is done by the PmgTrendViewer object) or kept for the next analyses.

The PmaTrendGroup object provides both historical (to disk) and memory trending (only in computer memory). The trend server is the PROMOTIC application in which one or more PmaTrendGroup objects are used. Each PmaTrendGroup object represents a group on the trend server that is unambiguously identified by the Trend group identifier string.
For the detailed description of creating trends see PROMOTIC video tutorial 2 - Trends.

Features:

- Client/server architecture.

- Server stores data to disk in the format: dBase, MS SQL, MySQL, FireBird, Oracle Access, PROMOTIC binary,.

- Backup system of storing to disk or into a recurrent file. The size (specified by time or number of rows) of one backup file and the number of these backup files is defined at the backup system. The oldest backup is deleted after the number of backups is reached and a new backup is created.

- "Caching" into memory on the server. Defined data sector is stored into memory in parallel in the process of storing to disk (historical trends). When processing current queries by the server, it needn't query data on the disk. It is the substantial acceleration of data query transactions.

- Server can be a Web component and it can provide data into the Internet/Intranet in the XML and HTML format.

- Server can be asked (independently on a viewer) for a data set. At a data query it is possible to enter filter conditions that limit the asked data set. See for example the PmaTrendGroup.GetData method. This method also allows to statistically evaluate the data (average, minimum, maximum, sum, count).

- The server data can be exported (browser independently) into the text file saved on the computers disk, using for example the *.csv format. See PmaTrendGroup.SaveToFile method.

- The trend server supports the change-optimalized data storage, i.e. the values can be stored only after defined changes occured. See the "Enable saving of variables on change" configurator.

- Data stored by the server can be consequently edited backwards and error values can be corrected by the PmaTrendGroup.SetValueByTime method.

- Server (any PmaTrendGroup object) can read and evaluate data from databases created by the 3rd party in the "Read only (new records cannot be written)" mode by setting the Read only (new records cannot be written) option.

- The trend server (PmaTrendGroup object) can change the data archive location dynamically on the disk or connect to existing data archive by methods PmaTrendGroup.Open, PmaTrendGroup.Close.

- Client (viewer) is the PmgTrendViewer object. Displays data in the graph or table form. The viewer can be located either in the panel of the PROMOTIC system or in the Web browser. The viewer views data continuously and independently on how the backup files were created. Any 3rd party application (for example HTML pages) can be the client that will process data provided by the server for example into the Internet by Web services. The way of the view - the graphic view in the form of 2D or 3D view with a potential for multi-level color diversity of marginal values or the table view with a potential for color diversity of marginal values. See: PmgTrendViewer.ViewMode.

- Interactive viewing the variable flows by the mouse - scrolling and zooming by dragging the mouse.

- The viewer can serve as a stand-alone viewer of 2-dimensional function y=f(x) without the necessity to add the viewer to some data source - the trend server. Thus the independent variable needn't be only the time. The flow of this function is defined in the script by the tvPoints object. See: Example for displaying mathematical functions by means of the trend viewer.

- Dynamic configuration of the viewer. Adding, delete the variable flow, change the graphic appearance, etc. by pre-configured HTML pages on the runtime. See: PmgTrendViewer.DlgTrends and tvTrend.DlgProperties.

- In the viewer it is possible to create configuration files (XML format) where it is possible to store the current settings of the viewer. It goes first of all about saving the list of viewed variables and their configuration but it is possible even to save the graphic appearance of the viewer. By creating several such groups it is then possible very easy to switch the viewer between these groups and so to view flows of logically joint variables. See: Configuration trend files, PmgTrendViewer.SaveCfg and PmgTrendViewer.LoadCfg.