JP2011014015A - System and method for sharing data - Google Patents

Abstract

PROBLEM TO BE SOLVED: To facilitate data sharing in a plurality of software servers.SOLUTION: A data sharing system performs: a process for extracting the processing data of one software server in response to the instruction of use terminals 10A to 10C; a process that a data storage server 12 stores the extracted processing data in a designated directory region; a process that a conversion processing server 13 makes an inquiry for the directory region in which the processing data are stored; a process for generating conversion tag information including conversion source/post-conversion tag format type information based on information such as the directory region as the object of inquiry and the user name and format type; a process for extracting the conversion source/post-conversion format type of the generated conversion tag information, and for extracting the conversion rule information of the conversion rule database 15 based on the conversion source/post-conversion format type, and for converting the format type according to the extracted conversion rule information; and a process for transferring the converted data to the other software server.

Description

  The present invention relates to a data sharing system and a data sharing method capable of sharing common data among a plurality of business package software.

  In general, a recent business computer system is configured such that a plurality of business-specific package softwares are operated on individual server computers, and a terminal device on the user side accesses each server computer via a network. Yes. Such a business computer system includes, for example, a server computer that operates production management business package software and a server computer that operates sales management business package software connected via a network, and a user who uses a user terminal The production management business package software and the sales management business package software are configured to be accessible.

  In the business computer system configured in this way, even if shared data that is commonly used as data that needs to be input to multiple business-specific package software exists, data is individually input to each server computer. It was done.

  For example, even if there is data such as production factory name / address / contact information in a company as data common to production management business package software and sales management business package software, data is stored in individual server computers. It had to be entered separately.

  For example, the following Patent Document 1 is cited as a document describing a technique related to the handling of the common data, and this Patent Document 1 includes data structures of all software in a computer system environment where a plurality of software exists. It is described that a common file having a common format is created and the common file is installed in all software. Patent Document 2 below describes a technique for automatically storing specific data with attribute designation in a predetermined folder.

JP 2000-242682 A JP 2004-362091 A

  The technique described in the above-mentioned Patent Document 1 has a problem that a plurality of business package software must be individually corrected so that a common file is mounted on different types of business package software having different forms. Further, according to the prior art, even when other business package software is newly added to the initial plurality of business package software, it is said that a shared file must be mounted on the additional business package software. There was a bug. The technique described in Patent Document 2 stores data in a predetermined folder according to a data format, and does not describe handling of shared data.

  An object of the present invention is to provide a data sharing system and a data sharing method capable of easily sharing shared data in a plurality of business package software.

In order to achieve the above object, the present invention is common to one software server that processes data in a predetermined format and another software server that processes data in the other format different from the predetermined format. A data sharing system for processing shared data to be handled,
A conversion rule information database for storing a plurality of conversion rule information for mutually converting data having different format formats;
A conversion processing server that is a computer that refers to the conversion rule information stored in the conversion rule information database and converts data of different formats to each other;
Tag information based on a data storage section in which the data storage area is formed as a multi-layer and a plurality of directory areas, and directory storage position information, data name, user name, and format information of the data stored in the multi-layer and a plurality of directory areas A data storage server that is a computer having a tag information generation unit for generating
The data storage server is
A first step of extracting processing data processed by the one software server;
A second step of storing the processing data extracted in the first step in a designated directory area of the data storage unit;
The conversion processing server is
A third step of polling the storage unit of the data storage server to inquire about a directory area in which processing data is stored;
Tag information including conversion source format information and converted format information is generated based on the directory area of the processing data inquired in the third step, the data name of the processing data, the user name, and the format information. A fourth step;
Extracting the conversion source format format and the converted format format of the tag information generated by the fourth step, extracting the conversion rule information of the conversion rule database based on the conversion source format format and the converted format format, and extracting A fifth step of converting the format format of the processing data in accordance with the converted conversion rule information;
The first feature is that the sixth step of transferring the data whose format has been converted in the fifth step is transferred to the other software server.

