WO2017208922A1

WO2017208922A1 - Data exchange system, data exchange method, and data exchange program

Info

Publication number: WO2017208922A1
Application number: PCT/JP2017/019325
Authority: WO
Inventors: 西村　真
Original assignee: 株式会社東新システム
Priority date: 2016-05-31
Filing date: 2017-05-24
Publication date: 2017-12-07
Also published as: CN109564541A; JP6842071B2; JPWO2017208922A1; CN109564541B

Abstract

Provided are a data exchange system, a data exchange method, and a data exchange program that are capable of realizing transmissive data exchange even between databases in which data having different granularity are managed, by using as an intermediary a database having a hierarchical structure. A data exchange system 1 is provided with: a base database 120; a conversion database 105; a base code conversion unit 110; a code presence determination unit 115 that determines whether or not standard data has been stored in the conversion database 105 in association with another database identifier; and a data conversion unit 125 that converts the standard data into an external identification code when a base code corresponding to the standard data is stored in the conversion database 105 in association with another database identifier, and, when the base code is not stored, converts the standard data into the external identification code stored in the conversion database 105 in association with another database identifier and the base code of the hierarchical structure stored in the base database 120.

Description

Data exchange system, data exchange method, and data exchange program

The present invention relates to a data exchange system, a data exchange method, and a data exchange program. In particular, the present invention relates to a data exchange system, a data exchange method, and a data exchange program for exchanging data between arbitrary systems using a database having a hierarchical structure.

When an attempt is made to manage a set having a large number of elements as a database, generally an identifier uniquely identified is given to these elements. For example, a product handled by a company is given a “product code”, and a commercial transaction is performed based on the “product code”. Here, if the other party of the transaction gives another “product code” to the same product, data exchange cannot be performed. In order to solve such problems, standard codes or unified codes have been developed.

However, there are cases where these standard codes or unified codes cannot be solved. This is a case where a large number of elements are classified into a complicated hierarchical structure, and the classification elements (hereinafter sometimes referred to as “nodes”) of each hierarchy themselves have meaning as effective identifiers. For example, in the “fruit and vegetable standard product code” developed by the Food Distribution Structure Improvement Promotion Organization, multiple types of “Daikon” (for example, “Moriguchi Daikon” etc.) are registered. "Daikon" which should be "is also registered as an item. This is because “Daikon” is also commonly used as an independent element concept. In the “fruit and vegetable standard product code”, no hierarchical relationship is defined between these codes. For this reason, even if an attempt is made to use the “fruit and vegetable standard product code”, data cannot be exchanged between a business operator who handles “Daikon” as “Daikon” and a business operator who handles it as “Moriguchi Daikon”. In other words, among a plurality of databases that handle elements to be expressed in a hierarchical structure, each database manages elements that should be located in different hierarchies (hereinafter, this is referred to as “different granularity” of data). In some cases, appropriate data exchange cannot be realized by a concept such as a conventional standard code or a unified code.

In other words, when there are multiple databases that handle elements that should be represented in a hierarchical structure, each database manages elements that should be located at different levels in the hierarchical structure (hereinafter referred to as the “granularity of data”). May be referred to as “different”), the appropriate data exchange cannot be realized by the concept of the conventional standard code or the unified code.

2. Description of the Related Art Conventionally, an electronic commerce mediation method for mediating business transactions between a plurality of suppliers or purchasers of products or services via a digital data communication network, and (a) a supplier side indicating a supplier's products or services Standard code system for indicating correspondence between classification code system and purchaser's classification code system, and attribute information on the same product or service supplied by multiple suppliers can be standardized and browsed. The browsing data and the non-browsing data including the transaction conditions set for each combination of the supplier and the purchaser are stored in advance as a broker database, and (b) the broker is the buyer The contents of the transaction of the supplier's product or service presented to the customer are converted into the purchaser's classification code system and presented to the purchaser. (C) The purchaser selects the product or service desired for purchase. Applying for a transaction for the selected product or service to an intermediary; (d) the intermediary reads from the non-browsing data different transaction conditions for each purchaser of the product or service selected by the purchaser; Estimate and present to buyer, (e) Buyer determines supplier based on estimate presented in step (d), (f) Intermediary determines transaction in this step (e) There is known an electronic commerce mediation method that performs code conversion on behalf of the purchaser and the supplier by performing code conversion on the classification code system of the purchaser and the supplier based on the conditions (for example, Patent Document 1). reference.). According to the electronic commerce mediation method described in Patent Literature 1, it is possible to eliminate a failure due to a difference in the classification code system between the purchaser and the supplier, and to perform transactions under special transaction conditions for each transaction party.

JP 2002-230342 A

The electronic commerce mediation method described in Patent Document 1 absorbs the difference in code system by using a standard code system that has a one-to-one correspondence between the code system on the service provider side and the code system on the purchaser side. is doing. However, with this method, data cannot be exchanged between databases that manage data with different granularities as described above.

Therefore, an object of the present invention is to provide a data exchange system, a data exchange method, and a data exchange program capable of realizing transparent data exchange by using a database having a hierarchical structure as an intermediary.

In order to achieve the above object, the present invention provides a data exchange system that realizes transparent data exchange between external databases by using a database having a hierarchical structure as an intermediary. A base database for storing hierarchical structure information represented by a structure, an external identification code for identifying external data stored in the external database, a database identifier for identifying the external database, and a base code stored in the base database A conversion database that is stored in association with each other and one external identification code that identifies one external data from one external database is stored in the conversion database in association with the database identifier of the one external database Code that converts data into standard data A conversion unit, a code existence determination unit for determining whether or not a base code corresponding to standard data is stored in the conversion database in association with another database identifier for identifying another external database, and another database identifier When the base code corresponding to the standard data is stored in the conversion database in association with, the standard data is stored in the conversion database in association with the base code corresponding to the standard data and another database identifier If the base code corresponding to the standard data is not stored in the conversion database by converting to the identification code and corresponding to other database identifiers, the hierarchical structure stored in the base database corresponds to the standard data. A classification position that goes back to the top from the classification position of the base code, a classification position that goes down to the bottom, Properly the data exchange system and a data conversion unit that converts the external identification code stored in the conversion database in association with the base code and other database identifier of the classification position on a same rank classification position is provided.

In the data exchange system, the hierarchical structure information includes a base code that identifies data of a higher concept of predetermined data, a base code that identifies data of a lower concept of predetermined data, or a base code that identifies predetermined data May be information represented by a hierarchical structure of a base code constructed including at least one of the following.

In addition, the data exchange system may further include an information attachment unit for attaching additional information related to one external data to the external identification code converted by the data conversion unit.

The data exchange system may further include a code ancillary unit for attaching one external identification code of one external data received from one external database to the external identification code converted by the data conversion unit.

In the above data exchange system, when the base code conversion unit receives one external data from another external database together with another database identifier and another external identification code for identifying other external data of the other database. A set of another database identifier and another external identification code is added to the standard data, or the standard data is not generated, and the code existence determination unit is stored in the conversion database in association with the other database identifier. The data conversion unit can also handle other external identification codes as converted external identification codes without determining whether or not they exist.

In the data exchange system, the conversion database stores a set of another database identifier corresponding to one external identification code and another external identification code for identifying other external data of the other database, Whether the code conversion unit refers to the conversion database and adds the set to the standard data, or does not generate standard data, and the code existence determination unit is stored in the conversion database in association with another database identifier Without determining whether or not, the data conversion unit can handle other external identification codes as converted external identification codes.

In the data exchange system, the conversion database stores a set of one database identifier and one external identification code corresponding to another external identification code for identifying other external data of another database, and data The conversion unit searches the conversion database based on the database identifier and the external identification code held in the standard data before the determination by the code presence determination unit, and the database identifier and the external identification code held in the standard data in the conversion database When a database identifier and an external identification code corresponding to are stored, the external identification code can be treated as a converted external identification code.

In the above data exchange system, when the base code corresponding to one external data is directly received from one external database, the base code conversion unit does not refer to the conversion database, and the code existence determination unit directly It can also be determined using the received base code.

In order to achieve the above object, the present invention provides a data exchange system that realizes transparent data exchange between external databases by using a database having a hierarchical structure as an intermediary. An input data processing unit that processes external data stored in the data processing unit, and an output data processing unit that processes data provided to another external database based on processing in the input data processing unit. The base database that stores the hierarchical structure information represented by the hierarchical structure of the base code that identifies the data, the external identification code that identifies the external data, the database identifier that identifies the external database, and the base code stored in the base database Conversion data stored in association with Standard data that associates the base and one external identification code that identifies one external data from one external database with the base code stored in the conversion database in association with the database identifier of one external database When the output data processing unit stores the base code corresponding to the standard data in the conversion database in association with another database identifier for identifying another external database The data is converted into an external identification code stored in the conversion database in association with the base code corresponding to the standard data and another database identifier, and the conversion database corresponds to the standard data in correspondence with the other database identifier. If the base code is not stored, the standard data is stored in the base database. The hierarchical structure stored in the database, the classification position that goes back higher than the classification position of the basic code corresponding to the standard data, the classification position that descends lower, or the basic code and other databases of the classification position in the same row A data exchange system is provided that includes a data conversion unit that converts an external identification code stored in a conversion database in association with an identifier.

In order to achieve the above object, the present invention provides a data exchange method in a data exchange system that realizes transparent data exchange between external databases by using a database having a hierarchical structure as an intermediary. Is a base database that stores hierarchical structure information represented by the hierarchical structure of the base code that identifies data, an external identification code that identifies external data stored in the external database, and a database identifier that identifies the external database A conversion database stored in association with the base code stored in the base database, and one external identification code for identifying one external data from one external database, a database identifier of the one external database Stored in the conversion database Whether the base code conversion stage for converting the base code to standard data and the base code corresponding to the standard data are stored in the conversion database in association with other database identifiers for identifying other external databases If the base code corresponding to the standard data is stored in the conversion database in association with the other database identifier, the base code corresponding to the standard data and the other database identifier If the base code corresponding to the standard data is not stored in the conversion database in association with another database identifier, the standard data is converted to the base database. The base code that corresponds to the standard data of the hierarchical structure stored by In the external identification code stored in the conversion database in association with the classification position that goes back from the classification position, the classification position that descends below, or the base code of the classification position in the same row as the classification position and another database identifier A data exchange method comprising a data conversion stage for conversion is provided.

In order to achieve the above object, the present invention provides a data exchange program for a data exchange system that realizes transparent data exchange between external databases by using a database having a hierarchical structure as an intermediary. Database identifier that identifies the external database, the base database that stores the hierarchical structure information represented by the hierarchical structure of the base code that identifies the data, the external identification code that identifies the external data stored in the external database And a conversion database that is stored in association with the base code stored in the base database, and one external identification code for identifying one external data from one external database and one external Conversion data corresponding to the database identifier of the database The base code conversion function that converts the base code stored in the database into standard data associated with the base code, and the base code corresponding to the standard data correspond to other database identifiers that identify other external databases, and the conversion database If the base code corresponding to the standard data is stored in the conversion database in association with another database identifier and the code existence determination function that determines whether the data is stored in the database, the standard data corresponds to the standard data When the base code corresponding to the standard data is not stored in the conversion database by converting to the external identification code stored in the conversion database in association with the base code and other database identifier Standard data, hierarchical data stored in the base database Stored in the conversion database in association with the base code and other database identifiers of the base position of the classification position that goes back to the upper rank from the classification position of the corresponding base code, the lower classification position, or the same classification position as the classification position. A data exchange program for realizing a data conversion function for converting to an external identification code is provided.

According to the data exchange system, data exchange method, and data exchange program according to the present invention, a data exchange system and a data exchange method capable of realizing transparent data exchange by using a database having a hierarchical structure as an intermediary. And a data exchange program.

