JP2011014009A - Data processing system using electronic mail and data processing method for the same - Google Patents

Abstract

PROBLEM TO BE SOLVED: To easily perform data processing of a computer using a portable terminal.SOLUTION: In an analysis processing server 13, an instruction sentence included in an electronic mail sentence is analyzed by referring to Format information registered in a format rule DB 16, and the performance procedure information of data processing corresponding to the analyzed instruction word is extracted from a processing rule DB 17, and a software server 19 is made to perform the data processing of software corresponding to the extracted performance procedure information, and a mail server 12 is made to transmit the performance result of the data processing of the software server 19 as text data, and the mail server 12 is made to create a reply mail sentence with the received text data as a main text and with the destination as a portable terminal mail address, and transmit it to the portable terminal 10 destination. Thus, it is possible to perform arbitrary data processing on the computer using the portable terminal.

Description

  The present invention relates to a data processing system and data processing method for executing arbitrary data processing using an electronic mail, and in particular, a result of analyzing a command execution sentence included in the electronic mail and processing the data according to the analysis result The present invention relates to a data processing system and an electronic data processing method using electronic mail that can return data by electronic mail.

  2. Description of the Related Art In recent years, a computer system has been realized in which a mobile phone is connected to a web server and software on the web server is executed using the function of the mobile phone. For example, in the case of a web page that searches for a train route, this computer system searches for a train route by inputting a station name in a field of a departure station / arrival station displayed on a mobile phone and operating an execution button. A technique for executing and displaying the route search result on a mobile phone is employed.

  On the other hand, the e-mail software transmitted / received via the Internet communication network is an interface unique to the e-mail software. Therefore, the e-mail software is created by document software / spreadsheet software / business software generally distributed in computers. If the file was attached, the contents of the received email attachment could not be read. Particularly in recent years, for example, even when trying to view a mail attachment file transmitted to an e-mail address of a work computer using a mobile phone from outside, the file cannot be viewed due to the above-described interface difference.

  Patent Document 1 listed below is a document that describes a technique for converting e-mail data according to the prior art into data of another format. This Patent Document 1 allows e-mail data to be displayed on the web. A technique for performing data conversion and displaying it on an electronic bulletin board on the Internet is described.

Japanese Patent Laid-Open No. 10-63592

  The above-described technology for operating software on a web server using a mobile phone has a problem in that dedicated software for processing data input from the mobile phone must be prepared on the web server. In addition, although the technique described in Patent Document 1 can display data in a predetermined format for electronic mail on an electronic bulletin board, it does not take into consideration that arbitrary data processing is performed using a mobile phone. There was a problem.

  An object of the present invention is to use an electronic mail that can execute arbitrary data processing on a computer system using a mobile terminal having an electronic mail transmission / reception function, such as a mobile phone, and return the execution result to the mobile terminal. The data processing system and the data processing method are provided.

In order to achieve the above object, the present invention receives an e-mail text created so as to include a command word in a predetermined format from a mobile terminal in which a mail address is set, analyzes the e-mail text, A data processing system using e-mail that executes processing and returns the execution result to the mobile terminal,
A mail server for receiving the e-mail message;
Analyzing an instruction word included in the received e-mail sentence, and an analysis processing server for instructing execution of data processing according to the analyzed instruction word;
A processing rule database in which execution procedure information for executing data processing according to the analyzed instruction word is registered in advance;
A software server including software that executes data processing according to the analyzed instruction word;
A format rule database for storing the predetermined format information of the e-mail text;
The mail server is
A first step of receiving an e-mail message including a command word transmitted from the mobile terminal;
The analysis processing server is
A second step of analyzing a command statement included in the e-mail message received in the first step with reference to predetermined format information registered in the format rule database;
A third step of extracting data processing execution procedure information according to the instruction word analyzed in the second step from the processing rule database using the instruction word as a key;
A fourth step of instructing a software server to perform software data processing according to the execution procedure information extracted in the third step;
The software server is
Executing the data processing instructed in the fourth step, and sending the execution result of the data processing to the mail server as text data;
The mail server is
Executing a sixth step of creating a response mail text having the text data transmitted in the fifth step as a body and a destination as a mobile terminal mail address that has transmitted the electronic mail text, and transmitting the response mail text to the mobile terminal. First feature.

