JP2014081667A - Information notification system, information presentation system, information notification method, information presentation method, information notification program, and information presentation program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To allow effective utilization of data stored in an external database and to allow execution of processing using data acquired from the external database without complicated design and considerable development.SOLUTION: An item storage unit 110 stores therein item names to be displayed in an input screen, item specification information specifying items in an external database 130 corresponding to the item names, and item attributes indicative of attributes of data stored in the items in association with each other. An operation display control unit 102 causes a display unit to display the input screen allowing selection of item names per item attribute and accepts input of an item name selected from in the input screen and a notification condition. A search text generation unit 103 generates a search text including item specification information associated with the item name and the notification condition. A search data acquisition unit 104 searches the external database 130 with the search text and acquires searched data from the external database 130. A notification information generation unit 105 generates notification information including the searched data. A transmission/reception unit 106 transmits the notification information.

Description

  The present invention relates to an information notification device, an information presentation device, an information notification method, an information presentation method, an information notification program, and an information presentation program.

  Conventionally, companies have introduced various systems such as a sales support system and a customer management system in order to improve management efficiency. In such a system, it is possible to introduce a system suitable for the business of each company by constructing a unique system according to the business content and the business flow of each company. However, designing and developing a system requires a lot of money and time, and it takes a considerable amount of effort to get the system up and running. I needed it.

  In recent years, in order to solve such problems, many systems utilizing general-purpose package software have been constructed. By using packaged software, the time required for system design and development can be greatly reduced and the cost can be reduced. On the other hand, there has been a problem that it is not possible to deviate greatly from the specifications predetermined as package software, and that it is somewhat inconvenient and that it is necessary to accept operation according to the package software.

  In addition, such a database accumulates an enormous amount of data with a great deal of time and effort. This accumulated data is used for processing provided by the package software, such as form creation and data analysis. To use these data for user-specific processing, a new system must be developed. It was not easy.

  In order to solve such problems, data necessary for predetermined processing is extracted and / or processed from the business system database related to sales / purchase used in the package software and stored in the business database, and stored in the business database. A technique is disclosed in which a notice occurrence condition is determined from the data thus obtained and notified to a notification destination (see Patent Document 1). In this technology, the database data held by the package software is extracted and processed to generate a new unique database, and the user can input conditions according to the new database items. Provides processing.

JP 2009-288886

  However, in the technique described in Patent Document 1, data stored in a database (hereinafter referred to as an external database) used in package software is used for processing necessary for the user, but the external database is used. There is a problem in that a new database must be created, and if the external database is different, a corresponding process and database must be created.

  In recent years, as the speed of technological development has been increasing, package software with various functions has been developed one after another, and each company has the functions that best suit its business and the functions that it wants to use. It is possible to replace the system frequently in the future to use it for packaged software. In such a technical trend, it is desired to provide a system that can effectively use data stored in a database of selected package software, regardless of the package software selected by the company.

  The present invention has been made in view of the above, and can effectively use data stored in an external database, and can perform complicated design and extensive development of processing using data acquired from the external database. It is an object of the present invention to provide an information notification device, an information presentation device, an information notification method, an information presentation method, an information notification program, and an information presentation program that can be executed without being performed.

  In order to solve the above-described problems and achieve the object, the present invention is an information notification apparatus capable of acquiring data from one or a plurality of external databases, the item name displayed on the input screen, and the external database Item storage means for storing item specification information for specifying an item corresponding to the item name and an item attribute indicating an attribute of data stored in the item in association with each other, and the item storage means for each item attribute Display control means for displaying on the display unit an input screen that enables selection of the item name stored in the display, a receiving means for receiving input of the item name and notification conditions selected from the input screen, and the receiving means A search statement generation means for generating a search statement including the item specifying information associated with the received item name and the notification condition; and the search statement generator Search the external database with the search sentence generated by the above, and generate search data acquisition means for acquiring the searched search data from the external database, and notification information including the search data acquired by the search data acquisition means Notification information generating means for transmitting, and transmitting means for transmitting the notification information generated by the notification information generating means.

  The present invention is also an information presentation device connected to one or a plurality of information notification devices via a network, the presentation information storage means for storing presentation information to be included in a web page generated by a web application, and the information Notification information receiving means for receiving notification information transmitted from the notification device, information extraction means for extracting presentation information from the notification information received by the notification information receiving means, and the presentation extracted by the information extraction means Presentation information storage means for storing information in the presentation information storage means.

  Further, the present invention is capable of acquiring data from one or more external databases, and an item name to be displayed on the input screen, item specifying information for specifying an item corresponding to the item name in the external database, An information notification method that is executed by an information notification device that includes an item storage unit that associates and stores an item attribute that indicates an attribute of data stored in the item. A display control step for displaying on the display unit an input screen that enables selection of the item name stored in the item storage means, and an accepting means for inputting the item name and notification condition selected from the input screen. And a search statement generating means for receiving the item specifying information associated with the item name received by the receiving step, and the communication A search statement generation step for generating a search statement including a condition; and a search data acquisition unit searches the external database with the search statement generated by the search statement generation step, and the searched search data is stored in the external database. The search data acquisition step acquired from the notification information generation means, the notification information generation step for generating notification information including the search data acquired by the search data acquisition step, and the transmission means generated by the notification information generation step And a transmission step of transmitting the notification information.

  In addition, the present invention is executed by an information presentation device including a presentation information storage unit that is connected to one or a plurality of information notification devices via a network and stores presentation information to be included in a web page generated by a web application. In the information presentation method, the notification information receiving unit receives the notification information transmitted from the information notification device, and the information extraction unit receives the notification received by the notification information receiving step. An information extraction step for extracting presentation information from the information; and a presentation information storage means for storing the presentation information extracted by the information extraction step in the presentation information storage means. To do.

  Further, the present invention is capable of acquiring data from one or more external databases, and an item name to be displayed on the input screen, item specifying information for specifying an item corresponding to the item name in the external database, In one or a plurality of computers including an item storage unit that stores an item attribute indicating an attribute of data stored in the item in association with each other, the item storage unit stores the item storage unit for each item attribute. A display control step for displaying an input screen enabling selection of an item name on the display unit, a receiving step for receiving input of the item name and notification conditions selected from the input screen, and the item received by the receiving step A search sentence generation step for generating a search sentence including the item specifying information associated with the name and the notification condition; and the search sentence A search data acquisition step of searching the external database with the search statement generated by the creation step and acquiring the searched search data from the external database; and notification information including the search data acquired by the search data acquisition step The notification information generation step for generating the notification information and the transmission step for transmitting the notification information generated by the notification information generation step are executed.

  In addition, the present invention is provided with one or a plurality of presentation information storage units that are connected to one or a plurality of information notification apparatuses via a network and store presentation information to be included in a web page generated by a web application. A notification information reception step for receiving notification information transmitted from the information notification device, an information extraction step for extracting presentation information from the notification information received by the notification information reception step, and the information extraction step. A presentation information storage step of storing the presentation information extracted by the presentation information storage means.

  According to the present invention, for each item attribute, an input screen that allows selection of an item name stored in the item storage means is displayed on the display unit, and the item name and notification conditions selected from the input screen are received and accepted. Generate a search statement that includes the item identification information and notification conditions associated with the selected item name, search the external database using the generated search statement, and obtain the searched search data from the external database. A search statement is generated by input from the screen, and data can be searched from an external database using the generated search statement, so that data stored in the external database can be used effectively and acquired from the external database. The process using the data can be executed without complicated design and extensive development.

