Method and system for eliminating backups in databases

Patent metadata

Field	Value
Publication number	US-9952938-B2
Application number	US-201414523081-A
Country	US
Kind code	B2
Filing date	Oct 24, 2014
Priority date	Oct 28, 2013
Publication date	Apr 24, 2018
Grant date	Apr 24, 2018

Abstract

Methods, devices and systems enable restoring a database system more efficiently. A server computing device may be configured to determine a recovery time interval for a session store database system so as to allow a large number of sessions (e.g., ninety percent of sessions, etc.) to start and finish within that interval, periodically review database records to identify a database record that has not been updated within a most recent recovery time interval, add the identified database record to a journaling log, and update the identified database record to include information identifying a time at which the database record was last added to the journaling log. After detecting a failure event, the server computing device may perform the database operations identified in the journaling log to restore the database system.

First claim

What is claimed is:

1. A method of restoring a session store database system that is accessible to one or more network components in a high-speed telecommunication system, the method comprising:
determining in a processor of a server computing device a recovery time interval for the session store database system so that ninety percent of sessions start and finish within the recovery time interval;
periodically reviewing database records to identify a database record that has not been updated within a most recent recovery time interval;
adding the identified database record to a journaling log;
updating the identified database record to include information identifying a time interval indicating when the database record was last added to the journaling log; and
using the journaling log to restore the session store database system.

2. The method of claim 1 , wherein using the journaling log to restore the session store database system comprises:
restoring empty database tables; and
performing database operations described in the journaling log that occurred within the most recent recovery time interval.

3. The method of claim 2 , further comprising determining a priority value for a database operation associated with the identified database record, wherein performing the database operations described in the journaling log that occurred within the most recent recovery time interval comprises applying the database operation to an empty database table based on the determined priority value.

4. The method of claim 3 , wherein determining the priority value for the database operation associated with the identified database record comprises:
determining the priority value based on a roaming status.

5. The method of claim 1 , wherein periodically reviewing database records to identify the database record that has not been updated within the most recent recovery time interval comprises:
determining time periods in which there is a high probability that the server computing device will experience a heavy load;
determining a regular time interval for reviewing database records that is less than the recovery time interval and which does not overlap with the determined time periods of heavy load; and
scheduling a process to execute at the regular time interval.

6. The method of claim 5 , further comprising dynamically adjusting the regular time interval based on changes in operating load.

7. The method of claim 1 , wherein adding the identified database record to the journaling log comprises adding the identified database record to the journaling log during a period of system inactivity.

8. The method of claim 1 , further comprising:
determining a priority value for the database record; and
adding the database record to the journaling log based on the determined priority value.

9. A server computing device deployed in a high-speed telecommunication system, comprising:
a processor configured with processor-executable instructions to perform operations comprising:
determining a recovery time interval for a session store database system so that ninety percent of sessions start and finish within the recovery time interval;
periodically reviewing database records to identify a database record that has not been updated within a most recent recovery time interval;
adding the identified database record to a journaling log;
updating the identified database record to include information identifying a time interval indicating when the database record was last added to the journaling log; and
using the journaling log to restore the session store database system.

10. The server computing device of claim 9 , wherein the processor is configured with processor-executable instructions to perform operations such that using the journaling log to restore the session store database system comprises:
restoring empty database tables; and
performing database operations described in the journaling log that occurred within the most recent recovery time interval.

11. The server computing device of claim 10 , wherein:
the processor is configured with processor-executable instructions to perform operations further comprising determining a priority value for a database operation associated with the identified database record; and
the processor is configured with processor-executable instructions to perform operations such that performing the database operations described in the journaling log that occurred within the most recent recovery time interval comprises applying the database operation to an empty database table based on the determined priority value.

12. The server computing device of claim 11 , wherein the processor is configured with processor-executable instructions to perform operations such that determining the priority value for the database operation associated with the identified database record comprises:
determining the priority value based on a roaming status.

13. The server computing device of claim 9 , wherein the processor is configured with processor-executable instructions to perform operations such that periodically reviewing database records to identify the database record that has not been updated within the most recent recovery time interval comprises:
determining time periods in which there is a high probability that the server computing device will experience a heavy load;
determining a regular time interval for reviewing database records that is less than the recovery time interval and which does not overlap with the determined time periods of heavy load; and
scheduling a process to execute at the regular time interval.

14. The server computing device of claim 13 , wherein the processor is configured with processor-executable instructions to perform operations further comprising dynamically adjusting the regular time interval based on changes in operating load.

15. The server computing device of claim 9 , wherein the processor is configured with processor-executable instructions to perform operations such that adding the identified database record to the journaling log comprises adding the identified database record to the journaling log during a period of system inactivity.

16. The server computing device of claim 9 , wherein the processor is configured with processor-executable instructions to perform operations further comprising:
determining a priority value for the database record; and
adding the database record to the journaling log based on the determined priority value.

17. A non-transitory computer readable storage medium having stored thereon processor-executable software instructions configured to cause a processor of a server computing device deployed in a high-speed telecommunication system to perform operations for restoring a session store database system, the operations comprising:
determining a recovery time interval for the session store database system so that ninety percent of sessions start and finish within the recovery time interval;
periodically reviewing database records to identify a database record that has not been updated within a most recent recovery time interval;
adding the identified database record to a journaling log;
updating the identified database record to include information identifying a time interval indicating when the database record was last added to the journaling log; and
using the journaling log to restore the session store database system.

18. The non-transitory computer readable storage medium of claim 17 , wherein the stored processor-executable software instructions are

Assignees

• Openet Telecom Ltd

Inventors

• Rolfe David
• Dunne Cameron Ross
• Mcnamee Alan
• D'Souza Andrew

Classifications

• G06F2201/80

  Database-specific techniques · CPC title

• G06F11/1471 Primary

  involving logging of persistent data for recovery · CPC title

• G06F11/1458 Primary

  Management of the backup or restore process · CPC title