Lune

VLDB2025Top-tier venue

Relational Data Models for Genetic VCF data

Mohamed Sabri Hafidi, Ozan Kahramanogullari, Anton Dignös, Johann Gamper

Abstract

The Variant Call Format (VCF) and its binary counterpart (BCF) are commonly used in bioinformatics for storing gene sequence data. While VCF files provide compact storage, they require specific tools and scripts for querying, thereby missing the rich functionality arsenal of database management systems and their potential for integration in multiomics pipelines. In this paper, we leverage Relational Database Management Systems (RDBMS) to enhance efficiency and flexibility in storing and querying large-scale genetic datasets. We map the VCF file structure to narrow, wide, and array-based data models that are further refined using JSON data structures, resulting in eight data models. Our experimental evaluation shows that RDBMS provide competitive performance in comparison with specialized state-of-the-art tools while making full-fledged database capabilities available for genetic data analysis.

Ask Lune

Know this paper in minutes, not an afternoon.

Lune can read every page of it and the top-tier papers that cite it, and gives you its claims, its evidence and its limits, each one cited to the paper it comes from. No skimming, no AI slop.

Questions to start from

Lune can draw on

the full paper · related work

Get the answer

Free to start. No credit card required.

Related papers

  1. Gosling: A Grammar-based Toolkit for Scalable and Interactive Genomics Data VisualizationSehi L'Yi, Qianwen Wang, Fritz Lekschas, Nils GehlenborgIEEE VIS 2021 · 73 citations
  2. BioToken and BioFM – Biologically-Informed Tokenization Enables Accurate and Efficient Genomic Foundation ModelsAleksandr Medvedev, Karthik Viswanathan, Praveenkumar Kanithi, Kirill Vishniakov et al.ICML 2026
  3. A Deep Dive into Common Open Formats for Analytical DBMSsChunwei Liu, Anna Pavlenko, Matteo Interlandi, Brandon HaynesVLDB 2023 · 23 citations
  4. M2Bench: A Database Benchmark for Multi-Model Analytic WorkloadsBogyeong Kim, Kyoseung Koo, Undraa Enkhbat, Sohyun Kim et al.VLDB 2023 · 13 citations
  5. GenoREC: A Recommendation System for Interactive Genomics Data VisualizationAditeya Pandey, Sehi L'Yi, Qianwen Wang, Michelle A. Borkin et al.IEEE VIS 2022 · 27 citations
Dusk over the sea between two cliffs drawn in fine vertical lines