title: Ultra-Structure database design methodology for managing systems biology data and analyses.
abstract: 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.
authors.affiliation: Department of Microbiology and Immunology, UNC Chapel Hill, NC, USA. maier@med.unc.edu
authors.forename: Christopher W
authors.initials: CW
authors.lastname: Maier
authors.forename: Jeffrey G
authors.initials: JG
authors.lastname: Long
authors.forename: Bradley M
authors.initials: BM
authors.lastname: Hemminger
authors.forename: Morgan C
authors.initials: MC
authors.lastname: Giddings
mesh_terms: D019295:Computational Biology / Q000379:methods*; D003628:Database Management Systems; D016208:Databases, Factual; D016247:Information Storage and Retrieval / Q000379:methods; D049490:Systems Biology
references.citation: J Biomed Inform. 2008 Oct;41(5):706-16
references.pmid: 18472304
references.citation: Biol Cell. 2006 Feb;98(2):135-40
references.pmid: 16417469
references.citation: Nature. 2008 Apr 17;452(7189):872-6
references.pmid: 18421352
references.citation: J Am Med Inform Assoc. 2000 Jul-Aug;7(4):343-56
references.pmid: 10887163
references.citation: J Am Med Inform Assoc. 2000 Sep-Oct;7(5):475-87
references.pmid: 10984467
references.citation: J Am Med Inform Assoc. 2004 Sep-Oct;11(5):380-91
references.pmid: 15187070
references.citation: Bioinformatics. 2000 Feb;16(2):184-5
references.pmid: 10842744
references.citation: Proc Natl Acad Sci U S A. 2003 Jan 7;100(1):20-5
references.pmid: 12518051
references.citation: Nat Rev Genet. 2003 May;4(5):337-45
references.pmid: 12728276
references.citation: Nature. 2007 Jun 14;447(7146):799-816
references.pmid: 17571346
references.citation: BMC Bioinformatics. 2006 Mar 23;7:170
references.pmid: 16556315
references.citation: BMC Bioinformatics. 2005 Feb 21;6:34
references.pmid: 15723693
references.citation: PLoS Biol. 2007 Sep 4;5(10):e254
references.pmid: 17803354
references.citation: J Am Med Inform Assoc. 1999 Nov-Dec;6(6):478-93
references.pmid: 10579606
references.citation: Genome Res. 2007 Jun;17(6):669-81
references.pmid: 17567988
references.citation: BMC Bioinformatics. 2007 May 09;8 Suppl 3:S2
references.pmid: 17493285
references.citation: Bioinformatics. 2003 Dec 12;19(18):2420-7
references.pmid: 14668226