1 is a block diagram illustrating a configuration of an information notification system 10 according to a first embodiment. It is explanatory drawing which shows an example of a data structure of the item storage part. It is explanatory drawing which shows an example of the notification condition input screen when the item attribute of a target item is a date. It is explanatory drawing which shows an example of the notification condition input screen in case the item attribute of a target item is a numerical value. It is explanatory drawing which shows an example of the notification condition input screen in case the item attribute of a target item is text data. It is explanatory drawing which shows an example of the other notification condition input screen when the item attribute of a target item is a date. 5 is a flowchart illustrating a procedure of information notification processing executed by the information notification server 100. 5 is a flowchart illustrating a procedure of item generation processing executed by the information notification server 100. It is a block diagram which shows the structure of the information presentation system 20 concerning Example 2. FIG. It is a flowchart which shows the procedure of the presentation information storage process which the information presentation server 300 performs. It is a flowchart which shows the procedure of the presentation information transmission process which PC200 and the information presentation server 300 perform.

  Embodiments of an information notification device, an information presentation device, an information notification method, an information presentation method, an information notification program, and an information presentation program according to the present invention will be described below in detail with reference to the accompanying drawings. In addition, the Example shown below is an example of embodiment of this invention, and this invention is not limited to these Examples.

  FIG. 1 is a block diagram of the configuration of the information notification system 10 according to the first embodiment. The information notification system 10 connects an information notification server 100 and a personal computer (hereinafter referred to as a PC) 200 via a network 1. The information notification server 100 and the PC 200 can communicate with each other. In FIG. 1, one information notification server 100 and one PC 200 are shown for ease of explanation, but actually, a plurality of information notification servers 100 and a plurality of PCs 200 are connected to the network 1 and a plurality of information notification servers 100 and a plurality of PCs 200 are connected. Each information notification server 100 can communicate with each of a plurality of PCs 200. The network 1 is, for example, a local area network (LAN), an intranet, Ethernet (registered trademark), or the Internet.

  The information communication server 100 constituting the information notification system 10 is a computer on which various package software such as sales support software and customer management software (not shown) operate. The information notification server 100 includes a database (an external database 130 described later) that constitutes a part of the package software.

  Next, functions and configuration of the information notification server 100 will be described. The information notification server 100 includes an operation display unit 101, an operation display control unit 102, a search sentence generation unit 103, a search data acquisition unit 104, a notification information generation unit 105, a transmission / reception unit 106, and a schedule control unit 107. , An item generation unit 108, an item storage unit 110, a search sentence storage unit 120, an external database 130, and a notification information storage unit 140.

  The external database 130 is a database used by one or a plurality of package software, and may be one database or a plurality of databases. The external database 130 stores data necessary for each software according to a data configuration determined for each package software. The external database 130 may be any type of database such as a relational database, a hierarchical database, or a network database.

  FIG. 2 is an explanatory diagram illustrating an example of a data configuration of the item storage unit 110. The item storage unit 110 stores item names, item specifying information, and item attributes in association with each other. Here, the item name is a name of an item displayed on the operation display unit 101 as a selectable item when the notification condition is input from the input screen. The item specifying information is information for specifying an item corresponding to an item name stored in a database (that is, the external database 130) used in the package software. The item specifying information is information that can uniquely specify an item corresponding to the item name from items defined in one or a plurality of databases, and data stored in the external database 130 by using this information. Can be obtained. The item attribute is an attribute of data stored in the item, and specifically is one of date, numerical value, and text data.

  The search sentence storage unit 120 stores the search sentence generated by the search sentence generation unit 103. The search statement includes item characteristic information and notification conditions, and more specifically, records that match the notification conditions are searched from one or a plurality of external databases 130, and data included in the notification information from the searched records. (Hereinafter referred to as search data) is described. Here, the record indicates a group of data of one item stored in one or a plurality of databases. When the external database 130 is a relational database, the search sentence is described in SQL that is a database language. The search sentence is not limited to SQL, and any language or program may be used as long as it can search and acquire data in the external database 130.

  The notification information storage unit 140 stores the notification information generated by the notification information generation unit 105. When the notification information is, for example, mail data, the subject and body are embedded with the data acquired from the record that matches the notification condition in the text data stored in the storage unit, and the mail address acquired as the notification destination is the destination. To do.

  The operation display unit 101 includes a display device such as a display for displaying an input screen and the like, a keyboard (including a touch panel) for performing various input operations, and an input device such as a mouse. The operation display control unit 102 controls display of an input screen and the like on the operation display unit 101 and accepts input of notification conditions and the like from the input device. The operation display control unit 102 is an example of a receiving unit referred to in the claims.

  FIG. 3 is an explanatory diagram illustrating an example of a notification condition input screen when the item attribute of the target item is a date. As shown in FIG. 3, the notification condition input screen 31 displays a target item input field 32 and a notification condition input field 33. When the item selection button in the target item input field 32 is clicked, the item names acquired from the item storage unit 110 and whose item attribute is date are displayed in a list. In the notification condition input field 33, a condition for determining whether or not the date stored in the target item is a notification target is input. As the pull-down menu shows, it is possible to select any of the conditions that the search date is before / after / today of the contract end date. Thereby, even if the date stored in the target item corresponds to any of the future / past / present, it can be a notification target.

  FIG. 4 is an explanatory diagram illustrating an example of a notification condition input screen when the item attribute of the target item is a numerical value. As shown in FIG. 4, the notification condition input screen 41 displays a target item input field 42, a notification condition 1 input field 43, and a notification condition 2 input field 44. When the item selection button in the target item input field 42 is clicked, a list of item names acquired from the item storage unit 110 and whose item attributes are numerical values is displayed. In the notification condition 1 input field 43, conditions for determining whether or not the numerical value stored in the target item is a notification target, specifically, “numerical value a or more”, “numerical value b or less”, Enter conditions such as “exceeding numerical value c” and “less than numerical value d”. In the input field 44 of the notification condition 2, the numerical value stored in the target item is compared with the numerical value stored in the item other than the target item whose item attribute is a numerical value (including processing the numerical value by a calculation formula). To input a condition for judging whether or not it is a notification target. Note that one or both of the notification condition 1 and the notification condition 2 are notification conditions for the target item.

  FIG. 5 is an explanatory diagram illustrating an example of a notification condition input screen when the item attribute of the target item is text data. As shown in FIG. 5, the notification condition input screen 51 displays a target item input field 52 and a notification condition input field 53. When the item selection button in the target item input field 52 is clicked, the item names acquired from the item storage unit 110 and whose item attribute is text data are displayed in a list. In the notification condition input field 53, a condition for determining whether or not the text data stored in the target item is a notification target, specifically, matching text data is input. Note that the text data to be entered in the notification condition input field 53 can be selected from a pull-down menu by acquiring the text data from the external database 130 if the text data that can be stored in the target item is determined in the external database 130. You may do it.

  FIG. 6 is an explanatory diagram showing an example of another notification condition input screen when the item attribute is date. As shown in FIG. 6, the notification condition input screen 61 displays a target item input field 62, a notification condition input field 63, and a notification date input field 64. When the item selection button in the target item input field 62 is clicked, the item names acquired from the item storage unit 110 and whose item attribute is date are displayed in a list. In the notification condition input field 63, a condition for determining whether or not the date stored in the target item is a notification target, specifically, a predetermined period is input. In the notification date input field 64, the date for notifying the notification information is input.

  The notification condition for generating the notification information may be a condition input from any one input screen as a notification condition or a combination of conditions input from a plurality of input screens. As a method of combining a plurality of conditions, each condition is combined with AND, OR, or NOT.

  The search sentence generation unit 103 generates a search sentence for searching for data stored in the external database 130 according to the notification condition received by the operation display control unit 102. More specifically, the search statement generation unit 103 acquires item specifying information corresponding to the item name selected by the notification condition from the item storage unit 110, and describes a search procedure including the acquired item specifying information and the notification condition. Generate a search statement to In addition, when the date and time for searching for data is controlled by the schedule control unit 107, the search sentence generation unit 103 stores the generated search sentence in the search sentence storage unit 120.

  The search data acquisition unit 104 acquires the data stored in the external database 130 using the search text generated by the search text generation unit 103 or the search text stored in the search text storage unit 120. More specifically, the search data acquisition unit 104 searches for data that matches the notification condition from the data stored in the area indicated by the item specifying information according to the search text, and records that include the searched data Get search data necessary to create notification information from. The search data acquired from the external database 130 may be provided with a separate input screen so that the user can select which data is the search data. For example, a customer telephone number for contacting a customer or an e-mail address that is a notification destination of notification information may be acquired from the external database 130 as search data.

  The notification information generation unit 105 generates notification information using the search data acquired by the search data acquisition unit 104. The notification information generation unit 105 stores the generated notification information in the notification information storage unit 140 when the schedule control unit 107 controls the date and time when the notification information is transmitted.

  The transmission / reception unit 106 transmits / receives data to / from the PC 200 connected via the network 1. The transmission / reception unit 106 transmits the notification information generated by the notification information generation unit 105 or the notification information stored in the notification information storage unit 140 to the notification destination.

  The schedule control unit 107 controls the search data acquisition unit 104 to execute the search data acquisition process at the date and time stored in the storage unit, and controls the transmission / reception unit 106 to execute the notification information transmission process.

  The item generation unit 108 acquires the item name, item specifying information, and item attribute stored in the external database 130 from the external database 130, and associates the acquired item name, item specifying information, and item attribute with the item storage. Stored in the unit 110. When there are a plurality of external databases, the information specifying the database and the information specifying the item in the database are acquired, and the item specifying information is generated.

  Next, the PC 200 constituting the information notification system 10 will be described. The PC 200 receives the notification information transmitted from the information notification server 100. When the notification information is mail data, the PC 200 receives a mail (hereinafter referred to as a notification mail) transmitted from the information notification server 100 when the mailer is activated from a mail server (not shown). The PC 200 used by the user is not limited to the PC, and includes a mobile phone, a PDA (Personal Digital Assistant), a smartphone, a game machine, and other web browsers, and receives notification information from the information notification server 100 via the network 1. Any electronic device can be used.

  Next, an information notification process in the information notification system 10 including the information notification server 100 and the PC 200 configured as described above will be described. FIG. 7 is a flowchart showing a procedure of information notification processing executed by the information notification server 100.

  The operation display control unit 102 acquires an item name, item specifying information, and item attributes from the item storage unit 110 (step S71). The operation display control unit 102 generates a notification condition input screen for inputting a notification condition from the item name, item identification information, and item attribute, and controls to display the generated notification condition input screen on the operation display unit 101 ( Step S72). The notification condition input screen displays a screen corresponding to the item attribute. In accordance with the menu selection, one of the notification condition input screens shown in FIGS. 3 to 6 is displayed.

  The operation display control unit 102 receives the notification condition input from the notification condition input screen (step S73). In addition to the notification condition, the operation display control unit 102 receives an input of a notification destination for transmitting notification information (step S74). As the notification destination, even if an item name such as a person-in-charge mail address or a person-in-charge mail address is selected from items stored in the external database 130 in the same manner as the item name selected on the notification condition input screen, a new mail address is selected You may enter. A plurality of mail addresses may be designated for one notification condition.

  The search sentence generation unit 103 generates a search sentence corresponding to the notification condition received by the operation display control unit 102 (step S75). When the search data acquisition unit 104 operates at the date and time stored in the storage unit by the schedule control unit 107, the search statement generated by the search statement generation unit 103 is stored in the search statement storage unit 120.

  The search data acquisition unit 104 transmits the search statement generated by the search statement generation unit 103 to the database management software that manages the external database 130, and acquires search data from the external database 130 (step S76). When the schedule control unit 107 controls the operation of the search data acquisition unit 104, the search data acquisition unit 104 reads the search text from the search text storage unit 120 at the date and time stored in the storage unit, and the read search text Is sent to the database management software, and the search data is acquired from the external database 130. As a result, it is possible to avoid access to the external database 130 during times and hours when the actual business is busy, so that the external database 130 can be adjusted so as not to be overloaded.

  The notification information generation unit 105 generates notification information from the acquired search data (step S77). When the notification information is mail data, the notification information generation unit 105 generates the mail data including the search data with the mail address included in the search data or the input mail address as a destination. For example, in the case of the notification email 1 month before the contract end date shown in FIG. 3, the subject “contract end date 1 month before notification”, the contract number, contract company name, person in charge, telephone obtained from the external database 130 in the text Generate mail data describing the number. Note that the transmission / reception unit 106 stores the generated notification information in the notification information storage unit 140 when executing the notification information transmission process at the date and time stored in the storage unit by the schedule control unit 107.

  The transmission / reception unit 106 transmits notification information (step S78). If the notification information is mail data, it is stored in the mail server by transmitting the mail data. When the schedule control unit 107 controls the operation of the transmission / reception unit 106, the transmission / reception unit 106 reads the notification information from the notification information storage unit 140 and transmits the read notification information at the date and time stored in the storage unit. As a result, it is possible to avoid mail transmission during periods and time periods when the network load is high, and the network load can be smoothed.

  Further, the notification information storage unit 140 and the schedule control unit 107 are provided in a server other than the information notification server 100, and the notification information generated by the notification information generation unit 105 is transmitted to other servers via the network 1. The notification information storage unit 140 may store the notification information. The schedule control unit 107 controls the transmission / reception unit, reads the notification information from the notification information storage unit 140 at the date and time stored in the storage unit, and transmits the read notification information. As a result, mail transmission processing is performed by an independent server different from the information notification server 100, so that the load on the information notification server 100 is reduced and the power of the information notification server 100 is turned off at the date and time when mail transmission is set. Even in such a case, the risk that the notification information cannot be transmitted can be avoided.

  The transmission / reception unit 201 of the notification destination PC 200 receives the notification information. When the notification information is mail data, the notification mail stored in the mail server when the mailer is activated on the PC 200 is received, and the received notification mail is displayed by the operation display unit 202. Note that the PC 200 may include a part of the functions of the information notification server 100 described above. For example, the notification condition input process may be realized by transmitting a notification condition input screen from the information notification server 100 to the PC 200 and transmitting the input notification condition to the information notification server 100.

  In this way, the notification conditions can be set freely using items defined in the external database, so the data accumulated with a great deal of effort can be used effectively and the work can be made more efficient. . In addition, since the notification means of mail transmission is provided, necessary information is notified when the notification condition is met, so that the user can take an appropriate action without missing the time.

  In addition, as the notification condition, an item defined in the external database can be freely selected, and a notification condition can be set according to the item attribute. Therefore, the notification can be received at a timing desired by the user. Not only 1 but also multiple notification destinations can be set, so not only individual management but also managers and related departments can be notified and more reliable management can be done on a team basis. be able to.

  Even when the existing package software is replaced with the new package software, if there is a similar item in the new software, the same notification function can be realized simply by changing the item specifying information. It is also easy to set notification conditions using items defined in new package software. For this reason, the freedom of selection and replacement of package software is improved, and the range of user selection can be further expanded. In addition, functions around the package software can be easily reconstructed. It should be noted that the present embodiment can be implemented not only with packaged software but also with software produced by a company as long as it has a similar database.

  Next, an item generation process of the information notification server 100 configured as described above will be described. FIG. 8 is a flowchart showing a procedure of item generation processing executed by the information notification server 100.

  The item generation unit 108 acquires an item name, item specifying information, and item attributes from the external database 130 (step S81). More specifically, an item name, item specifying information, and item attributes are acquired for each item defined as an item stored for each item in the external database 130. The item generation unit 108 stores the acquired item name, item specifying information, and item attribute in the item storage unit 110 (step S82). When there are a plurality of external databases 130, item specifying information is generated from information specifying each database and information specifying items defined in the database. Thereby, an item can be specified even when a plurality of external databases exist.

  As described above, even when an item defined in the database is changed or the database itself is replaced, information about the item is acquired from the external database 130 and the acquired information is stored in the item storage unit 110. Therefore, the contents of the database can be immediately reflected on the notification condition input screen. Thereby, the user can easily replace the database and package software and change items without stress.

  Another embodiment will be described. The notification process described above notifies a schedule management web application (for example, a Google (registered trademark) calendar) running on a server connected via the PC 200 or the network 1 instead of or in addition to mail transmission. May be. In this case, the notification destination is a user ID uniquely determined by the schedule management web application, and the user ID stored as a notification destination in the external database 130 includes a date and notification conditions (for example, a contract end date of 1 month). Processed by sending notification information such as previous) and search data (for example, contracted company: Company A). When the schedule management software is started, “1 month before contract end date: Company A” is displayed on the date. The Instead of the user ID, a group ID in which a plurality of members are registered may be used as the notification destination. By making the notification destination a group ID, it is displayed on the schedule of all the groups and information can be shared.

  By posting notification information as message data with registered accounts on SNS (Social Networking Service) websites (for example, mixi (registered trademark), Twitter (registered trademark), Facebook (registered trademark), etc.) You may be notified. Notification may be made by sending a mail address or IP address set in a digital photo frame, car navigation system, or the like as a notification destination, and sending notification information as mail data, image data, or text data. Notification information may be transmitted as chat data using a registered account in a chat (for example, Skype (registered trademark)) as a notification destination.

  Another example of the notification process is that the notification destination is a telephone number, the notification condition when the notification condition is matched, the search data, and the text data generated from the fixed text stored in the storage unit to the voice response system. Send. In the voice response system, notification is made by connecting to the telephone number of the call destination and reading out the transmitted text data by voice. Further, the notification information may be transmitted with the notification destination as the facsimile number, or may be transmitted to the facsimile by embedding the facsimile number in the mail data. Notification may be made by sending notification information to the printer with the notification destination as the printer ID and printing it.

  As another notification process, the notification information is stored in the storage unit as pop-up data in the information notification server 100, and a dedicated program for receiving the notification information by the PC 200 is made resident to periodically store the information notification server 100. The notification information stored in is acquired. When the notification information can be acquired, the notification information is displayed in a pop-up on the display screen of the PC 200.

  The information notification server 100 does not necessarily include the package software and the database. The information notification server 100 includes the package software and the database in another server connected via the network 1, and the information notification server 100 is provided between the other server and the information notification server 100. Data may be sent and received.

  FIG. 9 is a block diagram of the configuration of the information presentation system 20 according to the second embodiment. The information presentation system 20 connects the information notification server 100, the PC 200, and the information presentation server 300 via the network 1. The information notification server 100, the PC 200, and the information presentation server 300 can communicate with each other. Although simply described in FIG. 9, a plurality of information notification servers 100, a plurality of PCs 200, and a plurality of information presentation servers 300 are actually connected to the network 1 and communicate with each other.

  More detailed functions and configurations of each device will be described. Since each apparatus and each part which attached | subjected the code | symbol same as Example 1 mentioned above are the functions and structures similar to Example 1, a different point is demonstrated with reference to the above-mentioned description.

  The information presentation server 300 includes a transmission / reception unit 301, a presentation information extraction unit 302, a web application unit 303, a presentation information conversion unit 304, and a presentation information storage unit 310.

  The presentation information storage unit 310 stores the presentation information extracted from the notification information. Here, for example, the presentation information is generated by a web application such as work information indicating the content of the work, date information indicating the deadline date or the execution date of the work, and person-in-charge information indicating a person in charge of performing the work. Information to be included in the web page. In addition to these pieces of information, arbitrary information can be added to the notification information by setting parameters. Therefore, the presentation information can be changed according to the information included in the notification information.

  The transmission / reception unit 301 transmits / receives data to / from the information notification server 100 and the PC 200 connected via the network 1. The transmission / reception unit 301 receives notification information transmitted from the information notification server 100 each time a notification condition is met. Further, the transmission / reception unit 301 receives a URL (Uniform Resource Locator) and authentication information for using the web application transmitted from the web browser of the PC 200, a request for the web application, and a search result for the web application login page and the request. The web page etc. which showed are transmitted.

  The presentation information extraction unit 302 extracts the presentation information from the notification information received by the transmission / reception unit 301 and stores it in the presentation information storage unit 310. Every time notification information is newly received, new presentation information is accumulated.

  When a web page is requested from the web browser of the PC 200, the web application unit 303 acquires the presentation information stored in the presentation information storage unit 310, and generates various web pages using the acquired presentation information. The presentation page is, for example, for each user, a work management table that shows work information that the user is in charge of, and a date indicating the deadline date or execution date of the work, or a deadline date or execution date of the work in the calendar. It is a schedule table or the like that represents work information in an area, and various web pages that display presentation information stored in the presentation information storage unit 310 in a format determined by a web application.

  In addition, the web application unit 303 may be a general-purpose web application provided to the user for a fee or free of charge. In this case, the presentation information stored in the presentation information storage unit 310 by the presentation information conversion unit 304 is converted into a form that can be used by an existing web application, and then transferred to the web application unit 303. Thus, the presentation information stored in the presentation information storage unit 310 can be used in the web application without newly creating a dedicated web application.

  FIG. 10 is a flowchart showing the procedure of the presentation information accumulation process executed by the information presentation server 300.

  The transmission / reception unit 301 receives notification information transmitted from one or a plurality of information notification servers 100 (step S101). Notification information is transmitted from one or a plurality of information notification servers 100 each time a notification condition is met. The presentation information extraction unit 302 extracts presentation information from the notification information (step S102). The presentation information extraction unit 302 stores the extracted presentation information in the presentation information storage unit 310 (step S103).

  In this way, each time the notification information transmitted from the information notification server 100 is received, the presentation information extracted from the notification information is stored in the presentation information storage unit 310, so that the user wants to confirm information (for example, for work management). Necessary information, etc.) can be stored in a form that can be handled by a web application, so that input of useful information can be completed without burdening the user with data input and editing.

  FIG. 11 is a flowchart showing a procedure of presentation information transmission processing executed by the PC 200 and the information presentation server 300.

  The transmission / reception unit 201 of the PC 200 transmits the URL of the web application input from the web browser (step S111). The transmission / reception unit 301 of the information presentation server 300 transmits a login page of the web application (step S112). The transmission / reception unit 201 of the PC 200 transmits the user ID and password (step S113). The transmission / reception unit 301 of the information presentation server 300 authenticates the user ID and password by the web application unit 303, and transmits a web page indicating the authentication result (step S114). The transmission / reception unit 201 of the PC 200 transmits a request for the web application (step S115).

  The transmission / reception unit 301 of the information presentation server 300 receives a request for the web application (step S116). The web application unit 303 acquires the presentation information from the presentation information storage unit 310 (step S117). The web application unit 303 generates a web page representing the presentation information (step S118). Unlike the case where the web application unit 303 is a general-purpose web application and the data configuration of the presentation information storage unit 310 is assumed to be a general-purpose web application, the presentation information cannot be directly acquired from the presentation information storage unit 310. In this case, the presentation information stored in the presentation information storage unit 310 is converted by the presentation information conversion unit 304 and transferred to a general-purpose web application. The transmission / reception unit 301 transmits the web page to the PC 200 (step S119).

  The transmission / reception unit 201 of the PC 200 receives the web page transmitted from the information presentation server 300 (step S120). The operation display unit 202 displays a web page with a web browser (step S121).

  As described above, the notification information transmitted from the information notification server 100 can be accumulated as the presentation information in the presentation information storage unit 310, and the accumulated presentation information can be displayed on a web page with high listability by the web application. It is possible to check the work whose deadline date and execution date are determined for each user without omission. In addition, when a normal schedule management web application is used, the user himself / herself needs to input a work item, a deadline date, and an implementation date. In the information presentation system 20 according to the present embodiment, the information notification server 100 notifies the user. The presentation information extracted from the notification information that is automatically sent when the conditions are met can be stored, and the stored presentation information can be viewed on a web page, greatly reducing the work burden of user schedule management. can do. In addition, since notification information is generated and transmitted based on data that is centrally managed in an external database, information without omission can be obtained.

  As another example, by adding information about the group to which the person in charge belongs to the notification information and storing the information about the group as presentation information, a page for managing the work of the person in charge belonging to the group in addition to the person in charge is provided. Can be generated. Thereby, the work management of the whole group can be performed.

  Note that the present invention is not limited to the above-described embodiments as they are, and can be embodied by modifying the components without departing from the scope of the invention in the implementation stage. In addition, a plurality of constituent elements disclosed in the above-described embodiments may be appropriately combined, and some constituent elements may be deleted from the constituent elements shown in the above-described embodiments.

  The hardware configuration of the information notification server 100, the PC 200, and the information presentation server 300 according to the above-described embodiment will be described. The information notification server 100, the PC 200, and the information presentation server 300 include a control device such as a CPU (Central Processing Unit), a storage device such as a ROM (Read Only Memory) and a RAM (Random Access Memory), and an HDD (Hard Disk Drive). And external storage devices such as CD (Compact Disk) drive devices, display devices such as displays, input devices such as keyboards and mice, communication interfaces that communicate with other devices, and buses that connect these devices This is a hardware configuration using a normal computer.

  In the above-described embodiment, the information notification server 100 including each unit described above operates as an information notification device, and the information presentation server 300 including each unit described above operates as an information presentation device. Moreover, the information notification server 100 or the information notification server 100 and the PC 200 described above execute the information presentation method, and the information presentation server 300 or the information presentation server 300 and the PC 200 described above execute the information presentation method.

  In addition, the CPU in the information notification server 100 reads the information notification program from the ROM and executes it to operate various devices, thereby realizing the above-described embodiment. The information notification program executed by the information notification server 100 has a module configuration including the above-described units (operation display control unit, search sentence generation unit, search data acquisition unit, notification information generation unit, transmission / reception unit, item generation unit). As the actual hardware, the CPU reads the information notification program from the ROM and executes it, so that the above-described units are loaded onto the main storage device, and the operation display control unit 102, the search sentence generation unit 103, the search A data acquisition unit 104, a notification information generation unit 105, a transmission / reception unit 106, and an item generation unit 107 are generated on the main storage device. The information presentation program executed by the information presentation server 300 has a module configuration including the above-described units (transmission / reception unit, presentation information extraction unit, web application unit, presentation information conversion unit). When the information presentation program is read from the ROM and executed, the above-described units are loaded onto the main storage device, and the transmission / reception unit 301, the presentation information extraction unit 302, the web application unit 303, and the presentation information conversion unit 304 are main. Generated on the storage device.

  The item storage unit 110, the search sentence storage unit 120, the external database 130, the notification information storage unit 140, and the presentation information storage unit 310 are configured on the main storage device, such as an HDD, an optical disk, and a memory card. It can also be configured by any commonly used storage medium.

  The information notification program and the information presentation program are files in an installable or executable format, such as a CD-ROM, flexible disk (FD), CD-R, DVD (Digital Versatile Disk), or USB memory. It may be provided by being recorded on a readable recording medium.

  Further, the information notification program and the information presentation program may be stored on a computer connected to a network such as the Internet and provided by being downloaded via the network. The information notification program and the information presentation program may be provided or distributed via a network such as the Internet.