According to the present invention, in the data processing system according to the first feature, the e-mail text created in the predetermined format includes data designation information for designating data to be processed, and data search or update for the data designation information And a command word that indicates
According to a second aspect of the present invention, the software server executes, in the fifth step, data search or data update processing of the instruction word with respect to data designated by the data designation information.

In the data processing system of the first or second feature, the present invention provides a mobile terminal mail address of a user who uses the mobile terminal, user name information corresponding to the mobile terminal mail address, and the mobile terminal mail address. Providing a user management database storing usage authority information that permits the data processing corresponding to
The analysis processing server is
Next to the first step, execute a seventh step of extracting use authority information searched in the user management database using the mobile terminal mail address as a key,
When it is determined that the execution procedure information of the data processing extracted in the second step satisfies the authority of the usage right information extracted in the seventh step, the third step is to execute the data processing instructed in the fourth step. It is characterized by.

In the data processing system according to any one of the first to third aspects of the present invention, the mail server includes a data polling unit that stores an electronic mail sentence transmitted from the mail server in the first step,
When the analysis processing server determines whether or not an e-mail message is stored according to a predetermined time condition in the data polling unit of the mail server, and determines that the e-mail message is stored by the determination, The fourth feature is to execute the second step.

  According to the present invention, in the data processing system according to any one of the second to fourth features, the e-mail text is composed of a mail subject field and a text field, and the predetermined format is a type of data processing in the mail subject field. A fifth feature is that a command word for designating a data is input and target data for data processing is input in the text field.

Furthermore, the present invention provides a mail server that receives an e-mail message created so as to include a command word in a predetermined format from a mobile terminal in which a mail address is set, and a command word included in the received e-mail message. An analysis processing server for analyzing and instructing execution of data processing according to the analyzed instruction word; a processing rule database in which execution processing procedure information for executing data processing according to the analyzed instruction word is registered in advance; An e-mail message received from the portable terminal, comprising: a software server including software that executes data processing according to the analyzed instruction word; and a format rule database that stores the predetermined format information of the e-mail message Is a data processing method of a computer system that performs data processing by analyzing the data and returns the execution result to the mobile terminal. Te,
To the mail server,
Executing a first step of receiving an e-mail message including a command word transmitted from the mobile terminal;
In the analysis processing server,
A second step of analyzing a command statement included in the e-mail message received in the first step with reference to predetermined format information registered in the format rule database;
A third step of extracting data processing execution procedure information according to the instruction word analyzed in the second step from the processing rule database using the instruction word as a key;
A fourth step of instructing the software server to perform software data processing according to the execution procedure information extracted in the third step;
In the software server,
Execute the data processing instructed in the fourth step, and execute the fifth step of transmitting the execution result of the data processing as text data to the mail server,
To the mail server,
The sixth step of generating a response mail sentence having the text data transmitted in the fifth step as the body and the destination as the mobile terminal mail address that transmitted the e-mail text is transmitted to the mobile terminal. The sixth feature.

Further, the present invention provides the data processing method according to the sixth feature, wherein the e-mail text created in the predetermined format is data designation information for designating data to be processed, and data search or update for the data type information And a command word that indicates
According to a seventh feature of the present invention, the software server is caused to execute data search or data update processing of the instruction word on the data designated by the data designation information in the fifth step.

In the data processing method according to the sixth or seventh aspect, the present invention provides a mobile terminal mail address of a user who uses the mobile terminal, user name information corresponding to the mobile terminal mail address, and the mobile terminal mail address. Providing a user management database storing usage authority information that permits the data processing corresponding to
In the analysis processing server,
Next to the first step, the seventh step of extracting usage authority information searched in the user management database using the mobile terminal mail address as a key is executed,
When it is determined that the data processing execution procedure information extracted in the second step satisfies the authority of the usage right information extracted in the seventh step, the data processing instructed in the fourth step is executed. It is characterized by.

