Specifying Updates in Biomedical Databases

  • Authors:
  • Hartmut Liefke;Susan B. Davidson

  • Affiliations:
  • -;-

  • Venue:
  • SSDBM '99 Proceedings of the 11th International Conference on Scientific and Statistical Database Management
  • Year:
  • 1999

Quantified Score

Hi-index 0.00

Visualization

Abstract

Many of the publicly available biomedical data sources -- such as Genbank and SwissProt -- are not stored in traditional databases but in a variety of file formats (e.g. ASN.1 and EMBL). The data is complex, involving deeply nested structures. While query languages for such data have been well-studied, the issue of updating such databases has not. The need for a concise update language is critical since the changes to the data are typically very small when compared to the entire value.Starting with a query language called Collection Programming Language (CPL), we describe an extension called CPL+ which provides an intuitive framework for updates on complex values. We illustrate the language using examples and present various optimization that can substantially improve the performance of complex updates.