It is a schematic diagram of the data exchange system concerning this embodiment. It is a functional block diagram of the data exchange system which concerns on this Embodiment. It is a data block diagram of the conversion database which concerns on this Embodiment. It is a data block diagram of the basic | foundation database which concerns on this Embodiment. It is a functional structure block diagram of the other form of the data exchange system which concerns on this Embodiment. It is a figure which shows an example of the conversion database which concerns on this Embodiment. It is a figure which shows an example of the basic | foundation database which concerns on this Embodiment. It is a flowchart of the process in the data exchange system which concerns on this Embodiment. It is a figure of the basic | foundation database which concerns on other embodiment. It is a figure of the data of the conversion database which concerns on other embodiment. It is a conceptual diagram of the flow of data exchange in the data exchange system which concerns on other embodiment. It is a hardware block diagram of the data exchange system which concerns on this Embodiment.

[Embodiment]
FIG. 1 shows an outline of a data exchange system according to an embodiment of the present invention.

[Outline of Data Exchange System 1]
When each product is completely standardized, such as an industrial product, it is easy to associate a single identifier with a single item. On the other hand, when organizing elements having vague and diverse attributes, such as classification of animals and plants, a hierarchical classification having a tree structure is required. A problem occurs when identifiers are assigned to such elements in a general one-dimensional structure. For example, even if a certain database has an item “dog” as an element, in another database, “dog” may be a classification, and the element may be “Pomeranian” or “Akita dog”. There are inherent difficulties in exchanging data between these databases.

In the past, regarding the data exchange between these different databases, an approach has been advanced in which a unified “standard code” or “unified code” is defined and promoted to be used. However, there are various problems when using standard codes and unified codes. First, when each business operator already operates a database with its own code system, it is very difficult to change the code system. Moreover, even if it can be changed, using these standard codes and unified codes as they are may not be suitable for in-house operations. For example, while there are businesses that require the classification of “Pomeranian” and “Akita Inu”, there are businesses where the classification of “Dog” is sufficient. Furthermore, there may be a business operator that requires both. The “granularity” of information required by each operator is usually different.

Also, it has been sought to use such standard codes and unified codes when exchanging data with the outside without changing the code system to standard codes or unified codes. However, in this case as well, as described above, there are still cases where it is not suitable for the operation of each operator, and the essential difficulty in managing data with an ambiguous attribute having a tree structure is solved. I can't.

In other words, when managing elements that require such hierarchical attributes, the standard code or unified code approach cannot solve the problem that the “granularity” of information required by each operator differs. This causes an essential problem in the data exchange scene. For example, even in a JAN code that is uniquely identified as a product, the “color” of the product is not identified in a certain product, and one code is assigned. In addition, since a certain product is coded including even a color, there arises a problem that it is not possible to place an order such as “I want the product because I want any color.”

The data exchange system 1 according to the present embodiment is a system created by the present inventor in order to solve such a problem, and is adopted by each operator when using a database having a hierarchical structure that is the basis of data exchange. It is a system that realizes free data exchange while absorbing the problem of granularity without changing the original code system. In other words, the data exchange system 1 is also used in the case where each database manages elements that should be located in different hierarchies among a plurality of databases that handle elements that should be represented in a hierarchical structure. This is a data exchange system that realizes transparent data exchange.

Specifically, the data exchange system 1 according to the embodiment of the present invention includes a plurality of databases (for example, the external database 20, the external database 22, and the external database 24) that store data of different code systems. It is the data exchange system which performs data exchange in. In particular, transparent data exchange between multiple databases that handle elements that should originally be expressed in a hierarchical structure, even when each database manages elements that should be located in different levels of the hierarchical structure. Is a data exchange system that realizes In the present embodiment, among a plurality of databases that handle elements that should be expressed in a hierarchical structure, the state in which each database manages elements that should be located in different levels of the hierarchical structure is described as “granularity is different. " That is, the data exchange system 1 includes one database that stores one data (or data group) of one code system and another data (or other data group) of another code system that is different from the one code system. ) Is a system that executes appropriate data exchange with other databases storing data even if the data granularity is different.

The data exchange system 1 performs data exchange of data including various ambiguity in the attribute definition, with various standard attributes. For example, the data exchange system 1 includes data on classification of animals and plants, data on agricultural products (for example, varieties of agricultural products, etc.), data on fresh food (including fruits and vegetables, marine products, etc.), data on clothing, or food (processing) It is a system for exchanging data such as data on food (including food).

For example, one external database (hereinafter simply referred to as the external database 20) is stored in predetermined external data (that is, the external database 20) relative to another external database (hereinafter simply referred to as the external database 22). (Data) will be described. Here, as an example, an example in which the external database 20 supplies information for ordering a predetermined product to the external database 22 will be described.

Each external database and the data exchange system 1 are connected to each other via a communication network 5 such as the Internet so that they can communicate with each other. In addition, each external database is, for example, a predetermined product or commodity wholesaler, a middle wholesaler, an intermediary, or a company, store, restaurant, etc. that is responsible for selling or providing a predetermined product or product, or a university. Servers provided by educational institutions such as public institutions such as government agencies. The server can also have a part of the functions and configuration of the data exchange system 1.

First, the external database 20 stores external data in association with an external identification code for identifying the external data. Specifically, the external database 20 stores the external data in association with the external identification code for identifying the contents and / or attributes of the external data. For example, the external database 20 is classified as “daikon”, and a plurality of dairy varieties that are subordinate concepts of “daikon” are used as external data, and each external data is associated with an external identification code that uniquely identifies the external data. Is stored. As an example, the external database 20 stores the external data “Moriguchi Daikon” in association with the external identification code “a ₁₁ ′”, and the external data “Dochi Daikon” in association with the external identification code “a ₁₂ ′”.

On the other hand, the external database 22 stores external data in the same manner as the external database 20 based on a code system different from that of the external database 20. As an example, the external database 22 is classified as “root vegetables”, and a plurality of types of root vegetables that are subordinate concepts of “root vegetables” are used as external data, and are associated with external identification codes that uniquely identify the external data. Store each external data. As an example, the external database 22 stores the external data “Daikon” in association with the external identification code “a ₁ ′” and the external data “Kabu” in association with the external identification code “a ₂ ′”.

The data exchange system 1 includes a base database 120 that stores hierarchical structure information represented by the hierarchical structure of the base code that identifies data and / or data attributes. For example, “fruits and vegetables” is a superordinate concept such as “vegetables” and “fruits”. Further, subordinate concepts of “vegetables” include “root vegetables” and “leaf stem vegetables”. The subordinate concepts of “root vegetables” include “daikon” and “kabu”. Furthermore, subordinate concepts of “Daikon” include “Dochi Daikon” and “Moriguchi Daikon”. The base database 120 stores information indicating such products or product attributes as hierarchical structure information having a hierarchical structure in which a hierarchy in which lower-level concept attributes are included in higher-level concept attributes is held in a plurality of stages.

As an example, the base database 120 associates the base code “A” for identifying the data “root vegetables” with the base code for identifying the data “vegetable” and the base code “A” for identifying the data “leaf vegetables”. B "etc. are stored. The base database 120 stores the base code “a ₁ ” for identifying the data “Daikon”, the base code “a ₂ ” for identifying the data “Kabu”, and the like in association with the base code “A”. Further, the base database 120 associates the base code “a ₁ ” with the base code “a ₁₁ ” for identifying the data “Moriguchi Daikon”, the base code “a ₁₂ ” for identifying the data “Dochu Daikon”, etc. Is stored in the lower hierarchy.

That is, the base database 120 includes a base code for identifying the data “vegetable”, a base code for identifying a plurality of data (eg, root vegetables, leaf stem vegetables, etc.) included in the subordinate concept of the data “vegetable”, “root vegetables”. A basic code that identifies each of a plurality of data included in the subordinate concepts such as “Dochu Daikon, Moriguchi Daikon, etc.” and a plurality of data included in the subordinate concepts such as “leaf stem vegetables” , As well as individual codes (for example, daikon radish, moriguchi radish, etc.), from the basic code corresponding to the superordinate concept to the basic code corresponding to the subordinate concept Is stored as hierarchical structure information having a hierarchical structure configured using. Therefore, when a predetermined base code exists, the data exchange system 1 can search the base code of the higher concept of the predetermined base code or the base code of the lower concept by following the hierarchical structure indicated by the hierarchical structure information. . In particular, in the data exchange system 1, the base code corresponding to the superordinate concept of the base code can be acquired by going back to the top from the classification position of the base code of the subordinate concept.

Furthermore, the data exchange system 1 stores in advance the external identification codes of the plurality of external databases in association with the database identifiers uniquely identifying the plurality of external databases and the base codes stored in the base database 120. A conversion database 105 is provided. As an example, the conversion database 105 includes an external identification code “a ₁₁ ′” for identifying data “Moriguchi Daikon” and a base code “a ₁₁ ” stored in the base database 120 for the database identifier for identifying the external database 20. Are stored in association with each other. Similarly, the conversion database 105 includes a database identifier for identifying the external database 20, an external identification code “a ₁₂ ′” for identifying data “Dochu Daikon”, and a base code “a ₁₂ ” stored in the base database 120. Are stored in association with each other. Also, the conversion database 105 includes an external identification code “a ₁ ′” for identifying the data “Daikon” and a base code “a ₁ ” stored in the base database 120 for the database identifier for identifying the external database 22. Store in association.

Here, an example will be described in which the external database 20 places an order for “Dochu Daikon”. For example, it is assumed that the external database 22 which is another external database does not store data related to “Dochu Daikon”. First, the external database 20 supplies the data exchange system 1 with an external identification code (eg, external identification code “a ₁₂ ′”) of “Dochi Daikon”. The external database 20 may supply an external identification code and / or external data to the data exchange system 1 together with information specifying the external database 22 (that is, the database identifier of the external database 22).

The data exchange system 1 searches the conversion database 105 using the external identification code received from the external database 20. That is, the data exchange system 1 searches the base code stored in the conversion database 105 in association with the database identifier for identifying the external database 20 and the external identification code (for example, “a ₁₂ ′”), and performs the external identification. The code is converted into standard data (for example, standard data “a ₁₂ ”) using the base code extracted by the search. Specifically, the data exchange system 1 uses data represented by a base code as standard data. The standard data is data in which a base code, an external database identifier, and / or external data are associated with an external identification code. The standard data is data that can be freely referred to by a database that accesses the data exchange system 1.

Subsequently, the data exchange system 1 determines whether or not the base code corresponding to this standard data is stored in the information stored in the conversion database 105 in association with the database identifier of any other external database. Judge. For example, the data exchange system 1 determines whether the conversion database 105 stores a base code corresponding to this standard data in association with the database identifier of the external database 22.

In this case, the base code corresponding to the standard data is not stored in the conversion database 105 in association with the database identifier of the external database 22. Therefore, the data exchange system 1 searches the base database 120 and associates the base database in the hierarchical structure including the base code corresponding to the standard data with the database identifier of the external database 22 in the conversion database 105. This standard data is converted into a stored external identification code.

For example, in the above example, the base database 120 includes a base code “a ₁ ” that is a superordinate concept of the base code “a ₁₂ ” in the hierarchical structure. The conversion database 105 stores the external identification code “a ₁ ′” in association with the database identifier of the external database 22 and the base code “a ₁ ”. Therefore, the data exchange system 1 is extracted by tracing the hierarchical structure from the classification position on the base code "a _12" that match the standard data "a _12" (for example, back up the hierarchy) based code "a _1" To do. Then, the data exchange system 1 associates the standard data “a ₁ ” with the external identification code “a ₁ ′” stored in the conversion database 105 in association with the extracted base code “a ₁ ” and the database identifier of the external database 22. ₁₂ "is converted.

In other words, the data exchange system 1 traces back the hierarchical structure of the base database 120 in the direction of the higher concept when the base code corresponding to the standard data is not stored in the conversion database 105 in association with the database identifier of the external database 22. Search (that is, search in the direction higher than the classification position). Then, the data exchange system 1 converts the base code obtained by the search into an external identification code stored in the conversion database 105 in association with the database identifier of the external database 22 and the base code obtained by the search. To do. The data exchange system 1 supplies the external database 22 with the external identification code obtained by the conversion and / or external data associated with the external identification code.

If the data exchange system 1 determines that the base code corresponding to the standard data is stored in the conversion database 105, the database identifier of the external database 22 and the base code corresponding to the standard data (that is, The external identification code stored in the conversion database 105 and / or the external data associated with the external identification code is supplied to the external database 22 in association with the base code stored in the conversion database 105.

Thus, according to the data exchange system 1 according to the present embodiment, when a plurality of external databases store data in different code systems, the code system of one external database and the codes of other external databases It is possible to smoothly supply predetermined data from one external database to another external database without constructing a database that has a one-to-one correspondence with the system. Moreover, according to the data exchange system 1, even if the granularities of data stored in a plurality of external databases are different from each other, appropriate data exchange from one external database to another external database can be performed. That is, according to the data exchange system 1, data can be flexibly exchanged from one external database to a plurality of external databases.

The data exchange system 1 associates information related to data corresponding to the base code (for example, information related to attributes of a predetermined product) as text data, numerical data, graphic data, and / or code data in association with the base code. An attribute storage unit can be provided.

The communication network 5 is a communication network such as a mobile phone network and / or the Internet. The communication network 5 can also include a communication network such as a wired LAN and a wireless LAN. Each of the plurality of external databases can be provided not only with a predetermined database apparatus but also with a mobile communication terminal such as a mobile phone or a smartphone, or with an information processing terminal such as a personal computer, a notebook computer, or a tablet PC. In addition, when there is no communication network 5, the data exchange system 1 can also acquire various data from the outside via a recording medium such as a magnetic recording medium, an optical recording medium, and / or a semiconductor recording medium.

Furthermore, the data handled by the data exchange system 1 is data that can be associated with a predetermined code and is used in a database including various data. In particular, data is data related to items that are not necessarily completely standardized (that is, items that have ambiguity in attributes), and can be classified in a hierarchical structure (that is, a tree structure). It is a lot of data. The data may be data relating to products distributed in a predetermined market and / or products, or data used between organizations (whether for profit or non-profit) that exchange predetermined information. This data is, for example, data relating to animal / plant classification, data relating to agricultural products, data relating to fresh food, data relating to clothing, or data relating to food. As an example, the data is data relating to fresh foods, etc. whose producers, varieties / items, production areas, cultivation areas, cultivation methods, seasons, sizes, and / or ranks change from day to day. In addition, fresh food includes fruits and vegetables, marine products and the like.

[Details of Configuration of Data Exchange System 1]
FIG. 2 shows an example of a functional configuration of the data exchange system according to the embodiment of the present invention. The data exchange system 1 according to the present embodiment can be communicably connected to a plurality of external databases. However, in order to simplify the explanation, the data exchange system 1 and one external database are generally used in the following. Are connected so as to be communicable via the communication network 5.

The data exchange system 1 includes a data input unit 100 that accepts input of data from the outside, a conversion database 105 that stores an external identification code in association with a database identifier that identifies an external database, and a base code, and receives from an external database A base code conversion unit 110 that converts the external identification code into standard data, and a code presence determination unit that determines whether the base code corresponding to the standard data is stored in the conversion database 105 in association with another database identifier 115, a basic database 120 for storing hierarchical structure information represented by the hierarchical structure of the basic code, a data conversion unit 125 for converting standard data into an external identification code, and an incidental unit for attaching predetermined data to the external identification code 130, a data output device It includes a data output unit 140, a correspondence updating unit 150 for updating the data conversion database 105 is stored, and an information updating unit 155 to update the information infrastructure database 120 stores. In addition, each component provided in the data exchange system 1 may have a part of functions of other components or all functions.

(Data input unit 100)
The data input unit 100 receives input of one database from another external database and / or another database identifier for identifying another database to which one external data is supplied. In addition, the data input unit 100 receives information or an instruction to update the data stored in the conversion database 105 or an information or instruction to update the information stored in the infrastructure database 120. In addition, the data input unit 100 receives input of additional information related to one external data and / or one external identification code for identifying one external data. External data can also hold a plurality of information.

Furthermore, when receiving the input of one external data, the data input unit 100 can also directly receive the input of the base code corresponding to the one external data. In this case, the base code conversion unit 110 directly supplies the base code to the code presence determination unit 115 without referring to the conversion database 105. In this case, the base code conversion unit 110 can also determine the presence or appropriateness of the base code and perform predetermined error processing. In this case, the external database that supplies the predetermined data to the data exchange system 1 does not require the conversion database 105 to store its own external identification code. In this case, an external system including an external database has a predetermined data conversion function.

The data input unit 100 supplies the base code conversion unit 110 with one external data received from one external database, another database identifier, and / or one external identification code. Note that this one external data includes or is associated with the database identifier of one external database. One external data can also include a plurality of different information. In addition, the data input unit 100 supplies information or an instruction to update the data stored in the conversion database 105 to the correspondence update unit 150. Further, the data input unit 100 supplies the information update unit 155 with information or an instruction to update the information stored in the infrastructure database 120. Further, the data input unit 100 supplies additional information and / or one external identification code to the incidental unit 130.

(Conversion database 105)
FIG. 3 shows an example of the data structure of the conversion database according to the embodiment of the present invention.

The conversion database 105 includes an external identification code that identifies external data of an external database that stores external data of a predetermined code system, a database identifier that identifies the external database, and any base stored in the base database 120. Store it in association with the code. As shown in FIG. 3, the conversion database 105 is associated with a database identifier that uniquely identifies the external database, and an external identification code that identifies the attribute and / or concept of the external data stored in the external database. And a base code corresponding to the external identification code. Here, the base code stored in the conversion database 105 is the same as the base code stored in the base database 120. In this case, the conversion database 105 statically associates the external identification code with the database identifier and a predetermined base code.

For example, the conversion database 105 stores, as a base code associated with the external identification code, a superordinate concept or a subordinate concept of external data corresponding to the external identification code, or a base code associated with data corresponding to the same concept. The conversion database 105 may store at least a base code of the same or the same type as the external data, or a base code of data corresponding to a superordinate concept of the external data, as a base code associated with the external data corresponding to the external identification code. preferable. The conversion database 105 stores the data stored in the base code conversion unit 110, the code presence determination unit 115, and / or in response to the action of the base code conversion unit 110, the code presence determination unit 115, and / or the data conversion unit 125. The data is supplied to each data converter 125.

The conversion database 105 can store the external identification code and the base code in an n-to-m relationship (where n and m are each an integer of 1 or more). For example, the conversion database 105 can store a plurality of base codes in association with one external identification code (hereinafter referred to as “multiple registration of external identification codes” in some cases). As an example, let us consider a case where one external database stores the information “Daikon Daikon” and the information “Daikon Moriguchi” as external data, but does not store the information “Daikon”. In addition, when one external database receives information from other external databases other than the information “Daikon Daikon” and information of “Daikon Moriguchi”, for example, information “Dochi Daikon”, the information is “ Suppose that it is required to be converted into the information “Aoibe Daikon”. In this case, the conversion database 105 associates not only the base code corresponding to “Aoi Daikan” with the external identification code corresponding to the information “Aoi Daikon”, but also the base code corresponding to “Dosuke Daikon”. be able to. In addition, by associating the base code corresponding to “Aoikon Daikon” with the base code one level higher in the hierarchical structure stored in the base database 120 (for example, the base code corresponding to “Daikon”), For all types of "Daikon", the base code corresponding to "Aoibe Daikon" can be used.

Here, when a plurality of base codes are associated with one external identification code, the correspondence between the external identification code stored in the conversion database 105 and one base code is changed to another correspondence relation. It is also possible to associate information indicating “main registration” indicating priority. Since the base code conversion unit 110 executes the conversion process preferentially using the external identification code associated with the information indicating “main registration” and the base code, it is possible to obtain a stable conversion process result. it can.

Furthermore, the conversion database 105 can also store a plurality of external identification codes in association with one base code (hereinafter referred to as “multiple registration of base codes”). For example, when one external database stores the information "Daikon Daikon" and the information "Daikon Moriguchi" as external data, all of this information is associated with the base code corresponding to "Daikon". is there. However, in this case, original information (for example, information on the “blue neck” portion of “blue neck”) may be lost. Since such a function can also be realized by a search going back up the hierarchy, the data exchange system 1 may prohibit registration of a plurality of base codes in the conversion database 105.

Here, when the conversion database 105 has registered a plurality of base codes, “main” indicates that the correspondence between the base code stored in the conversion database 105 and one external identification code has priority over other correspondences. Information indicating “registration” can be associated. The base code conversion unit 110 executes the conversion process preferentially using the base code associated with the information indicating “main registration” and the external identification code, so that a stable conversion process result can be obtained. it can.

Note that the conversion database 105 is controlled by artificial intelligence, and may store the external identification code in a dynamic association with the database identifier and one of the base codes stored in the base database 120. In this case, the conversion database 105 can have a function of dynamically associating the external identification code with the database identifier and / or the base code. The conversion database 105 can update this association at any time by learning with artificial intelligence. The artificial intelligence may be learned based on information provided from an external server or the like via the communication network 5. The conversion database 105 stores the learning result by artificial intelligence and can be updated at any time.

(Base code converter 110)
The base code conversion unit 110 converts the external identification code into standard data based on the external data, the external identification code, and / or the database identifier received from the data input unit 100. That is, the base code conversion unit 110 is based on the base code stored in the conversion database 105 and the single external identification code in association with the single external identification code for identifying the single external data from the single external database. Thus, one external identification code is converted into standard data associated with the base code. Specifically, the base code conversion unit 110 receives an external identification code for identifying one external data and one external data from one external database. The infrastructure code conversion unit 110 can also receive external data and an external identification code together with other database identifiers for identifying other external databases to which one external data is supplied. The base code conversion unit 110 refers to the conversion database 105 and associates one external identification code with the one external identification code and the database identifier of the one external database and stores the base in the conversion database 105. The code and / or one external data is converted into standard data associated with it. For example, the base code conversion unit 110 extracts the base code stored in the conversion database 105, and sets the data that associates the extracted base code and one external data with one external identification code as standard data. The external identification code is converted into standard data. The base code conversion unit 110 supplies the standard data to the code presence determination unit 115.

In addition, when the base code conversion unit 110 receives one external data together with another external identification code for identifying other external data of another database from one external database, the base code conversion unit 110 does not convert the external identification code into standard data. You can also. If the external identification code is not converted into standard data, the base code conversion unit 110 supplies information indicating that the external identification code has not been converted and the external identification code to the code existence determination unit 115. When the external code is not converted into standard data, the base code conversion unit 110 does not refer to the external identification code received from one external database to a database different from other databases.

(Code existence judgment unit 115)
The code existence determination unit 115 determines whether or not the base code corresponding to the standard data received from the base code conversion unit 110 is stored in the base code column of the conversion database 105 in association with another database identifier. Judgment is made with reference to the database 105. The code presence determination unit 115 supplies information indicating the determination result to the data conversion unit 125. When the code presence determination unit 115 receives information indicating that the external identification code has not been converted into standard data from the base code conversion unit 110, the base code corresponding to the standard data is associated with another database identifier. Thus, the process of determining whether or not the data is stored in the conversion database 105 is not executed. The code presence determination unit 115 supplies the data conversion unit 125 with information indicating that the determination process has not been executed and the external identification code received from the base code conversion unit 110.

(Base database 120)
FIG. 4 shows an example of the data configuration of the base database according to the embodiment of the present invention.

The infrastructure database 120 stores hierarchical structure information represented by the hierarchical structure of the infrastructure code that identifies the data. Specifically, the base database 120 is a base code for identifying data such as the contents of predetermined data or attributes of a higher concept, a base code for identifying data such as attributes of a lower concept of predetermined data, or predetermined data Stores hierarchical structure information represented by a hierarchical structure of a base code constructed including at least one of base codes for identifying itself. The hierarchical structure is a structure in which a plurality of predetermined data are stacked in order from lower concept data to higher concept data to form the whole (in the following, the depth of the hierarchical structure is defined as n layers ( However, there are cases where n> 1).

For example, the first data, the second data, the third data, the fourth data, and the fifth data, which are different from each other, in the order of the first data, the second data, the third data, the fourth data, and the fifth data. The case where there is data indicating the concept is taken as an example (for example, the first data is “vegetables”, the second data is “root vegetables”, the third data is “daikon”, the fourth The data is “Dochi Daikon”, and the fifth data is “Dochi Daikon” with limited production.)

In this case, as shown in FIG. 4, in the hierarchical structure, the base code “A” for identifying the first data is arranged at the upper level of the hierarchical structure, and the base code “a ₁ ” for identifying the second data is used as the base code. Arranged below “A”. Similarly, the base code “a ₁₁ ” for identifying the third data is arranged under the base code “a ₁ ”, and the base code “a ₁₁₁ ” for identifying the fourth data is under the base code “a ₁₁ ”. The base code “a ₁₁₁₁ ” that is arranged and identifies the fifth data is placed under the base code “a ₁₁₁ ”. The base database 120 holds each of the plurality of base codes by bundling the base codes of the data corresponding to the lower concept by the base codes of the data corresponding to the upper concept in a plurality of stages. For example, when there are n stages, the base database 120 has an n-level hierarchical structure. The infrastructure database 120 supplies predetermined data to the data converter 125 in response to the action of the data converter 125.

Note that the base database 120 can further store a character string such as a “standard name” corresponding to each base code and other accompanying information together with the base code. The base database 120 stores character string information expressed in one of two-byte, one-byte, or mixed two-byte character string information as “standard name” information, or character string information in all these formats ( In other words, in this embodiment, it is referred to as “complete format” character string information). In addition, when the correspondence relationship update unit 150 and / or the information update unit 155 executes a predetermined process, the base database 120 is configured so that the data output unit 140 responds to the action of the correspondence relationship update unit 150 and / or the information update unit 155. The “standard name” can be output to the user in a perceptible manner. Further, the data output unit 140 can attach information related to the standard name as supplementary information to the output data.

(Data converter 125)
When the data conversion unit 125 determines that the code presence determination unit 115 stores the base code corresponding to the standard data converted by the base code conversion unit 110 in the conversion database 105 in association with another database identifier The standard data is converted into an external identification code stored in the conversion database 105 in association with the base code corresponding to the standard data and another database identifier.

In addition, the data conversion unit 125 includes the same base code as the base code corresponding to the standard data converted by the base code conversion unit 110 by the code presence determination unit 115 in the conversion database 105 in association with another database identifier. If it is determined that the data is not stored, the standard data is converted into a database by associating one of the base codes in the hierarchical structure represented by the hierarchical structure information including the base code corresponding to the standard data with another database identifier. The external identification code stored in 105 is converted. That is, the data conversion unit 125 searches the base code, which is an alternative to the base code corresponding to the standard data converted by the base code conversion unit 110, from within the hierarchical structure for the purpose of converting the standard data into the external identification code. Then, the conversion process is executed using the base code extracted by searching. For example, the data conversion unit 125 displays the base code corresponding to the standard data, the hierarchical structure stored in the base database 120, the position where the base code corresponding to the standard data is classified (that is, the standard data corresponds to the standard data). Stored in the conversion database 105 in association with the base code and other database identifiers that are classified into the top, bottom, or horizontal (same row) classification position from the base code matching position). Convert to an external identification code.

Specifically, when the code existence determination unit 115 determines that the base code corresponding to the standard data is not stored in the conversion database 105 in association with another database identifier, the data conversion unit 125 determines that the base database 120 Search backward (upward search), downward search (downward search) from the classification position of the base code corresponding to standard data (that is, base code that matches the base code corresponding to the standard data) ) And / or a search within the same hierarchy (horizontal search) to search for an appropriate base code. The data conversion unit 125 searches for the base code using at least one search method selected from the group consisting of an upper search, a lower search, and a horizontal search, or a combination of at least two search methods. When combining a plurality of search methods, the data conversion unit 125 searches for a base code according to a predetermined rule.

