JPH08307450A - Mail transmission and reception system for data base system - Google Patents

Abstract

PURPOSE: To automatically produce the requested electronic mails to be processed and also to retrieve these mails at both transmission and reception sides by providing a mail transmission part within a data base management host to produce and transmit the electronic mails and also providing a dealing request register part and a mail reception part at every terminal. CONSTITUTION: The request data given from a processing request register part 11a of a terminal 11 are registered into a data base 23 of a data base management host 24. The electronic mails are produced at a mail transmission part 24b of a dealing procedure management data base system 24a and sent and stored into a mail box 25 of a mail management host 26. Then the box 25 is retrieved and the mails are received at a mail reception part 21b of the corresponding terminal 21. In such a constitution, the electronic mails are automatically produced, transmitted, retrieved and received. Therefore, the burden of a mail dealer is reduced and also the circuit availability is improved.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a mail transmission / reception system of a database system, and more particularly to a form in which a database for managing office work procedures is accessed from individual terminals connected by a local area network (LAN). Database sending and receiving system of mail.

As the scope of application of the database system expands and the scale increases, the number of people who access the database increases. Therefore, in office work,
Items to be requested to other persons such as a request for processing to a person in charge of processing and a request for approval processing for processing contents increase. For this reason, there is a need for a mechanism to smoothly carry out the requested items. In addition, since the load on the network or the database management host increases due to the increase in the number of accesses due to the large scale of the database system, it has been demanded to reduce the load on the network and the database management host.

[0003]

2. Description of the Related Art FIG. 14 is a conceptual diagram of a conventional system.
The office management system is connected to a plurality of treatment departments 10 and a management department 20 that manages the treatment departments 10 via a network 1. In the treatment section 10, a terminal 11 is composed of a treatment person terminal operated by the treatment person and a person in charge of the person in charge. Reference numeral 13 is a mailbox for storing the contents of electronic mail, and 14 is a mail management host for managing electronic mail sent via the network 1. As the mailbox 13, for example, a disk device or the like is used.

In the management department 20, reference numeral 21 denotes a terminal, which comprises a database administrator terminal operated by a database administrator and an overall administrator terminal operated by an overall administrator who is responsible for processing the entire system. Reference numeral 23 denotes a database for storing treatment procedure management data, 24 denotes a database management host for managing the database 23, 2
5 is a mailbox for storing the contents of the email, 26
Is a mail management host that manages electronic mail sent via the network 1.

In the system thus constructed,
When a request for a treatment is made by e-mail from the person in charge of treatment 11, the content is the mailbox 13 or 25 of the other party.
Stored in. The person in charge confirms the content of the e-mail received by himself by reading the e-mail in the mailbox. The content of the electronic mail that has reached itself is displayed on the display unit of the terminal 11.

Further, the necessary information can be registered in the database 23 in the management section 20 from the terminal 11 for the person in charge of treatment. In this case, when the registration process is instructed from the person in charge of treatment 11, the database management host 24 accepts the registration content and registers it in the database 23. Thus, in the conventional system, it is possible to send and receive electronic mail between the terminals.

Here, consider the case of requesting a person in charge of a certain treatment or approval work. FIG. 15 is a diagram showing a processing flow of the conventional system. The same parts as those in FIG. 14 are designated by the same reference numerals. The solid arrows in the figure indicate the flow of processing.
The dashed arrow indicates database access. In the figure, reference numeral 24a denotes a procedure management database system for managing the database 23, which is a database management host 24.
It is provided inside. 23 in the database 23
Reference numeral a is a detailed content storage unit for storing details of processing, and reference numeral 23b is a treatment staff list.

In the processing shown in the figure, when requesting a certain procedure or approval work to another person in charge, the request destination and detailed contents are managed by the database 23 on the database management host 24 provided in the management department 20. It is like this. Upon receiving the treatment request from the database administrator terminal 21, the general manager terminal 21 requests the treatment department manager terminal 11 in the treatment department 10 for the treatment.

The terminal person in charge of treatment department 11 requests the terminal for treatment staff 11 for treatment. The person in charge of treatment 11 processes the treatment and requests the result of treatment to the terminal in charge of treatment department 11 for approval. The terminal person in charge of treatment department 11 who has received the approval request notifies the terminal 21 in charge of overall approval of the approval request. Upon receipt of the approval request, the general manager terminal 21 registers it in the database 23. When rejecting a treatment request in each section of these treatment requests, the treatment or approval is rejected.

