JPH08328929A - Database split management system - Google Patents

Abstract

PURPOSE: To improve efficiency for using a storage device for storing the physical files of a database and to improve the efficiency of physical file backup by performing access to the plural physical files logically as one physical file. CONSTITUTION: This system is provided with a physical file splitting means 110 for splitting a physical file 100 of the database into plural physical files 101 and 102 corresponding to the use frequency of data, a physical file moving means 120 for moving the plural split physical files 101 and 102 between plural storage devices corresponding to the use frequency of the physical files 101 and 102, a physical file access means 130 for performing access to the plural split physical files 101 and 102 logically as one physical file, and a physical file backup means 140 for backing up the updated physical file between the plural split physical files 101 and 102 after the backup.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database division management system, and more particularly to a database division management system for a database that divides a physical file having a large amount of data into a plurality of physical files and searches and updates the data. It is related to effective technology.

[0002]

2. Description of the Related Art Conventionally, in a database system, a logical file, which is a virtual file defined based on a physical file storing actual data, is created, and the physical file is accessed via the logical file.

The physical file of the database is a file that stores the actual data accumulated by the user of the database, and is composed of physical file definition information, data, and an index. The actual data is accumulated in the physical file. Over time, the size of the physical file may become enormous.

The logical file of the database is a file for extracting or combining arbitrary data from one or a plurality of physical files, is created according to the purpose of use, and is composed of logical file definition information and the like. .

In the operation of the database system, as the amount of data in the physical file increases, the burden of securing a storage area for storing the physical file and backing up the physical file increases.

For this reason, when performing work associated with the operation of the database such as securing the storage area and backing up, a physical file having a large amount of data is temporarily divided into a plurality of physical files having a small amount of data. I'm working.

When the data of the physical file is divided into a plurality of physical files, in order to access all the data of each of the divided physical files, the user himself / herself collects the data of each physical file into one data file. It is necessary to create a physical file and access the created physical file.

A method or apparatus for integrating a plurality of physical files into one as described above is disclosed in JP-A-60-19.
5653, JP-A-5-181727, JP-A-5-3
5553. The outline is a method of creating a temporary physical file by integrating multiple physical files at the time of execution, a device that simplifies the work of integrating multiple databases, and integration without saving all related files. Is the way to do it.

[0009]

The present inventor has found the following problems as a result of examining the above-mentioned prior art.

That is, when the physical file of the conventional database system contains the specific data which is not required in the normal operation, the specific data wastefully occupies the capacity of the external storage device storing the physical file. However, there is a problem that the usage efficiency of the external storage device is reduced.

Therefore, while the specific data is not needed, the specific data is divided into different physical files, saved in a storage medium such as a magnetic tape, and deleted from the external storage device, so that the external data is stored in the external storage device. It is possible to improve the use efficiency of the storage device.

However, when a job that requires all the data in the undivided physical file occurs, the physical file containing the specific data deleted from the external storage device is replaced with the magnetic tape or the like. Data from each storage medium to an external storage device and collect the data of each physical file 1
It is necessary for the user to recreate one physical file, and this work has a problem that it takes a lot of time to create the physical file because a large amount of data is handled.

Even in the method or apparatus for integrating a plurality of physical files described in JP-A-60-195653, JP-A-5-181727 and JP-A-5-35553, the physical files to be integrated If has a large amount of data, integrating the physical files requires a lot of time.

An object of the present invention is to provide a technique capable of improving the usage efficiency of a storage device that stores a physical file.

Another object of the present invention is to access a plurality of physical files logically as one physical file without integrating a plurality of divided physical files to create one physical file. To provide possible technology.

Another object of the present invention is to provide a technique capable of improving the efficiency of backing up a physical file.

The above and other objects and novel features of the present invention will become apparent from the description of the present specification and the accompanying drawings.

[0018]

Of the inventions disclosed in the present application, a representative one will be briefly described below.
It is as follows.

That is, according to the physical file dividing means for dividing the physical file of the database into a plurality of physical files according to the use frequency of the data, and the use frequency information of the plurality of physical files divided by the physical file dividing means. A database division management system comprising physical file moving means for moving the physical file between a plurality of storage devices, wherein the physical file dividing means is stored for each fixed area in the physical file to be divided. Data access recording means for recording the usage frequency of data, and divided physical file creation means for creating a plurality of physical files by dividing the physical file according to the usage frequency information recorded by the data access recording means , The physical file moving means determines the usage frequency according to the usage frequency information. A physical file saving means for saving a low physical file to another storage device, a physical file deleting means for deleting the physical file saved by the physical file saving means from the save source storage device, and a physical file saving means The physical file restoring means restores the saved physical file from the save destination storage device as needed.

