Apis Honeystore

Apis Honeystore is a time-series database, designed to provide the best possible performance on standard PC Hardware. The time-series may be regularly sampled over time, or based on events/changes if appropriate.

Compared to competing SQL based solutions, it has higher performance, both when storing and retrieving data. Instead of providing an SQL engine for data retrieval, it provides a standard OPC Historical Data Access interface, and optionally OLE DB / ADO and Internet Information Server ISAPI.

The combination of high performance, and standard client interfaces, means that Apis Honeystore is the ideal choice for an industrial database solution. You can sample all the data you want. And you can access this data from almost any PC-based business- or automation-software platform.

Capacity samples

The limitations lie in the hardware. When sampled mode is used, and compression is on, each sample will typically consume 0.5-1 bytes of data. As an example, on a low cost 4x80 GB IDE RAID solution, the system can be configured as follows:

  • Storing 7 500 signals per second for a year
  • Storing 15 000 signals each 10 second for 5 years.
  • Storing 1 500 signals each 100 millisecond for 6 months.

You may set up a mix of storage scenarios on a single system, each with different horizon and sample interval. If you add more hard disk capacity to your system, the capability will scale accordingly. When event-based mode is used, you will in most cases be able to store even more. The horizon is in this case not deterministic.

Apis Honeystore features

  • OPC Historical Data Access interface, supporting the following optional interfaces/methods:
    • IOPCHDA_SyncRead::ReadProcessed: Retrieving the following aggregated values over the resample intervals:
      • Maximum/Minimum;
      • First order interpolated data;
      • Standard deviation and variance;
      • Average;
      • Sum;
      • Sample count.
    • IOPCHDA_Playback, Playback of both raw and aggregated historical data.
  • Non-lossy data compression.
  • Namespace browsing.
  • Storage capacity and performance scales with the hardware provided.
  • Both time-fixed resolution and event-based storage.
  • Different sampling rates can be configured for different sets of tags.
  • Time-series of vectors (e.g. NIR-spectra) and matrices as single items.
  • Sampled data contains:
    • Data value only;
    • Data value and associated OPC DA quality;
    • Data value, associated OPC DA quality and a custom timestamp.
  • Seamless integration of Apis Hive with the ApisLoggerBee module, enabling sampling of data available from third party OPC servers and/or drivers, towards other proprietary interfaces and protocols.
  • Easy and remote configuration through the user interface of Apis Hive and Honeystore using Microsoft Management Console or Apis Management Studio.
  • If errors occur, a tray icon will appear with a red stop or warning sign, flashing periodically, notifying you.
  • All information, warning and error messages are written to log files, enabling remote surveillance and troubleshooting of Apis Honeystore through the log viewer in Apis Management Studio.
  • Visual Basic support through the OPC HDA automation wrapper.
  • A custom DCOM interface available for 3rd party interfacing