JP2008242840A - Data linkage system, data linkage method and data linkage program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a data linkage system, method, and program, for sharing information by data linkage when a plurality of systems different in data exchange system or data format exit. <P>SOLUTION: A control part 21 of an integrated DB server 20 acquires transaction data, and forms transmitting data according to a reception base. The control part 21 determines a switching state by use of a base-based format data storage part 22, and transfers, when an integrated DB system is set in the reception base, the data to a legacy system 15. On the other hand, when the integrated DB system is not set, the control part 21 confirms the data linkage system in a delivery base. When a conventional data linkage system is not used in the delivery base, the control part 21 transfers the data to a linkage server 10 and data are transferred to the other base by a replication function. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to a data linkage system, a data linkage method, and a data linkage program for sharing information by data linkage in an environment where a plurality of systems having different data exchange methods and data formats coexist.

  Conventionally, when producing and selling products in each region, it is necessary to follow the rules and business practices in each region. For example, in the export management business, it is necessary to judge exports in light of various related laws and regulations.

  However, if the person in charge at each regional base makes a determination or the like manually, there is a possibility that the determination may vary. Therefore, a management system for improving work efficiency and improving determination accuracy has been studied (see, for example, Patent Document 1). In the system described in this document, a server or a client connected via a network is used. In accordance with the contents of the database, the server displays determination guidance including display of individual legal texts of export-related laws on the client, and the user makes a determination accordingly, and the result is stored in the database together with the reason for the determination.

In such an environment, each region has its own system for production management and sales management.
On the other hand, when production and sales are expanded globally, products sold in a predetermined region may be produced in other regions, and it is necessary to share production information and sales information. In this case, it is difficult to share information if each region has its own data management.

  Therefore, when performing global development, it is necessary to share information about production information and sales information. Therefore, as shown in FIG. 4, in order to share information, a base server 150 may be newly provided at sales bases or production bases in the United States, Europe, or Asia. The existing management system unique to each region that has been used for a long time is linked and integrated as a legacy system 100. In this case, the base server 150 extracts data to be shared with other bases from data managed in the legacy system 100. Then, the data exchange between the bases is performed using the replication function with the other base server 150. As this replication function, for example, the function of a replication server of Sybase (registered trademark) can be used. Thereby, the product supply information for the product sales plan can be managed and the global development can be advanced.

In addition, as a method of information sharing, it is conceivable that information of each region is integrated and managed in one database. In this case, the integrated DB server acquires various information from the legacy system in each region. In this case, information sharing can be performed without providing a base server in each region. As described above, a technique for realizing migration of database definitions and migration of database access processing in order to realize a new system and create a new database has been studied (for example, see Patent Document 2). In the technique described in this document, a new system record specification is created based on a database definition file for each organization, which describes the specifications of each record that does not depend on the data structure in the system of each organization in one common format. Then, an SQL statement for defining each record in a tabular form from the new system record specification is prepared. Then, a new database definition file for each organization that defines the substance of each record in the relational database and a copy phrase for each organization that defines the format of each record are created.
JP 2003-36323 A (first page) JP 2006-293796 A (first page)

  As described above, when bases are spread out in each region, a database switching schedule may be set up in each base according to the circumstances of each base, and it is difficult to switch systems at one time. On the other hand, when a new system and a conventional system coexist, it is necessary to ensure the consistency.

  In addition, with such a system renewal, there are cases where it is desired to use a data format that can utilize more accurate information. Accordingly, a plurality of systems may coexist and data formats may coexist.

  The present invention has been made in order to solve the above-described problems, and its purpose is to provide data linkage for sharing information by data linkage in an environment in which a plurality of systems having different data exchange methods and data formats are mixed. A system, a data link method, and a data link program are provided.

  In order to solve the above problem, the invention described in claim 1 is a first method for performing data linkage by replication between base systems installed at a plurality of bases, and a second system for centrally managing data of base systems. In order to use the system together, the base data storage means for storing data for identifying the first system or the second system employed in the base system is supported for each base identifier, and data linkage between the base systems is supported. A data link system including a control unit, wherein the control unit uses a transfer data acquisition unit that acquires shared information distributed from an arbitrary base system, and the base data storage unit, When the data linkage method adopted in the system is specified and the shared information is acquired by the first method, the second method is adopted. When the shared information is transferred to the base system by the second method and the shared information is acquired by the second method, it is shared by the second method to other base systems that adopt the second method. The gist of the present invention is that it includes data exchange control means for transferring information to the base system adopting the first method and transferring shared information by the first method.

  According to a second aspect of the present invention, in the data linkage system according to the first aspect of the present invention, the data linkage system further includes a format data storage unit that stores data for specifying a format employed in the base system for each base identifier, The gist further comprises a format conversion means for specifying the format employed in the transfer destination base system using the format data storage means and converting the shared information into the format.

  According to a third aspect of the present invention, in the data linkage system according to the first or second aspect of the present invention, the data linkage system further includes a transmission destination data storage unit that stores a transfer destination base identifier for each distribution base identifier. The gist of the present invention is that the control means specifies the base system of the transmission destination of the shared information using the transmission destination data storage means for the base where the shared information is distributed.

