Database server

For data processing a cursor that is started by the web application copies the records of the live database or of the archive database into one or more temporary evaluation databases for evaluation per SQL.

The database server has the following tasks:

• The live database collects the data constantly arising of the connected machines (including the current status).
• The archive database records the historical data from the archive files (without the current status).
• One or more temporary evaluation databases receive the data by means of the cursor from the live database or from the archive database. A separate evaluation database is created for each logged-on user.

The Stoll-knit report® software uses PostgreSQL as the database server.

Important features of PostgreSQL version 9.5:

• Multiuser capability
• Source code available (C/C++)
• Utilization of several CPUs, if existing (multithreaded)
• APIs for C, C++, Java, Perl etc.
• Available on many different platforms
• Flexible and secure access system to databases
• Fixed and variable records
• Databases with a great number of entries possible
• Supported character sets: https://www.postgresql.org/docs/9.5/multibyte.html
• Supported authentication methods: https://www.postgresql.org/docs/9.5/auth-methods.html
• Supported Client Interfaces: https://www.postgresql.org/docs/9.5/auth-methods.html
• Connections and Authentication: https://www.postgresql.org/docs/9.5/auth-methods.html
• Supported and unsupported features: https://www.postgresql.org/docs/9.5/auth-methods.html