JP2001067367A - Information generating system for data base - Google Patents

Abstract

PROBLEM TO BE SOLVED: To efficiently and economically establish a data base common to groups connected with a network. SOLUTION: In order to establish a data base on the basis of data included in communication information transmitted and received among groups connected with a network, a specific information repeating point connected to the network are allowed to pass the communication information. In that way, a data extraction processing part 22 extracts necessary data from the communication information and automatically establishes the data base at the information repeating point. An extraction data setting definition part 24 automatically generates at least a part of a program to be used for establishment on the basis of the information that indicates a format of the communication information. It is possible to extract the necessary data from the communication information and to automatically establish the data base.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database information generating system, and more particularly to a database information generating method capable of efficiently and economically constructing a common database between groups connected by a network. The present invention relates to a database information generation device and a computer-readable recording medium storing a computer program according to the database information generation device.

[0002]

2. Description of the Related Art In recent years, the Internet has become widespread, and various types of information have been exchanged not only with company information but also with other companies. In addition, electronic commerce (electric commerce) has been realized in which ordering and settlement of goods are performed electronically via a network such as the Internet.

A specific group that exchanges information via a network, for example, a group of subsidiaries having a specific company as a parent company, may construct a common database. In this case, conventionally, for example, dedicated data for building a database in a format designated by a parent company is collected from related subsidiaries, and a database is built based on these dedicated data.

For example, as shown by an arrow in FIG. 1, in a commercial transaction or the like, a participant 3 exchanges information necessary for the commercial transaction with a participant 3 of a related partner. In the case of constructing a common database, conventionally, apart from the information exchanged in this way, for example, the database is constructed in a designated transmission destination with dedicated data for database construction in a format designated by the parent company. Had to be sent again.

[0005]

However, the creation and transmission of such dedicated data places a burden on the subsidiary. In particular, if special data to be sent is newly generated or changed, it is necessary to change the program for creating or sending such dedicated data, and in some cases, create new data There is a problem in terms of cost and the like.

SUMMARY OF THE INVENTION The present invention has been made to solve the above-mentioned conventional problems, and an information generation system for a database capable of efficiently and economically constructing a database common between groups connected by a network. The purpose is to provide.

[0007]

First, a database information generation method according to a first invention of the present application is to construct a database based on data included in communication information transferred between groups connected via a network. The communication information is passed through a specific information relay point connected to the network, and necessary data is extracted from the communication information at the information relay point to automatically construct a database. And a translator for performing format conversion of communication information and a mapping tool for defining the translator, wherein at least a part of a program used for the construction is automatically generated based on the information indicating the mapping. Thus, the above problem has been solved.

Next, the database information generating apparatus of the second invention of the present application is connected to the network in order to construct a database based on data included in communication information transferred between groups connected on the network. A data extraction processing unit that extracts a necessary data from the communication information and automatically constructs a database at the information relay point so that the communication information passes through a specific information relay point; At least a part of the program to be used, an extraction data setting definition unit that automatically generates based on the information indicating the mapping, a translator that performs format conversion of communication information, and a mapping tool that performs the definition. This has solved the problem. The data extraction processing unit and the extracted data setting definition unit can be realized by a computer program as an entity.

Further, a computer-readable recording medium according to a third invention of the present application is a computer-readable recording medium storing a computer program for realizing the data extraction processing unit and the extraction data setting definition unit according to the second invention. This problem has been solved by providing a simple recording medium.

Hereinafter, the operation of the present invention will be briefly described.

FIG. 2 is a block diagram showing the configuration of a typical database information generating apparatus according to the present invention.

A database information generating apparatus 1 shown in FIG.
6 has a data extraction processing unit 22 and an extracted data setting definition unit 24.

In the present invention, since a database is constructed based on data included in communication information transferred between groups connected to the network, a specific information relay point connected to the network is determined by the communication information. To go through. Then, at the information relay point, the data extraction processing unit 22 extracts necessary data from the communication information and automatically constructs a database.

Next, the extracted data setting definition section 24 automatically generates at least a part of the program used for the construction based on information indicated by reference numeral 18, ie, information indicating the format of the communication information. I do. The communication information format information 18 is not particularly limited. For example, the communication information format information 18 may be information indicating a format of communication information sent from one participant 3 to another participant 3.

Therefore, according to the present invention, it is possible to automatically construct a database by extracting necessary data from the communication information at the information relay point. For this reason,
Apart from the information exchanged between the participants 3, it is not necessary to transmit, for example, dedicated data for database construction in a format designated by the parent company to a designated destination again for constructing the database. .