In the flow of these processes, a treatment request or an approval request is first registered in the detailed content storage section 23a of the database 23 and the person in charge of treatment 23b, and the next person in charge accesses the database 23 to take action. Knowing that there is a request or approval request, the next person in charge will be notified by performing the same operation. That is, in the conventional system, each person in charge takes an indirect notification method of accessing the database 23 to know that there is a treatment request or approval request addressed to himself.

FIG. 16 is a diagram for explaining the operation of the conventional system. The same parts as those in FIG. 14 are designated by the same reference numerals.
In this case, the person who requests processing (treatment requester) is the terminal 11
The procedure request content is registered in the database 23 by the user, and a person who is requested to process the content (requestee of the procedure) accesses the database 23 from the terminal to know the processing content. The contents of the treatment request issued from the treatment requester terminal 11 enter the treatment procedure management database system 24a of the database management host 24 via the network 1.

The treatment procedure management database system 24
a registers the received treatment request content in the database 23. At the same time, the treatment requester sends a processing request e-mail to the mail management host 26, and stores the request contents in the general manager's mailbox 25a. The person to be treated (herein the general manager) searches the database 23 from the terminal 21 to see if there is any treatment request content addressed to him. If there is a treatment request addressed to you,
The general manager can access the mailbox 25a in which the electronic mail addressed to himself is stored from the terminal 21, recognize that there is a notification addressed to him, and display it on the display to know the contents. it can. If you approve the content,
The approval is registered in the database 23.

When sending an electronic mail from the terminal 11 to another terminal 11, the electronic mail is stored in the personal mailbox 25b, and each terminal 11 accesses the personal mailbox 25b to send it to itself. You can refer to the e-mail.

In such a conventional system, in fact,
In order to know whether the treatment-requested person is requested to perform the processing, the treatment-requested person himself / herself searches the database 23, or the treatment-requested person uses a telephone contact using the telephone 2 or a transmission means such as an electronic mail. There was a need. When notifying the treatment request by e-mail, the e-mail requesting the treatment is sent from the terminal 11 to the mail box 25a for the general manager and registered, and the general manager mails from the terminal 21 as necessary. Will be read to know the details of the treatment request.

[0015]

As described above, in the conventional database system, in the information transmission in which the person in charge requests the processing, grasps the situation, etc., the person in charge of the person himself or herself makes a mistake in the processing, an error, etc. May occur. Also, as the scale of the database increases, the amount of information increases, and the person in charge of transmitting information cannot be ignored.

In addition, the person to be treated himself / herself is in the database 2
In the method of accessing No. 3, it is necessary to access and search the database 23 even if there is no treatment request, the processing amount of the entire network increases, the processing capacity other than the database access decreases, and the load of the database management host 24 is increased. However, there is a problem in that the processing speed decreases, the processing speed decreases, and resources such as memory become insufficient.

The present invention has been made in view of the above problems, and it is possible to prevent processing delays and errors, reduce the information transmission labor of a person in charge, improve the processing capacity of the entire network, and make a database. It is an object of the present invention to provide a mail transmission / reception system of a database system that can reduce the load on the management host and improve the processing capacity.

[0018]

FIG. 1 is a block diagram showing the principle of the present invention. The same parts as those in FIG. 16 are designated by the same reference numerals. The system shown in the figure constitutes a database system in which a plurality of terminals 11 (or 21) and a database management host 24 are connected via a network 1 and messages are exchanged between the terminals 11 (or terminals 21). The terminals include a terminal 11 provided in the treatment department 10 and a terminal 21 provided in the management department 20, but any of these terminals may be used. The configuration is the same.

In the database management host 24, 23 is a database for storing various information (particularly a processing procedure management database), and 24b is a database 2
A mail sending unit that reads out the information in 3 to create an e-mail and sends the created e-mail, and is provided in the treatment procedure management database system 24a. The database 23 includes a registration content storage unit 23 that stores registration content.
a (the same as the detailed content storage unit 23a described above), a mail processing information storage unit 23c that stores mail processing information, and a user address information storage unit 2 that stores user address information.
It is composed of 3d.

In the terminal 11 (or 21), 1
1a (21a) is a treatment request registration unit that registers a treatment request in the database management host 24, 11b (21b) is a mail reception unit that receives an electronic mail transmitted from the database management host 24, and 11c (21c) is various types. It is a display unit for displaying information. The display section 11c (21c)
For example, a CRT is used. Reference numeral 26 is a mail management host, and 25 is a mailbox provided in the mail management host 26.

In this case, when the person in charge registers the name of the person in charge to be registered next from the terminal 11 and requests the database management host 24 to perform the next process, the database management host 24 sends the mail according to the registered contents. Based on the processing information and the user address information, it is possible to create an e-mail notifying the terminal of the next person in charge that the treatment has been requested and send it from the mail transmission unit 24b to the treatment requestee. Is preferable for surely notifying.

