Figure 1.

Database design. Schematic of flow of data, storage points, access points and interface processing (A–K). PADMA administrator retrieves processed data files (A and B) and manually formats them (C) into PADMA Data File (D). PADMA administrator downloads Affymetrix^® (E) and FlyBase (F) annotation files to update PADMA metadata registry. PADMA Data File, along with Affymetrix^® and FlyBase annotation files, are uploaded through Apache/PHP data loader (G) and processed within Oracle XE framework (H). PADMA users retrieve housed data (I) by specifying search criteria, and either view it on screen (J) or export as CSV files (K). Exported files can be opened in MS Excel^® or other data processing applications for further analysis (L).