Integration of computer systems with heterogeneous data bases

[Detailed Description of the Invention]

The present invention relates to the art which unifies typically the computer systems developed independently in which a large number which need to share some common data elements generally became independent. Especially the present invention relates to the computer systems of a large number which have a database of a different kind, and the art which unifies the computer systems which have a database with which form and structure generally differ from others mutually if it puts in another way, but the contents do not necessarily differ. Integration of computer systems means that a system comrade can communicate so that the change may be told to other computer systems which use the data, when a certain system generates or updates a data value. PRIOR ART The problem which unifies much computer systems is arising in various fields. The one typical example is a field of manufacture. The design (CAD) by computer support which is help when creating a manufacture drawing directly from a designer's command, When Then also develops a product before reaching the manufacture (CAM) and the design phase by the computer support for controlling a machine tool and a robot, much computer systems are developed to the engineering (CAE) by the computer support which is help. These days, the system for the manufacture resource plannings (MRP) for managing the flow of the product for every material or process through a manufacturing process is also developed. Also in the same manufacture plant, there are computer systems the separate total which needs to share other computers and data of each other, and for management. Typically, each of such a system is uniquely developed using the separate hardware and software which often come to hand from a different Noodle supplier for every system. Although it is easily clear that a manufacturing process is further improved when processing all these functions by the unified single system, When almost all the owners, administrator, and operator of a manufacture factory understand unwilling to discard each system developed as an object for a function like CAD, CAM, CAE, and MRP, they are at It was and the time when. Although the necessity for integration is generally accepted, Although the computer architecture tends to face to a distributing system and a hardware processor and the database relevant to it are arranged in such a system in a separate physical position, it operates as a system single [ a certain grade ]. This tendency has suggested that it can work as an object for work which unified the factory, without unifying to the single machine which has a single database which has developed specially all the functions supported by computer and which was programmed specially. The fundamental problem in automation of a factory and a majority of other applications is sharing data. Although the database relevant to the individual function by support of a computer has some common data elements, there is no useful art which shares common data. When coercion is exerted so that all the databases may use a single organization mechanism and a common record format to common data, communication between databases becomes easy clearly. This technique is used for almost all the solution proposed to the problem of integration. For example, Proc.1983 Natl.Computer In the paper it is [ "the impact:distribution database applications (IMPACT:Adistributed database application)" published on the 203 - 217th page of Conf., such as Mr. Alan Norman (Alan Norman), ] entitled, A distributed database system which maintains the facsimile copy of a database in a separate position is explained. Updating made to the database of a certain position is transmitted to another position. However, the same database mechanism as many positions is used. A system will be a "homogeneous" system if it puts in another way. It is almost satisfactory for distributing update information in many databases and attaining integration of a desired grade. In using the distributed data system which has many copies of a database as known by the designer of some of an integrative system, there are some advantages. For example, Ms. James Martin (James Martin) published in the plenty Isu hole ink (Prentice-Hall Inc.) in the Inguri Uzdcliffe of 07632 New Jersey "the design and art (Design) for distributed data processing and Strategy for Distributed Data General explanation of a distributed data system and various composition of the copy database are stated to Chapter 19 of the literature it is [ Processing ] entitled. The trial of the first stage about integration of many computers, The Belle Laboratories record in June, 1976 (Bell) Mr. James Tay Frisch (James T.Fritsch) published on the 163 - 169th page of Laboratories Recoed "the system for plant operations (A System forPlant) It is stated to the literature it is [ Operations" ] entitled. Operation of much circumference computer systems is controlled by this system using the central computer designed specially. For example, when a new order is received by order processing computer, this is connected to a central computer and a central computer measures adjustment of operation of the following Every by communicating with another computer in various stages which process an order. A central computer updates the order by which processing was recorded on other processing computers along with Advance. The multi-computer systems which must communicate with many computers are stated to the above-mentioned literature. However, the problem of a different-species database is not taken up but the database is designed to suit completely mutually clearly. It will be North Holland Publishing in 1982. Company Terry Landar published on the 153 - 184th page of "the distributed database (Distributed Date Bases)" published under an editor called h Jaye Shneider (H. J.Schneiper) (Terry) The database of only a question is explained to the paper it is [ Mr. Lander's "a multi-base outline (An Overview of Multibase)" ] entitled. A user can access a multi-base by using a single database mechanism and a single query language at a different Noodle database. A multi-base performs all the required transactions to a user, and achieves the user interface of only the question logically integrated to the environment of many databases which is not integrated physically. A multi-base is not a thing relevant to maintaining the consistency between databases, and relates to forming only the user interface for questioning a database. Although the problem of integration and its solution mainly explain the manufacture system of computer integration here, it will be understood that the same view as other uses accompanied by [ when ] Distributed database is applicable with the seat reservation system of an airplane and the system for banks. It depends in relation to this and a general problem is unifying many micro computers very much and accessing many different-species databases with a question. In many cases, it is requested that a micro computer can access only reading for the object of a question at various databases. What has very difficult unifying a micro computer with a large-sized mainframe computer except for the case of comparatively easy composition with the different-species characteristic of a database till the present, and intermediary To have. Therefore, it is also requested that the problem relevant to this is solved. The problem which an invention tends to solve It is clear from the above explanation that the art which unifies the computer systems of a large number which have a database of a different kind is still needed. Ideally, the database of a different kind must be quickly updated, in order to maintain the consistency of community or common data, and it must update the completeness of a database, without having a bad influence. If the solution of this problem is not what was suitable ideal to unify the micro computer which has a function of only reading to the big system of a different-species database, it will not become. The present invention is turned to these objects. The present invention provides the system which unifies the different Noodle host computer of a large number which have a different-species database by the control copy of common data so that it may be maintained by the state where the same data item in a database was mutually in agreement. (On explanation, when the same data item as two or more databases appears, these items are called "copy data" or "common data".) Although the principle of the present invention is applicable to almost all the distributed data system, The present invention is most suitable for a field like the factory automation system which does not need to update a database in real time. It is not necessary to copy this change immediately in other databases, and in such a field, when a common data item is changed in one database, even if it copies in several seconds, several minutes, or several hours, it does not usually have harmful influence. If it generally states briefly, it is a device of the present invention, The data conversion means changed in order to receive from one of the local databases of a host computer and to memorize a I got it. data item to other things of a local database, The communication network which connects a host computer system or a database with the above-mentioned data conversion means, The updating management tool combined with each host computer system is provided, and it is this updating management tool, While transmitting the value of change made by this host computer to the common data contained in the database of the host computer combined with it to the above-mentioned data conversion means through the above-mentioned communication network, Change of the changed database is received from a data conversion means. From database organization and a record format when it is received from one database in change of a database as for the above-mentioned data conversion means, It changes and ranks second to each database organization and a record format of the local database of some other host computers, Changed change is transmitted to these databases, and the consistency of a separate local database is secured, without this imposing specific database organization or a record format on any database. At the example for description of the present invention, it is the above-mentioned data conversion means, The dictionary module for memorizing database organization and a record format to each database which has common data, The database update transaction from computer systems was received, and it has the distributed module which begins to transmit the copy of updating to other databases which carry out shared access of the data updated by performing conversion required for updating. The data conversion means is provided also with the permission module which compares the possession relation of each data item updated so that only one owner of the item can start updating. The data conversion means is provided also with the communication module for passing through the above-mentioned communication network, and transmitting and receiving data. The data conversion means is provided also with the return module for saving important data and returning it when a system error or failure arises. The renewal management tool of data combined with each computer systems can take many various forms based on the character of the application program which operates with computer systems. In one composition, a data server intervenes between an application program and the database management system relevant to it so that all the database accesses made by the application program may be monitored. A data server detects updating made to common data, and in order to transmit these to a data conversion means through a communication network later, it saves it to a deferment operation file. In another solution, a data server receives the right of control from an application program before each database access or to the back. Updating to common data is detected also in this case, and it is put in by the deferment operation file. In the 3rd mode of this same general solution, it is connected to a database management system and a data server detects updating relevant to common data effectively. In these three cases, there is [ no ] a comparatively easy interface with the database management system relevant to an application program or it, and an application program almost or completely needs change for them. In some existing uses, database access is recorded on the audit file already in routine, therefore a data server chooses the transaction relevant to renewal of common data, and should just transmit this to a deferment operation file. The arbitrary additional features of the present invention are in the question processor provided with the central computer and the database. The database of a question processor memorizes the selected data subset in the local database of all the host computers. A question processor receives a question (namely, data request) from a host computer through a communication network, searches the data demanded from the database query, and transmits this to the host computer which has emitted the demand. A question can also be required via a communication network with display Turmill or a micro computer which is not a portion of 1 set which did not maintain the database of itself but was described above by extension of computer systems integrated. In order to maintain the database of a question processor in the state of agreeing with the correspondence data of various local databases, it is a data conversion means, Data update information is transmitted to a question processor the same with transmitting renewal of copy data to either of the local databases of a host computer. It is clear to the field of a distributed computer system from the above explanation the present invention's to bring about remarkable progress. In particular, in the present invention, renewal of common data is changed and it distributes. Therefore, art of sharing data conveniently among many different-species databases is provided. Other objects and effects of the present invention will become clear from detailed explanation of the following which referred to the accompanying drawing. EXAMPLE The present invention relates to the system which the host computer of a large number which have a different-species database is unified, and the same data item in a database is mutually in agreement, and is maintained. In this explanation, the minimum item that the data in a database can access individually is called a "data item", a "data entity", a "data element", or a "data tribute." Since the local database of various host computers has the different Noodle record format for a different Noodle organization mechanism or structure, and storage of data, it is called "different species." Since various databases can contain the same data item as two or more databases, there is partial copy nature or redundancy. For example, the data item which specifies the physical characteristic of a certain parts is contained in a CAD database, a CAM database, and a MRP database. Such a data item contained in two or more databases calls "copy data" or "common data." Integration of these various databases that are the gists of the present invention means making it mutually in agreement [ a common data item ] to two or more databases, namely, making it a common data item have the same data value. When a host computer updates the value of the data item in the local database or such integration adds a new data item to the local database, The change needs to be copied in the local database of all the host computers of the others containing the same data item. For example, when a CAD system changes the size of parts, the memory value of the part size contained in CAM and a MRP database must be changed similarly (namely, copy). a desirable example is described in detail below -- as -- each -- the problem of integration is simplified when updating the data item to a common data item specifies the "owner" showing being the permitted only local database. Although other local databases containing the same data item receive the data value updated when an "owner" updated the data item, the database besides these cannot start updating. This view that each data item has single "owner" is logical in almost all uses. If explanation is returned to a previous example, CAM or a MRP system is logical at the point that do not mean starting change of a part size and a CAD system serves as an "owner" of part size data for exclusive use. Another solution is enabling it to move the ownership of a data item from a certain local database to another local database, and preventing two or more databases from Natural owning a data item at once. According to the present invention, updating to common data is sent to a central position, and in order to distribute to other databases, it is copied with a conversion form. This is generally shown in Drawing 1, two host systems 10 are connected to common local area network 12, and host system 10' in the position which the 3rd left is connected to the same network via communication link 14. In fact, the number of the host systems by which interconnection is carried out turns into a large number rather than three systems shown in Drawing 1. Host system 10 and 10' are independent computer systems which have the separate local database shown by 16 and 16'. It has some data elements it was indicated to be roughly [ each local database ] at 18 and 18' although each of these local databases was separately accessed and controlled by the host system in each. These are common to a local database besides one or more (they are not necessarily all) (that is, copied to these). Such data is called "common data" 18. Generally, a local database has one of the databases of other, some common data items, and another database and a common different Noodle data item. In the device of the present invention, the computer (and software) system called integrated engine 20 is connected to host computer 10 and 10' via communication network 12 (preferably local area network). Integrated engine 20 has four main elements, i.e., data conversion machine 22, information question processor 24, disk storage module 26, and control console 28. Disk storage module 26 is accessed by data conversion machine 22 and question processor 24. Data conversion machine 22, question processor 24, and control console 28 are connected mutually loosely or closely by the another communication network or bus shown by 30. It performs with updating converter 22 and the main function of integrated engine 20 is the converter, Renewal of common data is received from a local database, and the data which changed and changed this data into the suitable format for other databases containing the same data item is transmitted to other databases. Each of host computer system 10 and 10' is provided with updating Management Department 32 and 32'. This Management Department contains updating capture module 31 and updating receiving module 33. When required with data conversion machine 22, updating capture module 31 "captures" each updating made to a common data item in host computer system 10, and transmits this to data conversion machine 22. [ monitor namely, ] Confidence receiving module 33 receives an updating transaction from data conversion machine 22, and updates the database of a host computer. If an operation sequence is described briefly, when the owner of a data tribute will update namely, change that attribute, it records, in order that updating capture module 31 may capture this information and may transmit to data conversion machine 22 later. After that, data conversion machine 22 which controls distribution of all the renewal of data polls updating capture module 31, and receives renewal of data. From the database mechanism in which this was received from the "owner" of data in the updating as for data conversion machine 22, and a format, It changes into one or more the separate mechanisms and formats which are memorized by one or more of the host computers of other, and transmits this changed copy object of renewal of data to other host computers. In the host computer which receives such changed updating, The updating receiving module 33 accesses the local database directly or indirectly, and a suitable data tribute is updated so that it may be in agreement with the data tribute in an owner's database. An information question processor fills various functions. This processor maintains the database query which comprises the predetermined subset of common data to disk store 26. The data item of a database query is updated by data conversion machine 22 like a Oh case in database in which the database query of a host computer is another. A database query is used only in order to satisfy the question (only reading) of the data made by various micro computers 34 connected to local area network 12. Or a question may be performed again from terminal 35 connected to one of the host computers 10. In some uses, many micro computers are separately connected very much to network 12 via a cluster control machine (not shown), Each connected micro computer can access only reading to many databases (the part is copied to the database query). In addition to the fundamental question function, information question processor 24 is arbitrarily specified that it backs up data conversion machine 22. This has data conversion machine 22 and the same hardware structure preferably. As for question processor 24, when the serious defect for data conversion machine 22 arises, it is preferred that it can play the role of a data conversion machine until both systems fully come to function again. Drawing 2 shows three separate composition of updating capture module 31 which has three main elements, data server 40, deferment operation file 42, and transaction management device 44. the --a [ 2 ] figure shows the 1st composition in which data server 40 was connected to application program 46 which has related database management system (DBMS) 48 and database 50. In the original state of it which is not changed, application program 46 has accessed the database with the command of DBMS48, and DBMS ranks next and has accessed database 50. In this composition, although data server 40 intervenes between application program 46 and DMBS48, it is a "penetration target", in view of program 46. If it puts in another way, application program 46 will not be changed but a demand will be emitted to the DBMS48, and it is To continue. The filter of these demands is carried out by data server 40 in fact, and the server includes discernment of a common data tribute in this. Therefore, data server 40 can identify any of the update request made by application program 46 are performed to a common data tribute. These identified items "are captured" by data server 40, and are transmitted to deferment operation file 42. Fundamentally, this file is output queuing to the renewal of data by which common data was captured. the -- in another composition shown inb [ 2 ] figure, the application program shown by number 46' is more closely combined with the DBMS48', and, as for this, Then is also good at a part of one software package. Therefore, it is not so practical to insert a data server between an application program and its DBMS. However, application program 46' can be easily changed so that it may interface with data server 40' directly, as illustrated, and thereby, a data server can acquire the right of control behind, before emitting a demand respectively to DBMS48'. The above-mentioned renewal of data into which data server 40' is made to common data like the case of the 1st composition is identified, and the details of these demands are saved to deferment operation file 42. the -- the 3rd composition shown inc [ 2 ] figure is provided with data server 40'' and application program 46''DBMS48'' and database 50''. In a certain case, an application program saves the audit log of all the demands in routine work at DBMS. Data server 40'' supervises only an audit log, and should just identify the transaction relevant to renewal of a common data item. These are saved to a deferment operation file, as described above. When application program 46'' does not generate an audit log, when common data is updated, data server 40'' can detect this by another method. In this method, data server 40'' can access DBMS48'' periodically, and can acquire the present value of all the common data "was owned" by that application program 46''. Subsequently, data server 40'' compares the data value of this group with 1 set of values collected before that. If there is a different value, it will be the value updated by application program 46''. Subsequently, data server 40'' transmits these updated values to updating capture module 31, in order to send to updating converter 22. If put into a transaction by queuing of deferment operation file 42, these transactions will be transmitted by transaction management device 44, when it is periodically required with data conversion machine 22 after that (polled). It will be understood from detailed explanation of computer integrated engine 20 (Drawing 1) shown in Drawing 3 in detail how these transmission is performed. Data conversion machine 22 is provided with six main modules. These are communication module 60, distributed module 62, conversion module 69 of 64 or 1 or more dictionary modules, permission, secret module 66, and recovery module 68. External communication module 60a for communication module 60 to communicate with host computer system 10 through local area network 12, It has internal communication module 60b for communicating with information question processor 24 and control console 28, and operator-machinery interface communication module 60c for communicating with a control console. Operator-machinery interface communication module 60c has respectively correspondence part 60c' and 60c'' in information question processor 24 and control console 28. These modules 60c, 60c', and 60c'', Communicate respectively between a control console and processors 22 and 24 through lines 70 and 72, and a control console performs surveillance and a control facility to two processors, and it enables it to interface with the operator of a control console suitably. As for control console 28, it is preferred to use the system of a display "window" so that the information from much sauce can be displayed simultaneously of surveillance and control for convenience. The main function of console 28 displays Audit log and displays the statistical performance of data conversion machine 22 and question processor 24, The graphical representation of the state of the network where integrated engine 20, host computer system 10, and 10' were connected is carried out, and information is memorized or retrieved to a central database and dictionary support module 64. Internal communication module 60b is connected to internal communication network 76 by line 74 in the "internal" communication level other than the interface communication level of operator-machinery. Internal communication module 60b' and 60b'' to which information question processor 24 and control console 28 correspond are respectively connected to the same network 76 by lines 78 and 80. This composition gives different necessary communication from what was needed for the operator-machinery interface function among three processors 22, 24, and 28. A general communications protocol can be used for communication network 76 used for internal communication. For example, the protocol considered to be desirable now is TCP/IP (a conveyance control protocol / Internet protocol) accepted as a standard for using it for the UNIX (Unix) operating system software which it is [ for a computer ] good and was known. External communication module 60a connects data conversion machine 22 to local area network 12 to which host computer system 10 and 10' were connected. Question processor 24 has external communication module 60a', in order to return the database information required of the computer or terminal of only reading connected to network 12. The purpose of external communication module 60a is to deal with the details of the message transmission between data conversion machine 22 and updating controlling device 32 in each host computer system. The actual communications protocol used is based on the protocol which can be dealt with by host computer system 10 and 10'. When local computer systems do not suit a single communications protocol, the data conversion machine can communicate with the separate subset of a local system via a separate communication network. In a desirable example, external communication module 60a starts communication with one of the local computers 10 by one of three fundamental communication commands, SEND (transmission), RECEIVE (reception), and the AUDIT(s) (audit). Each command is explained in detail below. It is a distributed module when it is ready for distributed module 62 to transmit update information to one of the host computer systems 10, The destination by which the SEND command, the data which accompanies it, and its data were meant is required of external communication module 60a as transmitting to a local computer. (In order to establish communication based on the actual communications protocol used for communicating through network 12 between data conversion machine 22 of desired host computer system 10, and updating controlling device 32) The CONNECT (connection) command can be placed before each command of SEND, RECEIVE, or AUDIT. Once the SEND command is generated from a viewpoint of distributed module 62, An external communication module transmits a message automatically and the distributed module can continue performing other functions. In order that renewal of a transaction may check the Somewhat broken thing of the result in the host computer which is each destination, each host computer has that preferred which returns a state confirmation message, after applying renewal of a transaction (when this is required). It may not necessarily be separately transmitted due to the original SEND command and 1 to 1, and these state confirmation messages may not have Re. Rather, a state confirmation message is accumulated in a host computer system, and the demand of data conversion machine 22 is transmitted as Batches at the time of Oh. The RECEIVE command is a polling command fundamentally. It orders a host computer system chosen so that a data transaction, a state confirmation message, or an audit response (it states below) which was ready for transmission might be transmitted. Since data conversion machine 22 generates overall state information in integrated engine 20, it is required that a general state message should be returned from a host computer. Distributed module 62 can determine whether it is a dirt state confirmation message in a transaction, it is an audit response, or it is a general state response from the contents of the received message. An audit command is an additional check command which can determine whether renewal of the data which branching module 62 asked the database of the host computer, and was already transmitted on the attribute level was performed correctly. It can But using two another solution. In one solution, only the identifier of a data tribute is transmitted with an audit command. A host computer system searches the identified attribute and returns this to data conversion machine 22. As compared with updating to which the searched data tribute is already sent, distributed module 62 can create an exclusion report, when the attribute is not updated correctly. Another solution is transmitting a data tribute identifier and the copy of the updated data tribute. Subsequently, a host computer system returns the message which shows whether it not only searches a data tribute, but the attribute was correctly updated as compared with the updated data which received this with the audit command. The message returned which occurred with the audit command is not transmitted until the RECEIVE command polls a host computer system. Thus, data conversion machine 22 holds the right of control of all the message transmission on network 12 which has connected the computer. Polling of a host computer is performed based on the priority chosen so that a priority might be specified as each host computer system, or is performed one by one based on the demand of the application program in a host computer. Based on the overall demand of a system, polling with the RECEIVE command may have a priority higher than the SEND and AUDIT commands, and does not need to have it. The principal part of data conversion machine 22 which actually changes updating to another database mechanism from a certain database mechanism is with dictionary module 64 and one or more conversion modules 69. Dictionary module 64 includes the information on each common database entity. A name (supposing it is required) with this information other than the name of an entity for every entity, The description information about the node number identifier of each local database containing the entity, directions of a classification of a mechanism, the updating template of each mechanism, an owner's discernment, and an entity is included. This dictionary information is memorizable in the convenient format for accessing via database management device (DBMS) 84. The solution considered to be desirable now is using an extended relation format as an object for dictionaries. The information from dictionary module 64 is used for each conversion module 69, It is reformatting-ization, i.e., change, at composition when that [ one ] of other host computer systems 10 which use the data item memorizes from composition when host computer system 10 which "owns" the data item memorizes renewal of data. It is not necessary to change into omnipotent middle composition, and direct conversion of the data is carried out from an owner's database organization to the database organization of other host computers. Generally, data conversion machine 22 is provided with separate conversion module 69 for every database organization of each set which must change. Or single conversion module 69 can also be designed to change into the selected composition in the 2nd group from the selected composition in the 1st group again, the composition in the 1st group is mutually the same in this case, and the composition in the 2nd group is mutually the same. It is required during an operation that communication module 60 should send updating to the common data which it may have since each of host computer system 10 was polled in series through communication network 12 and the host computer was polled at the end. When the host computer has such updating, updating controlling device 32 of a host computer sends the updating to communication module 60 of a data conversion machine via communication network 12. A communication module memorizes updating to input queuing 82 until it obtains the opportunity for distributed module 62 to process updating. A distributed module obtains the "template" which specifies data as the composition of the database of the information which specifies it is necessary which host computer to receive updating, and the host computer which serves as a partner of transmission for reformatting-ization, i.e., does it change?, how from a dictionary module. Subsequently, as for a distributed module, through and this module perform actual conversion of data composition for all those information to suitable conversion module 69. Subsequently, conversion module 69 memorizes the display changed about renewal of data to output queuing 86, and stands by being transmitted to suitable host computer 10 with external communication module 60a. Preferably, data conversion machine 22 is provided with multitasking computer systems, and each conversion module 69 is an independent asynchronous task module. Execution of each task is controlled by the command file formed of distributed module 62. As for a conversion module, when a task is completed, it is preferred to delete a command file. Especially this multitasking computer configuration is suitable for use of many computer processors. Permission and secret module 66 satisfy two large functions. One of these is comparing renewal of each being emitted from the right owner of the entity updated or an attribute. The another side is performing the required matching check directed by a specific use. For example, it is important to update some database attributes by a specific sequence, or to update two or more attributes simultaneously. Although such a matching check must usually be processed in each host computer system, permission and secret module 66 are additional, and give the secret layer sometimes needed to a certain position. Recovery module 68 achieves a backup function to a data conversion mechanism, and after a host system resumes operation following the interception cycle from a network, it coincides a common database again. When the serious failure for data conversion machine 22 arises, central console 28 is routine surveillance operating, Then also detects this, the operation which switches a data conversion function to question processor 24 is started, and the processor suspends the question processing capability temporarily. A transaction log is maintained in order to hold a database in a certain mechanism. During time to separate a host computer system from data conversion machine 22, updating which was probably transmitted to this separated system from the first is recorded by the log file. After the separated system returns to a line, the log file of an updating transaction is transmitted to this re-connected host system. In order to obtain perfect coincidence, updating which arose in the separated host system separates, and it is recorded by the host computer also on inside, and it must be transmitted when a system is re-connected to data conversion machine 22 after that. Distribution of an updating copy to a host computer is performed by two fundamental direct or indirect methods. these -- the -- the [a / 4 / figure and ] -- it is shown inb [ 4 ] figure. the -- in the direct method shown ina [ 4 ] figure, an updating transaction is directly transmitted to database management system (DBMS) 90 relevant to application program 92 which is operating with the host computer. When transaction management device 44 of a host computer receives updating from data conversion machine 22, it emits one or more suitable demands to DBMS80, and records updating on local database 94 of a host computer directly. indirect updating -- the problem of a synchronization -- when -- It was -- it is used when direct access cannot be performed for a reason of any kind. For example, in a certain use, when specific updating is received, to update other various data entities is needed. the application program of a host computer -- such special environment -- perfect -- a part, an intermediary cage, and this sake -- an updating transaction -- the -- as shown inb [ 4 ] figure, it is sent to an application program. Fundamentally, transaction management device 44 puts a receptacle I got it. transaction into input queuing 96, and processes it by application program 92. Then, it transmits to DBMS90' and updates database 94'. In indirect updating, an updating transaction is formatted with the form of the input item over an application program in data conversion machine 22. EFFECT OF THE INVENTION Probably, it will be clear to the field of the independent integration of computer systems which has a different-species database from the above explanation the present invention's to bring about remarkable progress. In particular, by the present invention, a copy object from which a database update was changed is formed, and these copy objects are distributed in other databases with a format and composition which are used by each database. Therefore, integration of a dispersed different-species database is achieved. In the present invention, a database of common data chosen as a desirable thing to access of only reading is maintained. Therefore, a question function is also achieved. Although the specific example of the present invention was described in detail, probably, it will be easily clear that various change may be made, without deviating from the soul and the range of the present invention. Therefore, the present invention shall be prescribed by only the claim.

[Brief Description of the Drawings]

Drawings 1 are a block diagram showing the desirable example of the present invention device connected to a plurality of locals and remote host computer systems, and Drawing 2, It is Then between the application program of a host computer system, and a transaction management module, The block diagram and Drawing 3 showing the interface of three forms used for communicating with the database of a host system, The detailed block diagram of the present invention as which the data conversion machine was mainly emphasized, and Drawing 4 are block diagrams showing some two another examples of the updating controlling device which receives updating from a data conversion machine. 10 10' ... A host system, 12 ... Local area network, 14 ... A communication link, 16, 16' ... Local database, 18 18' ... A data element, 20 ... An integrated engine, 22 ... Data conversion machine, 24 ... information question processor, 26 ... disk storage module, 28 ... control console, 31 ... an updating capture module, 32, and 32' ... An updating controlling device, 33 ... An updating receiving module, 34 ... Micro computer.