In the data processing method according to any one of the sixth to eighth aspects, the present invention provides the data polling unit for storing the email text transmitted from the mail server in the first step in the mail server,
When the analysis server causes the data polling unit of the mail server to determine whether an email text is stored according to a predetermined time condition, and when the determination determines that the email text is stored, The ninth feature is that the second step is executed.

  According to the present invention, in the data processing method according to any one of the seventh to ninth features, the e-mail text is composed of a mail subject field and a text field, and the predetermined format is a type of data processing in the mail subject field. A tenth feature is that an instruction word for designating a data is input and target data for data processing is input to the text field.

  The data processing system and the data processing method according to the present invention include a step of analyzing, in an analysis processing server, a command sentence included in an e-mail sentence by referring to predetermined format information registered in a format rule database, Extracting data processing execution procedure information according to the analyzed instruction word from the processing rule database using the instruction word as a key, and instructing a software server to perform software data processing according to the extracted execution procedure information. The execution result of the data processing that causes the software server to execute the specified data processing is transmitted to the mail server as text data, and the mail server receives the received text data as the body and the destination is the e-mail text. Create a response e-mail message that uses the e-mail address of the mobile phone you sent By transmitted to end, it is possible to perform any data processing on a computer system using a portable terminal having a mail transmission and reception functions of the mobile phone and the like, and returns the execution result to the mobile terminal.

1 is a diagram showing an overall configuration of an electronic mail data sharing system according to an embodiment of the present invention. The figure which shows the structure of the mail server by this embodiment. The figure which shows the structure of the portable terminal by this embodiment. The figure which shows the structure of the processing server by this embodiment. The figure which shows the structure of the software data processing server by this embodiment. The figure which shows the structure of the package software server by this embodiment. The figure which shows the structure of the user management database by this embodiment. The figure which shows the structure of the Format database by this embodiment. The figure which shows the structure of the process rule database by this embodiment. Explanatory drawing of the data processing request mail by this embodiment. Explanatory drawing of operation | movement of the mail request reception process by this embodiment. Operation | movement explanatory drawing of the Format confirmation process by this embodiment. Operation | movement explanatory drawing of the data processing system confirmation process by this embodiment. Operation | movement explanatory drawing of the software process for package software by this embodiment. Explanatory drawing of operation | movement of the email notification sentence preparation process by this embodiment. Operation | movement explanatory drawing of the administrator setting process by this embodiment.

Hereinafter, an embodiment of a data processing system and a data processing method using electronic mail according to the present invention will be described in detail with reference to the drawings.
[Constitution]
[overall structure]
As shown in FIG. 1, an electronic mail data sharing system, which is a computer system adopting the electronic mail data sharing method according to the present embodiment, includes portable terminals 10A to 10C having an electronic mail transmission / reception function such as a general mobile phone, The mail server 12 connected to the mobile terminals 10A to 10C via the public network 11 such as the Internet and having a function of transmitting and receiving electronic mails from other computers, and the present embodiment received from the mobile terminals 10A to 10C. Parameter analysis that receives data processing request mail text (information), which is a feature, analyzes the data processing request mail text, and executes data processing (data search / update / designated data processing) based on the analysis result Software data for storing the DB data processing server 13 and software for performing the data processing Software software processing for controlling the search / update of data by the software processing executed by the package software server 19, and the package software server 19 for executing processing of the software data stored in the software database 20 Server 14, user management database 15 in which user names and other user information are registered, format rule database 16 in which format information of e-mail software is registered, and processing in which predetermined processing rule information by software is registered The rule database 17 includes a work terminal 18 connected to the software data processing server 14 and the parameter analysis DB data processing server 13.

