Data exchange system, method and program
Abstract
Problem to be solved.To provide a data transfer system that can flexibly handle data transfer between business systems storing data.
Solution.In a business system 1a, business processing means 13a access data in data storing means 12a to update the storage contents of the data storing means 12a accordingly. An adapter 11a refers to an extraction definition table 112 to send the updated data. Upon receiving the sent information, a data HUB system 4 refers to a dictionary DB 44a to convert the data format to a standard format, refers to a definition table 45 to select a destination business system 2a, refers to a dictionary DB 44b corresponding to the destination to convert the data, and next sends them to the destination business system 2a. The destination business system 2a, upon receiving the data, updates its own data storing means 22a.
Copyright (C)2006,JPO&NCIPI
Term
Term ended
Projected expiry passed 31 March 2024, 2.5 years ago.
- Priority and filed
- Published
- Projected expiry
- Today
5 claims: 3 independent, 2 dependent
- 1A data transfer device connected to multiple business systems via a communication line, and stores the correspondence information between the data format used by the business system in data processing and the standard data format for each connected business system. A definition table that stores the definition information of the type of data sent and the transfer destination, and the business system that was sent when the data to be transferred arrived from any of the business systems. Refer to the dictionary database corresponding to the first conversion means for converting the data format of the incoming data to the reference data format, and refer to the definition table to determine the business system to which the incoming data is transferred. A second that refers to the discriminating means and the dictionary database corresponding to the business system of the transfer destination discriminated by the discriminating means, and converts the data converted by the first conversion means into the data format of the business system of the transfer destination. A data transfer device comprising:, and a transfer means for transferring the data converted by the second conversion means to a business system determined as a transfer destination by the determination means. 複数の業務システムと通信回線にて接続されたデータ転送装置であって、 接続された業務システムごとに、該業務システムがデータ処理において使用するデータ形式と基準となるデータ形式との対応情報を記憶した複数の辞書データベースを有すると共に、 送られてきたデータの種別と転送先との定義情報を記憶した定義テーブルと、 何れかの業務システムから転送すべきデータが到来した際に、送信した業務システムに対応する辞書データベースを参照し、到来したデータのデータ形式を基準となるデータ形式に変換する第1の変換手段と、 前記定義テーブルを参照し、到来したデータの転送先の業務システムを判別する判別手段と、 前記判別手段によって判別された転送先の業務システムに対応した辞書データベースを参照し、前記第1の変換手段によって変換したデータを、転送先の業務システムのデータ形式に変換する第2の変換手段と、 前記第2の変換手段によって変換されたデータを、前記判別手段によって転送先と判別された業務システムへ転送する転送手段と、を有する事を特徴とするデータ転送装置。
- 4Each connected business system has a plurality of dictionary databases that store the correspondence information between the data format used in the data processing and the reference data format, and the type and transfer destination of the sent data. The definition table that stores the definition information and the data transfer device connected to multiple business systems via a communication line correspond to the business system that was transmitted when the data to be transferred arrives from any of the business systems. The first conversion step of converting the data format of the incoming data into the reference data format by referring to the dictionary database to be performed, and the determination step of determining the business system to which the incoming data is transferred by referring to the definition table. The second conversion step of converting the data converted by the first conversion step into the data format of the transfer destination business system by referring to the dictionary database corresponding to the transfer destination business system determined by the determination step. A data transfer method characterized by executing a transfer step of transferring the data converted by the second conversion step to a business system determined as a transfer destination by the determination step. 接続された業務システムごとに、該業務システムがデータ処理において使用するデータ形式と基準となるデータ形式との対応情報を記憶した複数の辞書データベースを有すると共に、送られてきたデータの種別と転送先との定義情報を記憶した定義テーブルと、複数の業務システムと通信回線にて接続されたデータ転送装置が、 何れかの業務システムから転送すべきデータが到来した際に、送信した業務システムに対応する辞書データベースを参照し、到来したデータのデータ形式を基準となるデータ形式に変換する第1の変換ステップと、 前記定義テーブルを参照し、到来したデータの転送先の業務システムを判別する判別ステップと、 前記判別ステップによって判別した転送先の業務システムに対応した辞書データベースを参照し、前記第1の変換ステップによって変換したデータを、転送先の業務システムのデータ形式に変換する第2の変換ステップと、 前記第2の変換ステップによって変換されたデータを、前記判別ステップによって転送先と判別された業務システムへ転送する転送ステップと、を実行する事を特徴とするデータ転送方法。
- 5Each connected business system has a plurality of dictionary databases that store the correspondence information between the data format used in the data processing and the reference data format, and the type and transfer destination of the sent data. Corresponds to the business system that was transmitted when the data to be transferred from any business system arrived at the definition table that stores the definition information and the data transfer device connected to multiple business systems via a communication line. The first conversion step of converting the data format of the incoming data into the reference data format by referring to the dictionary database to be performed, and the determination step of determining the business system to which the incoming data is transferred by referring to the definition table. The second conversion step of converting the data converted by the first conversion step into the data format of the transfer destination business system by referring to the dictionary database corresponding to the transfer destination business system determined by the determination step. A data transfer program characterized by executing a transfer step of transferring the data converted by the second conversion step to a business system determined as a transfer destination by the determination step. 接続された業務システムごとに、該業務システムがデータ処理において使用するデータ形式と基準となるデータ形式との対応情報を記憶した複数の辞書データベースを有すると共に、送られてきたデータの種別と転送先との定義情報を記憶した定義テーブルと、複数の業務システムと通信回線にて接続されたデータ転送装置に、 何れかの業務システムから転送すべきデータが到来した際に、送信した業務システムに対応する辞書データベースを参照し、到来したデータのデータ形式を基準となるデータ形式に変換する第1の変換ステップと、 前記定義テーブルを参照し、到来したデータの転送先の業務システムを判別する判別ステップと、 前記判別ステップによって判別した転送先の業務システムに対応した辞書データベースを参照し、前記第1の変換ステップによって変換したデータを、転送先の業務システムのデータ形式に変換する第2の変換ステップと、 前記第2の変換ステップによって変換されたデータを、前記判別ステップによって転送先と判別された業務システムへ転送する転送ステップと、を実行させる事を特徴とするデータ転送プログラム。
Independent claims3
111 paragraphs, as filed
The present invention relates to data exchange systems, methods and programs between a plurality of computers.
For example, data stored in a specific computer may be transferred to another computer and used in the computer at the transfer destination.
Computer data is generally updated at any time, and if you want to continuously update the data stored in the target computer at the transfer destination, have the latest transfer source data always transferred. I need things.
However, if the transfer is performed from the transfer source to the transfer destination at any time, the processing of both the transfer source and the transfer destination will be heavily burdened. In particular, when a large amount of data exists, the processing time of the computer is taken only for the transfer time, which results in a decrease in the processing efficiency of the work that should be performed.
For this reason, conventionally, data is closed in units of a fixed period such as one day or one hour, and the data information at the time of the closing is collectively sent.<patcit num="1"><text>JP 2002-99451</text></patcit>
<p> In the transfer at regular intervals as specified in the above-mentioned conventional technology, when trying to utilize the data generated by the transfer destination computer, the time for using the data is delayed, such as the next day or one hour later. , It was difficult to utilize highly fresh data. In order to respond to this, in order to utilize the data with high freshness, it was necessary to create an application for each database that catches the event that the data is updated and instantly delivers the data to the other computer system.</p><p> Further, in order to transfer data between different computer systems, it is necessary to convert the data into a format that can be handled by the other computer system, and the data is processed and converted into a format by an application program. Therefore, when exchanging data between a plurality of computer systems, a large amount of system construction work for creating a data conversion / processing program for each database is required.</p><p> Further, in such a system consisting of a plurality of computer systems, the connection form of the computer system changes with the change of business, so that the connection form changes due to the business change such as the addition of a specific business or the deletion of business. The system change work to deal with it became complicated and enormous, and it was practically difficult.</p>
<p> In the present invention, in order to solve the above-mentioned conventional problems, a data transfer device connected to a plurality of business systems by a communication line is provided, and the data transfer device is provided by the business system for each connected business system. It has multiple dictionary databases that store the correspondence information between the data format used in data processing and the standard data format, and also has a definition table that stores definition information of the type of data sent and the transfer destination. When the data to be transferred arrives from that business system, the first conversion means that refers to the dictionary database corresponding to the transmitted business system and converts the data format of the incoming data into the standard data format, and The first conversion means by referring to the definition table and referring to the discriminating means for discriminating the business system of the transfer destination of the incoming data and the dictionary database corresponding to the business system of the transfer destination discriminated by the discriminating means. The second conversion means that converts the data converted by the above to the data format of the transfer destination business system, and the data converted by the second conversion means to the business system that is determined to be the transfer destination by the determination means. It is characterized by having a transfer means for transfer.</p>
<p> According to the present invention, data generated in a specific computer system is supplied to the data HUB in real time triggered by a data generation event, and based on the supplied data, it is processed and edited in a format that can be handled by the other computer system, and the other party By equipping a computer system with a mechanism for instantly delivering data, it is possible to supply highly fresh data from the computer system in which the data is generated to the computer system that utilizes the data. By realizing such a mechanism with middleware, it is possible to construct a system for real-time data distribution between a plurality of computer systems at low cost in a short period of time without creating an application program.</p><p> In addition, since it takes the form of a so-called hub and spoke that transfers data via a data transfer device as a relay, in a multi-server system form composed of a plurality of computer systems, necessary business computers are added and unnecessary business computers are added. The deletion can be performed without affecting other computer systems, and a flexible computer system that can respond quickly to business changes can be constructed.</p>
FIG. 1 shows a conceptual diagram according to an embodiment of the present invention.
In FIG. 1, 1a, 1b, and 1c are so-called data transfer source business systems that transfer accumulated data to other systems, respectively. Each of these business systems is equipped with adapters 11a, 11b, 11c that control data transfer to other systems, and data storage means 12a, 12b, 12c that access data according to business processing. There is.
2a and 2b are so-called data transfer destination business systems that accumulate data transferred from business systems 1a, 1b, and 1c, respectively, and perform business processing based on the accumulated data. The business systems 2a and 2b have adapters 21a and 21 that manage the reception of information transferred from other business systems and data storage means 21a and 21b that store the transferred data, respectively.
In addition, 3 is a data warehouse that stores and manages data, with an adapter 31 that controls the reception of data transferred from the business system business systems 1a, 1b, and 1c, and a data storage means 32 that stores the received data. Has.
4 converts the transfer data sent from the transfer source business systems 1a, 1b, and 1c into a format that can be used by the transfer destination business systems 2a and 2b and the data warehouse 3, and each business system 2a. 2b, transfer to data warehouse 3.
Next, each configuration of each of the above-mentioned systems will be described with reference to FIG.
In the present embodiment, since the transfer source business system 1a, business system 1b, and business system 1c have the same configuration, only the business system 1a will be described in FIG. 2, but other business systems 1b , 1c have the same configuration.
Further, since the business system 2a and the business system 2b of the transfer destination have the same configuration, only the business system 2a is described in FIG. 2, but the business system 2b also has the same configuration.
First, the business system 1a of the transfer source will be described.
As described above, the business system 1a has an adapter 11a and a data storage means 12a. This adapter 11a extracts the data in the range stored in the reflection definition file table from the data storage means 12a at the extraction timing stored in the reflection definition table 112, and all the files 113 · according to the range. It has a schedule extraction means 111 that generates a batch difference file 114 and a trans difference 115 and sends them to the data HUB system 4. Further, 13a is a business processing means that performs business processing by accessing the data of the data storage means 12a.
Further, 14a is a dictionary database that stores a conversion dictionary between the data format of the data stored in the data storage means 12a and the standard data format.
Next, the configuration of the transfer destination business system 2a will be described.
As explained above, this business system 2a also has an adapter 21a and a data storage means 22a, but this adapter 21a has all files 211, batch difference files 212, and tram differences sent from the data HUB system 4. Upon receiving 213, the definition reflecting means 23a performs a process of reflecting the received various files in the stored contents of the data storing means 22a. Note that 24a is a business processing means that performs business processing by accessing the data of the data storage means 12a. Further, 15a is a dictionary database that stores a conversion dictionary between the data format of the data stored in the data storage means 22a and the standard data format.
Next, the configuration of the transfer destination data warehouse 3 will be described.
As described above, the data warehouse 3 also has an adapter 21 and a data storage means 32. This adapter 21a receives all the files 311, the batch difference file 312, and the trans difference 313 sent from the data HUB system 4, and defines the various received files. The reflection means 33 defines the stored contents of the data storage means 32. Perform the processing to be reflected in. Reference numeral 34 denotes a dictionary database that stores a conversion dictionary between the data format of the data stored in the data storage means 32 and the standard data format.
Finally, the data HUB system 4 will be described.
The data HUB system 4 is connected to the runtime means 41 and the terminal 5 that convert the file sent from the transfer source business system into a file in a format that can be used by the transfer destination business system or the data warehouse 3 and then transfer the file. , Data linkage definition means 42 that stores the definition information of data linkage according to the instruction of the terminal 5, operation management that is connected to the terminal 6 and performs the operation management process of the data HUB 4 according to the operation management procedure defined by the terminal 6. It has means 43.
In addition, each connected business system 1a to 1c, 2a, 2b, and conversion dictionaries 44a, 44b ... Between the data format handled by the data warehouse 3 and the standard data format are provided.
Further, the runtime means 41 uses the information collecting means 411 that collects information from the business system of the transfer source such as the business system 1a and the data format of the data collected by the data collecting means 411 by the business system / data warehouse of the transfer destination. It has a data conversion means 412 for converting into a data format to be performed, a business system at the transfer destination, a business system at the transfer destination for storing data in the data warehouse 3, and a data storage means 413 for transferring data to the data warehouse 3. ..
The operation of the data transfer system configured as described above will be described below.
Since there are various systems in this embodiment, for convenience of explanation, the systems other than Data HUB4 are collectively referred to as "systems" below. Therefore, the description of "system" without any particular limitation is for all systems except Data HUB.
First, the matching process of each business system and each dictionary database 44 of the data HUB system 4 will be described.
As specified in the explanation of the above configuration, the data HUB system 4 converts the data sent from the transfer source business system into the data format handled by the predetermined transfer destination business system / data warehouse 3, and then the corresponding table system. -Transfer to Data Warehouse 3.
In order to perform this process flexibly and efficiently, as will be described later, after converting the data of the transfer source into the data of the standard format, the standard data is converted into the data format suitable for the system of the transfer destination. ing. By doing this, if you have a conversion dictionary database between the data format handled by each business system and the standard data format, you do not need to have a dictionary between all transfer source and transfer destination data formats, but data conversion transfer Is possible.
For this purpose, the data HUB system 4 has a data format conversion dictionary 44a ... For each system.
Since this dictionary database is a conversion dictionary between the data format of the business system that performs processing and the standard data format, basically, the conversion definition should be managed by the administrator of each system.
However, since the conversion process itself is performed in the data HUB system 4, it is necessary to store the conversion dictionary data of each system in the dictionary database of the data HUB system 4.
There are two possible ways to do this. That is, there is a method in which the dictionary data of each system is stored in the dictionary database 44a ... Of the data HUB system 4 in advance, and each system has its own dictionary database, which is managed by the administrator of each system. When the external dictionary database is modified in the system, the modification information is sent to the data HUB system 4, and the corresponding dictionary database of the data HUB system 4 is updated to update the dictionary database of each system and the dictionary database stored in the data HUB4. It is a method to take consistency with.
In the former case, once stored in the dictionary database, there is no communication related to the dictionary data, so there is an advantage that it is not necessary to consider the pressure on the communication line related to the update and the processing load of the processing for this purpose. However, there is a drawback that the data format cannot be changed in the corresponding system. On the other hand, in the latter case, communication is added for updating and the load on each system / data HUB system 4 is high, but if the administrator of each system corrects the contents of his / her own dictionary database, the information will be obtained. Since it is automatically reflected on the Data HUB4 side, it is possible to flexibly reflect the data format.
Therefore, the former is effective in a system in which the data format does not change much, and conversely, the latter is effective in a system in which the data to be handled changes frequently.
In the present embodiment, it is assumed that the dictionary database is managed by the latter method. The matching process of each system and the dictionary database of the data HUB system 4 will be described below with reference to FIG.
Since this matching process is performed in the same manner for each system, the matching process between the dictionary database 12a of the business system 1a and the corresponding dictionary database 44a of the data HUB system 4 will be described here.
First, the business system 1a checks whether or not the contents of the dictionary database 14a have been modified by the administrator (S1001). If no correction is made at this time, the process shifts to another process (S1002).
On the contrary, if the correction is made, the difference information of the dictionary database 14a is transmitted to the data HUB system 4 (S1003).
The data HUB system 4 that receives this information (S1004) updates the corresponding dictionary database 44a based on this received data (S1005).
When this update process is completed, the data HUB system 4 transmits information indicating the completion of the differential data update (S1006).
Upon receiving this information, the business system 1a (S1007) completes this update process.
Next, the update process of the extraction definition table of each system will be described.
When the transfer process to each system is enabled centering on the data HUB system 4 as in the present embodiment, it is necessary to memorize which information the data HUB system 4 transfers to which system, and each of them. Since the transfer source system also needs to store the extracted information and manage the extraction target part in the database of each system, the transfer source system has an extraction definition table, and the transfer destination system has an extraction definition table. It has a means to reflect the definition.
In the present embodiment, if the correspondence between the transfer source system and the transfer destination system is input to the data HUB system 4, the system is provided so as to be automatically reflected in the definition table of each system.
This reflection process will be described with reference to FIG. In addition, the input of this reflection shall be reflected in each system by the administrator of the data HUB system 4 inputting to the terminal 5.
Further, as in the above, since the same processing is performed in each system, the reflection processing between the business system 1a and the data HUB system 4 will be described as an example.
First, the data HUB system 4 checks whether the cooperation definition information is received from the terminal 5 (S2001). Here, if it has not been received, it shifts to another process. On the contrary, when it is received, the information is stored in the definition table 45 (S2002).
FIG. 5 is an example of the information received from the terminal 5, and as shown in this figure, the transfer source business system number 451 (for convenience of explanation, each number is attached to each business system in FIG. 1). (Use number), data number 452 in the database of the transfer source business system, transfer destination business system number 453, data name to be reflected in the transfer destination business system 454, transfer type (batch difference / tram difference / total) 455 , Receives the transfer timing information 456 and stores it in the definition table 45.
As mentioned above, there are three types of transfer type 455: batch difference, trans difference, and overall. Batch difference is the process of transferring the difference information of the data updated up to that point every good period, and trans difference. Indicates the process of transferring the difference information when the data is updated, and the process of transferring the entire contents of the database at the specified timing.
Next, the definition information is analyzed and processed into information related to each business system. This process is a process of collecting information related to each number of the transfer source and transfer destination business system in the stored information.
Examples of processing the information shown in FIG. 5 in this way are shown in FIGS. 6 and 7.
First, FIG. 6 shows an example of information processing for the business system of the transfer source, and data 457 is definition data for the business system 1a. As shown in this figure, from the data shown in FIG. 5, only the data related to "1a" indicating the business system 1a at the transfer source business system number 451 is extracted.
Data 458 shows the definition data for the data business system 1b extracted by the same process.
Further, FIG. 7 shows an example of information processing of the business system of the transfer destination. The definition data for the business system 2a is data 459, and the definition data for the business system 2b is data 460.
Next, the data HUB system 4 transmits each business data processed in this way to each target business system (S2004). Of this information, the business system 1a that has received the definition data such as the business system 1a (S2005) updates the extraction definition table 112 based on the information of the definition data (S2006).
When the update process is completed, the business system 1a transmits a notification indicating the completion to the data HUB system 4 (S2007).
When the data HUB system 4 receives the completion notification from each business system (S2008), it completes the external processing and shifts to another processing.
Data transfer from one business system to another while the dictionary data matching processing and definition reflection processing are being performed as described above will be described.
First, the data transfer process in the transfer source business system 1a will be described using the flowchart of FIG. Since the same processing is performed for both the transfer source business systems 1a and 1b, the data transfer processing in the business system 1a will be described. Naturally, the business system 1b also performs the same processing. Further, unless otherwise specified, the schedule extracting means 111 in the adapter 11a performs the processing in the business system.
The business system 1a is performing a plurality of processes, and at the stage of shifting from the other processes to the main process, the business system 1a first refers to the extraction definition table 112 (S3001), and already in the extraction definition table 112. Check if the transfer process for each item is completed (S3002).
If the transfer processing of all the items defined at this time is completed, the process shifts to another processing (S3003).
On the contrary, if it is not completed, one item that has not been transferred is extracted and its transfer type is checked (S3004). Here, if it is the whole or batch difference, the transfer timing of the same item is checked (S3005), and if it is determined that it is not the update timing, the process proceeds to S3001 and the process of the next item is performed. When it is determined that the update timing is reached, it is further determined whether the transfer type is total (S3006), and in the case of total, all data 113 is transmitted to the data HUB system (S3007).
Further, in the case of batch difference processing, the difference information 114 of the target data updated so far from the previous transmission processing is transmitted to the data HUB system 4 (S3008). After the processing of S3008 or S3009 is completed, the process shifts to S3001.
Next, when the transfer type is determined to be the trans difference in S3004, it is determined whether the data has been updated at that time (S3009). When there is an update, the difference data 115 due to the update is transmitted to the data HUB system 4 (S3009) and migrated to S3001.
Next, the process in which the data HUB system 4 transfers the information sent from the transfer source system to the transfer destination in this way will be described using the flowchart of FIG.
Unless otherwise specified, this process is assumed to be performed by the runtime means 41 of the data HUB system 4.
First, data reception processing is performed (S4001), and it is confirmed whether data has been sent from the transfer source business system 1a or 1b (S4002). Here, if it has not been sent, the process is terminated and the process proceeds to another process. When it is received, the dictionary database for the transfer source business system is referred to and the data format from the transfer source business system is converted to standard data. For example, in the case of data from the business system 1a, the data format is converted to the standard data format by referring to the corresponding dictionary database 44a (S4003).
Next, the transfer destination of the data is selected with reference to the definition table 45. For example, when the transfer data of DB5 is sent from the transfer source business system 1a, refer to the definition table 45 shown in Fig. 5 and select the target transfer destination from the sent data and its timing (S4004). .. For example, if the data DB5 of the transfer source is sent at 23:00, the transfer destination is the business system 2a. In the present embodiment, the identification is based on the timing and the data name, but the identification number is stored in the definition table 45 for each item of the definition data, and the definition table 45 is referred to based on the identification number. , The transfer destination may be determined.
Refer to the dictionary database corresponding to the business system of the transfer destination selected in this way, convert the data converted to the standard format in S2003 to the data format of the transfer destination, and convert it to the data format in the data warehouse 3. (S4005).
Then, the converted data is transferred to the target transfer destination system and the data warehouse 3 (S4006), respectively, and the process is completed.
Next, the process of reflecting the data sent from the data HUB system 4 in the transfer destination business system will be described with reference to the flowchart of FIG.
The business system of the transfer destination is the business system 2a and 2b, but since both perform the same processing, only the business system 2a will be described here.
It should be noted that this processing is processed by the definition reflecting means 23a in the adapter 21a of the business system 2a, and unless otherwise specified in the following description, it is assumed that the definition reflecting means 23a is processing. Further, although the definition reflecting means 23a is not described, it is assumed that the definition reflecting means 23a has a definition table sent from the data HUB system 4 shown in FIG.
First, when the definition reflecting means 23a receives the data (S5001), it refers to the definition table (S5002) and determines what kind of processing the received data performs (S5003).
At this time, if it is determined that the sent data is all data, all the target data in the database is replaced with the sent data (S5004). If it is batch difference data or trans difference data, the difference information is reflected in the current data (S5005 / S5006).
For example, if it is identified from the data of DB5 of the business system 1a, the transfer type is the batch difference information, and it can be determined that the data is reflected in the DB24 in the business system 2a.
Next, the processing in the data warehouse 3 will be described.
The data warehouse 3 is basically a database provided for accumulating transferred data at any time and utilizing it for other processing such as analysis of problems in the system.
Therefore, as described in the explanation of FIG. 9, all the transferred data is sent to the data warehouse 3 and the sent information is accumulated.
The data storage process in this data warehouse 3 will be described.
It should be noted that this processing is performed by the definition reflecting means 33 of the data warehouse 3, and unless otherwise specified, it is assumed that the definition reflecting means 33 is processing in the following description.
First, when the definition reflecting means 33 receives the data (S6001), it refers to the definition table (S6002), and adds the data update type information, the transfer source business system number, the transfer destination business system number, and the transfer data to the received data. Accumulate (S6003).
By doing so, all the update information in the system is accumulated in the data storage means 32.
With the above configuration, it is possible to transfer data in real time and reliably even if the data formats of each business system are different.
Further, in this embodiment, each business system / data HUB system 4 has a configuration requirement called an adapter, but even if it is not hardware, it can be used as an application level base such as middleware. You may have it as software. By having it as middleware in this way, it is possible to automatically transfer data without significantly modifying the application software directly used by the user.
Further, the present invention converts the data format of data from a certain business system into a standard data format. Or the opposite is stated.
Specifically, for example, the "product code" used in the business system is converted into a standard name such as "product name", or the transfer destination "product code" corresponding to this "product name" is used. This is the conversion to. Since the standard of such conversion can be known only by the person in charge of each business system actually used, in the present embodiment, the person in charge of the business system modifies the dictionary for his / her own business system. , The correction result is automatically reflected in the dictionary database corresponding to the business system of the data HUB system 4, so that the standard data format can be supported.
In addition, although the standard data is the "product name" in the above description, the standard product code for the product is defined, and the "product code" of the business system is converted to the standard "product code", or vice versa. You may try to do.
Furthermore, with this conversion, if there is a correlation between "inventory information" and "order information" that the inventory will decrease if there is an order, this difference may be calculated automatically and transferred. It is possible.
In addition, in the data transfer between the transfer source business system and the data HUB system 4, in the transfer by the whole or batch difference, the data is transmitted in file units, and the file is surely stored in the data supply HUB. In order to guarantee, by providing a generation management mechanism for files to be transmitted to the data supply unit and having a mechanism for responding to a retransmission request from the data HUB system 4, it is possible to perform data transfer more reliably.
Further, in the data transfer by the trans difference, when the data is sequentially transmitted to the data HUB system 4, the data loss is prevented by using the transaction recovery function by the DBMS (Database Management System) of the supplier business system.
Further, as for the data transferred from the business system of the supply source, it is impossible to reproduce the business operation in the system of the data supply unit side even if only one database is viewed like the form data. In such a case, there are multiple product orders in one business operation, or the products are described by the product code. With data in such a state, even if another computer system obtains the data, the data cannot be handled.
Therefore, by equipping the transfer source adapter with a concatenated file / dictionary file and a slip format conversion mechanism and adding information to the generated data, the slip format data can be supplied to the data HUB section. It is also possible to correspond to the format data.
In addition, the present embodiment has an operation management means 43 for communicating with the terminal 6.
The operation management means 6 provides the terminal 6 with the flow of data transfer in the current data HUB system 4 by the terminal 6.
By having such a management means, the administrator of the data HUB system 4 can grasp the transfer status in the data HUB system 4 and easily grasp the problem (bottleneck, etc.) of the transfer process in the data HUB system 4. Things will be possible.
(Appendix 1) A data transfer device connected to multiple business systems via a communication line, and for each connected business system, the data format used by the business system in data processing and the standard data format It has multiple dictionary databases that store correspondence information, a definition table that stores definition information of the type of data sent and the transfer destination, and when data to be transferred arrives from any business system. Refer to the dictionary database corresponding to the transmitted business system, refer to the first conversion means for converting the data format of the incoming data to the reference data format, and refer to the definition table, and refer to the business of the transfer destination of the incoming data. With reference to the discriminating means for discriminating the system and the dictionary database corresponding to the business system of the transfer destination discriminated by the discriminating means, the data converted by the first conversion means is converted into the data format of the business system of the transfer destination. A data transfer characterized by having a second conversion means for conversion and a transfer means for transferring the data converted by the second conversion means to a business system determined as a transfer destination by the determination means. apparatus.
(Appendix 2) The definition table can be updated, and a definition update notification means for transmitting at least update information related to the update is provided to each connected business system in response to the update of the definition table. The data transfer device described in Appendix 1, which is characterized by the above.
(Appendix 3) When the update information of the dictionary database is received from any of the business systems, the information stored in the dictionary database corresponding to the transmitted business system is updated according to the external update information. The data transfer device according to Appendix 1, which is characterized in that the above is provided.
(Appendix 4) Each connected business system has a plurality of dictionary databases that store information on the correspondence between the data format used by the business system in data processing and the reference data format, and of the data sent. A definition table that stores definition information of type and transfer destination and a data transfer device connected to multiple business systems via a communication line transmitted data to be transferred from any of the business systems. Refer to the dictionary database corresponding to the business system, refer to the first conversion step to convert the data format of the incoming data to the reference data format, and refer to the definition table to determine the business system to which the incoming data is transferred. The discriminating step for discriminating and the dictionary database corresponding to the business system of the transfer destination discriminated by the discriminating step are referred to, and the data converted by the first conversion step is converted into the data format of the business system of the transfer destination. A data transfer method characterized in that the conversion step 2 and the transfer step of transferring the data converted by the second conversion step to the business system determined as the transfer destination by the determination step are executed.
(Appendix 5) The data transfer device further updates the definition table, and transmits at least update information related to the update to each connected business system in response to the update of the definition table. The data transfer method described in Appendix 4 characterized by executing the definition update notification step.
(Appendix 6) When the data transfer device further receives the update information of the dictionary database from any of the business systems, the information stored in the dictionary database corresponding to the transmitted business system is converted into new diplomatic information. The data transfer method described in Appendix 4, which is characterized by executing the dictionary database update step to be updated at the same time.
(Appendix 7) Each connected business system has a plurality of dictionary databases that store the correspondence information between the data format used by the business system in data processing and the reference data format, and of the sent data. When data to be transferred from any of the business systems arrives at the definition table that stores the definition information of the type and transfer destination and the data transfer device connected to multiple business systems via a communication line, the data is transmitted. Refer to the dictionary database corresponding to the business system, refer to the first conversion step to convert the data format of the incoming data to the reference data format, and refer to the definition table to determine the business system to which the incoming data is transferred. The discriminating step for discriminating and the dictionary database corresponding to the business system of the transfer destination discriminated by the discriminating step are referred to, and the data converted by the first conversion step is converted into the data format of the business system of the transfer destination. A data transfer program characterized by executing two conversion steps and a transfer step of transferring the data converted by the second conversion step to a business system determined as a transfer destination by the determination step.
(Appendix 8) A data transfer system having a plurality of transfer source business systems, a plurality of transfer destination business systems, and a data transfer device connected to the transfer source and transfer destination business systems. An extraction definition table that stores the data storage means that is accessed when executing the application software of the business system, and the extraction type that updates the data storage means and extracts the transferred data, respectively, and the above. It has a transfer control means that extracts data from the data storage means by referring to the information stored in the extraction definition table and transmits it to the data transfer device in the previous period, and the data transfer device is used for each connected business system. In addition, a plurality of dictionary databases storing information corresponding to the data format used by the business system in data processing and the reference data format, the type of data sent, and the definition information of the transfer destination business system are stored. When the stored definition table and the data to be transferred from any of the transfer source business systems arrive, the data format based on the data format of the arrived data is referred to by the dictionary database corresponding to the transmitted business system. A dictionary database corresponding to a first conversion means for converting to data, a discrimination means for discriminating the transfer destination business system of incoming data by referring to the definition table, and a transfer destination business system determined by the discriminating means. The data converted by the first conversion means is converted by the second conversion means for converting the data converted by the first conversion means into the data format of the transfer destination business system determined by the determination means, and the second conversion means. It has a transfer means for transferring the data to the transfer destination business system determined by the determination means, and the plurality of transfer destination business systems access each when executing the application software of the business system. A data transfer system characterized by having a data storage means to be performed and a reflection means for reflecting the data sent from the data transfer device in the data storage system.
<figref num="1">Conceptual diagram of a data transfer system according to an embodiment of the present invention</figref><figref num="2">Functional block diagram of a data transfer system according to an embodiment of the present invention</figref><figref num="3">Flow chart of matching processing in the data transfer system according to the embodiment of the present invention</figref><figref num="4">Flow chart of reflection processing in the data transfer system according to the embodiment of the present invention</figref><figref num="5">A table diagram showing an example of information processing in the reflection process by the data transfer system according to the embodiment of the present invention.</figref><figref num="6">A table diagram showing an example of information processing in the reflection process by the data transfer system according to the embodiment of the present invention.</figref><figref num="7">A table diagram showing an example of information processing in the reflection process by the data transfer system according to the embodiment of the present invention.</figref><figref num="8">Flow chart of transfer processing in the data transfer system according to the embodiment of the present invention</figref><figref num="9">Flow chart of transfer processing in the data transfer system according to the embodiment of the present invention</figref><figref num="10">Flow chart of transfer processing in the data transfer system according to the embodiment of the present invention</figref><figref num="11">Flow chart of transfer processing in the data transfer system according to the embodiment of the present invention</figref>
Code description
1a ~ 1c Business system 2a, 2b Business system 3 Data warehouse 4 Data HUB system 11a ~ 11c Adapter 12a ~ 12c Data storage means 21a, 21b Adapter 22a, 22b Data storage means 31 Adapter 32 Data storage means
Every citation, both ways
| Document | Relation | Office | Cited during |
|---|---|---|---|
| JP2010161727A | Cited by | Japan | Examiner |
| WO2016060549A1 | Cited by | World Intellectual Property Organization (WIPO) | International search |
| US8280840B2 | Cited by | United States of America | Applicant |
| US8639670B2 | Cited by | United States of America | Applicant |
| US7702694B1 | Cited by | United States of America | Applicant |
| JP2011258122A | Cited by | Japan | Examiner |
2 priority claims, no other members on record
Priority claims2
| Document | Office | Kind | Date |
|---|---|---|---|
| 2004105081 | Japan | A | |
| JP20040105081 | – | – | – |
3 legal events, as the office reported them to INPADOC
Over the term
Point at a mark for the eventEvents
| Event | Code | |
|---|---|---|
| Decision of refusalA02 | A02 | |
| Notification of reasons for refusalA131 | A131 | |
| Written request for application examinationA621 | A621 |
Numbers
- Publication
- 2005293047
- Publication, DOCDB
- 2005293047
- Publication, EPODOC
- JP2005293047
- Application
- 105081
- Application, DOCDB
- 2004105081
- Application, EPODOC
- JP20040105081
Titles3
- Japanese
- データ交換システム、方法及びプログラム
- English
- Data exchange systems, methods and programs
- English
- DATA EXCHANGE SYSTEM, METHOD AND PROGRAM
Classification
- CPC, 2
- G06F17/30569
- G06F16/258
- IPC, 6
- G06F12 00
- B41B1 00
- G06F17 30
- G06K1 00
- H04N1 40
- H04N7 14