JPH03248239A - Data base management system constituting system - Google Patents

Abstract

PURPOSE:To easily change a data base management system without changing processing parts by constituting interface processing parts by the data operation of interface definition data and interface data groups. CONSTITUTION:Interface definition data operating parts 8 use parts 9 to 12 to access interface definition data 18 and retrieve, insert, delete, and change data in a data management table 19 and a structure management table 20. Interface data operating parts 13 retrieve data through the interface definition data operating parts and access interface data 22 based on data of the data management table 19 and retrieve, insert, delete, and change data based on data of the structure management table 20. At the time of data transmission/ reception between data base processing parts, processing parts 6 request processing parts 4 and management parts 7 to generate, insert, delete, and update data and transmit and receive data.

Description

[Detailed Description of the Invention] [Industrial Application Field] The present invention relates to a database management system construction method,
In particular, the present invention relates to a database management system construction method that allows the database management system to be easily changed and has enhanced expandability.

[Conventional technology]

A database management system is a collection of software that generally has the following functions for managing a database.

(1) A function to manage relationships between data and storage of data on recording media.

(2) A function that allows users to access data on storage media and search for information according to their requests.

(3) Control function to maintain data in correct state.

Therefore, in such a database management system, system changes refer to the basic mechanisms of the database management system: data storage mechanism, search mechanism, query processing mechanism, consistency control mechanism 1 recovery processing mechanism, and confidentiality protection mechanism. means to add or change.

Furthermore, a database management system is a collection of components (software) that have a mechanism that realizes data representation using a certain data model and guarantees data independence.

Such a database management system, for example,
It consists of each processing component of the database as shown in the figure.

FIG. 3 is a block diagram showing an example of the system configuration of the database management system. The outline of the database management system will be explained with reference to FIG. The database here refers to data stored in the file 34, and the database management system performs operations on the data in the file 34 based on the user's command string 23. and output to the user 24
to be returned.

In this case, the confidential management component 26 refers to the data definition information management component 27 for the user's command string 23 to check whether the user has the authority to issue the command string 23. Thereafter, the question processing component 25 analyzes the user's command string 23 using the data definition information component 27, and further inspects it by the consistency control component 29, and the data processing component 28. Using the consistency control component 29 and resource management component 30, database processing corresponding to the user's command string 23 is executed. The results of this database processing are then returned to the user as output 24.

In this manner, database processing is performed, but if any fault occurs during this processing, the fault management component 31 performs processing to return the data to correct values.

The database processing control unit 32 controls each processing component in order to efficiently implement such a series of database processing.

In addition, such a database management system includes a database generation assistance system 35. A database design support system 36 and a database reconfiguration support system 37 are provided.

In a database management system configured as described above, data is exchanged between each database processing component that performs database processing, as shown in Figure 4.
This is done using the control table 41. That is, when the database processing component A1 uses the database processing component B2, the processing component 3 of the database processing component A1 passes data necessary for using the database processing component B2 to the control table creation component 38. The control table creation component 38 creates a fifth control table based on the control table specifications 40 as shown in FIG. 5a.
A control table 41 as shown in Figure b is created.

This control table 41 is passed from the database processing component A1 to the database processing component B2 when control is transferred from the database processing component A1 to the database processing component B2. In the database processing component B2, the processing component 5 uses the control table interpretation component 39 to extract data from the control table 41 received from the database processing component A1. In this case, the control table interpretation component 39 uses the control table specifications 40 to interpret the data in the control table 41. Therefore, the control table creation component 38 and the control interpretation component 39 internally hold the same # table specification 40, thereby realizing data exchange processing between the respective components.

[Problem to be solved by the invention]

By the way, when using the above-mentioned data transfer method between database processing components, for some reason the functions of database processing component B2 may be added and the table name 40a and column name 40b of control table specification 40 may be changed. When the area is changed, for example, when the area of the table name 42a and column name 42b is changed as the specification 42 of the control table as shown in FIG. 42, the data must be interpreted. Therefore, if the specification of the control table is changed, the changed specification of the control table
Since data must be interpreted in a unified manner, changing the specifications of the control table does not require re-creating not only the control table interpretation component 39 but also the control table creation component 38, and even the database processing component A1. The problem is that it should not be done.

The present invention has been made to solve the above problems.

An object of the present invention is to prevent changes in one database processing component from causing changes in other database processing components.
An object of the present invention is to provide a database management system construction method that allows data to be exchanged between database processing components.

[Means to solve the problem]