When the registered contents are changed from the terminal 11 to the database 23, the database management host 24 notifies the changed contents based on the mail processing information and the user address information that the notification is necessary. It is preferable that the e-mail is created based on the above decision, and the e-mail is sent to the person in charge from the mail sending unit 24b in order to surely notify the person concerned of the changed contents.

If the registered contents and status of the database 23 satisfy the conditions registered in the database 23 in advance, the database management host 24 notifies the person in charge of the terminal registered in advance of that fact. It is preferable to create an electronic mail for performing the above and send it from the mail sending unit 24b in order to surely notify the person in charge of necessary information.

If the contents registered in the database 23 are left untreated for a certain period or longer, the database management host 24 creates an e-mail for notifying an alarm, It is preferable to send the mail from the mail sending unit 24b to the terminal of the person in charge of the treatment request in order to prompt the treatment and effectively use the resources.

Further, the database management host 24
Can send a list of contents registered in the database 23 to the preset person in charge as an e-mail from the mail sending unit 24b at regular intervals.
It is preferable to surely notify the person in charge of the list of registered contents.

On the side of the terminal 11 (or 21),
When the e-mail is received by the mail receiving unit 11b (or 21b), the receiving side searches the contents to be registered or updated or deleted according to the contents of the e-mail, and the processing screen is displayed on the display unit 11c (or 21c). In order to speed up the process, it is preferable to display and display the state where registration, update, or deletion is performed immediately.

On the side of the terminal 11 (or 21),
When the above e-mail is received, it is preferable to immediately display the reference data necessary for registration, update or deletion on the display unit 11c (or 21c) in order to speed up the process.

On the side of the terminal 11 (or 21),
When the above e-mail is received, it is preferable to immediately display the database processing screen on the display unit 11c (or 21c) in order to speed up the processing.

On the side of the terminal 11 (or 21),
When a plurality of e-mails are received, it is preferable to provide a means for sequentially performing the e-mails in order to surely perform all the processes.

Further, on the side of the terminal 11 (or 21),
When receiving the above-mentioned e-mail and performing the registration process for the contents of the e-mail, if detailed information is required, the detailed information screen to be displayed is previously displayed at the same time as the database processing screen of the display unit 11c (or 21c) is displayed. It is preferable to be able to set it in order to speed up the process.

[0031]

In the database management host 24, a mail sending unit 24b for reading the information in the database 23 to create an electronic mail and sending the created electronic mail is provided.
On the other hand, in the terminal 11, the database management host 2
A mail receiving unit for receiving the electronic mail transmitted from No. 4 is provided. Then, the treatment request is registered in the database 23 from the terminal 11. On the database management host 24 side,
The mail transmission unit 24b reads the stored contents of the registration contents storage unit 23a, the storage contents of the mail processing information storage unit 23c, and the necessary contents from the user address information storage unit 23d to create an e-mail requesting treatment, and stores them in the mailbox 25. Send an e-mail with the details of the treatment request and store it.

The person to be treated, when the terminal 21 is activated,
The mail receiving unit 21b can search the mail box 25 and recognize whether or not the processing request content addressed to itself has arrived. As a result, an e-mail requesting treatment can be automatically created and sent to the terminal in charge, reducing the information transmission effort of the person in charge, improving the processing capacity of the entire network, and burdening the database management host. Can be reduced to improve the processing capacity.

In this case, when the person in charge registers the name of the person in charge to be registered next from the terminal 11 and requests the database management host 24 to perform the next process, the database management host 24 sends the mail according to the registered contents. Based on the processing information and the user address information, an e-mail for notifying the terminal of the next person in charge that the treatment has been requested is created and transmitted from the mail transmission unit 24b, thereby requesting the treatment requestee to perform the treatment. Can be reliably notified.

When the registered contents are changed from the terminal 11 to the database 23, the database management host 24 notifies the changed contents based on the mail processing information and the user address information that the notification is necessary. By making a decision to create an e-mail and sending it to the person in charge from the mail sending unit 24b, it is possible to reliably notify the person concerned of the changed content.

If the registered contents and status of the database 23 satisfy the conditions registered in the database 23 in advance, the database management host 24 notifies the person in charge of the terminal registered in advance of that fact. By creating an electronic mail for performing the above and transmitting it from the mail transmitting unit 24b, it is possible to reliably notify the person in charge of necessary information.

