Abstract
Since many plant diseases have been investigated by many plant pathologists in Japan, a lot of available data for those pathogens, routes of infection, methods of protection, etc. are accumulated for the research results of plant diseases. Then, it is necessary to accumulate and file those data systematically to develop the database system for diagnosis of plant diseases, identification of causal pathogens and plant diseases protection. Twenty three kinds of major crops, i.e., rice, barley, wheat, tomato and so on, were selected as the target for the database. The data of 807 kinds of bacterial, fungal and viral diseases of these crops were also collected. Informix, the commercial database management system, and Wingz, the commercial spreadsheets software, were adopted to develop the database system and user interface. Each software was provided by ASCII Co. Ltd. in Japan. Informix-SQL and Informix-ESQL/C were used to describe the database. The database has the following functions: a) To retrieve the disease name, symptoms of disease, methods of protection and route of infection by using host name, pathogen name or keywords. b) To retrieve the disease name, symptoms of disease, methods of protection and route of infection by using characteristic data of pathogen. c) To refer the photographs of plant diseases.