[Portable terminal 10]
The portable terminals 10A to 10C according to the present embodiment store a keyboard 102 for data input, a display device 104 for displaying various information, and a program group 106 including an e-mail program 1061, as shown in FIG. It comprises an internal memory 105 and a CPU 101 that controls them. The e-mail program 1061 is an e-mail transmission / reception program that operates on a mobile phone or a PDA. Each e-mail program holds an e-mail address, and items to be entered each time include an e-mail address (Mail To), a subject ( There are “Subject” and “Body” (Data). Each item is input in a specific format and transmitted.

[Mail server 12]
As shown in FIG. 3, the mail server 12 according to the present embodiment includes a keyboard 122, a mouse 123, a display device 124, an internal memory 125 for storing an e-mail program 126, and a recording such as a magnetic disk device or a semiconductor storage device. The data area 127 is a medium and is provided with a polling area to be described later, and a CPU 121 that controls these areas.

  The e-mail program 126 receives a mail from a portable terminal, converts the mail information (Mail From, Mail To, Subject, Data) into a text, stores it in a polling area, and a mail response received from the parameter analysis data processing server The polling area 1271 is an area for temporarily storing received mail information, and the data polling unit of the parameter analysis data processing server sets the area as an example. It is provided for checking at any time interval or at any time.

[Parameter analysis data processing server 13]
As shown in FIG. 4, the parameter analysis DB data processing server 13 according to the present embodiment is a computer, and includes an internal memory 132 that stores various programs as functions, and a CPU 131 that executes processing according to these programs. In the internal memory 132, a data polling unit 133 that performs polling (inquiry) for data presence, which will be described later, an analysis program 134 that confirms user authority and format by analyzing mail text, and a data processing method that will be described later The data processing program 135 for executing other data processing, the response program 136 for generating a response sentence to the inquiry, and the management program 137 for controlling the processing such as user setting by the administrator, the keyboard 183 / Mouse 183 / Display 1 5 / is connected to a configured work terminal 18 a browser 1841 from the internal memory 184 Metropolitan stored.

  The data polling unit 133 is a program that periodically inquires whether the data processing request mail text is stored in the polling area 1271 of the mail server 12 and passes the information to the analysis program 134 when it is determined that the data processing request mail text is stored. . The user authority confirmation unit 1341 confirms the function for searching the user management database 15 using the transmission source mail address of the data processing request mail sentence passed from the data polling unit 133 as a key, the target software and the processing authority, and grants the authority. When it is determined that it has, the process proceeds to the format confirmation unit 1342, and when it is determined that the user does not have authority, the error is transmitted to the response sentence creation unit 1361.

  The format check unit 1342 determines whether the request is a request for sample data or a request for sample data based on the subject (subject) of the data processing request mail, checks whether the request is a correct format, and can be corrected. An error is a program that automatically corrects and reprocesses. The processing method confirmation unit 1351 searches the processing rule database 17 from the subject of the received data processing request mail, selects the software processing request unit 1353 or the DB processing execution unit 1352 from the operation flag string, and passes the processing It is. The DB processing execution unit 1352 is a program that searches the processing rule database 17 from the Subject and executes search and update processing on the software database 20. The software processing request unit 1353 is a program that requests the software data processing server 14 to search and update data by automatically operating a screen for package software that does not use a database such as SQL.

  The response sentence creation unit 1361 is a program that receives the result of each processing unit and creates a reply mail to the data processing request mail, and has a function of notifying a result of normal termination and an error when an error occurs. The user setting unit 1371 is a program registered in the user management database 15 that transmits a processing request mail. The format setting unit 1372 is a program that defines the format of the processing request mail in the format rule database 16. The conversion rule setting unit 1373 is a program that defines processing rule information in the processing rule database 17.

[Software data processing server 14]
As shown in FIG. 5, the software data processing server 14 is composed of an internal memory 142 for storing a plurality of programs for executing various processes and a CPU 141 for controlling these programs. The data processing program 143 includes a search processing unit 1431 for controlling and an update processing unit 1432 for performing update processing, and an administrator program 144 including an administrator setting unit 1441.

  The search processing unit 1431 is a program for executing the search processing request received from the parameter analysis data processing server 13 to the package software server 19, and the update processing unit 1432 is the update received from the parameter analysis data processing server 13. The manager is a program for executing a processing request to the package software server 19, and the manager setting unit 1441 is a program for setting search processing and update processing for specific items of each software.

[Package software server 19]
As shown in FIG. 6, the package software server 19 according to the present embodiment includes a keyboard 192 / mouse 193 / display device 194 / internal memory 195 that stores a package software program 196 including a data processing unit 1961. It is connected to the. The package software program 196 is assumed to be package software having a document creation or spreadsheet function that is generally popular.

[User management database 15]
The user management database 15 is registered with the user authority set in advance for the users of the mobile terminals 10A to 10C. As shown in the upper part of FIG. 7, the user name and the user name are registered. A mail address that is an e-mail address, a character code indicating a character code type matched to a mailer (e-mail software) used in the user's computer, target software indicating a processable software type, and the target software Each item information of processing indicating the processing contents that can be processed, specifically, for example, as shown in the table indicated by reference numeral 15 in the lower part of FIG. 7, the user name “User1” and the mail address “10A@keita.XX. “jp”, character code “S-JIS”, target software “Soft1”, process “search”, etc. It is.

[Format rule database 16]
As shown in the upper part of FIG. 8, the format rule database 16 according to the present embodiment includes a format name indicating the name of the format, a column number indicating the number of columns (records) of each format, and a column name that is the name of this column. And a character type indicating a character type that is a character type that can be input to this column, and a FIL indicating a handling process at the time of occurrence of a remainder due to a length, a blank, or the like that can be input to the column Specifically, as shown in the lower part of FIG. 8, the format name “Format 1”, the number of columns “2”, the column name linked by the column definition table (Table) number is “Company”, and the character type is A plurality of setting information is registered for each Format corresponding to a plurality of mail software, such as “50 Bytes” and FIL “Yes”.

[Processing rule database 17]
The processing rule database 17 is registered in advance with respect to received mail designated by the user. As shown in FIG. 9, target software for specifying processing target software and a processing key for a mail request statement. A subject for designating a subject (subject), a DB operation flag indicating whether the user instruction content is a DB operation (flag “0”) or a process via software (flag “1”), search, update, etc. Each item information indicating a DB operation statement (for example, an SQL statement for executing a DB process), which is a key for performing the process of FIG. 9, specifically, as shown in the lower part of FIG. Package A ”, Subject“ Name Search ”, Operation Flag“ 0 ”, DB Operation Statement“ SELECT Name Data FROM Package DB table "has been registered as. The DB operation statement of the top record (No. 1) in the lower part of FIG. This indicates that the name is searched from the table as a key, and the DB operation statement of the record (No. 2) is the package DB. This indicates that an address is searched from the table using the address as a key, and the DB operation statement of the record (No. 4) indicates that processing is performed via software and data is copied according to the operation rule C-1.

[Data processing request statement]
In the present embodiment, the data processing request text that the user requests to process the mail data using the mobile terminals 10A to 10C is “Mail From” indicating the mail sender who is the mail processing requester, as shown in FIG. Each item information of “Mail To” indicating the server administrator of the mail destination, “Subject” indicating the subject, and “Data” indicating the contents of the DB operation statement. Column names and target item names are entered.

  For example, “Mail From” is “10A@keitai.XX.jp”, “Mail To” is “19@keitai.XX.jp”, and “Subject” is an instruction word. "Data" is created as "Yamada" indicating data to be processed.

[Operation]
[Email request acceptance process]
As shown in FIG. 11, the data processing system and data processing method using the electronic mail according to the present embodiment configured as described above can be used by the user using the electronic mail program 1061 of the portable terminal 10 as shown in FIG. When the data processing request mail text as shown in FIG. 5 is created and sent to the mail server 12, the mail server 12 converts the data processing request mail text into the text data format using the e-mail program 126, and polling area. A step of storing in the unit 1271, a step in which the parameter analysis data processing server 13 searches the polling area unit 1271 of the mail server 12 at a predetermined timing and shifts the processing of the mail sentence to the user authority confirmation unit 1341, The user authority confirmation unit 1341 to which the process has been transferred displays the mail text (“Mail “From” “10A@keitai.XX.jp”), a step 1341a for extracting a sender email address, and searching the user management database 15 using the extracted email address as a key, and the owner of the searched email address is Step 1341b for determining whether or not there is an authority to operate software data, and whether or not the processing sequence of the user management database 15 matches the subject content of the mail text when it is determined that the authority is determined by the determination If it is determined that there is a match with this step 1341c, the process proceeds to the process of the format confirmation unit 1342, which will be described later, and the process of the response creation unit 1361 determines that the match by the user management database 15 cannot be obtained. Data processing request by executing the process to migrate Confirmation and processing contents statement authorized user respect Lumpur statement operates to determines whether to match the predetermined format.

  The process 1341a of the user authority confirmation unit 1341 searches the user management database 15 using the transmission source mail address (Mail From) of the data processing request mail text passed from the data polling unit 133 as a key, and extracts the corresponding line. Step 1341b confirms whether the destination mail address (Mail To) is a mail address for software permitted for the corresponding line, and if it is determined that the address is not permitted, the error indicating that it is not the target software. Is sent to the response sentence creation unit 1361, and if it is determined to be permitted, it has a function of passing to 1341c, and the process 1341c confirms whether the processing column of the row matches the Subject content ("Name search"). In the case of NG, an error indicating that it is not a processing target is passed to the response sentence creating unit 1361 In the case of OK, it has a function of proceeding to the format confirmation unit 1342.

[Format confirmation processing]
In the parameter analysis DB data processing server 13 to which the processing by the user authority confirmation unit 1341 has been transferred, as shown in FIG. 12, the Format confirmation unit 1342 determines whether or not the subject is a subject to which sample data is responded. When the subject is determined to be a sample data response subject as a result of the determination, the step 1342b of passing the column name of the software to be processed and the data of the first row as a sample to the response sentence creating unit 1361, and the subject in step 1341a When it is determined that the processing is not processing, it is determined by referring to the Format rule database 16 whether the Data item of the request mail is correct from the processing target software information. Step 13 2c and when it is determined to be incorrect by the step 1342c, if there is an extra blank (null), the blank is deleted, and the one with the punctuation mark “,” is corrected to a comma “,”, and the step 1342c Returning to step 1342d, and when it is determined that correction is impossible in step 1342d, the column name of the processing target software and the data sample of the first row are passed to the response sentence creating unit 1361, and the process proceeds to the response sentence creating unit 1361 Step 1342e is performed. In particular, in the present embodiment, even if there is a blank or comma error input in the data processing request mail text (FIG. 10), the error can be corrected by the aforementioned step 1342d.

  The step 1342a of the format confirmation unit 1342 has a function of transferring to the step 1342b when the subject of the received data processing request mail is a subject that responds to the sample data, and passing to the step 1342c otherwise. The step 1342b has a function of passing the data string name of the processing target software and the data of the first row as a sample to the response sentence creating unit 1361. In the step 1342c, whether the Data item of the request mail is a correct format. Has a function to search the format database 16 by using the processing target software information as a key, and when it is determined that the format is not correct, the process proceeds to step 1342d, and when it is determined that the format is correct, a function is passed to the processing method confirmation unit 1351. , Step 1342d is a blank space If the deletion or delimiter is not a comma, the process 1342c is executed after correction, and if it cannot be corrected, it has a function of passing to the process 1342e. The process 1342e includes the data string name of the processing target software and the first line Is sent to the response sentence creation unit 1361 as a sample, and in the case of OK, the process proceeds to the processing method confirmation unit 1351.

[Data processing method confirmation processing]
As shown in FIG. 13, the data processing method confirmation unit 1351 whose processing has been shifted due to the determination of the correct format in the step 1342c uses the subject (for example, “Name search”) as a key for processing rule information as the processing rule database 17. To determine whether the operation flag is “0” or “1”. When the operation flag is determined to be “1”, the process proceeds to the software processing request unit 1353, and the flag is determined to be “0” in the process. Then, the DB processing execution unit 1352 searches the processing rule database 17 using the Subject as a key, selects the relevant processing rule information, 1352a, and the SQL statement of the selected processing rule includes a Data item (for example, “Yamada”). ) To transfer the processing to the software database 20 by applying the information 1) If, executes a step 1352c to pass is the execution contents of the processing rule target software / Subject / Data in response sentence creation unit 1361.

  The processing method of the processing method confirmation unit 1351 searches the processing rule using the subject of the received data processing request mail as a key, determines whether the operation flag is “0” or “1”, and sets “1”. In this case, the process proceeds to the software process request unit 1353, and in the case of “0”, the process proceeds to the DB process execution unit. The process 1352a of the DB process execution unit 1352 searches the process rule database 17 using Subject as a key, A function of selecting a corresponding rule, and the step 1352b has a function of executing processing to the software database by applying the information in the Data item of the data processing request mail statement to the SQL statement of the selected rule, and the step 1352c includes , And a function of passing the processing rule execution contents (including the execution result) to the response sentence creation unit 1361.