If the contents registered in the database 23 are left untreated for a certain period of time or longer, the database management host 24 creates an e-mail for notifying an alarm, By transmitting from the mail transmission unit 24b to the terminal of the person in charge of treatment, the treatment can be promoted and the resources can be effectively used.

Further, the database management host 24
Sends a list of registered contents to the person in charge by sending a list of contents registered in the database 23 to the preset person in charge as an e-mail from the mail transmitting unit 24b. I can tell you for sure.

On the side of the terminal 11 (or 21),
When the e-mail is received by the mail receiving unit 11b (or 21b), the receiving side searches the contents to be registered or updated or deleted according to the contents of the e-mail, and the processing screen is displayed on the display unit 11c (or 21c). It is possible to speed up the process by displaying and displaying the state in which registration, update, or deletion is performed immediately.

On the side of the terminal 11 (or 21),
When the above e-mail is received, the display unit 11c (or 21c) can immediately display the reference data necessary for registration, update, or deletion, thereby speeding up the process.

On the side of the terminal 11 (or 21),
When the above e-mail is received, the display unit 11c (21
By immediately displaying the database processing screen in c), the processing speed can be increased.

On the side of the terminal 11 (or 21),
When a plurality of e-mails are received, a means for sequentially performing the e-mails can be provided so that all the e-mails can be surely taken.

Further, on the side of the terminal 11 (or 21),
When receiving the above-mentioned e-mail and performing the registration process for the contents of the e-mail, if detailed information is required, the detailed information screen to be displayed is set in advance at the same time as the database processing screen of the display unit 11c (21c) is displayed. By making it possible, the processing speed can be increased.

[0043]

Embodiments of the present invention will be described below in detail with reference to the drawings. FIG. 2 is an operation explanatory diagram of one embodiment of the mail transmitting side. The same parts as those in FIGS. 1 and 16 are designated by the same reference numerals. In FIG. 2, reference numeral 24c is a registration processing unit provided in the treatment procedure management database system 24a. In the database 23, 32 is a transmission processing table provided in the mail processing information storage section 23c, 33
Is a mail address table provided in the user address information storage unit 23d. Reference numeral 25a is a general manager's mailbox, and 25b is a personal mailbox.

In the mail sending unit 24b, 30 is a mail editing processing unit for performing a mail editing process, and 31 is a mail sending processing unit for performing a mail sending process. Reference numeral 34 denotes an edit processing unit that performs an electronic mail edit process in response to a request from the mail edit processing unit 30, and reference numeral 35 denotes an edit result file that stores the edit process result.

In the system thus constructed,
When the treatment request registration is performed from the treatment request registration unit 11a (see FIG. 1) of the terminal 11, the treatment request registration enters the treatment procedure management database system 24a, and the registration processing unit 24c.
Stores the treatment request in the registered content storage unit 23a. In the mail transmission unit 24b, the mail edit processing unit 30 reads the contents of the registered contents storage unit 23a and creates an electronic mail,
The destination is determined from the mail address table 33 and the transmission processing table 32, and the electronic mail is transmitted from the mail transmission processing unit 31 to the network 1. The sent e-mail is stored in the mail box 25a or 25b in the mail management host 26.

At this time, the edit processing unit 34 stores the transmission result in the edit result file 35. According to this embodiment,
When the person in charge registers the name of the person in charge to be registered next from the terminal 11 and requests the database management host 24 to perform the next process, the database management host 24 stores the mail processing information and the user address information according to the registered contents. Based on this, by creating an e-mail notifying that the treatment has been requested to the terminal of the next person in charge and transmitting the e-mail from the mail transmitting unit 24b, the treatment requestee can be surely notified of the treatment request. it can.

FIG. 3 is a diagram for explaining the operation of one embodiment of the mail receiving side. The same parts as those in FIGS. 1 and 2 are designated by the same reference numerals. In the figure, 37 is a personal work data file provided in the database management host 24, which has a stack menu storage unit 37a and a search data storage unit 37b therein. 36 is a search data storage unit 37
This is a search processing unit that searches for b. In the mail processing information storage unit 23c, 38 is a reception processing table that stores reception processing.

On the terminal 21 side, the mail receiving section 21b
From the received e-mail and the reception processing table 38,
Stack menu registration unit 40 for creating a stack menu for sequentially activating a series of processes to be performed when receiving
And a work table creation unit 41 that activates the search processing unit 36 necessary in advance for processing, and a stack menu execution unit 42 that actually activates the stack menu. Reference numeral 43 is a menu display data file in which menu display data is stored.

