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.
Related papers
- Gosling: A Grammar-based Toolkit for Scalable and Interactive Genomics Data VisualizationSehi L'Yi, Qianwen Wang, Fritz Lekschas, Nils GehlenborgIEEE VIS 2021 · 73 citations
- BioToken and BioFM – Biologically-Informed Tokenization Enables Accurate and Efficient Genomic Foundation ModelsAleksandr Medvedev, Karthik Viswanathan, Praveenkumar Kanithi, Kirill Vishniakov et al.ICML 2026
- A Deep Dive into Common Open Formats for Analytical DBMSsChunwei Liu, Anna Pavlenko, Matteo Interlandi, Brandon HaynesVLDB 2023 · 23 citations
- M2Bench: A Database Benchmark for Multi-Model Analytic WorkloadsBogyeong Kim, Kyoseung Koo, Undraa Enkhbat, Sohyun Kim et al.VLDB 2023 · 13 citations
- 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
