title: Representing genetic sequence data for pharmacogenomics: an evolutionary approach using ontological and relational models.
abstract: BACKGROUND
  The information model chosen to store biological data affects the types of queries possible, database performance, and difficulty in updating that information model. Genetic sequence data for pharmacogenetics studies can be complex, and the best information model to use may change over time. As experimental and analytical methods change, and as biological knowledge advances, the data storage requirements and types of queries needed may also change.
  
  
  RESULTS
  We developed a model for genetic sequence and polymorphism data, and used XML Schema to specify the elements and attributes required for this model. We implemented this model as an ontology in a frame-based representation and as a relational model in a database system. We collected genetic data from two pharmacogenetics resequencing studies, and formulated queries useful for analysing these data. We compared the ontology and relational models in terms of query complexity, performance, and difficulty in changing the information model. Our results demonstrate benefits of evolving the schema for storing pharmacogenetics data: ontologies perform well in early design stages as the information model changes rapidly and simplify query formulation, while relational models offer improved query speed once the information model and types of queries needed stabilize.
authors.affiliation: Department of Genetics, Stanford Medical Informatics, MSOB X-215, Stanford, CA 94305-5479, USA. rubin@smi.stanford.edu
authors.forename: Daniel L
authors.initials: DL
authors.lastname: Rubin
authors.forename: Farhad
authors.initials: F
authors.lastname: Shafa
authors.forename: Diane E
authors.initials: DE
authors.lastname: Oliver
authors.forename: Micheal
authors.initials: M
authors.lastname: Hewett
authors.forename: Russ B
authors.initials: RB
authors.lastname: Altman
mesh_terms: D000465:Algorithms; D003628:Database Management Systems; D030541:Databases, Genetic; D020869:Gene Expression Profiling / Q000379:methods*; D019146:Hypermedia; D016247:Information Storage and Retrieval / Q000379:methods*; D008957:Models, Genetic; D010597:Pharmacogenetics / Q000379:methods*; D016415:Sequence Alignment / Q000379:methods; D017422:Sequence Analysis, DNA / Q000379:methods*