The present invention also provides the data sharing system according to the first feature.
The conversion processing server is
In the fourth step, tag information including data name and user name of processing data and format information before and after conversion is generated,
A seventh step of generating an e-mail message including the data name, the user name, and the format information before and after conversion included in the conversion tag information;
A second feature is that an eighth step of transmitting the e-mail generated in the seventh step to the mail address of the user name included in the conversion tag information is executed.

  According to the present invention, in the data sharing system according to any one of the above features, the data storage server includes an archive storage unit that stores the processed data subjected to format conversion, and the format format is converted by the fifth step. A third feature is that the processed data and the tag information are stored in an archive storage unit.

  In the data sharing system according to any one of the above characteristics, the present invention includes a usage terminal that is a computer having a data storage area unit for using software installed in the software server, and the conversion processing server is The user terminal that has transmitted the e-mail text to the user terminal and received the e-mail stores the processing data whose format has been converted by the data storage server in the data storage area unit, and stores the processed data in the data storage area unit. A fourth feature is that the stored processing data is transferred to the other software server.

  In the data sharing system according to any one of the above-described features, the present invention further includes a format information database that stores a plurality of format information corresponding to a plurality of software servers, and the conversion processing server performs tag information in the fifth step. It is determined whether the same format format information as the conversion source format information is stored in the format information database, and the same format format information as the conversion source format information is stored in the format information database. When the determination is made, a fifth step is to extract the conversion rule information of the conversion rule database based on the conversion source format and the converted format, and convert the format of the processing data according to the extracted conversion rule information. Features.

  According to the present invention, in the data sharing system according to any one of the above features, the data storage server stores directory designation information for designating a directory area corresponding to a software name including a software version of the software server that performed the data processing. In the second step, a directory area for storing processing data is extracted from the specification information storage unit using the software name from which the processing data is extracted as a key, and the extracted directory specification is stored in the second step. A sixth feature is that a directory area is designated by information.

Furthermore, the present invention refers to a conversion rule information database for storing a plurality of conversion rule information for converting data having different format formats to each other, and conversion rule information stored in the conversion rule information database, so that different format formats are used. A conversion processing server that is a computer for mutually converting data, a data storage section in which data storage areas are formed as a plurality of directory areas, and directory storage location information and data of data stored in the plurality of directory areas A data storage server that is a computer having a tag information generation unit that generates tag information based on a name, a user name, and format information, and one software server that processes data in a predetermined format, Other than the prescribed format A data sharing method in a computer system for processing shared data with other software servers for processing data format of handled in common,
In the data storage server,
A first step of extracting processing data processed by the one software server;
Executing the second step of storing the processing data extracted in the first step in the designated directory area of the data storage unit;
Tag information including source format information and converted format information is generated based on the directory area of the processing data inquired in the second step, the data name of the processing data, the user name, and the format information. A third step;
In the conversion processing server,
A fourth step of polling the storage unit of the data storage server to inquire about a directory area in which processing data is stored;
Extracting the conversion source format format and the converted format format of the tag information generated in the fourth step, extracting the conversion rule information of the conversion rule database based on the conversion source format format and the converted format format, and extracting A fifth step of converting the format format of the processing data in accordance with the converted conversion rule information;
A seventh feature is that the sixth step of transferring the data whose format has been converted in the fifth step is transferred to the other software server.

Further, the present invention causes the data storage server of the data sharing method to generate tag information including a data name, a user name, and format information before and after conversion in the third step,
A seventh step of generating an e-mail message including the data name, the user name, and the format information before and after conversion included in the conversion tag information;
An eighth feature is that an eighth step of transmitting the e-mail generated in the seventh step to the e-mail address of the user name included in the conversion tag information is executed.

  According to the present invention, an archive storage unit for storing the processed data subjected to format conversion is provided in a data storage server of the data sharing method according to any one of the above characteristics, and the processed data converted in format format in the fifth step The ninth feature is that the tag information is stored in the archive storage unit.

  According to the present invention, in the data sharing method according to any one of the above features, a use terminal that is a computer having a data storage area unit for using software installed in the software server is provided, and the conversion processing server is the electronic device. When the mail text is transmitted to the user terminal, the user terminal that has received the e-mail stores the processing data whose format has been converted by the data storage server in the data storage area unit, A tenth feature is that the stored processing data is transferred to the other software server.

  In the data sharing method of any one of the above features, the present invention provides a format information database for storing a plurality of format information corresponding to a plurality of software servers, and the tag information is added to the conversion processing server by the fifth step. If the same format format information as the conversion source format information is stored in the format information database, the same format format information as the conversion source format information is stored in the format information database. When the determination is made, the conversion rule information of the conversion rule database is extracted based on the conversion source format and the converted format, and the format of the processing data is converted according to the extracted conversion rule information. Features.

  According to the present invention, in the data sharing method according to any one of the above characteristics, directory designation information for designating a directory area corresponding to a software name including a software version of the software server that performed the data processing is stored in the data storage server. In the second step, the directory area for storing the processing data is extracted from the specification information storage unit using the name of the software server from which the processing data is extracted as a key, and the extracted directory specification is provided. A twelfth feature is that a directory area is designated by information.

  The data sharing system and method according to the present invention includes a first step in which the data storage server extracts the processing data of the software server, a second step of determining a directory area for storing the extracted processing data based on the directory designation information, A third step of storing processing data in the determined directory area, and a fourth step in which the conversion processing server inquires about a directory area in which the processing data is stored; a directory area of the inquired processing data; A fifth step of generating tag information including conversion source / converted format format information based on the data name of the processing data, the user name, and the format format information, and the conversion format format and conversion of the generated tag information Extract the post format, and convert the original format and post format 6th step of extracting the conversion rule information of the conversion rule database based on the expression, and converting the format format of the processing data according to the extracted conversion rule information; The shared data in the plurality of business package software can be easily shared by executing the seventh step of transferring to the software server.

The figure which shows one Embodiment of the business computer system to which the data sharing system by this invention is applied. The figure which shows the structure of the utilization terminal by this embodiment. The figure which shows the structure of the work terminal by this embodiment. The figure which shows the structure of the data storage server by this embodiment. The figure which shows the structure of the conversion process server by this embodiment. The figure which shows the structure of the package software server by this embodiment. The figure which shows the example of package software data by this embodiment. The figure for demonstrating the Format database structure by this embodiment. The figure for demonstrating the conversion rule database structure by this embodiment. The figure for demonstrating the conversion tag by this embodiment. The figure for demonstrating the content of the response mail by this embodiment. The figure which shows the structure of the conversion source file directory by this embodiment. The figure for demonstrating the data conversion reception process by this embodiment. The figure for demonstrating the data conversion process by this embodiment. The figure for demonstrating the conversion result notification process and the file expansion | deployment process after conversion by this embodiment. The figure for demonstrating the conversion source archive process by this embodiment. The figure for demonstrating the conversion setting process for management by this embodiment. The figure for demonstrating the tagging process by this embodiment. The figure for demonstrating the conversion rule selection process by this embodiment. The figure for demonstrating the response mail preparation process by this embodiment.

Hereinafter, an embodiment of a data sharing system and a data sharing method according to the present invention will be described in detail with reference to the drawings.
[overall structure]
As shown in FIG. 1, a computer system that is a data sharing system that employs the data sharing method according to the present embodiment includes a plurality of package software servers (computers) 16A and 16B that execute business package software in charge of different business, Data used to store data handled by the package software servers 16A and 16B, the plurality of use terminals 10A to 10C connected by the public communication line network 11 and operated by a plurality of users, and the package software servers 16A and 16B. A storage server 12, a format database 14 for storing a plurality of data format information individually handled by the package software servers 16A and 16B, and a variable for performing data conversion to be described later. In a normal routine work, it includes a conversion rule database 15 that stores rule information, and a conversion processing server 13 that performs data conversion by referring to the Format database 14 and the conversion rule database 15 according to instructions from the work terminal 17. The user is configured to operate a plurality of tasks by the package software servers 16A and 16B using the use terminals 10A to 10C.

[Use terminals 10A to 10C]
As shown in FIG. 2, the use terminals 10A to 10C include a keyboard 102 for inputting data, a mouse 103 as a pointing device, a display device 104 for displaying various information, and converted data according to the present embodiment. A data area unit 107 for storing data, an internal memory 105 for storing various program groups 106, and a CPU 10 for controlling the parts. The program group 106 operates package software of the software servers 16A and 16B. Package software interface program 1061 which is a program necessary for data storage and the exported package software data in the conversion source file directory of the data storage server 12 or the converted file directory of the data storage server 12 Includes a file operation program 1062 for downloading the converted data generated to the user terminal 1OA - 1OC, a mail transmission and reception program 1063 is a program for receiving e-mail sent from the data storage server 12. The data area section is provided in a storage element or storage device such as a semiconductor memory or a magnetic disk device, and the same applies to terminals and servers described later.

[Working terminal 17]
As shown in FIG. 3, the work terminal 17 includes a keyboard 172 / mouse 173 / display device 174 / CPU 171 similar to the above-described use terminal, and a conversion rule / user / domain directory in the conversion source directory of the data storage server. A file operation program 1761 that is a program for creating (see FIG. 12) and a general Web browser that uses the Web UI of the conversion processing server 13 to use the Format setting unit and the conversion rule setting unit And an internal memory 175 for storing a program group 176 including a browser 1762.

