JP2006146656A - Farming guidance support system - Google Patents

Abstract

Agricultural / pest database data can be referred even in an area where communication with a mobile phone is impossible.
In a computer center 10, a DB server 11 receives JPP net data 100 and creates a prefecture DB 13. In the JA headquarter 20, the headquarter server 21 downloads the data of the prefecture DB13 and creates the JA headquarters DB23. Then, the download terminal 25 creates the PDA DB 27 from the JA home DB 23 and downloads it to the PDA 29.
In the JA branch 30, the download terminal 35 downloads the JA headquarters DB 23 to create a JA branch DB 33, and further creates a PDA DB 37 from the JA branch DB 33. The PDA DB 37 is downloaded to the PDA 39. The farming instructor brings the PDA 39 to the farm field 70 and performs farming guidance while searching the PDA DB 391 by the PDA 39.
[Selection] Figure 2

Description

  The present invention relates to a farming guidance support system that supports technical guidance of a farming instructor.

  In JA (whole farming), technical guidance is given by the farming instructor on the agricultural production and management of the members. The main duties of farming instructors are agricultural technical patrol guidance. Farming instructors give guidance on farming while referring to pesticide information and pest information.

  Regarding the use standards of agricultural chemicals, the Ministry of Agriculture, Forestry and Fisheries has determined the amount of spraying and the number of spraying based on the Agricultural Chemicals Control Law. For this reason, knowledge about agricultural chemicals is indispensable for technical guidance in agricultural production, and agricultural instructors absorb knowledge of agricultural chemicals while referring to several thick books related to agricultural chemicals. Farming instructors go to the farm and give technical guidance to the members, but there are many pesticide-related books that are thick and heavy, so it is inconvenient to bring to the farm, and the farming instructor brings them to the farm. That was rare. For this reason, agricultural instructors are currently providing technical guidance based on knowledge gained from past experiences, not pesticide-related books.

  However, recently, services for providing pesticide information via the Internet have been provided, and these services are being used as alternatives to pesticide-related books. There are currently two forms of pesticide information providing services via the Internet, one using a personal computer (PC) website and the other using a mobile phone website.

  In addition, as a prior art related to the present invention, the data for soil management is measured by a sensor installed on the farmland, and the measurement data is transmitted to the data management center via the mobile communication network and the public line network, This measurement data is registered in the farmland-specific measurement database in the data management center, and the decision support software creates farmland optimization proposals based on the farmland-specific measurement database, weather observation database, farmer-specific personal database, and regional database. However, there is an agrochemical business support system that provides the proposal information from the homepage of the data management center (Patent Document 1).

  Pest control support that has multiple individual specialized databases, and if the terms are synonymous even if the notation is different, related information can be searched from multiple individual specialized databases based on the terms using data mining technology There is also a database system (Patent Document 2).

However, these prior arts do not consider the regulation of agricultural chemicals (in the case of Patent Document 1), and do not consider updating the database or providing information outside the communication service area (in the case of Patent Document 2).
JP 2002-215717 A JP 2001-142888 A

  When technical guidance was provided without bringing agrochemical-related books, there were cases in which the application of prohibited agricultural chemicals was instructed due to lack of knowledge. In this case, there was a case where the product developed into a serious problem, for example, it was necessary to dispose of the product, resulting in damage to the members.

  In addition, when using the service via the Internet, there are many cases where the farm is located outside the communication service area of the mobile phone or the PHS, so that it cannot be used on the field.

  An object of the present invention is to provide a system in which a farming instructor can use farming guidance information such as the latest agricultural chemical information and pest information on a field site.

  The farming guidance support system according to the present invention includes a host system having a first database in which data on farming guidance is registered, and a second system that is updated based on the data of the first database held by the host system. A farming guidance support system having a first subordinate system that holds a database of

  In the farming guidance support system according to the first aspect of the present invention, the host system includes a first acquisition unit that acquires the latest farming guidance data via a network, and the farming guidance acquired by the first acquisition unit. First update means for updating the first database based on data, wherein the first lower system acquires second database data from the higher system. And a second updating means for updating the second database based on the data obtained by the second obtaining means, and a third database for the portable terminal is created from the second database. And a first creating means.

