FSST String Compression with Materialized View Integration

This document discloses a novel approach to integrating FSST (Fast Static Symbol Table) string compression with materialized views in embedded database systems. The implementation demonstrates adaptive compression strategies for VARCHAR and TEXT columns combined with automatic dictionary management, LRU-based caching, and SIMD-optimized batch processing. The system achieves 2-5x compression ratios with throughput exceeding 500 MB/sec for string encoding, while maintaining fullcompatibility with Parquet storage and RocksDB backends. This work establishes prior art for the integration of FSST compression with automatic materialized view refresh cycles, including dictionary training from Arrow string columns and adaptive symbol table optimization.

Authors

Publication Details

Journal
Zenodo (CERN European Organization for Nuclear Research)
Published
2026-03-27
DOI
https://doi.org/10.5281/zenodo.19243980
Primary Topic
Algorithms and Data Compression
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

FSST String Compression with Materialized View Integration

Daniel Moya Vaca
Zenodo (CERN European Organization for Nuclear Research)
Algorithms and Data Compression
article

FSST String Compression with Materialized View Integration

Daniel Moya Vaca
article en

Abstract

This document discloses a novel approach to integrating FSST (Fast Static Symbol Table) string compression with materialized views in embedded database systems. The implementation demonstrates adaptive compression strategies for VARCHAR and TEXT columns combined with automatic dictionary management, LRU-based caching, and SIMD-optimized batch processing. The system achieves 2-5x compression ratios with throughput exceeding 500 MB/sec for string encoding, while maintaining fullcompatibility with Parquet storage and RocksDB backends. This work establishes prior art for the integration of FSST compression with automatic materialized view refresh cycles, including dictionary training from Arrow string columns and adaptive symbol table optimization.

Zenodo (CERN European Organization for Nuclear Research)
Openalex Percentile: Top 6%
Algorithms and Data Compression
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.