[Software processing for packaged software]
As shown in FIG. 14, the software processing request unit 1353 whose processing has been shifted by the flag determination executes a step of determining whether the subject content of the data processing request mail text is search or update. The data processing server 13 uses the search processing unit 1341 to execute a step of instructing the package software to execute the search processing based on the content information of the data item, and the data processing unit 1961 of the package software server 19 that has received the search instruction A step of performing a search process based on the Data item is executed, and the software data processing server 14 executes a process of shifting to the process of the response sentence creating unit 1361.

  On the other hand, when the above-described software processing request unit 1353 determines that the subject is updated, the process update unit 1432 of the software data processing server 14 instructs execution of update processing to the package software based on the information in the Data item; Upon receiving this instruction, the data processing unit 1961 of the package software server 19 executes the update process based on the information in the Data part, and the process of shifting to the process of the response sentence creating unit 1361 after these processes. The search or update process by the package software can be performed.

[Create response sentence-notification process]
Now, the e-mail data sharing system according to the present embodiment retrieves or updates the predetermined processing rule by the DB processing execution unit 1352 shown in FIG. 13, or by the package software server 19 shown in FIG. After the above processing, the response sentence creation unit 1361 of the parameter analysis DB data processing server 13 writes (substitutes) the received processing result in the Data part column of the response mail as shown in FIG. A step of creating a response mail message addressed to Address and transferring it to the mail server 12, and the mail server 12 receiving the transfer sends the response mail message received using the e-mail program 126 to the corresponding mobile terminal 10. To the e-mail instructed by the e-mail text from the mobile terminal 10 Processing, search or update can be performed, and the execution result can be transmitted to the mobile terminal 10 as a response mail. Therefore, according to the present embodiment, electronic mail data received by general mail software can be processed using the mobile terminal 10 and the result can be transmitted to the mobile terminal 10.

  Therefore, according to the present embodiment, it is possible to execute arbitrary data processing on the computer system using a portable terminal having an electronic mail transmission / reception function such as a cellular phone, and return the execution result to the portable terminal.