[Data storage server 12]
As shown in FIG. 4, the data storage server 12 includes a keyboard 122 / mouse 123 / display device 124 / CPU 121, an internal memory 125 including a data storage program 126 for performing data conversion, and data conversion. And a data area unit 127 which is a work memory for performing.

  The data area 127 is a directory for storing files to be converted by the user. The directory name is the user and the company domain. The conversion requester mail address can be specified and the conversion rule can be determined. A conversion source file directory 1271 having a structure (details are shown in FIG. 12) and a directory in which the conversion source file and the conversion tag are stored by the file copy unit 1262, and the conversion processing server 13 is newly stored in this directory And the conversion processing server 13 stores the converted data, which is an area provided for the conversion file polling unit to detect (a control procedure for inquiring whether there is a transmission request according to a predetermined order). Directory, where the user When the error occurs, the converted file directory 1273, which is an area for acquiring the converted data stored in the file, and the conversion source package software data and the conversion tag stored in the polling directory 1272 are temporarily stored. In the case of an unexpected operation, an archive directory 1274, which is an area for receiving a report from the user and temporarily storing the system administrator to confirm the operation, is provided.

  When the area of the polling directory 1272 for storing the data of the package software server is automatically performed, the directory designation information for designating the storage area based on the name of the package software server from which the data is acquired is stored as the directory designation information. A designation information storage unit (not shown) may be provided. This directory designation information is information indicating in which of multiple directory areas of the conversion source file directory 1271 to be described later the processing data processed by the server 16A is stored. In this case, it is specified whether the processing data of the server 16A is stored in the “Format1 To Format2” directory shown in FIG. 12, and whether the processing data of the server 16B is stored in the “Format2 To Format1” directory. It is.

  In the data storage program 126 of the internal memory 125, the conversion requesting user's mail address and conversion rule (conversion source file Format, converted file Format) are determined from the directory name of the data storage server 12, and a conversion tag is created. Tagging unit 1261, file copy unit 1262 for saving the created conversion tag and the packaged software data as the conversion source file stored in the conversion source file directory to the polling directory, and the conversion processing server converting the converted data The archive directory 1263 for obtaining the converted data stored in this directory by the user and the entire text of the response mail text received from the conversion processing server 13 are used to send an e-mail. Create Mail From the source, destination and Mail the To, subject to Subject, the Data body) and includes an e-mail notification unit 1264 to be sent.

[Conversion processing server 13]
As shown in FIG. 5, the conversion processing server 13 includes a conversion program 133 composed of a plurality of tool programs for controlling data conversion processing, a mail transmission program 134 for generating an e-mail response sentence, and a data conversion Are stored, and an administrator program 135 that is operated by an administrator to register data format information settings and conversion rules is stored.

  The conversion program 133 is a conversion source file polling unit 1331 that periodically checks (inquires) whether there is a file in the conversion source file directory of the file storage server in order to check whether the conversion processing target is stored. Is a program that reads the information of the conversion tag and selects a processing rule to check the information of the conversion tag “conversion source file format” and “converted file format” and pass the confirmation contents to the conversion rule selection unit. The tag reading unit 1332 and the format of the conversion source file Format are searched from the format name column (record) in the format database 14, and the format configuration (number of columns, type, number of characters, FIL) is checked for any differences. Source file Format and after conversion A conversion rule selection unit 1333 that searches for a record of a rule name from the conversion rule database 15 using the file format as a key and calls the corresponding conversion rule is provided. The conversion rule selection unit 1333 executes conversion processing. A function for saving the converted file created in this way, a function for saving in the converted file directory of the server, and a function for writing the date and time when processing is completed to the conversion tag as the processing end date and time.

  The mail transmission program 134 has a function of writing the “conversion format specification” item of the conversion tag in the Data item of the response mail message (however, the file conversion request user item of the notification message is written as Mail To (destination)), and the Error item is If not blank, convert to the first line of the Data section of the response mail text Format Error, the function to write the Object as Error, if the Error section is blank, the function to write the Subject part as file conversion completion, the file conversion execution date and time of the conversion tag / Completion date / time / Conversion processing management ID Mail response data reading unit 1341 having the function of writing to the Data section of the response mail text, and response mail text creation having the function of passing the response mail text to the e-mail notification program of the data storage server Part 1342.

  The administrator program 135 includes a format setting unit 1351 for the administrator to set the format of data, and a conversion rule setting unit 1352 for the administrator to set conversion rules between the formats.

[Package software servers 16A and 16B]
As shown in FIG. 6, the package software servers 16A and 16B include an internal memory 162 that stores a package software program 163 that is a program for managing a specific business such as production management, and a package that is data for the specific business. It comprises a data area 164 for storing software data 165 and a CPU 161 for controlling them. The package software program 163 includes, for example, a data receiving unit 1631 having a function of receiving data from the use terminals 10A to 10C, a data processing unit 1632 having a function of executing data processing of the received data, and the data processing And a data storage unit 1633 having a function of storing data obtained as a result of processing by the unit 1632.

  For example, as shown in FIG. 7, the package software data 165 is composed of item information of company name (Company) / phone number (TelNumber) / name (FName, LName) / address (Address). In the embodiment, the data file 1651 will be described as shared data.

