Skip to main content

Table 2 Data types used for SNP data

From: DRUMS: Disk Repository with Update Management and Select option for high throughput sequencing data

Column

MySQL properties

DRUMS properties

Accession name

TINY INT, primary key

1 byte, key part 1

Chromosome

SMALL INT, primary key

2 byte, key part 2

Position on chromosome

INT, primary key

4 byte, key part 3

Reference nucleotide

VARCHAR

1 byte, value part 1

Mutated nucleotide

VARCHAR

1 byte, value part 2

  1. Used data types in MySQL and DRUMS for SNP data. All columns being part of the primary key are indexed.
Back to article page

BMC Bioinformatics

ISSN: 1471-2105

Contact us