PLATCOM

PLATCOM: Real World Demo

PLATCOM optimizes data storage and retrieval, reducing infrastructure costs and enhancing data processing efficiency.

Live compression flow

Raw data streams through PLATCOM and exits as a much smaller compressed representation.

LIVE PROCESSING
RAW DATA -
COMPRESSED -
PLATCOM
COMPRESS
Input size -
-% saved
Output size -
Animated particles are a visual representation of the data stream, not individual bytes.

Raw vs PLATCOM

LIVE
STORAGE GAIN
-%
reduction in storage size using PLATCOM
Dataset: air_quality
Data Source
Air-quality measurements are retrieved from the Open-Meteo Air Quality API and stored in PostgreSQL by the environment-lab collector. PLATCOM processes the air_quality table and evaluates different compression strategies for the collected environmental data.
USE CASE: REAL

Run Summary

Dataset and clustering details for the current PLATCOM run.
Dataset
air_quality
K
4
Silhouette Score
0.748345
Best Compression
628 B
Best Strategy
BZIP ZSTD ZSTD ZSTD

PLATCOM Method Comparison

Detailed comparison between Monolithic, PerColumn, PerColumnFallback and PLATCOM.

Storage Gain

Accuracy

Compression Time

Method Comparison

Compact comparison of the available compression approaches.
Method Criterion Cluster Mode Raw Size Compressed Size Storage Gain Accuracy Compression Time Decompression Time
Monolithic ALL_FEATURES K=1 7331 B 753 B 89.73% 83.40% 0.0056483100 s 0.0001366330 s
PerColumnFallback ALL_FEATURES expectedK=0|usedK=9 7331 B 786 B 89.28% 79.90% 0.0691086300 s 0.0001751550 s
Platcom ALL_FEATURES K=4 7331 B 628 B 91.43% 100.00% 0.0264543 s 0.000129635 s

Cluster Breakdown

Column groups evaluated during PLATCOM deployment.
Column Group 1
Columns: 4 5 6 7
Column Group 2
Columns: 0 1 2
Column Group 3
Columns: 8
Column Group 4
Columns: 3

Compression Results

Detailed measurements for every compression algorithm and column group.
Columns Scheme Compressed Size Compression Time Decompression Time
4 5 6 7 BZIP 391 B 0.0120893 s 6.5144e-05 s
4 5 6 7 GZIP 461 B 0.0119131 s 4.1149e-05 s
4 5 6 7 LZMA 540 B 0.0129101 s 9.875e-05 s
4 5 6 7 RAW 1067 B 0 s 0 s
4 5 6 7 ZSTD 477 B 0.0115371 s 3.4755e-05 s
0 1 2 BZIP 116 B 0.00718242 s 4.5444e-05 s
0 1 2 GZIP 75 B 0.0044122 s 8.5e-06 s
0 1 2 LZMA 120 B 0.00986571 s 3.2909e-05 s
0 1 2 RAW 2376 B 0 s 0 s
0 1 2 ZSTD 52 B 0.0030391 s 8.351e-06 s
8 BZIP 68 B 0.00329304 s 2.018e-05 s
8 GZIP 52 B 0.00387477 s 7.253e-06 s
8 LZMA 96 B 0.00521248 s 1.8438e-05 s
8 RAW 1944 B 0 s 0 s
8 ZSTD 32 B 0.00323434 s 8.304e-06 s
3 BZIP 216 B 0.00377421 s 3.1506e-05 s
3 GZIP 247 B 0.00371861 s 1.3458e-05 s
3 LZMA 268 B 0.0055644 s 3.2191e-05 s
3 RAW 1944 B 0 s 0 s
3 ZSTD 153 B 0.0036355 s 2.8686e-05 s

Detailed Algorithm Results

Comparison of BZIP, GZIP, LZMA and ZSTD for each PLATCOM column group.

Compressed Size

Compression Time

Compression vs Decompression Time