Database Schema Management Method for Creating Distributed Relations in Exchanges

摘要

The present invention manages the schema of the exchanger system database so that the generation of the distributed relation required by the query word during the operation of the system can be performed on-line, thereby facilitating the user's function development, shortening the functioning system application time, The purpose of this system is to enable continuous service of the system regardless.;When a request for generation of a distributed relation is issued in the database query language, the schema manager of each processor related to the data change is asked whether it is possible to allocate the memory according to the data change, and when a response message is received, , And the schema manager of each processor generates a hot schema for the transmitted information and creates a distributed table. If all of the processes are successful, the backup is performed on the disk according to the contents of the log during the schema change. If one of the processors fails to change the schema, the rest of the processors refer to the log contents to recover the schema and terminate the process .