JP2019049934A - Delivery information acquisition device, delivery information acquisition method, and delivery information acquisition program - Google Patents

Abstract

To provide a distribution information acquisition device, a distribution information acquisition method, and a distribution information acquisition program that can acquire only a part of distribution information that meets conditions desired by an operator.SOLUTION: A distribution information acquisition device includes steps of: (1) referring to a distribution definition master including a master name used to acquire distribution information, an extraction condition used to narrow down the distribution information, and a distribution definition for specifying a combination of the master name and the extraction condition and acquiring the master name and the extraction condition associated with the specified delivery definition; and (2) acquiring the distribution information that is associated with the acquired master name and that matches the acquired extraction condition.SELECTED DRAWING: Figure 15

Description

  The present invention relates to a distribution information acquisition apparatus, a distribution information acquisition method, and a distribution information acquisition program.

  According to Patent Document 1, it is possible to separate update data and non-update data from time to time and distribute them, thereby reducing the load on each of the server system, the network, and the client device. A data distribution system has been disclosed that can easily differentiate itself by changing the content and timing of distribution (see paragraph 0011, etc.).

JP 2006-99792 A

  In the field of management of such information delivery, when delivering delivery information from a delivery source to a delivery destination, acquisition and delivery of only the information meeting the conditions desired by the operator among the delivery information (delivery information It was difficult to do partial acquisition and delivery).

  Therefore, for example, when it is desired to distribute the information A and the information B included in a certain master to different distribution destinations, it is necessary to separately prepare the master having the information A and the master having the information B. And it takes time.

  The present invention has been made in view of the above problems, and is a distribution information acquisition apparatus, distribution information acquisition method, and distribution information acquisition which can acquire only a part of information of distribution information that meets the condition desired by the operator. Provide a program.

  In order to solve the problems described above and achieve the object, a distribution information acquisition apparatus according to the present invention is a distribution information acquisition apparatus including a control unit and a storage unit for acquiring distribution information, and the storage unit A distribution definition master including an acquisition information used to acquire the distribution information, an extraction condition used to narrow down the distribution information, and a distribution definition for specifying a combination of the acquisition information and the extraction condition The control unit refers to the distribution definition master and refers to the distribution definition master, and the acquisition information acquiring unit for acquiring the acquisition information and the extraction condition associated with the designated distribution definition; Distribution information acquisition means for acquiring the distribution information that is associated with the acquisition information acquired by the information acquisition means and that matches the extraction condition acquired by the acquisition information acquisition means; It is provided, characterized by.

  The distribution information acquisition apparatus according to the present invention is characterized in that the extraction condition is data of a character string format.

  In the distribution information acquisition apparatus according to the present invention, the distribution information acquisition means performs the acquisition using at least one of a MID function and a LEFT function.

  A distribution information acquisition method according to the present invention is a distribution information acquisition method for acquiring distribution information, which is executed by an information processing apparatus including a control unit and a storage unit, and the storage unit includes the distribution unit. A distribution definition master is stored that includes information for acquisition used to acquire information, extraction conditions used for narrowing down the distribution information, and a distribution definition for specifying a combination of the information for acquisition and the extraction conditions. An acquisition step of acquiring information etc. for acquiring the acquisition information and the extraction condition associated with the specified distribution definition with reference to the distribution definition master, executed by the control unit, and the information for acquisition Distribution information acquisition for acquiring the distribution information that is associated with the acquisition information acquired in the acquisition step, etc. and that matches the extraction condition acquired in the acquisition information acquisition step It includes the steps, and characterized.

  Furthermore, a distribution information acquisition program according to the present invention is a distribution information acquisition program for acquiring distribution information, for causing an information processing apparatus including a control unit and a storage unit to execute the program, the storage unit including: A distribution definition master including an acquisition information used to acquire distribution information, an extraction condition used to narrow down the distribution information, and a distribution definition for specifying a combination of the acquisition information and the extraction condition is stored Acquisition step for acquiring the acquisition information and the extraction condition associated with the specified distribution definition with reference to the distribution definition master, to be executed by the control unit; The distribution information that is associated with the acquisition information acquired in the acquisition information acquisition step, and that matches the extraction condition acquired in the acquisition information acquisition step Include a delivery information acquisition step of obtaining, and characterized.

  According to the present invention, it is possible to acquire only a part of the distribution information that matches the condition desired by the operator.

FIG. 1 is a block diagram showing an example of the configuration of a delivery management system. FIG. 2 is a block diagram showing an example of the configuration of the main company information processing apparatus. FIG. 3 is a block diagram showing an example of the configuration of a subsidiary information processing apparatus. FIG. 4 is a block diagram showing an example of the configuration of the relay apparatus. FIG. 5 is a diagram showing an example of a conventional master distribution method. FIG. 6 is an image diagram showing an example of a data environment according to the present embodiment. FIG. 7 is a table diagram showing an example of a data environment according to the present embodiment and an example of a setting flow according to the present embodiment. FIG. 8 is a view showing an example of the data configuration to be set when performing distribution processing according to the present embodiment. FIG. 9 is a diagram in which the types of master distribution from a parent company to a subsidiary are divided into three according to the server and environment to which the parent company and the subsidiary belong. FIG. 10 is a diagram in which the types of data migration from the test environment to the production environment are divided into two according to the test environment and the server to which the production environment belongs, and the environment. FIG. 11 is a diagram illustrating an example of distribution setting and distribution when the administrator of the distribution destination company does not perform the approval operation. FIG. 12 is a diagram showing an example of distribution setting and distribution in the case where the manager of the distribution destination company approves the operation. FIG. 13 is a diagram showing an installation example of each DB in the case where connection information of a plurality of environment information DBs is managed by one relay DB. FIG. 14 is a diagram showing an installation example of each DB when using and managing the relay DB for each of a plurality of environment information DBs. FIG. 15 is a diagram showing an example of extraction target data (distribution information) and extraction conditions. FIG. 16 is a diagram showing an example of the extraction condition of the character string format. FIG. 17 is a diagram showing an example of a method of controlling extraction from extraction conditions of the character string format. FIG. 18 is a diagram showing an example of how to set a transaction range in the prior art. FIG. 19 is a diagram showing an example of a method of rollback when an error occurs in each of the cases where the transaction range is “company unit” and “overall range”. FIG. 20 is a diagram showing an example of a screen for setting a distribution definition master. FIG. 21 shows an example of how to merge and sort company information. FIG. 22 is a diagram showing an example of confirmation of distribution information and return of the confirmed distribution information. FIG. 23 is a diagram showing an example of work table update and confirmation of approval status in DB units. FIG. 24 is a diagram showing an example of work table update in the entire unit. FIG. 25 is a diagram illustrating an example of the flow of processing for creating a transaction range chunk. FIG. 26 is a diagram showing an example of a conventional master distribution method. FIG. 27 is a diagram showing an example of how to match distribution source data (distribution information) and distribution destination data (distribution destination information) and a data configuration example in the item dictionary master. FIG. 28 is a diagram showing an example of the delivery setting method in the case of no approval and in the case of approval. FIG. 29 is a diagram showing an example of the distribution process based on the distribution setting. FIG. 30 is a view showing an example of the data configuration of the item dictionary master, distribution source data (distribution information), and distribution destination data (distribution destination information). FIG. 31 is a diagram illustrating an example of the matching confirmation screen when all of “addition”, “correction”, and “deletion” are selected as the update method. FIG. 32 is a diagram showing an example of the match confirmation screen in each of the cases of selecting “addition” as the update method, selecting “correction”, and selecting “deletion”. FIG. 33 is a diagram showing an example of how to match distribution source data (distribution information) and distribution destination data (distribution destination information).

  Hereinafter, embodiments of a distribution information acquisition apparatus, a distribution information acquisition method, and a distribution information acquisition program according to the present invention will be described in detail based on the drawings. The present invention is not limited by the present embodiment.

[1. Overview]
Conventionally, when distributing distribution information, it has been necessary to prepare data to be distributed for each distribution destination and each master. In addition, when creating a program for setting extraction conditions from the same table and distributing it, it is difficult to perform uniform management and execution since the conditions to be distributed are different for each master.

Therefore, in the present embodiment, in master distribution processing in which masters are synchronized among a plurality of environments and companies, a system is provided which can extract data to be distributed for each environment and master and can distribute optimum data. The outline of the present embodiment is as shown in the following (1) to (3).
(1) In the distribution definition master that defines the company information of the distribution destination and the distribution source and the information of the master to be distributed, partial extraction of the same master is made possible by holding the extraction conditions for each distribution destination.
(2) Dynamically acquiring, for each master, column information serving as an extraction condition by lexicalizing information such as whether or not it can be used as a Japanese name of an item or an extraction condition for all the columns of each master Made it possible to As a result, the extraction condition setting screen is unified in all the masters, enabling flexible and easy master distribution.
(3) A general-purpose extraction condition (for example, a regular expression or the like) which is not limited by the format of the database to be distributed (for example, difference between RDBMS or non-RDBMS) by storing setting information of extraction conditions in character string format It also made it possible to store
The specific configuration and operation will be described below.

[2. Constitution]
The configuration of a delivery management system including the present invention will be described.

[2-1. overall structure]
The entire configuration of the distribution management system will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of a delivery management system. As shown in FIG. 1, the distribution management system includes a main company information processing apparatus 100 corresponding to a first apparatus and a distribution information acquisition apparatus, and a subsidiary information processing apparatus 200 corresponding to a second apparatus and a distribution management apparatus. It corresponds to a relay device 300 corresponding to a third device relaying the first device and the second device, a main company business DB 400 corresponding to a storage location of distribution information, and a distribution destination of the distribution information. It comprises a subsidiary business DB 500 and networks 600, 700, 800 and 900.

  In the present embodiment and the drawings, the main company information processing apparatus 100 may be described as a master distribution DB 100, the subsidiary information processing apparatus 200 as an environment information DB 200, and the relay apparatus 300 as a relay DB 300.

