It’s 6:02am, a cool winter morning in Friedrichshafen, Germany. It’s dark night outside. My friend Richard Luft, our partner at www.bytec.eu, told me he would pick me up at 6:00am at the hotel. I looked out through the window and while I couldn’t see the Lake Constanze, I could see his car right there, of course, and I knew I was very late now. I rushed up and by 6:04 I sat in, apologizing for my tardiness. “No problem” he said, “I used this time to buy a ticket online for a show that I saw advertised in one of the major TV channels, by the way, did you know that the biggest online ticket sales in Germany runs on IBM Informix?”, I quickly replied “and did you know that that TV channel is part of the biggest TV group and it also runs in IBM Informix?”. Smiles.
Compression of TimeSeries data was first introduced in 12.10.xC3. This feature provides compression algorithms on sensor data to maximize the storage efficiency. It was limited to numeric types (smallint, integer, bigint, real, and float). While this worked well for applications that only captured numeric sensor data, there are many use cases where other data is captured that is not numeric. This latest enhancement to TS compression supports these applications capturing non-numeric data from the sensors.