Multi-byte Hash based CSV Load in Bioinformatics

Because using CSV files for data storage and exchange in bioinformatics has some disadvantages, it is usually necessary to load the bioinformatics CSV files into a database. However, the plain text and flexible nature of the CSV format make CSV files with Chinese headers often difficult to parse and correctly load their content. In this paper, we propose a multi-byte hash based bulk load method to load the bioinformatics CSV files with multi-byte headers into a database table. As a result, our proposed method improved data consistency and availability.

Authors

Publication Details

Published
2024-12-03
DOI
https://doi.org/10.1109/bibm62325.2024.10822437
Primary Topic
Genetics, Bioinformatics, and Biomedical Research
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

Multi-byte Hash based CSV Load in Bioinformatics

Zhenggui Xiang
Genetics, Bioinformatics, and Biomedical Research
article

Multi-byte Hash based CSV Load in Bioinformatics

Zhenggui Xiang
article en

Abstract

Because using CSV files for data storage and exchange in bioinformatics has some disadvantages, it is usually necessary to load the bioinformatics CSV files into a database. However, the plain text and flexible nature of the CSV format make CSV files with Chinese headers often difficult to parse and correctly load their content. In this paper, we propose a multi-byte hash based bulk load method to load the bioinformatics CSV files with multi-byte headers into a database table. As a result, our proposed method improved data consistency and availability.

Affordable and clean energy
Openalex Percentile: Top 78%
Genetics, Bioinformatics, and Biomedical Research
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.