JP2002073612A - Server device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a server device that permits a database operation from a terminal in which a browser is not installed. SOLUTION: This server device S is provided with a mail robot command database 21 where a predetermined e-mail address is registered as a command for a database operation, a mail server 22 for having a mail allocation routine 221 which receives e-mail through the Internet N and interprets a command corresponding to the e-mail, a database operation processing part 23 for performing operation processing of data to a business database DB1 on the basis of the command interpreted by the server 22, and a mail database 24 where a database operation ID and password are registered, which are needed at the time when a contracted user or a general user allowed by the contracted user to operate the database DB1 requests an operation of the database DB1.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] The present invention relates to a server device that operates in cooperation with a database.

[0002]

2. Description of the Related Art For example, a server operating in cooperation with a database is provided by the Internet or a LAN (Local Area Network).
For example, data is read from a database or registered in a database from a terminal connected to the network via a server device from a terminal connected to the network. In order to perform such database operations from the terminal, a browser must be installed on the terminal, and terminals for which the browser is not installed cannot send commands for database operations to the server device. Currently, it is not possible to perform database processing.

[0003] Therefore, an object of the present invention is to provide a server device that enables a database operation from a terminal on which a browser is not installed.

[0004]

Means for Solving the Problems and Effects of the Invention According to the first aspect of the present invention, there is provided a server apparatus which is placed on a network (N) and operates in cooperation with a database (DB1). (S) a mail command database (21) in which a predetermined e-mail address is registered as a command for operating the database
Mail address interpreting means for receiving an e-mail addressed to the predetermined e-mail address transmitted from a user via a network and interpreting a command corresponding to the e-mail by referring to the e-mail command database 221) and a database operation processing means (23) for performing database operation processing based on the command interpreted by the mail address interpretation means.

[0005] Alphanumeric characters in parentheses indicate corresponding components in the embodiment described later. Hereinafter, the same applies in this section. According to the present invention, the operation of the database can be performed by sending an e-mail to a command address corresponding to the contents to be operated. Therefore, the database can be operated even from a terminal such as a mobile phone in which a browser is not installed.

According to a second aspect of the present invention, there is provided a mail database (24) in which a database operation ID and a password required for requesting a database operation are registered.
In response to receiving the e-mail addressed to the predetermined e-mail address, a means (1) for transmitting a user authentication screen (40) requesting input of a database operation ID and a password to the terminal of the mail transmission source via the network.
1, 12, 13) and whether or not the sender of the e-mail is a person who is permitted to operate the database based on the registered contents of the mail database and the database operation ID and password entered on the user authentication screen 2. The server device according to claim 1, further comprising means (24) for performing authentication of (1).

According to the present invention, it is possible to prevent a person other than a person who is permitted to operate the database from operating the database. According to a fourth aspect of the present invention, there is provided a computer-readable recording medium recording a program executed by a server device (S), which is a computer which is placed on a network (N) and operates in cooperation with a database, Using a mail command database (21) in which a predetermined e-mail address is registered as a command for operating the database, receiving an e-mail addressed to the predetermined e-mail address transmitted from a user via a network, A program for causing the server device to execute a mail address interpretation process for interpreting a command corresponding to the electronic mail by referring to the command database and a database operation process based on the command interpreted by the mail address interpretation process. It is recorded with a recording medium.

By executing the program recorded on the recording medium by a computer, the same effect as the first aspect of the present invention can be obtained. The recording medium is a CD-ROM or FD (floppy disk)
Or a hard disk placed on a network. Preferably, the program further causes the server device to execute a process of forming a mail command database in a storage area on a storage medium accessible by the server device. .

According to a sixth aspect of the present invention, the program further uses a mail database (24) in which a database operation ID and a password necessary for requesting a database operation are registered, and the program is addressed to the predetermined e-mail address. Sending a user authentication screen requesting the input of a database operation ID and a password to the terminal of the mail transmission source via the network in response to the reception of the e-mail, and the registered contents of the mail database and the user authentication On the basis of the database operation ID and the password input on the screen, the server device further executes a process of authenticating whether or not the sender of the e-mail is a person permitted to operate the database. The recording medium according to claim 4 or 5, wherein It is.

By executing the program recorded on the recording medium by a computer, the same effect as the second aspect of the present invention can be obtained. As described in claims 3 and 7, the database operation processing includes searching for data registered in the database, registering new data in the database, changing data registered in the database, or changing the data registered in the database. It is preferable to include the deletion of the data registered in.

[0011]

Embodiments of the present invention will be described below in detail with reference to the accompanying drawings. FIG. 1 is a diagram showing a configuration of a server device according to an embodiment of the present invention. The server device S includes a computer having a CPU, a hard disk, a memory, and the like, and is located on the Internet N, which is a form of a network. For example, a user who has made a contract with the owner of the server S (contract user) stores data relating to his / her work on a hard disk in the server S or a hard disk connected to the server S via a network. Can be formed to store the business database DB1.