DESCRIPTION OF SYMBOLS 1 Network 10 Information notification system 20 Information presentation system 100 Information notification server 101 Operation display part 102 Operation display control part 103 Search sentence generation part 104 Search data acquisition part 105 Notification information generation part 106 Transmission / reception part 107 Schedule control part 108 Item generation part 110 Item storage unit 120 Search sentence storage unit 130 External database 140 Notification information storage unit 200 Personal computer 201 Transmission / reception unit 202 Operation display unit 300 Information presentation server 301 Transmission / reception unit 302 Presentation information extraction unit 303 Web application unit 304 Presentation information conversion unit 310 Presentation information Storage

The present invention has been made in view of the above, and can effectively use data stored in an external database, and can perform complicated design and extensive development of processing using data acquired from the external database. It is an object of the present invention to provide an information notification system , an information presentation system , an information notification method, an information presentation method, an information notification program, and an information presentation program that can be executed without being performed.

To solve the above problems and achieve the object, the present invention provides an information retrieval device, a said information retrieval device via the network consisting of connected information notifying apparatus information notification system, wherein the information The search device includes an item name displayed on the input screen and an item corresponding to the item name in an external database that is a database used in software operating on the information search device or the information processing device connected to the network. Item storage means for storing the item specification information to be specified and the item attribute indicating the attribute of the data stored in the item in association with each other, and the item name stored in the item storage means for each item attribute display control means for controlling to display an input screen that allows selection on the display unit, the item name and the item selected from said input screen And accepting means for accepting input of notification conditions using, the accepting said item specifying information associated with the item name received by the means, and the generating a search statement involving a notification condition, generated the Search text generation means for storing a search text in a search text storage unit, search data for searching the external database with the search text stored in the search text storage unit, and acquiring the searched search data from the external database An acquisition unit; a notification information generation unit that generates notification information including the search data acquired by the search data acquisition unit; and a first unit that transmits the notification information generated by the notification information generation unit to the information notification device. Transmission means, and first schedule control means for controlling the search data acquisition means to be executed at a predetermined timing. Notification device receives the notification information transmitted from said information retrieval device, a receiving means for storing the notification information received in the notification information storage unit, the notification information stored in the notification information storage unit and second transmission means for transmitting, characterized in that it comprises a second schedule control means for controlling to perform said second transmission means at a predetermined timing.