[2-2. Main company information processing apparatus 100]
The configuration of the main company information processing apparatus 100 will be described with reference to FIG. The main company information processing apparatus 100 is a commercially available desktop personal computer. Note that the main company information processing apparatus 100 is not limited to a stationary information processing apparatus such as a desktop personal computer, and may be a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, tablet personal computer, etc. It may be a portable information processing apparatus.

  The main company information processing apparatus 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The respective units included in the main company information processing apparatus 100 are communicably connected via an arbitrary communication path.

  The communication interface unit 104 communicably connects the main company information processing apparatus 100 to the networks 600 and 700 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 600 has a function of communicably connecting the main company information processing apparatus 100 and the main company business DB 400, and is, for example, the Internet, a local area network (LAN), or the like. Also, the network 700 has a function to connect the main company information processing apparatus 100 and the relay apparatus 300 so as to be able to communicate with each other, and is, for example, the Internet, a LAN, or the like.

  An input device 112 and an output device 114 are connected to the input / output interface unit 108. For the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. The input device 112 can be a keyboard, a mouse, a microphone, and a monitor that implements a pointing device function in cooperation with the mouse. Hereinafter, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

  The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving instructions to a central processing unit (CPU) in cooperation with an operating system (OS) to perform various processes. As the storage unit 106, for example, a memory device such as a random access memory (RAM) or a read only memory (ROM), a fixed disk device such as a hard disk, a flexible disk, an optical disk or the like can be used.

  The storage unit 106 includes, for example, a connection information master 106a as a first connection information master, a group master 106b as a first group master, a distribution target master 106c, and a distribution definition master 106d.

  The meaning of each term in the present embodiment will be described. The delivery source record is one line of specific information on the delivery source of the delivery information. For example, as shown in the table of “delivery source” in FIG. 30, “department CD: 001, reference date 2017/01 "01/01, department abbreviation: sales department" is a delivery source record of one line. The distribution information is information including the distribution source record. For example, in the case of the table of “distribution source” shown in FIG. 30, five rows of distribution source records can be collectively referred to as distribution information. The acquisition information is information used to acquire the distribution information, and is, for example, a specific name of a table or a master. For example, in the case of the table of “distribution source” shown in FIG. 30, the acquisition information is “department table”. For this reason, if the operator designates "department table" as the acquisition information, it is possible to acquire distribution information consisting of five rows of distribution source records shown in the "distribution source" table shown in FIG. The distribution information and the acquisition information are collectively referred to as distribution source data 406. The storage location of the distribution source data 406 is not particularly limited, but may be stored in the main company business DB 400 as shown in FIG. 1, for example, or may be stored in the main company information processing apparatus 100 itself. The distribution destination group is a concept in which the distribution destinations of the distribution information are grouped. The environment identification data is data for identifying a database environment to which the distribution destination group belongs.

  The connection information master 106a is, for example, the environment identification data (environment name) and first connection information (connection information) for connecting from the master distribution DB 100 to the relay DB 300 as shown in (1) server setting of FIG. including.

  The group master 106b includes, for example, the distribution destination group (distribution group name) and the environment identification data (environment name), as shown in (2) distribution group setting of FIG. The delivery destination (delivery destination company) is information set by the administrator of the environment information DB 200 as described later, so the administrator of the master delivery DB 100 refers to it unless the administrator of the environment information DB 200 permits it. It is not possible.

  The distribution target master 106c means, for example, that the distribution information that can be acquired by the acquisition information (master name) and the acquisition information is to be a distribution target, as shown in (3) distribution target setting of FIG. It includes one of the distribution permission classifications (“○” of distribution target) and the distribution non-permission classification (“x” of distribution target) that means not to be distributed.

  The distribution definition master 106d, for example, as shown in (4) setting of the distribution definition in FIG. 8, the acquisition information (distribution master), extraction conditions used to narrow down the distribution information, and the distribution destination group ( Distribution group name), a distribution definition (distribution definition name) for specifying at least one of the acquisition information, the extraction condition, and the distribution destination group. Details are given in [4. Specific Example of Processing] As described in the above, the operator can distribute desired distribution information to a desired distribution destination by specifying a distribution definition name. For example, if the distribution definition name “definition for construction subsidiary” is specified in (4) setting of the distribution definition in FIG. 8, information of the item codes 0001 to 1000 of the general account item master and the item codes A0001 to Information on A1000 can be distributed to the construction subsidiary Group. The delivery definition master 106 d may further include, for example, as shown in FIG. 20, an execution order for specifying the delivery order of the delivery information associated with the acquisition information.

  The information included in the connection information master 106a, the group master 106b, the distribution target master 106c, and the distribution definition master 106d described above is set by the administrator of the master distribution DB 100 unless otherwise specified.

  The control unit 102 is a CPU or the like that controls the main company information processing apparatus 100 in an integrated manner. The control unit 102 has an internal memory for storing control programs such as the OS, programs defining various processing procedures, required data, etc., and performs various information processing based on the stored programs. Run.

  The control unit 102 conceptually acquires, for example, (1) acquisition information for acquiring the acquisition information and the distribution destination group associated with the specified distribution definition with reference to the distribution definition master, for example. Acquisition information etc. acquiring unit 102a as means (acquiring means for acquiring acquisition information etc. for acquiring acquisition information and acquisition conditions associated with the specified distribution definition with reference to the distribution definition master); 2) Distribution information acquisition means for acquiring the distribution information associated with the acquisition information acquired by the acquisition information etc. acquisition means (associated with the acquisition information acquired by the acquisition information etc. acquisition means, and The distribution information acquisition unit 102b as a distribution information acquisition unit for acquiring the distribution information meeting the extraction condition acquired by the acquisition information etc. acquisition unit; And an environment identification data acquisition unit 102c as an environment identification data acquisition unit that acquires the environment identification data associated with the distribution destination group acquired by the acquisition information etc. acquisition unit; (4) the first connection information A first connection acquisition unit 102d as a first connection acquisition unit that acquires the first connection information associated with the environment identification data acquired by the environment identification data acquisition unit with reference to a master; The distribution information acquired by the distribution information acquiring unit and the environment identification data acquired by the environment identification data acquiring unit with respect to the third device connectable by the first connection information acquired by one connection acquiring unit (The distribution destination group acquired by the acquisition information acquisition unit, the distribution information acquired by the distribution information acquisition unit, and the environment identification data And a, a first transmission portion 102e of the said environmental identification data as the first transmission means) for transmitting to the second device acquired by means. In addition, about the detail of the process which each part performs, the following [4. Specific Example of Processing].

[2-3. Subsidiary Information Processing Device 200]
The configuration of the subsidiary information processing apparatus 200 will be described with reference to FIG. The subsidiary information processing apparatus 200 is a commercially available desktop personal computer. The subsidiary information processing apparatus 200 is not limited to a stationary information processing apparatus such as a desktop personal computer, but is a portable information processing apparatus such as a notebook personal computer, a PDA, a smartphone, a tablet personal computer, etc. which are commercially available. It may be.

  The subsidiary information processing apparatus 200 includes a control unit 202, a communication interface unit 204, a storage unit 206, and an input / output interface unit 208. The respective units included in the subsidiary information processing apparatus 200 are communicably connected via an arbitrary communication path.

  The communication interface unit 204 communicably connects the subsidiary information processing device 200 to the networks 800 and 900 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 204 has a function of communicating data with another device via a communication line. Here, the network 800 has a function of communicably connecting the subsidiary information processing apparatus 200 and the relay apparatus 300, and is, for example, the Internet, a LAN, or the like. The network 900 also has a function of communicably connecting the subsidiary information processing apparatus 200 and the subsidiary business DB 500, such as the Internet or a LAN.

  An input device 212 and an output device 214 are connected to the input / output interface unit 208. For the output device 214, in addition to a monitor (including a home television), a speaker or a printer can be used. The input device 212 can be a keyboard, a mouse, a microphone, and a monitor that implements a pointing device function in cooperation with the mouse. Hereinafter, the output device 214 may be described as the monitor 214, and the input device 212 may be described as the keyboard 212 or the mouse 212.

  The storage unit 206 stores various databases, tables, files, and the like. The storage unit 206 stores a computer program for giving instructions to the CPU in cooperation with the OS to perform various processes. As the storage unit 206, for example, a memory device such as a RAM or a ROM, a fixed disk device such as a hard disk, a flexible disk, an optical disk or the like can be used.

  The storage unit 206 includes, for example, a connection information master 206a as a second connection information master, a group master 206b as a second group master, a distribution target master 206c, and an item dictionary master 206d.

  The meaning of each term in the present embodiment will be described. The delivery destination record is one line of specific information on the delivery destination of the delivery information, and for example, as shown in the table of “delivery destination” in FIG. 30, “department CD: 002, reference date: 2000 / 01/01, department abbreviation name: accounting department "becomes the delivery place record of 1 line. The distribution destination information is information including the distribution destination record. For example, in the case of the “distribution destination” table shown in FIG. 30, records of three lines can be collectively referred to as distribution destination information. The acquisition information is information used to acquire the distribution destination information, and is, for example, a specific name of a table or a master. For example, in the case of the "distribution destination" table shown in FIG. 30, the acquisition information is the "department table". Therefore, if the operator designates "department table" as the acquisition information, it is possible to acquire distribution destination information composed of distribution destination records of three lines shown in the "distribution destination" table shown in FIG. The distribution destination information and the acquisition information are collectively referred to as distribution destination data 506. The distribution destination data 506 is stored, for example, in the subsidiary business DB 500 as shown in FIG.

  The connection information master 206 a includes, for example, the environment identification data and second connection information for connecting the environment information DB 200 to the relay DB 300. The information included in the connection information master 206 a is set by the administrator of the environment information DB 200.

  The group master 206b is set, for example, as follows. As described in [2-2], the manager of the master distribution DB 100 sets the group master 106 b including the distribution destination group (distribution group name) and the environment identification data (environment name), and the setting The group master 106 b is copied to the environment information DB 200 by transmitting the group master 106 b to the environment information DB 200 through the relay DB 300. Then, the administrator of the environment information DB 200 (administrator of the delivery destination company) sets the delivery group designated by the administrator of the master delivery DB 100 (delivery source company) as shown in (2) Delivery group setting of FIG. In contrast, setting which group master 206b is completed by selecting which company to be distributed and registering the distribution destination (distribution destination company name) in the group master 106b. Therefore, as shown in (2) distribution group setting of FIG. 12, the group master 206b, for example, includes the distribution destination group (distribution group name), the environment identification data (environment name), and the distribution destination (distribution destination company). Name) and In addition, assuming that there is a need not to show the information of the delivery destination company to the manager of the master delivery DB 100, management of the master delivery DB 100 as shown by triangles in (2) delivery group setting of FIG. It is assumed that the administrator of the environment information DB 200 can switch whether or not the user is permitted to refer to the distribution destination company of the environment information DB 200 which is an external environment.

  The distribution target master 206c is set, for example, as follows. As described in the above [2-2], the administrator of the master distribution DB 100 is a distribution target master including the acquisition information (master name) and the distribution division (“○” and “×” of distribution targets) By setting 106 c and transmitting the set distribution target master 106 c to the environment information DB 200 through the relay DB 300, the distribution target master 106 c is copied to the environment information DB 200. Then, the administrator of the environment information DB 200 (administrator of the delivery destination company) can obtain the information by the acquisition information (master to be delivered) as shown in (3) Delivery target setting of FIG. One of the distribution acceptance classifications of the distribution acceptance permission classification (the permission flag "permit") which means to accept distribution information and the non-permission classification (the permission flag "disapproval") which means not to accept, and the above By registering the distribution information update control method that can be acquired by the acquisition information in the distribution target master 106c, the setting of the distribution target master 206c is completed. For this reason, as shown in (3) distribution target setting of FIG. 12, the distribution target master 206c, for example, includes the acquisition information (master name) and the distribution division (distribution target "o" and "x"). The distribution acceptance category ("permit" and "disallow" of the permission flag) and the update control method are included. Note that the distribution acceptance classification and the update control method can also be expanded, for example, by each distribution destination name.

  The item dictionary master 206d, as shown in FIG. 30, for example, selects the item for acquisition (table name), the item (item name) for the specific information, and the item if the item is a key item. It includes key item information ("key" of item type), type and number of digits to be attached.

  The control unit 202 is a CPU or the like that controls the subsidiary information processing apparatus 200 in an integrated manner. The control unit 202 has an internal memory for storing control programs such as the OS, programs defining various processing procedures, required data, etc., and various information processing is performed based on the stored programs. Run.

  The control unit 202 functionally and, for example, (1) refers to the second group master to acquire the environment identification data transmitted by the third transmission unit and the distribution destination associated with the distribution destination group. Distribution destination acquisition means (distribution destination acquisition means for acquiring the distribution destination associated with the distribution destination group transmitted by the first transmission means and the environment identification data with reference to the second group master) (2) the second transmission unit (the first transmission unit transmits the distribution information transmitted by the third transmission unit to the distribution destination acquired by the distribution destination acquisition unit); Transmission of the delivery information to the delivery destination acquired by the delivery destination acquiring means is performed as one transmission unit for all the delivery destinations acquired by the As a second transmission unit) which transmits any of individual transmissions in which a combination of the environment identification data transmitted by the transmission unit and the distribution destination acquired by the distribution destination acquisition unit is the same as one transmission unit (2) an update unit as an update unit for updating the distribution destination information at the distribution destination (an update unit for updating the distribution destination information based on the result of the determination by the determination unit) 202c, (4) the first transmission of the distribution destination information for all the distribution destinations when all of the distribution destinations acquired by the distribution destination acquiring means approve the acceptance of distribution of the distribution information Batch updating unit 202c1 as batch updating means for updating to the distribution information transmitted by the means; and (5) acquisition of the distribution destination approved to accept distribution of the distribution information An individual updating unit 202c2 as an individual updating unit that updates only the distribution destination information about the distribution destination acquired in the stage to the distribution information transmitted by the first transmission unit; (6) the determination by the determination unit As a result, when there is a record that is not the same and there is a record that is included in the delivery source data but not included in the delivery destination data, the delivery source record corresponding to the included record is the delivery destination (7) As a result of the determination by the adding unit 202c3 as adding means for adding to data, and (7) determination means, the same but the above other than the key item between the distribution source record and the distribution destination record If there is a record in which the specific information of the item is different, the correction means as a correction means for correcting the specific information of the distribution destination record to the specific information of the distribution source record (8) As a result of the determination made by the correct part 202c4 and (8) determination means, if the same is not the case and there is a record which is not included in the delivery source data but is included in the delivery destination data A deletion unit 202c5 as deletion means for deleting a delivery destination record corresponding to the included record from the delivery destination data, and (9) all the delivery destination records included in the delivery destination data are included in the delivery source data Selected among the distribution source or the distribution destination among the total replacement unit 202c6 as the total replacement unit for replacing the distribution source record to be stored, (10) the addition unit, the correction unit, the deletion unit, and the total replacement unit Update control unit 202d as an update control unit that enables only update by the above unit, and (11) referring to the item dictionary master. A key item acquisition unit 202e as a key item acquisition unit that acquires the item having the key item information linked with the designated acquisition information, and (12) the delivery destination data and the delivery information The distribution information including the distribution source record including the specific information on the distribution source of the distribution source and the acquisition source data including the acquisition information used to acquire the distribution information, and the designated information for acquisition and the string Between the delivery destination record and the delivery source record acquired by the record obtaining unit 202f as a record obtaining means for obtaining the delivery destination record and the delivery source record to be attached; Judgment means for judging whether the specific information about the key item acquired by the acquisition means is the same or not the same And a, a determination unit 202g as. In addition, about the detail of the process which each part performs, the following [4. Specific Example of Processing].

