RDB Archive Changelog

Version numbers in here refer to the version of the plugin org.csstudio.archive.rdb.

Version 4.0.0 - 2014-08-15

• For -skip_last, assume current time as last time stamp

Version 3.2.15 - 2014-03-03

• Configurable archive reader 'fetch_size' to avoid out-of-memory

Version 3.2.14 - 2014-01-28

• Archive engine can write to configurable table other than "sample"

Version 3.2.13 - 2013-12-31

• In the PostGres table 'sample' data type of 'float_val' has been updated to 'double precision'.

Version 3.2.11 - 2013-11-06

• Fix 'cast' error in Linear interpolation. Invocation from Data Browser export for time range that included string samples like "Disconnected", "Archive Off" resulted in ClassCastException: ..VString cannot be cast to .. vtype.Display

Version 3.2.2 - 2013-11-04

• ArchiveEngine test for invalid time stamps.

Version 3.2.0 - 2013-09-18

• ArchiveEngine uses PVManager.
• Archive RDB writer option 'use_postgres_copy'.
• Added "-skip_last" option to ArchiveEngine not to read last sample time from RDB on start-up.

Version 3.1.1 - 2012-02-30

• RDB Password could not be set from Preference GUI

Version 3.1.0 - 2012-01-30

• BLOB support.

  Waveforms used to be stored element-by-element in a array_val table, which was very portable but inefficient. Now a BLOB column in the sample table holds waveform data. A configuration parameter allows use of either the new BLOB or the old array_val table:

  org.csstudio.archive.rdb/use_array_blob=(true|false)
  

• Preference cleanup

  After the archive plugin reorganization, the settings for url, user, password, schema could be set as preferences of the plugin org.csstudio.archive.rdb and they could _also_ be set as preferences of the plugin org.csstudio.archive.reader.rdb. The latter had the highest precedence for the reader, and the preference GUI in fact _only_ displayed the ...reader.rdb settings, not the fall-back in ...archive.rdb that was used when the ...reader.rdb settings were left empty.

  Now each settings is associated with only one plugin, and the preference GUI always shows the effective settings:

  # Settings for all RDB archive plugins (read, write, config)
  org.csstudio.archive.rdb/url
  org.csstudio.archive.rdb/user
  org.csstudio.archive.rdb/password
  org.csstudio.archive.rdb/schema
  org.csstudio.archive.rdb/use_array_blob
  
  # Additional setting that only applies to the reader
  org.csstudio.archive.reader.rdb/use_stored_procedure
  

  Existing plugin_customization.ini files that used ...reader.rdb to set url, user, password, schema need to be updated to use ...archive.rdb!

  The 'schema' setting (only used for Oracle) used to include a final '.'. Now it should not include a trailing '.'.

Version 3.0.1 - 2011-06-13

• Archive plugin reorganization

  The archive plugins, especially the engine code, was rearranged. These plugins now contain the engine and API for reading or writing archived data:

  org.csstudio.archive.engine
  org.csstudio.archive.config
  org.csstudio.archive.writer
  org.csstudio.archive.reader
  

  These plugins contain the RDB-based implementation:

  org.csstudio.archive.rdb
  org.csstudio.archive.config.rdb
  org.csstudio.archive.writer.rdb
  org.csstudio.archive.reader.rdb
  

  This should make it easier to provide for example a Hypertable-based implementation of the data store.

  Eclipse preferences are set via combination of org.csstudio.archive.rdb and org.csstudio.archive.reader.rdb.

Version 2010-11-15, 2.5.0

• PostgreSQL support
  .. provided by ITER.

Version 2010-03-01, 1.1.0

• Oracle stored procedure
  SNS uses a stored procedure in Oracle to accelerate reading "optimized" data. See org.csstudio.archive.reader.rdb/archive_reader.pls for code. Only used if org.csstudio.archive.reader.rdb/use_stored_procedure is defined.

Version 2009-July-02, 1.0.19

• Initial version of RDB archive SNS uses Oracle-based archive store. Code also supports MySQL.