The server device S includes a WWW server 11, a screen structure database 12 for storing a screen structure to be displayed on a user terminal (for example, a personal computer or a mobile phone) P connected to the Internet N,
The screen structure database 12 includes a URL (Uniform Resource Locator) of a screen whose screen structure is registered and a URL database 13 for storing a correspondence relationship between the screen structure and the registration position of the screen structure in the screen structure database 12. The function of the WWW server 11 is a CP in the computer.
This is realized by U executing the program processing.
The screen structure database 12 and the URL database 13 are formed, for example, in a storage area on a hard disk (storage medium) in a computer.

The server apparatus S also receives a mail via the Internet N and a mail robot command database 21 in which a predetermined electronic mail address (command address) is registered as a command for operating the database. A mail server 22 having a mail distribution routine 221 for interpreting a command corresponding to the command, a database operation processing unit 23 for operating data on the business database DB1 based on the command interpreted by the mail server 22, Or a mail database 24 in which a database operation ID and a password required when a general user permitted to operate the business database DB1 by a contract user requests the operation of the business database DB1. There. The functions of the mail server 22 and the database operation processing unit 23 are as follows:
This is realized by the PU executing the program processing. The mail robot command database 21 and the mail database 24 are formed, for example, in a storage area on a hard disk in a computer.

In this embodiment, the server S
Is configured so that a contract user or a general user can send and receive normal mail (mail not intended to operate the business database DB1). That is, in the mail database 24, the e-mail addresses, the user IDs, and the passwords of the contract user and the general user can be registered in association with each other, and the received mail (text) addressed to the registered e-mail addresses can be stored. There is provided a received mail storage area for storing, and a transmitted mail storage area for storing transmitted mail (body) from a registered e-mail address. Further, the server device S is provided with an attached file group storage area 31 for storing an attached file attached to the received mail addressed to the mail address registered in the mail database 24. The attached file group storage area 31 is formed, for example, in a storage area on a hard disk in a computer.

The registration and readout of data in the mail database 24 and the attached file group storage area 31 are achieved by the mail registration function and the mail reading function of the mail server 22, respectively. For example, if the received mail has an attached file, the mail registering function of the mail server 22 is provided in the attached file group storage area 3.
1 to register the attached file, register the mail text in the received mail storage area of the mail database 24,
The address indicating the storage position of the attached file in the attached file group storage area 31 is registered in association with the mail text.

FIG. 2 is a view for explaining the data structure in the mail robot command database 21. In the mail robot command database 21, an operation content, a database name to be operated, and a URL of a screen for displaying an operation result are registered in association with each command address. Is shown in FIG. A contract user or a general user can perform various operations on the business database DB1 by sending an electronic mail to a command address registered in the mail robot command database 21 as a destination. For example, "kensaku_DB1 @ xxx
x.yy.jp ", the business database DB1
You can search for data registered in the.
Also, by sending an e-mail addressed to a command address such as "toroku_DB1@xxxx.yy.jp",
New data can be registered in the business database DB1. Further, by sending an e-mail addressed to a command address such as "henkou_DB1@xxxx.yy.jp", data registered in the business database DB1 can be changed. Furthermore, "sakujyo_
By transmitting an e-mail addressed to a command address such as "DB1@xxxx.yy.jp", data registered in the business database DB1 can be deleted.

FIG. 3 is a diagram showing an example of a user authentication screen for authenticating whether or not the person who sent the e-mail addressed to the command address is a contract user or a general user. A contract user or a general user sends an e-mail addressed to a command address from the user terminal P, and when the e-mail reaches the server device S, the WWW server 11 of the server device S refers to the URL database 13, The registration position of the screen structure of the user authentication screen in the screen structure database 12 is read. Then, data of the user authentication screen is collected based on the screen structure registered at the registration position, and the collected user authentication screen data is transmitted to the user terminal P via the Internet N.

When the user terminal P receives the user authentication screen data, a user authentication screen 40 is displayed on the display of the user terminal P. In the user authentication screen 40, a database operation ID input field 41, a password input field 42
And a registration button 43. A contract user or a general user inputs a database operation ID into the database operation ID input field 41 and a password into the password input field 43, and then presses the registration button 43 with a mouse pointer, for example. click. Then, the entered database operation ID and password are stored in the user terminal P
Via the Internet N to the server device S.

In the server device S that has received the database operation ID and the password, an authentication process is performed by a mail distribution routine 221 in the mail server 22.
That is, the correspondence between the database operation ID and the password received from the user terminal P is stored in the mail database 24.
It is checked whether the correspondence between the database operation ID and the password registered in the database matches. As a result, if the password for the database operation ID received from the user terminal P is not correct, the WWW server 11
Is returned to the user terminal P, and an error message such as “authentication failed” is displayed on the display of the user terminal P.

On the other hand, if the password for the contracted user ID received from the user terminal P is correct, the mail distribution command 221 refers to the mail robot command database 21 by the mail distribution routine 221 to determine the destination of the received electronic mail. The operation content and the operation target database corresponding to the address are specified. Subsequently, the contents of the operation and the information of the operation target database are provided to the database operation processing unit 23, and the database operation processing unit 23 executes the mail distribution routine 2
An operation process based on the information provided from 21 is performed on the business database DB1. Then, the result of the operation processing is returned to the mail distribution routine 221.

