WO2013005390A1

WO2013005390A1 - Information notification device, information notification system, information presentation system, information notification method, information presentation method, information notification program and information presentation program

Info

Publication number: WO2013005390A1
Application number: PCT/JP2012/004143
Authority: WO
Inventors: 元幸福島; 孝英村越; 淳片岡
Original assignee: タイムコンシェル株式会社
Priority date: 2011-07-07
Filing date: 2012-06-27
Publication date: 2013-01-10
Also published as: JP4881485B1; JP2014081667A

Abstract

An operation display control unit (102) receives input of an item name and notification condition. A search statement generation unit (103) generates item-identifying information associated with the item name, and a search statement that includes a notification condition. A search data retrieval unit (104) searches an external database (130) for the search statement, and retrieves the search data that was searched, from the external database (130). A notification information generation unit (105) generates notification information that includes the search data, and a sending/receiving unit (106) sends the notification information. A schedule control unit (107) controls the search data retrieval unit (104) to execute in a specified timing.

Description

Information notification device, information notification system, information presentation system, information notification method, information presentation method, information notification program, and information presentation program

The present invention relates to an information notification device, 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.

Traditionally, companies have introduced various systems such as sales support systems and customer management systems 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 order to solve such problems, in recent years, many systems using 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 is a problem that individual users cannot greatly deviate from the specifications predetermined as the package software, and are somewhat inconvenient and have 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 (for example, form creation and data analysis), but a new system must be developed to use these data for user-specific processing. 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. An object is to provide an information notification device, 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.

In order to solve the above-described problems and achieve the object, the present invention provides an item name displayed on an input screen, item specifying information for specifying an item corresponding to an item name in one or more external databases, and items An item attribute indicating the attribute of the data to be stored is stored in the item storage unit in association with each other, and an input screen that enables selection of the item name stored in the item storage unit is displayed on the display unit for each item attribute. Control. The item name selected from the input screen and the notification condition input using the item name are accepted, the item identification information associated with the accepted item name and the search statement including the notification condition are generated and generated The search sentence is stored in the search sentence storage unit. The external database is searched with the search text stored in the search text storage unit, and the searched search data is acquired from the external database. Notification information including the acquired search data is generated, and the generated notification information is transmitted to an information processing apparatus connected via a network. The search data acquisition means is controlled to be executed at a predetermined timing.

In addition to the above means, the present invention stores the presentation information to be included in the web page generated by the web application in the presentation information storage means. The notification information transmitted from the information notification device is received, and the presentation information is extracted from the received notification information. The extracted presentation information is stored in the presentation information storage means. When a web page request is transmitted from an information processing apparatus connected via a network, a web page is generated from the presentation information stored in the presentation information storage unit, and the generated web page is transmitted to the information processing apparatus.

FIG. 1 is a block diagram of the configuration of the information notification system 10 according to the first embodiment. FIG. 2 is an explanatory diagram illustrating an example of a data configuration of the item storage unit 110. 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. 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. 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. FIG. 6 is an explanatory diagram showing an example of another notification condition input screen when the item attribute of the target item is date. FIG. 7 is a flowchart showing a procedure of information notification processing executed by the information notification server 100. FIG. 8 is a flowchart showing a procedure of item generation processing executed by the information notification server 100. FIG. 9 is a block diagram of the configuration of the information presentation system 20 according to the second embodiment. FIG. 10 is a flowchart showing the procedure of the presentation information accumulation process executed by the information presentation server 300. FIG. 11 is a flowchart showing a procedure of presentation information transmission processing executed by the PC 200 and the information presentation server 300.

Hereinafter, embodiments of an information notification device, 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 according to the present invention will be described 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 LAN (Local Area Network), 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 a single 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 showing an example of the 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, specifically, date, numerical value, text data, or the like.

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 a notification condition. More specifically, a record that matches the notification condition is searched from one or a plurality of external databases 130, and data (hereinafter, referred to as notification information) included in the notification information from the searched record. (Referred to as search data). 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 the data in the external database 130 can be searched and acquired.

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.