The data conversion unit 125 can execute an upward search, a downward search, and / or a horizontal search in a predetermined combination (hereinafter, sometimes referred to as “composite search”). For example, the data conversion unit 125 may sequentially execute upward search, downward search, and horizontal search. As an example, the data conversion unit 125 first performs an upward search, and if an appropriate base code cannot be extracted by the upward search, then performs a downward search. The data conversion unit 125 can execute a horizontal search when an appropriate base code cannot be extracted even by a downward search.

In addition, the data conversion unit 125 may not execute part of the upward search, the downward search, or the horizontal search in the composite search. For example, the data conversion unit 125 first performs an upward search up to n levels (where n is an integer equal to or greater than 1 and the value of n is determined in advance). Next, the data conversion unit 125 can execute a downward search and a process that does not execute a horizontal search. A combination of upward search, downward search, and / or horizontal search performed by the data conversion unit 125 may be determined according to a request from the data supply side database and / or the data reception side database. When there is a request for determination of a search combination from both the data supply side database and the data reception side database, it is preferable to determine in advance which one has priority.

Furthermore, the data conversion unit 125 can also perform a search that combines an upper search, a lower search, and / or a horizontal search in one search (hereinafter, sometimes referred to as “mixed search”). As an example, the data conversion unit 125 can search the hierarchical structure one hierarchy lower and then search one hierarchy lower. Further, for example, when an external database in which a base code is arranged only in a specific hierarchy of a hierarchical structure receives data from one external database via the data exchange system 1, the hierarchy stored in the base database 120 If there is no corresponding base code in the same group of the same layer as the base code of the specific layer for the base code in the structure, the specified base code is searched from multiple base codes of the “neighboring” group Extract. That is, in this case, the data conversion unit 125 executes a process of “searching up two levels” and further “searching down two levels”.

The data conversion unit 125 executes a search process with a predetermined combination in the mixed search. For example, the data conversion unit 125 can execute a downward search following the upward search, and can execute a mixed search when an appropriate base code cannot be extracted by any search. In the mixed search, the data conversion unit 125 executes the search in order such that the hierarchical structure goes back one level before the downward search, and then the hierarchical structure goes back two levels before the downward search. it can. The execution order of this search can be determined in advance. Further, the combination of the upper search, the lower search, and / or the horizontal search constituting the mixed search executed by the data conversion unit 125 is determined according to the request from the data supply side database and / or the data reception side database. Also good. When there is a request for determination of a search combination from both the data supply side database and the data reception side database, it is preferable to determine in advance which one has priority.

Here, the upward search will be described. The data conversion unit 125 can search the base code corresponding to the classification position of the external data in another hierarchical structure adopted by another database by upward search. Specifically, the data conversion unit 125 searches for a base code higher by n layers from the base code classification position corresponding to the standard data (provided that n ≧ 1 is satisfied). For example, the data conversion unit 125 searches for a base code corresponding to information obtained when the granularity of information corresponding to the base code is rounded (for example, information “Pomeranian” is associated with a predetermined base code). In this case, it is possible to round the granularity by converting the information into the information “dog”, which is a higher-level concept, and the data conversion unit 125 converts the original base code to “dog” with the granularity rounded. Search for the base code corresponding to the information.) In addition, when the external database side that receives the data does not require detailed information, or when there is no ability to execute detailed information processing, conversion to the base code corresponding to the high-level concept information is effective. Then, the data conversion unit 125 converts the standard data into an external identification code stored in the conversion database 105 in association with the base code extracted by searching and another database identifier.

Next, the downward search will be described. The data conversion unit 125 can search the base code corresponding to the classification position of the external data in another hierarchical structure adopted by another database by a downward search. Specifically, when searching for the base code, the data conversion unit 125 searches the hierarchical structure from higher to lower. That is, the data conversion unit 125 can extract the base code of the classification position descending from the classification position. For example, the data conversion unit 125 searches for the base code corresponding to the information obtained when the granularity of the information corresponding to the base code is reduced (for example, the information “dog” corresponds to the predetermined base code). In this case, it is possible to reduce the granularity by converting the information into information called “Pomeranian”, which is a lower concept, and the data conversion unit 125 reduces the granularity of the original base code. Search for the base code corresponding to the information "Pomeranian"). In addition, when the external database side that receives the data does not have an external identification code for receiving coarse-grained information, conversion to the base code corresponding to the lower concept information is effective. In other words, in the downward search, the data conversion unit 125 adds detailed information that the original information does not have to the original information.

For example, when one external database supplies “ordering data” of a predetermined transaction to another external database via the data exchange system 1, “any kind of dog can be used” from one external database. Assume that the external data “dog” is intentionally supplied to the data exchange system 1. In this case, the data exchange system 1 executes an operation of searching and extracting a base code corresponding to information “Pomeranian” corresponding to a concept level lower than the concept level of information “dog”.

Here, when searching the hierarchical structure of the conversion database 105 downward, there may be a plurality of base codes corresponding to the lower concept levels. In this case, one of a plurality of base codes is selected based on a predetermined agreement, and the data conversion unit 125 executes processing. For example, the data conversion unit 125 can execute a search according to a search order set in advance for each layer of the hierarchical structure stored in the base database 120. In addition, the data conversion unit 125 can execute a search according to the order of the base codes of the base database 120. The data conversion unit 125 can search for a base code that is one layer lower in the hierarchical structure, and if there is no base code corresponding to the external identification code to be converted, it can also search for the next lower layer. If an appropriate base code does not exist even after searching the next lower layer, the data conversion unit 125 may sequentially repeat the downward search.

Furthermore, horizontal search will be described. The data conversion unit 125 can search the base code corresponding to the classification position of the external data in another hierarchical structure adopted by another database by horizontal search. Specifically, when searching for the base code, the data conversion unit 125 can also search for the base code classified in the same row as the conceptual level of the base code classification position corresponding to the standard data. For example, the data conversion unit 125 searches for another base code of the same concept level without changing the granularity of information corresponding to the base code or the conceptual level of classification in the hierarchical structure (for example, a predetermined base code). When the information “Akita Inu” is associated with the information, the information can be converted into another base code without changing the granularity by converting the information “Pomeranian”, which is the same concept level as the information. The conversion unit 125 searches the base code associated with the other base information having the same concept level as the information corresponding to the base code. When one external database (data supply side) and another external database (data reception side) exchange data via the data exchange system 1, the external database on the reception side is a superordinate concept of predetermined external data. If there is no information corresponding to the above and information corresponding to the subordinate concept, and only other external data having the same concept level as the external data is stored, horizontal search is effective.

Note that in the horizontal search, the data conversion unit 125 is within the same group in the same hierarchy within the hierarchical structure stored in the base database 120, that is, within a plurality of base codes belonging to the lower order of the base code corresponding to the same superordinate concept. Perform a search. In addition, the data conversion unit 125 extracts one base code from a plurality of base codes based on a predetermined standard within the same group in the same hierarchy and uses it for the conversion process. Predetermined criteria are, for example, criteria for searching in advance for each hierarchical layer of the base database 120 and searching according to this search ranking, criteria for searching according to the base code order in this hierarchical structure, etc. It is. This search order may be determined according to a request from the data supplier database and / or the data receiver database. When there is a request for determining the search order from both the data supply side database and the data reception side database, it is preferable to determine in advance which is to be prioritized.

