Ultra-Structure database design methodology for managing systems biology data and analyses.
BACKGROUND
Modern, high-throughput biological experiments generate copious, heterogeneous, interconnected data sets. Research is dynamic, with frequently changing protocols, techniques, instruments, and file formats. Because of these factors, systems designed to manage and integrate modern biological data sets often end up as large, unwieldy databases that become difficult to maintain or evolve. The novel rule-based approach of the Ultra-Structure design methodology presents a potential solution to this problem. By representing both data and processes as formal rules within a database, an Ultra-Structure system constitutes a flexible framework that enables users to explicitly store domain knowledge in both a machine- and human-readable form. End users themselves can change the system's capabilities without programmer intervention, simply by altering database contents; no computer code or schemas need be modified. This provides flexibility in adapting to change, and allows integration of disparate, heterogenous data sets within a small core set of database tables, facilitating joint analysis and visualization without becoming unwieldy. Here, we examine the application of Ultra-Structure to our ongoing research program for the integration of large proteomic and genomic data sets (proteogenomic mapping).


RESULTS
We transitioned our proteogenomic mapping information system from a traditional entity-relationship design to one based on Ultra-Structure. Our system integrates tandem mass spectrum data, genomic annotation sets, and spectrum/peptide mappings, all within a small, general framework implemented within a standard relational database system. General software procedures driven by user-modifiable rules can perform tasks such as logical deduction and location-based computations. The system is not tied specifically to proteogenomic research, but is rather designed to accommodate virtually any kind of biological research.


CONCLUSIONS
We find Ultra-Structure offers substantial benefits for biological information systems, the largest being the integration of diverse information sources into a common framework. This facilitates systems biology research by integrating data from disparate high-throughput techniques. It also enables us to readily incorporate new data types, sources, and domain knowledge with no change to the database structure or associated computer code. Ultra-Structure may be a significant step towards solving the hard problem of data management and integration in the systems biology era.
Maier
Christopher W
CW
Department of Microbiology and Immunology, UNC Chapel Hill, NC, USA. maier@med.unc.edu
Long
Jeffrey G
JG
Hemminger
Bradley M
BM
Giddings
Morgan C
MC
D019295:Computational Biology / Q000379:methods*; D003628:Database Management Systems; D016208:Databases, Factual; D016247:Information Storage and Retrieval / Q000379:methods; D049490:Systems Biology
J Biomed Inform. 2008 Oct;41(5):706-16
18472304
Biol Cell. 2006 Feb;98(2):135-40
16417469
Nature. 2008 Apr 17;452(7189):872-6
18421352
J Am Med Inform Assoc. 2000 Jul-Aug;7(4):343-56
10887163
J Am Med Inform Assoc. 2000 Sep-Oct;7(5):475-87
10984467
J Am Med Inform Assoc. 2004 Sep-Oct;11(5):380-91
15187070
Bioinformatics. 2000 Feb;16(2):184-5
10842744
Proc Natl Acad Sci U S A. 2003 Jan 7;100(1):20-5
12518051
Nat Rev Genet. 2003 May;4(5):337-45
12728276
Nature. 2007 Jun 14;447(7146):799-816
17571346
BMC Bioinformatics. 2006 Mar 23;7:170
16556315
BMC Bioinformatics. 2005 Feb 21;6:34
15723693
PLoS Biol. 2007 Sep 4;5(10):e254
17803354
J Am Med Inform Assoc. 1999 Nov-Dec;6(6):478-93
10579606
Genome Res. 2007 Jun;17(6):669-81
17567988
BMC Bioinformatics. 2007 May 09;8 Suppl 3:S2
17493285
Bioinformatics. 2003 Dec 12;19(18):2420-7
14668226