[2-4. Relay device 300]
The configuration of relay apparatus 300 will be described using FIG. 4. The relay device 300 is a commercially available desktop personal computer. The relay device 300 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable information processing device such as a notebook personal computer, a PDA, a smartphone, or a tablet personal computer that is commercially available. It is also good.

  The relay apparatus 300 includes a control unit 302, a communication interface unit 304, a storage unit 306, and an input / output interface unit 308. The units included in the relay device 300 are communicably connected via any communication path.

  The communication interface unit 304 communicably connects the relay device 300 to the networks 700 and 800 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 304 has a function of communicating data with another device via a communication line. Here, the network 700 has a function of communicably connecting the relay device 300 and the main company information processing device 100, and is, for example, the Internet, a LAN, or the like. Also, the network 800 has a function of communicably connecting the relay device 300 and the subsidiary information processing device 200, and is, for example, the Internet, a LAN, or the like.

  An input device 312 and an output device 314 are connected to the input / output interface unit 308. For the output device 314, a speaker or a printer can be used in addition to a monitor (including a home television). The input device 312 can be a keyboard, a mouse, a microphone, and a monitor that cooperates with the mouse to realize a pointing device function. Hereinafter, the output device 314 may be described as the monitor 314, and the input device 312 may be described as the keyboard 312 or the mouse 312.

  The storage unit 306 stores various databases, tables, files, and the like. A storage unit 306 stores a computer program for giving instructions to the CPU in cooperation with the OS to perform various processes. As the storage unit 306, for example, a memory device such as a RAM or a ROM, a fixed disk device such as a hard disk, a flexible disk, an optical disk or the like can be used.

  The storage unit 306 has, for example, a connection information master 306 a as a third connection information master.

  The connection information master 306a is set, for example, as follows. The administrator of the master delivery DB 100 sets the connection information master 306a including the environment identification data (environment name) as shown in (1) server setting of FIG. 12, and sets the connection information master 306a to the connection information. The master 106a transmits it to the relay DB 300 that can be connected. Then, as shown in (1) server setting of FIG. 12, the administrator of the environment information DB 200 connects to the relay DB 300 which can be connected by the connection information master 206a, and from the relay DB 300 to the transmitted connection information master 306a. Third connection information (connection information) for connection to the environment information DB 200 is registered. Therefore, the connection information master 306a includes, for example, the environment identification data (environment name) and the third connection information (connection information) as shown in (1) server setting of FIG. The third connection information (connection information) is preferably encrypted and set. Only the administrator of the environment information DB 200 can refer to and update the third connection information (connection information) which is connection information to the environment information DB 200.

  The control unit 302 is a CPU or the like that controls the relay device 300 in an integrated manner. The control unit 302 has an internal memory for storing control programs such as the OS, programs defining various processing procedures, required data, and the like, and performs various information processing based on the stored programs. Run.

  The control unit 302 functionally and, for example, (1) refers to the third connection information master to acquire the third connection information associated with the environment identification data transmitted by the first transmission unit. A third connection acquisition unit 302a as a third connection acquisition unit; and (2) the first transmission unit for the second device connectable by the third connection information acquired by the third connection acquisition unit. And a third transmitting unit 302b as a third transmitting unit that transmits the transmitted distribution information. In addition, about the detail of the process which each part performs, the following [4. Specific Example of Processing].

[2-5. Main Company Business DB 400]
As shown in FIG. 1, the distribution source data 406 is stored in the main company business DB 400. The distribution source data 406 may be stored in the main company information processing apparatus 100 as described in the above [2-2].

[2-6. Subsidiary Business DB 500]
As shown in FIG. 1, the distribution destination data 506 is stored in the subsidiary business DB 500.

[3. Processing Overview]
The outline of the process according to the present embodiment will be described below with reference to FIGS.

