US20040098423A1 - Method for determining execution of backup on a database - Google Patents
Method for determining execution of backup on a database Download PDFInfo
- Publication number
- US20040098423A1 US20040098423A1 US10/428,591 US42859103A US2004098423A1 US 20040098423 A1 US20040098423 A1 US 20040098423A1 US 42859103 A US42859103 A US 42859103A US 2004098423 A1 US2004098423 A1 US 2004098423A1
- Authority
- US
- United States
- Prior art keywords
- backup
- amount
- main processing
- processing
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1458—Management of the backup or restore process
- G06F11/1461—Backup scheduling policy
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/81—Threshold
Definitions
- the present invention relates to a method for determining the execution timing of backup of a database in a database management system.
- a database management system (hereinafter referred to as the “DBMS”) has been utilized in a wide range of fields such as a customer management system and a commodity management system.
- DBMS database management system
- the maintenance of data or the maintenance of operations in preparation for possible failures plays an important role.
- One good example of the maintenance of operations is the backup of a database.
- Methods for getting the database backup include an off-line backup which is performed by shutting down the DBMS and an on-line backup which is carried out while operating the DBMS.
- a plan to shut down the DBMS during an appropriate time frame, or a backup plan is prepared by a database administrator in advance.
- a presumable backup plan is to execute backup by shutting down the DBMS according to the plan after work hours on weekdays and on holidays as well. Since it is necessary to complete the backup procedures within a short period of time if they are to be carried out after work hours on weekdays, a differential backup is executed to acquire the backup only for the portion that has been updated since the previous backup. While on holidays, a full backup is executed to get the backup of the whole database since plenty of time is available in this case.
- an on-line backup is utilized to achieve backup while operating the DBMS.
- the on-line backup may affect the work process which should constitute the main processing of the DBMS (hereinafter referred to as the “main processing”) while executing the backup, thus causing a possible delay in the processing. Accordingly, in order to perform backup without inducing any delay in the main processing even during the on-line backup, it is necessary to prepare a backup plan which executes backup during a time frame in which an amount of main processing of a database is smaller.
- the busy rate is used as an index to represent the amount of main processing.
- the busy rate implies a rate of disk accessing time for read or write per unit time.
- a backup execution conditions input function 1201 information including a threshold value to determine the executability of backup (backup executability reference value 1216 ) is input after comparing the respective busy rates of a date and time zone in which backup should be executed (backup candidate time zone 1214 ), time which is predicted to be necessary for backup (predicted backup time 1215 ), and a backup candidate time zone.
- a busy rate extraction function 1203 under the assumption that work has periodicity and the busy rate of a database changes in a cycle, busy rates that have been accumulated in a busy rate database 1212 are extracted.
- the cycle is presumed to be one year, and a busy rate 1217 during a backup candidate time zone on the same day, same week and same month of previous year is extracted.
- a time zone where the busy rate is sufficiently small namely, a time zone in which a busy rate is not exceeding the backup executability reference value 1216 is searched for among the busy rates that have already extracted, and an instruction is issued to a backup execution management function 1205 to execute backup in that time zone (in the above-stated prior art, such instruction information is called the backup execution plan).
- a method for increasing the value of the backup executability reference value 1216 and searching for a time zone in which a busy rate is not exceeding the backup executability reference value 1216 again.
- the backup execution management function 1205 manages a backup execution plan created in a backup execution plan creating function 1202 , and executes a backup execution utility 1206 when the time zone determined by above-stated backup execution time frame determining function 1204 is reached.
- FIG. 13 A method for determining a backup time frame according to the above-stated prior art will be described by referring to FIG. 13.
- the busy rate changes at a one-year cycle as described in the above.
- the vertical axis indicates busy rate
- the horizontal axis indicates time.
- a busy rate 1301 on the same day, same week and same month of previous year (t1 ′ to t2′) is extracted, under the presumption that such busy rate has a one-year cycle, and then the busy rate is applied as an assessed value of the busy rate 1302 for the backup candidate time zone 1214 (t1 to t2).
- the object of the present invention is to determine execution of on-line backup so as to reduce adverse affects on main processing by the on-line backup even in a case where changes in an amount of processing of the DBMS is not periodical.
- a point of time when the amount of a work processing which should be the core of the DBMS (the amount of main processing) is small is determined to execute backup.
- the amount of main processing specifically includes a busy rate of a disk, and an amount of transaction per unit time of a database.
- a main processing index is used as an index to determine whether a period of time which is assumed to be needed for the backup is long or short.
- the main processing index is a value obtained such that changes in the amount of main processing during the time frame estimatingly required for backup of a database is estimated from some amounts of main processing and the magnitude of the main processing during the time frame is to be represented by the single value, such as a maximum value or an average value thereof.
- To calculate a main processing index the amount of main processing of a database is first obtained, and then an approximate expression for changes in the amount of main processing is derived from the amount of main processing thus obtained.
- Such approximate expression could conceivably be a linearized approximation, or an approximation using a quadratic or a cubic curve.
- a maximum value or an average value can be used.
- the maximum value or the average value of the amount of main processing during the backup time is calculated or determined as the main processing index.
- Another possible method is that, from the amount of main processing obtained from the database, the maximum value or the average value is obtained directly from the amount of main processing obtained from the database.
- an index to determine the volume of the amount of main processing during the time frame estimatingly needed for backup may be used as the main processing index.
- a backup execution timing is determined by referring to the amount of past main processing, under the assumption that the amount of main processing of a database should change periodically.
- the backup executability is determined by judging the load of the amount of main processing at that time on the basis of the main processing index.
- the present invention since the last amount of main processing of a database is obtained and backup is executed by predicting changes in the amount of main processing from the determining point in time, it is possible to determine execution of on-line backup in the manner to avoid a time frame when the amount of main processing is large, and reduce adverse affects of the on-line backup on the main processing, even in the case where changes in the amount of main processing is not periodical.
- FIG. 1 is a diagram showing a processing flow of a method for determining execution of backup according to the present invention
- FIG. 2 is a diagram showing the principle of the method for determining execution of backup according to the present invention
- FIG. 3 is a diagram showing a system configuration according to a first embodiment
- FIG. 4 is a diagram showing another system configuration according to the first embodiment
- FIG. 5 shows an example of backup execution conditions according to the first preferred embodiment
- FIG. 6 is a flow chart illustrating a method for determining execution of backup according to the first invention
- FIG. 7 is a flow chart for obtaining a main processing index according to the first embodiment
- FIG. 8 is a flow chart of a processing program to obtain a busy rate according to the first preferred embodiment
- FIG. 9 is a flow chart for obtaining a main processing index according to a second preferred embodiment
- FIG. 10 shows an example of backup execution conditions according to a third preferred embodiment
- FIG. 11 is a flow chart of a method for determining execution of backup according to the third preferred embodiment
- FIG. 12 is ad diagram showing a prior art processing flow
- FIG. 13 is a diagram showing a prior art method for determining a backup time.
- the present invention determines, at a certain random time, the size of an amount of work processing which should be the core of the DBMS (hereinafter referred to as the amount of main processing), and executes backup if the amount of main processing is small.
- a busy rate which is a rate of a disk access time for read/write of a disk per unit of time, or an amount of transaction of a database can be used as an index to measure the size of the amount of main processing.
- Factors other than the above may be used if they should constitute values representing the amount of main processing.
- an index used to presume the size of the amount of main processing from moment to moment is mandatory.
- such an index shall be called the main processing index.
- the main processing index is a value obtained such that changes in the amount of main processing during the time frame estimatingly required for backup of a database is estimated from some amounts of main processing and the magnitude of the main processing during the time frame is to be represented by the single value, such as amaximum value or an average value thereof.
- the amount of main processing of a database is first obtained, and then an approximate expression for changes in the amount of main processing is derived from the amount of main processing thus obtained.
- Such approximate expression could conceivably be a linearized approximation, or an approximation using a quadratic or a cubic curve.
- a maximum value or an average value can be used.
- the maximum value or the average value of the amount of main processing during the backup time is calculated or determined as the main processing index.
- Another possible method is that, from the amount of main processing obtained from the database, the maximum value or the average value is obtained directly from the amount of main processing obtained from the database.
- an index to determine the volume of the amount of main processing during the time frame estimatingly needed for backup may be used as the main processing index.
- Methods for calculating an average value of the amounts of main processing in the predicted backup time zone may include the calculation of an average value of the amounts of main processing for the acquisition number of the amounts of main processing. Those indices other than the above may be used if they can indicate changes in the amount of main processing during backup.
- a function according to the present invention when a function according to the present invention is initiated by a database administrator or a scheduler application, first, in a backup execution conditions input function 101 , a parameter (conditions for backup execution 106 ) that is used to determine the execution of backup is input.
- the conditions for backup execution 106 includes a backup executability reference value 108 which is a threshold value to determine the executability of the backup, and a predicted backup time 111 which is a predicted time required for the backup.
- a backup execution determining function 102 is initiated to extract, in busy rate extraction 103 , a busy rate required for calculating the main processing index from a busy rate database 1211 . Then, the main processing index is calculated based on the busy rate extracted in main processing index computation 104 , and, in backup execution determining processing 105 , if the main processing index is equal to the backup executability reference value or smaller, the backup is determined to be executable, thus exiting the backup execution determining function.
- the number of times to acquire the amount of main processing can be changed by incorporating the number of acquisition times of busy rate that is used to calculate the main processing index in the number of main processing amount acquisitions 107 which is a parameter to be input to the conditions for backup execution. Increasing the value of the number of main processing amount acquisitions 107 will improve the accuracy of the main processing index.
- an interval to acquire the amount of main processing can be changed by incorporating an acquisition interval 110 in the parameter which is used to input an interval to acquire the amount of main processing in the conditions for backup.
- the load of acquiring the processing amount may increase for the main processing, but by providing an arrangement which enables the variable setting of the acquisition interval, the value can be adjusted to be adequate in accordance with the usage style or the operation method of the DBMS.
- the busy rate acquisition function 1208 adapted to acquire the busy rate of a database is initiated by the backup execution determining function 102 after inputting conditions for backup execution, and acquires the busy rate designated by the number of main processing amount acquisitions 107 . Then, such busy rate is accumulated in the busy rate database 1211 by the busy rate acquisition function 1211 .
- the busy rate acquisition function 1208 may be initiated independent of the backup execution determining function 102 to accumulate the busy rate in the busy rate database 1211 in advance, and the busy rate extraction function 1212 may provide the main processing amount 112 to the backup execution determining function 102 .
- backup since backup will not be executed unless the main processing index becomes equal to the backup executability reference value 108 or less, there may be a case where the backup cannot be executed forever. Possible solutions for dealing with such case could conceivably include a method for providing a maximum deferred period 109 in the conditions for backup execution 106 . If it is determined that backup will not be completed even after the maximum deferred period 109 has elapsed since the initiation of the backup execution determining function 102 , or more specifically, when the present time has passed the “(start time of the backup execution determining function + the maximum deferred period) —the predicted backup time”, the backup will be initiated irrespective of the result of comparison between the main processing index and the backup executability reference value 108 .
- FIG. 2 is a diagram describing the principle of main processing amount calculation according to the present invention.
- the amount of main processing which is necessary for the calculation of the main processing index is acquired before a point in time 207 when it is determined whether or not to execute backup (points in time t1, t2 and t3 as shown in FIG. 2).
- the main processing index is calculated based on the pre-acquired amount of main processing.
- an approximate expression 208 for the amount of main processing shall be calculated from t1 to t3, and the maximum value of the main processing amount during a predicted backup time 206 shall be the main processing index.
- the main processing index thus calculated is compared with the backup executability reference value 108 , and if the main processing index is equal to the backup executability reference value 108 or smaller, backup will be executed.
- the amount of main processing of a database is acquired and the main processing index is calculated. Thereafter, the main processing index is compared with the backup executability reference value 108 to determine execution of backup. For the main processing index, an approximate expression is obtained based on the amount of main processing obtained in the above, and then, the maximum value of the amount of main processing during the predicted backup time is calculated by using the approximate expression.
- FIG. 3 shows a system configuration according to the first embodiment.
- the present invention is applicable to a general computing system comprising a central processing unit (CPU) 301 , a display 302 , a keyboard 303 , a drive for portable medium 304 , a communication control unit 305 , a main memory 306 , a magnetic disk unit 307 and a system bus 320 .
- CPU central processing unit
- main memory main memory
- magnetic disk unit 307 a magnetic disk unit
- the CPU 301 executes various programs used in the present invention.
- the display 302 is used to display the execution status, the execution result, etc. of processing.
- the keyboard 303 is used to input commands to instruct the execution of the database control system, etc.
- the drive for portable medium 304 is used to write and read data to, and from portable medium 322 such as a floppy (R) disk, a magnet-optical disk, and a write-once-read-many magnet-optical disk.
- the communication control unit 305 is used for communication via a network 321 .
- the main memory 306 is used to store various programs to be used in the present invention and temporarily store data.
- the magnetic disk unit 307 is used to store databases and definition information related to such databases.
- the system bus 320 is used to connect the above-stated devices.
- the magnetic disk unit 307 keeps a database storage area 317 , a backup conditions storage area 318 and a main processing amount storage area 319 .
- the main memory 306 holds an application program 308 , a database control system program 309 , a backup execution determining program 311 , a system program 315 and a work area 316 .
- the database control system program 309 includes a database operation management utility 310 which conducts backup or status analysis of a database.
- the application program 308 provides users with services by using the database control system program 309 .
- the database control system program 309 executes operations and control of a database.
- the backup execution determining program 311 inputs conditions for determining the backup executability as shown in FIG. 5, and determines the execution of backup based on the amount of main processing.
- the system program 315 provides basic functions to execute various programs to be used in the present invention including outputs and inputs of data to and from peripheral equipment.
- the system program 315 incorporates a system clock, and retains the present date and time.
- the work area 316 is used to store data that are temporarily needed during the execution of a program.
- the database storage area 317 is used to store a database and definition information related to the database concerned.
- the backup conditions storage area 318 is used to store backup conditions to be input while executing the backup execution determining program 311 .
- the main processing amount storage area 319 stores the amount of main processing acquired while executing the backup execution determining program 311 in accordance with the time series. It should be noted, however, the backup conditions storage area 318 or the main processing amount storage area 319 may be stored in a memory or an ordinary file, not in the magnetic disk unit 307 .
- a program to be used in the present invention is installed in the main memory 306 via the portable medium 322 or the network 321 .
- the program shall be pre-stored in the portable medium 322 .
- FIG. 5 shows an example of parameters input to the backup execution determining program 311 .
- the number of main processing amount acquisitions 501 specifies acquisition times of the amount of main processing to calculate the main processing index.
- the example shown in FIG. 5 exemplifies that the main processing amount is acquired three times in advance to calculate the main processing index.
- a backup executability reference value 502 is a threshold value used for the comparison with the main processing index to determine the backup executability.
- FIG. 5 shows a case of specifying a sufficiently small amount of main processing to execute backup, and shows that, for example, with an assumption that the busy rate is used as the amount of main processing, the threshold value has been set in the manner that the backup is determined to be executable if the busy rate is 40% or less.
- a maximum deferred period 503 sets a deferred period during which the backup execution determination is continued.
- the main processing index is equal to the backup executability reference value 502 or larger and therefore the backup execution is determined to be impossible, another comparison is conducted with the acquisition of amount of main processing, the calculation of the main processing index and the backup executability reference value, respectively.
- the main processing index will not be smaller than the backup executability reference value 502 , and therefore the backup may not be executed for a long period of time. To address such problem, it will be so arranged that the maximum deferred period is prepared in advance.
- the backup execution determining program After the backup execution determining program is initiated, if it is determined that backup will not be completed after the maximum deferred period 503 has elapsed, or more specifically, when the present time has passed the “(start time of the backup execution determining function + the maximum deferred period) —the predicted backup time”, the backup will be initiated irrespective of the result of comparison between the main processing index and the backup executability reference value 502 .
- the acquisition interval 504 sets the interval to acquire the amount of main processing.
- the example in FIG. 5 shows that the amount of main processing is determined to acquire every one-minute.
- a predicted backup time 505 is a predicted value of time required to backup a database.
- the example in FIG. 5 shows that 20 minutes has been set for the predicted value of time required for database backup.
- the prediction of backup may be, for example, automatically set by the system by memorizing the period of time required for the previous backup.
- FIG. 6 is a process flow chart of the backup execution determining program 311 according to the first embodiment.
- a busy rate of disk (hereinafter simply referred to as the busy rate) is used as a means of expressing the amount of main processing.
- the busy rate implies a rate of disk accessing time for read or writes per unit time.
- the prior art is arranged to search for a time zone in which the amount of main processing is smaller than the backup executability reference value out of the amount of main processing acquired for each day or each time zone, by comparing all amount of main processing and backup executability reference values available in the predicted backup time.
- a main processing index which expresses the size of main processing in backup based on the acquired amount of main processing, and then the main processing index is compared with the backup executability reference value to determine the backup executability. More specifically, the amount of main processing during the backup time is predicted based on the main processing amount of a database in operation to determine the backup executability.
- the backup execution determining program 311 shown in FIG. 6 will be periodically initiated according to a backup plan specified by a database administrator, or it will be initiated as required.
- the program will be executed after the backup conditions shown in FIG. 5 are set to be input.
- the program acquires the present busy rate in step 601 and stores the busy rate thus acquired in step 602 .
- step 603 it is determined that the busy rate has been acquired more than the number of main processing amount acquisitions 501 since the flow is initiated. If the busy rate has been acquired more than the number of main processing amount, the process will advance to step 604 , and if not, the process will advance to step 607 .
- step 604 the latest busy rate is extracted in the number that is specified by the number of main processing amount acquisitions 501 based on busy rates accumulated in step 602 .
- step 605 the main processing index is calculated based on busy rates accumulated in step 602 .
- step 605 to calculate the main processing index Details of step 605 to calculate the main processing index will be shown in FIG. 7.
- step 701 an approximate expression for changes in the busy rate is calculated based on the acquired busy rates.
- step 702 the maximum value of busy rates available during the period of time between the present time and the predicted backup time 505 is calculated.
- step 703 the value thus obtained is set as the main processing index.
- a linear approximate expression is used as shown in FIG. 2
- the maximum values of main processing across the end points of the predicted backup time can be used.
- Such maximum values can be calculated by using general mathematical methods.
- step 606 the main processing index is compared with the backup executability reference value 502 that is specified in the backup conditions, and if the main processing index is equal to or smaller than the backup executability reference value 502 , the flow is terminated and backup is executed. While, if the main processing index is larger than the backup executability reference value 502 , the process advances to step 607 .
- step 607 it is determined whether or not backup will be completed before reaching the maximum deferred time 503 , if waited only for the acquisition interval 504 which is specified in the backup conditions. Judgment on whether or not backup is completed is conducted whether or not the maximum deferred time will be elapsed if the predicted backup time has passed over the present time.
- step 606 If the maximum deferred time 503 is passed over, backup will be executed regardless of the comparison result in step 606 . In the case where the maximum deferred time 503 is not passed over, waiting is made by the acquisition interval 504 in step 608 , and the process returns to step 601 .
- the result of the backup executability determination obtained through the backup execution judgment method of a database according to the present invention is displayed on the display 302 shown in FIG. 3. At this time, by concurrently displaying the graph shown in FIG. 2., it becomes possible to present to users related information which can be a ground for the backup executability determination. In addition, if the result obtained shows that the backup is not executable, it is possible to choose an adequate backup time frame by re-setting the conditions for backup execution 106 by using the keyboard 303 shown in FIG. 3 to implement the method according to the present invention.
- backup can be executed in a time frame in which the main processing of a database will be least liable to be affected, avoiding other time frames in which much more amounts of main processing are available.
- the system configuration is the same as that shown in FIG. 4.
- a parameter to input conditions for backup execution as well as a backup execution determining function are the same as those described in FIG. 6 for the first embodiment.
- step 605 to calculate the main processing index in the backup execution determining function shown in FIG. 6 is modified to step 901 shown in FIG. 9, wherein an average value of busy rates in the number of main processing acquisitions including the latest acquisition thereof is applied to the main processing index. For example, if the busy rates acquired are 40, 50 and 30 respectively, the average value of these three busy rates, that is 40, is used as the main processing index.
- backup can be executed in a time frame in which the main processing of a database will be least liable to be affected, avoiding other time frames in which much more main processing amounts are available. That is because a time zone which provides less load on the database can be determined as a time frame which is more appropriate than that for the first embodiment.
- a third preferred embodiment will be described.
- amounts of main processing of a database are acquired before calculating a main processing index, and then, a comparison is made between the main processing index and a backup executability reference value to perform backup execution determination.
- the main processing amounts acquired as they are used as the main processing index.
- the system configuration according to the third embodiment is the same as that shown in FIG. 4.
- the conditions for backup execution shown in FIG. 10 shall be set to be input. Parameters of the conditions for backup execution do not include the number of main processing acquisitions 1001 and a predicted backup time 1002 , but the other parameters of the conditions for backup execution are the same as those shown in FIG. 6.
- step 602 to 604 shown in FIG. 6 are not required as shown in FIG. 11.
- step 605 is not necessary as well, and therefore, the busy rate is used as it is in step 1102 .
- a time zone which provides less load on the database can be determined—by using an easier method than that of the first and the second embodiment, avoiding other time zones in which much more amounts of main processing are available, even in the case where changes in the main processing amount of a database is not periodical, backup can be executed in a time zone in which the main processing of the database will be least liable to be affected.
- FIG. 4 shows a configuration which is different from the system configuration shown in FIG. 3 for the first embodiment.
- all magnetic disk units 307 are controlled by an exclusive file server (NAS: Network Attached Storage) which is used by directly connecting to a network directly coupled to a system bus 320 .
- NAS Network Attached Storage
- FIG. 3 processing that is executed by the backup execution automatic determining program 311 on the main memory is executed within an NAS 402 .
- an NAS-linked program 401 is required to achieve linkage with the NAS 402 .
- the configuration shown in FIG. 5 can also be applied to the second and the third embodiment.
- backup can be executed in a time frame in which the main processing of the database will be least liable to be affected, avoiding other time frames in which much more main processing amounts are available even in the case where changes in the amounts of main processing of a database is not periodical, by performing the execution determination based on the amounts of main processing of the present database.
Abstract
Description
- The present invention relates to a method for determining the execution timing of backup of a database in a database management system.
- A database management system (hereinafter referred to as the “DBMS”) has been utilized in a wide range of fields such as a customer management system and a commodity management system. With such DBMS which boasts excellent reliability and availability, the maintenance of data or the maintenance of operations in preparation for possible failures plays an important role. One good example of the maintenance of operations is the backup of a database.
- Methods for getting the database backup include an off-line backup which is performed by shutting down the DBMS and an on-line backup which is carried out while operating the DBMS.
- As the off-line backup is being carried out, in general, a plan to shut down the DBMS during an appropriate time frame, or a backup plan is prepared by a database administrator in advance. For example, for a business-oriented DBMS being used in an enterprise, the DBMS can only be shut down after the work hours. Accordingly, a presumable backup plan is to execute backup by shutting down the DBMS according to the plan after work hours on weekdays and on holidays as well. Since it is necessary to complete the backup procedures within a short period of time if they are to be carried out after work hours on weekdays, a differential backup is executed to acquire the backup only for the portion that has been updated since the previous backup. While on holidays, a full backup is executed to get the backup of the whole database since plenty of time is available in this case.
- On the other hand, when the DBMS cannot be subjected to a planned shutdown due to the style of work or the usage of the DBMS, an on-line backup is utilized to achieve backup while operating the DBMS. However, the on-line backup may affect the work process which should constitute the main processing of the DBMS (hereinafter referred to as the “main processing”) while executing the backup, thus causing a possible delay in the processing. Accordingly, in order to perform backup without inducing any delay in the main processing even during the on-line backup, it is necessary to prepare a backup plan which executes backup during a time frame in which an amount of main processing of a database is smaller.
- With the Japanese Patent Laid-open No. 2000-347919 wherein on-line backup is executed during a time frame in which the amount of main processing is smaller, the busy rate is used as an index to represent the amount of main processing. Here, the busy rate implies a rate of disk accessing time for read or write per unit time.
- A processing flow of the above-stated prior art will be described by referring to FIG. 12. With the prior art stated above, it should be supposed that in a busy
rate acquisition function 1208, the busy rate of a database is periodically acquired by utilizing a busyrate acquisition utility 1210, and the busy rate thus acquired is accumulated on abusy rate database 1211 in the busyrate acquisition function 1208. - In a backup execution
conditions input function 1201, information including a threshold value to determine the executability of backup (backup executability reference value 1216) is input after comparing the respective busy rates of a date and time zone in which backup should be executed (backup candidate time zone 1214), time which is predicted to be necessary for backup (predicted backup time 1215), and a backup candidate time zone. - Then, in a busy
rate extraction function 1203, under the assumption that work has periodicity and the busy rate of a database changes in a cycle, busy rates that have been accumulated in abusy rate database 1212 are extracted. In the above-stated prior art, a description is made by quoting an example wherein the cycle is presumed to be one year, and a busy rate 1217 during a backup candidate time zone on the same day, same week and same month of previous year is extracted. - Next, in a backup execution
timing determining function 1204, a time zone where the busy rate is sufficiently small, namely, a time zone in which a busy rate is not exceeding the backupexecutability reference value 1216 is searched for among the busy rates that have already extracted, and an instruction is issued to a backupexecution management function 1205 to execute backup in that time zone (in the above-stated prior art, such instruction information is called the backup execution plan). In the above-stated prior art, considering a case where a time zone in which a busy rate is not exceeding the backupexecutability reference value 1216 cannot be found, a method for increasing the value of the backupexecutability reference value 1216, and searching for a time zone in which a busy rate is not exceeding the backupexecutability reference value 1216 again. With the example shown in FIG. 12, since thevalue 20 of the busy rate during 1:00 to 2:00, among busy rates 1217 during backup candidate time zone on the same day, same week and same month of previous year, is smaller than 30 of the backupexecutability reference value 1216 which should be the backup conditions, a backup execution plan is prepared so that backup may be executed within the time zone, judging that the busy rate is sufficiently small. - The backup
execution management function 1205 manages a backup execution plan created in a backup executionplan creating function 1202, and executes abackup execution utility 1206 when the time zone determined by above-stated backup execution timeframe determining function 1204 is reached. - A method for determining a backup time frame according to the above-stated prior art will be described by referring to FIG. 13. With the example shown in FIG. 13, it shall be presumed that the busy rate changes at a one-year cycle as described in the above. In the graph shown in FIG. 13, the vertical axis indicates busy rate, while the horizontal axis indicates time. In the busy
rate extraction function 1203 shown in FIG. 13, abusy rate 1301 on the same day, same week and same month of previous year (t1 ′ to t2′) is extracted, under the presumption that such busy rate has a one-year cycle, and then the busy rate is applied as an assessed value of the busy rate 1302 for the backup candidate time zone 1214 (t1 to t2). In the backup executiontiming determining function 1204 shown in FIG. 12, an interval in which any busy rate among the busy rates in the backup candidate time zone (t1 to t2) 1214 extracted in the above, more specifically, an interval in which the busy rate is not exceeding the backupexecutability reference value 1216, is searched for, and the time zone is determined as a backupexecution time zone 1303. - However, in recent years, the style of usage of the DBMS has been changing, and accordingly, such DBMS to be used by general people as those connected to the Internet have increased in number, in addition to such DBMS installed within an enterprise that is only used by limited persons. In addition, there is such DBMS that accepts accesses not only from domestic users, but also from overseas users, and with those cases, the amount of main processing will not always change periodically.
- Under such a situation, the method for determining backup time frame on the assumption of periodical changes in the amount of main processing as is the case of above-stated prior art cannot be applied. Even if such method is applied, there is a possibility that the actual main processing amount of the DBMS can not be obtained at the presumed predetermined time, and therefore, backup may be carried out at a time when the amount of main processing is large. As a result, the frequency of the main processing may increase during the execution of an on-line backup, thus causing adverse affects in the main processing of the DBMS such as a delay.
- Accordingly, to prevent adverse affects such as a delay during an on-line backup of the DBMS, it is necessary to acquire backup during a time zone in which the main processing of the DBMS is not affected.
- The object of the present invention is to determine execution of on-line backup so as to reduce adverse affects on main processing by the on-line backup even in a case where changes in an amount of processing of the DBMS is not periodical.
- A method for determining execution of backup to achieve the above-stated object will be described in the following.
- According to the present invention, a point of time when the amount of a work processing which should be the core of the DBMS (the amount of main processing) is small is determined to execute backup. Here, the amount of main processing specifically includes a busy rate of a disk, and an amount of transaction per unit time of a database.
- Since backup is not executed momentarily, a main processing index is used as an index to determine whether a period of time which is assumed to be needed for the backup is long or short. The main processing index is a value obtained such that changes in the amount of main processing during the time frame estimatingly required for backup of a database is estimated from some amounts of main processing and the magnitude of the main processing during the time frame is to be represented by the single value, such as a maximum value or an average value thereof. To calculate a main processing index, the amount of main processing of a database is first obtained, and then an approximate expression for changes in the amount of main processing is derived from the amount of main processing thus obtained. Such approximate expression could conceivably be a linearized approximation, or an approximation using a quadratic or a cubic curve. In addition to an approximate expression, a maximum value or an average value can be used. Next, from the approximate expression thus obtained, the maximum value or the average value of the amount of main processing during the backup time is calculated or determined as the main processing index. Another possible method is that, from the amount of main processing obtained from the database, the maximum value or the average value is obtained directly from the amount of main processing obtained from the database. In addition to the above-stated methods, an index to determine the volume of the amount of main processing during the time frame estimatingly needed for backup may be used as the main processing index.
- With the above-described prior art, a backup execution timing is determined by referring to the amount of past main processing, under the assumption that the amount of main processing of a database should change periodically. However, with the present invention, even in a case where the amount of main processing of a database does not change periodically, the backup executability is determined by judging the load of the amount of main processing at that time on the basis of the main processing index.
- According to the present invention, since the last amount of main processing of a database is obtained and backup is executed by predicting changes in the amount of main processing from the determining point in time, it is possible to determine execution of on-line backup in the manner to avoid a time frame when the amount of main processing is large, and reduce adverse affects of the on-line backup on the main processing, even in the case where changes in the amount of main processing is not periodical.
- FIG. 1 is a diagram showing a processing flow of a method for determining execution of backup according to the present invention;
- FIG. 2 is a diagram showing the principle of the method for determining execution of backup according to the present invention;
- FIG. 3 is a diagram showing a system configuration according to a first embodiment;
- FIG. 4 is a diagram showing another system configuration according to the first embodiment;
- FIG. 5 shows an example of backup execution conditions according to the first preferred embodiment;
- FIG. 6 is a flow chart illustrating a method for determining execution of backup according to the first invention;
- FIG. 7 is a flow chart for obtaining a main processing index according to the first embodiment;
- FIG. 8 is a flow chart of a processing program to obtain a busy rate according to the first preferred embodiment;
- FIG. 9 is a flow chart for obtaining a main processing index according to a second preferred embodiment;
- FIG. 10 shows an example of backup execution conditions according to a third preferred embodiment;
- FIG. 11 is a flow chart of a method for determining execution of backup according to the third preferred embodiment;
- FIG. 12 is ad diagram showing a prior art processing flow; and
- FIG. 13 is a diagram showing a prior art method for determining a backup time.
- To begin with, the principle of the present invention will be described. The present invention determines, at a certain random time, the size of an amount of work processing which should be the core of the DBMS (hereinafter referred to as the amount of main processing), and executes backup if the amount of main processing is small. A busy rate which is a rate of a disk access time for read/write of a disk per unit of time, or an amount of transaction of a database can be used as an index to measure the size of the amount of main processing. Factors other than the above may be used if they should constitute values representing the amount of main processing. Here, since backup will not be finished momentarily, it is desirable that the amount of main processing should remain small during backup. Therefore, an index used to presume the size of the amount of main processing from moment to moment is mandatory. Hereinafter, such an index shall be called the main processing index.
- The main processing index is a value obtained such that changes in the amount of main processing during the time frame estimatingly required for backup of a database is estimated from some amounts of main processing and the magnitude of the main processing during the time frame is to be represented by the single value, such as amaximum value or an average value thereof. To calculate a main processing index, the amount of main processing of a database is first obtained, and then an approximate expression for changes in the amount of main processing is derived from the amount of main processing thus obtained. Such approximate expression could conceivably be a linearized approximation, or an approximation using a quadratic or a cubic curve. In addition to an approximate expression, a maximum value or an average value can be used. Next, from the approximate expression thus obtained, the maximum value or the average value of the amount of main processing during the backup time is calculated or determined as the main processing index. Another possible method is that, from the amount of main processing obtained from the database, the maximum value or the average value is obtained directly from the amount of main processing obtained from the database. In addition to the above-stated methods, an index to determine the volume of the amount of main processing during the time frame estimatingly needed for backup may be used as the main processing index.
- Methods for calculating an average value of the amounts of main processing in the predicted backup time zone may include the calculation of an average value of the amounts of main processing for the acquisition number of the amounts of main processing. Those indices other than the above may be used if they can indicate changes in the amount of main processing during backup.
- Next, a comparison is made between the main processing index and a preset threshold value (backup executability reference value). As a result of the comparison, if the main processing index is equal to the backup executability reference value or smaller, backup is executed, judging that the effect on the amount of main processing during the backup is small.
- Processing procedures according to the present invention will be described by referring to FIG. 1. Here, the description is made by using the busy rate of a disk as the amount of main processing. With the present invention, when a function according to the present invention is initiated by a database administrator or a scheduler application, first, in a backup execution
conditions input function 101, a parameter (conditions for backup execution 106) that is used to determine the execution of backup is input. The conditions forbackup execution 106 includes a backupexecutability reference value 108 which is a threshold value to determine the executability of the backup, and a predictedbackup time 111 which is a predicted time required for the backup. - Next, a backup
execution determining function 102 is initiated to extract, inbusy rate extraction 103, a busy rate required for calculating the main processing index from abusy rate database 1211. Then, the main processing index is calculated based on the busy rate extracted in mainprocessing index computation 104, and, in backupexecution determining processing 105, if the main processing index is equal to the backup executability reference value or smaller, the backup is determined to be executable, thus exiting the backup execution determining function. - According to the present invention, the number of times to acquire the amount of main processing can be changed by incorporating the number of acquisition times of busy rate that is used to calculate the main processing index in the number of main
processing amount acquisitions 107 which is a parameter to be input to the conditions for backup execution. Increasing the value of the number of mainprocessing amount acquisitions 107 will improve the accuracy of the main processing index. - In addition, in a similar way, an interval to acquire the amount of main processing can be changed by incorporating an
acquisition interval 110 in the parameter which is used to input an interval to acquire the amount of main processing in the conditions for backup. When the acquisition interval is too short, the load of acquiring the processing amount may increase for the main processing, but by providing an arrangement which enables the variable setting of the acquisition interval, the value can be adjusted to be adequate in accordance with the usage style or the operation method of the DBMS. - In FIG. 1, the busy
rate acquisition function 1208 adapted to acquire the busy rate of a database is initiated by the backupexecution determining function 102 after inputting conditions for backup execution, and acquires the busy rate designated by the number of mainprocessing amount acquisitions 107. Then, such busy rate is accumulated in thebusy rate database 1211 by the busyrate acquisition function 1211. However, alternatively, the busyrate acquisition function 1208 may be initiated independent of the backupexecution determining function 102 to accumulate the busy rate in thebusy rate database 1211 in advance, and the busyrate extraction function 1212 may provide themain processing amount 112 to the backupexecution determining function 102. - According to the present invention, since backup will not be executed unless the main processing index becomes equal to the backup
executability reference value 108 or less, there may be a case where the backup cannot be executed forever. Possible solutions for dealing with such case could conceivably include a method for providing a maximumdeferred period 109 in the conditions forbackup execution 106. If it is determined that backup will not be completed even after the maximumdeferred period 109 has elapsed since the initiation of the backupexecution determining function 102, or more specifically, when the present time has passed the “(start time of the backup execution determining function + the maximum deferred period) —the predicted backup time”, the backup will be initiated irrespective of the result of comparison between the main processing index and the backupexecutability reference value 108. - FIG. 2 is a diagram describing the principle of main processing amount calculation according to the present invention. With the present invention, the amount of main processing which is necessary for the calculation of the main processing index is acquired before a point in
time 207 when it is determined whether or not to execute backup (points in time t1, t2 and t3 as shown in FIG. 2). At a point in time of thebackup execution determination 207, the main processing index is calculated based on the pre-acquired amount of main processing. In the example shown in FIG. 2, anapproximate expression 208 for the amount of main processing shall be calculated from t1 to t3, and the maximum value of the main processing amount during a predictedbackup time 206 shall be the main processing index. The main processing index thus calculated is compared with the backupexecutability reference value 108, and if the main processing index is equal to the backupexecutability reference value 108 or smaller, backup will be executed. - Hereinafter, a first preferred embodiment according to the present invention will be described.
- In the first embodiment, the amount of main processing of a database is acquired and the main processing index is calculated. Thereafter, the main processing index is compared with the backup
executability reference value 108 to determine execution of backup. For the main processing index, an approximate expression is obtained based on the amount of main processing obtained in the above, and then, the maximum value of the amount of main processing during the predicted backup time is calculated by using the approximate expression. - FIG. 3 shows a system configuration according to the first embodiment. The present invention is applicable to a general computing system comprising a central processing unit (CPU)301, a
display 302, akeyboard 303, a drive forportable medium 304, acommunication control unit 305, amain memory 306, amagnetic disk unit 307 and asystem bus 320. - The
CPU 301 executes various programs used in the present invention. Thedisplay 302 is used to display the execution status, the execution result, etc. of processing. Thekeyboard 303 is used to input commands to instruct the execution of the database control system, etc. The drive forportable medium 304 is used to write and read data to, and from portable medium 322 such as a floppy (R) disk, a magnet-optical disk, and a write-once-read-many magnet-optical disk. Thecommunication control unit 305 is used for communication via anetwork 321. Themain memory 306 is used to store various programs to be used in the present invention and temporarily store data. Themagnetic disk unit 307 is used to store databases and definition information related to such databases. Thesystem bus 320 is used to connect the above-stated devices. - The
magnetic disk unit 307 keeps adatabase storage area 317, a backupconditions storage area 318 and a main processingamount storage area 319. - The
main memory 306 holds anapplication program 308, a databasecontrol system program 309, a backupexecution determining program 311, asystem program 315 and awork area 316. - In addition, the database
control system program 309 includes a databaseoperation management utility 310 which conducts backup or status analysis of a database. - The
application program 308 provides users with services by using the databasecontrol system program 309. The databasecontrol system program 309 executes operations and control of a database. - The backup
execution determining program 311 inputs conditions for determining the backup executability as shown in FIG. 5, and determines the execution of backup based on the amount of main processing. - The
system program 315 provides basic functions to execute various programs to be used in the present invention including outputs and inputs of data to and from peripheral equipment. In addition, thesystem program 315 incorporates a system clock, and retains the present date and time. Thework area 316 is used to store data that are temporarily needed during the execution of a program. - The
database storage area 317 is used to store a database and definition information related to the database concerned. The backupconditions storage area 318 is used to store backup conditions to be input while executing the backupexecution determining program 311. The main processingamount storage area 319 stores the amount of main processing acquired while executing the backupexecution determining program 311 in accordance with the time series. It should be noted, however, the backupconditions storage area 318 or the main processingamount storage area 319 may be stored in a memory or an ordinary file, not in themagnetic disk unit 307. - A program to be used in the present invention is installed in the
main memory 306 via theportable medium 322 or thenetwork 321. However, it should be noted that, in the case where theportable medium 322 is used, the program shall be pre-stored in theportable medium 322. - FIG. 5 shows an example of parameters input to the backup
execution determining program 311. Hereinafter, details of the parameters to be input will be shown. The number of mainprocessing amount acquisitions 501 specifies acquisition times of the amount of main processing to calculate the main processing index. The example shown in FIG. 5 exemplifies that the main processing amount is acquired three times in advance to calculate the main processing index. A backupexecutability reference value 502 is a threshold value used for the comparison with the main processing index to determine the backup executability. FIG. 5 shows a case of specifying a sufficiently small amount of main processing to execute backup, and shows that, for example, with an assumption that the busy rate is used as the amount of main processing, the threshold value has been set in the manner that the backup is determined to be executable if the busy rate is 40% or less. - A maximum
deferred period 503 sets a deferred period during which the backup execution determination is continued. As a result of comparison between the backupexecutability reference value 502 and the main processing index, if the main processing index is equal to the backupexecutability reference value 502 or larger and therefore the backup execution is determined to be impossible, another comparison is conducted with the acquisition of amount of main processing, the calculation of the main processing index and the backup executability reference value, respectively. However, it may be possible that the main processing index will not be smaller than the backupexecutability reference value 502, and therefore the backup may not be executed for a long period of time. To address such problem, it will be so arranged that the maximum deferred period is prepared in advance. With such arrangement, after the backup execution determining program is initiated, if it is determined that backup will not be completed after the maximumdeferred period 503 has elapsed, or more specifically, when the present time has passed the “(start time of the backup execution determining function + the maximum deferred period) —the predicted backup time”, the backup will be initiated irrespective of the result of comparison between the main processing index and the backupexecutability reference value 502. The example shown in FIG. 5 shows that it has been so arranged that the backup execution is initiated irrespective of the result of comparison between the main processing index and the backupexecutability reference value 502, if backup will not be completed after 60 minutes has elapsed since the initiation of the backup execution determining program, that is, if 40 minutes or longer has elapsed since the determination of backup because the predicted backup time is set at 20 minutes. - The
acquisition interval 504 sets the interval to acquire the amount of main processing. The example in FIG. 5 shows that the amount of main processing is determined to acquire every one-minute. A predictedbackup time 505 is a predicted value of time required to backup a database. The example in FIG. 5 shows that 20 minutes has been set for the predicted value of time required for database backup. The prediction of backup may be, for example, automatically set by the system by memorizing the period of time required for the previous backup. - FIG. 6 is a process flow chart of the backup
execution determining program 311 according to the first embodiment. - With the first embodiment, a busy rate of disk (hereinafter simply referred to as the busy rate) is used as a means of expressing the amount of main processing. Here, the busy rate implies a rate of disk accessing time for read or writes per unit time.
- In the prior art, it is arranged to search for a time zone in which the amount of main processing is smaller than the backup executability reference value out of the amount of main processing acquired for each day or each time zone, by comparing all amount of main processing and backup executability reference values available in the predicted backup time. On the other hand, with the present invention, a main processing index which expresses the size of main processing in backup based on the acquired amount of main processing, and then the main processing index is compared with the backup executability reference value to determine the backup executability. More specifically, the amount of main processing during the backup time is predicted based on the main processing amount of a database in operation to determine the backup executability.
- The backup
execution determining program 311 shown in FIG. 6 will be periodically initiated according to a backup plan specified by a database administrator, or it will be initiated as required. The program will be executed after the backup conditions shown in FIG. 5 are set to be input. The program acquires the present busy rate instep 601 and stores the busy rate thus acquired instep 602. Instep 603, it is determined that the busy rate has been acquired more than the number of mainprocessing amount acquisitions 501 since the flow is initiated. If the busy rate has been acquired more than the number of main processing amount, the process will advance to step 604, and if not, the process will advance to step 607. Instep 604, the latest busy rate is extracted in the number that is specified by the number of mainprocessing amount acquisitions 501 based on busy rates accumulated instep 602. Instep 605, the main processing index is calculated based on busy rates accumulated instep 602. - Details of
step 605 to calculate the main processing index will be shown in FIG. 7. Instep 701, an approximate expression for changes in the busy rate is calculated based on the acquired busy rates. Using the approximate expression obtained instep 702, the maximum value of busy rates available during the period of time between the present time and the predictedbackup time 505 is calculated. Instep 703, the value thus obtained is set as the main processing index. When a linear approximate expression is used as shown in FIG. 2, the maximum values of main processing across the end points of the predicted backup time can be used. For a case of approximation by using a quadratic or a cubic curve, it is necessary to calculate the maximum value within the predicted backup time. Such maximum values can be calculated by using general mathematical methods. - In
step 606, the main processing index is compared with the backupexecutability reference value 502 that is specified in the backup conditions, and if the main processing index is equal to or smaller than the backupexecutability reference value 502, the flow is terminated and backup is executed. While, if the main processing index is larger than the backupexecutability reference value 502, the process advances to step 607. Instep 607, it is determined whether or not backup will be completed before reaching the maximumdeferred time 503, if waited only for theacquisition interval 504 which is specified in the backup conditions. Judgment on whether or not backup is completed is conducted whether or not the maximum deferred time will be elapsed if the predicted backup time has passed over the present time. If the maximumdeferred time 503 is passed over, backup will be executed regardless of the comparison result instep 606. In the case where the maximumdeferred time 503 is not passed over, waiting is made by theacquisition interval 504 instep 608, and the process returns to step 601. - FIG. 6 shows a method for acquiring the busy rate within the backup
execution determining program 311. However, instead of the acquisition and the accumulation of the busy rate as are respectively performed insteps execution determining program 311, by separately creating a program to perform a processing to acquire the busy rate. - Incidentally, although an approximate expression for the busy rate acquired is herein used for calculating the main processing index, statistical methods in which the maximum value among the amounts of main processing acquired is designated to be the main processing index may be used.
- The result of the backup executability determination obtained through the backup execution judgment method of a database according to the present invention is displayed on the
display 302 shown in FIG. 3. At this time, by concurrently displaying the graph shown in FIG. 2., it becomes possible to present to users related information which can be a ground for the backup executability determination. In addition, if the result obtained shows that the backup is not executable, it is possible to choose an adequate backup time frame by re-setting the conditions forbackup execution 106 by using thekeyboard 303 shown in FIG. 3 to implement the method according to the present invention. - According to the first embodiment, even in the case where changes in the amount of main processing of a database is not periodical, backup can be executed in a time frame in which the main processing of a database will be least liable to be affected, avoiding other time frames in which much more amounts of main processing are available.
- Next, a second preferred embodiment according to the present invention will be described. In the second embodiment, amounts of main processing of a database are acquired before calculating a main processing index. Thereafter, a comparison is made between the main processing index and a backup executability reference value to perform backup execution determination. An average value of the amounts of main processing acquired is calculated for the main processing index.
- The system configuration is the same as that shown in FIG. 4. A parameter to input conditions for backup execution as well as a backup execution determining function are the same as those described in FIG. 6 for the first embodiment.
- In the second embodiment, step605 to calculate the main processing index in the backup execution determining function shown in FIG. 6 is modified to step 901 shown in FIG. 9, wherein an average value of busy rates in the number of main processing acquisitions including the latest acquisition thereof is applied to the main processing index. For example, if the busy rates acquired are 40, 50 and 30 respectively, the average value of these three busy rates, that is 40, is used as the main processing index.
- According to the second embodiment, even in the case where changes in the amount of main processing of a database is not periodical, backup can be executed in a time frame in which the main processing of a database will be least liable to be affected, avoiding other time frames in which much more main processing amounts are available. That is because a time zone which provides less load on the database can be determined as a time frame which is more appropriate than that for the first embodiment.
- Hereinafter, a third preferred embodiment will be described. In the third embodiment, amounts of main processing of a database are acquired before calculating a main processing index, and then, a comparison is made between the main processing index and a backup executability reference value to perform backup execution determination. The main processing amounts acquired as they are used as the main processing index.
- The system configuration according to the third embodiment is the same as that shown in FIG. 4. In the third embodiment, the conditions for backup execution shown in FIG.10 shall be set to be input. Parameters of the conditions for backup execution do not include the number of
main processing acquisitions 1001 and a predictedbackup time 1002, but the other parameters of the conditions for backup execution are the same as those shown in FIG. 6. - Since the third embodiment is arranged in such a manner as to acquire the amounts of main processing, steps602 to 604 shown in FIG. 6 are not required as shown in FIG. 11. In the third embodiment, since conditions for backup execution shown in FIG. 10 are input, and a busy rate acquired as the main processing index is applied as it is,
step 605 is not necessary as well, and therefore, the busy rate is used as it is instep 1102. These are points that are different from the first and the second embodiment. - According to the third embodiment, since a time zone which provides less load on the database can be determined—by using an easier method than that of the first and the second embodiment, avoiding other time zones in which much more amounts of main processing are available, even in the case where changes in the main processing amount of a database is not periodical, backup can be executed in a time zone in which the main processing of the database will be least liable to be affected.
- FIG. 4 shows a configuration which is different from the system configuration shown in FIG. 3 for the first embodiment. In the configuration shown in FIG. 4, all
magnetic disk units 307 are controlled by an exclusive file server (NAS: Network Attached Storage) which is used by directly connecting to a network directly coupled to asystem bus 320. In FIG. 3, processing that is executed by the backup execution automatic determiningprogram 311 on the main memory is executed within an NAS 402. In this case, an NAS-linked program 401 is required to achieve linkage with the NAS 402. In addition, the configuration shown in FIG. 5 can also be applied to the second and the third embodiment. - In the backup execution determining method according to the present invention, backup can be executed in a time frame in which the main processing of the database will be least liable to be affected, avoiding other time frames in which much more main processing amounts are available even in the case where changes in the amounts of main processing of a database is not periodical, by performing the execution determination based on the amounts of main processing of the present database.
Claims (10)
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
JP2002335928A JP2004171249A (en) | 2002-11-20 | 2002-11-20 | Backup execution decision method for database |
JP2002-335928 | 2002-11-20 |
Publications (2)
Publication Number | Publication Date |
---|---|
US20040098423A1 true US20040098423A1 (en) | 2004-05-20 |
US7421460B2 US7421460B2 (en) | 2008-09-02 |
Family
ID=32290357
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/428,591 Expired - Fee Related US7421460B2 (en) | 2002-11-20 | 2003-05-01 | Method for determining execution of backup on a database |
Country Status (2)
Country | Link |
---|---|
US (1) | US7421460B2 (en) |
JP (1) | JP2004171249A (en) |
Cited By (37)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20050262118A1 (en) * | 2004-05-21 | 2005-11-24 | Russell Witt | Uninterrupted database index reorganization/movement |
US20050262317A1 (en) * | 2004-05-24 | 2005-11-24 | Yoshifumi Nakanishi | Data processing apparatus and disk access control method with data replication for the same |
US7139846B1 (en) * | 2003-09-30 | 2006-11-21 | Veritas Operating Corporation | Computer system and method for performing low impact backup operations |
US7484119B2 (en) | 2004-11-05 | 2009-01-27 | International Business Machines Corporation | Method, apparatus, computer program and computer program product for adjusting the frequency at which data is backed up |
US20090083345A1 (en) * | 2007-09-26 | 2009-03-26 | Hitachi, Ltd. | Storage system determining execution of backup of data according to quality of WAN |
US20090216977A1 (en) * | 2004-12-06 | 2009-08-27 | Hitachi, Ltd. | Storage System and Snapshot Data Preparation Method in Storage System |
WO2009154806A1 (en) | 2008-06-18 | 2009-12-23 | Commvault Systems, Inc. | Data protection scheduling, such as providing a flexible backup window in a data protection system |
US20120265907A1 (en) * | 2011-04-12 | 2012-10-18 | Fujitsu Limited | Access method, computer and recording medium |
US8589354B1 (en) * | 2008-12-31 | 2013-11-19 | Emc Corporation | Probe based group selection |
US8788462B1 (en) * | 2008-12-31 | 2014-07-22 | Emc Corporation | Multi-factor probe triggers |
US8972352B1 (en) * | 2008-12-31 | 2015-03-03 | Emc Corporation | Probe based backup |
US20160162349A1 (en) * | 2013-03-07 | 2016-06-09 | Axcient, Inc. | Protection Status Determinations for Computing Devices |
US20160191437A1 (en) * | 2014-12-31 | 2016-06-30 | C. Douglass Thomas | Data Transmission Management for Computer Based Inter-User Communication |
US9705730B1 (en) | 2013-05-07 | 2017-07-11 | Axcient, Inc. | Cloud storage using Merkle trees |
US9785647B1 (en) | 2012-10-02 | 2017-10-10 | Axcient, Inc. | File system virtualization |
US9798629B1 (en) * | 2013-12-16 | 2017-10-24 | EMC IP Holding Company LLC | Predicting backup failures due to exceeding the backup window |
US9852140B1 (en) | 2012-11-07 | 2017-12-26 | Axcient, Inc. | Efficient file replication |
US10284437B2 (en) | 2010-09-30 | 2019-05-07 | Efolder, Inc. | Cloud-based virtual machines and offices |
US20200104051A1 (en) * | 2018-09-30 | 2020-04-02 | EMC IP Holding Company LLC | Method, device and computer program product of storage management |
US10776329B2 (en) | 2017-03-28 | 2020-09-15 | Commvault Systems, Inc. | Migration of a database management system to cloud storage |
US10776219B2 (en) | 2014-05-09 | 2020-09-15 | Commvault Systems, Inc. | Load balancing across multiple data paths |
US10831778B2 (en) | 2012-12-27 | 2020-11-10 | Commvault Systems, Inc. | Application of information management policies based on operation with a geographic entity |
US10838821B2 (en) | 2017-02-08 | 2020-11-17 | Commvault Systems, Inc. | Migrating content and metadata from a backup system |
EP3739454A1 (en) * | 2019-05-14 | 2020-11-18 | EMC IP Holding Company LLC | System and method for scalable backup services |
US10860401B2 (en) | 2014-02-27 | 2020-12-08 | Commvault Systems, Inc. | Work flow management for an information management system |
US10866756B2 (en) | 2016-11-11 | 2020-12-15 | Fujitsu Limited | Control device and computer readable recording medium storing control program |
CN112685220A (en) * | 2019-10-17 | 2021-04-20 | 伊姆西Ip控股有限责任公司 | Method, electronic device and computer program product for backing up data |
US11036400B2 (en) | 2019-04-26 | 2021-06-15 | EMC IP Holding Company LLC | System and method for limiting restoration access |
US11093336B2 (en) | 2013-03-11 | 2021-08-17 | Commvault Systems, Inc. | Browsing data stored in a backup format |
US11093346B2 (en) * | 2019-06-03 | 2021-08-17 | EMC IP Holding Company LLC | Uninterrupted backup operation using a time based approach |
US11099941B2 (en) | 2019-04-23 | 2021-08-24 | EMC IP Holding Company LLC | System and method for accelerating application service restoration |
US11106544B2 (en) | 2019-04-26 | 2021-08-31 | EMC IP Holding Company LLC | System and method for management of largescale data backup |
US11119685B2 (en) | 2019-04-23 | 2021-09-14 | EMC IP Holding Company LLC | System and method for accelerated data access |
US11163647B2 (en) | 2019-04-23 | 2021-11-02 | EMC IP Holding Company LLC | System and method for selection of node for backup in distributed system |
US11308034B2 (en) | 2019-06-27 | 2022-04-19 | Commvault Systems, Inc. | Continuously run log backup with minimal configuration and resource usage from the source machine |
US11392542B2 (en) | 2008-09-05 | 2022-07-19 | Commvault Systems, Inc. | Image level copy or restore, such as image level restore without knowledge of data object metadata |
US11573866B2 (en) | 2018-12-10 | 2023-02-07 | Commvault Systems, Inc. | Evaluation and reporting of recovery readiness in a data storage management system |
Families Citing this family (30)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7434219B2 (en) | 2000-01-31 | 2008-10-07 | Commvault Systems, Inc. | Storage of application specific profiles correlating to document versions |
EP1442387A4 (en) | 2001-09-28 | 2008-01-23 | Commvault Systems Inc | System and method for archiving objects in an information store |
US7797483B1 (en) * | 2004-06-23 | 2010-09-14 | Emc Corporation | Write interceptor for tracking changes to disk image |
JP4688617B2 (en) * | 2005-09-16 | 2011-05-25 | 株式会社日立製作所 | Storage control system and method |
JP4825485B2 (en) * | 2005-10-05 | 2011-11-30 | 株式会社東芝 | Data backup system |
US7734669B2 (en) | 2006-12-22 | 2010-06-08 | Commvault Systems, Inc. | Managing copies of data |
US8041679B1 (en) | 2008-06-04 | 2011-10-18 | Symantec Operating Corporation | Synthetic differential backups creation for a database using binary log conversion |
US8352954B2 (en) | 2008-06-19 | 2013-01-08 | Commvault Systems, Inc. | Data storage resource allocation by employing dynamic methods and blacklisting resource request pools |
US9128883B2 (en) | 2008-06-19 | 2015-09-08 | Commvault Systems, Inc | Data storage resource allocation by performing abbreviated resource checks based on relative chances of failure of the data storage resources to determine whether data storage requests would fail |
US20100070474A1 (en) | 2008-09-12 | 2010-03-18 | Lad Kamleshkumar K | Transferring or migrating portions of data objects, such as block-level data migration or chunk-based data migration |
US8886610B2 (en) * | 2009-10-01 | 2014-11-11 | Hewlett-Packard Development Company, L. P. | Backup simulation for backing up filesystems to a storage device |
JP5661347B2 (en) * | 2010-06-28 | 2015-01-28 | キヤノン株式会社 | Information processing apparatus and method |
US8849762B2 (en) | 2011-03-31 | 2014-09-30 | Commvault Systems, Inc. | Restoring computing environments, such as autorecovery of file systems at certain points in time |
US9176744B2 (en) * | 2011-05-20 | 2015-11-03 | Citrix Systems, Inc. | Quickly provisioning a virtual machine by identifying a path to a differential file during pre-boot |
US10157184B2 (en) | 2012-03-30 | 2018-12-18 | Commvault Systems, Inc. | Data previewing before recalling large data files |
US9805075B1 (en) * | 2012-12-28 | 2017-10-31 | EMC IP Holding Company LLC | Method and system for a data protection policy generator |
JP6081213B2 (en) * | 2013-02-12 | 2017-02-15 | 株式会社日立ソリューションズ | Business document processing device, business document processing program |
US9648100B2 (en) | 2014-03-05 | 2017-05-09 | Commvault Systems, Inc. | Cross-system storage management for transferring data across autonomous information management systems |
US9823978B2 (en) | 2014-04-16 | 2017-11-21 | Commvault Systems, Inc. | User-level quota management of data objects stored in information management systems |
US11249858B2 (en) | 2014-08-06 | 2022-02-15 | Commvault Systems, Inc. | Point-in-time backups of a production application made accessible over fibre channel and/or ISCSI as data sources to a remote application by representing the backups as pseudo-disks operating apart from the production application and its host |
US9852026B2 (en) | 2014-08-06 | 2017-12-26 | Commvault Systems, Inc. | Efficient application recovery in an information management system based on a pseudo-storage-device driver |
US9444811B2 (en) | 2014-10-21 | 2016-09-13 | Commvault Systems, Inc. | Using an enhanced data agent to restore backed up data across autonomous storage management systems |
US9766825B2 (en) | 2015-07-22 | 2017-09-19 | Commvault Systems, Inc. | Browse and restore for block-level backups |
US10296368B2 (en) | 2016-03-09 | 2019-05-21 | Commvault Systems, Inc. | Hypervisor-independent block-level live browse for access to backed up virtual machine (VM) data and hypervisor-free file-level recovery (block-level pseudo-mount) |
US10740193B2 (en) | 2017-02-27 | 2020-08-11 | Commvault Systems, Inc. | Hypervisor-independent reference copies of virtual machine payload data based on block-level pseudo-mount |
US10891069B2 (en) | 2017-03-27 | 2021-01-12 | Commvault Systems, Inc. | Creating local copies of data stored in online data repositories |
US11074140B2 (en) | 2017-03-29 | 2021-07-27 | Commvault Systems, Inc. | Live browsing of granular mailbox data |
US10664352B2 (en) | 2017-06-14 | 2020-05-26 | Commvault Systems, Inc. | Live browsing of backed up data residing on cloned disks |
US10795927B2 (en) | 2018-02-05 | 2020-10-06 | Commvault Systems, Inc. | On-demand metadata extraction of clinical image data |
US10789387B2 (en) | 2018-03-13 | 2020-09-29 | Commvault Systems, Inc. | Graphical representation of an information management system |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5758359A (en) * | 1996-10-24 | 1998-05-26 | Digital Equipment Corporation | Method and apparatus for performing retroactive backups in a computer system |
US5937163A (en) * | 1996-03-26 | 1999-08-10 | Industrial Technology Research Institute | Method and system at a host node for hierarchically organizing the links visited by a world wide web browser executing at the host node |
US6601058B2 (en) * | 1998-10-05 | 2003-07-29 | Michael Forster | Data exploration system and method |
US20030154211A1 (en) * | 2002-02-14 | 2003-08-14 | Fujitsu Limited | Methods of gathering and delivering information, terminal unit and server for information processing, and computer product |
US20030208511A1 (en) * | 2002-05-02 | 2003-11-06 | Earl Leroy D. | Database replication system |
US6877016B1 (en) * | 2001-09-13 | 2005-04-05 | Unisys Corporation | Method of capturing a physically consistent mirrored snapshot of an online database |
US20050210080A1 (en) * | 2004-03-18 | 2005-09-22 | Nobuyuki Saika | Backup system, backup method, and program therefor |
Family Cites Families (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH04235625A (en) | 1991-01-09 | 1992-08-24 | Nec Corp | Buffer control system |
JPH05120110A (en) | 1991-10-30 | 1993-05-18 | Hitachi Ltd | Automatic backup system for file |
JPH07262067A (en) | 1994-03-18 | 1995-10-13 | Nissin Electric Co Ltd | Network type file back-up device |
JPH1031562A (en) | 1996-07-17 | 1998-02-03 | Hitachi Ltd | Information processing system |
JP2000163288A (en) | 1998-11-30 | 2000-06-16 | Nec Corp | Data storage system, data rearranging method, and recording medium |
JP2000347919A (en) | 1999-06-07 | 2000-12-15 | Nec Corp | Automatic operation system for database on-line backup |
-
2002
- 2002-11-20 JP JP2002335928A patent/JP2004171249A/en active Pending
-
2003
- 2003-05-01 US US10/428,591 patent/US7421460B2/en not_active Expired - Fee Related
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5937163A (en) * | 1996-03-26 | 1999-08-10 | Industrial Technology Research Institute | Method and system at a host node for hierarchically organizing the links visited by a world wide web browser executing at the host node |
US5758359A (en) * | 1996-10-24 | 1998-05-26 | Digital Equipment Corporation | Method and apparatus for performing retroactive backups in a computer system |
US6601058B2 (en) * | 1998-10-05 | 2003-07-29 | Michael Forster | Data exploration system and method |
US6877016B1 (en) * | 2001-09-13 | 2005-04-05 | Unisys Corporation | Method of capturing a physically consistent mirrored snapshot of an online database |
US20030154211A1 (en) * | 2002-02-14 | 2003-08-14 | Fujitsu Limited | Methods of gathering and delivering information, terminal unit and server for information processing, and computer product |
US20030208511A1 (en) * | 2002-05-02 | 2003-11-06 | Earl Leroy D. | Database replication system |
US20050210080A1 (en) * | 2004-03-18 | 2005-09-22 | Nobuyuki Saika | Backup system, backup method, and program therefor |
Cited By (62)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7139846B1 (en) * | 2003-09-30 | 2006-11-21 | Veritas Operating Corporation | Computer system and method for performing low impact backup operations |
WO2005114480A2 (en) * | 2004-05-21 | 2005-12-01 | Computer Associates Think, Inc. | Uninterrupted database index reorganization/movement |
WO2005114480A3 (en) * | 2004-05-21 | 2006-03-02 | Computer Ass Think Inc | Uninterrupted database index reorganization/movement |
US20050262118A1 (en) * | 2004-05-21 | 2005-11-24 | Russell Witt | Uninterrupted database index reorganization/movement |
US8510269B2 (en) | 2004-05-21 | 2013-08-13 | Ca, Inc. | Uninterrupted database index reorganization/movement |
US20050262317A1 (en) * | 2004-05-24 | 2005-11-24 | Yoshifumi Nakanishi | Data processing apparatus and disk access control method with data replication for the same |
US7194575B2 (en) * | 2004-05-24 | 2007-03-20 | Hitachi, Ltd. | Automatic disk mirroring according to workload |
US7484119B2 (en) | 2004-11-05 | 2009-01-27 | International Business Machines Corporation | Method, apparatus, computer program and computer program product for adjusting the frequency at which data is backed up |
US8095822B2 (en) * | 2004-12-06 | 2012-01-10 | Hitachi, Ltd. | Storage system and snapshot data preparation method in storage system |
US20090216977A1 (en) * | 2004-12-06 | 2009-08-27 | Hitachi, Ltd. | Storage System and Snapshot Data Preparation Method in Storage System |
US20090083345A1 (en) * | 2007-09-26 | 2009-03-26 | Hitachi, Ltd. | Storage system determining execution of backup of data according to quality of WAN |
US7849058B2 (en) * | 2007-09-26 | 2010-12-07 | Hitachi, Ltd. | Storage system determining execution of backup of data according to quality of WAN |
US11321181B2 (en) | 2008-06-18 | 2022-05-03 | Commvault Systems, Inc. | Data protection scheduling, such as providing a flexible backup window in a data protection system |
EP2307998A4 (en) * | 2008-06-18 | 2013-03-13 | Commvault Systems Inc | Data protection scheduling, such as providing a flexible backup window in a data protection system |
EP2307998A1 (en) * | 2008-06-18 | 2011-04-13 | Commvault Systems, Inc. | Data protection scheduling, such as providing a flexible backup window in a data protection system |
WO2009154806A1 (en) | 2008-06-18 | 2009-12-23 | Commvault Systems, Inc. | Data protection scheduling, such as providing a flexible backup window in a data protection system |
US10198324B2 (en) | 2008-06-18 | 2019-02-05 | Commvault Systems, Inc. | Data protection scheduling, such as providing a flexible backup window in a data protection system |
US11392542B2 (en) | 2008-09-05 | 2022-07-19 | Commvault Systems, Inc. | Image level copy or restore, such as image level restore without knowledge of data object metadata |
US8589354B1 (en) * | 2008-12-31 | 2013-11-19 | Emc Corporation | Probe based group selection |
US8788462B1 (en) * | 2008-12-31 | 2014-07-22 | Emc Corporation | Multi-factor probe triggers |
US8972352B1 (en) * | 2008-12-31 | 2015-03-03 | Emc Corporation | Probe based backup |
US10284437B2 (en) | 2010-09-30 | 2019-05-07 | Efolder, Inc. | Cloud-based virtual machines and offices |
US8843672B2 (en) * | 2011-04-12 | 2014-09-23 | Fujitsu Limited | Access method, computer and recording medium |
US20120265907A1 (en) * | 2011-04-12 | 2012-10-18 | Fujitsu Limited | Access method, computer and recording medium |
US9785647B1 (en) | 2012-10-02 | 2017-10-10 | Axcient, Inc. | File system virtualization |
US9852140B1 (en) | 2012-11-07 | 2017-12-26 | Axcient, Inc. | Efficient file replication |
US11169714B1 (en) | 2012-11-07 | 2021-11-09 | Efolder, Inc. | Efficient file replication |
US10831778B2 (en) | 2012-12-27 | 2020-11-10 | Commvault Systems, Inc. | Application of information management policies based on operation with a geographic entity |
US11409765B2 (en) | 2012-12-27 | 2022-08-09 | Commvault Systems, Inc. | Application of information management policies based on operation with a geographic entity |
US9998344B2 (en) * | 2013-03-07 | 2018-06-12 | Efolder, Inc. | Protection status determinations for computing devices |
US10003646B1 (en) | 2013-03-07 | 2018-06-19 | Efolder, Inc. | Protection status determinations for computing devices |
US20160162349A1 (en) * | 2013-03-07 | 2016-06-09 | Axcient, Inc. | Protection Status Determinations for Computing Devices |
US11093336B2 (en) | 2013-03-11 | 2021-08-17 | Commvault Systems, Inc. | Browsing data stored in a backup format |
US10599533B2 (en) | 2013-05-07 | 2020-03-24 | Efolder, Inc. | Cloud storage using merkle trees |
US9705730B1 (en) | 2013-05-07 | 2017-07-11 | Axcient, Inc. | Cloud storage using Merkle trees |
US9798629B1 (en) * | 2013-12-16 | 2017-10-24 | EMC IP Holding Company LLC | Predicting backup failures due to exceeding the backup window |
US10860401B2 (en) | 2014-02-27 | 2020-12-08 | Commvault Systems, Inc. | Work flow management for an information management system |
US11119868B2 (en) | 2014-05-09 | 2021-09-14 | Commvault Systems, Inc. | Load balancing across multiple data paths |
US10776219B2 (en) | 2014-05-09 | 2020-09-15 | Commvault Systems, Inc. | Load balancing across multiple data paths |
US11593227B2 (en) | 2014-05-09 | 2023-02-28 | Commvault Systems, Inc. | Load balancing across multiple data paths |
US11303599B2 (en) | 2014-12-31 | 2022-04-12 | C. Douglass Thomas | Network-based messaging system with database management for computer based inter-user communication |
US11159468B2 (en) | 2014-12-31 | 2021-10-26 | Albert S. Penilla | Data transmission management for computer based inter-user communication |
US20160191437A1 (en) * | 2014-12-31 | 2016-06-30 | C. Douglass Thomas | Data Transmission Management for Computer Based Inter-User Communication |
US10652191B2 (en) * | 2014-12-31 | 2020-05-12 | C. Douglass Thomas | Data transmission management for computer based inter-user communication |
US10866756B2 (en) | 2016-11-11 | 2020-12-15 | Fujitsu Limited | Control device and computer readable recording medium storing control program |
US11467914B2 (en) | 2017-02-08 | 2022-10-11 | Commvault Systems, Inc. | Migrating content and metadata from a backup system |
US10838821B2 (en) | 2017-02-08 | 2020-11-17 | Commvault Systems, Inc. | Migrating content and metadata from a backup system |
US10776329B2 (en) | 2017-03-28 | 2020-09-15 | Commvault Systems, Inc. | Migration of a database management system to cloud storage |
US10949114B2 (en) * | 2018-09-30 | 2021-03-16 | EMC IP Holding Company, LLC | Data storage management devices using utilization rates and methods for data storage management using utilization rates |
US20200104051A1 (en) * | 2018-09-30 | 2020-04-02 | EMC IP Holding Company LLC | Method, device and computer program product of storage management |
US11573866B2 (en) | 2018-12-10 | 2023-02-07 | Commvault Systems, Inc. | Evaluation and reporting of recovery readiness in a data storage management system |
US11119685B2 (en) | 2019-04-23 | 2021-09-14 | EMC IP Holding Company LLC | System and method for accelerated data access |
US11163647B2 (en) | 2019-04-23 | 2021-11-02 | EMC IP Holding Company LLC | System and method for selection of node for backup in distributed system |
US11099941B2 (en) | 2019-04-23 | 2021-08-24 | EMC IP Holding Company LLC | System and method for accelerating application service restoration |
US11106544B2 (en) | 2019-04-26 | 2021-08-31 | EMC IP Holding Company LLC | System and method for management of largescale data backup |
US11036400B2 (en) | 2019-04-26 | 2021-06-15 | EMC IP Holding Company LLC | System and method for limiting restoration access |
US11061732B2 (en) | 2019-05-14 | 2021-07-13 | EMC IP Holding Company LLC | System and method for scalable backup services |
EP3739454A1 (en) * | 2019-05-14 | 2020-11-18 | EMC IP Holding Company LLC | System and method for scalable backup services |
US11093346B2 (en) * | 2019-06-03 | 2021-08-17 | EMC IP Holding Company LLC | Uninterrupted backup operation using a time based approach |
US11308034B2 (en) | 2019-06-27 | 2022-04-19 | Commvault Systems, Inc. | Continuously run log backup with minimal configuration and resource usage from the source machine |
US11829331B2 (en) | 2019-06-27 | 2023-11-28 | Commvault Systems, Inc. | Continuously run log backup with minimal configuration and resource usage from the source machine |
CN112685220A (en) * | 2019-10-17 | 2021-04-20 | 伊姆西Ip控股有限责任公司 | Method, electronic device and computer program product for backing up data |
Also Published As
Publication number | Publication date |
---|---|
JP2004171249A (en) | 2004-06-17 |
US7421460B2 (en) | 2008-09-02 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US7421460B2 (en) | Method for determining execution of backup on a database | |
US5471614A (en) | Database system concurrency control apparatus using timestamps and processing time estimation | |
Kraska et al. | Consistency rationing in the cloud: Pay only when it matters | |
US6275987B1 (en) | Adaptive, predictive progress indicator | |
US20050066239A1 (en) | Configuration system and method | |
US7720634B2 (en) | Apparatus and method for automatically improving a set of initial return on investment calculator templates | |
JP2002505457A (en) | System and method for extracting and predicting computing resource data, such as CPU consumption, using an auto-regression method | |
JP2000172537A (en) | Device and method for performance prediction and recording medium | |
US20070050330A1 (en) | Self-Healing RDBMS Optimizer | |
US7747449B2 (en) | Method and computer system for providing a cost estimate for sizing a computer system | |
US20150039555A1 (en) | Heuristically modifying dbms environments using performance analytics | |
US8428986B2 (en) | Return on investment analysis tool for storage systems | |
JP2001125962A (en) | Support system for management consulting and decision making in management | |
CN109871368A (en) | Database detection method, apparatus, computer installation and storage medium | |
US8756200B2 (en) | Undo advisor | |
CN113326985B (en) | Short-term load prediction method and device | |
JP5684745B2 (en) | Batch job analysis device, batch job analysis method, batch processing monitoring device, and batch processing monitoring method | |
JP4339769B2 (en) | Prediction model selection device, prediction model selection method, and program | |
Layton | A new approach to dating and predicting Australian business cycle phase changes | |
JP6697082B2 (en) | Demand forecasting method, demand forecasting system and program thereof | |
Kelly et al. | Predicting performance in distributed enterprise applications | |
CN114519636A (en) | Batch service processing method, device, equipment and storage medium | |
CN113703974A (en) | Method and device for predicting server capacity | |
US20190266548A1 (en) | Project Progress Prediction Device and Project Progress Prediction System | |
CN100451962C (en) | Adaptive control of loading a program in a disk-based operating system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AS | Assignment |
Owner name: HITACHI, LTD., JAPAN Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:CHIGUSA, KENTARO;CHADANI, KENICHI;IWATA, MORIHIRO;REEL/FRAME:014467/0135 Effective date: 20030807 |
|
FEPP | Fee payment procedure |
Free format text: PAYOR NUMBER ASSIGNED (ORIGINAL EVENT CODE: ASPN); ENTITY STATUS OF PATENT OWNER: LARGE ENTITY |
|
FEPP | Fee payment procedure |
Free format text: PAYER NUMBER DE-ASSIGNED (ORIGINAL EVENT CODE: RMPN); ENTITY STATUS OF PATENT OWNER: LARGE ENTITY Free format text: PAYOR NUMBER ASSIGNED (ORIGINAL EVENT CODE: ASPN); ENTITY STATUS OF PATENT OWNER: LARGE ENTITY |
|
FPAY | Fee payment |
Year of fee payment: 4 |
|
REMI | Maintenance fee reminder mailed | ||
LAPS | Lapse for failure to pay maintenance fees | ||
STCH | Information on status: patent discontinuation |
Free format text: PATENT EXPIRED DUE TO NONPAYMENT OF MAINTENANCE FEES UNDER 37 CFR 1.362 |
|
FP | Lapsed due to failure to pay maintenance fee |
Effective date: 20160902 |