JPH07129444A - Inter-system data base utilizing method - Google Patents

Abstract

PURPOSE:To provide an inter-system data base (DB) utilizing method for constructing the DB peculiar to possible respective systems while including the related DB and for making possible the backup of the DB corresponding to the inter-system transfer only of basic data and the basic data stored in an auxiliary storage device. CONSTITUTION:This method is composed of a system 1, system 2, processor 3, terminal equipment 4, man-machine function 5, data output function 6, data editing function 7, data input function 8, basic data buffer 9, working file buffer 10, system parameter table 11, DB managing information 12 and auxiliary storage device 13.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a basic data that can be shared by a plurality of systems and a DB management system that can construct a database (hereinafter referred to as a DB) specific to the system from the basic data. When there are multiple systems with enormous amounts of data, basic data created by one system is diverted, and a DB unique to each system is constructed including the related DB, and a backup function when the DB is destroyed The present invention relates to a method of using an inter-system DB that can automatically and efficiently build a highly reliable DB when a need arises.

[0002]

2. Description of the Related Art Conventionally, as shown in the specification of Japanese Patent Application No. 4-134735, only one type of DB can be commonly used in the system, so that a plurality of DBs are related to a certain DB. When there are a plurality of DBs, it is necessary to carry out conversation processing as many as the number of DBs associated with each other to transfer data and build a DB. For this reason, it took a lot of time to construct a DB peculiar to the system.

[0003]

[Problems to be Solved by the Invention] In order to shorten the DB creation time, optimize the capacity, and facilitate backup,
Centralized management of the DB and minimization of the number of input data are the most effective. However, when a unique DB is required for each system, the centralized management enables the number of input data and D
Capacity of B inevitably increases. In order to solve this problem, there is a method of developing a DB generation method (usage method) that combines centralized management of the DB and minimizes the number of input data.

It is an object of the present invention to automatically build a system-specific DB including related data with the minimum data (basic data) input in a certain system. The purpose is to provide a DB usage method.

[0005]

According to the present invention, there is a system parameter in which information about which part of the basic data is used and which calculation formula is used to generate data for each system and a related DB. The management information such as what is stored is stored, and at the same time, DB generation parameter information indicating what kind of file is generated is provided, and the basic data input by a certain system is used by a communication line or the like. Data is received every time, and a DB unique to the system can be automatically constructed including the related DB.

[0006]

[Operation] Managing the basic data that allows the DB to be shared by multiple systems, the system parameters for automatically creating the system-specific DB from the basic data, and what the associated data is By dividing it into management information to be stored, it is possible to construct a DB for a plurality of systems by simply inputting data from any one of the plurality of systems, and it is possible to shorten the data creation time.

Further, by automatically enabling the construction of the DB from the basic data, it is possible to easily perform the reconstruction (backup) when the DB in the system is destroyed by maintaining only the basic data. The contents can be updated easily by maintaining the basic data and distributing it to multiple systems.

[0008]

Embodiments of the present invention will be described below with reference to the drawings.

FIG. 1 shows a block diagram of a system according to an embodiment of the present invention. In this embodiment, a system 1 including a terminal device 4 for performing man-machine processing, a processing device 3 for automatically constructing a DB, and an auxiliary storage device 13 for saving / restoring data, and a communication line It is composed of a system 1 and a plurality of systems 2 which are composed of the same devices and the like. Further, although the relation of each function in the processing device 3 is shown, only representative functions for explaining the embodiment of the present invention are mentioned.

As an outline of the processing, first, the man-machine function 5 receives the basic data input from the operator by the terminal device 4, and stores the input basic data in the basic data buffer 9 (buffer in the magnetic disk). Next, the data editing function 7 is activated by the man-machine function 5, and the data editing function 7 stores the basic data stored therein and the system-specific D of the system parameter table 11 created in advance.
The processing file of the processing file buffer 10 (buffer in the magnetic disk) is created based on the B creation information.

Further, the man-machine function 5 receives a data input / output instruction from an operator and activates the data output functions 6 and 8.