The second acquisition unit of the first lower system acquires the data of the first database from the higher system via, for example, a network.
The first creation means creates the third database by, for example, an interactive format with a user.

  The farming guidance support system according to the second aspect of the present invention is the farming guidance support system according to the first aspect, wherein the first subordinate system transmits the third database created by the first creation means to the portable terminal. It further has a transmission means to perform.

  The farming guidance support system according to a third aspect of the present invention is the farming guidance support system according to the first aspect, wherein the upper system notifies the first lower system of update information of the first database. And a first creation unit of the first lower system refers to the update information when receiving the update information from the upper system, and stores the second database as necessary. It is characterized by updating.

  The farming guidance support system according to a fourth aspect of the present invention is the farming guidance support system according to the first aspect, wherein the first lower system is connected to a second lower system via a network, The lower system is acquired by a fourth database in which data relating to farming guidance is registered, a third acquisition unit that acquires data of the second database from the first lower system, and the third acquisition unit. A third updating unit for updating the fourth database based on the data obtained, and a second creating unit for creating a fifth database for a portable terminal from the fourth database. It is characterized by.

The third acquisition unit of the second lower system acquires data of the first database from the first lower system via, for example, a network.
The farming guidance support system according to a fifth aspect of the present invention is the farming guidance support system according to the fourth aspect, in which the upper system updates the update information of the first database, the first lower system and the second lower system. The system further comprises second notifying means for notifying the system.

The second creation means creates the fifth database by, for example, an interactive format with a user.
The farming guidance support system according to a sixth aspect of the present invention is the farming guidance support system according to the fourth aspect, wherein the upper system notifies the first and second lower systems of update information of the first database. 2 notification means, and the second update means of the first lower system updates the second database when receiving the update information from the higher system, and When the update information is received from the higher system, the third update means of the system refers to the update information and updates the fourth database as necessary.

  According to the present invention, the farming instructor can check the latest farming guidance data while searching the database mounted on the mobile terminal on the farm field, so that appropriate technical guidance can be performed on the farm field. In addition, it is possible to create a database for a mobile terminal in which farming guidance data is registered in accordance with the actual situation of the area that each farming instructor is in charge of. Furthermore, since a database for farming guidance is installed in the mobile terminal, it is possible to refer to the latest farming guidance data even in a field that cannot be communicated by a mobile communication terminal such as a mobile phone.

Hereinafter, embodiments of the present invention will be described with reference to the drawings.
[Example 1]
FIG. 1 is an overall hardware configuration diagram of a farming guidance support system which is an embodiment to which the present invention is applied.

This system is, for example, a computer network system of JA in a certain prefecture.
The computer center 10 is a data center provided in all JA farms in a certain prefecture, and manages and operates the computer system of the JA headquarters in that prefecture and the JA branch in each region.

The computer center 10 includes a database server 11 (hereinafter referred to as a DB server 11) and a prefecture database 13 (hereinafter referred to as a prefecture DB 13), and is connected to the Internet 60.
The computer center 10 is provided with a Web server (not shown), and this Web server is connected to the Internet 60. An application server (not shown) is also provided, and the DB server 11 is configured to be connected to the Internet 60 via an application server and a Web server.

  The Web server has a function of downloading the latest agricultural chemical / pest database stored in JPP-NET via the Internet. When the pesticide and pest database held by JPP-NET is updated, JPP-NET notifies the Web server by e-mail to that effect.

  When the Web server receives the database update notification mail, the Web server accesses the JPP-NET and downloads the latest agrochemical / pest database from the JPP-NET.

Here, JPP-NET will be described.
JPP-NET is a membership network operated by the Japan Plant Protection Association, and provides the latest information on pest control of agricultural crops in a database.

  The agrochemical / pest database downloaded by the Web server is sent to the DB server 11 via the application server. The DB server 11 overwrites the sent agricultural chemical / disease / pest database in the prefecture DB 13 and updates the contents of the agricultural chemical / disease database stored in the prefecture DB 13.

In addition, the application server and the DB server 11 cooperate to create a difference (update information) between the previous agricultural chemical / pest database and the current (latest) agricultural chemical / pest database.
The computer center 10 is connected to the JA head office 20 via the network 40. The network 40 is, for example, the Internet, a prefecture LAN, a JA LAN, or the like.

The JA head office 20 includes a home server 21, a JA home DB 23, a download terminal 25, a PDA database 27 (hereinafter, PDA DB 27), and a PDA 29.
When the home server 21 receives an e-mail notifying the update of the pesticide / pest database from the Web server of the computer center 10, it downloads the latest database stored in the prefecture DB 13 of the computer center 10 and stores the JA home DB 23. Update. The same database as the agrochemical / pest database stored in the prefecture DB 13 is stored in the JA head office DB 23.

  The download terminal 25 is connected to the JA home DB 23 via the home server 21. The user operates the download terminal 25 to create the PDA DB 27 from the JA home DB 23. The PDA DB 27 is a database created by extracting only the data required by the user from the agrochemical / pest database stored in the JA main DB 23. The download terminal 25 provides a GUI (Graphical User Interface) for facilitating the creation of the PDA DB 27 for the user.

  The PDA 29 is a personal information terminal (Personal Digital Assistant), and a database stored in the PDA DB 27 is stored in a device by wired communication / wireless communication such as USB (Universal Serial Bus) or infrared communication. Or an external storage medium that can be attached to the main body of the device.

  The JA branch 30 is connected to the JA head office 20 via the network 50. The network 50 is, for example, the Internet, a JA LAN, a prefecture LAN (such as a wide area Ethernet), or the like. The network 40 and the network 50 may be the same network.

The JA branch 30 includes a download terminal 35, a JA branch DB 33, a PDA DB 37, and a PDA 39.
The download terminal 35 downloads the database stored in the JA headquarters DB 23 while communicating with the headquarters server 21 of the JA headquarters 20 via the network 50, and overwrites it in the JA branch DB 33. Update the pesticide / pest database stored in the JA branch DB 33. Also, the PDA DB 37 is created in the same manner as the download terminal 25 of the JA head office 20.

  The PDA 39 has the same function as the PDA 29 of the JA headquarters 20. The pesticide / disease database created in the PDA DB 37 by the download terminal 35 is stored in its own device by wired / wireless communication such as USB or infrared communication. To other storage devices or storage devices that can be attached to the device itself.

  FIG. 2 is a functional block diagram showing the software configuration of the farming guidance support system having the hardware configuration of FIG. The functions of the processing units shown in FIG. 2 are realized by a CPU (Central Processing Unit) of a server or terminal executing the program stored in a memory, storage, or the like.

  The DB server 11 of the computer center 10 includes a data acquisition processing unit 111. The data fetch processing unit 111 fetches the latest agricultural chemical / pest database data 100 (hereinafter, JPP net data 100) from JPP-NET via the Internet (not shown).

  In the present embodiment, the JPP net data 100 is recorded in CSV (Comma Separate Value), and includes the data of the agent outline 101, the application condition 102, and the active ingredient 103. Each of these data is composed of a plurality of records.

  The agent summary 101 is summary data regarding one agrochemical. The application condition 102 is data defining the usage method, the number of times of use, the dilution rate, and the like of crops, pests and weeds to which the agricultural chemicals can be applied. The active ingredient 103 is data regarding the active ingredient contained in the pesticide, and when the pesticide is a mixture, there are a plurality of records.

  3, 4, and 5 are diagrams showing the format of one record of the agent outline 101, the application condition 102, and the active ingredient 103, respectively. As shown in FIGS. 3 to 5, each record of the agent outline 101, application condition 102, and active ingredient 103 is linked by an item “registration number”.

The data capture processing unit 111 creates the prefecture DB 13 based on the JPP net data 100.
FIG. 6 is a diagram illustrating a data structure of the prefecture DB 13. From the data of the agent summary 101, each table of the agrochemical master 130, the agrochemical classification master 131, the pest control reference master 132, the pest control master 133, the pesticide characteristic information 134, the pesticide component master 135, the applicable pest information 136, and the component use frequency information 137 (File) is created. The prefecture DB 13 is processed by collecting only information used in the prefecture, adding prefecture-specific know-how, or deleting unnecessary data.

  The head office server 21 of the JA head office 20 includes a data fetch processing unit 211. This data acquisition processing unit 211 accesses the DB server 11 of the computer center 10 via the network 40, downloads data from the prefecture DB 13, and copies it to the JA headquarters DB 23.

The download terminal 25 of the JA head office 20 includes a data capture processing unit 251, a PDA DB creation processing unit 252, and a USB transfer processing unit 253.
The data fetch processing unit 251 reads a table set in an initial setting file (described later) from the JA home DB 23. The PDA DB creation processing unit 252 creates the PDA DB 27 by extracting data instructed by the user from the fetched table. The USB transfer processing unit 253 transmits the PDA DB 27 to the PDA 29 in response to a request from the PDA 29. This transmission is performed with a user interface processing unit 293 (described later) of the PDA 29. FIG. 7 is a functional block diagram of the main part of the PDA 29 according to the present invention.

  The PDA 29 includes a PDA DB 291, a USB communication processing unit 292, and a user interface processing unit 293. The user interface processing unit 293 includes a use standard search processing unit 293A, a mixed case dilution calculation processing unit 293B, a residual standard search processing unit 293C, and an agrochemical information search processing unit 293D.

  The USB communication processing unit 292 performs data communication processing based on the USB standard with the USB transfer processing unit 253 of the download terminal 25 and receives the PDA DB 27 from the download terminal 25. The PDA DB 27 is stored and saved in the storage device in the apparatus as the PDA DB 291 in the PDA 29. The user interface processing unit 293 refers to the PDA DB 291 and provides each function of “use standard search”, “mixed case dilution calculation”, “residual standard search”, and “pesticidal information search” to the user. The “use criteria search”, “mixed case dilution calculation”, “residual criteria search”, and “pesticidal information search” functions are the use criteria search processing unit 293A, the mixed case dilution calculation processing unit 293B, and the residual criteria search processing, respectively. This is realized by executing the unit 293C and the agricultural chemical information search processing unit 293D. These functions are provided by an interactive GUI via a screen display.

  2 illustrates an example in which the PDA DB 27 is downloaded from the download terminal 25 to the PDA 29 by USB communication. However, the download may be performed by wireless communication such as infrared communication or Bluetooth. . The same applies to transmission / reception of the PDA DB 37 between the download terminal 35 of the JA branch 30 and the PDA 39, which will be described later.

  The download terminal 35 of the JA branch 30 has the same configuration and function as the download terminal 25 of the JA head office 20, and includes a data capture processing unit 351, a PDA DB creation processing unit 352, and a USB transfer processing unit 353. .

  The data fetching processing unit 351 fetches the JA headquarters DB 23 of the JA headquarter 20 via the network 50 and copies it to the JA branch DB33. The PDA DB creation processing unit 352 processes the JA branch DB 33 by the same process as the PDA DB creation processing unit 252 to create the PDA DB 37. The creation of the PDA DB 37 is performed in an interactive form using a GUI. The PDA DB 37 is downloaded from the download terminal 35 to the PDA 39 by the USB transfer processing unit 353. This download is executed in the same manner as in the JA head office 20 described above.

  The PDA 39 is a portable terminal having the same hardware and software configuration as the PDA 29 of the JA headquarters 20, and stores the PDA DB 391 in an internal storage device or a mountable external storage device.

  The farming instructor of the JA branch 30 brings the PDA 39 when visiting the farm 70 to conduct farming guidance, searches the PDA DB 391 while using the PDA 39 in the farm 70, and searches for “usage criteria search”, “mixed cases”. Provide appropriate farming guidance to union members while performing “dilution calculation”, “residue criteria search”, “pesticidal information search”, etc. Although not clearly shown in FIG. 2, the farming instructor at JA Headquarters 20 uses the PDA 29 in the same manner as the PDA 39 to provide farming guidance to the union members on the field.

[Processing of Computer Center]
FIG. 8 is a flowchart for explaining the processing of the DB server 11.

First, the latest JPP net data 100 (all cases) is downloaded via the Internet 60 (step S11). Next, it connects with prefecture DB13 (step S12).
Connection to the prefecture DB 13 is performed by transmitting a regular user name and password input from an input device (not shown) to a DBMS (Database Management System) of the prefecture DB 13. The same applies to the following DB connections.

Subsequent to step S12, the processes of steps S13 to S19 are performed in a predetermined order for all the tables registered in the prefecture DB 13.
In step S13, the latest data downloaded in step S11 is edited into the registration format of the table in the prefecture DB 13. In this editing, “item rearrangement” and “character string editing” are mainly performed. In “sort items”, the latest data is sorted by crop. In the “character string editing”, an initial is taken from a crop reading and obtained as a search character.

  Subsequently, data (previous data) is read from the table of the prefecture DB 13 (step S14), and the latest data is compared with the previous data (step S15). If it is determined that the data has been updated (step S16, YES), the process proceeds to step S17. On the other hand, if it is determined that the data has not been updated, the process proceeds to step S18.

In step S17, the update information is written in a difference table (not shown). This difference table is provided, for example, in a work area of the memory.
Subsequently, the table in the prefecture DB 13 is rewritten with the latest data (step S18). Then, it is determined whether there is an unprocessed (remaining) table (step S19). If there is an unprocessed table, the process returns to step S13.

In this way, all the tables in the prefecture DB 13 are updated with the latest data, and the update information is stored in the difference table.
If it is determined in step S19 that the processing has been completed for all the tables in the prefecture DB 13, the prefecture DB 13 is disconnected (step S20), and the update information stored in the difference table is sent to the JA head office 20 and the JA branch 30 by e-mail. Transmit (step S21), and the process ends.

FIG. 9 is a diagram showing an example of a data structure of update information distributed by the electronic mail.
As shown in FIG. 5A, the update information 400 is composed of four items of update information “No.”, “update date”, “update category”, and “update content”, and data of these items. Each type is a text type. “No.” is a 5-digit serial number starting from “00001”. “Update date” is a number indicating year (YYYY) / month (MM) / day (DD). There are two types of “update category”: new registration or item change, and there are three types of item change: “add”, “change”, or “delete”. In the “update content”, specific update content is described. FIG. 5B shows a specific example of the update information 400 when a new pesticide is registered.

[JA head office processing]
FIG. 10 is a diagram for explaining the update process of the JA headquarters DB 23 of the JA headquarter 20. The processing shown in this flowchart is performed by the data fetch processing unit 211 of the main server 21.

  Upon receiving the e-mail notifying the update information from the DB server 11 of the computer center 10, the head office server 21 refers to the update information and checks whether the data in the table related to the JA home DB 23 has been updated. If it has been updated, the processing shown in the flowchart of FIG.

  In this process, first, the prefecture DB 13 is connected (step S31), and then the JA head office DB 23 is connected (step S32). Then, the data is copied from the prefecture DB 13 to the JA home DB 23 (step S33). Subsequently, after the JA head office DB 23 is cut (step S34), the prefecture DB 13 is cut (step S35), and the process is terminated.

As described above, the data in the JA home DB 23 is updated to the latest data.
FIG. 11 is a flowchart for explaining the PDA DB 27 creation process of the download terminal 25 of the JA head office 20. The processing shown in this flowchart is performed by the data capture processing unit 251 and the PDA DB creation processing unit 252 of the download terminal 25.

First, the PDA DB creation processing unit 252 displays a download selection screen (step S41).
This download selection screen is a screen for inputting extraction conditions for data to be downloaded from the JA home DB 23 to the PDA DB 291. The extraction conditions include “item selection”, “agricultural classification selection”, “agrochemical information selection”, and “residual reference information selection”.

  Next, the user inputs extraction conditions for data to be downloaded on the screen (step S42). Subsequently, the PDA DB creation processing unit 252 determines whether an extraction condition is input in step S42 (step S43). If the extraction condition is input, the process proceeds to step S44, and the extraction condition must be input. If the process ends, the process ends.

In step S44, the table name set in the initial setting file is read.
FIG. 12 is a diagram showing an example of the contents of the initial setting file.
The initial setting file 500 shown in FIG. 1-No. 24 table names up to 24 are registered. The tables having these table names are tables that constitute the JA home DB 23.

  Next, the PDA DB creation processing unit 252 connects to the JA home DB 23 (step S45), and then connects to the PDA DB 27 (step S46). Thereafter, the data acquisition processing unit 251 and the PDA DB creation processing unit 252 cooperate to repeat the processing of steps S47 to S49 as many times as necessary (equal to the number of tables registered in the initial setting file). The PDA DB 27 is created.

  In steps S47 to S49, data is extracted from the JA home DB 23 using the extraction condition input in step S42 as a key (step S48), and the extracted data is written in the PDA DB 27 (step S49). Is repeated until it is determined in step S47 that the processing in steps S48 and S49 has been completed for all the registration tables of the initial setting file. If it is determined in step S47 that there is no unprocessed table name (table), the process proceeds to step S50.

Then, the data fetch processing unit 251 disconnects the PDA DB 27 in step S50, then disconnects the JA home DB 23 (step S51), and ends the process.
As described above, the PDA DB 27 is created from the JA home DB 23 based on the table name registered in the initial setting file.

FIG. 13 schematically shows the flow of processing in the flowchart of FIG.
As shown in FIG. 13, the PDA DB creation processing unit 252 takes in data selected via the download selection screen 600 from the JA home DB 23 and creates the PDA DB 27.

FIG. 14 is a diagram illustrating an example of a process for creating the PDA DB 27 from the JA home DB 23.
A part of the JA home DB 23 is shown on the left side of the figure. Here, an applicable pest information table 231 and an agrochemical information table 233 linked to the agrochemical item “Actala Granule 5” registered in the table 231 are shown. In this example, only “lettuce” is extracted as the “item name” from the applicable pest information table 231 to create the applicable pest information table 271 of the PDA DB 27. Further, only “Aktara Granule 5” is extracted from the pesticide information table 233 as the “pesticide name”, and the pesticide information table 273 of the PDA DB 27 is created.

[Processing of JA branch]
FIG. 15 is a flowchart for explaining the processing of the data capture processing unit 351 of the download terminal 35. In this process, the JA head office DB 23 of the JA head office 20 is downloaded to the JA branch DB 33.

  First, the head office server 21 of the JA head office 20 is accessed via the network 50 and connected to the JA branch DB 33 (step S61). Next, the connection is made to the JA branch DB 33 (step S62), and the data of the JA branch DB 23 is copied to the JA branch DB 33 (step S63).

Then, the JA home DB 23 is disconnected through the home server 21 (step S64), and then the JA branch DB 33 is disconnected (step S65), and the process is terminated.
Through the above processing, the contents of the JA branch DB 33 are updated to the latest data.

  FIG. 16 is a flowchart for explaining a PDA DB 37 creation process performed by the PDA DB creation processing unit 352. Since the processing performed in this flowchart is the same as the processing in the flowchart of FIG. 11 described above, detailed description thereof is omitted. In this processing, the user can create a desired PDA DB 37 in the download terminal 35 in an interactive manner via a GUI screen displayed on the display of the download terminal 35.

  FIG. 17 shows the contents of the initial setting file referred to in step S74 of the flowchart of FIG. The initial setting file 700 shown in FIG. 15 is the same as the initial setting file 500 of FIG. 12, but it is not necessarily the same.

  FIG. 18 is a diagram for explaining processing executed by the USB transfer processing unit 353. In this process, the PDA DB 37 generated in the download terminal 35 is downloaded to the PDA 39.

  First, the PDA DB download screen is displayed on the display (not shown) of the download terminal 35 (step S91). On this screen, a “download button” for instructing to download the PDA DB 37 from the download terminal 35 to the PDA 39 is displayed.

  When the user presses the download button by clicking the mouse or the like (step S92), it is determined whether the download terminal 35 and the PDA 39 are connected so as to be able to perform data communication via USB or the like (step S93).