The present invention is also an information presentation system in which one or a plurality of information notification devices and an information presentation device are connected via a network, the information notification device including an item name displayed on an input screen, and the information Item specifying information for specifying an item corresponding to the item name in an external database which is a database used in software operating on a notification device or an information processing device connected to the network, and attributes of data stored in the item And an item storage unit that stores the item attribute indicating the item name and the input screen that enables selection of the item name stored in the item storage unit for each item attribute. Display control means, receiving means for receiving an input of the item name selected from the input screen and a notification condition using the item name, and Search sentence generation means for generating a search sentence including the item specifying information associated with the item name received by the attaching means and the notification condition, and storing the generated search sentence in a search sentence storage unit And search data acquisition means for searching the external database with the search text stored in the search text storage unit and acquiring the searched search data from the external database, and the search data acquisition means acquired by the search data acquisition means A notification information generation unit that generates notification information including search data, a transmission unit that transmits the notification information generated by the notification information generation unit to the information presentation device, and the search data acquisition unit are executed at a predetermined timing. includes a schedule control means for controlling so as to, wherein the information presentation apparatus, a web application generates Webupe And presentation information storing means for storing presentation information to be included in the notification information receiving means for receiving the notification information transmitted from the information notifying apparatus, the presentation information from the notification information received by the notification information receiving unit Information extracting means to extract, presentation information storing means for storing the presentation information extracted by the information extracting means in the presentation information storage means, and a request for the web page from an information processing apparatus connected via the network Is transmitted, the web page generation unit that generates a web page from the presentation information stored in the presentation information storage unit, and the web page generated by the web page generation unit is transmitted to the information processing apparatus. And a web page transmitting means .

