search

timescale / timescaledb

An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
https://www.timescale.com/
Other
17.36k stars 870 forks source link

Ramer-Douglas-Peucker Algorithm #2108

Open tkirchm opened 4 years ago

tkirchm commented 4 years ago

Hi,

is there any way to use Ramer-Douglas-Peucker Algorithm to compress data? Would be very useful for sensor data over several years.

Thomas

mfreed commented 4 years ago

Hi @tkirchm I'm curious if you've tested at least with existing compression algorithms and see how well they work for you re: compressability? Thanks!

tkirchm commented 4 years ago

Hi, Compression itself isn’t my goal. My Sensors only report changes and so I don't have equidistant timedeltas and can't calculate with this data. A time series db with compression like Ramer-Douglas-Peucker usually also can calculate equidistant timedeltas, mean or sum.