The SQLite version of GPMDB was created to allow for the
creation of simple, portable versions of individual GPM result
files. GPM result files are written in XML: the SQLite
version of these files contains the same information
as the GPMDB entry associated with that file, as well as the
peak lists from the file (which is not normally stored in GPMDB).
The table structure and columns were kept as similar to GPMDB
as possible. Data types were converted to the simpler set
of types available in SQLite. All primary keys were set to
be auto-incremented. Two tables that are in GPMDB (Path and ProteinRevision)
were removed, as they have no role in a single file database. The
Spectrum table was added, to record the peak list information
associated with each identification.
The prefered extension for files in this format is ".gpmdb"
to distinguish them from other files generated using SQLite. A Perl
script for generating these files, an example GPM XML file and its
corresponding .gpmdb file are available
here.
|