When the data conversion unit 125 converts the standard data into the external identification code stored in the conversion database 105 in association with the base code extracted from the base database 120, the original external identification code (that is, the data input) There may be a case where some information of the external data corresponding to the external identification code of the external data received by the unit 100 from one external database is lost. That is, in the data conversion unit 125, the external identification code of the external data received by the data input unit 100 is converted into the external identification code of the external data corresponding to the higher concept, thereby causing information loss. For example, when the data input unit 100 receives an external identification code of “Dochi radish” from one external database and the data conversion unit 125 converts the external identification code into an external identification code of “radish”, at least “Sat” Information on "Appendix" is lost.

Therefore, the data converter 125 converts the standard data into an external identification code, and when information loss occurs, loss information indicating that information has been lost and / or information loss level (i.e., Loss level information indicating the degree of loss) may be included in the converted external identification code. For example, every time the hierarchical structure of the base database 120 is traced, the granularity of information associated with the base code becomes coarse, and information loss occurs. Therefore, the data conversion unit 125 generates “the number of retroactive hierarchies” representing the degree of loss as the “loss level”. The data conversion unit 125 may include the generated information in the converted external identification code. Thereby, another external database that has received the external identification code can grasp the occurrence of loss and the level of loss. For example, when searching the hierarchical structure of the base database 120, the data conversion unit 125 generates the number of hierarchies that have been traced back in the hierarchical structure search (that is, “the number of retroactive hierarchies”) as loss information. As an example, if the number of retrospective hierarchies is “0”, it indicates “no loss of information”, and if the “number of retroactive hierarchies” is “1”, it indicates that “a retroactive one layer has occurred” When the “number” is “m”, it indicates that “m-level retroactive has occurred” (where m> 1).

Similarly, the data conversion unit 125 can also generate information indicating the number of hierarchies in which the descending from the upper level to the lower level has occurred in the hierarchical structure search. For example, by going down the hierarchical structure of the base database 120, the information added to the original information becomes more detailed. Therefore, the data conversion unit 125 can return the “number of retroactive hierarchies” as a negative value using the same item as the “loss level” at the time of the upward search. That is, the data conversion unit 125 returns “−1”, for example, when a search is performed one level down. Note that the data conversion unit 125 can also generate predetermined error information when there is no base code corresponding to the external identification code to be converted even if it goes down to the lowest layer of the hierarchical structure. The data converter 125 can also include error information in the converted external identification code.

Furthermore, when the horizontal conversion is executed, the data conversion unit 125 can also generate information indicating that the horizontal search has been executed. For example, the data conversion unit 125 may generate a horizontal search occurrence flag indicating that a search process in the horizontal direction (that is, a search process in one hierarchy belonging to the same conceptual level of the hierarchical structure) has occurred. Good. In addition, the data conversion unit 125 prepares a predetermined flag indicating that an alternative search including an upward search and a downward search (ie, “alternative search”) has occurred, and in the presence of the flag, When the value of “the number of hierarchies” is “zero”, information that can identify that a horizontal search has occurred may be generated. Further, the data conversion unit 125 can also generate predetermined error information when an appropriate base code cannot be searched by horizontal search.

In addition, when the mixed search is executed, the data conversion unit 125 generates information indicating that the mixed search is performed. For example, the data conversion unit 125 counts the number of upward layers in the upward search performed in the mixed search (hereinafter, “U”; U is an integer of 0 or more) and the downward in the downward search. The combined search information represented as [U, D] can be generated by combining the number of downstream hierarchies (hereinafter referred to as “D”, where D is an integer greater than or equal to 0). For example, when searching up one level, the mixed search information is [1, 0], and when searching down one level, the mixed search information is [0, 1]. When a horizontal search within the same group is executed, the mixed search information is [1, 1]. Further, when there are a plurality of groups at the same conceptual level of the hierarchical structure, when a horizontal search is performed on the “adjacent” group of one group, the mixed search information becomes [2, 2], and the “parent” of the hierarchical structure A plurality of base codes classified into the “siblings” (that is, the same conceptual level (hierarchies in the same column) as the high-order classification position) of (that is, the base code existing in the high-order classification position of the classification position of one base code) ), The mixed search information is [2, 1].

In addition, when the data conversion unit 125 receives information indicating that the determination process has not been executed and the external identification code, the data conversion unit 125 treats the external identification code as a converted external identification code. The data conversion unit 125 supplies the converted external identification code to the incidental unit 130 and / or the data output unit 140. That is, the data conversion unit 125 treats the received external identification code as an external identification code that is output to the outside (in this embodiment, this processing is referred to as “direct conversion”).

In addition, when the data conversion unit 125 searches the base code matching the standard data by tracing back the hierarchical structure of the base database 120 from the bottom to the top, the base code conversion unit If the same base code as the base code corresponding to the standard data converted by 110 is not found, error information indicating that it was not found is supplied to the data output unit 140. The error information is, for example, a null value or “zero” value, or flag information indicating an error.

(Attached unit 130)
The accessory unit 130 includes an information appending unit 132 that appends additional information to the external identification code, and a code appending unit 134 that appends the external identification code itself received from the outside to the external identification code. The auxiliary unit 130 converts the additional information attached to the external identification code by the information auxiliary unit 132 and / or the information related to the external identification code attached to the external identification code by the code auxiliary unit 134 in association with the external identification code. It can also be stored in the database 105. In this case, the conversion database 105 can also supply corresponding additional information or the like when supplying the base code to other components.

(Informational part 132)
The information supplementary unit 132 appends additional information related to one external data to the external identification code converted by the data conversion unit 125. The additional information is, for example, text data indicating the contents of external data, numerical data, code data, and / or graphic data. As an example, when the external data is “Moriguchi Daikon”, the information supplementary unit 132 attaches text data indicating “Moriguchi Daikon” as additional information to the external identification code converted by the data conversion unit 125. The information supplementary unit 132 supplies the data output unit 140 with an external identification code supplemented with additional information. As a result, the external identification code (hereinafter referred to as the original external identification code) supplied from the one external database to the other external database is the original external database that has received the external identification code accompanied by the additional information. Even when the external data represented by the external identification code is converted into the external identification code of the superordinate external data, the contents of the external data corresponding to the original external identification code can be grasped.

Here, the information supplementary unit 132 is configured to add additional information added to the external data received by the data input unit 100 (for example, information related to a character string such as a name) and / or additional information stored in the conversion database 105 or Information related to the external identification code can be added to the standard data when the base code conversion unit 110 converts the external identification code into standard data in response to an action from the base code conversion unit 110. When the additional information includes information related to a character string such as a name, the character string represented by the information is a character string in any one of full-width, half-width, or mixed full-width. The information on the character string added to the standard data is information converted into all types of full-width, half-width, or mixed half-width (hereinafter referred to as “complete format”) by the process described below. Also good. For example, the base code conversion unit 110 and / or the data conversion unit 125 can execute the conversion process of the information related to the character string into the complete format information. As an example, when the data input unit 100 receives an input of external data, the base code conversion unit 110 can execute the conversion process. The conversion process can also be executed when the base code conversion unit 110 stores predetermined information in the conversion database 105. Further, when the data conversion unit 125 executes the process of converting the standard data into the external identification code, the conversion process to the complete format information can also be executed.

In addition, the data input unit 100 can further receive the following three pieces of information when receiving input of external data of text data. That is, as the format of the character string of the text data, there are a full-width character string, a half-width character string, and a character string in which all the half-width characters are mixed. The data input unit 100 includes “full-width character string information” that is information when the character string of the text data is a full-width character string, “half-width character string information” that is information when the character string is a half-width character string, and full-width characters. Input of “full-width mixed character string information”, which is information when a mixed character string may be included, is accepted. The data input unit 100 supplies full-width character string information, half-width character string information, and / or full-width mixed character string information to the information-attached portion 132.

When the additional information is appended to the external identification code and the additional information is text data, the information-attached unit 132 includes the full-width character string information, half-width character string information, or full-width mixed character string received from the data input unit 100. Based on the information, the text data is converted into a predetermined format. Specifically, if the information supplementary unit 132 does not receive at least one of the full-width character string information, the half-width character string information, and the full-width mixed character string information from the data input unit 100, the information-added portion 132 excludes the received information. Is automatically generated and attached to the external identification code as additional information. When the data input unit 100 accepts input of text data, the information supplementary unit 132 analyzes the text data, and the information supplementary unit 132 itself adds full-width character string information, half-width character string information, or Full-width mixed character string information may be associated.

For example, when the information-accompanying unit 132 does not receive full-width character string information from the data input unit 100 and receives full-width mixed character string information, Half-width characters are converted to full-width characters, and full-width character string information is generated. Then, the information supplementary unit 132 includes the full-width character string information, the half-width character string information, and the full-width mixed character string information obtained by the generation in the additional information. Further, when the information-adding unit 132 does not receive full-width character string information from the data input unit 100 and does not receive full-width mixed character string information, the half-width character of the character string indicated by the half-width character string information Is converted to double-byte, and double-byte character string information is generated. Then, the information supplementary unit 132 includes the full-width character string information and the half-width character string information obtained by the generation in the additional information.

In addition, when the full-width character string information is not received from the data input unit 100 and the full-width character string information is received, the information-attached unit 132 includes the full-width character string information as it is in the additional information. On the other hand, if the information-added unit 132 does not receive the full-width mixed character string information from the data input unit 100 and does not receive the full-width character string information, the information-added portion 132 receives the character string indicated by the half-width character string information. Either half-width characters are converted to full-width characters to generate full-width character string information, or the half-width characters of the character string indicated by the half-width character string information are maintained as they are. Then, the information supplementary unit 132 includes the full-width character string information obtained by the generation as it is or includes the half-width character string information as it is in the additional information.

Further, when the information ancillary unit 132 has not received the half-width character string information from the data input unit 100 and has received full-width mixed character string information, the information-attached portion 132 performs kanji for the character string indicated by the full-width mixed character string information. The conversion character string information that has been converted to Kana is included in the additional information. On the other hand, when the information-added unit 132 does not receive the half-width character string information from the data input unit 100 and does not receive the full-width mixed character string information, Include half-width character string information that has been converted to kanji and kana in additional information.

As a result, the data exchange system 1 allows the one external database to be replaced with another external database even when the character string format handled by one external database is different from the character string format handled by another external database. Since the external data supplied to can be converted into a predetermined character string format, stable data exchange between each external database can be realized.

In addition, the information supplement part 132 can function as a text data conversion system by itself. The text data conversion system includes a text data acquisition unit that acquires text data from the outside, a text data determination unit that determines the type of text data acquired by the text data acquisition unit, and text based on the determination result of the text data determination unit. A text data converter for converting the data into a predetermined format. The type of text data is a type indicating that the text data is a full-width character string, a type indicating that the text data is a half-width character string, or a type indicating that the text data may be a mixture of full-width characters. The text data conversion system also outputs a text data output unit that outputs text data converted into a predetermined format, and / or whether the output text data is automatically generated by the text data conversion system. The flag part which attaches the flag to show to the said output text data can also be included.

The text data determination unit analyzes the acquired text data, and if the character string of the text data is a full-width character string, the full-width character string information, if the character string is a half-width character string, the half-width character string information, and If the character string may be a mixture of a full-width character string and a half-width character string, the full-width mixed character string information is determined as the type of text data. The text data conversion unit obtains the text acquired based on the text data acquired by the text data acquisition unit, the text data not acquired, and the determination result of the text data determination unit, as in the above description of the information supplement unit 132. Performs conversion processing such as conversion of half-width characters to full-width characters and kanji-kana conversion.

The flag part adds a flag indicating whether or not the text data conversion part has automatically generated text data to the converted text data. For example, when the text data conversion unit converts half-width of text data to full-width and / or when full-width is converted to half-width, the flag portion does not include a flag indicating that it has been automatically generated or is not automatically generated. A flag indicating that there is not is attached. On the other hand, when the text data conversion unit executes the kanji / kana conversion process, the flag unit attaches a flag indicating that the text data is automatically generated to the converted text data.

This allows the text data conversion system to unify the type of text data to be output even when the type of input text data is not standardized. In addition, since the text data conversion system can attach a predetermined flag to the output text data, it is possible to easily determine whether the output text data is automatically generated by the text data conversion system. it can.

