JPH0398135A - Automatic saving controlling system for data base - Google Patents

Abstract

PURPOSE:To quickly save and delete the tables and to facilitate the arrangement of files by deciding whether the table information should be saved or not based on the log information. CONSTITUTION:When a process start is requested, a table information process means 3 reads and writes the table control information and the table data into and out of a directory file 9 and a data base file 10. A log information collecting means 4 writes the identification name and the process date of a table to the log information file 11. When a saving instruction is produced for the table information, a table information saving means 5 gives an input date to a log information deciding means 6. The means 6 takes only the log information of old dates out of the file 11 and gives the identification name of the relevant table to the means 5. The means 5 reads the table control information and the table data out of the files 9 and 10 respectively to write them into a saving file 12 and sends the identification name of the table to a table information deleting means 7. The means 7 deletes the table control information and the table data out of the files 9 and 10 respectively. As a result, the tables can be quickly saved and deleted.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a database control means for database technology in an information processing system.

[Conventional technology]

Conventionally, in database technology in information processing systems, the entire database system is evacuated. Alternatively, a database administrator outputs a list of tables created in a directory file, saves the list based on the list, and processes each table by determining whether it can be deleted or not.

[Problem to be solved by the invention]

In the conventional database technology described above, in a database system where a large number of tables are created, the method of backing up the entire system requires a considerable amount of time to save the entire system.
The database system cannot be used while the backup process is being executed.

In addition, the method of outputting a list and making a judgment one by one requires a considerable amount of time as it is necessary to repeatedly judge whether to save or not for several tables.
This added the task of performing the deletion process, which was a hassle.

[Means to solve the problem]

The configuration of the automatic database evacuation control system of the present invention is as follows:
A subset of the data can be stored in a subfile (a subfile can be
A database file that stores subfile data (called table data), a directory file that stores management information (referred to as table management information) for storing the table data, and a directory file that stores the table management information for this directory file. table information processing means for reading and writing the table data to and from the database file; a log information file for storing the table management information and log information during processing of the table data; a log information collection means for writing information read or written by the information processing means into the log information file as one piece of log information for each table; using a log information judgment means for searching and extracting log information that satisfies a reference value, a save file for storing the table management information and the table data for storage, and the log information extracted by the log information judgment means, table information saving means for reading the table management information from the directory file and the table data from the database file and writing them to the save file; the saved table management information from the directory file and the table data from the database; The log information is deleted by using table information deletion means to be deleted and log information update means that adds information indicating that the table is a saved table to the log information of the saved table and writes it to the log information file. The present invention is characterized by saving and deleting table information of a table that is determined not to be used for the time being from the directory file and the database file based on the above.

〔Example〕

Next, the present invention will be explained in detail with reference to the drawings.

Referring to FIG. 1, one embodiment of the present invention includes a process start instructing device 1 for instructing the start of processing for directory files and database files, an evacuation instructing device 2 for instructing the evacuation of tables, and table management information in a directory file. , a table information processing means 3 that reads and writes table data to and from a database file, a log information collection means 4 that writes information received from the table information processing means 3 as log information to a log information file, and a save instruction. The date received from the device 2, which serves as a reference for the save processing, is passed to the log information judgment means 6, and the log information judgment means 6 receives the retrieved log information and extracts the table management information of the table from the directory file and the table data. A table information saving step 5 of reading from a database file and writing to a save file, a step 6 of log information judgment for searching for log information having a date older than the date received from the table information saving means 5 and extracting the log information, and a step 6 of saving the log information. The table information deletion means 7 deletes the table management information of the deleted table from the directory file and the table data from the database file, adds information indicating that the table has been saved and deleted to the log information of the deleted table, and Log information update means 8 to write to information file
, a directory file 9 for storing table management information, a database file 10 for storing table data, a log information file 11 for storing log information, and a save file 12 for storing table management information and table data. has been done.

In the above configuration, when a process start is requested from the process start instructing device 1, the table information processing means 3 uses the input table identification name to send table management information to the directory file 9 and the database file 10. Performs processing to read and write table data. When these processes are completed, the identification name of the processed table and the processing date are passed to the log information collection means 4. Upon receiving the table identification name and processing date, the log information collecting means 4 writes it out as one piece of log information in a log information file.

Next, when a date is input from the save instruction device 2 and an instruction to save the table information is requested, the table information save means 5 passes the input date to the log information judgment means 6.

The log information judgment means 6 reads all the log information in the log information file 11, compares the received date with the date in the log information, extracts only the log information that is older than the latter, and extracts the log information in the log information that is older. Save the table identification name and table information 1,000 steps 5
pass it on to

The table information saving means 5 saves the table management information from the directory file 9 to the database file 1 using the table identification name.
Table data is read from 0 and written to the save file 12. When the writing process to the save file is completed, the table identification name is passed to the table information deletion means 7.

The table information deletion means 7 deletes the table management information from the directory file 9 into the database file 1 using the table identification name.
Delete table data from 0. When the deletion process is completed, the table identification name of the table that has been deleted is passed to the log information updating means 8.

Using the identification name of the table, the log information update means 8 adds information indicating that the table is a saved and deleted table to the log information of the table in the log information file 11, and writes it to the log information file 11. [Effects of the Invention] The present invention relates to a database technology for an information processing system, and in a database system in which a large number of tables are created, by determining whether or not to save table information based on log information, Tables can be quickly saved and deleted, and files can be easily organized. In addition, the free space in directory files and database files created by deleting table information can be used as space for other tables, or as space for newly created tables. This has the effect of making effective use of the area.

directory file, 10... database file,
11... Log information file, 12... Save file.

Claims (1)

[Claims] Subsets of data can be stored in subfiles (subfiles can be
A database file that stores subfile data (called table data), a directory file that stores management information (referred to as table management information) for storing the table data, and a directory file that stores the table management information for this directory file. table information processing means for reading and writing the table data to and from the database file; a log information file for storing the table management information and log information during processing of the table data; a log information collection means for writing information read or written by the information processing means into the log information file as one piece of log information for each table; using a log information judgment means for searching and extracting log information that satisfies a reference value, a save file for storing the table management information and the table data for storage, and the log information extracted by the log information judgment means, table information saving means for reading the table management information from the directory file and the table data from the database file and writing them to the save file; the saved table management information from the directory file and the table data from the database; The log information is deleted by using table information deletion means to be deleted and log information update means that adds information indicating that the table is a saved table to the log information of the saved table and writes it to the log information file. An automatic database save control system characterized by saving and deleting table information of a table that is determined not to be used for the time being from the directory file and the database file based on the above.