[3-1. background]
First, the background will be described with reference to FIG. Conventionally, when distributing data (master) of a major company to a subsidiary, data can be distributed only among companies belonging to the same environment, and all data is deleted and replaced. Therefore, there was a restriction that the data delivery function can be used only at the time of system introduction. For this reason, when distributing a master after system operation, only data migration via a CSV file or the like can be performed, and the number of companies is multiplied by the number of masters as shown in Example 1 and Example 2 below. Because it is necessary to manually accept the CSV file, the maintenance of the master data takes time and costs.

  As shown in the left figure in Fig. 5 as an example 1, there is a method of copying the master between companies in case of master distribution to companies belonging to the same database environment as shown in the left figure. There is a problem that it can only be used at the time of system introduction because it is not done. There is also a method of performing master input / output, but with this method, there is a problem that it is necessary to log in to each company and manually execute each company and master. Regardless of which method is used, even when masters are unified among a plurality of group companies, master unification work has been troublesome.

  As Example 2, as shown in the right figure of FIG. 5, there is a method of performing master input / output when performing master distribution to a company belonging to another database environment, but this method is as described in the previous paragraph. There is a problem that it is necessary to log in for each company and manually execute for each company and master. In other words, when data is distributed across environments (environment DBs), only the method of master input / output can be used, and master unification work has been troublesome.

  Therefore, in the master distribution function according to the present embodiment, it is possible to perform batch distribution of masters to a plurality of companies by grouping distribution destination companies and performing master distribution to the group. In addition, another server company can be included in the group, and it is possible to perform master maintenance in a short time regardless of the server configuration of the company.

[3-2. About data environment, setting flow and table structure]
Next, the data environment, setting flow, and table structure according to the present embodiment will be described with reference to FIGS.

  A data environment according to the present embodiment will be described using the image diagram of FIG. 6 and the table diagram of FIG. As shown in the image of FIG. 6 and the table of FIG. 7, the 100th company (parent company) and the 200th company (core company) belong to Environment 1, and the 300th company and 400 company (both domestic construction subsidiaries) 10 belongs to Environment 2, 10 companies (overseas construction subsidiaries) and 20 companies (overseas trading subsidiaries) belong to Environment 3, 30 companies and 40 belong to Environment 4. As shown in the image diagram of FIG. 6 and the table diagram of FIG. 7, the parent company and domestic subsidiaries belong to server A managing environment 1 and environment 2 and server B managing environment 3 and environment 4 overseas. Subsidiary belongs. As described above, in the data environment where there are many companies in the same industry, and in the case where there are domestic and overseas companies, it has been difficult to easily maintain the same master data, but in the present embodiment According to this, the same master data can be easily maintained by the method described in the following setting flow and table structure.

  The setting flow according to the present embodiment will be described with reference to the flowchart of FIG. First, when data is distributed to a company in another environment (step S0: Yes), server setting is performed (step S1), and grouping setting of a distribution destination company is subsequently performed (step S2). On the other hand, when data is not distributed to a company in another environment (step S0: No), there is no need for server setting, and grouping setting of a distribution destination company is performed (step S2). Following the grouping setting of the delivery destination company (step S2), setting of a master to be a distribution target (step S3) and setting of a distribution definition (step S4) are performed. Then, distribution execution is performed based on the distribution definition set in step S4 (step S5).

The table structure according to the present embodiment will be described using FIG. 8 as an example in which data (master) of company number 100 is distributed to company number 10, company number 20, company number 200 and company number 300.
(1) First, perform server setting. Specifically, as shown in FIG. 8 (1) server setting (the setting is necessary when distributing to a company in another environment), the 300th company belonging to Environment 2 which is an environment different from the 100th company (in Japan For the subsidiary company, set the environmental name and connection information, and also set the environmental name and connection information for the 10th and 20th companies (overseas subsidiaries) belonging to the environment 3 which is different from the 100th company. . The connection information is information required to connect to the environment DB of each server of the distribution destination.
(2) Next, grouping setting of delivery destination company information is performed. Specifically, as shown in (2) Grouping setting of delivery destination companies in FIG. 8, the 200th, 300th and 10th companies are set as the construction subsidiary group, while the 20th company is set. Set as a trading company subsidiary group. It should be noted that even if a company (200th company) in the same environment and a company (10th and 300th companies) in another environment are grouped into one distribution group as viewed from the distribution source company (100th company) Good.
(3) Next, the master to be distributed is set. Specifically, as shown in (3) setting of masters to be distributed in FIG. 8, the general account item master, subsidiary item master, slip classification master and マ ス タ master are set as distribution targets. Further, each master set as a distribution target can be set by checking whether to actually distribute or not, and furthermore, for each master set as a distribution target, the update control method (all deletion It is also possible to select replacement, addition only, addition / update.
(4) Next, set the delivery definition. Specifically, as shown in (4) Setting of distribution definition in FIG. 8, setting from the master set as the target of distribution in (3) by setting the distribution master (setting of what to distribute) And (2) setting a distribution group by selecting from among the distribution groups created in (2) (setting to which to distribute to). It is also possible to specify in detail the data to be distributed by setting extraction conditions for each master. Then, in order to specify the combination of the set distribution master, distribution group and extraction condition, a distribution definition name is set.
(5) Finally, by specifying the delivery definition name in the delivery definition set in (4), the 100th company can execute delivery. Specifically, if the distribution definition name "definition for construction subsidiary" is specified, the general account item master and subsidiary item master can be distributed to the 10th, 200th and 300th companies, and the distribution definition name "trade company system" If "Definement for subsidiary" is specified, the general account item master and subsidiary item master can be distributed to the 20th company, and if the distribution definition name "definition for all subsidiaries" is specified, the slip classification master is 10th company, It can be distributed to 20th, 200th and 300th companies.

[3-3. About the operation assumption of master distribution]
Lastly, the operation assumption of master distribution according to the present embodiment will be described with reference to FIGS. 9 and 10.

As shown in FIG. 9, according to the present embodiment, any of the following master distributions (1) to (3) are possible.
(1) Master distribution from parent company to subsidiary when parent company and subsidiary have same server and same environment (2) Parent company and subsidiary have same server and same environment, but parent company and group company have same server and different environment (3) The parent company and the subsidiary company have the same server and the same environment, but the parent company and the group company have another server and the other environment, the parent company to the group company Master delivery

As shown in FIG. 10, according to this embodiment, any data migration of the following (1) to (2) is possible.
(1) Data migration from test environment to production environment when test environment and production environment are the same server and different environment (2) Test environment to production environment when test environment and production environment are different servers Data migration

[4. Specific example of processing]
Hereinafter, specific examples of the process according to the present embodiment will be described.

[4-1. Grouping Master Delivery]
In this item, grouping master distribution (processing for realizing batch distribution of data from a distribution source by grouping distribution destinations) will be described with reference to FIGS. The grouping master distribution process may be either a configuration that does not consider security or a configuration that considers it, so in this item, both configurations will be described.

[4-1-1. Grouping master distribution without considering security]
First, grouping master distribution processing in which security is not considered (that is, processing for not performing approval operation of a manager of a distribution destination company at the time of master distribution) will be described using FIG.

  First, as shown in (1) server setting of FIG. 11, the manager of the delivery source company registers an environment name (environment 1) and connection information (connection string of environment information DB). In the master distribution DB, connection information of the environment information DB is held.

  Next, as shown in (2) distribution group setting of FIG. 11, the server environment (environment 1) and distribution destination company number registered by the distribution source company administrator in the distribution group name (group 1) and (1) (The 200th company) is specified.

  Next, as shown in (3) Delivery target setting of FIG. 11, the administrator of the delivery source company selects a table (master 1 and master 2) to be a delivery target, and delivery is performed for the selected master. Select whether to target. In the example of FIG. 11, the master 1 is targeted for distribution, while the master 2 is not targeted for distribution.

  Next, as shown in (4) distribution definition setting of FIG. 11, the administrator of the distribution source company creates a distribution definition for the masters whose distribution group (group 1) and the distribution destination have permitted distribution.

  Finally, as shown in (5) distribution processing of FIG. 11, the administrator of the distribution source company distributes the data (business DB 400) of the distribution source company to the distribution destination company based on the distribution definition created in (4). Deliver to business DB 500).

  As described above in this item [4-1-1], according to the distribution management system according to the present embodiment, distribution of information from the distribution source to the distribution destination is collectively performed by grouping the distribution destinations. It can be done (grouping master delivery). However, in the form described in this item, there is a possibility that the information of the distribution destination can be seen from the distribution source. Therefore, as described in the following [4-1-2], it is preferable to perform grouping master distribution in consideration of security.

[4-1-2. Grouping Master Distribution Considering Security]
Next, grouping master distribution in consideration of security (that is, processing of performing approval operation of a manager of a distribution destination company at the time of master distribution) will be described using FIG. Approval is roughly divided into (A) stages of registration of connection information, affiliated company information, a distribution target master, etc. as preparation necessary for performing distribution (A in FIG. 12) and (B) sent from a distribution source Before reflecting the incoming data, there are two steps (B in FIG. 12) of confirming and approving at the delivery destination. The data configuration of each master is as shown in FIG.

(Information acquisition process for acquisition)
The acquisition information acquisition unit 102a refers to the distribution definition master 106d as shown in (4) distribution definition setting of FIG. 12, and acquires information (master 1) associated with the specified distribution definition (definition 1). And master 2, both account item masters) and distribution destination group (group 1) are acquired.

(Distribution information acquisition process)
The distribution information acquisition unit 102b acquires distribution information associated with the acquisition information (master 1 and master 2) acquired by the acquisition information etc. acquisition unit 102a. Although not shown, it is assumed that the distribution information associated with master 1 and master 2 is account item "cash" and its code, and account item "receivables" and its code.

(Environmental identification data acquisition process)
The environment identification data acquiring unit 102c refers to the group master 106b and associates with the distribution destination group (group 1) acquired by the acquiring information etc. acquiring unit 102a as shown in (2) distribution group setting of FIG. Acquire environment identification data (environment 1).

(First connection acquisition process)
The first connection acquisition unit 102d refers to the connection information master 106a as shown in (1) server setting of FIG. 12, and associates the first connection acquisition unit 102d with the environment identification data (environment 1) acquired by the environment identification data acquisition unit 102c. One connection information (connection string of relay DB) is acquired.

(First transmission process)
The first transmission unit 102e transmits the distribution information (accounts acquired by the distribution information acquisition unit 102b to the relay DB 300 that can be connected by the first connection information (connection string of the relay DB) acquired by the first connection acquisition unit 102d. The subject "cash" and its code, the account "account receivable" and its code) and the environment identification data (environment 1) acquired by the environment identification data acquisition unit 102c are transmitted. The first transmission unit 102e transmits together the acquisition information (master 1 and master 2) acquired by the acquisition information etc. acquisition unit 102a and the distribution destination group (group 1) acquired by the environment identification data acquisition unit 102c. May be

