Conference Schedule - PGConf.EU 2012Back
PostBIS - A Bioinformatics Booster for PostgreSQL
Date: Oct. 26, 2012
Biological sequences such as genomic DNA sequences are most commonly stored as ASCII strings in varchar fields or just simple text files outside the database. While this is a valid and functional approach, it deprives us of optimization opportunities, the nature of biological sequence data offers.
PostBIS introduces data types for biological sequences that facilitate maintenance of data integrity, outperform gzip-, bzip2- and, of course, the built-in PostgreSQL-compression in both size and time and drastically improve the performance of standard Bioinformatics applications.