The present invention is also an information notification method executed by an information notification system comprising an information search device and an information notification device connected to the information search device via a network , the information search device Item specifying information for specifying an item name displayed on the screen and an item corresponding to the item name in an external database which is a database used in software operating on the information search device or the information processing device connected to the network When, with the item storage means for storing in association with each other, and the item attribute indicating an attribute of data to be stored in the fields, for each pre-Symbol attribute, you can select the item names stored in the item storage means use a display control step of controlling to display on the display unit an input screen, the front the item name and the item name selected from filled force screen An accepting step of accepting an input of notification condition, the item specifying information associated with the item name accepted by the previous SL accepting step, and generates a search statement involving the notification condition, generated the search was Search sentence generation step of storing a sentence in a search sentence storage unit, search data acquisition for searching the external database with the search sentence stored in the search sentence storage unit, and acquiring the searched search data from the external database a step, a notification information generating step of generating the notification information including the pre-Symbol Search the search data acquired by the data acquiring step, the first to send the notification information generated by the notification information generation step to the information notifying apparatus A first schedule for controlling the transmission step and the retrieval data acquisition step to be executed at a predetermined timing; The information notification device receives the notification information transmitted from the information search device, and stores the received notification information in a notification information storage unit; and the notification information A second transmission step of transmitting the notification information stored in the storage unit; and a second schedule control step of controlling the second transmission step to be executed at a predetermined timing .

