Method and system for reducing journaling log activity in databases

Patent metadata

Field	Value
Publication number	US-9952937-B2
Application number	US-201414522990-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 receive a database transaction request that includes information identifying a database operation, determine a priority value for the database operation, and add the database operation to a journaling log based on the determined priority value. 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 database system that is accessible to network components in a high-speed telecommunication system, the method comprising:
receiving in a processor of a server computing device a database transaction request that includes information identifying a database operation;
determining a priority value for the database operation identified in the received database transaction request;
determining whether the priority value is greater than a threshold value;
adding the database operation to a journaling log in response to determining that the determined priority value is greater than the threshold value;
detecting a failure event; and
performing database operations identified in the journaling log to restore the database system in response to detecting the failure event.

2. The method of claim 1 , further comprising determining whether the database operation is a critical operation based on whether failing to perform the database operation would impact a service delivery functionality of the telecommunication system.

3. The method of claim 1 , wherein determining the priority value for the database operation comprises determining whether a notable flag associated with the database transaction request is set.

4. The method of claim 1 , wherein determining the priority value for the database operation comprises:
determining a transaction type of the database operation; and
computing the priority value based on the transaction type.

5. The method of claim 4 , wherein:
determining the transaction type of the database operation comprises determining whether the database operation is one of an insert operation, a delete operation, and an update operation; and
computing the priority value based on the transaction type comprises assigning a high priority to the database operation in response to determining that the database operation is one of the insert operation and the delete operation.

6. The method of claim 5 , wherein computing the priority value based on the transaction type comprises:
determining whether the database operation adds service access units to a balance account in a charging system in response to determining that the database operation is the update operation; and
assigning a high priority to the database operation in response to determining that the database operation adds access units to the balance account.

7. The method of claim 1 , wherein determining whether the priority value is greater than the threshold value comprises determining whether determined priority value is greater than a system load value computed at run time.

8. The method of claim 1 , wherein determining the priority value for the database operation comprises:
assigning a high priority to the database operation in response to determining that a number of other database operations were previously assigned a low priority.

9. The method of claim 1 , wherein determining the priority value for the database operation comprises:
determining the priority value based on an aggregate of values associated with database operations that were previously assigned a low priority.

10. The method of claim 1 , wherein determining the priority value for the database operation comprises:
determining the priority value based on a probability that failure to perform the database operation will result in a user contacting customer services.

11. The method of claim 1 , wherein determining the priority value for the database operation comprises:
determining the priority value based on a roaming status.

12. A server computing device deployed in a high-speed telecommunication system, comprising:
a processor configured with processor-executable instructions to perform operations comprising:
receiving a database transaction request that includes information identifying a database operation;
determining a priority value for the database operation;
determining whether the priority value is greater than a threshold value;
adding the database operation to a journaling log in response to determining that the determined priority value is greater than the threshold value;
detecting a failure event; and
performing database operations identified in the journaling log to restore the database system in response to detecting the failure event.

13. The server computing device of claim 12 , wherein the processor is configured with processor-executable instructions to perform operations further comprising determining whether the database operation is a critical operation based on whether failing to perform the database operation would impact a service delivery functionality of the telecommunication system.

14. The server computing device of claim 12 , wherein the processor is configured with processor-executable instructions to perform operations such that determining the priority value for the database operation comprises determining whether a notable flag associated with the database transaction request is set.

15. The server computing device of claim 12 , wherein the processor is configured with processor-executable instructions to perform operations such that determining the priority value for the database operation comprises:
determining a transaction type of the database operation; and
computing the priority value based on the transaction type.

16. The server computing device of claim 15 , wherein the processor is configured with processor-executable instructions to perform operations such that:
determining the transaction type of the database operation comprises determining whether the database operation is one of an insert operation, a delete operation, and an update operation; and
computing the priority value based on the transaction type comprises assigning a high priority to the database operation in response to determining that the database operation is one of the insert operation and the delete operation.

17. The server computing device of claim 16 , wherein the processor is configured with processor-executable instructions to perform operations such that computing the priority value based on the transaction type comprises:
determining whether the database operation adds service access units to a balance account in a charging system in response to determining that the database operation is the update operation; and
assigning a high priority to the database operation in response to determining that the database operation adds access units to the balance account.

18. The server computing device of claim 12 , wherein the processor is configured with processor-executable instructions to perform operations such that determining whether the priority value is greater than the threshold value comprises determining whether determined priority value is greater than a system load value computed at run time.

19. The server computing device of claim 12 , wherein the processor is configured with processor-executable instructions to perform operations such that determining the priority value for the database operation comprises:
assigning a high priority to the database operation in response to determining that a number of other database operations were previously assigned a low priority.

20. The server computing device of claim 12 , wherein the processor is configured with processor-executable instructions to perform operations such that determining the priority value for the database operation comprises:
determining the priority value based on an aggregate of values associated with database oper

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