(Third connection acquisition process)
The third connection acquisition unit 302 a refers to the connection information master 306 a as illustrated in (1) server setting of FIG. 12, and the third connection acquisition unit 302 a associates with the environment identification data (environment 1) transmitted by the first transmission unit 102 e. Get connection information (connection string of environment information DB).

(Third transmission process)
The third transmission unit 302b transmits the distribution transmitted by the first transmission unit 102e to the environment information DB 200 that can be connected by the third connection information (connection string of the environment information DB) acquired by the third connection acquisition unit 302a. Send information (the account "cash" and its code as well as the account "accounts receivable" and its code). The third transmitting unit 302b may transmit both the acquisition information (master 1 and master 2) transmitted by the first transmitting unit 102e, the environment identification data (environment 1), and the distribution destination group (group 1). .

(Distribution destination acquisition process)
The distribution destination acquisition unit 202a refers to the group master 206b as shown in (2) distribution group setting of FIG. 12, and transmits the environment identification data (environment 1) and the distribution destination group (group 1) transmitted by the third transmission unit 302b. 1) Obtain a distribution destination company (the 100th company and the 200th company) linked to 1).

(Second transmission process)
As shown in (5) distribution processing of FIG. 12, the second transmission unit 202b performs third transmission to the distribution destination company (business DB of 100th and 200th companies) acquired by the distribution destination acquisition unit 202a. The distribution information (the account item "cash" and its code and the account item "receivable" and its code) transmitted by the unit 302b is transmitted. As shown in (3) distribution target setting of FIG. 12, the second transmitting unit 202b is, among the distribution target master 206c, acquisition information whose distribution target is “O” and the permission flag is “permitted” (master Only distribution information associated with 1) may be transmitted. That is, in this case, the second transmitting unit 202b does not transmit the account item "cash" and its code and account item "receivables" and its code for master 2, and the account item "cash" and its code for master 1 Only the code and the account "accounts receivable" and its code will be sent.

  Note that the second transmission unit 202b may transmit the distribution information only to the distribution destination (a distribution destination company) that has accepted acceptance of the distribution information transmitted by the third transmission unit 302b.

  As described above in this item [4-1-2], according to the distribution management system according to the present embodiment, distribution of information from the distribution source to the distribution destination is collectively performed by grouping the distribution destinations. The security of the distribution source and the distribution destination can be secured by adopting a configuration in which exchange of information between the distribution source and the distribution destination is performed through the relay device.

[4-1-3. About relay DB 300]
The storage location of the relay DB 300 will be described. The purpose of using the relay DB 300 is that the administrator of the master distribution DB 100 and the administrator of the environment information DB 200 do not want to know the connection information held by each other at all. The connection information to the relay DB 300 can be known by any administrator, so if the master distribution DB 100 and the environment information DB 200 are managed in the same server as the relay DB 300 server, information such as the server name etc. , Will be known to the other party manager. Therefore, it is preferable that the relay DB 300 be managed by a server different from the server in which the master distribution DB 100 and the environment information DB 200 exist. When appropriate security settings are made in the DB in the server, there is no problem even if the master distribution DB 100 and the environment information DB 200 are managed in the same server as the relay DB 300 server, In order to secure more complete security, the relay DB 300 is preferably managed by a server different from the server on which the master distribution DB 100 and the environment information DB 200 exist.

  The usage mode of the relay DB 300 will be described. Regarding the usage mode of the relay DB 300, as shown in FIG. 13, (A) a mode in which connection information of a plurality of environment information DBs 200 is managed by one relay DB 300, and as shown in FIG. There are two possible modes of using and managing the relay DB 300, but either mode may be used. The features when using each mode are shown below.

Feature of the mode of (A) (1) In order to manage the connection information of all of the distribution destination environment information DB 200 for one relay DB 300, it is the simplest method as a DB management method in master distribution considering security. is there.
(2) Since the relay DB 300 requires only the minimum number of components, resources can be minimized and management is easy.
(3) The relay DB 300 is managed by the system administrator on the master distribution DB 100 side.

Feature of mode of (B) (1) In order to manage one connection information of the distribution destination environment information DB 200 for one relay DB 300, even if a connection failure or the like to the relay DB 300 occurs, the influence is It can be minimized.
(2) The management of the relay DB 300 is performed by a system administrator on each environment information DB 200 side.

[4-1-4. Summary]
The points in the above [4-1-1] to [4-1-3] are shown in the following (1) to (5).
(1) The relay DB 300 is prepared separately from the master distribution DB 100 and the distribution destination environment information DB 200.
(2) Only the connection information of the relay DB 300 is managed from the master distribution DB 100 so that the administrator (distribution source administrator) of the master distribution DB 100 can not view the connection information of the distribution destination environment information DB 200.
(3) The company information of the distribution destination is held only in the distribution destination environment information DB 200 so that the manager (distribution source administrator) of the master distribution DB 100 can not view the company information of the distribution destination.
(4) In the distribution target master, management information of the content that the distribution source wants to distribute (“○” or “×” in the distribution target master) and management information of the content that the distribution destination wants to receive (permission flag in the distribution target master (“Permitted” or “not permitted”)) to be held separately.
(5) The administrator of the delivery destination company can confirm and approve the data that the delivery source wants to deliver before receiving the data.

[4-2. Acquisition of distribution information using extraction conditions]
In this item, distribution information acquisition using extraction conditions will be described with reference to FIGS.

Here, it is preferable that the extraction condition is data of a character string format (for example, an XML format etc.) for the following reasons (1) to (3).
(1) By storing the extraction condition in the form of a character string, it is possible to manage and control information regardless of the form of the database or the description form of the query. By reading and writing to the database using the string format, it works as a mechanism that can be used universally in any language system.
(2) If the condition contains a function etc., the number of required arguments may differ for each function, but in this case it is necessary to save the extraction condition in the form of a character string. This is because not only the number of arguments but also unified database management becomes possible. In the following [4-2-1], an example is shown in which the distribution information matching the extraction condition of the character string format is acquired using the MID function and the LEFT function which are generally used.
(3) As a mechanism for performing execution control to actually extract based on the extraction condition setting of the character string format, it is possible to achieve general purpose using templating and substitution of request queries. In the following [4-2-2], an example of a method of controlling the extraction from the extraction condition of the character string format is shown.

[4-2-1. Example of acquiring delivery information matching extraction condition of character string form using MID function and LEFT function]
In this item, an example of acquiring data of the employees "Yamamoto" and "Kawasaki" from the distribution information shown in <data to be extracted> in FIG. 15 will be described. Here, the distribution information and the extraction condition that are the premise of data acquisition will be described.

  The delivery information will be described. In <data to be extracted> in Fig. 15, which corresponds to delivery information, the first three letters of the employee CD indicate the department to which it belongs (TKY indicates Tokyo, NGY indicates Nagoya), and the subsequent four digits The numbers indicate employee numbers.

The extraction conditions will be described. In this item, extraction conditions are described using a MID function and a LEFT function, as shown in <example of extraction conditions> in FIG. In the MID function, three arguments are required, and when it is described as MID (character string, start position, number of characters), it is specified by the third argument from the start position specified by the second argument of the character string of the first argument It means taking out the number of characters. On the other hand, the LEFT function requires two arguments. When LEFT (character string, number of characters) is described, it means that the number of characters specified by the second argument is extracted from the beginning of the character string of the first argument. Therefore, the meanings of the extraction conditions shown in <example of extraction conditions> in FIG. 15 are as follows.
“LEFT (Employee CD, 3) = 'TKY'” (condition 1) means that the result of extracting three characters from the employee CD from the left is equal to the character string 'TKY'.
“MID (Employee CD, 4, 4)> = 1000” (condition 2) indicates that the result of extracting the four characters from the fourth character from the left of the employee CD is the character string '1000' or later means.
"MID (Employee CD 4, 4) <= 2000" (condition 3) indicates that the result of extracting the employee CD from the leftmost four characters from the left is four characters before character string '2000' means.

  An example will be described in which data of the employees "Yamamoto" and "Kawasaki" are acquired from the distribution information using the MID function and the LEFT function, assuming that the above distribution information and extraction conditions are set. Although not shown in the distribution definition master 106 d, “employee data” is set as acquisition information, “conditions 1 to 3” are set as extraction conditions, and “definition for employees” is set as distribution definitions. It is assumed that

(Acquisition process for acquisition information etc.)
The acquisition information acquisition unit 102a refers to the distribution definition master 106d to acquire acquisition information (employee data) and extraction conditions (conditions 1 to 3) associated with the specified distribution definition (definition for employee). .

(Distribution information acquisition process)
The distribution information acquisition unit 102b is associated with the acquisition information (employee data) acquired by the acquisition information etc. acquisition unit 102a, and matches the extraction conditions (conditions 1 to 3) acquired by the acquisition information etc. acquisition unit 102a. Get delivery information. That is, referring to <data to be extracted> of FIG. 15 corresponding to delivery information, all employees are linked with acquisition information (employee data) (not shown), but condition 1 (employee CD from left 3 The employees who match the character string 'TKY' as the result of character extraction) are “Yamamoto”, “Kawasaki”, “Ito” and “Toda”, and the condition 2 and 3 (Employee CD from the left) Only the two employees "Yamamoto" and "Kawasaki" match the character string '1000' and the following and '2000') as a result of four characters extracted from the fourth character. As described above, the distribution information acquisition unit 102b acquires data of the employees "Yamamoto" and "Kawasaki" from the distribution information.

  Although the case where the extraction condition is in the character string format has been described in this item, when the extraction condition is in the table format, retention of data shown in <when the extraction condition is retained in the table format of FIG. It becomes the way of. Since the retention of extraction conditions in the form of a table can not cope with the case where the number of columns increases or decreases depending on the number of required arguments for each function, it is not suitable as a database registration method. Specifically, in <if the extraction condition is to be stored in table format in FIG. 15>, although a function having three or less arguments can be handled, a function having four or more arguments is added to the extraction condition If you do, you can not respond. On the other hand, in the case of the character string format, as shown in FIG. 16, necessary information can be stored in one record, so that it is possible to flexibly cope with increase and decrease of arguments.

  As described above in the item [4-2-1], according to the delivery management system of the present embodiment, it is possible to obtain only part of the delivery information that meets the conditions desired by the operator.