In the system thus constructed,
When the electronic mail is sent from the mail management host 26, the stack menu registration unit 40 sequentially activates a series of processes to be performed when receiving from the received electronic mail and the reception processing table 38. On the other hand, the work table creating unit 41 has a search processing unit 36 which is necessary in advance for performing the processing.
And the search processing unit 36 causes the search data storage unit 37 to
The data necessary for performing the processing by searching b is searched.

Then, the stack menu execution unit 42
The stack menu is activated, and the data stored in the menu display data file 43 and the content of the received electronic mail are displayed on the display unit 21c. According to this embodiment, by providing the work table creating unit 41 and the stack menu registering unit 40, it is possible to automate the process performed on the received electronic mail. As a result, it is possible to reliably notify the treatment requestee of the treatment request.

FIG. 4 is an explanatory view of the mail transmission operation, showing the operation of the mail edit processing section 30. The same parts as those in FIG. 2 are designated by the same reference numerals. The mail transmission unit 24b is
As described above, the mail edit processing unit 30 and the mail transmission processing unit 31 are included. The mail edit processing unit 30 edits the contents of the electronic mail based on the contents stored in the registered contents storage unit 23a and the mail processing information stored in the mail processing information storage unit 23c.

The mail edit processing section 30 refers to the transmission processing table 32 based on the processing content. In the transmission processing table 32, the processing contents, the name of the editing processing program for editing the contents of the mail with respect to the processing contents, the start parameters for starting the editing processing program, the transmission destination, the transmission conditions, etc. Is remembered. The mail edit processing unit 30 activates the edit processing unit 34 based on these values.

The edit processing section 34 executes, for example, an edit processing program. The edit processing unit 34 edits the content of the electronic mail from the start parameter and the registered content, and stores it in the edit result file 35. The content of the electronic mail stored in the edit result file 35 is read by the mail edit processing unit 30 and then stored in the mailbox 25 in the mail management host 26 from the mail transmission processing unit 31.

FIG. 5 is another explanatory diagram of the mail transmission operation, showing the operation of the mail transmission processing section 31. The same parts as those in FIGS. 2 and 4 are designated by the same reference numerals. The mail transmission processing unit 31 is activated by the mail editing processing unit 30 with the processing content as a parameter. Then, first, the transmission destination and the transmission condition are obtained from the transmission processing table 32 based on the processing content.
Whether the transmission conditions are met for the destination,
Check the registration details. As a result of the check, when the transmission condition is satisfied, the content of the electronic mail stored in the edit result file 35 is transmitted to the address of the mailbox 25 shown in the mail address table 33. According to this embodiment, the person in charge can be surely notified of necessary information.

FIG. 6 is a diagram for explaining the operation of the stack menu registration section. The same parts as those in FIG. 3 are designated by the same reference numerals. The stack menu registration unit 40 is activated when the terminal 21 accesses the database 23 that stores the processing procedure management data. And mailbox 25
A display screen name, a display type, and a treatment completion condition are obtained from the contents of the self-addressed electronic mail stored in the device and the contents of the reception processing table 38, and registered in the stack menu storage unit 37a assigned to each user. To do.

The work table creating section 41 searches in advance for information necessary for the processing to be performed when the electronic mail is received, and associates the search data with the stack menu storage section 37a so that the processing can be performed immediately when the stack menu is executed. Keep it.

As described above, on the terminal 21 side (or 11 side), when an electronic mail is received by the mail receiving section 21b, the contents to be registered, updated, or deleted are retrieved by the receiving side according to the contents of the electronic mail. By displaying the processing screen on the display unit 21c and immediately registering or updating or deleting the processing screen, the processing speed can be increased.

On the terminal 21 side (or 11 side), when the electronic mail is received, the display unit 21c (or 11c) immediately displays the reference data necessary for registration, update or deletion. The processing speed can be increased.

On the terminal 21 side (or 11 side), when an electronic mail is received, the database processing screen is immediately displayed on the display section 21c (or 11c), so that the processing speed can be increased. .

FIG. 7 is a diagram for explaining the operation of the work table creating section. The same parts as those in FIG. 6 are designated by the same reference numerals. The work table creation unit 41 uses the reception processing table 3
8, the program name and the starting parameter of the search processing unit 39 corresponding to the contents of the electronic mail are obtained, and the search processing unit 39 is obtained.
To start. Then, the search result of the search processing unit 39 is registered in the registration search data storage unit 37b and the reference search data storage unit 37c of the personal work data file 37.
Then, these registration data are stored in the stack menu storage unit 3
Corresponds to 7a. Stack menu execution unit 42
Is executed from the person-in-charge terminal 11 and executes the stack menu created by receiving the email.

FIG. 8 is an operation explanatory diagram of the stack menu execution unit. The same parts as those in FIG. 7 are designated by the same reference numerals. The stack menu execution unit 42 reads the display screen name, the display type, the processing completion condition, and the search data corresponding to the display screen name stored in the stack menu storage unit 37a. The display data that is the main body of the display screen is
It is stored in the menu display data file 43,
The screen display data corresponding to the display screen name is read from the menu display data file 43 and displayed on the display unit 21c.

FIG. 9 is a diagram showing an execution example of the stack menu. As the stack menu, a reference screen A, a registration screen B, a registration screen C, and a registration screen D are displayed as display screens.
There is. There are simultaneous and sequential display types. First, when execution of the stack menu is started, the reference screen A and the registration screen B are simultaneously activated, and both screens are displayed (). That is, the first reference screen A is displayed first, but if the display types are the same, the next screen, the registration screen B, is also unconditionally displayed. When the end condition (XX registration) is satisfied by the operation after the screen is displayed,
The reference screen A and the registration screen B are deleted from the stack menu.

Next, after the reference screen A and the registration screen B are completed,
Since the display types are sequential, after the previous screen ends, the next screen, the registration screen C, is displayed (). In the case of the registration screen C, if nothing is registered and the process ends, that is, if the end condition is not satisfied, the stack screen remains in the stack menu (displayed at the next startup).

10 to 13 are operation explanatory views of another embodiment of the present invention. In the embodiment shown in FIG. 10, the next person in charge makes a treatment request. When the person in charge of the treatment department registers the person in charge of treatment (), a treatment request mail is sent to the person in charge of treatment (). When the person in charge of treatment receives the treatment request, the person in charge of treatment displays a registration screen and performs a predetermined treatment.

In this case, when the person in charge registers the name of the person in charge who should register next from the terminal 11 and requests the database management host 24 for the next processing, the database management host 24 processes the mail according to the registered contents. Based on the information and the user address information, an e-mail for notifying the terminal of the next person in charge that the treatment has been requested is created and transmitted from the mail transmission unit 24b, thereby requesting the treatment requestee to perform the treatment. You can be sure to notify.

The embodiment shown in FIG. 11 is for notifying the changed contents to the affected places, and is the case where the general manager changes (corrects) the registered contents. When the general manager corrects the registered contents (), the database management host 24
For the changed content, based on the mail processing information and the user address information, the range required to be notified is determined, an electronic mail is created, and a correction notification mail is sent to the person in charge. This makes it possible to notify the person in charge of the details of the change.

In this embodiment, the change mail is sent from the general manager to the department manager in charge of the procedure and the person in charge of the procedure.
If you add the condition "registered person in charge" as a transmission condition, it will not be sent to unregistered treatment personnel (
mark).

The embodiment shown in FIG. 12 notifies a certain treatment that all the treatments have been completed. The general manager notifies the person in charge of all treatment departments of the treatment completion notice. The person in charge of each treatment section registers the treatment approval () and sends a treatment completion confirmation mail to the general manager (). Upon receipt of the treatment completion confirmation mail, the general manager displays the treatment list reference screen and the treatment end registration screen, and sends a mail notification when the overall treatment approval is completed.

In the embodiment shown in FIG. 13, the database 23
When the contents registered in (1) are not treated for a certain period of time, an e-mail for notifying an alarm is created and transmitted from the mail transmission unit to the terminal of the person in charge of treatment. When the person in charge of the treatment department makes a treatment request to the person in charge of treatment, the monitoring unit 24f of the treatment procedure management database system 24a monitors the registration status of the database ().

When no treatment is performed for a certain period (for example, one month) or more, an alarm mail is sent to the person in charge of the treatment department (). Upon receipt of this alarm mail, the person in charge of treatment notifies the person in charge of treatment of a reminder to take action (). According to this embodiment, it is possible to effectively use the resources by urging the person in charge of treatment to perform the treatment.

Further, the database management host 24
Can send a list of contents registered in the database 23 to the preset person in charge as an electronic mail from the mail sending unit 24b at regular intervals. According to this, the person in charge can be surely notified of the list of registered contents.

On the side of the terminal 11 (or 21),
When the e-mail is received by the e-mail receiving unit 11b (or 21b), the receiving side searches the contents to be registered, updated, or deleted according to the contents of the e-mail, and the processing screen is displayed on the display unit 11c (or 21c). By doing so, it is possible to immediately enter the state of registering, updating or deleting. As a result, the processing speed can be increased.

On the side of the terminal 11 (or 21),
When the e-mail is received, the display unit 11c (or 21
It is possible to immediately display the reference data necessary for registering, updating or deleting in c). As a result, the processing speed can be increased.

On the side of the terminal 11 (or 21),
When the e-mail is received, the display unit 11c (or 21
The database processing screen can be immediately displayed in c). As a result, the processing speed can be increased.

On the side of the terminal 11 (or 21),
When a plurality of e-mails are received, it is possible to provide a means for sequentially performing the measures for the e-mails.
This ensures that all treatments can be performed.

Furthermore, on the side of the terminal 11 (or 21),
When receiving the e-mail and performing the registration process for the contents of the e-mail, if detailed information is required, the detailed information screen to be displayed is preset at the same time as the database processing screen of the display unit 11c (or 21c) is displayed. can do. Thereby, the processing can be speeded up.

[0077]

As described above in detail, according to the present invention, in the database management host, there is provided a mail sending unit for reading information in the database to create an electronic mail and sending the created electronic mail. On the other hand, in the terminal, a mail receiving unit for receiving an electronic mail sent from the database management host is provided, and the treatment request is registered in the database from the terminal. Creates an e-mail requesting processing by reading the required contents from the storage contents of the storage unit, the storage contents of the mail processing information storage unit, and the user address information storage unit, and sending and storing the e-mail of the treatment request contents in the mailbox. In addition, when the terminal is activated, the recipient receives a search for the mailbox in the email receiver and By recognizing whether you are,
An e-mail requesting treatment can be automatically created and sent to the terminal in charge, reducing the information transmission work of the person in charge, improving the processing capacity of the entire network, and reducing the burden on the database management host. Processing capacity can be improved.

In this case, when the person in charge registers the name of the person in charge to be registered next from the terminal and requests the database management host to perform the next process, the database management host stores the mail processing information in accordance with the registered contents. Based on the user address information, create an e-mail to notify the terminal of the next person in charge that the treatment has been requested and send it from the mail sending unit, so that the treatment requestee is notified of the treatment request. can do.

When the registered contents are changed from the terminal to the database, the database management host judges the necessary range of the changed contents based on the mail processing information and the user address information. By making an e-mail by using the e-mail and sending the e-mail to the person in charge from the e-mail transmission unit, it is possible to reliably notify the person concerned of the changed content.

If the registered contents and status of the database satisfy the conditions registered in the database in advance, the database management host notifies the person in charge of the terminal registered in advance to that effect. By creating an email and sending it from the email sending unit, it is possible to reliably notify the person in charge of necessary information.

If the contents registered in the database are left untreated for a certain period of time or longer, the database management host creates an e-mail notifying the alarm and requests the treatment. By sending from the mail sending unit to the terminal of the person in charge, it is possible to prompt treatment and effectively use the resources.

Further, the database management host sends a list of contents registered in the database to the preset person in charge as an e-mail from the mail transmission section at regular intervals to register the database. The person in charge can be surely notified of the list of contents.

On the side of the terminal, when the e-mail is received by the mail receiving section, the receiving side searches for the content to be registered, updated or deleted according to the content of the e-mail, and the processing screen is displayed on the display section. It is possible to speed up the process by displaying and displaying the state in which registration, update, or deletion is performed immediately.

On the terminal side, when the above-mentioned e-mail is received, the reference data necessary for registration, update or deletion can be immediately displayed on the display unit to speed up the process. .

On the side of the terminal, when the above-mentioned e-mail is received, the processing speed can be increased by immediately displaying the database processing screen on the display section. Further, on the side of the terminal, when a plurality of e-mails are received, by providing a means for sequentially performing the e-mails, it is possible to surely perform all the measures.

Further, on the side of the terminal, when the above-mentioned electronic mail is received and the registration processing for the contents of the mail is performed, if detailed information is required, the details to be displayed at the same time as the display of the database processing screen of the display unit. By enabling the information screen to be preset, the processing can be sped up.

As described above, according to the present invention, it is possible to prevent processing delay and error, reduce the information transmission labor of the person in charge, improve the processing capability of the entire network, and reduce the load on the database management host. Thus, it is possible to provide a mail transmission / reception system of a database system capable of improving processing capacity.

[Brief description of drawings]

FIG. 1 is a principle block diagram of the present invention.

FIG. 2 is an operation explanatory diagram of an embodiment of a mail transmitting side.

FIG. 3 is an operation explanatory diagram of an example of a mail receiving side.

FIG. 4 is an explanatory diagram of a mail transmission operation.

FIG. 5 is another explanatory diagram of the mail transmission operation.

FIG. 6 is an operation explanatory diagram of a stack menu registration unit.