Further, in the above-mentioned database division management system, which is provided with a physical file access means for logically accessing a plurality of divided physical files as one physical file, wherein the physical file access means comprises:
A logical file definition means for recording the names of the plurality of divided physical files and logical file definition information indicating whether or not the plurality of divided physical files have been moved by the physical file moving means, and the division When there is an access request for a plurality of physical files that have been created, the logical file access means is provided for referring to the logical file definition information recorded by the logical file definition means and executing the access request.

A database division management system comprising physical file backup means for backing up a physical file that has been updated since the last backup among a plurality of divided physical files, wherein the physical file backup Means, backup recording means for recording the backup information indicating when the backup of the plurality of divided physical files was performed, the backup information recorded by the backup recording means and the update date and time of the physical file. By comparison, it has a partial backup means for backing up a physical file that has been updated since the previous backup as needed.

[0022]

According to the above-mentioned means, the physical file dividing means of the database division management system of the present invention divides the physical file of the database into a plurality of physical files according to the frequency of use of the data.

The data access recording means of the physical file dividing means, when the data stored in a fixed area in the physical file to be divided is accessed, the time, number of times or unit time at which the access is made. The number of hits is recorded as the usage frequency of the data for each fixed area of the physical file.

The divided physical file creating means of the physical file dividing means refers to the usage frequency information recorded by the data access recording means, and creates a plurality of physical files composed of data within a certain usage frequency range. .

Next, the physical file saving means of the physical file moving means refers to the usage frequency information of the divided physical files, and stores the physical files with low usage frequency as a storage medium of another storage device such as a magnetic tape. Evacuate to.

The physical file deleting means of the physical file moving means deletes the physical file with low frequency of use saved by the physical file saving means from the storage device of the save source, and the physical file deleting means of the physical file moving means. The physical file restoring means restores the physical file saved by the physical file saving means from the save destination storage device as necessary.

As described above, in the database division management system of the present invention, the physical file of the database is divided into a plurality of physical files according to the frequency of use of data, and the physical file is used from among the plurality of divided physical files. Since the infrequent physical file is moved to the storage medium of another storage device such as a magnetic tape, it is possible to improve the usage efficiency of the storage device in which the physical file to be divided is stored.

Further, the physical file access means of the database division management system of the present invention logically accesses a plurality of divided physical files as one physical file.

The logical file definition means of the physical file access means records the names of the plurality of divided physical files and the logical file definition information indicating whether or not the physical file has been moved by the physical file moving means.

The logical file access means of the physical file access means refers to the name of each physical file in the logical file definition information when an access request is made to the plurality of divided physical files, The access request is executed by individually accessing the plurality of divided physical files, and the execution result is passed to the request source of the access request.

When some of the divided physical files have been moved by the physical file moving means, the physical file restoring means moves the physical files from the save destination storage device. Restore and execute the access request.

As described above, in the database partition management system of the present invention, when there is an access request to the plurality of divided physical files, the plurality of divided physical files are individually accessed. It is possible to logically access the plurality of divided physical files as one physical file without integrating the plurality of divided physical files to create one physical file.

Further, the physical file backup means of the database division management system of the present invention backs up the physical files that have been updated since the previous backup among the plurality of divided physical files.

The backup recording means of the physical file backup means records backup information indicating when the backup is performed when the plurality of divided physical files are backed up.

The partial backup means of the physical file backup means compares the backup information recorded by the backup recording means with the update date and time in the usage frequency information of the physical file, and the update is performed after the previous backup. Back up physical files as needed.

For the update date and time compared with the backup information, if the data access recording means records the update date and time as the usage frequency information, use the latest value of the update date and time in the usage frequency information. It is also possible to use a value obtained from the update date and time data recorded for each file by the conventional file management technique.

As described above, in the database partition management system of the present invention, when backing up the plurality of divided physical files, only the physical files that have been updated since the previous backup are backed up. It is possible to improve the efficiency of file backup.

[0038]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention will be described below in detail with reference to the drawings together with embodiments.

In all the drawings for explaining the embodiments, parts having the same functions are designated by the same reference numerals, and the repeated description thereof will be omitted.

FIG. 1 is a diagram showing a processing outline of an embodiment of the database division management system of the present invention.