Further, at least a part of the program used for the construction can be automatically generated based on the communication information format information 18. Therefore, it is possible to reduce the time, labor, and cost required for creating a program necessary for the data extraction processing unit 22 and the like.

As described above, according to the present invention, a database common to groups connected by a network can be efficiently and economically constructed.

[0018]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Embodiments of the present invention will be described below in detail with reference to the drawings.

FIG. 3 is a block diagram showing the overall configuration of the database information generating system according to the embodiment to which the present invention is applied.

In this embodiment, in order to construct a database based on data included in communication information transferred between groups connected to the network, a specific information relay point connected to the network is specified by the communication information To go through. That is, the information exchanged between the participants 3 always passes through the information relay point.

Then, at the information relay point,
As shown in this figure, an EC center 10 is provided. In this figure, the place where the EC center 10 is installed corresponds to the information relay point in the present invention.

FIG. 4 is a block diagram showing the configuration of the EC center 10.

As shown in FIG. 1, the EC center 10 has a common DB (data base) 14 and a database information generator 16. The database information generating device 16 has the same configuration as that shown in FIG.
Data extraction processing unit 22 and extraction data setting definition unit 24
Having.

The database information generating device 16 operates as described above with reference to FIG. In addition, the shared DB1
4 may be provided outside the EC center 10. The communication information format information 18 is used when automatically generating at least a part of a program used for building the shared DB 14.
It may be taken from outside the EC center 10 each time. Alternatively, the communication information format information 18 may be stored inside the EC center 10, and the present invention is not limited to this.

FIG. 5 is a data flow diagram showing the processing performed by the data extraction processing section 22 described above.

In this figure, the communication information 50 is
This is an example of information exchanged between the participants 3, and is communication information conventionally transmitted directly from the participant 3 to another participant 3. The communication information 50 includes communication information configuration data A to E based on a predetermined format.

The database construction information 52 is used for constructing the shared DB 14. The database construction information 52 has a format in which the communication information configuration data A to E described above are rearranged in the order of "BEDAC".

The data extraction processing section 22 grasps the format relating to the communication information 50 from the communication information format information 18 described above. Then, the communication information configuration data A to E in the format is converted into the format of the database construction information 52 that is grasped in advance. The conversion is performed as shown in FIG.
This is a process mainly for sorting.

As described above, in the present embodiment, at the information relay point where the EC center 10 is installed, necessary data can be extracted from the communication information to automatically construct a database. Therefore, apart from the information exchanged between the participants 3, for example, it is not possible to retransmit dedicated data for building a database in a format specified by the parent company to a specified destination to build a database. Will be needed. Further, at least a part of the program used for the construction can be automatically generated based on the communication information format information 18. Therefore, it is possible to reduce the time, labor, and cost required to create a program required by the data extraction processing unit 22 and the like.

As described above, in the present embodiment, the present invention can be effectively applied. Therefore, a database common between groups connected by a network can be efficiently and economically constructed.

[0031]

According to the present invention, a database common to groups connected by a network can be efficiently and economically constructed.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a conventional exchange of communication information regarding a commercial transaction between participants.

FIG. 2 is a block diagram showing the configuration of a typical database information generation device according to the present invention.

FIG. 3 is a block diagram showing an overall configuration of a database information generation system according to an embodiment to which the present invention is applied;

FIG. 4 is a block diagram showing a configuration of an EC center used in the embodiment.

FIG. 5 is a data flow diagram showing processing performed by a data extraction processing unit of the embodiment.

[Explanation of symbols]

 3 Participant 10 EC Center 14 Shared DB 16 Database Information Generating Device 18 Communication Information Format Information 22 Data Extraction Processing Unit 24 Extracted Data Setting Definition Unit

Claims (3)

[Claims] An information processing system according to claim 1, wherein the communication information passes through a specific information relay point connected to the network in order to construct a database based on data included in communication information transferred between groups connected to the network. And a translator for extracting necessary data from the communication information and automatically constructing a database at the information relay point, and for performing a format conversion of the communication information;
A method for generating information for a database, comprising: a mapping tool for performing the definition, wherein at least a part of a program used for the construction is automatically generated based on the information indicating the mapping. 2. A method for constructing a database based on data included in communication information transferred between groups connected to a network, so that the communication information passes through a specific information relay point connected to the network. At the information relay point, a data extraction processing unit that extracts necessary data from the communication information and automatically constructs a database, and converts at least a part of a program used for the construction into information indicating the mapping. An extraction data setting and definition unit that automatically generates a communication information based on the format;
And a mapping tool for performing the definition. 3. The data extraction processing unit according to claim 2,
And a computer-readable recording medium recording a computer program for realizing the extracted data setting definition section.