The data output function 6 stores the basic data of the basic data buffer 9 existing in its own processing device in the auxiliary storage device 13 or outputs it to the instructed system 2 using the communication line. . The system 2 automatically creates a processing file peculiar to the own system based on the transmitted basic data, and if there is data related to the transmitted data, the system requests the transmission of those data. Go to 1. In system 1,
The data input function 8 receives the transmission request and activates the data editing function 7. Also, the activated data editing function 7
Reads out from the DB management information 12 what DB is associated with the DB just output. Then, the corresponding data is read from the processing file buffer 10, the original basic data is stored in the basic data buffer 9 based on the information of the system parameter table 11,
The data output function 6 is activated. In the data output function 6,
This basic data is output to the system 2. By repeating the process of creating the basic data buffer 9 from the processing file 10 and outputting the data to the system 2 until there is no associated DB, the system 2 includes the processing file specific to the own system including the related data. It will be possible to automatically create.

When the basic data is created by the system 2, the data input function 8 receives the basic data transmitted from the system 2 and stores it in the basic data buffer 9.
The data editing function 7 is activated. The data editing function 7 creates a processing file specific to the system 1 in the processing file buffer 10 based on the basic data in the basic data buffer 9 and the file generation information in the system parameter table 11. Then, if there is a DB related to the DB input this time according to the DB management information 12, the remaining DB output request is issued to the system 2 by activating the data output function 6. This basic data input is repeated until the input of all associated DBs is completed.

Further, the processed file buffer 1 of the system 1
When the processing file in 0 or the basic data in the basic data buffer 9 is destroyed, the basic data saved in the auxiliary storage device 13 is changed by the data input function 8.
The data is read into the basic data buffer 9 and the data editing function 7 is used to recreate the processing file in the processing file buffer 10. Note that the same processed file reorganization is also performed between a plurality of systems by transmitting and receiving only basic data.

Next, FIG. 2 shows an outline of the data flow.
The basic data buffer 9 is a buffer that stores a plurality of basic data 14 for creating a system-specific file, and is a data group that enables DB construction in a plurality of systems. Also, the system parameter table 11 is
File generation management information 16 storing information indicating what kind of processing file needs to be created, basic data index information 17 storing information indicating which basic data is used to create the processing file, and The file generation parameter 18 stores information indicating how to process the basic data and create a system-specific processed file. The processed file buffer 10 stores a plurality of processed files 15 created by the data editing function 7 from the information in the basic data buffer 9 and the system parameter table 11. Further, the DB management information 12 is composed of information indicating what DB is associated with a certain DB.

FIG. 3 shows a related table configuration diagram. The file generation management information 16 is composed of a file generation number 19 indicating how many processed files 15 are generated, and file m (m = 1 to m) information 20 which is index information. The file m (m = 1 to m) information 20 is basic data index information 1 indicating which basic data 14 is used.
Basic data index information index 21 corresponding to 7
And a file generation parameter index 22 associated with a file generation parameter 18 indicating how to generate the processed file 15. The basic data index information 17 is composed of an information number 24 indicating the number of times the basic data 14 is used and basic data position information 25 indicating the used data position. The file generation parameter 18 is composed of calculation formula information 27 indicating a calculation formula for generating the processed file 15, a calculation formula coefficient number 28 indicating the number of coefficients of the calculation formula, and a coefficient 29 of the calculation formula.

FIG. 4 shows the structure of the DB management information 12. D
The B management information 12 is a basic data type 30 for indexing corresponding information from the basic data 14, and a related D
From the index information (O) 31 indicating the number of B and the system parameter index information 32 that is the index information of the system parameter P33 indicating which system parameter is used to calculate the basic data 14 from the processed file m15 by back calculation Composed.

Next, referring to FIG. 5, a processing flow of the data editing function 7, which is particularly important in this embodiment, will be described. The data editing function 7 first sets the system parameter table 11
All the information of the file generation management information 16 is read.
Next, the number of created files 15 in the system is recognized from the number of generated files 19, and the file m (m = 1 to m) information 20 is sequentially viewed to find the corresponding basic data index information index 21 or The file generation parameter index 22 is read. The basic data index information index 21 is the basic data index information 1
7 shows the case number of the basic data position information 23 of No. 7, and from this information, the data editing function 7 indicates the number of pieces of information indicating the basic data 14 of the basic data position information 23 indicating how many basic data are to be taken from where. 24 and basic data position information 25 are read.

