Data Management for High-Throughput Genomics

Today's sequencing technology allows sequencing an individual genome within a few weeks for a fraction of the costs of the original Human Genome project. Genomics labs are faced with dozens of TB of data per week that have to be automatically processed and made available to scientists for further analysis. This paper explores the potential and the limitations of using relational database systems as the data processing platform for high-throughput genomics. In particular, we are interested in the storage management for high-throughput sequence data and in leveraging SQL and user-defined functions for data analysis inside a database system. We give an overview of a database design for high-throughput genomics, how we used a SQL Server database in some unconventional ways to prototype this scenario, and we will discuss some initial findings about the scalability and performance of such a more database-centric approach.

[1]  Jun Fang,et al.  Hosting the .NET Runtime in Microsoft SQL server , 2004, SIGMOD '04.

[2]  K. Kinzler,et al.  Gene expression analysis goes digital , 2007, Nature Biotechnology.

[3]  Anil Nori,et al.  The ADO.NET entity framework: making the conceptual level real , 2006, SGMD.

[4]  Jim Gray,et al.  To BLOB or Not To BLOB: Large Object Storage in a Database or a Filesystem? , 2007, ArXiv.

[5]  Susie Stephens,et al.  ODM BLAST: Sequence Homology Search in the RDBMS , 2004, IEEE Data Eng. Bull..

[6]  Ela Hunt Indexed Searching on Proteins Using a Suffix Sequoia , 2004, IEEE Data Eng. Bull..

[7]  Michael Stonebraker,et al.  The POSTGRES Data Model , 1987, Research Foundations in Object-Oriented and Semantic Database Systems.