[Administrator settings]
In the electronic mail data sharing system according to the present embodiment, the administrator executes registration of the user (mobile terminal) / registration / update of the data format / registration of the processing rule. This processing is shown in FIG. As described above, the administrator registers / updates / deletes the registered user in the user management database 15 using the user setting unit 1371 of the parameter analysis DB data processing server 13 using the browser 1841 of the work terminal 18, and similarly the browser 1841 is used to register / update / delete the Format rule of the Format rule database 16 using the format setting unit 1372 of the server 13, and similarly, the registered format is registered using the conversion rule setting unit 1373 using the browser 1841. Is read from the Format rule database 16 and the processing By reflecting in the database 17, it is performed.

  10A to 10C: Mobile terminal, 11: Public network, 12: Mail server, 13: Parameter analysis DB data processing server, 14: Software data processing server, 15: User management database, 16: Format rule database, 17: Processing rules Database: 18: Work terminal, 19: Package software server, 20: Software database.

Claims (10)

An e-mail text created to include an instruction word in a predetermined format is transmitted from a mobile terminal in which a mail address is set, the e-mail text is analyzed, data processing is executed, and the execution result is sent to the mobile terminal A data processing system using a reply e-mail,
A mail server for receiving the e-mail message;
Analyzing an instruction word included in the received e-mail sentence, and an analysis processing server for instructing execution of data processing according to the analyzed instruction word;
A software server including software executed in accordance with execution processing procedure information indicating a processing procedure for executing data processing according to the analyzed instruction word;
A processing rule database in which execution processing procedure information corresponding to the analyzed instruction word is registered in advance;
A format rule database for storing the predetermined format information of the e-mail text;
The mail server is
A first step of receiving an e-mail message including a command word transmitted from the mobile terminal;
The analysis processing server is
A second step of analyzing a command statement included in the e-mail message received in the first step with reference to predetermined format information registered in the format rule database;
A third step of extracting data processing execution procedure information according to the instruction word analyzed in the second step from the processing rule database using the instruction word as a key;
A fourth step of instructing a software server to perform software data processing according to the execution procedure information extracted in the third step;
The software server is
Executing the data processing instructed in the fourth step, and sending the execution result of the data processing to the mail server as text data;
The mail server is
A data process for executing a sixth step of creating a response mail text having the text data transmitted in the fifth step as a body and a destination address of the mobile terminal mail address to which the electronic mail text has been transmitted, and transmitting to the mobile terminal system. The e-mail text created in the predetermined format includes data designation information for designating data to be processed, and a command word for instructing search or update of data for the data designation information,
2. The data processing system according to claim 1, wherein the software server executes data search or data update processing of the instruction word for data designated by the data designation information in the fifth step. User management storing a mobile terminal mail address of a user who uses the mobile terminal, user name information corresponding to the mobile terminal mail address, and usage authority information permitting the data processing corresponding to the mobile terminal mail address Set up a database,
The analysis processing server is
Next to the first step, execute a seventh step of extracting use authority information searched in the user management database using the mobile terminal mail address as a key,
The data processing instructed in the fourth step is executed when it is determined that the execution procedure information of the data processing extracted in the second step satisfies the authority of the usage right information extracted in the seventh step. 2. The data processing system according to 2. The mail server has a data polling area for storing the e-mail text transmitted from the mail server in the first step;
When the analysis processing server determines whether or not an e-mail message is stored in the data polling area of the mail server according to a predetermined time condition, and determines that the e-mail message is stored by the determination, The data processing system according to claim 1, wherein the second step is executed.   The e-mail text is composed of a mail subject field and a body text field, and the predetermined format is to input a command word for specifying the type of data processing in the mail subject field, and to input data subject to data processing in the body text field. A data processing system according to any one of claims 2 to 4. A mail server that receives an e-mail sentence created so as to include an instruction word in a predetermined format from a mobile terminal in which an e-mail address is set, and an instruction word included in the received e-mail sentence is analyzed, and the analysis An analysis processing server for instructing execution of data processing according to the instruction word, a processing rule database in which execution processing procedure information for executing data processing according to the analyzed instruction word is registered, and the analyzed instruction A software server including software that executes data processing according to words, and a format rule database that stores the predetermined format information of the e-mail message, and analyzes the e-mail message received from the portable terminal A computer system data processing method for executing processing and returning an execution result to a mobile terminal,
To the mail server,
Executing a first step of receiving an e-mail message including a command word transmitted from the mobile terminal;
In the analysis processing server,
A second step of analyzing a command statement included in the e-mail message received in the first step with reference to predetermined format information registered in the format rule database;
A third step of extracting data processing execution procedure information according to the instruction word analyzed in the second step from the processing rule database using the instruction word as a key;
A fourth step of instructing the software server to perform software data processing according to the execution procedure information extracted in the third step;
In the software server,
Execute the data processing instructed in the fourth step, and execute the fifth step of transmitting the execution result of the data processing as text data to the mail server,
To the mail server,
Data processing for executing the sixth step of creating a response mail sentence having the text data transmitted in the fifth step as the body and the destination as the mail address of the mobile terminal that has transmitted the e-mail text, and transmitting to the mobile terminal Method. The e-mail text created in the predetermined format includes data designation information for designating data to be processed, and a command word for instructing search or update of data for the data type information,
The data processing method according to claim 6, wherein the software server is caused to perform data search or data update processing of the instruction word on the data designated by the data designation information in the fifth step. User management storing a mobile terminal mail address of a user who uses the mobile terminal, user name information corresponding to the mobile terminal mail address, and usage authority information permitting the data processing corresponding to the mobile terminal mail address Set up a database,
In the analysis processing server,
Next to the first step, the seventh step of extracting usage authority information searched in the user management database using the mobile terminal mail address as a key is executed,
The data processing instructed in the fourth step is executed when it is determined that the execution procedure information of the data processing extracted in the second step satisfies the authority of the usage right information extracted in the seventh step. 8. The data processing method according to 7. The mail server is provided with a data polling area for storing the email text transmitted from the mail server in the first step,
When the analysis processing server determines whether or not an email message is stored in accordance with a predetermined time condition in the data polling area of the mail server, and when determining that the email message is stored by the determination, The data processing method according to claim 6, wherein the second step is executed.   The e-mail text is composed of a mail subject field and a body text field, and the predetermined format is to input a command word for specifying the type of data processing in the mail subject field, and to input data subject to data processing in the body text field. The data processing method according to any one of claims 7 to 9.

Images