JPH07101400B2 - Database management system - Google Patents

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database management system capable of increasing the maximum number of access terminals to a database and allowing overseas database access without using a special line.

[0002]

2. Description of the Related Art As a conventional database management system, there is, for example, "Information Processing Handbook" edited by Information Processing Society of Japan, published by Ohmsha (196-236, 966-1,000). As described here, conventionally, when a database of a database management system is accessed from the terminal side, it is performed by time-division control of a computer.

[0003]

Therefore, in the conventional database management system, the number of installed terminals is uniquely limited by the capability of the computer. Further, since it is necessary to connect from the terminal to the computer online, there is a problem that a high-quality line is basically required for each terminal for accessing the database overseas.

[0004]

The present invention has been made in view of the above, and is connected to a LAN in order to increase the number of connection terminals and to enable access to a database overseas without providing a special line. The present invention provides a database management system adapted to access a database management device via an electronic mail system. You
In other words, in order to solve the above problems,
Local area network 5 to which computer 3 is connected
And connected to the local area network 5,
Electronic for exchanging messages between the terminal computers 3
Connect to the mail system 2 and the electronic mail system 2
Database based on database operating instructions
With a database management device 1 for accessing
The database management system, the e-mail system 2
Or the e-mail system 2 and database management
It is provided between the device 1 and the terminal computer 3
A message addressed to the received database management device 1 is received.
The operation instructions of the database included in the sage
Control means 4 for sending to the base management device 1 for execution,
Installed in the e-mail system 2, the database
Response message to the sender including the output information from the management device 1.
Create a sage as a reply mail and
A reply means 22 for replying to the data 3 is provided.

[0005]

The database management system according to the present invention will be described in detail below. FIG. 1 shows an embodiment of the present invention.
The database management system of the present invention includes a database management device 1 in which a database is stored and which can be accessed from the outside, an electronic mail system 2 including a user side program for exchanging messages with a user,
A terminal computer 3 that executes a user-side program of the system 2, a control computer 4 that manages each of the database management device 1 and the electronic mail system 2, and a LAN (connects each of the electronic mail system 2 and the terminal computer 3). Local Area Network) 5
It is composed of

The database management device 1 comprises a database management system program, and is composed of a CPU, a memory, a disk device, etc. for executing the program.

The electronic mail system 2 is composed of a mail system management section 21 and a computer 22. The mail system management unit 21 manages a directory called a mailbox of each registered user, receives a message file from the terminal computer used by each user, and sends the mail of the addressed user in the message file. A computer for storing and managing a mail system having a server program for storing a message file in a box and transmitting a message file addressed to a user requested by a reception request from the terminal computer 3 to the terminal computer 3 which responds. It is configured with. On the other hand, the computer 22 is provided with a user program for transmitting / receiving a message created by the terminal computer 3 used by each user to / from the server program of the mail system management unit 21, and is composed of a CPU and a memory. There is.

In the message of the mail system management section 21, for example, the following keywords are provided. Match: age ≤ 12, age ≥ 65; (Records whose age field value is 12 or less, 65 or more) Add: Name ← "Kame", Age ← 28 ,; (Create a new record and name it Kame, Age 28: Delete: Height ≤ 148, Blood = AB; (Delete Height field is 148 or less, Blood field is AB) Count: Name = "* a *";("a" in Name field Count the number of records with, * is a wild card) Such a keyword is used to operate the database when the user composes a message to access the database by the user side program of the electronic mail system 2. Is.

Furthermore, the required number of terminal computers 3 is L.
It is connected to the AN 5 and has a function of executing a program on the user side of the electronic mail system 2, and comprises a CPU, a memory, a disk device, a display device and the like. There is a temporary user name in the email system 2.
The attached mailbox for the database management device 1
It is provided. In the above configuration, the user
The user name that was temporarily assigned to the database management device 1
A message containing the desired database operation details you wrote
To the electronic mail system 2. The transmitted content is received by the electronic mail system 2, and the received message is moved to the database management apparatus mailbox to which the temporary user name of the database management apparatus 1 is added . On the other hand, the computer 22 of the electronic mail system 2 checks the mailbox at regular time intervals (short cycle time) according to the user program ,
If there is a message in the mailbox, it communicates with the mail system management unit 21 and receives the message. Computer
When 22 messages for the database management device 1 is received, the control computer 4 which manages the user program in the computer 22, whether contains the keyword in the said message <br/> di Check. Control if it contains keywords
The computer 4 checks whether the operation for the keyword is correct . If it is determined to be correct,
The control computer 4 instructs the database management device 1 to perform an operation corresponding to the keyword (for example, match
→ Search, Add → Add, etc.) That is,
The electronic mail system 2 and the database management device 1
Between the control means consisting of a control computer
4 is provided to receive from the terminal computer 3
Message addressed to the database management device 1
Operation instructions of the database included in the database
To the management device for execution. Database database above
The database is accessed based on the operation information from the processing device 1.
Set. As a result, it is output from the database management device 1.
The output database is the control computer 4
Is passed to the temporary mail user program of the computer 22 of the electronic mail system 2 via. The electronic mail system 2 creates a reply to the user (sender) and sends it to the sender as a combined message of the outputs from the database management device 1. That is, the electron
The mail system 2 has a reply means including a computer 22.
From the database management device 1
Reply email with reply message to sender including output information
And sends it back to the sender terminal computer 3.
Although the control computer 4 and the computer 22 are separately configured for the database management device 1, they may be executed as parallel processes on one computer.

[0010]

As described above, according to the database management system of the present invention, the electronic mail system is used to access the database management device.
The maximum number of terminals that can access the database can be dramatically increased. Further, as long as the e-mail can be used, the database can be accessed from any place inside or outside the country without the need to install a new line.

[Brief description of drawings]

FIG. 1 is a block diagram showing an embodiment of the present invention.

[Explanation of symbols]

1 ... Database management device, 2 ... E-mail system, 3 ... Terminal computer, 4 ... Control computer,

Claims (1)

[Claims] A local area network 1. A plurality of terminal computers are connected, the connected to a local area network, an electronic mail system for exchanging messages between the terminal computer, is connected before Symbol email system , Database manipulation
A database that accesses the database based on the work instructions.
It is a database management system equipped with
In the e-mail system or in the e-mail system
The terminal provided between the database and the database management device.
The database management device received from the computer
The operating finger of the database included in the addressed message
Control to send the instructions to the database management device for execution.
Control means and a response message to the sender that is provided in the electronic mail system and includes output information from the database management device.
The terminal computer that created the message as a reply mail and sent it
A database management system , comprising: a reply means for replying to .