The present invention is also an information presentation method executed in an information presentation system in which one or a plurality of information notification apparatuses and an information presentation apparatus are connected via a network, the information notification apparatus being displayed on an input screen. An item specifying information for specifying an item corresponding to the item name in an external database which is a database used in software operating on the information notification device or the information processing device connected to the network, An item storage means for storing an item attribute indicating an attribute of data stored in the item in association with each other, and an input screen that enables selection of the item name stored in the item storage means for each item attribute Display control step for controlling display on the display unit, the item name selected from the input screen, and a notification condition using the item name A receiving step for receiving an input; a search sentence including the item specifying information associated with the item name received by the receiving step; and the notification condition; and generating the search sentence in the search sentence storage Search data generation step for storing in the search section, search data acquisition step for searching the external database with the search text stored in the search text storage section, and acquiring the searched search data from the external database, and the search A notification information generation step for generating notification information including the search data acquired by the data acquisition step, a transmission step for transmitting the notification information generated by the notification information generation step to the information presentation device, and the search data A schedule control step for controlling the acquisition step to be executed at a predetermined timing; and Includes the information presentation device, the notification information reception step includes a presentation information storage means for storing the presentation information, to receive the notification information transmitted from the previous SL information notifying apparatus to be included in a web page that the web application generates When an information extraction step of extracting presentation information from the notification information received by the pre-Symbol notification information receiving step, presentation information storage for storing the presentation information extracted by the previous SL information extraction step in the presentation information storage unit A web page generating step for generating a web page from the presentation information stored in the presentation information storage means when a request for the web page is transmitted from an information processing apparatus connected via the network; The web page generated by the web page generation step is changed to the information. And a web page transmitting step for transmitting to the information processing apparatus .