[Format database 14]
As shown in FIG. 8A, the format data stored in the format database 14 includes a format name that is a format name, a column number that indicates the number of columns of each format, and a column name that is the name of the column. , A type indicating the data format, a number of character bytes indicating the length (upper limit value) that can be input to the column, and an FIL indicating whether or not an FIL padding occurs when an uninput length occurs in the number of character bytes Specifically, the data content is as shown by reference numeral 14d in FIG. 8B.
[Conversion rule database 15]
As shown in FIG. 9A, the conversion rule database 15 includes a rule name indicating which format is converted to which format, and item information of processing contents indicating specific rules for conversion. In FIG. 9B, as indicated by reference numeral 15a, the rule name is “Format 1 To Format 2” and the processing content is “Company” in column 1 of Format 1 is copied to [Company] in column 1 of Format 2. Note that “number” in the figure means half-width numbers, “character” means full-width characters, and for example, “character → number” in type conversion means full-width characters. It is defined to convert a lot number value written in characters into a half-width lot number value.

[Conversion tag information]
In the data sharing system according to the present embodiment, when one package software server 16A or 16B executes predetermined business data processing in accordance with a user instruction, the tagging unit 1261 of the data storage server 12 converts conversion information for data conversion ( In this embodiment, it is also referred to as “conversion tag information”), and the conversion processing server 13 refers to the conversion tag and selects a conversion rule. As shown in FIG. The conversion source format, the converted format, the mail address of the “file conversion request user”, the rule at the time of error occurrence, the file conversion execution date / time, the conversion processing management ID, and the item information of the file conversion completion date / time in XML syntax format It is described.

[Response mail text]
Furthermore, the data sharing system according to the present embodiment generates a mail text (referred to as “response mail text” in the present embodiment) addressed to the change requester when the conversion processing server 13 executes the data conversion processing, and the data storage server 11, the response mail text is, as shown in FIG. 11, “file conversion complete” as the conversion processing server as the mail transmission source, the file conversion request server as the mail transmission destination, and the subject (subject name). , The data includes each item information of conversion source / post-conversion file / file storage execution date / time to completion date / time and conversion processing management ID.

[Conversion source file directory 1271]
The conversion source file directory 1271 indicates the directory structure of the storage area. As shown in FIG. 12, there are a plurality of user name areas such as User1 / User2 below “Company-Domain”. A format conversion rule name area (Format2 To Format1, etc.) such as Format2 To Format1 is stored in the lower layer of the area.

