JP2004070877A - Information distributing device and its method, and computer program for information distribution - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To easily and quickly automatically extract and set a mail addressee by changing a mailing environment of a user only minimally. <P>SOLUTION: The user of the system can optionally change extraction condition items for the addressee to which mail will be distributed on the basis of a DB of the user, and it can be added without changing the environment of the user even when the user does not have mail address information in the DB. Setting of an extraction condition of an addressee to which mail will be distributed, mail distribution based upon the setting, and automatic mail distribution capable of automatically distributing mail to an addressee satisfying a particular condition when a specified condition is satisfied can be easily realized from a user side via browsing software or the like. <P>COPYRIGHT: (C)2004,JPO

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to an information distribution apparatus and method, and a computer program for information distribution.
[0002]
[Prior art]
With the spread of the Internet, the opportunity to exchange e-mails is increasing rapidly. In particular, the use of e-mail services has become popular in the fields of finance and distribution, and has played a role as part of retaining customers.
Conventionally, techniques for automatically extracting a mail delivery destination and delivering the mail to the destination are disclosed in JP-A-2001-31448, JP-A-2001-297183, JP-A-2002-108779, and Japanese Patent Application Laid-Open No. 2002-99506.
[0003]
[Problems to be solved by the invention]
According to the above-described related art, the extraction condition item for specifying the destination of the mail is set by the system providing side and is fixed. Therefore, it is necessary for a user who newly introduces the system to set a condition item of a database (DB) as an introduction work, and the load on the user side is large.
Users have a desire to use it as easily as possible. We also want it to be easy to use. One example of answering user needs is that a database held by a user can be used as it is or can be used with few changes.
As mentioned above, it is desirable that the system can be used without changing the environment of the user's system as much as possible or with few changes, and that the selection of the transmission destination or other necessary settings can be performed relatively easily.
[0004]
An object of the present invention is to provide an easy-to-use device or method desired by a user.
[0005]
[Means for Solving the Problems]
The means for solving the above-mentioned problems will be described in detail in the following embodiments of the invention. One of the solutions of the present invention is that an extraction condition for specifying a transmission destination of information or the like or an item to be searched for can be easily set based on a database (DB).
Another solution is that if there is no destination address information in the database (DB), it can be easily added.
Still another solution is to make it possible to easily set conditions for extracting a transmission destination.
Still another solution is to make it possible to easily set conditions for transmission.
[0006]
BEST MODE FOR CARRYING OUT THE INVENTION
FIG. 1 shows an example of the configuration of an information distribution system to which the present invention is applied. The information distribution system shown in FIG. 1 includes a client terminal device 101 operated by a system user, a system server 104, in-house DBs 106 to 108, a system DB 121, a mail server 105, and recipient terminal devices 109 to 111 operated by a mail recipient. Consists of
Here, the information distribution apparatus according to the present embodiment is mounted in the system server 104, and can also have a role as a portal site. The mail server 105 is dynamically connected to the in-house DBs 106 to 108 as described above. Solve the problem. Here, the database, that is, the DB, refers to the in-house DBs 106 to 108 and the system DB 121, and refers to a set of tables including a plurality of items and a set of DBs. Further, in the present embodiment, an explanation will be given by taking a mail as an example, but the present invention can also be applied to the distribution of sound including images, videos, and music, or information combining these. In this case, the client terminal device 101 and the recipient terminal devices 109 to 111 select a browser or a dedicated screen suitable for the information to be distributed by the user or automatically.
[0007]
The client terminal device 101 includes a terminal device 102 operated by an administrator who is a user of the information distribution system and has DB management authority, and a user terminal device 103 operated by a general user without the management authority. You. It should be noted that the administrator terminal device 102 and the user terminal device 103 may be plural.
Here, the user of the information distribution system is composed of an administrator and a user. Of the users of the information distribution system, anyone who has a user ID with management authority can become an administrator using any client terminal device 101, and that user is called an administrator. . Further, among the users of the information distribution system, a person having a user ID without administrative authority is referred to as a user. Further, in the present embodiment, the mail recipient means a destination to which the information distribution device distributes a mail. Of course, it may be bidirectional.
[0008]
The administrator terminal device 102 can access the system server 104 via the line 112 and update the contents of the in-house DBs 106 to 108. The in-house DBs 106 to 108 may exist in the system server 104 or may exist independently.
The system DB 121 is used, for example, when storing data which is determined to be necessary by the system and which is difficult to hold in the in-house DBs 106 to 108.
[0009]
The user terminal device 103 can access the system server 104 and obtain a search result via the line 113. Further, the user terminal device 103 executes, via the line 114, mail distribution with a condition setting described later (e.g., narrowing down a destination to which the mail is distributed by condition extraction and distributing a mail to the destination). it can.
The transmitted mail is delivered from the mail server 105 via the line 118 to the receiver terminal device 109 operated by the mail receiver. Similarly, the mail is delivered to the recipient terminal devices 110 and 111 operated by the mail recipient.
Although the above-described lines 112, 113, 114, and 118 to 120 are shown as dedicated lines, they may be realized by, for example, an IP (Internet Protocol) network or the like.
[0010]
FIG. 13 is a flowchart showing the flow of processing when a general user who does not have administrator authority uses the information distribution system. 2 to 12 show an example of a screen configuration displayed on the user terminal device 103.
Hereinafter, the operation of the embodiment of the present invention will be described in detail with reference to FIGS. 2 to 13 and FIG.
[0011]
The user first opens the initial screen 201 shown in FIG. On the initial screen 201, there are links 202 relating to the concept of the information distribution system, the service menu, and the system configuration and the operating environment. At each link destination, a description of the corresponding content is described.
When using the function related to the mail, the user selects the user function 203 via the user terminal device 103 in step S1302 in the flowchart shown in FIG. When a selection operation is performed here, an end user login screen 301 (step S1303) shown in FIG. 3 is displayed.
[0012]
In the flowchart shown in FIG. 13, in step S1304, the user inputs a user ID and a password in the user ID input area 302 and the password input area 303 using the end user login screen 301 shown in FIG. To start using the system, a login button 304 is selected. To cancel the use and return to the initial screen 201, the user selects the cancel button 305.
If the user selects the log-in button 304 with the wrong user ID or password, the re-login screen shown in FIG. 4 is displayed. In the flowchart shown in FIG. 13, in step S1305, the user uses the re-login screen 401 to enter the user ID and the password again in the user ID input area 402 and the password input area 403. After the input, the user selects the login 404 to start using the system. When the use is interrupted and the screen returns to the initial screen 201, the cancel button 405 is selected.
[0013]
If the login is successful, an extraction condition setting screen shown in FIG. 5 is displayed (step S1306). In the extraction condition setting screen 501, registered extraction conditions are displayed in an array, that is, when there are a plurality of extraction conditions, an extraction condition list 511 in which a plurality of sets of conditions are displayed and a registered condition monitoring distribution information list 512 And are arranged in parallel. In the extraction condition list 511, a list 520 of the titles 504 corresponding to the condition setting is arranged in the row direction for each extraction condition of the other party when the mail is delivered. The column information includes NO, title 504, details 505, and deletion check 506. The extraction condition list 511 has an addition button 502 and a deletion button 503 for adding / deleting to / from the extraction condition list.
In the condition monitoring distribution information list 512, a title, details 513, and a deletion check 506 corresponding to each setting condition for automatically distributing mail at regular intervals are arranged in the same manner as the registered extraction condition list 511. Have been. Further, an add button 507 and a delete button 508 for adding / deleting to the list of condition monitoring distribution information are arranged.
[0014]
In the flowchart shown in FIG. 13, in step S1307, the user operates the user terminal device 103 and selects the addition 502 of the registered extraction condition list. When the selection is made here, a new registration screen of the extraction condition shown in FIG. 6 is displayed (step S1308).
The new registration screen 601 has a registration name and table name setting column 621 and an extraction condition setting column 622. In step S1309, a registration name and a table name are set, and an extraction condition is set. First, an arbitrary name is input to the registered name 602. This registration name is registered in the title list 520 on the extraction condition setting screen shown in FIG.
[0015]
Next, the user selects the table name 603 from the pull-down menu. This table name 603 is the target table for performing the condition extraction. In the setting of the extraction condition, a condition 606 of the data item 604 of the table with respect to the search content 605 is defined.
For example, if the search item 604 is “position”, the search content 605 is “section manager”, and the comparison condition 606 is “over”, the condition is “level is over section manager”. In addition, there are provided definitions for determining the rank of a position, such as “manager”, “section manager”, “section manager”, and “general employee”, and condition extraction is determined according to the rank. FIG. 28 shows a table image of the employee list.
[0016]
In the extraction condition setting column 622, a plurality of conditions can be set by repeating the same operation. In order to increase the number of item rows, select the condition addition 609. To delete an item row, check Delete 607 and select condition delete 610 to delete the row of the checked item. To define a row of items as one condition and connect and define a plurality of conditions, a logical product (and) or a logical sum (or) is selected from the conditions 608. If and, a condition that satisfies both of the adjacent upper and lower conditions is set, and if or, a condition that satisfies one of the conditions is set.
When the user selects the registration 611, the above settings are registered in the information distribution apparatus of the present embodiment, and the registration completion screen 701 of the extracted information shown in FIG. 7 is displayed. Here, by selecting the OK button 702, the screen returns to the extraction condition setting screen 501 shown in FIG. If the cancel button 612 is selected, the above settings are discarded, and the screen returns to the extraction condition setting screen 501 shown in FIG.
[0017]
In the flowchart shown in FIG. 13, it is assumed that the user has selected “registered data 1” (504) on the extraction condition setting screen 501 shown in FIG. 5 in step S1310. At this time, a screen of the selected extraction result is displayed (step S1311). An example of this screen configuration is shown in FIG.
[0018]
An extraction result screen 801 shown in FIG. 8 displays an extraction result 811 corresponding to the selected extraction condition. The list of the extraction results includes a name 802, a mail address 803, and a check box 804 in the column direction, and the extracted records are displayed in the row direction. The initial setting of the check 804 is a check ON. Therefore, it is only necessary to uncheck only the names determined to be unnecessary. The information of the name 802, the mail address 803, and the check column 804 is managed in units of lines, and the display in the line direction increases as the information increases. When the display area becomes full, a scroll bar is displayed, and information can be referred to by scrolling. When the scroll display is performed, the mail transmission button 805 and the close button 806 for performing operations such as mail distribution may be scrolled out. Therefore, the mail transmission button 807 having the same function is provided above the extraction result 811. A close button 808 is arranged for easy use.
If the user clicks on “Sato” of the name 802 in the screen 801 of the selected extraction result shown in FIG. 8, a face photograph 812 of the person may be displayed. For example, when a plurality of names “Sato” appear in the search result, it may be difficult to identify the other party, and in such a case, the other party can be easily confirmed with a face photograph.
[0019]
When a mail transmission button 805 (see FIG. 8) is selected in step S1312, a screen of a mailer used by the user is displayed. An example of the mailer screen is shown in FIG.
The mail address of the record whose check box 804 is checked in the selected extraction result screen 801 (FIG. 8) is displayed in the destination 902 of the mailer screen 901 in FIG. 9 (carbon copy (CC) 903). May be used).
When there are a plurality of checks, each e-mail address is displayed separated by a delimiter symbol such as;. For example, A @ xx. zz and B ＠ xx. zz. A xx. zz; B ＠ xx. zz is set to the destination 902, and the mail is simultaneously delivered to the two destinations when the mail is transmitted.
When the user closes the mailer screen 901, the screen returns to the selected extraction result screen 801 shown in FIG. 8. When the user selects the close button 806, the screen returns to the extraction condition setting screen 501 shown in FIG. 5.
[0020]
The mailer screen 901 is displayed as a separate window in front of the extraction result screen 801 shown in FIG. Thus, if the screen is switched, the mail text can be created on the mailer screen while viewing the extraction result 811.
Also, by setting options, the screen of the mailer can be changed to the WEB screen. In this case, the screen of the mailer is displayed instead of the screen 801 of the extraction result shown in FIG. In this case, since the same WEB screen is used, the operability is unified and the operation becomes easy. In addition, a browser provided by the information distribution system can be selected. In this case, the screen is not displayed in a superimposed manner, but can be embedded in a part of the extraction result 801 or can be used to create a mail text on a screen displayed by switching.
[0021]
In the mailer screen 901, for example, when 20 destinations can be set, if the number of destinations exceeds 20, the information distribution device stores the addresses in another area, and automatically stores the sequentially stored addresses as the destinations. Set with. It is also possible to assign a unique group name to such a set of e-mail addresses and manage transmission of e-mail with such a group name. By performing such a process, the number of destinations is unlimited, and for example, it can withstand mail transmission to a bank customer.
[0022]
On the other hand, it is assumed that, in step S1314 in FIG. 13, the setting change 505 of the row of “registration data 1” (504) on the extraction condition setting screen 501 shown in FIG. 5 is selected. As a result, a screen for changing the extraction condition (not shown) is displayed (step S1315). The processing method in step S1316 is the same as that in step S1309 described above. While step S1309 is additional registration, the processing in step S1316 is change registration processing. The subsequent operation method is the same except that “new registration” on the new extraction condition registration screen 601 shown in FIG. 6 is replaced with “change”.
[0023]
Further, in the flowchart shown in FIG. 13, it is assumed that the user selects the add button 507 of the condition monitoring distribution information list 512 in which the extraction condition setting screen 501 shown in FIG. 5 is registered in step S1317. As a result, the new condition monitoring distribution information registration screens 1001 and 1101 shown in FIGS. 10 and 11 are displayed (step S1318). The new registration screen 1101 is obtained by scrolling the new registration screen 1001 downward.
In the process of step S1319, setting of the registration name and table name and setting of the condition monitoring delivery condition (mail delivery execution condition) are performed using the new condition monitoring delivery information registration screens 1001 and 1101 shown in FIGS. You can set the destination mail address and register the mail contents. Here, the condition monitoring distribution refers to a process of monitoring information distribution execution conditions and performing distribution when the execution conditions are satisfied. Specifically, first, on the new registration screen 1001, the registered name is entered in the registered name 1002. This registered name becomes the title displayed in an array in the title list 521 of the condition monitoring distribution information list 512 registered on the extraction condition setting screen 501 shown in FIG. For example, “test” is entered in the registered name 1002, and when the registration is completed, “test” is displayed in the column of the first row in the title list 521 of the condition monitoring distribution information list 512. In the table name 1003, a table to be searched is selected from a pull-down menu. Next, condition monitoring delivery conditions (mail delivery execution conditions) are set. The condition monitoring delivery condition is a condition serving as a trigger for sending a mail in a function of delivering a mail at a constant interval.
[0024]
In the setting of the condition monitoring distribution condition, a condition 1006 of the data item 1004 of the table with respect to the search content 1005 is defined.
For example, if the search item 1004 is “stock price”, the search content 1005 is “300”, and the comparison condition 1006 is “less”, the condition is “stock price is less than 300”. On this screen, a plurality of conditions can be set by the same operation. In order to increase the number of items, the condition addition 1011 is selected. To define a row of items as one condition and define a plurality of conditions in a concatenated manner, select and or or from the condition 1007. If it is a logical product (and), a condition that satisfies both of the upper and lower adjacent conditions is set. If it is a logical sum (or), a condition that satisfies one of the conditions is set.
FIG. 10 shows an example in which the second search item 1008, the search content 1009, and the comparison condition 1010 are arranged and displayed so that they can be input. Examples of comparison conditions include “greater than”, “greater than or equal to”, “less than or equal to”, “same as”, “different from”, and “smaller”. Further, a table name can be specified on the left side of the condition item 1004. Therefore, it becomes possible to compare the conditions of items between different tables.
[0025]
In the setting of the destination e-mail address, it is possible to register the e-mail address of the person to whom transmission is desired when the condition monitoring distribution conditions (e-mail distribution execution conditions) are satisfied.
For example, when the stock of the product A becomes 10 or less, it can be used when it is desired to notify the person in charge of the order by e-mail. For the destination 0 (1012 in FIG. 10), the destination 1 (1013 in FIG. 10), and the destination 2 (1014 in FIG. 10), in addition to directly specifying the mail address, the extraction condition setting shown in FIG. A title 504 (registered name of the extraction condition) of the extraction condition list 511 registered on the screen 501 can also be specified. For example, when “registered data 1” is set, the partner extracted by “registered data 1”, in the example of FIG. 6, the search item 604, the search content 605, the comparison condition 606, and the deletion check 607 are set as one item. In this case, a search condition composed of two sets of items, that is, a mail is delivered to a partner whose “position” is “section manager” or “more” and whose “id” is “5” or “greater”. If a destination is to be added, selecting the add address button 1015 adds a line to the destination column.
By writing the text in the mail title 1110 and the mail body 1111 in the setting of the mail content displayed by scrolling (see FIG. 11), the mail title and the body of the delivered mail can be set.
[0026]
When a registration button 1112 is selected on the new condition monitoring distribution information registration screen 1101 shown in FIG. 11, the above setting is registered in the information distribution apparatus of the present embodiment, and the completion notification of the condition monitoring distribution information shown in FIG. A screen 1201 is displayed.
By selecting the OK button 1202 on the completion notification screen 1201 shown in FIG. 12, the screen returns to the extraction condition setting screen 501 shown in FIG. When the cancel button 1113 on the new condition monitoring distribution information registration screen 1101 shown in FIG. 11 is selected, the above setting is discarded, and the screen returns to the extraction condition setting screen 501 shown in FIG.
[0027]
For example, in the flowchart illustrated in FIG. 13, it is assumed that the title of the registered condition monitoring distribution information list 512 on the extraction condition setting screen 501 illustrated in FIG. As a result, a condition monitor distribution information change screen (not shown) is displayed (step S1321). Then, in step S1322, the registered name and table name can be changed, the condition monitoring delivery condition (mail delivery execution condition) can be changed, the sending mail address can be changed, and the mail content can be changed.
When the change is performed, for example, the setting change 513 of the row of the row of the test 514 with the title of the registered condition monitoring distribution information list 512 is selected. The content of the process after the selection is exactly the same as the process of step S1319. While step S1319 is a new registration process, step S1322 is a change registration process. Also in this case, the operation method is the same as the new condition monitoring distribution information new registration screens 1001 and 1101 shown in FIGS.
[0028]
Next, processing performed by a client having management authority will be described with reference to FIGS. FIG. 23 is a flowchart illustrating a processing flow when an administrator having administrator authority uses the information distribution system. 14 to 22 show an example of a screen configuration displayed on the administrator terminal device 102. FIG.
Hereinafter, the operation of the information distribution apparatus of the present invention shown in FIGS. 1 and 2 will be described in detail with reference to FIGS.
[0029]
First, the administrator opens an initial screen 201 shown in FIG. The initial screen has a concept, a service menu, and links 202 related to the system configuration and the operating environment. Each link has a description of the corresponding content.
When using the function related to mail, the administrator selects the administrator function 204 by operating the administrator terminal device 102 in step S2302 in the flowchart shown in FIG. As a result, an administrator login screen 1501 (step S2303) shown in FIG. 15 is displayed. In step S2304, the administrator uses the administrator login screen 1501 to enter a user ID and a password in the user ID input area 1502 and the password input area 1503, respectively. To start using the information distribution system, a login button 1504 is selected. When the use is interrupted and the screen returns to the initial screen 201, a cancel button 1505 is selected.
[0030]
When the login button 1504 is selected by mistake in the user ID or password, a screen 1601 for re-login shown in FIG. 16 is displayed.
In the flowchart shown in FIG. 23, in step S2305, the user ID and password are again input to the user ID input area 1602 and the password input area 1603 on the re-login screen 1601. After the input, the user selects the login button 1604 to start using the information distribution system. When the use is interrupted and the screen returns to the initial screen 201, a cancel button 1605 is selected.
[0031]
If the login is successful, a screen 1701 (FIG. 17) of a list of registered tables is displayed (step S2306). On the screen of the list of registered tables shown in FIG. 17, a list 1703 of registered table names is displayed. To register a new table, an add button 1705 is selected. Details will be described later. If the user wants to delete the table, he / she checks the deletion check column 1704 and selects a deletion button 1706. As a result, the checked table is deleted.
[0032]
In step S2307, the administrator operates the administrator terminal device 102 to select one of the table names, for example, the IP address list 1702, on the registered table list screen 1701 shown in FIG. I do. As a result, a table item setting information screen 1801 shown in FIG. 18 is displayed (step S2308).
Here, the selected IP address list is defined as a table display name of the ip table. The item setting information of the ip table is displayed in the list 1821 using the item entity name 1803 as a key. In the list, an item entity name 1803, an item display name 1804, a name 1822, an address 1823, an item conversion rule setting 1808, and a local DB type 1809 are displayed in the column direction.
One line of information is displayed for one item entity, and the information for a plurality of item entities is displayed on a line basis. The item entity name 1803 corresponds to the column name of the table. The item display name 1804 is provided for the user to recognize the column for convenience. The name column 1822 corresponds to a primary key for uniquely identifying a data record. The address column 1823 indicates a column for storing a mail address. Note that the name column 1822 and the address column 1823 are radio buttons, and an item corresponding to the line with the check 1805 or 1806 is selected from the list 1821, and the selected items are respectively named, It can be used as an address.
[0033]
The item conversion rule 1808 is for converting the content of data to be shown to the user for convenience. For example, it is used when a code display is shown in a content display. The local DB type 1809 is used when copying the DB to the client's local environment separately from the in-house DBs 106 to 108 (see FIG. 1) of the information distribution system. To copy the DB to the client's local environment, the administrator selects a “copy to local DB” button 1811. To register the set information, an information registration button 1812 is selected. As a result, the set information is registered in the information distribution system, and the screen returns to the registered table list screen 1701 shown in FIG.
If the administrator selects the cancel button 1813 or the close button 1814, the set information is discarded and the screen returns to the registered table list screen 1701 shown in FIG. If the cancel button 1813 is selected, the settings on the screen 1801 are initialized, and the screen returns to the screen 1701 without registering the setting information. When the close button 1814 is selected, the screen returns to the screen 1701 without registering the setting information while leaving the setting contents on the screen 1801.
[0034]
To execute the item conversion rule in the information distribution system, it is necessary to select the information registration 1812 after checking the check box 1807 of the item conversion rule setting 1808. Note that a plurality of check columns 1807 can be selected. To set a conversion rule, an item conversion rule setting 1808 for an arbitrary one-item entity name is selected in step S2309. As a result, a conversion rule setting screen 1901 shown in FIG. 19 is displayed (step S2310). On the conversion rule setting screen 1901, an item value before conversion (substance value) 1902 and an item value after conversion (display value) 1903 are provided.
[0035]
In step S2311, the administrator can make settings so that the contents of the table are converted and displayed to ordinary users. Further, a specific item can be set to non-display. For example, when the pre-conversion item value 1902 is a gender code of 1 and 2, the post-conversion item value 1903 is changed to “male” for the pre-conversion item value 1902 “1” and the pre-conversion item value 1902 is “2”. On the other hand, if the converted item value 1903 is “female”, the actual data “1” or “2” can be shown to the user as “male” or “female”.
If the user does not want to show the item itself, he checks the non-display 1910. If the column of the conversion item value is not enough, selecting the item addition 1904 adds the column in the row direction. When the information registration 1905 is selected, the setting information is registered in the system, and the screen returns to the table item setting information screen 1801 shown in FIG. If a cancel button 1906 or a close button 1907 is selected, the setting information is discarded, and the screen returns to the table item setting information screen 1801 shown in FIG.
[0036]
In step S2312, the administrator operates the administrator terminal device 102 (see FIG. 1) to select the add button 1705 using the registered table list screen 1701 shown in FIG. As a result, a database registration screen 2001 shown in FIG. 20 is displayed (step S2313).
In step S2314, the user specifies the database 2002, the user ID 2003, and the password 2004, and selects the connection button 2005. When registering a database, a user ID and a password for business management can be prepared in addition to the connection management using the input area of the user ID 2003 and the password 2004 for accessing the database. As a result, database management can be performed in business units.
[0037]
If the cancel button 2006 is selected, the screen returns to the registered table list screen 1701 shown in FIG.
When the connection button 2005 is selected and the connection is successful, a database table list screen 2101 shown in FIG. 21 is displayed (step S2315). A database table list screen 2101 displays a list 2102 of database table names specified in the database 2002 on the database registration screen 2001. When the cancel button 2103 or the “close” button 2104 is selected, the screen returns to the database registration screen 2001 shown in FIG.
The “database” is a data management area including a set of databases and a set of tables. The table is composed of a plurality of items, and holds a plurality of data in the record direction for each item.
[0038]
In step S2316, it is assumed that one table name is selected from the table name list 2102 on the database table list screen 2101 shown in FIG. As a result, the table item setting information screen 2201 is displayed (step S2317). For example, when a property 2105 is selected from the table name list 2102, a property table item setting information screen 2201 shown in FIG. 22 is displayed.
In step S2318, by operating the administrator terminal device 102, each information is set using the table item setting information screen 2201 shown in FIG. 22, and the information registration button 2213 is clicked to transfer the setting contents to the information distribution system. register. The operation method is the same as the operation using the table item setting information screen 1801 shown in FIG. Details are described below.
[0039]
In the table display name 2202 column of the table item setting information screen 2201 shown in FIG. 22, the table name used when registering in the information distribution system is entered. The registered table name is displayed in the table name 1703 column of the registered table list 1701.
The item information setting column 2221 is listed with the item entity name 2203 as a key. In the column list, a plurality of items can be selected in the column direction by an item entity name 2203, an item display name 2204, a name column 2205 which can be selected by a radio box, an address column 2206 which can be selected by a radio box, and a check column 2207. The item conversion rule setting 2208 and the local DB type 2209 are displayed. Here, one line of information is displayed for one item entity, and thereafter, information is displayed for a plurality of item entities in units of rows. The item entity name 2203 corresponds to the column name of the table. The item display name 2204 is provided for the user to recognize the column for convenience. The name column 2205 corresponds to a primary key for uniquely identifying a data record. The address column 2206 indicates a column for storing a mail address.
[0040]
The item conversion rule 2208 is for converting the content of data to be shown to the user for convenience. For example, it is used when a code display is shown in a content display.
The local DB type 2209 is used when copying the DB to the local environment of the client separately from the DB of the information distribution system. To copy the DB to the client's local environment, a “Copy to Local DB” button 2212 is selected. To register the set information, an information registration 2213 is selected. As a result, the set information is registered in the information distribution system, and the screen returns to the database table list screen 2101 shown in FIG. When the cancel button 2214 or the close button 2215 is selected, the set information is discarded, and the screen returns to the database table list screen 2101 shown in FIG.
[0041]
To execute the item conversion rule in the information distribution system, it is necessary to check the check box 2207 and then operate the information registration button 2213.
The conversion rule setting step S is the same as the conversion rule setting step S2311 on the table item setting information screen 1801 shown in FIG.
The address addition table creation button 2211 is used when there is no item for storing a mail address in the user database. By using this function, the mail address information can be added to the existing database information without changing the structure of the currently used database at all.
By operating the address addition table creation button 2211, an item for storing the mail address is apparently created in the last line of the item setting information list 2221. For example, such items as "item entity name is mail_address, item display name is mail address, address is ON" are added.
[0042]
For convenience of the user, the items are displayed in the properties table as if one item has been added, but the substance of the added items is stored in a database (system DB 121) different from the database used by the user (in-house DBs 106 to 108). However, it is also possible to provide a function of adding an item to the properties table itself according to the situation of the user.
[0043]
In the above-described embodiment, as long as there is only a DB and a mail environment compatible with ODBC (Open, DataBase, and Connectivity) that can uniquely identify a partner, mail can be automatically distributed according to search conditions. In this case, even if the mail address column does not exist in the already constructed database, according to the present embodiment, the condition is narrowed down by linking with the primary key that has its own mail address table and can uniquely identify the record. A mail delivery function with functions can be realized, and existing databases can be used effectively.
For example, the above-described function is very useful when an information distribution system in which a new mail address is added is to be constructed, but an existing database cannot be modified.
Even when the mail address is already registered in the in-house DB, the search item can be directly selected from the column of the table in the in-house DB. Therefore, even if the in-house DB is updated, the user of the system can immediately add or change the search item. Therefore, it is not necessary to customize the information distribution system every time the search item is changed, which is very convenient.
[0044]
The above-mentioned function will be described in detail with reference to a flowchart of mail delivery by condition search shown in FIG.
First, in step S2402, it is confirmed whether or not the user environment of the information distribution system includes an execution environment capable of transmitting and receiving mails and the in-house DBs 106 to 108 (see FIG. 1). If not, in step S2403, the user of the information distribution system builds a mail environment and an in-house DB.
Next, in step S2404, it is confirmed whether or not the information of the mail address exists in the in-house DBs 106 to 108. If not (Yes), the information distribution system registers the information of the mail address in the system DB 121 in step S2405. At this time, a link to an item serving as a primary key corresponding to the mail address of the existing in-house DBs 106 to 108 can be designated. Further, depending on the environment of the user's in-house DBs 106 to 108, it is possible to additionally register information of the mail address in the in-house DBs 106 to 108.
[0045]
In step S2406, search conditions for narrowing down the destination of the mail are set. When setting the search condition, the user can directly refer to the item (column or field) information of the table in the database and set the search condition for the item.
When the search condition is set, the mail can be automatically delivered to the destination narrowed down by the condition search by the information delivery system in step S2407. If you do not set search conditions, mail will be delivered to all recipients.
[0046]
Further, according to the present embodiment, for example, when the stock becomes less than 10, it is also very easy to automatically send an e-mail to a related person. In this case, first, a condition monitoring delivery condition (mail delivery execution condition) that the stock is less than 10 is set. The check of the condition monitoring distribution condition can be set to be periodically performed by a timer. That is, a search condition for extracting a related person is separately registered as condition registration 1.
As a result, when the stock becomes less than 10, the condition monitoring / delivery condition is checked, which triggers the condition search and mail distribution processing by the information distribution system of the other party. At the time of mail distribution, a destination can be searched under the conditions specified in the condition registration 1, and mail distribution processing can be performed on the destination. Therefore, in this embodiment, it is guaranteed that the destination of the mail is always based on the latest address data. This is a very useful function when the stakeholders change dynamically and information should not be transmitted to anyone other than the stakeholders.
[0047]
The above-described function will be described with reference to a flowchart of condition search mail distribution based on condition monitoring distribution information setting shown in FIG.
Here, condition monitoring distribution information is set in step S2502. The condition monitoring delivery information includes a mail delivery execution condition (condition monitoring delivery condition) and a DB monitoring time. The mail delivery execution condition (condition monitoring delivery condition) is such that delivery of a mail is performed when the set condition is satisfied. The DB monitoring time is a time interval at which a timer periodically checks whether or not a set mail delivery execution condition is satisfied. For example, when checking whether or not the stock falls below 10 every hour, the mail delivery execution condition (condition monitoring delivery condition) is “whether or not the stock falls below 10” and the DB monitoring time is 1 hour. Become.
[0048]
In step S2503, a mail delivery environment based on a condition search is set. Step S2503 may be before step S2502.
In step S2503, the processing in steps S2402 to S2406 described above is performed. Next, in step S2504, it is determined whether the condition monitoring distribution condition (mail distribution execution condition) is satisfied. If the condition is satisfied, a condition search is performed in step S2505, and the mail is automatically delivered to the narrowed down destination.
[0049]
26 and 27 show examples of a condition setting screen provided with a hierarchical display area adapted to an extraction condition setting screen and a condition monitoring distribution information new registration screen, respectively. The condition setting screen 2600 includes an area 2610 for hierarchically displaying the in-house DBs 106 to 108 (see FIG. 1), an area 2620 for setting an extraction condition expression or a transmission condition expression, a table name, an item name, a data display area 2630, and a keyword. It comprises a search area 2640, a search result area 2650, and an extraction (transmission) condition preview 2660.
[0050]
When using the condition setting screen 2600 by operating the user terminal device 103, the user first uses the area 2610 in which the in-house DBs 106 to 108 are hierarchically displayed.
In the area 2610, a plurality of sets of database names, table names, and item names of the in-house DBs 106 to 108 are hierarchically displayed. For example, the management database 2611 in the area 2610 is a database name, and the table 2612 constituting the database is customer information, personnel information, and inventory management. In addition, items 2613 configuring the inventory management 2615, which is a table, are a product code, a product name, a monthly production number, and a product inventory number. The symbol “+” at the left end means that the component is hidden thereunder, and the symbol “−” means that the component is expanded and displayed thereunder.
When the symbol "+" is clicked, the symbol changes to "-", and the components below it are expanded like inventory management 2615. Clicking on the sign "-" changes the sign to "+" and hides the components below it, like customer information 2614.
The area 2610 in which the in-house DBs 106 to 108 are hierarchically displayed may have a hierarchical structure corresponding to the organization.
[0051]
An area 2620 for setting an extraction condition expression or a transmission condition expression is an extraction condition setting screen 601 shown in FIG. 6 or a condition monitoring distribution condition setting area of a new condition monitoring distribution information registration screen 1001 shown in FIG. Area. For the table name of the extraction (transmission) condition 1, inventory management may be selected from the pull-down menu in the area 2621, or the inventory management 2615 in the area 2610 may be clicked and dragged and dropped in the area 2621. 2621. Similarly, by clicking and dragging the product stock quantity 2616 in the area 2610 and dropping it in the area 2622, the product stock quantity can be set in the area 2622.
You can also click and drag instead of drag and drop. For example, when the user clicks on the inventory management 2615 in the area 2610 and clicks on the area 2612, “inventory management” is set in the area 2621.
[0052]
In the table name, item name, and data display area 2630, the table displayed in the area 2610, its items, and data are displayed.
For example, customer information 2631 can be set by clicking and dragging the customer information 2631 and dropping it in the area 2626. By clicking and dragging Miyagi prefecture 2634 of the data and dropping it in area 2628, Miyagi prefecture can be set in area 2628.
[0053]
In the keyword search area 2640, a table name and an item name can be searched from the item name and the contents of data. For example, when "Miyagi *" is entered in the data area 2641 and the search button 2627 is pressed, a character string including the character string "Miyagi" at the beginning is searched from the database. The search result is displayed in search result area 2650. The display format is, for example, a table name / item name. In the search result area 2650 of FIG. 26, for example, the display format is displayed as “customer information / customer address” 2651. The extracted item names can be set in the extraction condition area by drag and drop. For example, by clicking and dragging “customer information / customer address” 2651 in search result area 2650 and dropping it in area 2627 of area 2620 for setting an extraction condition expression, the customer address is stored in area 2627 and the customer information is stored in area 2626. Is set.
To check the validity of the set extraction condition expression (transmission condition expression), the user clicks an extraction (transmission) condition preview 2601. As a result, the search result is displayed on preview screen 2660. Therefore, it is possible to set a conditional expression while confirming that expected data is included. This is convenient because errors in conditional expressions can be prevented.
[0054]
Here, FIG. 29 shows a partial configuration of the system server 104 shown in FIG. The internal configuration of the information distribution device of the present embodiment will be described with reference to FIG.
Specifically, the blocks shown below are constituted by a CPU serving as a control center of the system server 104 and a peripheral LSI including a memory. The CPU reads out programs recorded in the memory and sequentially executes the programs, thereby having the blocks. The function is realized.
More specifically, the information distribution device of the present embodiment includes a communication interface unit 141, a DB structure disclosure unit 142, an information distribution unit with destination extraction conditions 143, and an information distribution execution condition monitoring unit 144. In the figure, blocks denoted by the same reference numerals as those in FIG. 1 are the same as those shown in FIG.
[0055]
The communication interface unit 141 manages an interface with the connected client terminal device 101. Here, since the communication interface unit 141 is connected via the network networks 112 and 113, for example, TCP / IP (Transmission / Control / Protocol / Internet / Protocol). Is implemented.
The DB structure publishing unit 142 provides the user with information based on the DB registration information generated by the administrator having the authority to manage the in-house DBs 106 to 108 operating the administrator terminal device 102, which is one of the client terminal devices 101. In order to permit the reference of the in-house DBs 106 to 108, a function of disclosing the DB structures of the DBs 106 to 108 is provided. Note that the DB registration information includes, for example, information set in the table list in FIG. 17, the table list 1821 in FIG. 18, the item information setting column 2221 in FIG. 22, and the like.
[0056]
The information delivery unit with destination extraction condition 143 is based on the disclosed DB structure and according to the extraction condition setting information generated when the user operates the user terminal device 103 which is one of the client terminal devices 101. In addition, it has a function of performing a search of the in-house DBs 106 to 108 to which reference is permitted by the DB structure disclosure unit 142, and delivering predetermined information to a destination corresponding to the search result. The extraction condition setting information is information set by the title 504 shown in FIG. 5, or the search item 604, the search content 605, the comparison condition 606, and the like shown in FIG.
Further, the information distribution execution condition monitoring unit 144 monitors the information distribution execution condition based on the information distribution execution condition setting information generated by operating the user terminal device 103 by the user, and the condition is satisfied. Sometimes, it has a function of instructing the information distribution unit with destination extraction condition 143 to deliver predetermined information to the destination corresponding to the search result. Here, it is called condition monitoring distribution because it has a function as a trigger for performing distribution. Information distribution execution condition setting information sets conditions for executing distribution of information including mail.
[0057]
As described above, in the present embodiment, the automatic extraction and setting of the destination of the e-mail are performed easily and quickly without changing the user's environment as much as possible. The mail service is performed by extracting a trusted user from the credit rating data as a condition, so that the trusted user can be enclosed. In addition, real estate intermediary services such as providing real estate-related information to these users can be performed to differentiate them from other banks.
[0058]
The procedure executed by each of the communication interface unit 141, the DB structure disclosure unit 142, the information distribution unit with destination extraction condition 143, and the information distribution condition monitoring unit 144 shown in FIG. 29 is recorded on a computer-readable recording medium. By causing a computer system to read and execute the program recorded on the recording medium, the information distribution device of the present embodiment is realized. Here, the computer system includes an OS and hardware such as peripheral devices.
[0059]
The “computer system” also includes a homepage providing environment (or a display environment) if a WWW system is used.
Further, the above program may be transmitted from a computer system storing the program in a storage device or the like to another computer system via a transmission medium or by a transmission wave in the transmission medium. Here, the “transmission medium” for transmitting a program refers to a medium having a function of transmitting information, such as a network (communication network) such as the Internet or a communication line (communication line) such as a telephone line.
[0060]
The present invention can be widely applied without being limited to the above embodiment.
Based on the above invention, the following applications can be considered.
For example, the automatic delivery function to the condition search destination of the present invention can be used as follows in a regular health examination operation. First, in a guidance work for a regular medical checkup, it can be used for a work of automatically distributing a guidance notice of a designated medical institution according to age and work location. For example, a list of medical institutions that can receive a medical examination can be sorted and contacted by prefecture where the medical examination applicant works. Further, when the subject and fee for examination differ depending on the age of the examinee, appropriate information can be transmitted to each recipient by extracting conditions. In the case where the contents of consultation differ for each business unit or organization, it is convenient to use the condition setting from the information of the hierarchical structure shown in FIG. 26 in the condition setting of automatic mail delivery to the condition search destination.
[0061]
Further, after the health check is performed, it can be used for a task of delivering an e-mail such as a notification of a result of the health check according to the diagnostic level of the health check. Further, by using the condition monitoring distribution function of the present invention, the following processing can be performed. Employees who have received a re-examination warning and who have not been re-examined will receive periodic e-mail recommendations using the system's condition monitoring and distribution function. By using this function, it is not necessary for the general affairs bureau to urge the person who is subjected to the reexamination many times. In addition, it is not necessary to forget to prompt a retest. Since the person in charge of general affairs does not prompt the person to re-examine, the mental load on the person in charge of general affairs can be reduced. In addition, the access right to the database storing the diagnosis results can be given only to employees with limited administrative affairs.
[0062]
In the real estate brokerage business, the embodiment of the present invention can be used as follows. The conditions of a real estate property include area, rent, floor plan, equipment, lease period, and the like. For a real estate agency, if there is a property that satisfies these conditions, it is difficult to communicate appropriate information to the applicant (customer) properly if the conditions are complicated or there are many applicants. It is. In such a case, using the automatic distribution function to the condition search destination and the condition monitoring distribution function of the present invention becomes very convenient. For example, the above information of the real estate, the desired conditions of the customer, and the mail address of the customer are registered in the system. The customer's requirements are set as conditions for the condition monitoring delivery function, and mail is automatically delivered to the other party within a certain period. Customers with the same requirement may be recognized as the same group by the condition retrieval function. For example, the registered extraction condition list of FIG. 6 may be given a title such as “A condition occupancy applicant”, and customers having the same occupancy condition may be grouped. When the occupancy applicant who has received the notification contacts the real estate agent and decides to move in, it is only necessary to update the database of real estate information. If the timer setting of the condition monitoring distribution function is set to 24 hours and the e-mail is automatically transmitted during non-business hours, there is no need to worry about double booking.
[0063]
The embodiment of the present invention can be used as follows when requesting a loan from a financial institution. When a user wants to perform a renovation, the user requests an estimate to some renovation companies. At this time, an automatic distribution function to condition search destinations is utilized based on database information held by the user. For example, a mail is sent to a renovation company that satisfies the conditions desired by the user, such as a standard remodeling fee, company capital, and a basic service menu. When the user obtains an estimate response from the company, the information such as the estimated amount and the company name is registered in a database owned by the user. Based on the registration information, contact a financial institution considered to be financing possible. A financial institution considered to be capable of lending is selected by utilizing an automatic distribution function to a condition search destination based on a lending limit held by a user and information on a company having a transaction. In addition, select a candidate from there and contact him by email. In addition, based on the customer information, the financial institution uses the information on the customer's deposit balance, loan balance, annual income, occupation, desired business, etc. to notify the desired customer of the loan limit and provide information such as business opportunities, etc. This can be realized by using the condition monitoring distribution function. By providing such information, a financial institution can increase financing opportunities and acquire customers.
[0064]
The embodiment of the present invention can be used as follows in outbound such as solicitation of a mortgage loan or the like. Financial institutions actively discuss marketing methods for general customers. Generally, the customer management DB includes detailed personal data such as periodic expiration information and family structure. Specific examples are as follows. "｛Address = Sendai City｝ & ｛Gender = other than unknown｝ & ｛Accident information = none｝ &｛Age> 20｝ & ｛Occupation = Yes｝ & ｛Annual income> 4 million｝ & ｛Marriage = Marriage｝ Loan application = none｝ & ｛Loan balance <1 million｝ & シ ス テ ム system registration of the present invention = yes｝ ”. A direct mail can be sent to a person who meets this condition (the logical product of the conditions described in 用 い) using the automatic delivery function to the condition search destination of the present invention to promote customer acquisition activities.
[0065]
The following shows an application example of the embodiment of the present invention to a system having a function of registering a Web site or a database.
In advance notice of the departure time of the transportation, the embodiment of the present invention can be used as follows. In conjunction with a database that manages the departure and arrival of operating companies such as JR, private railways, buses, airlines, and ships, for example, specify 10 minutes before the bus that the user gets on, and the two buses where the user gets on When arriving at the previous bus stop, the operating company notifies the user of the e-mail. It is assumed that a bus company has introduced the implementation method of the present invention and provides services as part of a measure to improve the convenience of bus users, and the following will specifically explain. Mr. A often works until the last hour, but he always misses and frequently returns home by taxi. To improve this wasteful situation, use the service provided by the bus company. Based on the information in this DB, when the bus arrives two stops before from the nearest bus stop, Mr. A's mobile phone Send an e-mail to, and set up conditions for condition monitoring distribution to inform you that the bus is coming soon. Then, even if the bus arrives late due to weather or congestion, it can be expected to get on without waiting at the bus stop.
In addition, by making the same setting, it is possible to watch the television at leisure in the morning without having to wait at the bus stop, which is liable to be delayed due to congestion in the morning, and to walk to the bus stop when a mobile mail is received. In a typhoon or a cold place in the northern country, there is no need to wait while shaking. The situation of waiting at a bus stop is no longer present, and potential users can be guided to the bus.
[0066]
In the business matching of the transportation industry, the embodiment of the present invention can be used as follows. Long haul trucks often return empty (empty) when carrying luggage, which is not good for the environment. Therefore, a site for business matching in the transportation industry (or a group for exchanging e-mails) was built, and the driver (owner and destination), the installed capacity and conditions (e.g. Enter your e-mail address. On the other hand, the client uses the automatic distribution function to the condition search destination to distribute mail to a driver who satisfies the conditions by using the transport destination as a key and establish a business. As a similar business model, taxis do not always find customers immediately when they reach their destination. Therefore, if the above-mentioned site is provided and the conditions of the client and the taxi driver are satisfied, a service that discounts from the normal fare can be considered.
[0067]
The following shows an application example of the embodiment of the present invention to a system using a web site.
In business matching for financial institutions, embodiments of the present invention can be used as follows. As a part of customer enclosing, BtoB (Businessesto Business) between customers is provided using the method of the present invention. In the customer DB, rating information and other credit information held by the bank, business types and mail addresses are stored. If a customer is considering purchasing real estate, access the bank's site and use the search function of the automatic distribution function to the condition search destination of the present invention, and search for "real estate business" and the desired condition using the key Then, for the obtained e-mail address, the estimating conditions and the like are entered, and the transmission and negotiation are performed to establish a business. The above model has been implemented on many sites, but in the case of financial institutions, customers can be authenticated with their own credit information, and if there is a bankruptcy, etc., the use can be stopped immediately and a high creditworthy market is formed be able to.
[0068]
In the notification of recruiting information (utilization in Hello Work), the embodiment of the present invention can be used as follows. The recruiting agency matches the recruiting information of the company with the information of the applicant for employment by using the condition monitoring distribution function, and periodically sends the information to both parties by e-mail. If the company has introduced this system, the information sent by e-mail is registered in the in-house database, and by using the automatic distribution function to the condition search destination, the personnel who match the conditions are further searched as recruitment candidates. , You will be able to contact us by email.
[0069]
【The invention's effect】
According to the present invention, it is possible to provide a device or a method that is easy for a user to use in transmitting information by e-mail or the like.
The following are examples of specific embodiments. It is easy to select a destination. Further, it is easy to use a database already used as a database used for selection. Further, it is easy to set conditions for determining the transmission time. Since the administrator can determine the database that is permitted to be used, the database can be used with security from the viewpoint of security. In addition, there are various specific effects in the above embodiment.
[Brief description of the drawings]
FIG. 1 is a diagram showing an example of a system configuration of an information distribution system to which the present invention is applied.
FIG. 2 is a diagram showing an example of a screen configuration used in the embodiment of the present invention, and shows a system initial screen.
FIG. 3 is a diagram illustrating an example of a screen configuration used in the embodiment of the present invention, and illustrates an end-user login screen.
FIG. 4 is a diagram showing an example of a screen configuration used in the embodiment of the present invention, showing an end-user re-login screen.
FIG. 5 is a diagram showing an example of a screen configuration used in the embodiment of the present invention, and shows a setting screen of an extraction condition.
FIG. 6 is a diagram illustrating an example of a screen configuration used in the embodiment of the present invention, and illustrates a new registration screen of an extraction condition.
FIG. 7 is a diagram illustrating an example of a screen configuration used in the embodiment of the present invention, and illustrates a completion notification screen.
FIG. 8 is a diagram showing an example of a screen configuration used in the embodiment of the present invention, and shows a screen of a selected extraction result.
FIG. 9 is a diagram illustrating an example of a screen configuration used in the embodiment of the present invention, and illustrates a screen of a mailer to which a destination is set.
FIG. 10 is a diagram illustrating an example of a screen configuration used in the embodiment of the present invention, and illustrates a new registration screen of condition monitoring distribution information.
FIG. 11 is a diagram showing an example of a screen configuration used in the embodiment of the present invention, and shows a new registration screen for condition monitoring distribution information.
FIG. 12 is a diagram illustrating an example of a screen configuration used in the embodiment of the present invention, and illustrates a completion notification screen.
FIG. 13 is a flowchart of a user function cited for explaining the operation of the embodiment of the present invention.
FIG. 14 is a diagram showing an example of a screen configuration used in the embodiment of the present invention, and shows a system initial screen.
FIG. 15 is a diagram illustrating an example of a screen configuration used in the embodiment of the present invention, and illustrates an administrator login screen.
FIG. 16 is a diagram showing an example of a screen configuration used in the embodiment of the present invention, and shows an administrator re-login screen.
FIG. 17 is a diagram showing an example of a screen configuration used in the embodiment of the present invention, showing a screen of a list of registered tables.
FIG. 18 is a diagram showing an example of a screen configuration used in the embodiment of the present invention, and shows a table item setting information screen.
FIG. 19 is a diagram showing an example of a screen configuration used in the embodiment of the present invention, and shows a conversion rule setting screen.
FIG. 20 is a diagram showing an example of a screen configuration used in the embodiment of the present invention, and shows a database registration screen.
FIG. 21 is a diagram illustrating an example of a screen configuration used in the embodiment of the present invention, and illustrates a screen of a database table list.
FIG. 22 is a diagram illustrating an example of a screen configuration used in the embodiment of the present invention, and illustrates a table item setting information screen.
FIG. 23 is a diagram cited for explaining the operation of the embodiment of the present invention and is a flowchart of an administrator function.
FIG. 24 is a diagram cited for describing the operation of the embodiment of the present invention, and is a flowchart of mail delivery by condition search.
FIG. 25 is a diagram cited for explaining the operation of the embodiment of the present invention, and is a flowchart of condition search mail distribution by setting condition monitoring distribution information.
FIG. 26 is a diagram showing an example of a screen configuration used in the embodiment of the present invention, showing a condition setting screen provided with a hierarchical display area adapted to an extraction condition setting screen.
FIG. 27 is a diagram showing an example of a screen configuration used in the embodiment of the present invention, and shows a condition setting screen provided with a hierarchical display area adapted to a new registration screen of condition monitoring distribution information.
FIG. 28 is a diagram cited for describing the operation of the embodiment of the present invention, and is a diagram illustrating an example of a table image.
FIG. 29 is a block diagram showing the internal configuration of the information distribution device of the present invention by developing the function;
[Explanation of symbols]
101 client terminal device, 102 administrator terminal device, 103 user terminal device, 104 system server, 105 mail server, 106 (107, 108) in-house database (DB), 109 (110, 111) ... Receiver terminal device, 121: system DB, 112 (113, 114, 118, 119, 120): communication network, 141: communication interface unit, 142: DB structure disclosure unit, 143: information delivery unit with destination extraction condition, 144: Information distribution condition monitoring unit

Claims (12)

An information distribution device having a database connected to a client terminal device via a communication network,
In order to allow the user to refer to the database based on database registration information generated by an administrator having the management authority of the database operating an administrator terminal device that is one of the client terminal devices. Database structure publishing means for publishing the structure of the database,
Based on the structure of the published database, according to the extraction condition setting information generated by the user operating the user terminal device as one of the client terminal devices, the search of the database permitted to be referred to, An information distribution means with a destination extraction condition for delivering predetermined information to a destination corresponding to the search result;
An information distribution device comprising: Based on information distribution execution condition setting information generated by a user operating the user terminal device, the information distribution execution condition is monitored, and when the execution condition is satisfied, the information distribution with the destination extraction condition is performed. Information delivery execution condition monitoring means for instructing means to deliver predetermined information to a destination corresponding to the search result;
The information distribution device according to claim 1, further comprising: An information distribution method for identifying a destination by distributing information by searching a database which is a set of tables including a plurality of items,
Reference to the database is allowed based on information generated by the administrator operating the administrator terminal device,
Based on the information generated by the user operating the user terminal device, a condition search is performed according to the tables and items of the database permitted to be referred to, and as a result of the condition search, information is delivered to the specified destination. To do,
An information distribution method characterized by the following. An information distribution method for identifying a destination by distributing information by searching a database which is a set of tables including a plurality of items,
The administrator operates the administrator terminal device to permit reference to the database and register a distribution destination,
Based on the information generated by the user operating the user terminal device, a condition search is performed in accordance with the tables and items of the database permitted to be referred to, and as a result of the condition search, the information is registered to the specified destination. Distributing information based on the distribution destination
An information distribution method characterized by the following. An information distribution method for specifying a destination by distributing predetermined information by searching a database which is a set of tables including a plurality of items,
Reference to the database is allowed based on information generated by the administrator operating the administrator terminal device,
Based on information generated by the user operating the user terminal device, distributing the information to the destination according to the table and the item of the database permitted to be referred to,
An information distribution method characterized by the following. An information distribution method for specifying a destination by distributing predetermined information by searching a database which is a set of tables including a plurality of items,
Permission of reference to the database based on information generated by the administrator operating the administrator terminal device, and register the distribution destination,
Distributing information to an address corresponding to a registered distribution destination, based on information generated by a user operating a user terminal device, according to tables and items of a database permitted to be referred to;
An information distribution method characterized by the following. An information distribution method for transmitting predetermined contents to a destination when specific data in a database meets certain conditions,
Reference to the database is allowed based on information generated by the administrator operating the administrator terminal device,
When the user operates the user terminal device, the user terminal device specifies data including a determination item to be used for determining whether or not the condition of the specific data in the database permitted to be referred to is satisfied. A screen for setting the above conditions is displayed,
A judgment item, a comparison condition, and a reference item for judging the condition are inputted through the screen to judge whether or not the condition is satisfied, and a predetermined content is determined based on the satisfaction of the condition. Sending to
An information distribution method characterized by the following. An information distribution method for distributing information input to a selected destination,
A plurality of destinations constitute a target for performing the condition extraction, and a plurality of sets of the target for performing the condition extraction are recorded in a database,
A search permission target is input from the target extraction target set,
When the user operates the user terminal, a screen for selecting a target for performing the condition extraction used for selecting the transmission destination is displayed, and the screen for selecting the condition for which the selection is permitted is displayed on the screen. Is displayed, and a specific target is designated from among the targets for performing the condition extraction displayed through the screen,
Further, a selection condition for selecting the transmission destination is input via the screen, and a search based on the selection condition is performed on a target for performing the specified condition extraction, and a transmission destination address is selected. Distributing the entered content to the selected transmission address,
An information distribution method characterized by the following. An information distribution method of selecting a destination of the input information and transmitting the information to the selected destination,
A plurality of destinations constitute a target for performing the condition extraction, and the target for performing the condition extraction is recorded in a database,
When the user operates the user terminal device, a screen for selecting an object for performing the condition extraction used for selecting the transmission destination is displayed, and the condition extraction for which the selection is permitted is performed on the screen. The target is displayed in a plurality of sets hierarchically, and the target to be used is specified from among the targets for performing the condition extraction of the hierarchical state displayed via the screen,
Further, a selection condition for selecting the transmission destination is input via the screen, and a search based on the selection condition is performed on a target for performing the specified condition extraction, and a transmission destination address is selected. Distributing the entered content to the selected transmission address,
An information distribution method characterized by the following. An information distribution method for selecting a transmission destination of input information and distributing the information to the selected transmission destination,
A plurality of destinations constitute a target for performing the condition extraction, and a plurality of sets of the target for performing the condition extraction are recorded in a database,
By operating the user terminal device by the user, a screen for selecting a target for performing the condition extraction used for selecting a destination is displayed, and a target for performing the condition extraction is designated via the screen,
Further, a selection condition for selecting the transmission destination is input via the screen, and a search based on the selection condition is performed on a target for performing the specified condition extraction, and a transmission destination address is selected. Distributing the entered content to the selected transmission address,
An information distribution method characterized by the following. A computer program for information distribution used in an information distribution device having a database connected to a client terminal device via a communication network,
In order to allow the user to refer to the database based on database registration information generated by an administrator having the management authority of the database operating an administrator terminal device that is one of the client terminal devices. A database structure publishing procedure for publishing the structure of the database,
Based on the structure of the published database, according to the extraction condition setting information generated by the user operating the user terminal device as one of the client terminal devices, the search of the database permitted to be referred to, An information delivery procedure with a destination extraction condition for delivering predetermined information to the destination corresponding to the search result;
A computer program that causes a computer to execute. Based on the information distribution execution condition setting information generated by the user operating the user terminal, the information distribution execution condition is monitored, and when the execution condition is satisfied, the destination corresponding to the search result is sent to the destination. An information distribution execution condition monitoring procedure for instructing distribution of predetermined information,
The computer program according to claim 11, which causes a computer to execute the following.

Images