Work

FSST String Compression with Materialized View Integration

Year: 2026

Type: article

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.

Source: Zenodo (CERN European Organization for Nuclear Research)

DOI: 10.5281/zenodo.19243979

Author: Moya Vaca, Daniel

Language: English

Topic: Advanced Database Systems and Queries

Subfield: Computer Networks and Communications

Field: Computer Science

Domain: Physical Sciences

Open Access status: green

OpenAlex ID: W7141457036

FWCI:

Cites:

Cited by:

Related to: