JP2006012137A - Database apparatus - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To distribute recipe information and an exercise program to a person who desires provision of information aiming at distribution of the exercise program and the recipe information which suit individual condition of disease and life aspect. <P>SOLUTION: This database apparatus 1 is constituted of a WEB server 4, a DB server 5, a recipe information DB 6 and an exercise program DB 7 and connected to a network such as the Internet. A client computer which requests the recipe information and the exercise program transmits retrieval conditions of the recipe information to the WEB server and requests distribution of recipe/exercise programs. The WEB server 4 retrieves the recipe information/exercise program stored in the DB server 5 based on the retrieval conditions obtained from the client computer 2 and returns a retrieval result to the client computer 2. When new recipe information is added to the database apparatus 1, a client computer 3 on the network transmits the new recipe information to the WEB server 4 of the database apparatus and the WEB server 4 registers the new recipe information in the DB server 5. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to a technique for distributing recipe information and an exercise program adapted to specific information of an information provider.

  In general hospitals with a large number of hospitalized beds, medical treatment recipe information is stored in a database of a computer system unique to the general hospital in order to determine a menu for medical treatment to be provided to hospitalized patients. An administrative dietitian working at a general hospital records the recipe information in the medical system database of the general hospital's computer system to determine the menu of medical meals to be provided to hospitalized patients at the general hospital. It is possible to search and use the recipe information.

  On the other hand, there are few cases where a registered dietitian who creates a menu for recuperation meals is working at a doctor who has few hospitalized beds, such as a clinic or clinic, and there are cases where a computer system like a general hospital is introduced. rare.

  Due to the medical division of labor system started in 2003, patients with chronic diseases such as lifestyle-related diseases represented by diabetes have to receive medical care at a doctor in charge such as a doctor's office or clinic.

  Lifestyle-related diseases, such as diabetes, require dietary improvement guidance through medical diets, and are not available at clinics and clinics that do not have medical diet recipe information suitable for the patient's height, weight, age, sex, occupation, and medical condition. , I was unable to give guidance on how to improve meals with optimal medical treatment.

  However, in order to obtain optimal medical recipe information at small clinics and clinics, it is costly to hire a registered dietitian and store medical recipes in the database of the computer system unique to the clinic or clinic. Have difficulty.

  In addition, it is easy to reduce the waiting time for medical examinations at clinics and clinics and to provide more examination time when instructing patients with chronic illnesses to improve their meals based on medical diet recipes. It is essential to obtain medical treatment recipe information in a simple operation and in a short time.

  Furthermore, lifestyle-related diseases are also associated with daily exercise. In order to improve lifestyle diseases and promote health, it is necessary to improve not only diet but also exercise. In order to provide an exercise program, it is not sufficient to determine the amount of exercise necessary from physical data such as the individual's weight and height. Conditions such as individual occupational form, area of residence, time of exercise, and orientation to exercise must also be considered.

  Therefore, an object of the present invention is to distribute an exercise program and recipe information suitable for an individual's medical condition and lifestyle.

  An object of the present invention is to distribute recipe information to a user who requests provision of recipe information suitable for health, such as a nursery school, a school, a health facility for the elderly, a lunch center, and a side dish shop.

  An object of the present invention is to distribute an exercise program to a user who seeks to provide an exercise program suitable for health, such as a fitness club or a school.

  According to the present invention, the recipe information to be distributed and the exercise program are stored in the database device connected to the Internet network. The database apparatus according to the present invention has a function of searching for recipe information and exercise programs stored in the database apparatus and transmitting the recipe information and exercise programs through the Internet network.

  According to the present invention, when a request signal is sent from the client computer for program request to the database apparatus of the present invention together with the stored recipe information and information for retrieving the exercise program, the request signal is stored in the database. The recipe information and exercise program are retrieved from the information for retrieving the recipe information and exercise program obtained from the program requesting client computer, and the corresponding recipe information is processed into a format for display on the program requesting client computer. Can be sent.

  The database apparatus of the present invention can be connected to a large number of program requesting client computers that are qualified to connect. The database apparatus according to the present invention has means for authenticating whether or not the connected program requesting client computer has a connection qualification.

  The database device of the present invention has means for permitting connection of a recipe registration client computer for registering the latest recipe information in the database device and registering the latest recipe information transmitted from the recipe registration client computer. . The latest recipe information transmitted from the recipe registration client computer is stored in the database device.

  According to the present invention, it is not necessary to store a large amount of recipe information and exercise programs on the side of many program requesting client computers. In addition, recipe information can be obtained in a simple operation and in a short time without having a means for retrieving recipes and exercise programs on the client computer for program request side. Furthermore, by adding the latest recipe information and exercise program to the database apparatus of the present invention, the latest recipe information and exercise program can be provided to the connected program requesting client computer.

  A program distribution system to which the present invention is applied will be described with reference to FIG. The program distribution system 100 includes a database device 1 that distributes recipe information and an exercise program, a client computer 2 that requests recipe information and an exercise program (an example of a client computer for requesting a program), and a client computer 3 that registers recipe information (recipe registration) An example of a client computer.

  The client computer 2 that requests recipe information is provided in a place where health-conscious recipe information is required, such as a doctor's office, kindergarten, nursery school, geriatric health facility, pharmacy, restaurant, sports club, and private home. The client computer 2 for registering recipe information is provided in a place where a specialist such as a registered dietitian can provide recipe information in consideration of health.

  The database device 1 includes a WEB server 4 (an example of a communication server) and a DB server 5. The database device 1 is connected to a network such as the Internet network.

  The WEB server 4 includes a screen transmission function for transmitting a screen to the client computer 2 that requests recipe information / exercise program and a client computer 3 that registers new recipe information, the client computer 2 that requests recipe information / exercise program, and new recipe information. Search function according to the search condition requested by the client computer 2 requesting the recipe function / exercise program and changing the search result to a format that can be displayed on the client computer 2 A search function for transmission and a recipe addition function for adding new recipe information sent from the client computer 3 for registering a new recipe to the DB server 5 are provided.

  The DB server 5 stores recipe information / exercise programs, and searches for recipe information stored in the recipe information DB 6 and exercise programs stored in the exercise program DB 7 in accordance with a search request from the WEB server 4. , Reply to the WEB server 4 and record the number of times the stored recipe information / exercise program is searched.

  The client computer 2 that requests recipe information / exercise program connected to the database apparatus 1 and the client computer 3 that registers new recipe information have a common interface for displaying information transmitted by the WEB server 4 of the database apparatus 1. . With this interface, it is possible to display a screen based on a markup language represented by HTML or the like standardized by W3C (World Wide WEB Consortium).

  FIG. 2 shows a sequence related to signal transmission / reception between the database apparatus 1 to which the present invention is applied and a client computer 2 that requests recipe information connected to the database apparatus 1. All transmission / reception is performed via a network such as the Internet.

  The client computer 2 that requests recipe information to be connected to the database device 1 first makes a connection request to the database device 1 of the present invention. In this case, a connection request is made from the client computer 2 to the WEB server 4 of the database device 1 in a format such as https: // domain name of the database device 1 / login.aspx (signal 1 in FIG. 2).

  When receiving a connection request from the client computer 2 that requests recipe information, the WEB server 4 of the database apparatus 1 transmits authentication information input screen information to the client computer 2. This information is described in a standardized format such as an HTML format (signal 2 in FIG. 2). The client computer 2 that has received the authentication information input screen information displays an authentication information input screen for inputting authentication information such as an ID and a password on an application that can display a standardized format such as an HTML format.

  FIG. 3 is an example of an authentication information input screen. The client computer 2 requesting the recipe information transmits authentication information including the ID and password input on the authentication information input screen as shown in FIG. 3 to the database device 1 (signal 3 in FIG. 2).

  The WEB server 4 of the database apparatus 1 that has received the authentication information from the client computer 2 that requests the recipe information / exercise program verifies whether the received authentication information including the ID and password is valid, and the valid authentication information is Only when it is sent, the search condition input screen information is transmitted to the client computer 2 (signal 4 in FIG. 2). Search condition input screen information is also described in a standardized format such as an HTML format. In the client computer 2 that has received this search condition input screen information, a search condition input screen for inputting the search conditions for recipes and exercise programs is displayed on an application that can display a standardized format such as HTML format. .

  FIG. 4 is an example of a search condition input screen. When a search condition is input on the search condition input screen as shown in FIG. 4, the client computer 2 transmits a program request signal with the search condition input on the search condition input screen to the database device 1 (FIG. 4). 2 signal 5).

  The WEB server 4 receives a recipe request signal from the client computer 2 that requests the recipe information / exercise program. The WEB server 4 instructs to search for recipes satisfying the search condition from the recipe information stored in the DB server 5 using, for example, an SQL sentence standardized by ISO (International Organization for Standardization). The recipe search / exercise program search algorithm will be described later. The DB server 5 transmits the search result based on the SQL instruction to the WEB server 4. This search result is recipe information including a combination of menus for one meal, ingredients for each menu, and a cooking method. The WEB server 4 transmits program information display screen information, which is the search result of the recipe information and exercise program, to the client computer 2. This information is also transmitted in a standardized format such as HTML (signal 6 in FIG. 2).

  FIG. 5 is an example of a program information display screen. On the program information display screen shown in FIG. 5, a combination of menus including staple food, main dish, side dish 1 and side dish 2 is displayed. A check box for selecting whether to display detailed information corresponding to each combination is displayed. The user of the client computer 2 can select a favorite recipe from a plurality of recipes and display detailed information such as ingredients, cooking methods, and the like. FIG. 6 is an example of a detailed information display screen. On the detailed information display screen, the names of dishes to be staple foods, main dishes, side dishes 1 and side dishes 2, ingredients of each dish, and cooking methods are displayed.

  Next, the registration process of new recipe information will be described with reference to FIG. FIG. 7 shows a sequence related to signal transmission / reception between the database apparatus 1 and the client computer 3 that registers new recipe information in the database apparatus 1. Communication between the database apparatus 1 and the client computer 3 is via a network such as the Internet.

  The client computer 3 that registers new recipe information first makes a connection request to the database device 1. The client computer 3 issues a connection request to the WEB server 4 of the database apparatus 1 in the form of https: // domain name of the database apparatus 1 of the present invention / login.aspx (signal 1 in FIG. 7). ).

  When receiving a connection request from the client computer 3 for registering new recipe information, the WEB server 4 of the database apparatus 1 transmits authentication information input screen information to the client computer 3. This information is transmitted in a standardized format such as an HTML format (signal 2 in FIG. 7). Upon receiving this authentication information, the client computer 3 displays an authentication information input screen for inputting authentication information such as an ID and password on an application that can display a standardized format such as the HTML format. This authentication information input screen has substantially the same configuration as that illustrated in FIG.

  The client computer 3 that registers the new recipe information transmits authentication information including the ID and password input on the authentication information input screen to the database device 1 (signal 3 in FIG. 7).

  The WEB server 4 of the database apparatus 1 that has received the authentication information from the client computer 3 that registers the new recipe information verifies whether the received authentication information including the ID and password is valid, and the valid authentication information is sent. Only when it arrives, the recipe input screen information is transmitted to the client computer 3 (signal 4 in FIG. 7). This information is transmitted by the WEB server 4 of the database apparatus 1 in a standardized format such as an HTML format. The client computer 3 that has received the search condition input screen information displays a recipe input screen for inputting a recipe search condition on an application that can display a standardized format such as HTML. FIG. 8 is an example of a recipe input screen.

  The client computer 3 that registers the new recipe information transmits the recipe information input on the recipe input screen to the database device 1 (signal 5 in FIG. 7).

  The WEB server 4 of the database apparatus 1 that has received the recipe information from the client computer 3 that registers the new recipe information instructs the DB server 5 of the database apparatus 1 to insert a new recipe by, for example, an SQL statement. Upon receiving the SQL statement, the DB server 5 adds new recipe information to the recipe information DB. The WEB server 4 of the database apparatus 1 sends an insertion instruction to the DB server 5 and then transmits a registration completion notification screen for notifying that the registration is completed to the client computer 3 in a standardized format such as HTML (FIG. 7). Signal 6). FIG. 9 is an example of a registration completion notification screen. In the registration completion notification screen shown in FIG. 9, a text for notifying that the registration of the recipe has been completed and a command button for selecting the end of the registration completion screen are provided.

  An embodiment of a recipe distribution system 200 to which the present invention is applied will be described with reference to FIG. The recipe distribution system 200 searches the database apparatus 10 that distributes recipes, the clinic client computer 20 (an example of a recipe request client computer) provided in the clinic where the patient visits, and the clinic client computer 20. An order receiving client computer 30 for an ingredient / food delivery company for inputting details of a recipe and a recipe registration client computer 40 (an example of a recipe registration computer) for registering a new recipe are provided.

  The database device 10 includes a WEB server 11, a DB server 12, and a recipe information DB 13. The database device 10 is connected to a network such as the Internet network.

  The WEB server 11 has an operation screen that is used when the client computer 20 for the clinic, the client computer 30 for ordering, and the client computer 40 for registering new recipe information by the contract management dietitians nationwide use the database apparatus of the present invention. When a recipe request is sent together with a search condition from a function to be transmitted to each client computer 20, 30, 40, clinic client computer 20 or order client computer 30, the recipe information stored in DB server 12 is It has a function of changing to a format that can be displayed on the client computers 20, 30 and transmitting it, and a function of adding new recipe information sent from the client computer 40 for registration of contract management dietitians nationwide to the DB server 12.

  The DB server 12 includes a recipe information DB 13 for storing recipe information, searches for recipe information stored in the recipe information DB 13 in accordance with a search request from the WEB server 11, and returns a response to the WEB server 11. It has a function of counting the number of times a certain piece of recipe information stored in the recipe information DB 13 is retrieved.

  Both the client computer for clinic 20 and the client computer for ordering 30 have a common interface for displaying the WEB page received from the WEB server 11 of the database apparatus 10. An example of this interface is a WEB browser. The interface displays an image based on a markup language represented by HTML standardized by W3C (World Wide WEB Consortium).

  The clinic client computer 20 includes a patient information DB 21. When a patient visits a clinic that can receive medical meal recipe information, the patient information DB 21 on the clinic side stores the patient ID, name, address, height, weight, age, sex, medical history, activity intensity, cooking difficulty, etc. Information is registered for each patient.

  When a doctor gives a patient a meal improvement instruction based on a medical diet recipe, the clinic client computer 20 receives medical diet recipe information from the database device 10 using information in the patient information DB 21. FIG. 11 shows a sequence related to signal transmission / reception between the database apparatus 10 and the clinic client computer 20. Transmission / reception is performed via a network such as the Internet.

  The clinic client computer 20 makes a connection request to the database device 10. In this case, a connection request is made from the clinic client computer 20 to the WEB server 11 of the database apparatus 10 in a format such as https: // domain name of the database apparatus 10 / login.aspx (signal 1 in FIG. 11). .

  When receiving a connection request from the clinic client computer 20, the WEB server 11 of the database apparatus 10 transmits an authentication information input screen to the clinic client computer 20. This information is described in a standardized format such as an HTML format (signal 2 in FIG. 11). The clinic client computer 20 that has received the authentication information input screen displays an authentication information input screen for inputting authentication information such as a clinic ID and a password on the browser.

  FIG. 12 is an example of an authentication information input screen. The clinic client computer 20 transmits the authentication information including the clinic ID and password input on the authentication information input screen as shown in FIG. 12 to the database device 10 (signal 3 in FIG. 11).

  The WEB server 11 of the database apparatus 10 that has received the authentication information from the clinic client computer 20 verifies whether the received authentication information including the clinic ID and password is valid, and when valid authentication information is sent. Only the patient information input screen information is transmitted to the clinic client computer 20 (signal 4 in FIG. 11). Patient information input screen information is also described in a standardized format such as an HTML format. Upon receipt of the patient information input screen information, the clinic client computer 20 inputs patient information such as patient ID, residential area, height, weight, age, sex, illness, occupation (activity intensity), cooking difficulty, etc. on the browser. The patient information input screen is displayed.

  FIG. 13 is an example of a patient information input screen. The patient information input screen shown in FIG. 13 is provided with an input area for inputting a patient ID, residential area, height, weight, age, sex, medical history, activity intensity, and cooking difficulty level. The activity intensity, which is the input content of the patient information input screen, means the degree of activity in the patient's life. In the patient information input screen of FIG. 13, items of rest, light (desk work, etc.), medium, heavy (manual labor, etc.) are displayed in order of increasing activity intensity. The user selects his / her activity intensity from these items. The cooking difficulty level means the cooking difficulty level of a recipe to be searched. As the cooking difficulty level, items of simple, normal, and complicated are displayed in ascending order of difficulty. The cooking difficulty level is selected according to the time and labor required for cooking by the patient.

  The client computer 20 for clinics transmits the patient information input on the patient information input screen as shown in FIG. 13 and the medical food recipe request signal to the database device 10 (5 in FIG. 11).

  When a recipe request signal accompanied by patient information is received from the client computer 20 for the clinic, the WEB server 11 of the database apparatus 10 uses, for example, an SQL statement standardized by ISO (International Organization for Standardization) to use the database apparatus 10. Instructed to retrieve the requested medical recipe information from the medical recipe information stored in the DB server 12.

  Next, a procedure in which the WEB server 11 searches for a medical meal recipe from the DB server 12 will be described.

  The recipe information DB 13 in the DB server 12 is a relational database and has five tables: a recipe table, a color information table, a material table, a repellent table, and a cooking difficulty level table. 14 to 18 are configuration examples of each table stored in the recipe information DB 13.

  FIG. 14 is an example of a recipe table. The recipe table is a table for storing information related to cooking. The recipe table includes eight items: recipe ID, recipe name, type, calorie, salt content, lipid, Japanese-Western Chinese, and cooking method storage destination. The item of recipe ID stores a key code that is uniquely assigned to each recipe. The type item stores three types of staple foods such as bread and rice, main dishes mainly made of protein, and side dishes based on vitamins and minerals. The item of Japanese and Western stores the genre of cooking. Ethnics may be added to the genre of cooking in addition to Japanese, Western and Chinese. The item in Japanese and Western expresses which cooking genre has a strong characteristic. For example, when the Japanese characteristic is strong, the sum is stored. In the search process, a combination of recipes with strong Japanese special features and recipes with strong western and medium features is avoided. The item “cooking method storage location” indicates a storage location of a text file in which a detailed cooking method related to the recipe is entered.

  FIG. 15 is an example of a color information table. The color information table stores color information of each recipe. The color information relates to the color of the food material. For example, the color of curry is yellow and the color of green salad is green. In the search process, recipes are combined so that five colors of red, white, yellow, green, and black are included.

  FIG. 16 is an example of a material table. The ingredient table stores information on ingredients necessary for the recipe. The material table includes four items of recipe ID, material, region, and season. In the material item, information on the material and amount required for the recipe is stored. In the item of region, the region name is preserved when the material includes materials that are usually difficult to obtain except for a specific region. A blank (NULL) is preserved if any region is composed solely of normally available materials. In the item of season, the name of the season is stored when the material includes materials that are usually difficult to obtain except for a specific season. In any season, a blank (NULL) is preserved if it is composed solely of normally available materials.

  FIG. 17 is an example of a repelling table. The repellent table includes three items: a recipe ID, a repellent name, and a rank. In the item of repellent disease name, a disease name that avoids the recipe is stored. The rank item stores the degree to which the recipe should be avoided. The rank is from 1 to 5. The lowest rank is 1, and the higher the number, the higher the degree that must be avoided.

  FIG. 18 is an example of a cooking difficulty level table. The cooking difficulty level table stores information on the difficulty level of cooking of the stored recipe. The rank is from 1 to 3. The rank indicates that 1 is the lowest and can be easily cooked, 2 indicates that the difficulty of cooking is normal, and 3 indicates the highest and the cooking is complicated.

  When the WEB server 11 receives the patient information and the medical recipe request signal from the medical client 20, the web server 11 searches for medical recipe information suitable for the patient. A procedure for retrieving medical meal recipe information will be described with reference to FIGS. 19 to 22.

  FIG. 19 shows a main routine of a medical meal recipe search process. As the initial processing of the main routine, calculate the calorie range (eg, 700 to 750 calories), lipids, and salinity necessary for the menu to be provided from the patient's height, weight, age, sex, illness, and occupation (activity intensity). (Step S11).

  Next, the DB server 12 calls the main meal routine, the main dish routine, and the side dish routine, and creates the main dish table, the main dish table, and the side dish table. The staple food routine, the main dish routine, and the side dish routine are processes in which a recipe that is difficult for the patient to cook and a recipe for avoiding the patient are removed from the recipe table. In this embodiment, the recipe that should be avoided depending on the medical condition of the patient is excluded by using a material that is difficult to cook and is difficult for the patient to obtain depending on the season and region (step S12).

  In the example of executing the staple food routine using SQL, as shown in FIG. 20, the DB server 12 that has received the SQL statement from the WEB server 11 uses the SQL SELECT statement to create the recipe table in FIG. A recipe having a type of staple food in the WHERE clause is searched from the cooking difficulty table of FIG. 18, and a recipe that includes difficult-to-obtain ingredients depending on the patient's residence area and season, and a recipe that is higher than the cooking difficulty specified by the patient The intermediate table 1 is created (step S31). The DB server 12 sorts from the intermediate table 1 and the repellent table of FIG. 17 using the ORDER BY clause in the descending order of the repellent rank according to the SELECT statement of SQL. Only the recipes up to are extracted and a staple food table is created (step S32).

  In the example of executing the main dish routine using SQL, as shown in FIG. 21, the DB server 12 that has received the SQL statement from the WEB server 11 uses the SQL SELECT statement to execute the recipe table in FIG. 14 and the material in FIG. The table and the cooking difficulty table of FIG. 18 are searched for the main dishes in the WHERE clause, and the recipe including the difficult-to-obtain ingredients depending on the patient's residence area and season, and the cooking difficulty specified by the patient The intermediate table 2 excluding higher recipes is created (step S41). The DB server 12 sorts from the intermediate table 2 and the repellent table of FIG. 17 using the ORDER BY clause in the order of the repellent rank in descending order according to the SELECT statement of SQL. Only the recipes up to the above are extracted and a main dish table is created (step S42).

  In the example of executing the side dish routine using SQL, as shown in FIG. 22, the DB server 12 that has received the SQL statement from the WEB server 11 uses the SQL SELECT statement to execute the recipe table in FIG. 14 and the material in FIG. The table and the cooking difficulty table of FIG. 18 are searched for items with the type of side dish in the WHERE clause, and the recipe containing the difficult-to-obtain ingredients depending on the patient's residence area and season, and the cooking difficulty specified by the patient An intermediate table 3 excluding higher recipes is created (step S51). The DB server 12 sorts from the intermediate table 3 and the repellent table of FIG. 17 using the ORDER BY clause in the descending order of the repellent rank according to the SELECT statement of SQL. Only the recipes up to the above are extracted and a side dish table is created (step S52). The staple food table, the main dish table, and the side dish table created by SQL are VIEW, which is a virtual table.

  The DB server 12 creates a menu table, which is a virtual table for storing items of one staple food, one main dish, and one or more side dishes (step S13). The menu table created in step S13 is an empty virtual table in which nothing is stored. The DB server 12 stores recipes extracted from the staple food table, the main dish table, and the side dish table in empty items of the menu table, and creates a temporary menu in the menu table column. Then, the temporary menu is compared with the search condition. When the temporary menu does not satisfy the predetermined condition, the DB server 12 deletes an item that does not satisfy the condition or a column that does not satisfy the condition. By repeating this process, a menu table consisting of only menus that satisfy all the conditions is finally completed. The menu table creation process will be described below.

  In step S14 to step S21, a temporary combination of staple food, main dish, and side dish is created, only the combination within the calorie range suitable for the patient is held in the menu table, and the combination outside the calorie range is discarded. The DB server 12 takes out one recipe from the staple food table and stores it in the staple food item in the editing column of the menu table (step 14). Next, the DB server 12 takes out one recipe from the main dish table and stores it in the editing column (step S15). The DB server 12 checks whether the total calorie amount of the recipe in the editing column is equal to or greater than the calorie range necessary for the menu provided to the patient. At this point, if the calorie range is equal to or greater than the required calorie range (step S16; YES), the extracted main dish information is discarded (step S17), and the process proceeds to step S15.

  If the total amount of calories in the editing column that stores the recipe for staple food and main dish is less than the required calorie range (step S16; NO), one recipe is taken out from the side dish table and stored in the menu table. (Step S18). Check whether the total calorie content of the staple food, main dish, and first side dish is within the calorie range required for the menu provided to the patient. At this point, if the necessary calorie range has been exceeded (step S19; YES), the recipe for the side dish selected here is discarded (step S21), and the process proceeds to step S18 to transfer the next side dish from the side dish table. Take one vegetable and store it in the editing column of the menu. On the other hand, if it is less than the necessary calorie range in step S19, the column being edited is stored in the menu table as one completed menu.

  Check whether the total calorie content of the staple food, main dish and first side dish is within the calorie range necessary for the menu provided to the patient. If it is less than the range (step S19; NO), the recipe is prepared from the side dish table. Take one and store it in the menu. There may be multiple side dishes. Check if the total calories in the editing column, including the added side dishes, is within the required calorie range for the menu provided to the patient. Discard the recipe, take one next side dish from the side table, and store it in the editing column of the menu table. The total calorie content of the row containing the new side dishes is also checked to see if it is within the calorie range required for the menu to be provided to the patient, and if it is within the range, the column being edited is displayed as a complete menu in the menu table. Store.

  Next, the DB server 12 searches whether all recipes in the main dish table have been extracted. If there is a recipe that has not yet been extracted from the main dish table (step S21; NO), the process proceeds to step S15. One of the main dishes that have not yet been selected for the menu is stored in the menu table.

  On the other hand, if all recipes in the main dish table have been extracted (step 21; YES), it is searched whether all recipes in the main table have been extracted (step S22), and the recipes that have not yet been extracted. Is present (step S22; NO), the process proceeds to step S14, and one of the recipes not yet taken out is taken out from the staple food table and stored in the menu table.

  When all recipes of the staple food table have been taken out in step S22 (step S22; YES), a menu table in which the staple food, the main dish, and the side dish are combined so as to be within the calorie range suitable for the patient is completed.

  Next, the DB server 12 calculates the total amount of lipid and salt for all columns of the menu table, and deletes the column if the limit value is exceeded (step S23). Furthermore, when the recipe of a different genre is combined with the column of the menu table from the menu table and the recipe table, the DB server deletes the column. The different genres mean that the staple food is Japanese, the main dish is Western, the side dish is Chinese, etc., and the genre is not unified (step S24). Further, a menu including a large number of colors is extracted from the menu table and the color table of FIG. 15 (step S25). When executing the process of step S24 using SQL, the SQL statement is sorted using the ORDER BY clause in the order in which the five colors are included according to the SELECT statement of SQL. Extract only the menu until.

  FIG. 23 shows an example of a menu table that is a virtual table that has been sorted in step S25. The menu table includes items of recipe ID of staple food, recipe ID of main dish, recipe ID of side dish 1, recipe ID of side dish 2, and recipe ID of side dish 3.

  The WEB server 11 creates medical meal recipe information based on the information stored in the menu table, converts it into a format that can be displayed on the client computer that requests the medical recipe information, and transmits it to the clinic client computer 20. (Step S26). FIG. 24 shows an example of a medical diet list display screen displayed on the clinic client computer 20.

  In the medical treatment list display screen of FIG. 24, the names of recipes to be staple food, main dish, side dish 1, side dish 2, and side dish 3 are displayed in a horizontal row. This horizontal combination of recipes is a menu. A check box for selecting whether or not to display the details of the menu is provided along with the display area of each menu. A command button for instructing detailed display of the selected menu is provided below the menu display area. Further, below the command button, text describing “Display next 5 items” is displayed. When this text is selected, the next list of medical meal list display screens is displayed.

  The doctor can select the patient's favorite recipe from the menu displayed on the medical treatment list display screen, display it on the detailed information screen such as ingredients and cooking methods, and print it on the printer 22. Detailed information which is a printing result is illustrated in FIG.

  In the detailed information, the patient ID, menu ID, the amount of rice as a staple food, the ingredients of curry as a main dish, the cooking method, the amount of tangerine as a side dish, the total calories of the menu, the mass of salt, the mass of lipid Is displayed.

  The exchange between the clinic client computer 20 and the database device 10 when printing detailed information will be described. When the doctor performs an operation to display detailed information on the screen of the medical treatment list display screen of FIG. 24, the clinic selection information indicating the selected medical treatment recipe is displayed as the medical treatment list information. The client computer 20 transmits to the WEB server 11 of the database apparatus 10 (signal 7 in FIG. 11). The WEB server 11 of the database device 10 is an ID code that is uniquely assigned to a combination of the selected recipe ID, patient ID, disease name, and selected date in the recipe information DB 13 of the DB server 12. The menu ID and the detailed recipe information created from the recipe table in FIG. 14 and the ingredient table in FIG. 16 are transmitted to the clinic client computer 20 (signal 8 in FIG. 11). In the clinic client computer 20 that has received the menu ID and the detailed recipe information, the information is displayed as a detailed information screen, and the content of the detailed information screen is printed by the printer 22.

  On the other hand, when receiving the recipe selection information (signal 7 in FIG. 11) sent from the clinic client computer 20, the database device 10 receives the selected recipe ID, patient ID, and the like in the recipe information DB 13 of the DB server 12. Information on the selected recipe is recorded in the menu selection table and the menu configuration table that store the menu name that is the ID code uniquely assigned to the combination of the disease name and the selected date. Here, the menu ID is the same as the menu ID displayed on the detailed information screen of FIG. FIG. 26 shows an example of the menu selection table, and FIG. 27 shows an example of the menu configuration table.

  The menu selection table of FIG. 26 includes items of menu ID, patient ID, disease name, and selection date, and stores information indicating which patient of which medical condition has selected which menu on what day. . The menu configuration table of FIG. 27 includes items of menu ID and recipe ID, and stores information about which recipe is included in the selected menu ID.

  By managing the information of the selected recipe according to the menu selection table of FIG. 26 and the menu configuration table of FIG. 27, the recipe that is popular among patients with a certain medical condition is investigated, or the recipe that is not popular is searched. The cause can be investigated and utilized as information for creating a new recipe, or the same recipe can not be provided to a patient for a certain period of time. Further, as will be described later, the order receiving client computer 30 that requests medical diet recipe information can also be used when searching issued recipe information.

  Next, a procedure for registering new recipe information by connecting the registration client computer 40 to the database device 10 by a contract management dietitian nationwide will be described. FIG. 28 shows a sequence related to transmission / reception of signals between the database apparatus 10 and the registration client computer 40 for registering new recipe information. Transmission / reception is performed via a network such as the Internet.

  When contract management dietitians nationwide register new recipe information in the database device 10 of the present invention, the registration client computer 40 that registers new recipe information first makes a connection request to the database device 10 of the present invention. This is because a connection request is made from the registration client computer 40 to the WEB server 11 of the database apparatus 10 in the form of https: // domain name of the database apparatus 10 of the present invention / login2.aspx (FIG. 28). Signal 1).

  When receiving a connection request from the registration client computer 40 that registers new recipe information, the WEB server 11 of the database apparatus 10 transmits authentication information input screen information to the registration client computer 40. This information is described in a standardized format such as an HTML format (signal 2 in FIG. 28). Upon receiving the authentication information input screen information, the registration client computer 40 displays an authentication information input screen for inputting authentication information such as a registered dietitian ID and password on the browser.

  FIG. 29 is an example of an authentication information input screen. The registration client computer 40 for registering new recipe information inputs authentication information composed of a registered dietitian ID and password information to the authentication information input screen as shown in FIG. 29 and transmits it to the database device 10 (FIG. 28). 3).

  The WEB server 11 of the database apparatus 10 that has received the authentication information from the registration client computer 40 for registering new recipe information verifies whether the received authentication information including the registered dietitian ID and password is valid, and authenticates the authentication. Only when the information is sent, the registered medical meal recipe search screen information is transmitted to the registration client computer 40 (signal 4 in FIG. 28). Registered medical food recipe search screen information is also described in a standardized format such as HTML format. The registration client computer 40 that has received the registered medical treatment recipe information displays a registered medical treatment recipe search screen for inputting a recipe name or a part of the recipe name on the browser.

  FIG. 30 is an example of a registered medical meal search. In the registered medical treatment search shown in FIG. 30, an input area for inputting a recipe name or a part of the recipe name and a command button for instructing a recipe search are provided.

  The registration client computer 40 for registering new recipe information transmits a recipe name search request signal including a recipe name or a part of the recipe name, which is input on the registered recipe recipe screen, to the database device 10 (see FIG. 28 signals 5).

  When the WEB server 11 of the database apparatus 10 receives the medical treatment recipe search request signal from the registration client computer 40 for registering new recipe information, the search condition among the recipe information stored in the recipe information DB 13 of the DB server 12 The registered recipe including a part of the recipe name given as is retrieved, and the recipe information that matches the condition is extracted. The WEB server 11 transmits recipe retrieval result screen information obtained by converting the retrieved registered recipe into a standardized format such as HTML to the registration client computer 40 (signal 6 in FIG. 28). Upon receiving the recipe search result screen information, the registration client computer 40 displays a recipe search result screen that displays a registered recipe including a recipe name designated as a search condition or a part of the recipe name.

  FIG. 31 is an example of a recipe search result screen. In the recipe search result screen shown in FIG. 31, text indicating the number of search results “5 recipes containing“ curry ”in the recipe name”, the name of the registered recipe, the recipe Is displayed. A check box for selecting whether or not to display the details of the recipe along with the recipe name is provided. Below the recipe name, a command button for displaying a detailed screen of the selected recipe and a command button for displaying an input screen of a new recipe are provided.

  Based on the detailed information of the recipe, the registered dietitian can check whether or not a duplicated recipe to be newly registered is registered. FIG. 32 is an example of a detailed information screen. The detailed information screen shown in FIG. 32 displays the recipe name, type, material, cooking method, nutritional value, color, repellent name, cooking difficulty level, and the like. Nutritional value includes calories, salinity, lipids and the like. The rank is displayed along with the name of the disease. The rank indicates the degree to which the recipe should be avoided.

  Based on the recipe search result screen and the detailed information, the user confirms with the database device 10 a recipe that overlaps with a recipe to be newly registered. When a command button for displaying a new recipe input screen is selected, the registration client computer 40 transmits a medical food recipe registration request signal to the WEB server 11 of the database apparatus 10 (signal 7 in FIG. 28). When the WEB server 11 of the database apparatus 10 receives the medical recipe registration request signal from the registration client computer 40 for registering new recipe information, the medical recipe registration screen is registered in a standardized format such as HTML format. 40 (signal 8 in FIG. 28).

  FIG. 33 is an example of a medical food recipe registration screen. The medical treatment recipe registration screen shown in FIG. 33 inputs an input area for inputting a recipe name, a selection button for selecting a type, an input area for inputting a material, an input area for inputting a cooking method, and a nutritional value. An input area, an input area for inputting a color, an input area for inputting a repellent name and rank, a selection button for selecting a cooking difficulty level, and a command button for instructing registration of the input recipe are provided.

  Registered dietitians across the country fill in the recipe information registration screen for new recipes. The registration client computer 40 transmits a medical food recipe registration request signal with the entered new recipe information to the WEB server 11 of the database device 10 (signal 9 in FIG. 28).

  When the WEB server 11 of the database apparatus 10 receives the medical treatment recipe registration request signal from the registration client computer 40 for registering new recipe information, the recipe table, color table, material table, and repellent table of the recipe information DB 13 of the DB server 12 The new recipe information is registered in each table of the cooking difficulty level table. When registering new recipe information, the WEB server 11 outputs, for example, an SQL INSERT statement and adds the new recipe information to the DB server 12.

  After inserting the new recipe information into the DB server 12, the WEB server 11 of the database apparatus 10 transmits a registration completion screen notifying that the registration is completed to the registration client computer 40 in a standardized format such as an HTML format. (Signal 10 in FIG. 28). FIG. 9 is an example of a registration completion screen.

  Next, the process in which the order receiving client computer 30 for the food / food delivery company reads the detailed information of the menu from the database device 10 will be described. The patient receives medical treatment recipes and diet improvement instructions from a doctor in the clinic. By notifying the menu ID of the recipe table delivered from the doctor, the patient can order the ingredients of the recipe delivered from the doctor or the meal according to the recipe from the meal / food delivery company.

  A description will be given of a procedure in which a meal / food supplier who has received an order for food / food from a patient by connecting a client computer 30 for ordering to the database apparatus 10 and obtains recipe information of food / food. FIG. 34 shows a sequence related to transmission / reception of signals between the database apparatus 10 and the order-receiving client computer 30 that acquires the recipe information of the lunch / food ingredients. Transmission / reception is performed via a network such as the Internet.

  When the lunch / delivery company connects the order receiving client computer 30 to the database apparatus 10 and acquires the recipe information of the lunch / ingredient, the order receiving client computer 30 that acquires the recipe information of the lunch / ingredient first starts with the database. A connection request is made to the WEB server 11 of the apparatus 10. This is because the client computer 30 for ordering receives a connection request to the WEB server 11 function of the database device 10 in the form of https: // domain name of the database device 10 / login3.aspx (signal 1 in FIG. 34). ).

  The WEB server 11 of the database apparatus 10 transmits authentication information input screen information to the order receiving client computer 30 when receiving a connection request from the order receiving client computer 30 for acquiring recipe information of food / food ingredients. This information is transmitted in a standardized format such as the HTML format (signal 2 in FIG. 34). The order receiving client computer 30 that has received the authentication information input screen information displays an authentication information input screen for inputting authentication information such as an ID and a password on the browser.

  FIG. 35 is an example of an authentication information input screen. The order-receiving client computer 30 that acquires the recipe information of the lunch / ingredient transmits the authentication information, which is input on the authentication information input screen and includes the lunch / food provider ID information and the password information, to the database device 10.

  The WEB server 11 that has received the authentication information from the order receiving client computer 30 that acquires the recipe information of the lunch / food ingredients verifies whether the authentication information including the meal / food provider ID and password is valid, and is valid. Only when the authentication information is sent, recipe search condition input screen information is transmitted to the order receiving client computer 30 (signal 4 in FIG. 34). Recipe search input screen information is also transmitted in a standardized format such as HTML format. The order receiving client computer 30 that has received the recipe search condition input screen information displays a recipe search condition input screen for inputting menu ID information notified from the patient on the browser. FIG. 36 is an example of a recipe search condition input screen. The recipe search condition input screen of FIG. 36 is provided with an input area for inputting a menu ID and a command button for instructing transmission of the input menu ID.

  The lunch / food material distributor inputs the menu ID notified from the patient to the recipe search condition input screen. The order-receiving client computer 30 that acquires lunch / food recipe information transmits a medical meal recipe request with a menu ID input as a search condition on the search condition input screen to the database device 10 (signal 5 in FIG. 34). .

  The WEB server 11 of the database apparatus 10 that has received the medical treatment recipe request signal with the menu ID that is the search condition from the order receiving client computer 30 that acquires the recipe information of the lunch / food ingredients, for example, by the SQL SELECT statement And instructing the user to search for a recipe corresponding to the recipe ID from the recipes stored in the DB server 12 of the database device 10.

  The WEB server 11 of the database apparatus 10 acquires a required recipe ID from the menu selection table of FIG. 26 and the menu configuration table of FIG. 27 based on the menu ID received from the order receiving client computer 30, and the recipe ID 14 and the material table of FIG. 16 constitute recipe information, and a recipe information screen is transmitted to the order receiving client computer 30 in a standardized format such as HTML (signal 6 of FIG. 34). FIG. 37 is an example of a recipe information screen. The recipe information screen in FIG. 37 displays a menu ID, ingredients, and cooking method.

  The business operator delivering the lunch / food ingredients delivers the meal / food ingredients designated by the patient on the recipe information screen displayed on the browser of the order-receiving client computer 30 that acquires the recipe information of the lunch food ingredients.

  In the present embodiment, the manner in which the recipe is distributed to a small-scale home clinic that does not employ a registered dietitian is illustrated. According to the present invention, recipe information can be distributed by a similar method to a place where distribution of health-conscious recipe information is required, such as a kindergarten, a nursery school, a geriatric health facility, and a private house. Alternatively, a system may be used in which culinary meals are delivered to a cram school or overtime meals are delivered to a company that works overtime until late at night.

  Next, an example of a program distribution system 300 for distributing an exercise program will be described with reference to the drawings. The program distribution system 300 proposes a recipe and an exercise program that are entangled, and provides support from both nutrition and exercise using a network. Since the recipe search function of the program distribution system 300 has already been described in the first embodiment, a detailed description thereof will be omitted. In addition, the same reference numerals are given to programs having the same function.

  FIG. 38 is a block diagram showing the configuration of the program distribution system 300. The program distribution system 300 includes a database device 60 that distributes exercise programs and recipes, a clinic client computer 20 (an example of a program request computer) provided in a clinic with which a patient communicates, and a clinic client computer 20. An ordering client computer 30 for inputting the details of the retrieved recipe, a registration client computer 40 for registering a new recipe, and a patient client computer 50 for inputting the achievement level of the exercise program are provided.

  The database device 60 includes a WEB server 61, a DB server 62, a recipe information DB 63, and an exercise program information DB. The database device 60 is connected to a network such as the Internet network.

  The WEB server 61 transmits an operation screen to be used when the clinic client computer 20, the order receiving client computer 30, and the national contract management dietitian register new recipe information and the registered client computer uses the database device 60 of the present invention. When the recipe request is sent together with the search condition from the function, the clinic client computer or the order client computer 30, the recipe information / exercise program stored in the DB server 62 can be displayed on each client computer. It has a function of changing and transmitting, and a function of adding to the DB server 62 new recipe information sent from a client computer to a contract management dietitian nationwide.

  The DB server 62 includes a recipe information DB 63 that stores recipe information and an exercise program DB 64 that stores an exercise program, and stores the recipe information stored in the recipe information DB 63 and the exercise program DB 64 in accordance with a search request from the WEB server 61. A function for searching the exercise program and replying to the WEB server 61, and a function for counting the number of times the recipe information stored in the recipe information DB 63 is searched.

  Both the clinic client computer 20 and the order receiving client computer have a common interface for displaying a WEB page received from the WEB server 61 of the database device 60. An example of this interface is a WEB browser. The interface displays an image based on a markup language represented by HTML standardized by W3C.

  The clinic client computer 20 includes a patient information DB 21. Patient information is registered in the patient DB on the clinic side. In the patient DB, information such as patient ID, name, address, height, weight, age, sex, medical history, activity intensity, cooking difficulty, exercise habits, delivery items, improvement targets, etc. is registered for each patient.

  FIG. 39 is an example of a patient information input screen. The patient information input screen shown in FIG. 39 is provided with areas for inputting patient ID, residential area, height, weight, age, sex, medical history, activity intensity, cooking difficulty, exercise habits, and delivery items. It is the input content of a patient information input screen. Exercise habits mean the number of exercises per week. 39, items 0, 1-2, 3-4, and 5-7 are displayed in ascending order. The user inputs his exercise habit from these items. The distribution item means the content of information to be distributed. In the patient information input screen of FIG. 39, distribution items of recipe only, exercise program only, and recipe + exercise program are displayed.

  When the exercise program or the distribution of the recipe + exercise program is selected, the clinic client computer 20 displays the target input screen shown in FIG. 40 and the test result input screen shown in FIG. The target input screen is provided with an area for inputting an improvement target, an exercise environment, a training site, and the like. In the improvement target, the target weight, the target cholesterol value, etc. are input. In the exercise environment, items such as whether or not the gym is used, whether or not the pool is used, and whether or not there is an outdoor exercise environment where jogging, jumping rope, etc. are displayed. Enter the part of the body you want to train most in the training part. For those with weak legs, select knees and hips. For those who want to train their trunks, select abdominal and back muscles.

  The result of the physical fitness test is entered on the test result input screen. On the test input screen, the number of times when programs such as stepping up / down, body composition, and repeated side jumps are executed, and the heart rate before and after the execution are input. In addition, physical fitness tests are conducted regularly. The exercise intensity of the exercise program changes according to the measurement result.

  The client computer 20 for clinics transmits the patient information input on the input screens of FIGS. 39 to 41, the physical strength test measurement result, and the program request signal to the database device 60.

  When receiving a program request signal accompanied by patient information from the clinic client computer 20, the WEB server 61 of the database device 60 uses, for example, an SQL statement standardized by ISO to the DB server 62 of the database device 60. Instruct to search the accumulated exercise program.

  Next, a procedure in which the WEB server 61 searches for an exercise program from the DB server 62 is shown. In addition, since the procedure which searches medical care recipe information is substantially the same as a recipe delivery system, description is abbreviate | omitted.

  The exercise program DB 64 in the DB server 62 has four tables: an exercise program table, an exercise environment table, an avoidance exercise table, and a strengthened part table. 42 to 45 are configuration examples of each table stored in the exercise program DB 64.

  FIG. 42 is an example of an exercise program table. The exercise program table is a table that stores information related to exercise. The exercise program table includes five items: exercise ID, exercise item, exercise intensity rank, and detailed information storage destination. The exercise ID item stores a key code uniquely assigned to each exercise. The name of an exercise such as walking, running, and swimming is stored in the item of exercise item. The exercise intensity rank stores exercise intensity. The exercise intensity is an objective physical intensity that can be converted into a numerical value such as a running speed and a work amount.

  The detailed information storage destination indicates a storage destination of a text file in which detailed information regarding the exercise is entered. As information on exercise, specific exercise methods, exercise effects, precautions when exercising, and the like are described. The exercise method is the frequency “How often do you walk in the week, how many minutes do you walk?” Or the exercise method, walking, “stretch the spine, pull the jaw, Tighten your stomach, fully extend your knees, land from your heels, and kick with your toes. In the exercise effect, the exercise effect such as “Walking is said to be the king of aerobic exercise, and it is said that continuation and habitualization lead to prevention and improvement of illness” is described. As for cautions, cautions such as "If you feel sick or are very tired along the way, you need to self-control to stop or slow down more than usual. .

  As shown in FIG. 43, the exercise environment table stores information related to an environment in which exercise is possible. The exercise environment table includes six items: exercise ID, use / non-use of gym, use / non-use of pool, use / non-use of outdoor exercise environment, region, and season. In the presence / absence of use of the gym, information indicating whether or not exercise using a gym training machine or the like is stored. In the presence / absence of use of the pool, information on whether or not the exercise uses the pool, such as swimming and underwater walking, is stored. In the presence / absence of use of the outdoor environment, information indicating whether the exercise is performed outdoors such as jogging or walking is stored. In the area item, the area name where exercise is impossible is stored. For example, it is not possible to give guidance to “run outside” in the winter season for patients living in heavy snowfall.

  As shown in FIG. 44, the repellent exercise table includes three items: exercise ID, repellent disease name, and rank. In the item of repellent disease name, an exercise name that avoids the exercise is stored. The rank item stores the degree to which the exercise should be avoided. The rank is from 1 to 5. The lowest rank is 1, and the higher the number, the higher the degree that must be avoided.

  As shown in FIG. 45, the strengthened part table includes two items of exercise ID and strengthened part name. The body part name strengthened by the exercise is stored in the strengthened part name item. For example, the chest is a push-up and the abdomen is an abdominal muscle.

  When receiving the patient information and the program request signal from the medical client, the WEB server 61 searches for an exercise program suitable for the patient. The exercise program search procedure will be described with reference to FIG. The procedure for creating recipe information is the same as the recipe distribution system. This system is characterized in that the calorie range of the recipe information is calculated in association with the calorie consumption due to exercise.

  As an initial process for searching for an exercise program, a target value for a patient is set. For example, when the patient aims to lose weight, the WEB server 61 obtains the amount of calories consumed, the amount of calories consumed, and the like (step T11).

  The calorie consumption can be determined from, for example, the patient's age, height, occupation (activity intensity), and exercise habits. The calorie intake can be determined from the calorie consumption. If the intake energy exceeds the consumption energy, the energy intake becomes excessive. If the excess of intake energy continues, the weight increases, and vice versa. Next, if the balance is not balanced, the excess or deficiency is adjusted by increasing or decreasing the amount of energy consumed. Here, the calorie intake calculated is the calorie range for recipe creation.

  The DB server 62 uses the athletic environment table to extract the intermediate table 1 excluded from the athletic program table according to the area where the patient lives, the exercise that cannot be performed depending on the season, the exercise using the gym, the exercise using the outdoor exercise environment, and the like. Create (step T12).

  The DB server 62 sorts the repellent movement table from the intermediate table 1 and the repellent movement table shown in FIG. (Step T13).

  The DB server 62 extracts an exercise for strengthening a part that the patient wants to strengthen from the intermediate table 2 and the strengthened part table of FIG. 44 and creates the intermediate table 3 (step T14).

  The DB server 62 selects at least one of the exercises stored in the intermediate table 3 and creates an exercise program for several months of the selected exercise. At this time, the DB server 62 anticipates an increase in the level of the physical strength of the patient, and creates an exercise program of a gradually higher level, such as the second month rather than the first month, and the third month than the second month. For example, if walking (60-70 m / min), walk for 20 minutes with 10 minutes x 2 sets in the first month, walk for 40 minutes with 20 minutes x 2 sets in the second month, and 30 minutes x 2 in the third month. The set is set to walk for 60 minutes (step T15).

  Thereby, the program table is completed. The database device 60 delivers the created exercise program to the clinic client computer 20 (step T16). The doctor prescribes the exercise program provided to the patient.

  Furthermore, in the program distribution system 300 to which the present invention is applied, the patient himself / herself can make a self-check of the degree of achievement of the exercise program and the transition of his / her exercise ability, and can re-create the exercise program. This optimizes the exercise program.

  FIG. 47 illustrates exercise program optimization. The database device 60 creates a check table together with the exercise program and transmits it to the clinic client computer 20 (step T21). The patient installs the check table in the patient client computer 50 (step T22). Physical changes such as the achievement level of the daily exercise program and the body weight are input to the check table (step T23).

  The check table also describes a method for measuring physical fitness and a method for evaluating training effects. The patient performs periodic physical fitness measurements according to the checklist. The patient client computer 50 obtains a check result such as a rank of exercise intensity from the result of physical strength measurement, and transmits the check result and patient information to the database device 60 (step T24).

  The database device 60 recreates the exercise program and the check table based on the patient information and the check result (step T25), and distributes it to the clinic client computer 20 (step T26). The doctor provides the patient with a reworked exercise program and checklist. Thereafter, the patient repeats the recreation of the regular exercise program described in steps T22 to T26.

  In addition, during this time, if there are environmental changes such as moving, psychological changes such as tiredness of the exercise program, physical problems when the exercise program does not fit the patient, the doctor will The patient information DB 21 of the computer 20 is updated (step T27), and new patient information of the exercise program and a re-creation request signal are transmitted to the database device 60 (step T28). When the database device 60 receives the reconstruction request signal, the database device 60 shifts the processing to step T25, and recreates the exercise program and the check result.

  As described above, the program distribution system 300 to which the present invention is applied is characterized by not only improving dietary habits but also improving exercise in order to improve lifestyle diseases and promote health. And In order to provide an exercise program, an exercise program completed based on the amount of exercise determined from individual physical data such as weight, age, and physical strength measurement results cannot meet the individual needs.

  The program distribution system 300 to which the present invention is applied can further provide a custom-made exercise program that meets conditions such as an individual's occupational form, a residential area, a time zone during which the user can exercise, and an orientation toward the exercise.

  Furthermore, the program distribution system 300 is intended to distribute recipe information to many people through a network and to contribute to health promotion widely from the aspect of food. Further, the program distribution system 300 further enhances the health promotion effect by distributing the exercise program to many people through the network.

  The present invention is not only for treatment in medical facilities such as small and medium-sized general hospitals and clinics, but also in sports gyms, fitness clubs, distribution of exercise programs for muscle strengthening, Distribution of exercise programs suitable for growth, or contract with individuals and distribution of exercise programs directly to individuals.

It is a block diagram which shows the whole structure of this embodiment. It is a sequence diagram regarding transmission and reception of signals between a database device to which the present invention is applied and a client computer that requests recipe information connected to the database device. It is the schematic of the authentication information input screen displayed on the client computer connected to a database apparatus. It is the schematic of the search condition input screen displayed with the client computer connected to a database apparatus. It is the schematic of the recipe information display screen displayed with the client computer connected to a database apparatus. It is the schematic of the detailed information display screen displayed with the client computer connected to a database apparatus. It is a sequence diagram regarding transmission and reception of signals between a database device and a client computer that registers new recipe information connected to the database device. It is the schematic of the recipe input screen displayed with the client computer which registers the new recipe information connected to a database apparatus. It is the schematic of the registration completion notification screen displayed on the client computer which registers the new recipe information connected to a database apparatus. It is a block diagram which shows the whole image of an Example. It is a sequence diagram regarding transmission and reception of signals between clinic client computers. It is the schematic of the authentication information input screen displayed with a client computer for clinics. It is the schematic of the patient information input screen which inputs patient information, such as patient ID, a residence area, height, weight, age, sex, illness, occupation (activity intensity), cooking difficulty, etc. which are displayed with a clinic client computer. It is a conceptual diagram of the recipe table | surface stored in recipe information DB. It is a conceptual diagram of the color information table stored in the recipe information DB. It is a conceptual diagram of the material table | surface stored in recipe information DB. It is a conceptual diagram of the repelling table stored in recipe information DB. It is a conceptual diagram of the cooking difficulty level table stored in recipe information DB. It is a flowchart which shows the main routine of a medical treatment recipe search process. It is a flowchart which shows the staple food routine of a medical treatment recipe search process. It is a flowchart which shows the main dish routine of a medical treatment recipe search process. It is a flowchart which shows the side dish routine of a medical treatment recipe search process. It is a conceptual diagram which shows the menu table which the WEB server of the database apparatus searched and created the medical treatment recipe information stored in DB server based on the patient information requested | required from the client computer for clinics. It is the schematic of the medical treatment list display screen displayed with the client computer for clinics. It is the schematic of the printing result which printed the detailed information displayed with a client computer for clinics with a printer. It is a conceptual diagram of the menu selection table preserve | saved in recipe information DB. It is a conceptual diagram of the menu structure table | surface preserve | saved at recipe information DB. It is a sequence diagram regarding transmission / reception of the signal between a database apparatus and the client computer which registers new recipe information. It is the schematic of the authentication information input screen displayed with the client computer which registers new recipe information. It is the schematic of the registered medical treatment recipe screen displayed on the client computer which registers new recipe information. It is the schematic of the recipe search result screen displayed on the client computer which registers new recipe information. It is the schematic of the detailed information screen displayed on the client computer which registers new recipe information. It is the schematic of the medical treatment recipe registration screen displayed with the client computer which registers new recipe information. It is a sequence diagram regarding transmission and reception of signals between order-receiving client computers. It is the schematic of the authentication information input screen displayed with a client computer for order receipt. It is the schematic of the recipe search condition input screen displayed on the order receipt client computer. It is the schematic of the recipe information screen displayed on the order receipt client computer. FIG. 6 is a block diagram showing an overall image of Example 2. Patient information input screen for entering patient information such as patient ID, residential area, height, weight, age, gender, illness, occupation (activity intensity), cooking difficulty, exercise habits, and delivery items displayed on the client computer for the clinic FIG. It is the schematic of the target input screen which inputs patient information, such as an improvement target displayed on a client computer for clinics, an exercise environment, and a training part. It is the schematic of the test result input screen which inputs patient information, such as a physical measurement result and a heart rate, which are displayed with a clinic client computer. It is a conceptual diagram of the exercise program table stored in the exercise program DB. It is a conceptual diagram of the exercise environment table stored in the exercise program DB. It is a conceptual diagram of the repelling exercise table stored in the exercise program DB. It is a conceptual diagram of the reinforcement | strengthening part table | surface stored in exercise program DB. It is a flowchart explaining the search procedure of an exercise program. It is a flowchart explaining the optimization procedure of an exercise program.