FIG. 7 is an operation explanatory diagram of a work table creation unit.

FIG. 8 is an operation explanatory diagram of a stack menu execution unit.

FIG. 9 is a diagram illustrating an execution example of a stack menu.

FIG. 10 is an operation explanatory diagram of another embodiment of the present invention.

FIG. 11 is an operation explanatory diagram of another embodiment of the present invention.

FIG. 12 is an operation explanatory diagram of another embodiment of the present invention.

FIG. 13 is an operation explanatory diagram of another embodiment of the present invention.

FIG. 14 is a conceptual diagram of a conventional system.

FIG. 15 is a diagram showing a processing flow of a conventional system.

FIG. 16 is an explanatory diagram of the operation of the conventional system.

[Explanation of symbols]

 11 terminal 11a treatment request registration unit 11b mail reception unit 11c display unit 21 terminal 21a treatment request registration unit 21b mail reception unit 21c display unit 23 database 23a registration content storage unit 23c mail processing information storage unit 23d user address information storage unit 24 database management Host 24a Treatment procedure management database system 24b Mail transmitter 25 Mailbox 26 Mail management host

 ─────────────────────────────────────────────────── ─── Continuation of the front page (72) Inventor Tokiko Kawagoe 3-9-18 Shin-Yokohama, Kohoku-ku, Yokohama-shi, Kanagawa Fujitsu Communication Systems Limited (72) Inventor Yuki Mochida 3 Shin-Yokohama, Kohoku-ku, Yokohama, Kanagawa 9-9-18 Fujitsu Communication Systems Limited (72) Inventor Hiroyuki Amata 3-9-18 Shin-Yokohama, Kohoku Ward, Yokohama City, Kanagawa Prefecture Fujitsu Communication Systems Limited

Claims (11)

[Claims] 1. A database system in which a plurality of terminals and a database management host are connected via a network and messages are exchanged between the terminals, a database storing various information in the database management host, and the database. A mail sending unit for reading the information in the inside to create an electronic mail and sending the created electronic mail is provided, and in the terminal, a treatment request registration unit for registering a treatment request in the database management host, and the database management host A mail transmission / reception system of a database system, comprising a mail reception unit for receiving an electronic mail to be transmitted. 2. When the person in charge registers the name of the person in charge to be registered next from the terminal and requests the database management host for the next processing, the database management host, in accordance with the registered contents, sends the mail processing information and the user address. 2. The mail sending / receiving system of the database system according to claim 1, wherein an electronic mail for notifying that the next person in charge is requested to take a treatment is created based on the information and sent from the mail sending unit. . 3. When the registered contents are changed from the terminal to the database, the database management host judges the necessary range for the changed contents based on the mail processing information and the user address information. The mail transmitting / receiving system of the database system according to claim 1, wherein the electronic mail is created by the electronic mail, and the electronic mail is sent to the person in charge from the mail sending unit. 4. The registered contents and status of the database are
When the conditions registered in the database in advance are satisfied, the database management host creates an e-mail notifying the person in charge of the terminal registered in advance and sends it from the mail transmission unit. The mail sending / receiving system of the database system according to claim 1. 5. When the contents registered in the database are left without any action for a certain period or longer, the database management host creates an email notifying an alarm and requests the action. The mail sending / receiving system of the database system according to claim 1, wherein the mail is sent from the mail sending unit to a person in charge. 6. The database management host sends a list of contents registered in the database as an electronic mail from a mail sending unit to a preset person in charge at regular intervals. The mail transmission / reception system of the database system according to claim 1. 7. When the e-mail is received by the mail receiving unit on the terminal side, the receiving side searches for contents to be registered, updated or deleted according to the contents of the e-mail, and a processing screen is displayed on the display unit. 7. The mail transmission / reception system of the database system according to claim 2, wherein the mail is displayed and brought into a state of immediately registering, updating or deleting. 8. The terminal side, when receiving the e-mail, immediately displays the reference data necessary for registering, updating, or deleting on the display unit. An e-mail sending and receiving system of the database system described in Crab. 9. The mail transmission / reception system of the database system according to claim 2, wherein the terminal side immediately displays the database processing screen on the display unit when the electronic mail is received. . 10. The database system according to claim 2, wherein the terminal side is provided with means for sequentially performing a procedure for the electronic mails when a plurality of electronic mails are received. Mail sending / receiving system. 11. When the terminal side receives the e-mail and performs registration processing for the contents of the e-mail, detailed information to be displayed at the same time when the database processing screen of the display unit is displayed when detailed information is required. 7. The mail transmission / reception system of the database system according to claim 2, wherein the information screen can be set in advance.