File generation parameter index 22
Is the parameter information 26 of the file generation parameter 18.
The data editing function 7 uses this information to calculate the calculation formula information 27 and the calculation formula information 27 indicating the calculation formula of the parameter information 26 for processing the basic data 14 read out. The number of coefficients 28 and the coefficient 29 used in the calculation formula are read out. Then, the data editing function 7 selects the calculation formula indicated by the calculation formula information 27 from a plurality of predetermined calculation formulas, and the coefficient 29 corresponding to the calculation formula coefficient number 28 is selected.
To determine each coefficient in the calculation formula.

Next, the basic data 14 indicated by the basic data position information 25 that has already been read out is read out and processed by the determined calculation formula. This calculation processing result, information number 2
4 is created for the number indicated by 4, and a processing file 15 that is unique to the system is created and stored in the processing file buffer 10.

By the above-mentioned method, the processing files 14 corresponding to the number of generated files 19 are created and stored in the processing file buffer 10.

Finally, a related DB input / output processing flow will be described with reference to FIG. For example, when the information of the basic data buffer 9 created in the system 2 is input in the system 1, the information of the processed file buffer 10 which is the method shown in FIG. 5 is created, and then the basic data type 30 in the DB management information 12 is stored. The information of the basic data buffer 9 input this time is compared, and the information of the matched type is extracted. If there is a plurality of index numbers (O) 31 in the information, it is recognized that the information of the basic data buffer 9 input this time has a plurality of associated DBs. Next, when data is being input at present, the next basic data buffer 9 is output by activating the data output function 6.

Further, when the information of the basic data buffer 9 created by the system 1 is output to the system 2, the information of the basic data buffer 9 to be output is created by activating the data editing function 7 and calculating backward from the processing file 10. The data editing function 7 activates the data output function 6 to output to the system 2.

According to this embodiment, it is possible to easily create a DB unique to a plurality of systems, including associated DBs, based on basic data created by a certain system. Also, the backup of the DB can be facilitated.

[0025]

According to the present embodiment, (1) the DB construction time can be shortened by automatically generating the system-specific DB.

(2) Backup can be facilitated when a DB is destroyed.

(3) By having the basic data, the number of input data can be shortened.

[Brief description of drawings]

FIG. 1 is a block diagram of a system according to the present invention.

FIG. 2 is a flowchart of data centering on the data editing function 7 in the present invention.

FIG. 3 is an explanatory diagram of a relation table according to the present invention.

FIG. 4 is an explanatory diagram of a related table in the present invention.

FIG. 5 is a processing flowchart of main functions in the present invention.

FIG. 6 is a processing flowchart of main functions in the present invention.

[Explanation of symbols]

1 ... System, 2 ... System, 3 ... Processing device, 4 ... Terminal device, 5 ... Man-machine function, 6 ... Data output function, 7 ...
Data editing function, 8 ... Data input function, 9 ... Basic data buffer, 10 ... Processed file buffer, 11 ... System parameter table, 12 ... DB management information, 13 ... Auxiliary storage device.

Claims (3)

[Claims] 1. When there are a plurality of systems each including a terminal device having a man-machine function, communication with other systems, and a device for constructing and managing a database in its own system, a system-specific DB of a processing device is provided. Parameter information for construction is provided, basic data created by a certain system is transferred to each system via a communication line, and a DB peculiar to each system can be constructed including related DBs. At the time of DB destruction, A method for using an inter-system database characterized by easily enabling DB reconstruction unique to each system by transferring only basic data between systems. 2. The data according to claim 1, wherein the basic data is data defining an attribute of each DB configuration data, can be used as a parameter of a calculation formula, and the associated DB is
An inter-system database usage method that can be divided into multiple types based on the characteristics of one key information. 3. A terminal device having a man-machine function, an auxiliary storage device, and a processing device for constructing and managing a DB in its own system are regarded as one system, and they are processed in a plurality of systems connected by a communication line. The system-specific DB construction parameter information is provided in the device, and the basic data created by one system and stored in the auxiliary storage device is transferred to each system through the communication line, and the D-specific
A method for utilizing an inter-system database, characterized in that B can be constructed including a related DB, and the DB can be backed up by basic data stored in an auxiliary storage device.