The invention according to claim 4 is provided in order to use both the first method for performing data linkage by replication between the base systems installed at a plurality of bases and the second method for centrally managing the data of the base system. A data linkage system comprising, for each identifier, a branch data storage unit that stores data for identifying the first method or the second method employed in the branch system, and a control unit that supports data linkage between the branch systems. In which the control unit obtains shared information distributed from an arbitrary base system, and at the base system of the transfer destination using the base data storage means When the adopted data linkage method is specified and the shared information is acquired by the first method, the other method adopting the second method is adopted. When the shared information is transferred to the system by the second method and the shared information is acquired by the second method, the shared information is transferred by the second method to other base systems that adopt the second method. And transferring the shared information according to the first method to the base system adopting the first method.

  According to the fifth aspect of the present invention, in order to use both the first method for performing data linkage among the base systems installed at a plurality of bases by replication and the second method for centrally managing the data of the base system, A data linkage system comprising, for each identifier, a branch data storage unit that stores data for identifying the first method or the second method employed in the branch system, and a control unit that supports data linkage between the branch systems. Using the transfer data acquisition means for acquiring shared information distributed from an arbitrary base system and the base data storage means, When the data linkage method adopted in the base system is specified and the shared information is acquired by the first method, the second When the shared information is transferred to the other base system that adopts the second method by the second method and the shared information is acquired by the second method, the other base system that adopts the second method The gist is to transfer the shared information by the second method and to function as a data exchange control means for transferring the shared information by the first method to the base system adopting the first method.

(Function)
According to the present invention, the control unit acquires shared information distributed from an arbitrary base system. Then, the data link method employed in the transfer destination base system is specified using the base data storage means. Further, when the shared information is acquired by the first method, the shared information is transferred by the second method to the base system adopting the second method. On the other hand, when the shared information is acquired by the second method, the shared information is transferred by the second method to the site system that adopts the second method, and the first is obtained for the site system that adopts the first method. Share information is transferred according to the method. Thereby, even when a plurality of data linkage methods coexist, shared information can be accurately transferred according to each base system, and data linkage can be performed.

  According to the present invention, the control unit uses the format data storage unit to identify the format employed in the transfer destination base system and convert the format of the shared information. Thereby, shared information can be provided in a format suitable for the base system.

  According to the present invention, the base system of the transmission destination of the shared information is specified using the transmission destination data storage unit for the base where the shared information is distributed. As a result, information can be efficiently transferred to a base that requires information.

  According to the present invention, there are provided a data linkage system, a data linkage method, and a data linkage program for sharing information by data linkage in an environment where a plurality of systems having different data exchange methods and data formats coexist.

Hereinafter, an embodiment embodying the present invention will be described with reference to FIGS. In the present embodiment, a data linkage system, a data linkage method, and a data linkage program for managing information related to product production and sales will be described.

  As shown in FIG. 1, it is assumed that a legacy system for performing production and sales management at each site (A, B, C, D) is installed. Here, the bases (A, B) are provided with base servers (10a, 10b) for information sharing together with the legacy systems (15a, 15b). This base server has a replication function with other base servers, and inter-base data linkage (first method) is realized by this function.

  On the other hand, the base J functions as an aggregation base. This base J is provided with an integrated DB server 20 connected to the cooperation server 10 together with the cooperation server 10. This linkage server 10 has a replication function in the same manner as other base servers (for example, base servers 10a and 10b). Then, data cooperation is realized with the base servers (10a, 10b) of the base that continuously uses the conventional data cooperation method. Furthermore, the cooperation server 10 transfers the data acquired by the conventional data cooperation method to the integrated DB server 20.

  Further, the integrated DB server 20 manages a database (integrated database) that accumulates information of each base in an integrated manner in order to realize inter-base data linkage (second method) by centrally managing the base system data. It is a server computer. The integrated DB server 20 acquires information from the legacy systems (for example, the bases C and D) at each base that has finished switching to the new data linkage system (second system). Here, data linkage is performed with the legacy systems (15c, 15d) of the bases (C, D).

