Harnessing The Potential of Open-Source Database Platform and Related Web Technologies for Managing Seed Inventory of Cereals Germplasm Collection
Rodolfo C. Camaclang III1*, Sancho G. Bon2, Aldrin Joseph J. Hao1, and Juan Paolo D. Banares2
1Institute of Computer Science, College of Arts and Sciences, University of the Philippines Los Baños (UPLB), Los Baños, 4031 Laguna, Philippines; 2Institute of Crop Science, College of Agriculture and Food Science, UPLB, Los Baños, 4031 Laguna, Philippines. *Corresponding author, rccamaclang1@up.edu.ph

Abstract

Philippine Cereals Genetic Resources Information Database (PCGRID) exemplifies that industry-class germplasm documentation and inventory system can be developed and implemented using open-source database system platforms and web technologies such as PostgreSQL and the Yii framework. These open-source resources perform well with off-theshelf retail consumer market hardware configurations and commercial domain hosting and cloud services. The PCGRID has shown that rapid access, better-quality information, effective data filtration; improved data integrity and streamlined and integrated data management is a better forward option for seed inventory management and germplasm documentation, in general. Online implementation and administration further improve functionality and value of the system. Data can be accessed and retrieved, appended, and reviewed anytime, anywhere where internet services are available. Online administration, however, involve operational costs such as subscription to services providers or as additional server load to the institution’s in-house systems facilities or acquisition and installation of hardware systems and internet subscription. Moreover, a dedicated systems administrator is necessary for keeping the database system updated, continuing systems design and features improvement, and to rectify bugs and crashes.

Keywords: Germplasm conservation, germplasm database, germplasm seed inventory, online, PGR
documentation, postgresql, SQL, Yii framework