If it is determined that the download terminal 35 and the PDA 39 are not connected, a warning message is displayed on the screen to prompt the user to connect.
Following this warning, the user connects the download terminal 35 and the PDA 39 so that they can communicate with each other (step S94).

  When the process of step S94 ends, the process returns to step S93, and it is determined again whether the download terminal 35 and the PDA 39 are connected so as to be communicable. If the connection is normal, the PDA DB 37 generated in the download terminal 35 is downloaded to the PDA 39 (step S95), and the process ends.

In this way, the PDA DB 391 (the same database as the PDA DB 37) is downloaded and stored in the storage device of the PDA 39.
FIG. 19 is a diagram illustrating the flow until the PDA DB 29 is created in the first embodiment, with the database as a main component. Here, the flow of processing until the PDA DB 27 is created at the JA head office 20 is shown.

  The computer center 10 takes the JPP net data 100 from the JPP net data DB 1000 and creates the prefecture DB 13. The JA head office 20 creates a JA head office DB 23 by copying the data of the prefecture DB 13. Then, with reference to the initial setting file 500, a necessary table is extracted from the JA home DB 23, and a PDA DB 27 including the extracted table is created.

[Example 2]
FIG. 20 is an overall system configuration diagram of the farming guidance support system according to the second embodiment.
In the figure, the same reference numerals are assigned to the same components as those of the first embodiment shown in FIG.
In the second embodiment, maintenance terminals 1101 and 1201 are provided at the computer center 10 and the JA headquarter 20, respectively. The maintenance terminal 1101 of the computer center 10 includes a “data addition function”, a “data maintenance function”, a “maintenance information mail function”, and the like. The data addition function is a function for adding data such as know-how regarding “pesticidal properties”, “mixed cases”, “residual standard”, “holding standard” and the like to the prefecture DB 13. The data maintenance function is a function for maintaining the data of “various masters” and data on “pesticidal information” registered in the prefecture DB 13 in the latest data. The maintenance information mail function is a function for distributing information related to the maintenance performed by the maintenance terminal 1101 by mail.

  The maintenance terminal 1201 of the JA head office 20 has a “data maintenance function” and a “maintenance information mail function”. These functions are the same as the functions provided in the maintenance terminal 1101 of the computer center 10 except that the target database is changed from the prefecture DB 13 to the JA head office DB 23.

  By the way, in the above embodiment, database data exchange between the computer center 10 and the JA head office 20 and between the JA head office 20 and the JA branch 30 is performed online using network communication. The database may be recorded on a portable storage medium such as -R, and the database may be exchanged offline by distributing the portable storage medium.

  The present invention can create a database of pesticides and pests suitable for the climate and environment of each region, as well as the soil characteristics of the fields, etc., and can be used around the world because it can be stored on a mobile terminal and carried by farming instructors. Extremely versatile.

It is a hardware block diagram of the farming guidance support system of Example 1. It is a software block diagram of the farming guidance assistance system of Example 1. FIG. It is a figure which shows the data content of an agent outline | summary. It is a figure which shows the data content of application conditions. It is a figure which shows the data content of an active ingredient. It is a figure which shows the data structure of prefecture DB. It is a functional block diagram of the principal part concerning PDA of this invention. It is a flowchart explaining the process of DB server. (A) is a figure which shows the data structure of update information, (b) is a figure which shows the content of the update information at the time of new pesticide registration. It is a flowchart explaining the process which the data acquisition process part of the JA main office server performs. It is a flowchart explaining the process which the DB creation process part for PDA of the download terminal of JA head office performs. It is a figure which shows the content of the initialization file used in JA head office. It is an outline figure of processing which creates DB for DBA from DB for JA headquarters via a download selection screen. It is a figure which shows the specific example of the process by which DB for DBA is produced from DB for JA headquarters. It is a flowchart explaining the process of the data taking-in process part of the download terminal in JA branch. It is a flowchart explaining the process of the DB creation process part for PDA in JA branch. It is a figure which shows the content of the initialization file used in JA branch. It is a figure explaining the process which the user interface process part of the download terminal of JA branch performs. FIG. 5 is a schematic diagram illustrating a flow of processing until a DB for DBA is created from JPP net data in the first embodiment. It is a figure which shows the hardware constitutions of the farming guidance assistance system of Example 2. FIG.