4-2-2. Example of a method to control extraction from extraction condition of character string form]
An example of a method of controlling extraction from extraction conditions of the character string format is shown in FIG.

4-2-3. Summary]
The points in the above [4-2-1] to [4-2-2] are shown in the following (1) to (3).
(1) The following can be achieved by having the filter condition (extraction condition) as a character string.
-The extraction condition can be stored in the same column even if the extraction condition is different for each table to be distributed.
-When the extraction conditions increase, it is not necessary to change the structure of the setting table storing the extraction conditions.
-By storing setting information of extraction conditions in the form of a character string, it becomes possible to perform general-purpose description regardless of the format of the distributed database.
(2) By setting the distribution definition master 106d, filter conditions (extraction conditions) can be divided and held for each table to be distributed and for each distribution destination group. As a result, it becomes possible to change the contents of distribution for each distribution destination from the same distribution source.
(3) As described in the above [4-1], the information that needs to be set before distribution can be collected in advance as one unit of the distribution definition master 106d, so distribution is performed at the time of distribution execution. It is only necessary to specify the distribution definition included in the definition master 106d. Here, large-scale group companies have many subsidiaries, and the subsidiaries often belong to an industry completely different from the parent company, and there is a need to change distribution data for each distribution destination company. Therefore, according to the master distribution described in this item [4-2], the extraction condition for each company can be recorded in the DB (distribution definition master 106d), so a company group that spans multiple industries It has become possible to distribute master data in line with the business of each company, even in a company that The information that needs to be registered in the distribution definition master 106d is: Delivery destination company information 2. Delivery source company information 3. Master information to be distributed and There are four pieces of information of a master and extraction conditions (filter conditions) to be distributed to each company, and these four pieces of information can be collectively managed as a distribution definition. In addition, since the filter condition is stored in the DB (distribution definition master 106 d) in a character string (XML or the like) format, it is not necessary to change the table structure of the distribution definition master 106 d even if an item is added.

[4-3. Send and Update in Desired Transaction Range]
This section describes transmissions and updates in the desired transaction range.

[4-3-1. Send in desired transaction range]
In this item, transmission in a desired transaction range will be described using FIG. 20 and FIG. In this item, the data configurations in the group master 106b, the distribution definition master 106d, and the group master 206b are as follows.
(Group master 106b) ... stored in master distribution DB 100 (distribution source) Group 1 Environment 1
Group 2 Environment 1
Group 2 Environment 2
(Distribution definition master 106d) ... stored in master distribution DB 100 (distribution source) Master 1 Group 1 Definition 1 Execution order 2
Master 2 Group 2 Definition 2 Execution Order 1
Master 3 Group 1 Definition 3 Execution Order 3
(Group master 206b) ... stored in environmental information DB 200 (Distribution destination) Group 1 Environment 1 100th Company, 200th Company, 300th Company Group 2 Environment 1 100th Company, 300th Company Group 2 Environment 2 100th Company

(Acquisition processing for acquisition information, etc.)
The acquisition information etc. acquiring unit 102a acquires acquisition information (master name) and distribution destination group (distribution destination group name) that are associated with the specified distribution definition, with reference to the distribution definition master 106d. In this example, it is assumed that the delivery definitions 1, 2 and 3 are specified. In this case, the acquisition information acquisition unit 102a obtains “master 1, group 1 and execution order 2” for “delivery definition 1”. Then, “master 2 and group 2 and order of execution 1” is acquired for “distribution definition 2”, and “master 3 and group 1 and order of execution 3” is acquired for “distribution definition 3”.

(Distribution information acquisition process)
The distribution information acquisition unit 102b acquires distribution information 1 to 3 associated with the acquisition information (masters 1, 2 and 3) acquired by the acquisition information etc. acquisition unit 102a.

(Environmental identification data acquisition process)
The environment identification data acquisition unit 102c refers to the group master 106b to acquire environment identification data (environment name) associated with the distribution destination group (distribution destination group name) acquired by the acquisition information etc. acquisition unit 102a. Specifically, “environment 1” is acquired for group 1 and “environment 1 and environment 2” is acquired for group 2.

(First transmission process)
The first transmission unit 102e includes the distribution destination group (distribution destination group name) acquired by the acquisition information acquisition unit 102a, the distribution information acquired by the distribution information acquisition unit 102b, and the environment identification data acquired by the environment identification data acquisition unit 102c. The (environment name) is sent to the second device (environment information DB 200). The first transmission unit 102e may transmit the execution order acquired by the acquisition information acquisition unit 102a to the second apparatus (environment information DB 200). Specifically, the first transmission unit 102e has "group 1, distribution information 1, environment 1, execution order 2", "group 2, distribution information 2, environment 1, execution order 1", "group 2 and distribution information Four combinations of 2 and environment 2 and execution order 1 and “group 1 and distribution information 3 and environment 1 and execution order 3” are transmitted to the environment information DB 200.

(Distribution destination acquisition process)
The distribution destination acquisition unit 202a refers to the group master 206b to acquire a distribution destination associated with the distribution destination group (distribution destination group name) and the environment identification data (environment name) transmitted by the first transmission unit 102e. Specifically, the distribution destination acquisition unit 202a acquires “100, 200, 300” for the combination of Group 1 and Environment 1, and “100” for the combination of Group 2 and Environment 1. Acquires "Company No. 300 company" and "Company No. 100" for the combination of Group 2 and Environment 2.

The information acquired up to this point can be summarized as a combination of distribution information, environment name, company number and execution order:
Delivery information 1 Environment 1 100th company Execution order 2
Delivery information 1 Environment 1 200th company Execution order 2
Delivery information 1 Environment 1 300th company Execution order 2
Delivery information 2 Environment 1 100th company Execution order 1
Delivery information 2 Environment 1 300th company Execution order 1
Delivery information 2 Environment 2 100th company Execution order 1
Delivery information 3 Environment 1 100th company Execution order 3
Delivery information 3 Environment 1 200th company Execution order 3
Delivery information 3 Environment 1 300th company Execution order 3
The above-mentioned nine lines of information correspond to the information described in the “definition creation screen” of FIG. 25, but in FIG. 25, the distribution information is written as a master name.

(Second transmission process)
First, the second transmitting unit 202b rearranges the information of the above-mentioned nine lines in ascending order of environment names, as shown in "1. Re-sort in order of environment DB" in FIG.

  Next, as shown in “2. Re-sort in the order of company (distribution destination DB)” in FIG. 25, the second transmitting unit 202 b causes the company number to be re-sorted in the order of “9. Sort by youngest.

  Next, the second transmission unit 202b rearranges the information of the nine rows sorted in ascending order of company number, in ascending order of execution order, as shown in "3. Reorder in execution order" in FIG.

  Next, the second transmission unit 202b arranges the information of the nine lines sorted in ascending order of execution into one block, in which the combination of the environment name and the company number is the same. Specifically, as shown in “4. Execute transaction by managing chunks for each chunk of execution processing database and execute execution processing” in FIG. 25, a chunk (a chunk (A) and a combination of environment name 1 and company number 100) ), A combination of environment name 1 and company number 200 (set as a mass (B)), a combination of environment name 1 and company number 300 (set as a mass (C)) and a combination of environment name 2 and company number 100 Four chunks (referred to as chunks (D)) are created. This block is a transmission unit of distribution information when the transaction range is a company unit. When the transaction range is the whole unit, the distribution information is transmitted with all the above nine lines as one transmission unit regardless of this block.

  When “whole” is selected in the frame on the right of “transaction management” in the setting screen (the upper screen in FIG. 20) of the distribution definition master 106d, the second transmitting unit 202b transmits the first transmitting unit 102e. Transmission of the transmitted distribution information to the distribution destination acquired by the distribution destination acquisition unit 202a is performed with all distribution destinations (distribution destination company numbers) acquired by the distribution destination acquisition unit 202a as one transmission unit (whole distribution).

  Specifically, the second transmitting unit 202b transmits all of the blocks (A) to (D) of “4. Manage the transaction for each block in the execution processing database and execute the execution process” in FIG. As a unit (transaction unit), transmission processing of distribution information is performed sequentially from the first line of the block (A). Therefore, for example, when an error occurs in the transmission process on the second line of the mass (B), the second transmission unit 202b returns to the first line of the mass (A) and performs the transmission process again.

  On the other hand, the second transmission unit 202b selects “DB unit (company unit)” in the frame on the right of “transaction management” in the setting screen (upper screen in FIG. 20) of the distribution definition master 106d. In this case, the environment identification data (environment name) transmitted by the first transmission unit 102e and transmission destination acquisition unit 202a transmit the distribution information transmitted by the first transmission unit 102e to the distribution destination acquired by the distribution destination acquisition unit 202a. The same combination of the acquired distribution destinations (distribution destination company numbers) is performed as one transmission unit.

  Specifically, the second transmitting unit 202b transmits one of each of chunks (A) to (D) of “4. Manage the transaction for each chunk of the execution processing database and execute the execution processing” in FIG. Transmission information is transmitted as a unit (transaction unit). Under the present circumstances, it is preferable that the 2nd transmission part 202b transmits delivery information in order with a young order of execution also in the same block. Therefore, for example, when an error occurs in the transmission of the second row of the mass (B), the transmission process in the mass (A), (C) and (D) is not affected, and one row of the mass (B) Return to the eye and perform transmission again.

  As described above in the item [4-3-1], according to the delivery management system according to the present embodiment, the person who delivers the delivery information only selects the desired delivery unit, and the desired delivery unit is selected. Delivery can be performed in delivery units.