In order to achieve the above object, the database management system construction method of the present invention is a construction method for an interface processing component within a database processing component that exchanges data between database processing components that perform processing for managing a database. interface definition data consisting of a data management table and a structure management table; an interface definition data manipulation component for searching, inserting, deleting, and updating the interface definition data; and an interface data manipulation component that searches, inserts, deletes, and updates the interface data, and the interface data management component is an interface definition data manipulation component. and an interface processing component that controls the operation components of the interface data manipulation component to create and interpret interface data by manipulating the interface definition data and the interface data group.

[Effect]

A database management system is composed of a plurality of database processing components that perform processing for managing a database. Each database processing component exchanges data between itself and performs processing for managing the database. Data exchange between the database processing components is performed by an interface processing component within the database processing component.

The database management system includes interface definition data consisting of data management tables and structure management tables,
Search, insert,
An interface definition data manipulation component that performs deletion and updating, an interface data group including a plurality of interface data created according to the interface definition data, and for the interface data,
An interface data manipulation component for searching, inserting, deleting, and updating is provided.

The interface data management component controls the interface definition data manipulation component and the interface data manipulation component to perform data manipulation of the interface definition data and the interface data group.
Build interface processing components that create and interpret interface data. In other words, the interface data management component uses the interface definition data to match the logical data structure and physical data structure of data exchanged between the database processing components, and performs data operations on the interface processing components. , construct an interface data processing component that creates and interprets interface data in a database processing component.

As a result, even if a change occurs in the data structure of the interface between database processing components, data exchange is independent of each other's changes, and the expandability of the database processing components can be improved.

Therefore, changes to database processing components can be made without causing changes to other database processing components.
The database management system can be easily changed.

〔Example〕

Hereinafter, one embodiment of the present invention will be specifically described using the drawings.

FIG. 1 is a block diagram showing the configuration of essential parts of a database management system according to an embodiment of the present invention.

In FIG. 1, 1 is a first database processing component A;
2 is a second database processing component B. The database management system is composed of a plurality of database processing components 1 and 2 that perform processing for managing a database. Database processing components 1 and 2 are processing components 3, 5, . . . which perform database processing, respectively. and interface data processing components 4 and 6 for exchanging data between each database processing component.

Each of the database processing components 1 and 2 exchanges data between each database processing component using the interface processing components 4 and 6, and each of the processing components 3 and 5 performs processing for managing the database. In this way, data exchange between the database processing components is performed between the interface processing components 4 and 6 within the database processing components.

In the interface processing components 4 and 6, the data sending side
The interface data generation component sends the interface data, and the data is interpreted by the data receiving side or the interface data interpretation component. In the following description, the interface processing component 4 is assumed to be an interface data generation component.

The interface processing component 8 will be explained as an interface data interpretation component.

In addition, in FIG. 1, 22 is interface data;
21 is an interface data group which is a collection of data (interface data 22) received and passed between database processing components; 20 is a structure management table showing the correspondence between logical data structures and physical data structures; 19 is a This is a data management table showing logical identification names of data. Also, 18
is interface definition data that collects definition information of the interface data 22.

7 is the interface data group 2 using the interface definition data 18 based on the command of the database processing component.
This is an interface data management component that performs the first operation.

The interface data management component 7 includes an ink interface definition data manipulation component 8 that performs data manipulation on the interface definition data 18, and an interface data manipulation component 13 that performs data manipulation on the interface data group 21. Part 7 is
It controls the interface definition data manipulation component 8 and the interface data manipulation component 13, and constructs the interface processing component.

The interface definition data manipulation component 8 includes a search component 9.
．． Insert parts 10. Deleted parts 11. Update parts 12 are provided, and these parts 9 to 12 are used to access the interface definition data 18 and update the data management table 19.
Data and structure management table 20 data search, insertion,
Perform deletion, update, etc.

The interface data manipulation component 13 also includes a search component 14. Insert parts 15. Deleted parts 16. An updated part 16 is provided. The interface data manipulation component 13 uses the search component 9 of the interface definition data manipulation component 8 to search for data in the data management table 19 and data in the structure management table 20 via the interface definition data manipulation component 8. Based on the data in the data management table 19, search component 14. Insert parts 15. Deleted parts 16. Using the update component 17, access the interface data 22 of the interface data group 21 and update the structure management table 20.
Search and insert data of the interface data 22 based on the data of.

Delete or update.

When exchanging data between database processing components, the interface data creation component (interface processing component in database processing component 1) 4 and the interface data interpretation component (interface processing component in database processing component 1) 6 perform interface data management. Creating and inserting interface data into part 7,
delete.

Request updates and exchange data. This eliminates the need for each database processing component to be aware of the physical data structure of the exchanged data.

This makes it possible to realize a data exchange method that does not cause changes in other database processing components even if one database processing component is changed.

When constructing a database processing component, the user first uses the database generation support system 35 shown in FIG. Interface definition data 18 consisting of data is created.