(Attached part 134 with cord)
The code attachment unit 134 attaches one external identification code of one external data received from one external database to the external identification code converted by the data conversion unit 125. That is, the code attachment unit 134 attaches one external identification code of one external data received by the data exchange system 1 from one external database to the external identification code converted by the data conversion unit 125. The code attachment unit 134 supplies the external identification code converted by the data conversion unit 125 to which the external identification code is attached to the data output unit 140. Thereby, in the data exchange system 1, when a predetermined external identification code is supplied from one external database to another external database, one external identification code is obtained from the external identification code supplied to the other external database. The external identification code supplied to another external database can be restored.

(Data output unit 140)
The data output unit 140 receives the external identification code converted by the data conversion unit 125, external data, and / or additional information associated with the external identification code or the external data, and / or information regarding the external identification code. And output to another external database (that is, the external database corresponding to the database identifier designated as the external database of the supply destination by one external database for the data exchange system 1). In addition, the data output unit 140 can store the external identification code converted by the data conversion unit 125 in a predetermined storage medium.

Note that the data exchange system 1 can allow some of the components described above to exist outside the system. For example, the data exchange system 1 may include an external server including the conversion database 105, the infrastructure database 120, and / or the data conversion unit 125.

(Correspondence update unit 150)
The correspondence relationship update unit 150 updates the data stored in the conversion database 105. When the correspondence update unit 150 receives information or an instruction to update the data stored in the conversion database 105, the correspondence update unit 150 updates the stored data according to the information or the instruction.

Further, when the conversion database 105 stores a plurality of base codes in association with one external identification code, the correspondence update unit 150 sets information indicating “main registration” together with the one external identification code. The user can be instructed or forced to correspond to the corresponding relationship with the base code. Similarly, when the conversion database 105 stores a plurality of external identification codes in association with one base code, the correspondence update unit 150 sets information indicating “main registration” as one base code. The user can be instructed or forced to be associated with the corresponding relationship with the external identification code.

(Information update unit 155)
The information update unit 155 updates information stored in the base database 120. When the information update unit 155 receives information or an instruction to update the information stored in the base database 120, the information update unit 155 updates the stored information according to the information or the instruction.

(Code Change Management Department)
Correspondence update unit 150 and / or information update unit 155 prevents the data exchange system 1 from outputting an unexpected data conversion processing result when the information associated with the base code is changed. For the purpose, a code change management unit can be further included. The code change management unit generates an unexpected result when the data stored in the conversion database 105 is not updated in the correspondence relationship update unit 150 in response to a change in the contents of the external database on the data supply side. Prevent output.

For example, the code change management unit functions under the following preconditions. First, it is assumed that the external data for which the data input unit 100 accepts input includes not only an external identification code and the like, but also name character string information of a name indicating the content of the external data. Further, it is assumed that the conversion database 105 further stores name character string information of external data identified by the external identification code in association with the database identifier, the external identification code, and the base code.

When the base code conversion unit 110 converts the external identification code into standard data, the code change management unit uses the name character string information attached to the external identification code or the like and the name character stored in the conversion database 105. Match column information. When the collation results do not match, the code change management unit may supply information indicating an error to the one external database side that provided the external data to the data exchange system 1. The code change management unit may supply information indicating an error to the data output unit 140 side. The information indicating an error includes a flag indicating that an error has occurred, and / or name character string information attached to external data received by the data input unit 100, and a name character string stored in the conversion database 105 Information can also be included.

Here, when the code change management unit compares the name character string information attached to the external data received by the data input unit 100 and the name character string information stored in the conversion database 105, the code change management is performed. Parts can be compared by simple exact match. In addition, the code change management unit performs a “fuzzy search” type comparison that absorbs the full-width / half-width differences, uppercase / lowercase differences, katakana / hiragana differences, and the like of the name strings represented by the name string information. You can also. In addition, the code change management unit detects a matching part and a difference part when comparing the name character string information attached to the external data and the name character string information registered in the conversion database 105. It can also be attached to information indicating. When the code change management unit detects the matching part and the difference part, the code change management part can also make a comparison using the above-mentioned “fuzzy search”. Furthermore, if the name string information is not stored in the conversion database 105 in advance, the code change management unit automatically associates the name string information attached to the external data with the external identification code or the like in the conversion database 105. May be stored. The code change management unit automatically adds the name automatically attached to the external data when there is a difference between the name character string information attached to the external data and the name character string information stored in the conversion database 105. Character string information can also be stored in the conversion database 105. In this case, the code change management unit can also supply predetermined error information and warning to the one external database side that provided the external data to the data exchange system 1 and / or the data output unit 140 side.

(Error handling)
All or some of the components included in the data exchange system 1 can each include an error processing function that supplies a predetermined error to one external database and / or another external database when a predetermined error is detected. In addition, when all or some of the components included in the data exchange system 1 detect a predetermined error, the processing in each component can be stopped at the time of detection. In this case, the data exchange system 1 has received an input of a flag indicating what kind of processing has been performed in the data exchange system 1 with respect to various types of data received from one external database. It can be associated with all or part of various data. Further, the data exchange system 1 can continue the data processing in the data exchange system 1 even when a predetermined error occurs, and supply the converted data to another external database. Alternatively, the data exchange system 1 can stop all processes in the data exchange system 1 when m (where m is an integer equal to or greater than 1) predetermined errors occur.

FIG. 5 shows an example of an outline of a functional configuration of another form of the data exchange system according to the embodiment of the present invention. The data exchange system 1a shown in FIG. 5 differs from the data exchange system 1 in the form of functional configuration. That is, the data exchange system 1a has substantially the same configuration and function as all or part of the data exchange system 1 except that the data exchange system 1a includes the input data processing unit 10 and the output data processing unit 15. Therefore, a detailed description is omitted except for differences.

The data exchange system 1a executes an input data processing unit 10 for processing external data stored in an external database, and processing of data provided to another external database based on the data processing in the input data processing unit 10. And an output data processing unit 15. The input data processing unit 10 includes a conversion database 105, a base code conversion unit 110, and a base database 120. Further, the output data processing unit 15 has a data conversion unit 125. The input data processing unit 10 and the output data processing unit 15 include a data input unit 100, a code presence determination unit 115, an information supplement unit 132, a code supplement unit 134, a data output unit 140, a correspondence update unit 150, and / or information. A part or all of the updating unit 155 may be further included.

When the input data processing unit 10 acquires external data from the external database, the input data processing unit 10 converts the external identification code into standard data based on the acquired external data, external identification code, and / or database identifier. Specifically, the base code conversion unit 110 refers to the conversion database 105 and acquires the base code stored in the conversion database 105 in association with the external identification code of the acquired external data. Then, the base code conversion unit 110 converts the external identification code into standard data associated with the acquired base code. For example, the base code conversion unit 110 uses, as standard data, data that associates the base code acquired from the conversion database 105 and the external data acquired from the external database with the external identification code of the external database. Is converted to standard data. The input data processing unit 10 supplies standard data to the output data processing unit 15.

The output data processing unit 15 refers to the conversion database 105 and determines whether or not the base code corresponding to the received standard data is stored in the conversion database 105 in association with the database identifier of another database. When the data conversion unit 125 determines that the same base code as the base code corresponding to the received standard data is stored in the conversion database 105 in association with another database identifier, the standard data is converted into the standard data. The data is converted into an external identification code stored in the conversion database 105 in association with another database identifier.

On the other hand, if the data conversion unit 125 determines that the same base code as the base code corresponding to the converted standard data is not stored in the conversion database 105 in association with another database identifier, it corresponds to the standard data. The base code stored in the base database 120 is associated with the base code and the other database identifiers that are classified in the classification position that goes back from the classification position of the standard data to the conversion database 105. Convert to stored external identification code.

The data conversion unit 125 can also execute a conversion method (hereinafter referred to as “direct conversion process”) that does not go through a conversion process using the base database 120. For example, the data conversion unit 125 can execute at least one of the following first to third direct conversion processes.

Specifically, the first direct conversion process is executed by the following process, for example. First, the data input unit 100 receives an output side database identifier and an external identification code. The data input unit 100 may receive n sets (n is an integer of 1 or more) of a set of a database identifier and an external identification code. Next, the base code conversion unit 110 adds the set of n sets of database identifiers and external identification codes received by the data input unit 100 to the standard data and supplies them, or performs data conversion without generating standard data. To the unit 125. Then, the data conversion unit 125 indicates the conversion result of the external identification code added to the standard data or the external identification code received by the data input unit 100 without searching the basic database 120 by the code existence determination unit 115. Information is supplied to the data output unit 140 (that is, information indicating the conversion result is treated as an external identification code obtained by conversion. The same applies hereinafter).

Also, the second direct conversion process is executed by the following process, for example. First, in the conversion database 105, n sets (n is an integer of 1 or more) of sets of database identifiers on the output side and external identification codes corresponding to the external identification codes on the input side can be stored. Then, the base code conversion unit 110 refers to the conversion database 105 and supplies n sets of database identifiers and external identification codes to the standard data or supplies the standard data to the data conversion unit 125 without generating the standard data. Supply. The data conversion unit 125 uses the external identification code added to the standard data or the external identification code received by the data input unit 100 as information indicating the conversion result without performing the search of the base database 120 by the code presence determination unit 115. This is supplied to the data output unit 140.

Also, the third direct conversion process is executed by the following process, for example. First, in the conversion database 105, n sets (n is an integer of 1 or more) of sets of database identifiers on the input side and external identification codes corresponding to the external identification codes on the output side can be stored. The data conversion unit 125 searches the conversion database 105 based on the database identifier and the external identification code held in the standard data before the code presence determination unit 115 executes the conversion database 105 search process. When the database identifier and the external identification code corresponding to the database identifier and the external identification code held in the standard data are stored in the conversion database 105, the data conversion unit 125 indicates the conversion result of the external identification code. The information is supplied to the data output unit 140 as information.

Here, the first to third direct conversion processes may be executed, for example, by assigning a priority to each direct conversion process and prioritizing any direct conversion process over other direct conversion processes. it can.

(Outline of the processing flow of the data exchange system 1)
FIG. 6 shows an example of data in the conversion database according to the embodiment of the present invention, and FIG. 7 shows an example of data in the base database according to the embodiment of the present invention. FIG. 8 shows an example of the processing flow of the information input system according to the embodiment of the present invention.

Here, a case where predetermined data is supplied from the first external database to the second external database will be described as an example. The database identifier of the first external database is “001”, the first external database stores the data “Moriguchi Daikon” in association with the external identification code “a ₁₁ ′”, and the data “Dochi Daikon” ”In association with the external identification code“ a ₁₂ ′ ”. On the other hand, the database identifier of the second external database is “002”, the data “radish” is stored in association with the external identification code “a ₁ ′”, and the data “cab” is stored as the external identification code “a ₂ ′”. Assume that they are stored in association with.

Then, as shown in FIG. 6, the conversion database 105 stores the base code “a ₁₁ ” stored in the base database 120 in association with the database identifier “001” and the external identification code “a ₁₁ ′”. stores foundation code "a _12" stored in the underlying database 120 in association with a database identifier "001" and external identification code "a _{12 ''.} Similarly, the conversion database 105 stores the base code “a ₁ ” stored in the base database 120 in association with the database identifier “002” and the external identification code “a ₁ ′”, and stores the database identifier “002”. The base code “a ₂ ” stored in the base database 120 is stored in association with the external identification code “a ₂ ′”.