In FIG. 1, 100 to 102 are physical files, 110 is a physical file dividing means, 120 is a physical file moving means, 130 is a physical file access means,
140 is a physical file backup means, and 150 and 17
Reference numeral 0 is a magnetic tape (MT), and 160 is an application program.

As shown in FIG. 1, the database division management system of the present embodiment has a physical file division means for dividing a physical file of a database into a plurality of physical files according to the frequency of use of data, and the aforementioned division. Physical file moving means 1 for moving a less frequently used physical file to another storage device according to the frequency of use of a plurality of physical files
20, a physical file access unit 130 that provides access as if the plurality of divided physical files were logically one physical file, and backs up the plurality of divided physical files. Sometimes, a physical file backup means 14 for backing up physical files that have been updated since the last backup
It has 0.

In the database division management system of this embodiment, the physical file 100 of the database is divided into the physical file 101 and the physical file 102 by the physical file dividing means 110.

The physical file moving means 120 uses the physical file 10 when the physical file 102 is used less frequently.
2 is moved to the MT 150 so that the storage area of the storage device in which the physical file 102 was stored can be used to store another physical file.

When the application program 160 tries to access the data of the physical file 101 and the physical file 102, the physical file access means 130 individually accesses the physical file 101 and the physical file 102, and the result of the access is applied. Pass to the program 160.

Further, the physical file backup means 14
0 is a physical file 10 which is a divided physical file
Of 1, 102, the physical file that has been updated since the previous backup is backed up in the MT 170.

In the database division management system of the present invention, a process of dividing and moving a physical file of a database, a process of accessing a plurality of divided physical files, and a backup of a plurality of divided physical files will be described below. The processing for performing will be described together with each embodiment.

(Embodiment 1) In the database division management system of the present invention, a physical file of a database is divided into a plurality of physical files according to the frequency of use of data, and the plurality of divided physical files are divided into physical files. A process of moving a physical file according to the frequency of use will be described.

FIG. 2 is a diagram showing an outline of processing for dividing and moving a physical file of a database in the database division management system of this embodiment.

In FIG. 2, 111 is a data access recording means, 112 is a divided physical file creating means, 121 is a physical file saving means, 122 is a physical file restoring means, 123 is a physical file deleting means, 201 is data in the physical file. Is stored in the data record, and 202 is an access time in which the time when the record is accessed is recorded.

As shown in FIG. 2, the physical file dividing means 110 of the database division management system of this embodiment comprises a data access recording means 111 for recording the frequency of use of the physical file 100, and a physical file dividing means 110 according to the frequency of use. The physical file moving means 120 has a divided physical file creating means 112 for dividing 100, and the physical file saving means 12 saves the physical file to the MT 150 according to the frequency of use of the divided physical files 101, 102.
1, physical file deletion means 123 for deleting the physical file saved in MT150 from the storage device from which the physical file was saved, and MT150 when the physical file saved in MT150 needs to be accessed. Physical file restoring means 1 for restoring the physical file
22.

In the database division management system of this embodiment, the data access recording means 111 of the physical file dividing means 110 stores the data stored in the physical file 100 each time the data is accessed. Access time 20 corresponding to record 201
In 2, the time when the access is performed is recorded as the usage frequency of the data.

Next, the divided physical file creating means 112 of the physical file dividing means 110 refers to the access time 202 of the physical file 100 and creates a plurality of physical files consisting of the data records 201 having the access time 202 within a certain range. create.

For example, the average value of the access times 202 of the physical file 100 is calculated, and the physical file 101 storing the data record 201 having the access time 202 of the average value or more and the access time 20 of less than the average value.
The physical file 102 storing the data record 201 having 2 is created.

When the physical file 102 storing the data that is used less frequently is not used, the physical file saving means 121 of the physical file moving means 120 saves the physical file 102 to the MT 150. Physical file 10
2 is saved to MT150, and then physical file moving means 1
The physical file deletion unit 123 of 20 deletes the physical file 102 on the storage device of the save source.

When it becomes necessary to access the data in the physical file 102 saved in the MT 150, the physical file restoring means 122 of the physical file moving means 120 restores the physical file in the MT 150.

As described above, in the database division management system of this embodiment, the physical file of the database is divided into a plurality of physical files according to the frequency of use of the data, and the physical files of the divided plurality of physical files are divided. Since the less frequently used physical file is moved to the storage medium of another storage device such as a magnetic tape, it is possible to improve the usage efficiency of the storage device in which the physical file to be divided is stored.

(Embodiment 2) In the database division management system of the present invention, a process of logically accessing a plurality of divided physical files as one physical file will be described below.