[Operation]
The data sharing system according to the present embodiment, as shown in FIG. 13, when the package software interface program 1061 of the use terminals 10A to 10C executes the function of instructing the extraction of the package software data by the user's operation, A process of executing a function of performing extraction processing of the package software data 165 stored in the data area unit 164 by the data processing unit 1632 of 16A or 16B, and the terminal 10A to 10C using the extracted package software data 165 in its own data area A step of transferring the received package software data 165 to an arbitrary area (conversion of the conversion source file directory 1271). The function of storing in the directory area arbitrarily designated according to the data format desired by the client or the directory area designated by the directory designation information) and the tagging unit 1261 includes the conversion source file directory 1271 With reference to the information (directory structure information in FIG. 12), a step of performing a function of generating conversion tag information as shown in FIG. 10 based on the directory structure information is executed. The storage area (directory) of the conversion source file directory 1271 for storing the package software data is determined according to a predetermined rule. For example, the server 16A has a format 1 data format, and the server 16B has a format 2 format. The data format is such that the data created by the server 16A is stored in the “Format1 To Format2” directory, and the data created by the server 16B is stored in the “Format2 To Format1” directory. Yes.

  For example, when the package software data 165 is stored in the “Format 1 To Format 2” directory of User 1 shown in FIG. 12, the tag information is generated using the format 1 at the top of the directory name as the conversion source and the next Format 2 as After conversion, an e-mail address (domain is specified in advance) including the user number (User1) above the directory is created, and the file storage date / time information is generated based on the system time of the computer, and these information are shown in FIG. It is generated by fitting in XML data of a format.

  More specifically, this tag information generation process is performed as follows. The date information attached to the package software data 165 stored in the conversion source file directory 1271 in the data area 127 of the data storage server 12 is shown in FIG. From the step 1261a for generating the conversion tag information file in which the storage / update date / time information is extracted and determined based on the date and time, and a random number added to the date / time is set as the name, and the storage directory name and directory structure of the data 165 Step 1261b for determining the conversion source file Format / post-conversion Format / conversion requester name and writing it to the conversion tag information, and step 1261c for writing the file save date and time information attached to the file name of the data 165 to the conversion tag information Conversion tag name and conversion processing management ID By executing the steps 1261d writing conversion tag information et Te, it is possible to automatically generate a transform tag information.

  Next, in the data sharing system according to the present embodiment, as shown in FIG. 14, the data storage server 12 stores the generated conversion tag information 200 and package software data 165 in the polling directory 1272 using the file copy unit 1262. Execute the process. Subsequently, in the data sharing system, following the above-described steps, the conversion processing server 13 performs data polling (periodic inquiry) using the conversion source file polling unit 1331 so that data is transferred to the polling directory 1272. Inquiring whether or not the data is stored, and when it is determined that the data exists, the conversion tag information stored in the directory 1272 is read and the conversion source and the converted Format format are extracted and confirmed. A process, a process of referring to the Format database 14 and the conversion rule database 15 using the conversion rule selection unit 1333, storing the data after execution of the conversion process in the converted file directory 1273, and a mail response tag reading unit 1341 Move on to processing To perform the steps of.

  In the conversion process by the conversion rule selection unit 1333 described above, a function for selecting a conversion rule with reference to the conversion rule database 15 is executed. The conversion rule selection process includes a conversion tag as shown in FIG. The format of the conversion source format is discriminated by referring to the information 200, and the format structure is different by comparing the step 1333a for searching the record of the format name in the format database 14 with the conversion source file (data 165) searched from the format database 14. Step 1333b for determining whether or not there is a difference between Step 1333b and Step 1333g, the fact that the conversion source format is different is written in the error term in the conversion tag information, and the process proceeds to 1333h in the response mail sentence creation step; , For When it is determined that there is no difference in at 1333b, step 1333c for calling the conversion rule (FIG. 9) from the conversion source / converted Format included in the conversion tag information, and data conversion according to the conversion rule called by the step are executed. Step 1333d for creating converted file data; Step 1333e for storing the created converted file data in the converted file directory 1273 of the data storage server; Data conversion according to the conversion rule can be performed by executing the step 1333f that is obtained and written in the conversion tag information and moves to the processing of the response mail sentence creation unit 1341.

  Next, in the data sharing system, as illustrated in FIG. 15, the conversion processing server 13 specifies the change requester (file change requester “User1”) from the conversion tag information 200 using the mail response tag reading unit 1341. The response mail text creation unit 1342 is used to create the response mail text 18 (FIG. 11) addressed to the change requester and send it to the email notification unit 1264 of the data storage server 12. The storage server 12 generates a mail based on the response mail text 18 using the e-mail notification unit 1264, stores the mail in the archive directory 1263 and transmits the mail to the user terminal, and the user terminal 10 that has received the mail , Receiving the mail, and using the file operation program 1062 to convert the converted file data in the data storage server 12. The process of connecting to the directory 1273 and acquiring the converted file into the data area unit 107 and executing the acquisition of the acquired converted data into the data area unit 164 of the package software server 16 using the package software interface program 1061 By doing so, for example, the data processed by the server 16A can be converted into the format of the server 16B by the conversion processing server 13 and stored in the server 16B.

  The above-described response mail sentence 18 (FIG. 11) is created by the mail response tag reading unit 1341 of the conversion processing server 13 referring to the conversion tag 200 and the change requester address and the conversion format as shown in FIG. Step 1341a for extracting the part and writing it in the response mail text; Step 1341b for determining whether or not the error item is blank; and if it is determined in Step 1341b that it is not blank, the subject (subject name) part of the response mail text is “ "Error" and step 1341c in which "Conversion Error Format" is entered in the first line of the Data portion, and when it is determined in Step 1341b that the Error term is not blank, "subject file conversion" Step 1341e, which is described as “Complete”, and Step 13 Subsequent to 1d or 1341c, the file conversion execution date / time / completion date / time and the conversion process management ID are extracted and executed in step 1341e, which is added to the response mail text, and each data read by the reading section 1341 is processed as a response mail text creating section. The response mail is created by operating 1342 as a response mail text data format to the electronic mail notification unit 1264.

  The archive directory 1263 of the data storage server 12 that has received the response mail from the e-mail notification unit 1264 archives the package software data 165 and the conversion tag information 200 that are pre-conversion files in the polling directory 1272, as shown in FIG. The step of moving to the directory for use 1274 is executed.

  As described above, the data sharing system to which the data sharing method according to the present embodiment is applied includes the step of storing the data 165 processed by the package software server 16A or 16B in the business process in the data area unit 164, and the data storage server. 12 stores the conversion tag information on the basis of the step of saving the data 165 in an arbitrary storage area of the conversion source file directory 1271, the directory structure of the predetermined storage area of the conversion source file directory 1271, the date and time of data storage, and the like. Step of generating and storing in the polling directory 1272 (FIG. 18), and when the conversion processing server 13 polls the polling directory 1272 and confirms the existence of the conversion tag information 200 and the data 165, the conversion tag information 200 Conversion source and post-conversion Fo a step of recognizing mat, a step of referring to the Format database 14 and the conversion rule database based on the format before and after the conversion (FIG. 14), a conversion requester of the conversion tag 200 and format information A step of generating a response mail text based on FIG. 18, a step of transmitting the generated response mail text to the data storage server 12, and a conversion stored in the converted file directory 1273 by the data storage server 12 The post-data and the conversion tag information are moved to the archive directory 1274 and transferred to the corresponding package software server 16 after conversion via the use terminal 10, whereby the data handled by one package software server is F of other package software server It can be provided by converting the rmat format.

  In the above embodiment, an example in which there are two software servers has been described. However, even when there are a large number of software servers, shared data common to the software servers is analyzed in advance, and the conversion source file is analyzed. By reflecting in advance in the directory structure, data of a large number of software servers can be shared. Furthermore, in the present invention, even when a new software server is added to the computer system shown in FIG. 1, the shared data between the newly added software server and the existing software server is analyzed in advance, and the conversion source file directory By reflecting in advance in the structure, shared data can be input to the added software server.

  As shown in FIG. 17, the conversion source file directory structure is set by the file operation program 1761 reconstructing the structure of the conversion source file directory 1271 in the data storage server 12 by the operation of the administrator operating the work terminal 17. The new format information 1762a is registered in the format database 14 through the format setting unit 1351 of the conversion processing server 13 using the browser 1762, and the new conversion rule information 1762b is registered through the conversion rule setting unit 1352. 15 can be performed.

  10A to 10C: use terminal, 11: public communication network, 12: data storage server, 13: conversion processing server, 14: format database, 15: conversion rule database, 16A-16B: package software server, 17: work terminal, 18: Response mail text, 102: Keyboard, 103: Mouse, 104: Display device, 105: Internal memory, 106: Program group, 107: Data area section, 125: Internal memory, 126: Data storage program, 127: Data area Part: 133: conversion program, 134: mail transmission program, 135: administrator program, 162: internal memory, 163: package software program, 164: data area part, 165: package software data, 200: conversion tag information, 1061 : Cage software interface program, 1062: file operation program, 1063: mail transmission / reception program, 1262: file copy unit, 1263: archive directory, 1264: email notification unit, 1271: conversion source file directory, 1272: polling directory, 1273 : Converted file directory, 1274: Archive directory, 1331: Conversion source file polling unit, 1332: Tag reading unit, 1333: Conversion rule selection unit, 1341: Mail response data reading unit, 1342: Response mail sentence creation unit 1351: Format setting unit, 1352: Conversion rule setting unit, 1631: Data reception unit, 1632: Data processing unit, 1633: Data storage unit, 1651: Data file Le, 1761: file operation program.