Further, as shown in FIG. 7, the infrastructure database 120 has an infrastructure code “a ₁ ” (for example, data “radish”) as a subordinate concept of the infrastructure code “A” (for example, infrastructure code corresponding to the data “root vegetables”). ), A base code “a ₂ ”, a base code “a ₃ ”, etc., and a base code “a ₁₁ ” (for example, data “Moriguchi Daikon”) as a subordinate concept of the base code “a ₁ ”. And the hierarchical structure information of the hierarchical structure formed by associating the basic code “a ₁₂ ” and the like. In addition, in the description here, the conversion database 105 and the base database 120 store a plurality of database identifiers, external identification codes, and / or base codes in addition to the above, but the purpose is to simplify the description. As an example, some database identifiers, external identification codes, and / or infrastructure codes will be described.

First, the data input unit 100 accepts input of external data from the first external database (step 10; hereinafter, steps are represented as “S”). For example, the data input unit 100 accepts input of external data indicating “Moriguchi Daikon” associated with the external identification code “a ₁₁ ′” together with the database identifier “002” of the second external data. The data input unit 100 supplies the received data and the like to the base code conversion unit 110.

The base code conversion unit 110 converts the external identification code into standard data based on the data received from the data input unit 100 (S15). For example, the base code conversion unit 110 associates the external identification code “a ₁₁ ′” with the external identification code received from the data input unit 100 and the database identifier “001” of the first external database in the conversion database 105. to obtain the foundation code stored "a _11". The base code conversion unit 110, the data that correlates _'and external data corresponding to the external identification code "a ₁₁ base code" a ₁₁ "and external identification code obtained" a ₁₁ _"' to" as the standard data (However, in this embodiment, for the sake of simplicity, standard data is represented by the same notation as the base code associated with the standard data.) The base code conversion unit 110 supplies the obtained standard data to the code presence determination unit 115.

The code presence determination unit 115 determines whether or not the base code corresponding to the standard data received from the base code conversion unit 110 is stored in the conversion database 105 in association with the database identifier “002” of the second external database. Judgment is made (S20). The code presence determination unit 115 supplies information indicating the determination result to the data conversion unit 125.

When the code existence determination unit 115 determines that the base code corresponding to the standard data is stored in the conversion database 105 (S20: Y), the data conversion unit 125 converts the standard data and the standard data The data is converted into an external identification code stored in the conversion database 105 in association with the database identifier of the external database 2 (S25). The data conversion unit 125 supplies the external output code obtained by the conversion to the data output unit 140.

On the other hand, if the code existence determination unit 115 determines that the base code corresponding to the standard data is not stored in the conversion database 105 (S20: N), the data conversion unit 125 converts the standard data into the base database 120. And converted into an external identification code stored in the conversion database 105 in association with one of the base codes in the hierarchical structure including the base code corresponding to the standard data and the database identifier of the second external database (S30). For example, the data conversion unit 125 refers to the hierarchical structure information of the underlying database 120 that contains the base code same base code "a _11" and "a _11" corresponding to the standard data "a _11". Underlying database 120 includes a base code "a _11" and conversion database 105, platform code "a _11" base code database identifier "a _1" and the second external database is a preamble of "002 And the external identification code “a ₁ ′” is stored.

Therefore, the data conversion unit 125 first searches the hierarchical concept “a ₁₁ ” around the higher level concept and extracts the base code “a ₁ ”. Then, the data conversion unit 125 refers to the conversion database 105 and refers to the external identification code “a ₁ ′” associated with the database identifier “002” and the extracted base code “a ₁ ”. Then, the data conversion unit 125 converts the standard data “a ₁₁ ” into the external identification code “a ₁ ′”. In this case, the data conversion unit 125 can add loss information indicating “1” as the “number of retroactive times” to the converted external identification code.

The data output unit 140 outputs the external identification code and / or external data received from the data conversion unit 125 to a predetermined external database (S35). For example, the data output unit 140 outputs a part or all of the external data associated with the external identification code “a ₁ ′” and / or the standard data “a ₁₁ ” to the second external database. .

FIG. 9 shows an example of a basic database according to another embodiment of the present invention, and FIG. 10 shows an example of data in a conversion database according to another embodiment of the present invention. FIG. 11 shows an outline of the flow of data exchange in the data exchange system according to another embodiment of the present invention. Here, an example in which data is provided from company B to company A will be described.

As illustrated in FIG. 9, the infrastructure database 120 arranges the infrastructure code “A” for identifying the first data above the hierarchical structure (that is, the tree structure) and also identifies the infrastructure data “a ₁ ” for identifying the second data. ”And the base code“ a ₂ ”for identifying the third data are arranged below the base code“ A ”. Similarly, the base code “a ₁₁ ” for identifying the fourth data and the base code “a ₁₂ ” for identifying the fifth data are arranged below the base code “a ₁ ”, and the base code “ a ₁₁₁ ”, a base code“ a ₁₁₂ ”for identifying the seventh data, and a base code“ a ₁₁₃ ”for identifying the eighth data are arranged below the base code“ a ₁₁ ”. In addition, another base code “B” or the like is arranged in the same row as the base code “A”. Similarly, for each of the base code “a ₁ ”, the base code “a ₁₁ ”, or the base code “a ₁₁₁ ”, other base codes other than those illustrated may be arranged.

As an example, the first data is data indicating “vegetables”, the second data is data indicating “root vegetables”, the third data is data indicating “leaf vegetables”, and the fourth data is “ It is assumed that the data is “daikon” and the fifth data is data indicating “kabu”. In addition, it is assumed that the sixth data is data indicating “Daikon Daikin”, the seventh data is data indicating “Moriguchi Daikon”, and the eighth data is data indicating “Seigoin Daikon”.

Also, as shown in FIG. 10, the conversion database 105 stores the external identification code, the base code, and / or the product name in association with the database identifier “A” for identifying the company A. Further, the conversion database 105 stores the external identification code, the base code, and / or the product name in association with the database identifier “B” for identifying the company B.

For example, the conversion database 105 stores the database identifier “A” in association with the external identification code “0001”, the base code “a ₁₁ ”, and the product name “Daikon”. Similarly, the conversion database 105 associates the database identifier “A” with the external identification code “0002”, the base code “a ₁₁₁ ”, and the product name “Dochi Daikon”, and associates the database identifier “A” with the external identification code “0003”. ”, The base code“ a ₁₂ ”, and the product name“ Kabu ”, and the database identifier“ A ”is stored with the external identification code“ 0003 ”, the base code“ a ₁₁₃ ”, and the product name“ Kabu ”in association with each other.

Here, the base code “a ₁₁₃ ” and the product name “Kabu” are associated with each other, which indicates that the company A employs an association different from the base database 120. Therefore, when there are a plurality of associations between the external identification code and the base code, the conversion database 105 prohibits the plurality of associations or associates the priorities with each of the plurality of associations. Then, the data converter 125 executes the conversion process using the base code associated with the highest priority. For example, in the example of FIG. 10, a flag (hereinafter referred to as “priority flag” (not shown) indicating that the highest priority is associated with the base code “a ₁₂ ” corresponding to the external identification code “0003”. ).) Can be associated. On the other hand, a priority flag is not associated with the base code “a ₁₁₃ ” corresponding to the external identification code “0003”.

Also, the conversion database 105 associates the database identifier “B” with the external identification code “1001”, the base code “a ₁₁₁ ”, and the product name “Dochi Daikon”, and associates the database identifier “B” with the external identification code “1002”. Is associated with the product code “a ₁₁₂ ^* ” and the product name “Moriguchi Daikon”, the database identifier “B” is associated with the external identification code “1003”, the product code “a ₁₁ ” and the product name “Daikon”. “B” is associated with the external identification code “1004”, the base code “a ₁₂ ”, and the product name “Kabu”, and the database identifier “B” is associated with the external identification code “1005”, the base code “a ₁₁₃ ”, and the product name “Seigoin”. Correspond to "Daikon".

Here, predetermined supplementary information can be attached to the base code. For example, a mark indicating that predetermined incidental information is attached is added to the base code “a ₁₁₂ ^* ”. Based on the incidental information, the data converter 125 converts the standard data into an external identification code. For example, this incidental information indicates that, for a predetermined base code associated with a predetermined database identifier, another predetermined code is used as the external identification code regardless of the hierarchical structure of the base database 120. Information.

As an example, the base code “a ₁₁₂ ” is stored in the conversion database 105 in association with the database identifier “B”, and when this base code is used for A company, the external base of company A is used. Assume that incidental information instructing to use the code “0003” is incidental. In this case, when supplying data (in this case, data corresponding to the external identification code “1002”) to the company A, first, the base code conversion unit 110 performs the external identification supplied from the company B external database. The conversion database 105 is searched using the code “1002”, and the base code “a ₁₁₂ ” stored in association with the database identifier “B” and the external identification code “1002” is acquired. Then, the base code conversion unit 110 treats data obtained by associating the base code “a ₁₁₂ ” with the external identification code “1002” as the standard data “a ₁₁₂ ”, and uses the external identification code “1002” as the standard data “a ₁₁₂ ”. To "". The accompanying information is attached to each of the base code and standard data stored in the conversion database 105 in advance.

Next, the data conversion unit 125 receives this standard data from the base code conversion unit 110 and checks whether or not a base code corresponding to the standard data exists in the hierarchical structure of the base database 120. Here, however, this standard data is accompanied by additional information. As described above, this incidental information is information for instructing the company A to use the company A external base code “0003” when using the base code. That is, it is information indicating conversion to another hierarchical structure different from the hierarchical structure used by the base database 120. Therefore, the data conversion unit 125 does not follow the hierarchical structure of the base database 120 and uses a code (here, the code “0003”) predetermined by the supplementary information as the external identification code.

Then, as shown in FIG. 11, the external identification code of company B is converted into the external identification code of company A via the standard data by the functions of the code presence determination unit 115 and the data conversion unit 125. For example, the external base code “1001” of company B is associated with the base code “a ₁₁₁ ” in the conversion database 105, and this base code is converted into standard data “a ₁₁₁ ” by the base code converter 110. The Then, the data conversion unit 125, an external identification code associated with the underlying code "a _111" that match the base code corresponding to the standard data "a _111" with the database identifier "A" in the conversion database 105 " in 0002 ", to convert the standard data" _{a 111} ". The data exchange system 1 executes the same processing for the base code that does not have accompanying information.

On the other hand, the conversion database stores a base code “a ₁₁₂ ” with additional information associated with the external identification code “1002” of company B. The conversion database 105 does not store the base code “a ₁₁₂ ” in association with the database identifier of the company A. In this case, if there is no supplementary information, the data exchange system 1 follows the upper layer of the code “a ₁₁₂ ” of the base database 120 and selects the base code “a ₁₁ ” as the base code to be converted. The data exchange system 1, if there is no supplementary information, the external identification code of the standard data "a _111" stored in the base code "a _11" and the database identifier conversion database 105 in association with the "A" Converted to “0001” to obtain an external identification code. However, here, since the supplementary information is attached to the base code, the data exchange system 1 uses the external identification code for converting the code indicated by the supplementary information. That is, here, the code “0003” is an external identification code to be converted. As a result, the data exchange system 1 can convert the external identification code “1002” of company B into the external identification code “0003” of company A.

In the case where an external identification code in which a plurality of base codes are associated with the same external identification code in the conversion database 105 is used, the base code conversion unit 110 executes processing based on the priority flag. For example, when acquiring the external identification code “0003” from the company A, the infrastructure code conversion unit 110 uses the infrastructure code associated with the priority flag (in the example of FIG. 10, the infrastructure code “a ₁₂ ”), Convert the external identification code to standard data. Then, the data conversion unit 125 executes the conversion process using the standard data converted by the base code conversion unit 110 based on the priority flag.

FIG. 12 shows an example of the hardware configuration of the data exchange system according to the embodiment of the present invention.

A data exchange system 1 according to an embodiment of the present invention includes a CPU 1500, a graphic controller 1520, a random access memory (RAM), a memory 1530 such as a read-only memory (ROM) and / or a flash ROM, and a storage device that stores data. 1540, a read / write device 1545 for reading data from and / or writing data to a recording medium, an input device 1560 for inputting data, a communication interface 1550 for transmitting / receiving data to / from an external communication device, and a CPU 1500 A chip set that connects the graphic controller 1520, the memory 1530, the storage device 1540, the read / write device 1545, the input device 1560, and the communication interface 1550 so that they can communicate with each other. And a door 1510. Note that the constituent elements such as the CPU 1500 are one or more CPUs, and may include a plurality of CPUs.