FIG. 3 shows logically a plurality of physical files divided by the database division management system of this embodiment.
It is a figure which shows the process outline which accesses as one physical file.

In FIG. 3, 131 is a logical file definition means, 132 is a logical file access means, 310 is an external storage device, 320 is a memory, and 330 is logical file definition information.

As shown in FIG. 3, the physical file access means 130 of the database partition management system of this embodiment.
The logical file definition means 131 for recording the names of the plurality of divided physical files and the logical file definition information 330 indicating whether the physical files have been moved, and the access to the plurality of divided physical files. It has a logical file access means 132 for performing.

FIG. 4 is a diagram showing a schematic structure of the logical file definition information of the database partition management system of this embodiment.

In FIG. 4, 410 is a basic part, 420 is index definition information, 430 is related file name definition information, 431 is a configuration file name, and 432 is valid / invalid information.

As shown in FIG. 4, the logical file definition information 330 of the database partition management system of this embodiment is composed of a basic section 410, index definition information 420, and related file name definition information 430. Part 4
10 stores basic information about the file, such as file classification, file type, file creation date and time, and the index definition information 420 includes an index name, index key length, index record length, and a tree structure index in the file. Information such as index attributes and key items defining the index is stored, and the related file name definition information 430 includes a configuration file name 43 that is a file name of a plurality of divided physical files.
1 and the physical file is the physical file moving means 120.
Valid / invalid information 432 indicating whether the user has been moved by
Is stored.

In the database division management system of this embodiment, the logical file definition means 131 of the physical file access means 130 records the names of the physical files 101 and 102 which are the divided physical files in the configuration file name 431. .

If the physical file exists in the external storage device 310, the logical file definition information 131 records "valid" in the valid / invalid information 432 of the physical file, and the physical file Is moved from the external storage device 310 by the physical file moving means 120, the valid / invalid information 4 of the physical file
32 is recorded as “invalid”.

Next, when the application program 160 tries to access the physical file 100, the logical file access means 132 causes the logical file definition information 330.
, The name of the divided physical file is read from the configuration file name 431 of the related file name definition information 430, the physical file 101 and the physical file 102 are accessed, and the above access result is used as the application program 1
Pass to 60.

Further, the logical file access means 132
However, when trying to access the physical file 101 and the physical file 102, the valid / invalid information 432 of the physical file 102 is “invalid”, and the physical file 1
If 02 is saved in the MT 150, the physical file restoring unit 122 of the physical file moving unit 120 restores the physical file 102 in the MT 150 to the external storage device 310, and then accesses.

In the database division management system of this embodiment, a processing procedure for accessing a plurality of divided physical files will be described below.

FIG. 5 is a flow chart showing the sequential search processing procedure in the database partition management system of this embodiment.

As shown in FIG. 5, in the database division management system of this embodiment, the application program 160 is
In the case of performing a sequential search process of sequentially searching the data records 201 in the physical file 100 and reading a certain record, the logical file access unit 132 first accesses the logical file definition information 330 for the first access. It is determined whether it is a request (step 501).

When the access to the logical file definition information 330 is the first access request, the logical file access means 132 has the associated file name definition information 430.
In accordance with the order of the configuration file name 431 stored in, the record positioning is performed for the first record of the physical file 101 stored first (step 5
02, step 503).

The logical file access means 132 does not perform steps 502 and 503 when the access to the logical file definition information 330 is not the first access request, and thereafter the same processing as when it is the first access request. Returning to step S504, the position of the valid record is searched by searching the positioned record for a valid record which is a record to be searched (step 504).

It is confirmed whether or not the valid record can be retrieved (step 505). When the valid record can be retrieved, the valid record is read and passed to the application program 160, and the process is terminated (step 506).

When the valid record cannot be searched, it is confirmed according to the related file name definition information 430 whether or not there is a physical file next to the physical file currently being searched. When the validity / invalidity information of the next physical file is “invalid”, the physical file restoration unit 122 stores the physical file in the external storage device 310.
(Step 507).

If the next physical file does not exist, it is assumed that all the data have been searched, and the search result is passed to the application program 160, and the processing is terminated (step 508).

If the next physical file exists, it is positioned at the top record of the physical file (steps 509 and 510) and the process returns to step 504.

FIG. 6 is a flow chart showing the minimum data search processing procedure in the database partition management system of this embodiment.