Explanation of symbols

1 database device, 2 client computer, 3 client computer, 4 WEB server, 5 DB server, 6 recipe information DB, 7 exercise program DB, 10 database device, 11 WEB server, 12 DB server, 13 recipe information DB, 20 for clinic Client computer, 21 Patient information DB, 22 Printer, 30 Client computer for order receipt, 40 Client computer for registration, 50 Client computer for patient, 60 Database device, 61 WEB server, 62 DB server, 63 Recipe information DB, 64 Exercise program DB , 100 program distribution system, 200 recipe distribution system, 300 program distribution system

Claims (29)

Search condition input screen information is sent to a computer for recipe request on the network in a standardized language format represented by HTML, and the recipe information stored in the database server is searched according to the search condition, and on the network to be connected. A web server that authenticates the recipe registration computer and inserts recipe information sent in a standardized language format such as HTML from the recipe registration computer on the network into the database server;
A database apparatus comprising: a database server that stores recipe information, notifies a search result for the search request of the WEB server to the WEB server, and stores the recipe information in a database according to the recipe insertion request of the WEB server.   The database server stores the medical treatment recipe information stored in the medical treatment recipe information optimal for the patient using the means for storing the medical treatment recipe information optimal for the lifestyle-related disease and information on the patient having the lifestyle-related disease as a search condition. The database apparatus according to claim 1, further comprising means for searching from recipe information.   When the recipe information is stored in the database server, the WEB server distinguishes and stores the main food, the main dish, and the side dish, and when using the information on the lifestyle-related disease patient as a search condition, the main food, the main dish, and the side dish are stored. Choose candidates that match the search criteria separately for vegetables, and rearrange the recipes selected as candidates for staple food, main dishes, and side dishes in combination to match the information related to patients with lifestyle-related diseases. The database apparatus according to claim 1, wherein:   The database server stores menu information that combines recipe request source information and distributed recipe information when the recipe information is distributed to the recipe requesting computer after receiving the request for recipe information. The database device described.   When a request for distributed recipe information is received from an order receiving computer on the network, information on the received recipe information is searched using information that combines the recipe request source client information and the distributed recipe information, and the order receiving computer on the network The database apparatus according to claim 1, wherein the distributed recipe information is transmitted to. A communication server for transmitting a search condition input screen to a program request computer on a network and receiving the search condition from the program request computer;
Recipe information classified into the types of staple food, main dish, and side dish, and exercise information are stored, and according to the search conditions input from the communication server, the recipe information whose type is the staple food and the type is the main dish A database server that searches for menu information that combines recipe information that is the above and recipe information that is the type of side dish, and exercise information that satisfies the search conditions,
The database server, wherein the communication server transmits the created menu information and the retrieved exercise information to the program requesting computer.   The data server inputs and inputs at least one of the height, weight, age, sex, illness, activity intensity, exercise habit, improvement target, training site, and physical fitness measurement result of the information requester as the search condition. Based on the search conditions, the calorie range required by the information provider and the calorie consumption to be consumed by the information provider are calculated so that the calorie consumption of the information provider becomes the calorie to be consumed. The database apparatus according to claim 6, wherein exercise information is selected.   7. The database according to claim 6, wherein the data server re-searches the exercise information satisfying the new search condition when an exercise information change request and a new search condition for the information provider are input. apparatus.   The data server distributes an evaluation input screen for allowing the information providing applicant to evaluate the result of executing the exercise according to the exercise information to the program requesting computer, and receives the information input on the evaluation input screen. 7. The database apparatus according to claim 6, wherein the search is again performed based on the exercise condition. A communication server that transmits a search condition input screen to the recipe information request computer on the network and receives the search condition from the recipe information request computer;
Recipe information classified into the types of staple food, main dish, and side dish is stored, and upon receiving a recipe information search instruction from the communication server, the recipe information that is the staple food and the type according to the search condition A database server that creates menu information combining recipe information whose main dish is recipe and recipe information whose type is side dish,
The communication server transmits the created menu information to the recipe information requesting computer.   The database server stores the recipe information and attribute information of the recipe information in association with each other, compares the search condition with the attribute information, and searches for recipe information associated with attribute information that does not satisfy the search condition. The database apparatus according to claim 10, wherein the database apparatus is excluded from a target.   Create a virtual table that stores temporary menu information that combines recipe information whose type is staple food, recipe information whose type is main dish, and recipe information whose type is side dish, and is included in the temporary menu information 11. The database apparatus according to claim 10, wherein the recipe information is compared with the search condition, and temporary menu information satisfying the search condition is selected as menu information.   The database server inputs a calorie range required by an information provider as the search condition, calculates a sum of calories of staple foods, main dishes, and side dishes included in the temporary menu information, and sums the calories. 13. The database apparatus according to claim 12, wherein provisional menu information is selected as menu information so that is within the calorie range.   The database server inputs at least one of the height, weight, age, gender, illness, and activity intensity of the information providing applicant as the search condition, and the information providing applicant is required based on the input search condition. Calculating the calorie range, calculating the sum of the calories of the staple food, the main dish, and the side dishes included in the temporary menu information, and selecting the temporary menu information for which the sum of the calories is within the calorie range as the menu information. The database apparatus according to claim 12, characterized in that:   The database server inputs a mass range of lipids to be ingested by the information requester as the search condition, calculates a total mass of lipids of staple food, main dish, and side dish included in the temporary menu information, 13. The database apparatus according to claim 12, wherein provisional menu information having a total mass within the mass range is held as menu information.   The database server inputs a mass range of salt to be taken by the information requester as the search condition, calculates a total amount of salt content of the staple food, the main dish, and the side dish included in the temporary menu information. 13. The database apparatus according to claim 12, wherein provisional menu information in which the total amount is within the mass range is held as menu information.   The database server stores the recipe information in association with the area information related to the area where the ingredients are available described in the recipe information, and compares the area of residence of the information providing applicant input as the search condition with the area information. The database apparatus according to claim 11, wherein recipe information using materials that are difficult to obtain in a residence area of the information provision applicant is excluded from search targets.   The database server associates and stores the recipe information and seasonal information related to the availability of ingredients described in the recipe information, compares the input timing of the search condition with the seasonal information, and makes it difficult to obtain materials The database apparatus according to claim 11, wherein recipe information using is excluded from search targets.   The database server stores the recipe information and the cooking difficulty level of cooking described in the recipe information in association with each other, and more than the cooking difficulty level in which the cooking difficulty level designated by the information providing applicant is input as the search condition. 12. The database apparatus according to claim 11, wherein recipe information having a high degree of difficulty is excluded from search targets.   The database server associates and stores the recipe information and the avoidance information to be avoided based on the recipe created based on the recipe information, and the medical condition information regarding the illness of the information providing applicant input as the search condition, and the avoidance information 12. The database apparatus according to claim 11, wherein recipe information that should be avoided by the information provider is excluded from search targets.   The database server stores the recipe information in association with the genre to which the dish created based on the recipe information belongs, and retains temporary menu information that matches the genres of staple food, main dish, and side dish as menu information. The database apparatus according to claim 12.   The database server stores the recipe information and the color information of the ingredients prepared based on the recipe information in association with each other, and holds the provisional menu information having different color information of staple food, main dish, and side dish as menu information. 13. The database apparatus according to claim 12, wherein   The communication server transmits a recipe information input screen to a recipe registration computer connected via an external network, and the database server registers the recipe information input on the recipe information input screen as new recipe information. The database apparatus according to claim 10. The database server attaches a menu ID to the created menu information,
The communication server is connected to an order receiving computer via an external network, and when a menu ID is designated from the order receiving computer, instructs the database server to search for menu information corresponding to the menu ID,
11. The database apparatus according to claim 10, wherein the data server returns menu information corresponding to the menu ID to the order receiving computer. A communication server that transmits a search condition input screen to the exercise program request computer on the network and receives the search condition from the exercise program request computer;
A database server that stores exercise information and attribute information of the exercise information in association with each other, compares the attribute information with the search condition, and searches for exercise information that satisfies the search condition;
The database server, wherein the communication server transmits the retrieved exercise information to the program requesting computer.   The database server stores the exercise information and the exercise intensity of the exercise in association with each other, compares the physical strength measurement result of the information providing applicant input as the search condition with the exercise intensity, and 26. The database apparatus according to claim 25, wherein an exercise that is difficult to execute with physical strength is excluded from search targets.   The database server stores the exercise information and an exercise environment in which the exercise can be performed in association with each other, compares the exercise environment of the information providing applicant input as the search condition with the exercise environment in which the exercise can be executed, 26. The database apparatus according to claim 25, wherein an exercise that is difficult to execute in an exercise environment of an information providing person is excluded from search targets.   The database server stores the exercise information and the avoidance information that should be avoided to execute the exercise in association with each other, and compares the disease information related to the illness of the information requester input as the search condition with the avoidance information. 26. The database apparatus according to claim 25, wherein exercise information that should be avoided by the information provider is excluded from search targets. The database server stores the exercise information and the body part strengthened by the exercise in association with each other, and holds the exercise information for strengthening the body part desired by the information requester as a search target. The database apparatus according to claim 25.

Images