In this embodiment, the base server (10a, 10b) and the legacy system (15c, 15d) function as the base system, and these systems distribute shared information.
As shown in FIG. 2, the integrated DB server 20 is a computer system that manages transaction data from each base in an integrated manner, and includes a control unit 21 including a CPU, storage means (RAM, ROM), communication means, and the like. ing. The integrated DB server 20 performs the processes described later (processing including a shared information acquisition stage, a data linkage system identification stage, a shared information transfer stage, a format conversion stage, a transmission destination base identification stage, and the like). By executing the data linkage program for this purpose, the control unit 21 functions as transfer data acquisition means 211, registration means 212, transmission data creation means 213, data exchange control means 214, and the like.

The transfer data acquisition unit 211 acquires various transaction data from the cooperation server 10 or the legacy system (15c, 15d).
The registration unit 212 functions as a format conversion unit, generates transaction data of an old format or a new format based on the acquired transaction data, and records it in each data storage unit (24, 25).

The transmission data creation means 213 specifies transmission destination bases and creates transmission data according to the format used at each base.
Then, the data exchange control unit 214 performs data transfer to the cooperation server 10 and the legacy system.

  The integrated DB server 20 further includes a base-specific format data storage unit 22, a transmission destination base data storage unit 23, a new format transaction data storage unit 24, and an old format transaction data storage unit 25.

The base format data storage unit 22 functions as base data storage means and format data storage means, and holds base format old and new format tables regarding the format information used and the switching status to the integrated DB. This new and old format table for each site is configured to include data relating to the format determination code and the parallel operation flag for the site code and table type code.

In the base code data field, data relating to an identifier for uniquely specifying each base is recorded.
In the table type code data field, data relating to codes for determining master, order (ordering) data, order status, and shipment results data is recorded.

In the format identification code data field, data for specifying a conventional data linkage method (first method) for specifying use of a base server in data linkage at a base or an integrated DB method (second method) using the integrated DB server 20 Is recorded. In the integrated DB method, data related to a code for determining whether the old format is used or the new format is used is recorded.
In the parallel operation flag data field, data for specifying the parallel operation status with the conventional data linkage method is recorded for the integrated DB method at this site.

  The transmission destination base data storage unit 23 functions as a transmission destination data storage unit, and holds a data transmission destination control table for specifying to which base the data received by the integrated DB server 20 is transmitted. This data transmission destination control table includes data related to the transmission destination base code with respect to the base code.

In the base code field, data relating to an identifier for uniquely specifying each base on the information distribution side is recorded.
In the transmission destination base code field, data for specifying the transmission destination base where the data received by the integrated DB server 20 is transmitted is recorded.

The new format transaction data storage unit 24 stores transaction data in a new format.
The old format transaction data storage unit 25 stores old format transaction data.

Next, a processing procedure when data linkage is performed using the above system will be described with reference to FIG.
First, the control unit 21 of the integrated DB server 20 executes transaction data acquisition processing (step S1-1). Specifically, in the case of a base (for example, bases A and B) that uses the conventional data linkage method, data linkage is performed by replication between the base servers. In this case, the cooperation server 10 acquires transaction data by replication. Then, the cooperation server 10 transfers the transaction data acquired from each base to the integrated DB server 20.

  On the other hand, in the case of a base using the integrated DB method (for example, bases C and D), the legacy system (15c, 15d) directly transfers the transaction data to the integrated DB server 20. Thereby, the transfer data acquisition means 211 of the control part 21 acquires transaction data from the cooperation server 10 or a legacy system.

  In this case, the control unit 21 of the integrated DB server 20 executes a data registration process (step S1-2). Specifically, the registration unit 212 of the control unit 21 checks the referential integrity before registration, and notifies an error to the distribution side base when an error occurs.

