Harnessing The Potential of Open-Source Database Platform and Related Web Technologies for Managing Seed Inventory of Cereals Germplasm Collection

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-the-shelf 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.