As shown in FIG. 6, in the database division management system of this embodiment, the application program 160 is
In the case of performing the minimum data search process of searching the data record 201 in the physical file 100 and reading the minimum record, first, the logical file access means 132 is used.
Positions the physical file 101 stored first according to the order of the configuration file name 431 stored in the logical file definition information 330 (step 6).
01).

The key item data to be retrieved is zero data,
The index record having the minimum data for the index is input (step 602). The key item data of the input index record is stored as the minimum key item data of the physical file (step 6).
03).

According to the related file name definition information 430, it is confirmed whether or not there is a physical file next to the physical file 101 currently being searched (step 604).

If the next physical file exists, the physical file is positioned, and if the valid / invalid information of the next physical file is "invalid",
The physical file restoring means 122 restores and positions the physical file in the external storage device 310 (step 605) and returns to step 602.

If the next physical file does not exist, the minimum key item data stored in step 603 is searched for the physical file that stores the smallest value, and the record is positioned (step 60).
6). The record positioned in step 606 is read out and passed to the application program 160, and the process ends (step 607).

FIG. 7 is a flowchart showing a processing procedure for performing a sequential search in ascending key order in the database partition management system of this embodiment.

As shown in FIG. 7, in the database partition management system of this embodiment, when the application program 160 performs a sequential search process in ascending key order, first, a record having the same key item data as the previously input record. Is checked after the physical file (step 701).

If a record having the same key item data exists, the physical file having the record is positioned (step 702). If there is no physical file having the same key item, according to the order of file names stored in the related file name definition information 430,
The physical file stored first is positioned (step 703).

An index record having key item data next larger than the key item data of the record input last time is input (step 704). The key item data of the input index record is stored as the minimum key item data of the physical file (step 703).

According to the related file name definition information 430, it is confirmed whether or not there is a physical file next to the physical file 101 currently being searched (step 706).

If the next physical file exists, the physical file is positioned, and if the valid / invalid information of the next physical file is "invalid",
The physical file restoring means 122 restores and positions the physical file in the external storage device 310 (step 707) and returns to step 704.

If the next physical file does not exist, the physical file that stores the smallest value is searched from the key item data stored in step 705, and the record is positioned (step 708).
The record located in step 702 or step 708 is read out and passed to the application program 160, and the process ends (step 709).

As described above, according to the database partition management system of this embodiment, when there is an access request to the plurality of divided physical files, each of the divided physical files is individually accessed. To access, so combine the above-mentioned divided physical files into 1
The plurality of divided physical files can be logically accessed as one physical file without creating one physical file.

(Embodiment 3) A process of backing up a plurality of divided physical files in the database division management system of the present invention will be described below.

FIG. 8 is a diagram showing a processing outline of backup of a plurality of divided physical files in the database division management system of this embodiment.

In FIG. 8, reference numeral 141 is backup recording means, 142 is partial backup means, 801 is backup information, 802 is reference time, and 803 is update time.

As shown in FIG. 8, the physical file backup means 14 of the database partition management system of this embodiment.
0 is backup recording means 141 for recording backup information 801 indicating when the backup was performed.
And a partial backup means 142 for backing up a physical file that has been updated since the previous backup.

Further, at the access time 202 of the physical file 101 of the database division management system of this embodiment, the reference time 802 indicating the time at which the access for referring to the data was made and the access for updating the data were made. The update time 803 indicating the time is recorded. The update time 803 in this embodiment is an update time that is a part of the usage frequency information recorded by the data access recording unit 111,
Alternatively, it may be the latest update time of the physical file recorded by the conventional file management technique.

The backup recording means of the physical file backup means 140 of the database division management system of this embodiment records the time of the backup in the backup information 801 when the plurality of divided physical files are backed up. To do.

The partial backup means 142 of the physical file backup means compares the previous backup time recorded in the backup information 801 of the physical file 101 with the update time 803, and updates the physical file after the previous backup. Is selected, the selected physical file is copied to the MT 170 and backup processing is performed.

In the first backup after the physical file is divided, since the previous backup time is not recorded in the backup information 801, all the plurality of divided physical files are copied to the MT 170 and backup processing is performed.

As described above, according to the database partition management system of this embodiment, when backing up the plurality of divided physical files, only the physical files updated after the previous backup are backed up. Therefore, it is possible to improve the backup efficiency of the physical file.

Although the present invention has been specifically described based on the above embodiments, the present invention is not limited to the above embodiments, and various modifications can be made without departing from the scope of the invention. Of course.

For example, in the database division management system of this embodiment, the access time is used as the data usage frequency, but the access frequency or the access frequency per unit time may be used as the data usage frequency.
Instead of the dynamically changing measurement value as described above, the static use frequency may be set according to the content of the stored data.