Claims (12)

A data sharing system that processes shared data that is commonly handled by one software server that processes data in a predetermined format and another software server that processes data in the other format different from the predetermined format There,
A conversion rule information database for storing a plurality of conversion rule information for mutually converting data having different format formats;
A conversion processing server that is a computer that refers to the conversion rule information stored in the conversion rule information database and converts data of different formats to each other;
Tag information based on a data storage section in which a data storage area is formed as a multi-layer and a plurality of directory areas, and directory storage position information, data names, user names, and format information of the data stored in the multi-layer and a plurality of directory areas A data storage server that is a computer having a tag information generation unit for generating
The data storage server is
A first step of extracting processing data processed by the one software server;
A second step of storing the processing data extracted in the first step in a designated directory area of the data storage unit;
The conversion processing server is
A third step of polling the storage unit of the data storage server to inquire about a directory area in which processing data is stored;
Tag information including conversion source format information and converted format information is generated based on the directory area of the processing data inquired in the third step, the data name of the processing data, the user name, and the format information. A fourth step;
Extracting the conversion source format format and the converted format format of the tag information generated in the fourth step, extracting the conversion rule information of the conversion rule database based on the conversion source format format and the converted format format, and extracting A fifth step of converting the format format of the processing data in accordance with the converted conversion rule information;
A data sharing system that executes the sixth step of transferring the data whose format has been converted in the fifth step to the other software server. The conversion processing server is
In the fourth step, tag information including data name and user name of processing data and format information before and after conversion is generated,
A seventh step of generating an e-mail message including the data name, the user name, and the format information before and after conversion included in the conversion tag information;
The data sharing system according to claim 1, wherein an eighth step of transmitting the e-mail generated in the seventh step to a mail address of a user name included in the conversion tag information is executed.   The data storage server has an archive storage unit for storing the processed data subjected to format conversion, and stores the processed data and the tag information whose format format has been converted in the fifth step in the archive storage unit. Item 3. The data sharing system according to Item 1 or 2.   A user terminal that is a computer having a data storage area unit for using software installed in the software server, and the conversion processing server transmits the e-mail text to the user terminal and receives the e-mail; 2. The use terminal stores the processing data whose format has been converted by the data storage server in the data storage area, and transfers the processing data stored in the data storage area to the other software server. 4. The data sharing system according to any one of 3 to 3.   A format information database for storing a plurality of format information corresponding to a plurality of software servers, wherein the conversion processing server receives the format information that is the same as the source format information of the tag information in the fifth step; It is determined whether or not it is stored in the database, and when it is determined that the same format format information as the conversion source format information is stored in the format information database, the conversion source format format and the converted format format are used as the basis. 5. The data sharing system according to claim 1, wherein the conversion rule information in the conversion rule database is extracted to convert the format of the processing data according to the extracted conversion rule information.   The data storage server has a designation information storage unit for storing directory designation information for designating a directory area corresponding to a software name including a software version of a software server that has performed the data processing. In the second step, 6. The directory area for storing data is extracted from the designation information storage unit using the software name from which the processing data is extracted as a key, and the server directory area is designated by the extracted directory designation information. Data sharing system. A conversion rule information database for storing a plurality of conversion rule information for mutually converting data of different format formats, and conversion rule information stored in the conversion rule information database, and referring to the data of different format formats. A conversion processing server, which is a computer for conversion, a data storage unit in which data storage areas are formed as a plurality of directory areas, and directory storage location information, data names, and user names of data stored in the plurality of directory areas A data storage server that is a computer having a tag information generation unit that generates tag information based on the format information, one software server that processes data of a predetermined format, and the predetermined format Is a different format A data sharing method in a computer system for processing the shared data to be handled in common with other software servers for processing the format of the data,
In the data storage server,
A first step of extracting processing data processed by the one software server;
Executing the second step of storing the processing data extracted in the first step in the designated directory area of the data storage unit;
In the conversion processing server,
A third step of polling the storage unit of the data storage server to inquire about a directory area in which processing data is stored;
Tag information including conversion source format information and converted format information is generated based on the directory area of the processing data inquired in the third step, the data name of the processing data, the user name, and the format information. A fourth step;
Extracting the conversion source format format and the converted format format of the tag information generated in the fourth step, extracting the conversion rule information of the conversion rule database based on the conversion source format format and the converted format format, and extracting A fifth step of converting the format format of the processing data in accordance with the converted conversion rule information;
A data sharing method for executing the sixth step of transferring the data whose format has been converted in the fifth step to the other software server. In the conversion processing server,
In the fourth step, tag information including data name and user name of processing data and format information before and after conversion is generated,
A seventh step of generating an e-mail message including the data name, the user name, and the format information before and after conversion included in the conversion tag information;
8. The data sharing method according to claim 7, wherein an eighth step of transmitting the e-mail generated in the seventh step to a mail address of a user name included in the conversion tag information is executed.   8. The data storage server is provided with an archive storage unit for storing the processing data subjected to format conversion, and the processing data and the tag information converted in format format in the fifth step are stored in the archive storage unit. Or the data sharing method according to 8.   A use terminal, which is a computer having a data storage area unit for using software installed in the software server, is provided, and the electronic mail is received when the conversion processing server sends the e-mail text to the use terminal. The processing data stored in the data storage area unit is stored in the data storage area unit, and the processing data stored in the data storage area unit is transferred to the other software server. The data sharing method according to any one of 7 to 9.   A format information database for storing a plurality of format information corresponding to a plurality of software servers is provided, and the format information that is the same as the format information of the tag information converted by the fifth step is stored in the format information in the conversion processing server. When it is determined whether or not the same format format information as the conversion source format information is stored in the format information database, it is determined based on the conversion source format format and the converted format format. The data sharing method according to claim 7, further comprising: extracting conversion rule information from the conversion rule database, and converting the format format of the processing data according to the extracted conversion rule information.   The data storage server is provided with a designation information storage unit for storing directory designation information for designating a directory area corresponding to a software name including a software version of the software server that has performed the data processing. 12. The directory area for storing the directory name is extracted from the designation information storage unit using the name of the software server from which the processing data is extracted as a key, and the directory area is designated by the extracted directory designation information. Data sharing method.

Images