Abstract
- This paper presents a relational integration of the TSXor compression algorithm for regularly sampled time-series data. We design and implement a schema and compression pipeline within TimescaleDB, allowing lossless compression and in-database decompression using SQL and PL/pgSQL. Our approach replaces full timestamps with delta-based offsets and encodes floating-point values using reference-based XOR encoding. We evaluate the system on multiple real-world datasets, showing moderate compression ratios (up to 23%) and fast decompression performance. While the SQL-based implementation introduces storage and execution overhead, the integration enables transparent querying and lays the foundation for further database-native optimizations of time-series compression.