Also, items present invention, corresponding to the item name in the external database is a database used by the item name to be displayed on the input screen, software running on other connected computers over a computer or network The item specifying information for specifying the item and the item storage means for storing the item attribute indicating the attribute of the data stored in the item in association with each other. A display control step for controlling the display unit to display an input screen enabling selection of the item name stored in the storage means, and the item name selected from the input screen and a notification condition using the item name Accepting step for accepting input, and the item specifying information associated with the item name accepted by the accepting step And generates a search statement involving the notification condition, a search text generating step of storing the generated the search text in the search text storage unit, the external database with the search statement stored in the retrieval sentence storage unit A search data acquisition step of searching and acquiring the searched search data from the external database, a notification information generation step of generating notification information including the search data acquired by the search data acquisition step , and the search data acquisition step Is stored in the notification information storage unit, a storage step for storing the notification information generated in the notification information generation step in a notification information storage unit, and a notification information storage unit. a transmission step of transmitting the notification information, executing the transmitting step at a predetermined timing Characterized in that to execute a second schedule control step of so that control, the.

Further, the present invention provides an item name displayed on the input screen and an item corresponding to the item name in an external database which is a database used in software operating on a computer or another computer connected via a network. Item storage means for storing the item specifying information to be specified and the item attribute indicating the attribute of the data stored in the item in association with each other, and the presentation information storage for storing the presentation information to be included in the web page generated by the web application And a display control step for controlling, on a display unit, an input screen that enables selection of the item name stored in the item storage unit for each item attribute. The item name selected from the input screen and the notification condition input using the item name are accepted. Generating a search sentence including the item specifying information associated with the item name accepted in the attaching step and the receiving step, and the notification condition, and storing the generated search sentence in the search sentence storage unit A search statement generation step, a search data acquisition step of searching the external database with the search statement stored in the search statement storage unit, and acquiring the searched search data from the external database, and the search data acquisition step A notification information generation step for generating notification information including the search data acquired by the step, a notification information transmission step for transmitting the notification information generated by the notification information generation step, and the search data acquisition step at predetermined timings. a schedule control step of controlling to execute in the transmission step the notification information Thus a notification information reception step of receiving the transmitted the notification information, the information extraction step of extracting presentation information from the notification information received by the notification information reception step, the presentation information extracted by the information extraction step From the presentation information stored in the presentation information storage means when a request for the web page is transmitted from another computer connected via a network. A web page generation step of generating a web page and a web page transmission step of transmitting the web page generated by the web page generation step to the other computer are executed.

