Technical Overview, mem acc nums table

The mem_acc_nums table in the peakdb database is used to generate the MRM displays for protein and peptide information in GPMDB.

The main difference between this table and the other tables that make up the GPM is that it is a memory table; the contents of this table reside in the database server's memory, to increase the response time for queries involving these tables.

The contents of this table are updated manually, when new source data files are generated.

Columns:

• rowid: the unique identifier for a row of data.
• pepid: the unique identifier for a specific peptide. A single peptide may have more than one row in this table.
• label: the protein accession number to which this peptide applies.
• pos: the 1-based position of this peptide within the protein identified by the label.