Further, in the database partition management system of the present embodiment, the divided physical files with low frequency of use are moved to the magnetic tape, but they are moved to another storage medium such as a magneto-optical disk having a different access speed. You can
Also, a physical file that is frequently used may be moved to a high-speed storage device such as a semiconductor disk.

[0104]

The effects obtained by the typical ones of the inventions disclosed in the present application will be briefly described as follows.

That is, the physical file of the database is divided into a plurality of physical files according to the frequency of use of data, and the physical file is divided into storage media of another storage device according to the frequency of use of the plurality of divided physical files. It is possible to improve the usage efficiency of the storage device in which the physical file to be divided is stored.

Further, when there is an access request to the plurality of divided physical files, the plurality of divided physical files are individually accessed, so that the plurality of divided physical files are integrated. It is possible to access the plurality of divided physical files logically as one physical file without creating one physical file.

Further, when backing up the plurality of divided physical files, only the physical files that have been updated since the previous backup are backed up, so the efficiency of backing up the physical files can be improved. is there.

[Brief description of drawings]

FIG. 1 is a diagram showing a processing outline of an embodiment of a database division management system of the present invention.

FIG. 2 is a diagram showing an outline of processing for dividing and moving a physical file of a database in the database division management system according to the first embodiment.

FIG. 3 is a diagram showing a processing outline for logically accessing a plurality of physical files divided by the database division management system of the second embodiment as one physical file.

FIG. 4 is a diagram showing a schematic configuration of logical file definition information of the database partition management system according to the second embodiment.

FIG. 5 is a flowchart showing a processing procedure of sequential search in the database partition management system according to the second embodiment.

FIG. 6 is a flowchart showing a processing procedure of minimum data search in the database division management system according to the second embodiment.

FIG. 7 is a flowchart showing a processing procedure for performing a sequential search in an ascending key order in the database partition management system according to the second embodiment.

FIG. 8 is a diagram showing a processing outline of backup of a plurality of divided physical files in the database division management system according to the third embodiment.

[Explanation of Codes] 100 ... Physical File, 101 ... Physical File, 102
... physical file, 110 ... physical file dividing means, 12
0 ... Physical file moving means, 130 ... Physical file access means, 140 ... Physical file backup means.

 ─────────────────────────────────────────────────── ─── Continuation of the front page (72) Hideo Fukuda Inventor Hideo Fukuda 6-81 Onoe-cho, Naka-ku, Yokohama-shi, Kanagawa Hitachi Software Engineering Co., Ltd. (72) Inventor Takashi Motokawa Onou-cho, Naka-ku, Yokohama-shi, Kanagawa Address 81 Hitachi Software Engineering Stock Association In-house

Claims (3)

[Claims] 1. A physical file dividing means for dividing a physical file of a database into a plurality of physical files according to the frequency of use of data, and a use frequency information of a plurality of physical files divided by the physical file dividing means. A database division management system comprising physical file moving means for moving the physical file between a plurality of storage devices, wherein the physical file dividing means is stored for each fixed area in a physical file to be divided. Data access recording means for recording the usage frequency of data, and divided physical file creation means for creating a plurality of physical files by dividing the physical file according to the usage frequency information recorded by the data access recording means The physical file moving means is an object that is used less frequently according to the use frequency information. A physical file saving means for saving a file to another storage device; a physical file deleting means for deleting the physical file saved by the physical file saving means from the save source storage device; and a physical file saving means for saving the file. A database partition management system comprising: a physical file restoring means for restoring the physical file from the storage device of the save destination as needed. 2. A database division management system comprising physical file access means for logically accessing a plurality of divided physical files as one physical file, wherein the physical file access means is the divided A logical file definition means for recording the names of a plurality of physical files and the logical file definition information indicating whether or not the plurality of divided physical files have been moved by the physical file moving means, and the plurality of divided physical files. The logical file access means for executing the access request by referring to the logical file definition information recorded by the logical file definition means when there is an access request for the file. Described database partition management system. 3. A database division management system comprising physical file backup means for backing up a physical file that has been updated since a previous backup among a plurality of divided physical files, wherein the physical file backup is provided. Means, backup recording means for recording the backup information indicating when the backup of the plurality of divided physical files was performed, the backup information recorded by the backup recording means and the update date and time of the physical file. 3. The database partition management system according to claim 2, further comprising: partial backup means for backing up a physical file that has been updated since the previous backup as needed.