Next, the registration unit 212 generates a file converted into the new format in the case of the old format, and generates a file converted into the old format in the case of the new format. For example, in a new format with respect to an old format, a new item may be added or the number of digits may be changed. When converting from the new format to the old format, the conversion is performed by deleting new items in the new format or extracting the number of digits specified in the old format. Then, the registration unit 212 registers the old format file and the new format file in the new format transaction data storage unit 24 and the old format transaction data storage unit 25, respectively.

  Next, the control unit 21 of the integrated DB server 20 executes transmission data creation processing (step S1-3). The transmission data creation means 213 of the control unit 21 acquires the distribution side base code included in the transaction data. Then, the transmission data creation unit 213 acquires a transmission destination base code corresponding to the distribution side base code data from the data transmission destination control table of the transmission destination base data storage unit 23.

  Then, the transmission data creation unit 213 acquires data related to the transmission destination base code from the base-specific format table in the base-specific format data storage unit 22. As a result, the transmission data creation unit 213 can determine whether or not the integrated DB server is used at the transmission destination base and the old and new formats. Then, the transmission data creation means 213 creates a transmission data file in accordance with the format of each base.

  Next, the control unit 21 of the integrated DB server 20 performs the processes after step S1-4. In this case, the control unit 21 of the integrated DB server 20 sequentially identifies the transmission destination bases, and executes it for each base.

  First, the control unit 21 of the integrated DB server 20 executes a confirmation process of the status of switching to the integrated DB method at the transmission destination base (step S1-4). The data exchange control means 214 of the control unit 21 determines the switching status using the new and old format tables for each site recorded in the format data storage unit 22 for each site. Here, when the transmission destination site has been switched to the integrated DB method (in the case of “YES” in step S1-4), the data exchange control means 214 of the control unit 21 of the integrated DB server 20 determines the legacy of this site. Data transfer processing to the system is executed (step S1-5). For example, when the transmission destination base is the base (C, D), step S1-5 is executed.

  On the other hand, when the transmission destination base has not yet been switched to the integrated DB method (in the case of “NO” in step S1-4), the data exchange control means 214 of the control unit 21 of the integrated DB server 20 A confirmation process of the data linkage method at the base is executed (step S1-6). This process is also determined using the parallel operation flag of the new and old format tables for each site recorded in the format data storage unit 22 for each site.

  Here, when the distribution side base does not use the conventional data linkage method (in the case of “NO” in step S1-6), the data exchange control means 214 of the control unit 21 of the integrated DB server 20 performs the linkage. Data transfer processing for the server 10 is executed (step S1-7). In this case, the cooperation server 10 replicates data to other base servers by the replication function (step S2-1).

  On the other hand, when the conventional data linkage method is used at the distribution side base (in the case of “YES” in step S1-6), the processing regarding the transmission destination base is terminated. The above processing is repeated for each identified transmission destination base.

For example, when the transmission destination base is the base (C, D), the data exchange control means 214 of the control unit 21 executes the data transfer process to the legacy system regardless of the distribution side base (step S1-5). ). Further, when the distribution side base is the base (C, D) and the transmission destination base is the base (A, B), the data exchange control means 214 of the control unit 21 executes the data transfer process for the cooperation server 10. (Step S1-7), and replication is performed from the cooperation server 10 to the legacy system (15c, 15d) (Step S2-1). When both the distribution side base and the transmission destination base use the conventional data linkage method, the integrated DB server 20 does not perform processing for data linkage.

As described above, according to the present embodiment, the following effects can be obtained.
-In above-mentioned embodiment, the integrated DB server 20 connected to the cooperation server 10 with the cooperation server 10 is provided. When transaction data is distributed from a base that uses the conventional data linkage method, the linkage server 10 acquires the transaction data by data linkage by conventional replication between the base servers. And since the cooperation server 10 transfers the transaction data acquired from each base to the integrated DB server 20, the integrated DB server 20 can acquire transaction data from the base using the conventional data cooperation method. .

  In the above embodiment, the control unit 21 of the integrated DB server 20 executes a confirmation process of the status of switching to the integrated DB method at the transmission destination base (step S1-4). When the transmission destination site has been switched to the integrated DB method (in the case of “YES” in step S1-4), the data exchange control means 214 of the control unit 21 of the integrated DB server 20 Data transfer processing is executed (step S1-5). Thereby, the data acquired by the new integrated DB system can be provided to other systems using the integrated DB system.

  In the above embodiment, when the distribution side base does not use the conventional data linkage method (in the case of “NO” in step S1-6), the data exchange control means 214 of the control unit 21 of the integrated DB server 20 Executes data transfer processing for the cooperation server 10 (step S1-7). In this case, the cooperation server 10 replicates data to other base servers by the replication function (step S2-1). Thereby, the data acquired by the new integrated DB method can be provided to other systems that do not use the integrated DB method.

  In the above embodiment, when the conventional data linkage method is used at the distribution side base (in the case of “YES” in step S1-6), the processing regarding the transmission destination base is terminated. As a result, in other systems using the integrated DB method, information has already been acquired by replication between base servers, so that it is possible to suppress information distribution again.