Explanation of symbols

10 computer center 11 DB server 111 data acquisition processing part 13 prefecture DB
20 JA headquarters 21 headquarters server 211 Data import processing unit 23 JA headquarters DB
231 Applicable pest information table 233 Pesticide information table 25 Download terminal 251 Data acquisition processing unit 252 PDA DB creation processing unit 253 USB transfer processing unit 27 PDA DB
271 Applicable pest information table 273 Pesticide information table 29 PDA
291 DB for PDA
292 USB communication processing unit 293 User interface processing unit 293A Usage standard search processing unit 293B Mixed case dilution calculation processing unit 293C Residual standard search processing unit 293D Pesticide information search processing unit 30 JA branch 33 DB for DB of JA branch
35 Download terminal 351 Data acquisition processing unit 352 PDA DB creation processing unit 353 USB transfer processing unit 37 PDA DB
39 PDA
391 DB for PDA
40, 50 Network 60 Internet 70 Field 100 JPP Net Data 101 Drug Overview 102 Application Condition 103 Active Ingredient 130 Pesticide Master 131 Pesticide Classification Master 132 Pest Control Standard Master 133 Pest Pest Standard Master 134 Pesticide Property Information 135 Pesticide Component Master 136 Applicable Pest Information 137 Component Use count information 400 Update information 401 Update information 500 when registering new pesticides Initial setting file (for JA headquarters)
600 Download selection screen 700 Initial setting file (for JA branch)
1000 JPP Net Database 1101 Maintenance terminal (Computer Center)
1201 Maintenance terminal (JA head office)

Claims (10)

A first subordinate system that has a first database in which data related to farming management is registered and a second database that is updated based on the data in the first database that the upper system possesses A farming guidance support system having a system,
The host system is
A first acquisition means for acquiring the latest farming guidance data via a network;
First update means for updating the first database based on farming guidance data acquired by the first acquisition means;
The first sub-system is:
Second acquisition means for acquiring data of the first database from the host system;
Second update means for updating the second database based on the data acquired by the second acquisition means;
First creation means for creating a third database for mobile terminals from the second database;
A farming guidance support system characterized by comprising A farming guidance support system according to claim 1,
The first sub-system is:
Transmitting means for transmitting the third database created by the first creating means to the mobile terminal;
It is further provided with the feature. A farming guidance support system according to claim 1,
The second acquisition unit of the first lower system acquires data of the first database from the upper system via a network. A farming guidance support system according to claim 1,
The first creation means creates the third database in a dialog format with a user. A farming guidance support system according to claim 1,
The host system is
First notification means for notifying the first lower system of update information of the first database,
The first creation unit of the first lower system refers to the update information when the update information is received from the higher system, and updates the second database as necessary. To do. A farming guidance support system according to claim 1,
The first subordinate system is connected to a second subordinate system via a network;
The second subsystem is
A fourth database in which data on farming guidance are registered;
Third acquisition means for acquiring data of the second database from the first lower system;
Third update means for updating the fourth database based on the data acquired by the third acquisition means;
Second creation means for creating a fifth database for portable terminals from the fourth database;
A farming guidance support system characterized by comprising A farming guidance support system according to claim 6,
The third acquisition unit of the second lower system acquires data of the first database from the first lower system via a network. A farming guidance support system according to claim 6,
The host system is
Second notification means for notifying update information of the first database to the first lower system and the second lower system;
Furthermore, it is characterized by comprising. A farming guidance support system according to claim 6,
The second creation means creates the fifth database in an interactive format with a user. A farming guidance support system according to claim 6,
The host system is
A second notification means for notifying the first and second lower systems of update information of the first database;
The second update unit of the first lower system updates the second database when receiving the update information from the upper system,
The third updating unit of the second lower system, when receiving the update information from the upper system, refers to the update information and updates the fourth database as necessary. To do.