Claims (10)

An information notification device capable of acquiring data from one or more external databases,
Item storage for storing the item name displayed on the input screen, the item specifying information for specifying the item corresponding to the item name in the external database, and the item attribute indicating the attribute of the data stored in the item in association with each other Means,
Display control means for displaying an input screen for enabling selection of the item name stored in the item storage means for each item attribute;
Receiving means for receiving input of the item name and notification condition selected from the input screen;
A search statement generation unit that generates a search statement including the item specifying information associated with the item name received by the reception unit and the notification condition;
Search data acquisition means for searching the external database with the search text generated by the search text generation means and acquiring the searched search data from the external database;
Notification information generating means for generating notification information including the search data acquired by the search data acquiring means;
Transmitting means for transmitting the notification information generated by the notification information generating means;
An information notification apparatus comprising: The accepting means is
Whether the item attribute is a date, and the date stored in the area indicated by the item identification information associated with the item name matches the date of the search date, or Receiving an input of a notification condition for determining whether or not the date matches the date before or after a predetermined period from the date of the search date,
Or
The item name whose item attribute is a numerical value is selected, and whether or not the numerical value stored in the area indicated by the item specifying information associated with the item name matches a predetermined value, A notification condition for determining at least one of whether the value exceeds, whether it is greater than or equal to a predetermined value, whether it is less than or equal to a predetermined value, or less than a predetermined value Accepting input,
Or
Whether the item attribute whose text attribute is text data is selected, and whether the text data stored in the area indicated by the item identification information associated with the item name matches predetermined text data Accepting notification conditions to determine
Or
Select the item name whose item attribute is a date, and determine whether the date stored in the area indicated by the item specifying information associated with the item name is included within a predetermined period The information notification apparatus according to claim 1, wherein an input of a notification condition is received. The notification information generating means
Generating the notification information as mail data;
Or
Generating the notification information as schedule data that is read into a schedule management web application and written to the schedule;
Or
Generating the notification information as printer data to be printed by a printer;
Or
Generating the notification information as facsimile data to be transmitted to a facsimile;
Or
Generating the notification information as digital photo frame data transmitted to the digital photo frame;
Or
Generating the notification information as voice response data that is read into voice response software and notified by voice;
Or
The information notification device according to claim 1 or 2, wherein the notification information is generated as web data displayed on a website by posting the information on a website of an SNS (Social Networking Service). .   Item generating means for acquiring the item name, the item specifying information, and the item attribute from the external database, and storing the acquired item name, the item specifying information, and the item attribute in the item storing means in association with each other The information notification device according to any one of claims 1 to 3, further comprising: An information presentation device connected to one or more information notification devices via a network,
Presentation information storage means for storing presentation information to be included in a web page generated by a web application;
Notification information receiving means for receiving notification information transmitted from the information notification device;
Information extracting means for extracting presentation information from the notification information received by the notification information receiving means;
Presentation information storage means for storing the presentation information extracted by the information extraction means in the presentation information storage means;
An information presentation device comprising:   The information presentation apparatus according to claim 5, further comprising web page generation means for generating a web page from the presentation information stored in the presentation information storage means. Data that can be acquired from one or more external databases and that are displayed on the input screen, item specifying information that specifies an item corresponding to the item name in the external database, and data stored in the item An information notification method that is executed by an information notification device including an item storage unit that associates and stores an item attribute indicating an attribute of
A display control step for causing the display control means to display on the display unit an input screen for selecting the item name stored in the item storage means for each item attribute;
A receiving step for receiving an input of the item name and notification condition selected from the input screen;
A search statement generation step, wherein the search statement generation means generates a search statement including the item specifying information associated with the item name received by the reception step and the notification condition;
A search data acquisition step for searching the external database with the search sentence generated by the search sentence generation step, and acquiring the searched search data from the external database,
A notification information generating step for generating notification information including the search data acquired by the search data acquiring step;
A transmitting step for transmitting the notification information generated by the notification information generating step;
An information notification method comprising: An information presentation method that is executed by an information presentation device that is connected to one or more information notification devices via a network and includes presentation information storage means that stores presentation information to be included in a web page generated by a web application. There,
A notification information receiving means for receiving notification information transmitted from the information notification device;
An information extracting step for extracting presentation information from the notification information received by the notification information receiving step;
A presentation information storage step in which a presentation information storage means stores the presentation information extracted in the information extraction step in the presentation information storage means;
The information presentation method characterized by including. Data that can be acquired from one or more external databases and that are displayed on the input screen, item specifying information that specifies an item corresponding to the item name in the external database, and data stored in the item In one or more computers provided with item storage means for storing and storing item attributes indicating the attributes of
For each item attribute, a display control step for displaying on the display unit an input screen that enables selection of the item name stored in the item storage unit;
An accepting step for accepting input of the item name and notification condition selected from the input screen;
A search statement generation step of generating a search statement including the item specifying information associated with the item name received by the reception step and the notification condition;
A search data acquisition step of searching the external database with the search statement generated by the search statement generation step, and acquiring the searched search data from the external database;
A notification information generation step for generating notification information including the search data acquired by the search data acquisition step;
A transmission step of transmitting the notification information generated by the notification information generation step;
An information notification program characterized in that One or more computers provided with one or a plurality of information notification devices via a network and provided with a presentation information storage unit that stores presentation information to be included in a web page generated by a web application,
A notification information receiving step of receiving notification information transmitted from the information notification device;
An information extracting step of extracting presentation information from the notification information received by the notification information receiving step;
A presentation information storage step of storing the presentation information extracted by the information extraction step in the presentation information storage means;
An information presentation program characterized in that the program is executed.

Images