The chip set 1510 includes a memory 1530, a CPU 1500 that accesses the memory 1530 and executes predetermined processing, and a graphic controller 1520 that controls display on an external display device. Perform data passing. The CPU 1500 operates based on a program stored in the memory 1530 and controls each component. The graphic controller 1520 displays an image on a predetermined display device based on image data temporarily stored on a buffer provided in the memory 1530.

Also, the chipset 1510 connects a storage device 1540, a read / write device 1545, and a communication interface 1550. The storage device 1540 stores programs and data used by the CPU 1500 of the data exchange system. The storage device 1540 is, for example, a flash memory. The read / write device 1545 reads the program and / or data from the storage medium storing the program and / or data, and stores the read program and / or data in the storage device 1540. For example, the reading / writing device 1545 acquires a predetermined program from a server on the Internet via the communication interface 1550, and stores the acquired program in the storage device 1540.

The communication interface 1550 executes data transmission / reception with an external device via a communication network. Further, when the communication network is disconnected, the communication interface 1550 can execute data transmission / reception with an external device without going through the communication network. An input device 1560 such as a tablet or a microphone is connected to the chipset 1510 via a predetermined interface.

The data exchange program stored in the storage device 1540 is provided to the storage device 1540 via a communication network such as the Internet or a recording medium such as a magnetic recording medium or an optical recording medium. The data exchange program stored in the storage device 1540 is executed by the CPU 1500. Note that the data exchange program can be installed in the computer by using the recording medium. The recording medium storing the program may be a non-transitory recording medium such as a CD-ROM or DVD.

The information input program executed by the data exchange system 1 works on the CPU 1500 to change the data exchange system 1 to the input data processing unit 10, output data processing unit 15, data input unit 100, conversion described with reference to FIGS. A database 105, a base code conversion unit 110, a code presence determination unit 115, a base database 120, a data conversion unit 125, an auxiliary unit 130, an information auxiliary unit 132, a code auxiliary unit 134, a data output unit 140, a correspondence update unit 150, It functions as the information update unit 155.

(Effect of embodiment)
In the data exchange system 1 according to the present embodiment, since the conversion database 105 defines the data correspondence to the base database 120 of each of the plurality of external databases, data exchange between different external databases can be realized freely. . In particular, the data exchange system 1 according to the present embodiment is a basis for a conversion process having a tree structure defining a multi-level hierarchical structure with respect to a standard code or a unified code having a conventional one-dimensional structure. A base database 120 is provided. By using the base database 120, the data exchange system 1 can realize data exchange between arbitrary databases. Thereby, the data exchange system 1 can implement | achieve the data exchange between arbitrary databases only by defining the correspondence of the data which the conversion database 105 stores.

That is, in the data exchange system 1 according to the present embodiment, each of the plurality of external databases exchanges data in a format in which the contents of the data can be grasped with respect to the external databases of different code systems while maintaining the unique code system. Can be executed. That is, according to the data exchange system 1, data exchange with any database can be performed freely. Since the data exchange system 1 includes the infrastructure database 120 that stores data including ambiguity as hierarchical structure information having a hierarchical structure, the data exchange system 1 differs from each other with the development of information communication technology and the progress of social complexity. Even when information used in multiple social areas (for example, multiple servers using different code systems) increases or changes, the information is shared between different social areas. Can be exchanged and used effectively.

Therefore, according to the data exchange system 1, the same base code as the base code corresponding to the standard data converted by the base code conversion unit 110 is not stored in the conversion database 105 in association with another database identifier. However, the standard data can be converted into an appropriate external identification code by searching the hierarchical structure of the base database 120 in consideration of so-called difference in granularity. Therefore, the data exchange system 1 can realize flexible data exchange while each of various external databases using the system operates a unique code system.

As mentioned above, although embodiment of this invention was described, embodiment described above does not limit the invention which concerns on a claim. In addition, it should be noted that not all the combinations of features described in the embodiments are essential to the means for solving the problems of the invention. Furthermore, the technical elements of the above-described embodiments may be applied independently, or may be applied by being divided into a plurality of parts such as program parts and hardware parts.

DESCRIPTION OF SYMBOLS 1, 1a Data exchange system 5 Communication network 10 Input data processing unit 15 Output

data processing unit

20, 22, 24 External database 100 Data input part 105 Conversion database 110 Base code conversion part 115 Code presence judgment part 120 Base database 125 Data conversion part 130 Attached Unit 132 Information Attached Part 134 Code Attached Part 140 Data Output Part 150 Correspondence Update Part 155 Information Update Part 1500 CPU
1510 chip set 1520 graphic controller 1530 memory 1540 storage device 1545 read / write device 1550 communication interface 1560 input device

Claims

A data exchange system that realizes transparent data exchange between external databases by using a database having a hierarchical structure as an intermediary,
A base database for storing hierarchical structure information represented by a hierarchical structure of a base code for identifying data;
A conversion database for storing an external identification code for identifying external data stored in an external database in association with a database identifier for identifying the external database and the base code stored in the base database;
One external identification code for identifying one external data from one external database is associated with the database identifier of the one external database and standard data associated with the base code stored in the conversion database. A base code converter to convert;
A code presence determination unit that determines whether the base code corresponding to the standard data is stored in the conversion database in association with another database identifier that identifies another external database;
When the base code corresponding to the standard data is stored in the conversion database in association with the other database identifier, the standard data is converted to the base code corresponding to the standard data and the other database identifier. Is converted into the external identification code stored in the conversion database in association with
When the base code corresponding to the standard data is not stored in the conversion database in association with the other database identifier, the standard data is stored in the hierarchical structure stored in the base database as the standard data. In the conversion database, the classification position is traced back to the upper position from the classification position of the corresponding base code, the classification position is lower, or the base code of the classification position in the same row as the classification position and the other database identifier. A data exchange system comprising: a data conversion unit that converts the stored external identification code.
The hierarchical structure information includes at least one of a base code for identifying data of a higher concept of predetermined data, a base code for identifying data of a lower concept of the predetermined data, and a base code for identifying the predetermined data. The data exchange system according to claim 1, wherein the data exchange system is information represented by the hierarchical structure of the infrastructure code constructed and included.
3. The data exchange system according to claim 1, further comprising an information attachment unit that attaches additional information related to the one external data to the external identification code converted by the data conversion unit.
4. The code attachment unit according to claim 1, further comprising a code attachment unit for attaching the one external identification code of the one external data received from the one external database to the external identification code converted by the data conversion unit. The data exchange system according to item 1.
When the base code converter receives the one external data from the one external database together with the other database identifier and another external identification code for identifying the other external data of the other database, A set of the database identifier and the other external identification code is added to the standard data, or the standard data is not generated,
The code presence determination unit does not determine whether the code database is stored in the conversion database in association with the other database identifier,
The data exchange system according to any one of claims 1 to 4, wherein the data conversion unit handles the other external identification code as a converted external identification code.
The conversion database stores a set of the other database identifier corresponding to the one external identification code and another external identification code for identifying other external data of the other database;
The base code conversion unit refers to the conversion database, adds the set to the standard data, or does not generate the standard data,
The code presence determination unit does not determine whether the code database is stored in the conversion database in association with the other database identifier,
The data exchange system according to any one of claims 1 to 4, wherein the data conversion unit handles the other external identification code as a converted external identification code.
The conversion database stores a set of the one database identifier and the one external identification code corresponding to another external identification code identifying other external data of the other database;
The data conversion unit searches the conversion database based on the database identifier and the external identification code held in the standard data before the determination by the code presence determination unit, and is held in the standard data in the conversion database. 5. The method according to claim 1, wherein when the database identifier and the external identification code corresponding to the database identifier and the external identification code are stored, the external identification code is treated as a converted external identification code. Data exchange system.
In the case where the base code corresponding to the one external data is directly received from the one external database,
The infrastructure code converter does not refer to the conversion database,
The data exchange system according to any one of claims 1 to 7, wherein the code presence determination unit directly makes a determination using the received base code.
A data exchange system that realizes transparent data exchange between external databases by using a database having a hierarchical structure as an intermediary,
An input data processing unit that processes external data stored in an external database by the data exchange system; and an output data processing unit that processes data provided to another external database based on processing in the input data processing unit; With
The input data processing unit is
A base database for storing hierarchical structure information represented by a hierarchical structure of a base code for identifying data;
A conversion database for storing an external identification code for identifying the external data in association with a database identifier for identifying the external database and the base code stored in the base database;
One external identification code for identifying one external data from one external database is associated with the database identifier of the one external database and standard data associated with the base code stored in the conversion database. A base code converter to convert;
Have
The output data processing unit is
When the base code corresponding to the standard data is stored in the conversion database in association with another database identifier for identifying the other external database, the standard data is converted to the base code corresponding to the standard data. And the external identification code stored in the conversion database in association with the other database identifier,
When the base code corresponding to the standard data is not stored in the conversion database in association with the other database identifier, the standard data is stored in the hierarchical structure stored in the base database as the standard data. In the conversion database, the classification position is traced back to the upper position from the classification position of the corresponding base code, the classification position is lower, or the base code of the classification position in the same row as the classification position and the other database identifier. A data exchange system comprising a data conversion unit for converting the stored external identification code.
A data exchange method in a data exchange system that realizes transparent data exchange between external databases by using a database having a hierarchical structure as an intermediary,
The data exchange system includes a base database for storing hierarchical structure information represented by a hierarchical structure of a base code for identifying data, and an external identification code for identifying external data stored in the external database. A conversion database that stores the database identifier in association with the base code stored in the base database;
One external identification code for identifying one external data from one external database is associated with the database identifier of the one external database and standard data associated with the base code stored in the conversion database. A base code conversion stage to convert;
A code presence determination step of determining whether the base code corresponding to the standard data is stored in the conversion database in association with another database identifier for identifying another external database;
When the base code corresponding to the standard data is stored in the conversion database in association with the other database identifier, the standard data is converted to the base code corresponding to the standard data and the other database identifier. Is converted into the external identification code stored in the conversion database in association with
When the base code corresponding to the standard data is not stored in the conversion database in association with the other database identifier, the standard data is stored in the hierarchical structure stored in the base database as the standard data. In the conversion database, the classification position is traced back to the upper position from the classification position of the corresponding base code, the classification position is lower, or the base code of the classification position in the same row as the classification position and the other database identifier. A data exchange method comprising: a data conversion step of converting the stored external identification code.
A data exchange program for a data exchange system that realizes transparent data exchange between external databases by using a database having a hierarchical structure as an intermediary,
The data exchange system includes a base database for storing hierarchical structure information represented by a hierarchical structure of a base code for identifying data, and an external identification code for identifying external data stored in the external database. A conversion database that stores the database identifier in association with the base code stored in the base database;
On the computer,
One external identification code for identifying one external data from one external database is associated with the database identifier of the one external database and standard data associated with the base code stored in the conversion database. The base code conversion function to convert,
A code existence determination function for determining whether the base code corresponding to the standard data is stored in the conversion database in association with another database identifier for identifying another external database;
When the base code corresponding to the standard data is stored in the conversion database in association with the other database identifier, the standard data is converted to the base code corresponding to the standard data and the other database identifier. Is converted into the external identification code stored in the conversion database in association with
When the base code corresponding to the standard data is not stored in the conversion database in association with the other database identifier, the standard data is stored in the hierarchical structure stored in the base database as the standard data. In the conversion database, the classification position is traced back to the upper position from the classification position of the corresponding base code, the classification position is lower, or the base code of the classification position in the same row as the classification position and the other database identifier. A data exchange program for realizing a data conversion function for converting into the stored external identification code.