FIG. 3 is an explanatory diagram showing 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 an item selection button in the target item input field 32 is clicked, the operation display unit 101 displays a list of item names acquired from the item storage unit 110 and whose item attribute is date. 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 showing 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, the operation display unit 101 displays a list of item names acquired from the item storage unit 110 and whose item attributes are numerical values. 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 showing 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 operation display unit 101 displays a list of item names acquired from the item storage unit 110 and whose item attributes are text data. The notification condition input field 53 includes a condition for determining whether or not the text data stored in the target item is a notification target, specifically, text data that may be stored in the target item. Enter. Note that the text data to be entered in the notification condition input field 53 is acquired from the external database 130 and selected from the pull-down menu when the text data stored in the target item is determined in the external database 130. You may be able to 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 operation display unit 101 displays a list of item names acquired from the item storage unit 110 and whose item attribute is date. 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.

Further, 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 notification condition may be further narrowed down by another notification condition from a search result that matches one notification condition.

The search sentence generation unit 103 generates a search sentence for searching the 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, the customer name and customer phone number for contacting the customer, the e-mail address that is the notification destination of the notification information, and the like 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 and the transmission / reception unit 106 to execute the notification information transmission process at the date and time stored in the storage unit.

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, but 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, information notification processing 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 an item attribute 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. According to the menu selection, one of the notification condition input screens shown in FIGS. 3 to 6 is displayed.

The operation display controller 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 the 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. For example, when the item name “person-in-charge mail address” stored in the external database 130 is selected as the notification destination, the data stored in the item “person-in-charge mail address” is acquired from the record that matches the notification condition, and the destination Generate mail data.

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 schedule control unit 107 controls the search data acquisition unit 104 to operate at the date and time stored in the storage unit, the search statement is stored in the search statement storage unit 120.

The search data acquisition unit 104 transmits a search statement 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.

In the case of the notification conditions as shown in FIGS. 4 and 5, the same notification information is notified multiple times if the data matches the notification conditions when the search data acquisition unit 106 executes the process. become. Therefore, in order to avoid the same notification information being notified many times, a notification unit, a notification content, a notification destination, and a notification date and time are provided in association with each other, and a notification information transmission unit 108 is provided. Reads the information stored in the storage unit before sending the notification information, and does not notify all of the same notification information, but only notifies the first time / notify once a week / every time the notification condition is met. You may control to transmit at the time of notifications predetermined, such as one time notification.

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 another server via the network 1. Then, it may be stored in the notification information storage unit 140. 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, it is possible to avoid the risk that the notification information cannot be transmitted even if a failure has occurred.

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.

As described above, since the notification condition can be set freely using items defined in the external database 130, it is possible to effectively utilize the data accumulated with a great deal of labor and to improve the efficiency of the work. it can. 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.

Also, as the notification condition, an item defined in the external database 130 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 if the existing package software is replaced with 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 identification 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.

In addition, the external database 130 can acquire data from a plurality of databases, not limited to 1, and can acquire data stored in different databases, so that data distributed in various environments can be used effectively. . That is, the external database 130 may be used by software operating on the information notification server 100 or may be used by software operating on another server or PC connected to the network 1.

The external database 130 is an internal / external database (RDB (Relational Database), other format databases, spreadsheet software data such as EXCEL, CSV format data, XML (Extensible Markup Language) format data, etc. ) Can also be acquired, so that various data can be integrated and used for the notification function.

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.

Other embodiments 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 registered 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.) as notification destinations 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 a 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 will be described for each device. 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) for using a web application transmitted from the web browser of the PC 200, authentication information, a request for the web application, and a search result for the web application login page or 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.

Further, 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 storage 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 illustrating 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 using a normal schedule management web application, the user himself / herself needs to input a work item, a deadline date, and an implementation date. However, in the information presentation system 20 according to the present embodiment, the information notification server 100 extracts and accumulates the presentation information from the notification information that is automatically transmitted when the notification condition is met, and the accumulated presentation information is stored in the web. Can be viewed on the page. For this reason, the work burden of the user's schedule management can be greatly reduced. 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 the above-described units operates as an information notification device, and the information presentation server 300 including the above-described units 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.

Also, the above-described embodiment is realized by operating various devices by the CPU in the information notification server 100 reading and executing the information notification program from the ROM. 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 Memory