[4-3-2. Update in desired transaction range]
In this item, update processing in a desired transaction range is described with reference to FIGS.

  First, as shown in (1) of FIG. 22, when the manager of the distribution source (company No. 100) confirms the distribution information and executes the distribution process, the first transmission unit 102e distributes the distribution information. Do. If reference to distribution destination information is permitted, the administrator of the distribution source can also confirm the update of the distribution destination company. The administrator of the distribution destinations (200th, 300th, 400th, 10th and 20th companies) matches the distribution information (distribution source data) with the distribution destination information (distribution source data) and is updated. Check the contents of the

  Subsequently, as shown in (2) of FIG. 22, as a result of the matching, the manager of the distribution destination selects whether to approve or reject the update of the distribution destination information, and returns it to the environment information DB 200. The reason for rejection may be, for example, a reason to avoid updating the already existing code.

(Individual update process)
In the case of individual updating, the individual updating unit 202c2 transmits to the distribution information that the first transmitting unit 102e transmits only the distribution destination information about the distribution destinations acquired by the distribution destination acquiring unit 202a that has approved acceptance of distribution of the distribution information. Update. Specifically, as shown in “(3) reflection processing (DB unit)” in FIG. 23, only three companies, the 200th, 400th, and 10th companies, approved to accept distribution of the distribution information. In this case, the individual updating unit 202c2 updates only the distribution destination information for the three companies to the distribution information transmitted by the first transmitting unit 102e (updating from the work table to the real table). Thus, the individual updating unit 202c2 can reflect the distribution information at the timing when the distribution information is approved by the distribution destination.