FIG. 2a is a diagram showing an example of a data management table, and the second
Figure b is a diagram showing an example of a structure management table. Also, the second
Figure c is a diagram showing an example of interface data.

For example, a user creates data in a data management table 19 as shown in FIG. 2a and data in a structure management table 20 as shown in FIG. Store it in advance. The data in the data management table 19 shown in FIG. 2a and the data in the structure management table 20 shown in FIG.
This is definition information for the interface data 22 shown in the figure. That is, the name 4% of the interface data 22 (
IF12) corresponds to the data name of data management table 19, and each item name of interface data 22 corresponds to structure management table 2.
Corresponds to structure name 0. Further, the interface data 22 always has a data identifier 22a in the first item.

As a result, the interface data generation component (interface data processing component) 4 and the interface data interpretation component (interface data processing component) 6 create an interface as if the interface data 22 were configured in the format shown in FIG. 2c. Can manipulate data.

Referring again to FIG. When the interface data generation component 4 requests the interface data management component 7 to generate interface data 22, the interface data manipulation component 13 uses the search component 9 of the interface definition data manipulation component 8 to manage data from the interface definition data 18. The data in Table 19 and Structure Management Table 20 are taken out, and interface data 22 is created based on the data. Then, it is stored in the interface data group 21 using the insertion component 15 in the interface data manipulation component 13.

Also, the interface data generation component 4 provides the interface data 22 to the interface data management component 7.
When a request is made to update or delete, the interface data manipulation component 13 first uses the search component 9 of the interface definition data manipulation component 8 to retrieve the data in the data management table 19 and the structure management table 20, and retrieves the data based on the data. The interface data 22 to be updated or deleted is extracted from the interface data group 21 and updated using the update component 17 in the interface data manipulation component 13, or deleted using the deletion component 16.

When the interface data interpretation component 6 requests the interface data management component 7 to search for the interface data 22, the interface data manipulation component 13 searches the data management table 19 and the structure management table using the search component 9 of the interface definition data manipulation component 8. Based on the data, interface data 22 is extracted from the interface group 21, and the search result is returned to the interface data interpretation component 6.

Also, the interface data interpretation component 6 provides the interface data 22 to the interface data management component 7.
When you request an update of the interface data manipulation component 1
3 is a search component 9 of the interface definition data manipulation component 8
is used to extract data from the data management table 19 and structure management table 20, and create interface data group 2 based on the data.
The interface data 22 to be updated is extracted from 1 and updated using the update component 17.

Note that, as mentioned above, the interface definition data 18
is created using the interface definition data manipulation component 8 using the database generation support system 35, but editing processing such as insertion, deletion, and updating of the interface definition data 18 is performed using the interface data management component F. insert, delete, or update the interface definition data manipulation component 8.
0. Deleted parts 11. Use updated part 12.

The present invention has been specifically explained above based on examples, but
It goes without saying that the present invention is not limited to the embodiments described above, and can be modified in various ways without departing from the spirit thereof.

〔Effect of the invention〕

As is clear from the above description, according to the present invention, changing a database processing component does not cause changes in other database processing components, and the database management system can be easily changed.

[Brief explanation of drawings]

FIG. 1 is a block diagram showing the configuration of main parts of a database management system according to an embodiment of the present invention. Figure 2a shows an example of a data management table, Figure 2b shows an example of a structure management table, Figure 2c shows an example of interface data, and Figure 3 shows an example of a database management system. A block diagram showing an example of the system configuration; FIG. 4 is an explanatory diagram of a data exchange method between database processing components using a conventional control table; FIG. 5a is a diagram showing an example of the specifications of the control table; FIG. 5b FIG. 2 is a diagram showing an example of data in a control table. Figure 6a is a diagram showing another example of the specification of the control table;
The figure is a diagram showing another example of data in the control table. In the figure, 1, 2... database processing components, 3, 5...
・Processing parts, 4, 6... Interface data processing parts, F... Interface data management parts, 8...
Interface definition data manipulation component, 13... Interface data manipulation component, 18... Interface definition data, 19... Data management table, 20... Structure management table, 21... Interface data group, 22...・
interface data.

Claims (1)

[Claims] (1) A construction method for an interface processing component within a database processing component that exchanges data between database processing components that perform processing for managing a database, and an interface definition consisting of a data management table and a structure management table. an interface definition data manipulation component that searches, inserts, deletes, and updates the interface definition data; and an interface data group including a plurality of interface data created according to the interface definition data; an interface data manipulation component that searches, inserts, deletes, and updates the interface data; the interface data management component controls the interface definition data manipulation component and the interface data manipulation component; A database management system construction method characterized by constructing an interface processing component that creates and interprets interface data by manipulating data and a group of interface data.