Claims

An information notification device,
An item name displayed on the input screen, item specifying information for specifying an item corresponding to the item name in one or a plurality of external databases, and an item attribute indicating an attribute of data stored in the item are stored in association with each other. Item storage means for
Display control means for controlling to display on the display unit an input screen that enables selection of the item name stored in the item storage means for each item attribute;
Receiving means for receiving an input of the item name selected from the input screen and a notification condition using the item name;
A search statement generating means for generating a search statement including the item specifying information associated with the received item name and the notification condition, and storing the generated search statement in a search statement storage unit;
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;
Notification information generating means for generating notification information including the acquired search data;
Transmitting means for transmitting the generated notification information to an information processing apparatus connected via a network;
Schedule control means for controlling the search data acquisition means to execute at a predetermined timing;
An information notification device 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 the information notification apparatus receives an input of a notification condition to be performed.
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 apparatus according to claim 1, 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 generation that acquires the item name, the item specifying information, and the item attribute from the external database, and stores the acquired item name, the item specifying information, and the item attribute in the item storage unit in association with each other The information notification device according to any one of claims 1 to 3, further comprising: means.
An information notification system for connecting an information search device and an information notification device via a network,
The information search device includes:
An item name displayed on the input screen, item specifying information for specifying an item corresponding to the item name in one or a plurality of external databases, and an item attribute indicating an attribute of data stored in the item are stored in association with each other. Item storage means for
Display control means for controlling to display on the display unit an input screen that enables selection of the item name stored in the item storage means for each item attribute;
Receiving means for receiving an input of the item name selected from the input screen and a notification condition using the item name;
A search statement generating means for generating a search statement including the item specifying information associated with the received item name and the notification condition, and storing the generated search statement in a search statement storage unit;
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;
Notification information generating means for generating notification information including the acquired search data;
First transmission means for transmitting the generated notification information to the information notification device;
First schedule control means for controlling the search data acquisition means to execute at a predetermined timing,
The information notification device includes:
Receiving means for receiving the notification information transmitted from the information search device, and storing the received notification information in a notification information storage unit;
Second transmission means for transmitting the notification information stored in the notification information storage unit to an information processing apparatus connected via the network;
Second schedule control means for controlling the second transmission means to execute at a predetermined timing;
An information notification system comprising:
An information presentation system for connecting an information notification device and an information presentation device via a network,
The information notification device includes:
An item name displayed on the input screen, item specifying information for specifying an item corresponding to the item name in one or a plurality of external databases, and an item attribute indicating an attribute of data stored in the item are stored in association with each other. Item storage means for
Display control means for controlling to display on the display unit an input screen that enables selection of the item name stored in the item storage means for each item attribute;
Receiving means for receiving an input of the item name selected from the input screen and a notification condition using the item name;
A search statement generating means for generating a search statement including the item specifying information associated with the received item name and the notification condition, and storing the generated search statement in a search statement storage unit;
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;
Notification information generating means for generating notification information including the acquired search data;
Transmitting means for transmitting the generated notification information to the information presentation device;
Schedule control means for controlling the search data acquisition means to execute at a predetermined timing,
The information presentation device includes:
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 the notification information transmitted from the information notification device;
Information extracting means for extracting presentation information from the received notification information;
Presentation information storage means for storing the extracted presentation information in the presentation information storage means;
Web page generation means 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;
Web page transmitting means for transmitting the generated web page to the information processing apparatus;
An information presentation system comprising:
The search data acquisition means retrieves search data including person-in-charge information indicating a person in charge of performing work, work information indicating work contents, and date information indicating a work due date or execution date from the external database. Acquired,
The presentation information storage means stores the person-in-charge information, the work information, and the date information in association with each other as the presentation information,
The web page generating means includes a web page or a calendar showing a work management table representing the work information and the date associated with the person-in-charge information corresponding to the user information input from the information processing apparatus. 7. A web page indicating a schedule table representing the work information associated with the person-in-charge information corresponding to the user information is generated in a field of a work deadline date or an execution date. Information presentation system described in 1.
An item name displayed on the input screen, item specifying information for specifying an item corresponding to the item name in one or a plurality of external databases, and an item attribute indicating an attribute of data stored in the item are stored in association with each other. An information notification method executed by an information notification device comprising:
A display control step for controlling to display on the display unit an input screen that enables selection of the item name stored in the item storage means for each item attribute;
An accepting step of accepting an input of a notification condition using the item name and the item name selected from the input screen;
A search statement generation step of generating a search statement including the item specifying information associated with the accepted item name and the notification condition, and storing the generated search statement in a search statement storage unit;
A search data acquisition step of 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;
A notification information generating step for generating notification information including the acquired search data;
A transmission step of transmitting the generated notification information to an information processing apparatus connected via a network;
A schedule control step for controlling the transmission step to be executed at a predetermined timing;
Information notification method including
An information presentation method executed by an information presentation system that connects one or more information notification devices and an information presentation device via a network,
The information notification device includes:
An item name displayed on the input screen, item specifying information for specifying an item corresponding to the item name in one or a plurality of external databases, and an item attribute indicating an attribute of data stored in the item are stored in association with each other. Item storage means, and presentation information storage means for storing presentation information to be included in the web page generated by the web application,
A display control step for controlling to display on the display unit an input screen that enables selection of the item name stored in the item storage means for each item attribute;
An accepting step of accepting an input of a notification condition using the item name and the item name selected from the input screen;
A search statement generation step of generating a search statement including the item specifying information associated with the accepted item name and the notification condition, and storing the generated search statement in a search statement storage unit;
A search data acquisition step of 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;
A notification information generating step for generating notification information including the acquired search data;
A notification information transmission step of transmitting the generated notification information to the information presentation device;
A schedule control step for controlling the search data acquisition step to be executed at a predetermined timing,
The information presentation device includes:
A presentation information storage means for storing presentation information to be included in a web page generated by a web application;
A notification information receiving step for receiving the notification information transmitted from the information presentation device;
An information extraction step of extracting presentation information from the received notification information;
A presentation information storage step of storing the extracted presentation information in the presentation information storage means;
A web page generating step of 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;
A web page transmission step of transmitting the generated web page to the information processing apparatus;
Information presentation method.
An item name displayed on the input screen, item specifying information for specifying an item corresponding to the item name in one or a plurality of external databases, and an item attribute indicating an attribute of data stored in the item are stored in association with each other. One or more computers having item storage means for
A display control step for controlling to display on the display unit an input screen that enables selection of the item name stored in the item storage means for each item attribute;
An accepting step of accepting an input of a notification condition using the item name and the item name selected from the input screen;
A search statement generation step of generating a search statement including the item specifying information associated with the accepted item name and the notification condition, and storing the generated search statement in a search statement storage unit;
A search data acquisition step of 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;
A notification information generating step for generating notification information including the acquired search data;
A transmission step of transmitting the generated notification information;
A schedule control step for controlling the search data acquisition step to be executed at a predetermined timing;
Information notification program to execute
An item name displayed on the input screen, item specifying information for specifying an item corresponding to the item name in one or a plurality of external databases, and an item attribute indicating an attribute of data stored in the item are stored in association with each other. One or a plurality of computers provided with item storage means for storing and presentation information storage means for storing presentation information to be included in a web page generated by a web application,
A display control step for controlling to display on the display unit an input screen that enables selection of the item name stored in the item storage means for each item attribute;
An accepting step of accepting an input of a notification condition using the item name and the item name selected from the input screen;
A search statement generation step of generating a search statement including the item specifying information associated with the accepted item name and the notification condition, and storing the generated search statement in a search statement storage unit;
A search data acquisition step of 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;
A notification information generating step for generating notification information including the acquired search data;
A notification information transmission step of transmitting the generated notification information;
A schedule control step for controlling the search data acquisition step to be executed at a predetermined timing;
A notification information receiving step for receiving the transmitted notification information;
An information extraction step of extracting presentation information from the received notification information;
A presentation information storage step of storing the extracted presentation information in the presentation information storage means;
A web page generation step of 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 another computer connected via a network;
A web page transmission step of transmitting the generated web page to the other computer;
Information presentation program that executes