(Batch update process)
On the other hand, in the case of batch update, Mr. A who is the manager of the distribution source refers to the distribution destination information as shown in “(3) Confirmation of approval status (in the case of batch reflection processing)” in FIG. If it is not permitted, only the approval status as a whole can be confirmed (that is, only the information of MA1 in FIG. 23 can be confirmed), but if reference to the delivery destination information is permitted, companywide The approval status can be confirmed (ie, the information of MA2 and MA3 in FIG. 23 can be confirmed). Mr. B and Mr. C who are administrators of the environmental information DB 200 confirm the rejection reasons of the company belonging to each environmental information DB 200 (that is, Mr. B can confirm the information of MA 2 and C can confirm the information of MA 3 And the overall approval status can be confirmed. Mr. D. Mr. H who is the manager of the business DB can confirm the entire approval status.

  When all the distribution destinations acquired by the distribution destination acquiring unit 202a approve the acceptance of distribution of the distribution information, the batch updating unit 202c1 transmits the distribution destination information for all the distribution destinations by the first transmitting unit 102e. Update to delivery information. Specifically, as shown in “(6) reflection processing (collective)” in FIG. 24, all of the 200th, 300th, 400th, 10th and 20th companies distribute the distribution information. When the acceptance is accepted, the collective updating unit 202c1 updates the distribution destination information on all the companies to the distribution information transmitted by the first transmitting unit 102e (updating from the work table to the real table). Thus, the batch update unit 202c1 updates the work table to the real table at the timing when the distribution information is approved by all the distribution destinations. The scope of the transaction at the time of updating can be selected as “entire unit” or “company unit”.

[4-3-3. Summary]
The points in the above [4-3-1] to [4-3-2] are shown in the following (1) to (3).
(1) At the definition stage of distribution, it is sufficient to set only the transaction unit or the company unit.
(2) It is possible to automatically determine and execute the order and transaction unit of an appropriate transaction from the distribution target group and the distribution destination company information at the timing of executing distribution.
(3) When approval is given by the delivery destination, the unit for updating the delivery destination information and the transaction unit for delivering the delivery information can be separately set. That is, when the update unit is for each company, it is possible to update the distribution destination company that has approved the distribution information, and the transaction unit for distributing the distribution information is also for each company. On the other hand, if the update unit is the whole unit, it can not be updated until all distribution destination companies approve the distribution information, but the transaction unit for distributing the distribution information is “whole unit” and “company Both units can be selected.

[4-4. Data Matching and Update Control]
In this item, data matching and update control will be described.

[4-4-1. Data match]
In this item, data matching will be described with reference to FIGS. The data configuration of the item dictionary master 206d is as shown in FIG. 30, the data configuration of the distribution information is as shown in the distribution source table of FIG. 30, and the data configuration of the distribution destination information is of the distribution destination of FIG. Assume that it is as shown in the table.

(Key item acquisition process)
The key item acquisition unit 202e refers to the item dictionary master 206d and acquires an item having key item information (key), which is associated with designated acquisition information (department table), as a key item. Specifically, referring to the item dictionary master 206d of FIG. 30, the item names associated with the table name "department table" are three items of "department CD", "reference date" and "department abbreviated name". Then, among the three items, the items having the item type “key” are the two items “department CD” and the “reference date”, so the two items become the key items.

(Record acquisition process)
The record acquisition unit 202 f refers to the distribution destination data and the distribution source data to acquire a distribution destination record and a distribution source record associated with the designated acquisition information (department table). Specifically, the three distribution destination records shown in the distribution destination table of FIG. 30 and the five distribution source records shown in the distribution source table of FIG. It can be said. Therefore, the record acquisition unit 202f acquires the three distribution destination records and the five distribution source records.

(Determination process)
The determination unit 202g determines whether the specific information about the key item acquired by the key item acquisition unit 202e is the same or not between the distribution destination record and the distribution source record acquired by the record acquisition unit 202f. (In other words, the distribution destination data and the distribution source data are matched based on the key item acquired in the (key item acquisition processing)). Specifically, among the three distribution destination records of FIG. 30 and the five distribution source records of FIG. 30, the records having the same key items “department CD” and “reference date” are indicated by hatching in FIG. As it is a record, it can be said that specific information about the key item is the same for the four records. On the other hand, regarding the records other than the four records (the delivery source record with department CD 001, the delivery source record with department code 004, the delivery source record with department CD 005 and the delivery destination record with department CD 007) It can be said that specific information about key items is not the same.

(Update process)
The update unit 202c updates the distribution destination information (the table of the distribution destination in FIG. 30) based on the result of the determination unit 202g. The types of update are roughly classified into the addition, modification, deletion, and total substitution described below (in other words, matching is performed based on the key item acquired in the above (key item acquisition processing), and addition is performed. , At least one process of correction and deletion).

(Additional processing)
If the adding unit 202c3 determines that the above is not the same as a result of the determination by the determining unit 202g, and there is a record included in the distribution source data but not included in the distribution destination data, the adding unit 202c3 is included A delivery source record corresponding to a record is added to the delivery destination data. Specifically, records where the specific information about the key item is not the same (in FIG. 30, the delivery source record with department CD 001, delivery source record with department code 004, delivery source record with department CD 005, and department CD Among the delivery destination records of 007), delivery source records that are included in the delivery source table but delivery source records for which the department CD is 001, delivery source records for which the department code is 004, and departments are not included The CD is three records of the delivery source record of 005. Therefore, the adding unit 202c3 adds the three records to the distribution destination table.

(Correction process)
When there is a record that is the same as a result of the determination by the determination unit 202g, but the specific information of the items other than the key item is different between the distribution source record and the distribution destination record, as a result of the determination by the determination unit 202c And correcting the specific information of the distribution destination record into the specific information of the distribution source record. Specifically, among the records (four records indicated by hatching in FIG. 30) in which the specific information about the key item is the same, in the delivery source record whose department CD is 002, the establishment CD and the address are respectively “002 In the distribution destination record with a department CD of 002, it is assumed that the establishment CD and the address are “001” and “Chuo-ku, Tokyo”, respectively, while “D” and “Chiyoda-ku Tokyo”. In this case, the correction unit 202c4 corrects “001” and “Tokyo Chuo Ward” of the distribution destination record of the department CD 002 to “002” and “Chiyoda ward” of the distribution source record of the department CD 002. Do.

(Delete process)
As a result of the determination by the determination unit 202g, if the deletion unit 202c5 does not have the same result and there is a record that is not included in the distribution source data but is included in the distribution destination data, the deletion unit 202c5 is included A delivery destination record corresponding to a record is deleted from the delivery destination data. Specifically, records where the specific information about the key item is not the same (in FIG. 30, the delivery source record with department CD 001, delivery source record with department code 004, delivery source record with department CD 005, and department CD Among the distribution destination records of “007”, it is a distribution destination record of the department CD “007” which is not included in the distribution source table but is included in the distribution destination table. Therefore, the deletion unit 202c5 deletes the record from the distribution destination table.

Note that, by using the item dictionary master 206d, the operator can dynamically show the results when the addition processing, the correction processing, and the deletion processing described above are performed, as shown in (1) to (4) below. You can refer to (in advance).
(1) If all of “Add”, “Modify” and “Delete” are selected in “Update method” on the match confirmation screen shown in FIG. 31, all of the add process, fix process and delete process are performed The results can be referenced in advance in a list. In FIG. 31, a record without hatching is a record to be added, a record with hatching of dots is a record to be corrected, and a record with hatching of oblique lines is a record to be deleted. If the "detail" button is selected, it is possible to confirm the details of the record to be updated.
(2) As shown in the upper part of FIG. 32, if “Add” is selected in “Update method” on the match confirmation screen, records (all column information including key information) to which the delivery source company is added are Is displayed.
(3) As shown in the middle of FIG. 32, if “Modify” is selected in “Update method” on the match confirmation screen, the pre-delivery and post-delivery column information is displayed side by side, and the difference is hatched Records are displayed in status.
(4) As shown in the lower part of FIG. 32, if “Delete” is selected in “Update method” on the match confirmation screen, records (all column information including key information) to be deleted of the delivery destination company are Is displayed.

  The updating unit 202c may perform the three processes of the adding process, the correcting process, and the deleting process described above at the same time (in this case, it is the same process as the entire replacement process described below). Or two arbitrary processes may be performed. As an example of two processes in any combination, for example, when the delivery destination company wants only the latest data of the delivery source company while leaving its own data unchanged, the additional process and the correction process are performed. .

(All replacement process)
The total replacement unit 202c6 includes all the distribution destination records (three distribution destination records in FIG. 30) included in the distribution destination data, the distribution source records (five distribution source records in FIG. 30) included in the distribution source data. Replace with).

  As described above in the item [4-4-1], according to the delivery management system according to the present embodiment, the delivery information of the delivery source and the delivery destination information of the delivery destination are compared with each other to obtain the delivery information. Flexible update of destination information is possible.

[4-4-2. Update control]
In this item, update control will be described using FIG. 28 and FIG.

(Update control process)
The update control unit 202d allows only the update selected by the distribution source among the addition unit 202c3, the correction unit 202c4, the deletion unit 202c5, and the total replacement unit 202c6. Specifically, as shown in “setting of distribution method (non-approval mode)” in FIG. 28, the distribution source administrator (manager of company number 100) who is the administrator of the relay DB (environment DB) distributes Select the update method for each destination company. For example, since "addition / update (modification)" is selected for the 200th company, only the adding unit 202c3 and the modifying unit 202c4 can update the 200th company (that is, the 200th company). (For delivery, only the addition of the delivery source record or the correction of the delivery destination record is made).

  The update control unit 202d may perform only the update by the unit selected by the distribution destination among the addition unit 202c3, the correction unit 202c4, the deletion unit 202c5, and the total replacement unit 202c6. Specifically, as shown in “setting of distribution method (with approval)” in FIG. 28, each distribution destination administrator who is a manager of the relay DB (environment DB) selects the update method. Then, as shown in FIG. 29, distribution of distribution information to each distribution destination is performed based on the selected update method. As shown in FIG. 29, for the company No. 200, since the update method is "addition / update (modification)", the adding unit 202c3 and the correcting unit 202c4 perform existence check from the key information of the item dictionary master 206d, Each performs additional processing and update processing (correction processing). Further, as shown in FIG. 29, for the 300th company, since the update method is "addition", the addition unit 202c3 performs existence check from the key information of the item dictionary master 206d, and performs addition processing. Then, as shown in FIG. 29, for the 400th company, since the update method is “all replacement”, the all replacement unit 202c6 adds the distribution source data after deleting all the data of the distribution destination.

[4-4-3. Summary]
The points in the above [4-4-1] to [4-4-2] are shown in the following (1) to (4).
(1) By managing the item information of the distribution target table, the distribution source data and the distribution destination data are matched, and the difference is made to be understood.
(2) Acceptance side of distribution information by holding the information of distribution destination information update control method (addition only, addition / update (modification) and all deletion replacement) in distribution destination environment DB unit or distribution destination company unit We made it possible to change the contents of delivery by the policy of.
(3) Based on the update control method, the distribution source administrator and the distribution destination administrator share the distribution content in advance, so that the distribution destination administrator can reflect the updated content after approval.
(4) As shown in FIG. 33, the risk of misdelivery of the master 400 can be eliminated by comparing the master 400 to be delivered with the current master information 500 of the delivery destination.

[4-5. Other Embodiments]
As another embodiment, the contents of [4-1] to [4-4] described above may be arbitrarily combined and used. As an example, when performing distribution processing with security secured, when it is desired to distribute only a part of distribution information, the contents of [4-1] and [4-2] are combined and used. do it. In addition, as another example, when performing a grouping distribution process with security secured, if you want to match the distribution source data to be distributed and the distribution destination data for each of the grouped distribution destinations, [4 The contents of -1] and [4-4] may be used in combination.

[5. Other embodiments]
The present invention may be practiced in various different embodiments within the scope of the technical idea described in the claims in addition to the embodiments described above.

  For example, among the processes described in the embodiment, all or part of the process described as being automatically performed may be manually performed, or all the processes described as being manually performed. Alternatively, some of them can be performed automatically by known methods.

  In addition, information including processing procedures, control procedures, specific names, registered data of each processing, parameters such as search conditions, screen examples, and database configurations shown in the present specification and the drawings are described unless otherwise specified. Can be changed arbitrarily.

  Further, with regard to the main company information processing apparatus 100, the subsidiary information processing apparatus 200, and the relay apparatus 300, each component in the drawing is functionally conceptual, and does not necessarily have to be physically configured as illustrated.

  For example, with regard to the processing functions of the main company information processing apparatus 100, the subsidiary information processing apparatus 200, and the relay apparatus 300, in particular each processing function performed by the control unit, all or any part thereof It may be realized by a program that is interpreted and executed, or may be realized as wired logic hardware. The program is stored in a non-temporary computer-readable recording medium including programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment, and, if necessary, main company information It is mechanically read by the processing device 100, the subsidiary information processing device 200 and the relay device 300. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). The computer program is executed by being loaded into the RAM, and cooperates with the CPU to configure the control unit.

  Further, this computer program may be stored in an application program server connected to the main company information processing apparatus 100, the subsidiary information processing apparatus 200 and the relay apparatus 300 via an arbitrary network, as needed. It is also possible to download all or part of it.

  Further, the program for executing the processing described in the present embodiment may be stored in a non-temporary computer readable recording medium, or may be configured as a program product. Here, the "recording medium" means a memory card, a universal serial bus (USB) memory, a secure digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an erasable programmable read only memory (EPROM), and an EEPROM (registration). Trademarks (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Blu-ray (registered trademark) Disc etc. Any "portable physical media It is intended to include.

  The “program” is a data processing method described in any language or description method, and may be in any format such as source code or binary code. Note that the “program” is not necessarily limited to one that is configured in a single way, and achieves its function in cooperation with a separate program represented by a plurality of modules or libraries or a separate program represented by the OS. Including things. In addition, as a specific configuration and reading procedure for reading the recording medium in each device shown in the embodiment, an installation procedure after reading, and the like, a known configuration and procedure can be used.

  The various databases and the like stored in the storage unit are storage devices such as RAM, memory devices such as ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, etc. Stores programs, tables, databases, files for web pages, etc.

  In addition, the main company information processing apparatus 100, the subsidiary information processing apparatus 200, and the relay apparatus 300 may be configured as an information processing apparatus such as a known personal computer or a workstation, or any peripheral device may be connected. You may comprise as an information processing apparatus. In addition, the main company information processing apparatus 100, the subsidiary information processing apparatus 200, and the relay apparatus 300 are realized by implementing software (including a program or data, etc.) that causes the apparatuses to realize the processing described in the present embodiment. It is also good.

  Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them may be functionally or physically in any unit in accordance with various additions or according to functional load. It can be distributed and integrated. That is, the embodiments described above may be implemented in any combination, and the embodiments may be implemented selectively.

  The present invention is useful in all industries, but is particularly useful in an industry where there are many companies having a group structure such as a parent company-subsidiary.

100 major company information processing device 102 control unit
102a Acquisition information acquisition part
102b Distribution information acquisition unit
102c Environment identification data acquisition unit
102d First connection acquisition unit
102e first transmission unit 104 communication interface unit 106 storage unit
106a Connection Information Master
106b Group master
106c distribution target master
106d distribution definition master 108 input / output interface unit 112 input device 114 output device 200 subsidiary information processing device 202 control unit
202a Delivery destination acquisition unit
202b Second transmitter
202c update section
202c1 Batch update unit
202c2 Individual update unit
202c3 additional part
202c4 Modification
202c5 deletion part
202c6 all substitution part
202d update control unit
202e Key item acquisition unit
202f Record acquisition part
202 g determination unit 204 communication interface unit 206 storage unit
206a Connection Information Master
206b Group master
206c Delivery Target Master
206 d Item dictionary master 208 Input / output interface unit 212 Input device 214 Output device 300 Relay device 302 Control unit
302a Third Connection Acquisition Unit
302b Third transmission unit 304 Communication interface unit 306 Storage unit
306 a connection information master 308 input / output interface unit 312 input device 314 output device 400 main company business DB
406 Distribution Source Data 500 Subsidiary Business DB
506 Destination data 600, 700, 800, 900 network

Claims (5)

A distribution information acquisition apparatus including a control unit and a storage unit for acquiring distribution information,
The storage unit
A distribution definition master including an acquisition information used to acquire the distribution information, an extraction condition used to narrow down the distribution information, and a distribution definition for specifying a combination of the acquisition information and the extraction condition is stored Yes,
The control unit
Acquisition information acquiring means for acquiring the acquisition information and the extraction condition associated with the designated distribution definition with reference to the distribution definition master;
Distribution information acquisition means for acquiring the distribution information that is associated with the acquisition information acquired by the acquisition information acquisition means and that matches the extraction condition acquired by the acquisition information acquisition means;
To provide
A distribution information acquisition device characterized by The extraction condition is data of a character string format,
The delivery information acquisition apparatus according to claim 1, characterized in that The delivery information acquisition means performs the acquisition using at least one of a MID function and a LEFT function.
The delivery information acquisition apparatus according to claim 1 or 2, characterized in that A distribution information acquisition method for acquiring distribution information, which is executed by an information processing apparatus including a control unit and a storage unit, the method comprising:
The storage unit
A distribution definition master including an acquisition information used to acquire the distribution information, an extraction condition used to narrow down the distribution information, and a distribution definition for specifying a combination of the acquisition information and the extraction condition is stored Yes,
Executed by the controller
An acquisition step of acquiring the information for acquisition associated with the specified distribution definition and the extraction condition with reference to the distribution definition master;
A distribution information acquisition step for acquiring the distribution information that is associated with the acquisition information acquired in the acquisition information acquisition step and that matches the extraction condition acquired in the acquisition information acquisition step;
Including
Distribution information acquisition method characterized by A distribution information acquisition program for acquiring distribution information, for causing an information processing apparatus including a control unit and a storage unit to execute the program.
The storage unit
A distribution definition master including an acquisition information used to acquire the distribution information, an extraction condition used to narrow down the distribution information, and a distribution definition for specifying a combination of the acquisition information and the extraction condition is stored Yes,
For the control unit to execute
An acquisition step of acquiring the information for acquisition associated with the specified distribution definition and the extraction condition with reference to the distribution definition master;
A distribution information acquisition step for acquiring the distribution information that is associated with the acquisition information acquired in the acquisition information acquisition step and that matches the extraction condition acquired in the acquisition information acquisition step;
Including
Distribution information acquisition program characterized by.

Images