When the result of the operation processing is returned from the database operation processing unit 23, the mail distribution routine 2
21, the mail robot command database 21
Of the operation result display screen according to the content (command address) of the operation performed on the business database DB1 from
The RL is read, and the read URL is provided to the WWW server 11. Then, the WWW server 11 refers to the URL database 13 and reads out the registration position in the screen structure database 12 of the screen structure (the screen structure of the operation result display screen) corresponding to the URL given from the mail sorting routine 221. . Next, screen data is collected based on the screen structure registered at the registration position, and the collected screen data is transmitted to the user terminal P via the Internet N. As a result, the result of the operation processing on the business database DB1 is displayed on the display of the user terminal P.

As described above, according to this embodiment, data manipulation on the business database DB1 can be performed by sending an e-mail to a command address corresponding to the content to be operated. Therefore, even from a terminal on which a browser such as a mobile phone is not installed, the business database DB1 can be used.
Can perform data operations on. The server device S according to this embodiment may be provided in a completed form as a device having the above-described functions. For example, a CD-ROM storing a program for realizing the above-described functions may be provided. When a program recorded on a CD-ROM or the like is installed in a computer, each database is formed in a storage area on a hard disk of the computer, and the computer functions as the server device S You may do so. In addition, a program for realizing each of the above functions is recorded on a hard disk on a network, and the program recorded on the hard disk is downloaded to a computer and executed. May be formed, and the computer may function as the server device S.

Although the description of one embodiment of the present invention is as described above, the present invention can be embodied in forms other than the above-described embodiment. For example, in the above-described embodiment, an example is described in which the server device S is located on the Internet N, but the server device S may be located on another network such as a LAN. In addition, various design changes can be made within the scope of the matters described in the claims.

[Brief description of the drawings]

FIG. 1 is a diagram showing a configuration of a server device according to an embodiment of the present invention.

FIG. 2 is a diagram for explaining a data structure in a mail robot command database.

FIG. 3 is a diagram illustrating an example of a user authentication screen.

[Explanation of symbols]

 11 WWW server 12 screen structure database 13 URL database 21 mail robot command database 22 mail server 221 mail distribution routine 23 database operation processing unit 24 mail database 40 user authentication screen DB1 business database N network P user terminal S server device

 ────────────────────────────────────────────────── ─── Continuing on the front page (72) Inventor Shinichi Kubouchi 2-9-13 Tateminami, Misato-cho, Ikoma-gun, Nara F-term within the limited company L-Internet 5B075 KK03 KK07 KK13 KK33 KK40 KK43 KK54 KK64 KK66 KK67 ND03 NK54 PP10 PP14 PP30 PQ02 PQ05 UU24 UU40 5B082 GA08

Claims (7)

[Claims] 1. A server device placed on a network and operating in cooperation with a database, comprising: a mail command database in which a predetermined e-mail address is registered as a command for operating the database; A mail address interpreting means for accepting an e-mail addressed to the predetermined e-mail address transmitted from the e-mail address and interpreting a command corresponding to the e-mail by referring to the e-mail command database; And a database operation processing means for performing a database operation process based on the interpreted command. 2. A mail database in which a database operation ID and a password necessary for requesting an operation of the database are registered, and a database operation ID and a password in response to receiving the e-mail addressed to the predetermined e-mail address. Means for transmitting, via the network, a user authentication screen requesting the input of a password to the terminal of the mail sender; and electronically based on the registered contents of the mail database and the database operation ID and password input on the user authentication screen. 2. The server device according to claim 1, further comprising: means for authenticating whether or not the sender of the mail is a person who is permitted to operate the database. 3. The database operation processing by the database operation processing means includes searching for data registered in the database, registering new data in the database, changing data registered in the database, or registering data in the database. 3. The server device according to claim 1, wherein the server device deletes the data. 4. A computer-readable recording medium storing a program executed by a server device which is a computer which operates on a network and cooperates with a database. By using a mail command database registered as a command for the e-mail, receiving an e-mail addressed to the predetermined e-mail address sent from the user via the network, and referring to the e-mail command database, A recording medium storing a program for causing the server device to execute a mail address interpretation process for interpreting a corresponding command and a database operation process based on the command interpreted by the mail address interpretation process. 5. The program according to claim 4, wherein the program further causes the server device to execute a process of forming a mail command database in a storage area on a storage medium accessible by the server device. Recording medium. 6. The program further uses a mail database in which a database operation ID and a password necessary for requesting a database operation are registered, and responds to the reception of the e-mail addressed to the predetermined e-mail address. Transmitting a user authentication screen requesting input of a database operation ID and a password to a terminal of a mail transmission source via the network; and registering contents of the mail database and a database operation ID input on the user authentication screen. 6. The server device according to claim 4, further comprising the step of: performing a process of authenticating whether the sender of the e-mail is a person authorized to operate the database based on the password. Recording medium. 7. The database operation processing includes searching for data registered in the database, registering new data in the database, changing data registered in the database, or deleting data registered in the database. The recording medium according to any one of claims 4 to 6, comprising: