JPH10133920A - Data base management device and computer-readable storage medium where data base management control program is recorded - Google Patents

Abstract

PROBLEM TO BE SOLVED: To enable a general user to alter data in a data base system in cooperation with a system administrator by inspecting whether or not alterations are made between the contents of a table registered in a basic table and a copy table. SOLUTION: A table registration part 3 registers a table containing basic information specified by the registration command input of the administrator in the basic table 2 and a table copy part 5 generates a copy table 4 of the table registered in the basic table 2. When the administrator alters the basic information, a table alteration management part 6 takes the information before the alteration out of the data base system 1 and stores it in the copy table 4. Consequently, the information before the alteration is stored in the basic table 2 and the information after the alteration is stored in the copy table 4. A basic table inspection part 7 inspects whether or not an alteration is made between the contents of the table registered in the basic table 2 and the contents of the copy table 4.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database management apparatus and a storage medium for storing a database management control program in a computer readable manner. A database system built with an information processing system
Although various tables are provided according to the target information processing system, in recent years, the number of tables and the data amount of the tables have become enormous with the increase in the amount of information. Regardless of the type of information processing system, it is often the case that a change is made to the constructed database afterwards, such as modification of table data, and this change is incidental. That is, in an information processing system, a database is effective only when data is constantly updated to the latest state. Therefore, it is required that data can be changed reliably and quickly. Here, in the conventional database system, data can be changed only by the administrator of the system. Therefore, a general user can input data related to the table data (for example, data input at the time of issuing a voucher), but can change the table data (for example, the If it is necessary to change the job system of the person concerned), the change is actually dependent on the administrator of the system.

[0002]

2. Description of the Related Art A conventional change operation has been performed manually by a system administrator as follows. That is, the system administrator checks the user for the necessity of changing the table data, manually creates an SQL statement as a database query language based on the check result, and executes the data change. Alternatively, in the case of a data change associated with a change in the organization of the company, the system administrator creates an SQL statement manually based on the notice of the personnel change,
Perform data changes.

[0003]

However, since the number of tables and the amount of data in the tables have become enormous in recent databases, there is a conventional database in which all the tables are manually changed as described above. In the method, it is inevitable that a change error occurs, and it is difficult to ensure the certainty of the change. Also, in this method, only the man-hour of the system administrator increases, and it is difficult to expect a quick data change.

[0004] Here, the system administrator can only understand and maintain the database system, and has no information on the contents of changes in the table data. on the other hand,
There is certainly table data for which only the system administrator can make data changes, but the source of the data to be changed is the general user, and the table may be left to the general user. Data should also be present.

[0005] Therefore, in order to secure certainty and quickness of data change, it is optimal to adopt a method in which general users are allowed to change data. In this case, since it is difficult for a general user to understand SQL, the SQL
It is desired to develop a device that allows a general user to easily change data without creating an L sentence. SUMMARY OF THE INVENTION The present invention has been made to solve such a problem, and provides a database management apparatus and a database management control program which enable a general user to change data in a database system in cooperation with a system administrator. It is an object of the present invention to provide a storage medium that stores a computer in a readable manner.

[0006]

FIG. 1 is a block diagram showing the principle of the first to fourth aspects of the present invention. Claim 1
The table registration unit 3 registers a table storing basic information in the basic table 2 in the database system 1, and the table duplication unit 5 generates a duplicate table 4 of the table registered in the basic table 2.
And a table change management unit 6 for storing information before the change in the duplicate table 4 when the information of the table registered in the basic table 2 is changed, and the contents of the table registered in the basic table 2 and the duplicate table 4 And a basic table inspection unit 7 for inspecting whether or not there is a change between the contents.

According to a second aspect of the present invention, in the database management apparatus according to the first aspect, the basic table inspecting unit 7 performs an inspection of whether or not there is a change when the application program is started, and the basic table inspecting unit 7 has a change. When it is determined that the application program accesses various tables, the table display unit 8 displays the contents of the corresponding tables.
It is characterized by having.

According to a third aspect of the present invention, in the database management apparatus according to the second aspect, a change command generating unit 9 for generating a change command from the change data input in the table displayed by the table display unit 8 is provided. It is characterized by having. According to a fourth aspect of the present invention, in the database management apparatus according to the third aspect, the table registration unit 3 registers execution control information for designating a timing of a change process with respect to a table to be registered in the basic table, and changes the table. It is characterized by comprising a storage unit 10 for storing the change command generated by the command generation unit 9 and a change command execution unit 11 for executing the change command stored in the storage unit 10 in accordance with the execution control information.

According to a fifth aspect of the present invention, there is provided a recording medium recording a database management control program, wherein a first procedure for registering a table for storing basic information in a database system in a basic table in a computer; A second procedure for generating a duplicate table of the table registered in the basic table, a third procedure for storing information before the change in the duplicate table when information of the table registered in the basic table is changed, And a fourth step of checking whether there is any change between the contents of the table registered in the first table and the contents of the duplicate table.

According to a sixth aspect of the present invention, in the recording medium according to the fifth aspect, in the fourth step, a check for the presence or absence of a change is executed when the application program is started, and the database management control program executes the fourth step. When the application program determines that there is a change, the fifth step of displaying the contents of the corresponding table when the application program accesses various tables is performed by the computer.

According to a seventh aspect of the present invention, in the recording medium according to the sixth aspect, the database management control program generates a change command from the change data input in the table displayed in the execution of the fifth procedure. 6
The method is characterized by causing a computer to execute the procedure. According to an eighth aspect of the present invention, in the recording medium according to the seventh aspect, the first step further includes a step of registering execution control information for designating a timing of a change process for the table registered in the basic table. The database management control program causes the computer to execute a seventh procedure of storing the change command generated in the execution of the sixth procedure in the storage unit and an eighth procedure of executing the change command stored in the storage unit in accordance with the execution control information. It is characterized by being executed.

Next, the operation of the database management apparatus of the present invention will be described with reference to FIG. According to the first aspect of the present invention, attention is paid to the fact that "base information exists" in the database, and the table registration unit 3 inputs a registration command input by the administrator from among many tables in the database system 1. Is registered in the basic table 2 and the table duplicating unit 5 generates a duplicate table 4 of the table registered in the basic table 2.

When the administrator performs an operation of changing the underlying information, the table change management unit 6 fetches the information before the change from the database system 1 and copies the information before the change. Stored in Table 4. As a result, the post-change information is stored in the basic table 2, and the pre-change information is stored in the duplicate table 4. Therefore, the basic table inspection unit 7
By checking whether there is any change between the contents of the table registered in the database and the contents of the duplicate table 4, it is possible not only to automatically detect the necessity of data change and to notify the user, but also to change the underlying information. Thus, a change in another table that needs to be changed in a chain can be called out, and data can be changed quickly.

More specifically, as in the second aspect of the present invention, the basic table checking unit 7 checks whether there is a change between the contents of the table registered in the basic table 2 and the contents of the duplicate table 4. Is performed when the user starts the application program, and when the application program accesses various tables, the table display unit 8 displays the contents of the table determined by the basic table inspection unit 7 to be changed. Thus, the user can input data to be changed.

That is, the user can change only necessary tables and data related to the user according to the flow of the application program to be used. Therefore, even if the user is allowed to change the data, the destruction of the database and the inconsistency of data between tables can be prevented. At this time, since the change command generating unit 9 generates the change command from the change data input by the user, the user can easily change the data even if the user is not familiar with the database system. Can perform processing.

Since there is an appropriate timing for the execution of the change processing according to the nature of the data and the like, the table registration unit 3 registers the table registered in the base table as in the invention according to claim 4. If the change command execution unit 11 executes the change command stored in the storage unit 10 in accordance with the execution control information and registers the execution control information that specifies the time of the change process for the Change processing can be performed at an appropriate time.

Further, according to the invention described in claims 5 to 8, it is possible to provide a recording medium for recording the above-described control program of the database management device in a computer-readable manner.

[0018]

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

FIG. 2 is a block diagram of an embodiment corresponding to claims 1 to 4. The database management device according to the present embodiment includes a database memory 20, an administrator operation unit 21, a table registration unit 22, a basic memory 23, a table duplication unit 24, a duplication memory 25, and a table change management unit 2.
6, a table inspection unit 27, a table display unit 28, a user operation unit 29, a change command generation unit 30, a change command memory 31, a change command execution unit 32, and the like.

The administrator operation section 21 includes an input device (keyboard, mouse, etc.) and a display device having a display screen, and the system administrator outputs various commands in an interactive manner. In the present embodiment, the registration command is
To the database memory 20, the basic memory 23, and the table change management unit 26, and an execution instruction to the change command execution unit 32.

The table registration unit 22 is provided with the administrator operation unit 21
Receiving the registration command from the base station, the basic table management information is provided to the basic memory 23, and the table information is transmitted to the table duplication unit 24.
Give to. The table duplication unit 24 receives the table information from the table registration unit 22, generates a duplicate table, and stores it in the duplicate memory 25. Table change management unit 26
Receives the change instruction, obtains the pre-change information from the database memory 20 and stores it in the duplicate memory 25.

The table inspection unit 27 includes a user operation unit 29
Receiving the application program start signal from the
3 is compared with the contents of the duplicate memory 25 to check for a change. The inspection result (presence or absence of change) is given to the table display unit 28. When the application program started by the user refers to and cites various tables stored in the database memory 20 (hereinafter simply referred to as “reference”), the table display unit 28 changes the output of the table inspection unit 27. At a certain time, the corresponding table is read from the database memory 20 and the contents of the table are displayed on the display screen of the user operation unit 29 together with the change conditions and the like.

The user operation unit 29 includes an input device (keyboard, mouse, etc.) and a display device having a display screen, similarly to the administrator operation unit 21. The user starts the application program using the input device,
Uses the input device to input change data for the table displayed on the display screen of the display device. This change data is provided to the change command generator 30.

The change command generation unit 30 converts the change data given from the user operation unit 29 into change command data, and stores the converted command data in the change command memory 31. The change command execution unit 32 executes the change command stored in the change command memory 31 according to the execution control information acquired from the basic memory 23 or according to an execution command from the administrator operation unit 21. A change process is performed on a table stored in the database memory 20 and referenced by the application program.

In the above configuration, the correspondence with the claims is as follows. A database memory 20 corresponds to the database system 1. The basic memory 23 corresponds to the basic table 2. Table registration part 3
Corresponds to the table registration unit 22. Replication table 4
Corresponds to the duplicate memory 25. The table replication unit 24 corresponds to the table replication unit 5. The table change management unit 26 corresponds to the table change processing unit 6. The table inspection unit 27 corresponds to the basic table inspection unit 7.
The table display unit 28 corresponds to the table display unit 28.

The change command generator 9 corresponds to the change command generator 30. The change command memory 31 corresponds to the storage unit 10. The change command execution unit 11 includes:
The change command execution unit 32 corresponds. Regarding the database management control program, the first procedure corresponds to the processing executed by the table registration unit 22, and the second procedure is
The third procedure corresponds to the processing performed by the table change management unit 26, the fourth procedure corresponds to the processing performed by the table inspection unit 27, The fifth procedure corresponds to the processing executed by the table display unit 28, the sixth procedure and the seventh procedure correspond to the processing executed by the change command generation unit 30, and the eighth procedure corresponds to the change command execution unit. 32.

This database management device is a computer such as a well-known personal computer or workstation.
It is executed by the database management control program. That is, this computer includes a CPU (Central Processing Unit), a memory, a hard disk, and various devices (CD-
Auxiliary recording device such as ROM, modem for data communication using telephone line, network card for data communication using network such as LAN, etc.)
Are connected to the bus. Then, the database management control program is loaded into the memory from the hard disk or the various devices, and causes the CPU to execute the above procedures.

Next, the operation of the database management apparatus according to the present embodiment will be described with reference to FIGS. FIG. 3 is a configuration diagram of the basic table. FIG. 4 is a configuration diagram of the employee table. FIG. 5 is an explanatory diagram when the employee table # 2 is changed. FIG. 6 is an explanatory diagram of generation of a replication table. FIG. 7 is a configuration diagram of a slip table as an example of the reference table. FIG. 8 is an explanatory diagram of table display and content / condition input.

As described above, a program that uses any database system always includes “basic (core) information” (eg, employee information and organization information for a company). Exists. Further, the necessity of changing data in the database system mainly arises when these “base information” change. The user is fully aware of whether or not the “base information” has changed, the details of the change, and the like.

In the present embodiment, attention is paid to such a point, and when the necessity of data change arises, the system administrator and the general user can cooperate with each other to change the data. It is. In FIG. 2, the administrator operation unit 2
1, table registration unit 22, basic memory 23, table duplication unit 24, duplication memory 25, table change management unit 26
Is a part related to data change performed by the system administrator. Also, a table inspection unit 27, a table display unit 28,
The user operation unit 29, the change command generation unit 30, the change command memory 31, and the change command execution unit 32 are parts related to data change performed by a general user.

First, a part related to data change performed by the system administrator will be described. The system administrator generates a registration command in the manager operation unit 21 and gives the registration command to the table registration unit 22 to perform preprocessing for data change. This registration command is a command for storing the basic table management information in the basic memory 23. The basic table management information is shown in FIG.
As shown in the figure, the information includes a “file name” and “execution control information”.

"File name" is the name of a table in which basic data is stored. In the present embodiment, the “employee number” in the company is defined as the basic data. Therefore,
“File name” is “employee table”.

The "execution control information" is information for designating a timing at which a change command generated by a user is executed, as described later, for a related table using the basic data when the basic data is changed. . The system administrator is fully aware of the number, characteristics, contents, and the like of the “employee table” stored in the database memory 20.

Therefore, upon receiving the registration command, the table registration unit 22 stores the basic table management information in the basic memory 23 while requesting the system administrator. FIG. 3 shows an example of the basic table management information stored in the basic memory 23. A plurality of employee tables (# 1, # 2, # 3,...) Are registered as “table names”. Further, an “execution control time” is registered for each employee table. In the illustrated example, "employee table # 1" indicates "end of program", "employee table # 2" indicates "night", and "employee table # 3" indicates "20:30".
And so on.

"At the end of the program" indicates that the change process is immediately executed on the table using the employee table # 1 when the application program referring to the table is ended. Therefore, in this case, the operation of the system administrator is unnecessary, and the change processing is automatically executed. “Nighttime” indicates that a change process is performed on a table using the employee table # 2 at the convenience of the system administrator during the night after the end of the application program that refers to the table. Therefore, the change processing in this case is performed by the operation of the system administrator.

"20:30" indicates that the table using the employee table # 3 will be changed at 20:30 after the end of the application program that refers to the table. Therefore, in this case, the operation of the system administrator is unnecessary, and the change processing is automatically executed.

In the employee table, for example, as shown in FIG. 4, required items are registered in each item of "employee number", "affiliation", "name" and "department name". Table registration unit 22
Supplies the table duplication unit 24 with the table (item) information of each table having the table name input by the system administrator when the basic table management information is stored in the basic memory 23.

The table duplicating section 24 generates a table consisting only of frames (items) of each table information. Specifically, for example, as shown in FIG.
A table including only the items “affiliation”, “name”, and “department name” is generated. This is stored in the duplicate memory 25. If, for example, there is a change in the organization of the company after the above preprocessing is performed, the system administrator sees the notice of the personnel change and generates and inputs a change command in the manager operation unit 21.
This is output to the database memory 20, the basic memory 23, and the table change management unit 26.

For example, assume that data is changed in the employee table # 2. The contents of the employee table # 2 before the change are shown in FIG. Employee number "000
“Sato” of “1” belongs to “A1”.
As shown in (b), the “affiliation” has been changed to “B1”. In the database memory 20, upon receiving the change command, the contents of the employee table # 2 before the change (FIG. 5A)
Is output to the table change management unit 26, and in the employee table # 2, the affiliation of "Sato" of the employee number "0001" is changed from "A1" to "B1", and the changed employee table # 2 is changed. 2 (FIG. 5B) is given to the basic memory 23.

As a result, the changed employee table # 2 (FIG. 5B) is stored in the basic memory 23. On the other hand, when the table change management unit 26 obtains the employee table # 2 (FIG. 5A) before the change from the database memory 20, the data in each column of the employee number “0001” related to the change is copied to the copy memory 25. Give to. As a result, the duplication memory 25 registers and holds necessary items in each column of the duplication table (FIG. 6A) including only frames (items) (FIG. 6B).

Next, when the user of the employee number “0001” operates the user operation unit 29 to start, for example, an ordering program as an application program, the start signal is given to the table inspection unit 27. Then, the table inspection unit 27 receives the activation signal input from the user operation unit 29, fetches the employee table # 2 (FIG. 5B) having the employee number "0001" from the basic memory 23, and The employee table # 2 (FIG. 6 (b)) having the employee number "0001" is fetched from the duplicate memory 25, the presence or absence of the change is checked, and the check result of the change is displayed on the table display unit 2.
Give 8

The table display unit 28 monitors that the activated ordering program refers to the table stored in the database memory 20 when the inspection result of the table inspecting unit 27 is changed. When the activated ordering program refers to the table, the table display unit 2
8 retrieves a reference table in which the employee number “0001” exists from the database memory 20.

For example, if the reference table is a slip table, as shown in FIG. 7 (a), the slip table has columns such as "slip number", "creator (employee)", "affiliation", and "article name". It consists of. The table display unit 28 extracts data related to the employee number “0001” from the slip table, and displays “field name”, “change contents” and “change” on the display screen of the user operation unit 29 as shown in FIG. conditions"
Is displayed in a menu format.

The user performs a data change operation while viewing this screen. That is, in the "change content" input field, simply enter "B1" in the "affiliation code" field. Also,
In the "change condition" input field, "AND""NAND"
Although an item of “OR” is provided, in the present example, “000” is simply entered in the input field of “AND” in the field of the employee number.
1 ".

These input data are sent to the user operation unit 29
To the change command generator 30. The change command generator 30 converts the input change data into an SQL sentence and stores it in the change command memory 31. In this way, even if the user is not familiar with the database system, the user can easily understand and operate to input the change data in the field to be changed in a usual manner.

Next, the change command execution unit 32 extracts the execution control information on the employee table used for the inspection by the table inspection unit 27 from the basic memory 23, and executes the change command stored in the change command memory 31 accordingly. , The data of the corresponding table stored in the database memory 20 is changed. In the previous example, it was for employee table # 2. The execution control information is “night”. In this case, the system administrator outputs an execution command from the manager operation unit 21 at a convenient time during the night, so the change command execution unit 32 receives the execution command and stores it in the change command memory 31. Execute the change command.

The employee table is an employee table #
If 1, the execution control information is “immediate”,
The change command execution unit 32 automatically executes the change command stored in the change command memory 31 upon completion of the ordering program. If the employee table is employee table # 3, the execution control information is “20:30”.
Therefore, the change command execution unit 32 automatically executes the change command stored in the change command memory 31 at 20:30 after the end of the ordering program.

As a result, the slip table stored in the database memory 20 referred to by the ordering program shows that the “creator (employee number) 0001” and the “affiliation” are “A1” from FIGS. It is changed to "B1" as shown in (b). In the present embodiment, a database system in a company has been described as an example. However, since this device can be used for, for example, a trend survey of population distribution by prefecture, it is similar to a database system in a general information processing system. Needless to say, it can be applied to

[0049]

As described above, according to the first aspect of the present invention, attention is paid to the fact that "base information exists" in the database, and the basic In addition to registering a table that stores the information to be stored in the base table, a duplicate table of the registered table is generated, and when the base information is changed, the information before the change is stored in the duplicate table. Then, it checks whether there is any change between the contents of the table registered in the base table and the contents of the duplicate table.

Therefore, according to the present invention, it is possible to automatically detect the necessity of data change and notify the user of the change, and also to change other tables which need to be changed in a chain by the change of the underlying information. Changes can be triggered and data can be changed quickly. More specifically, as in the second aspect of the present invention, the check for the presence or absence of a change is performed when the user starts the application program, and when the application program accesses various tables, it is determined that there is a change. By displaying the contents of the table, the user can input data to be changed.

That is, since the user is aware of the content of the data change, it is possible to change only the necessary tables and data related to the user according to the flow of the application program to be used. Therefore, even if the user is allowed to change the data, the destruction of the database and the inconsistency of data between tables can be prevented.

At this time, if the change command is generated from the change data input by the user as in the invention described in claim 3, the user can easily execute the change processing even if he is not familiar with the database system. . Since there is an appropriate timing for the execution of the change processing according to the nature of the data, the generated change command is stored and stored as in the invention of claim 4. If the execution of the change command is performed according to the execution control information, the change processing can be performed at an appropriate time according to the nature of the data.

Further, according to the inventions described in claims 5 to 8, it is possible to provide a computer-readable recording medium for recording the control program of the database management device according to claims 1 to 4. In short, according to the present invention, not only the system administrator but also the user can change the data, so that it is possible to reduce the man-hour of the system administrator and to prevent the occurrence of the change error due to the overload. In addition, rapid data changes can be made by cooperation between the system administrator and the user.

[Brief description of the drawings]

FIG. 1 is a principle block diagram of the invention described in claims 1 to 4;

FIG. 2 is a configuration diagram of an embodiment of the present invention corresponding to claims 1 to 4;

FIG. 3 is a configuration diagram of a basic table.

FIG. 4 is a configuration diagram of an employee table.

FIG. 5 is an explanatory diagram when there is a change in an employee table # 2. (A) Employee table # 2 before change
Is shown. (B) shows the configuration of the employee table # 2 after the change.

FIG. 6 is an explanatory diagram of generation of a replication table. (A) shows a duplicate table of the employee table # 2 (before the change operation). (b) shows saving of employee data related to the change operation.

FIG. 7 is a slip table configuration diagram shown as an example of a reference table. (A) shows the slip table before the change.
(B) shows the slip table after the change.

FIG. 8 is an explanatory diagram of table display and content / condition input.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Database system 2 Basic table 3 Table registration part 4 Duplication table 5 Table duplication part 6 Table change management part 7 Basic table inspection part 8 Table display part 9 Change command generation part 10 Storage part 11 Change command execution part 20 Database memory 21 Administrator Operation unit 22 Table registration unit 23 Basic memory 24 Table duplication unit 25 Duplication memory 26 Table change management unit 27 Table inspection unit 28 Table display unit 29 User operation unit 30 Change command generation unit 31 Change command memory 32 Change command execution unit

Claims (8)

[Claims] A table registration unit for registering a table storing basic information in a database system in a basic table; a table duplication unit for generating a duplicate table of the table registered in the basic table; A table change management unit that stores information before the change in the duplicate table when there is a change in the registered table information; and changes between the contents of the table registered in the base table and the contents of the duplicate table. A database management device comprising: a basic table inspection unit for inspecting presence / absence. 2. The database management device according to claim 1, wherein the basic table inspection unit performs the inspection of the presence or absence of the change at the time of starting an application program, and when the basic table inspection unit determines that there is a change, A database management device, comprising: a table display unit for displaying contents of a table when an application program accesses various tables. 3. The database management apparatus according to claim 2, further comprising: a change command generation unit configured to generate a change command from change data input in a table displayed by the table display unit. apparatus. 4. The database management device according to claim 3, wherein the table registration unit registers execution control information for designating a timing of a change process for a table registered in a base table, and the change command generation unit. And a change command execution unit that executes the change command stored in the storage unit in accordance with the execution control information. 5. A recording medium on which a database management control program is recorded, comprising: a first step of registering, in a computer, a table for storing basic information in a database system in a basic table; A second procedure of generating a duplicate table of the table; a third procedure of storing information before the change in the duplicate table when there is a change in information of the table registered in the basic table; And a fourth step of checking whether there is a change between the contents of the duplicated table and the contents of the duplicate table. 6. The recording medium according to claim 5, wherein, in the fourth step, the check for the presence or absence of the change is executed when an application program is started, and the database management control program executes the fourth step in the execution of the fourth step. When it is determined that there is a change,
A computer-readable recording medium recording a database management control program, wherein the application program causes a computer to execute a fifth procedure of displaying the contents of a corresponding table when the application program accesses various tables. 7. The recording medium according to claim 6, wherein the database management control program generates a change command from change data input in a table displayed in the execution of the fifth procedure.
A computer-readable recording medium having recorded thereon a database management control program for causing a computer to execute a procedure. 8. The recording medium according to claim 7, wherein said first step further includes a step of registering execution control information for designating a change processing time for a table to be registered in a base table; The management control program executes a seventh procedure of storing the change command generated in the execution of the sixth procedure in a storage unit, and an eighth procedure of executing the change command stored in the storage unit in accordance with the execution control information. A computer-readable recording medium having recorded thereon a database management control program.