In addition, you may change the said embodiment into the following aspects.
In the above embodiment, data exchange is performed between the cooperation servers 10 by replication, but the data cooperation method is not limited to this.

  In the above embodiment, the old and new formats are used together, but a unified format can be used. In this case, the integrated DB server 20 only controls data transfer.

In the above embodiment, the control unit 21 of the integrated DB server 20 performs the processes after step S1-4. In this case, the control unit 21 of the integrated DB server 20 sequentially identifies the transmission destination bases, and executes it for each base. Instead of this, it is also possible to first perform transmission processing in the conventional data linkage method. In this case, first, the data exchange control unit 214 of the control unit 21 of the integrated DB server 20 executes a confirmation process of the data cooperation method at the distribution base. When the distribution side base does not use the conventional data linkage method (in the case of “NO” in step S1-6), the data exchange control means 214 of the control unit 21 of the integrated DB server 20 The data transfer process for 10 is executed. Only the bases using the new integrated DB system perform data transfer individually.

1 is a schematic diagram of a system according to an embodiment of the present invention. Explanatory drawing of the functional block of an integrated DB server. Explanatory drawing of the process sequence of one Embodiment of this invention. Schematic diagram of a conventional system.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 10 ... Cooperation server, 10a, 10b ... Base server, 15, 15a, 15b, 15c, 15d ... Legacy system, 20 ... Integrated DB server, 21 ... Control part, 211 ... Transfer data acquisition means, 212 ... Registration means, 213 ... Transmission data creation means, 214... Data exchange control means, 22... Location-specific format data storage section, 23... Transmission destination base data storage section, 24... New format transaction data storage section, 25.

Claims (5)

In order to use both the first method that links data between the base systems installed at multiple bases by replication and the second method that centrally manages the data of the base system, each base identifier is adopted in the base system. Base data storage means storing data for identifying the first method or the second method,
A data linkage system comprising a control unit for supporting data linkage between base systems,
The control unit is
Transfer data acquisition means for acquiring shared information distributed from any base system;
Using the base data storage means, identify the data linkage method adopted in the transfer destination base system,
When the shared information is acquired by the first method, the shared information is transferred by the second method to other base systems that adopt the second method,
When the shared information is acquired by the second method, the shared information is transferred by the second method to other base systems that adopt the second method, and for the base system that adopts the first method. And a data exchange control means for transferring shared information according to the first method. For each site identifier, further comprising a format data storage means for storing data specifying the format adopted in the site system,
The control unit further comprises format conversion means for specifying a format employed in a transfer destination base system using the format data storage means and converting the shared information into the format. The data linkage system according to claim 1. For each base identifier of the distribution source, further comprising transmission destination data storage means storing the base identifier of the transfer destination,
The said data exchange control means specifies the base system of the transmission destination of the said shared information using the said transmission destination data storage means with respect to the base which distributed the shared information. The data linkage system described. In order to use both the first method that links data between the base systems installed at multiple bases by replication and the second method that centrally manages the data of the base system, each base identifier is adopted in the base system. Base data storage means storing data for identifying the first method or the second method,
A method for performing data linkage using a data linkage system including a control unit that supports data linkage between base systems,
The control unit is
Acquiring shared information distributed from any base system;
Using the base data storage means, identify the data linkage method adopted in the transfer destination base system,
When the shared information is acquired by the first method, the shared information is transferred by the second method to other base systems that adopt the second method,
When the shared information is acquired by the second method, the shared information is transferred by the second method to another base system that adopts the second method, and for the base system that adopts the first method. And transferring the shared information according to the first method. In order to use both the first method that links data between the base systems installed at multiple bases by replication and the second method that centrally manages the data of the base system, each base identifier is adopted in the base system. Base data storage means storing data for identifying the first method or the second method,
A program for data linkage using a data linkage system including a control unit that supports data linkage between base systems,
The control unit
Transfer data acquisition means for acquiring shared information distributed from any base system;
Using the base data storage means, identify the data linkage method adopted in the transfer destination base system,
When the shared information is acquired by the first method, the shared information is transferred by the second method to other base systems that adopt the second method,
When the shared information is acquired by the second method, the shared information is transferred by the second method to another base system that adopts the second method, and for the base system that adopts the first method. And a data exchange program that functions as data exchange control means for transferring shared information by the first method.

Images