Database triggered push notification

Patent metadata

Field	Value
Publication number	US-9654576-B2
Application number	US-201414484293-A
Country	US
Kind code	B2
Filing date	Sep 12, 2014
Priority date	Sep 12, 2014
Publication date	May 16, 2017
Grant date	May 16, 2017

Abstract

Systems and methods of database triggered push notification are disclosed. In one aspect, data from a database entity is cached in response to executing user service request at a client session, where the service request involves information from the database entity. In response to caching the data from the database entity, the client session subscribing to a messaging channel dedicated to the database entity. In another aspect, a message is generated as a result of invoking a trigger by an operation in the database entity. In yet another aspect, the message is transported by the messaging channel to the subscribed client session to invoke refresh of the cached data. A push notification is sent to the client in response to the message.

First claim

What is claimed is:

1. A non-transitory computer-readable medium storing instructions which, when executed by at least one processor, cause a computer system to perform activities comprising:
execute at least one operation at a database entity;
in response to executing the at least one operation at the database entity, generate a subscription to a messaging channel for at least one subscriber, wherein the messaging channel is dedicated to the database entity via one-to-one correspondence relationship;
activate a database trigger defined for the database entity and in communication with the messaging channel, wherein the database trigger is invoked in response to executing the at least one operation at the database entity, and wherein the database trigger generates and sends an inbound message to the messaging channel of the database entity;
receive the inbound message at the messaging channel;
upon receiving the inbound message, push at least one outbound message to the at least one subscriber;
in response to the at least one outbound message, retrieve data from the database entity; and
submit the retrieved data to refresh at least one cache associated with the at least one subscriber.

2. The computer readable medium of claim 1 further storing instructions which, when executed by the at least one processor, cause the computer system to perform activities comprising:
push a notification based on the retrieved data to update at least one client user interface corresponding to the at least one subscriber.

3. The computer readable medium of claim 1 further storing instructions which, when executed by the at least one processor, cause the computer system to perform activities comprising:
receive a request involving the at least one operation at the database entity;
in response to receiving the request, retrieve initial data from the database entity; and
submit the retrieved initial data to the at least one cache.

4. The computer readable medium of claim 3 further comprising:
receive the inbound message in response to invoking the trigger by the execution of the at least one operation, wherein the inbound message including metadata for the at least one operation; and
transport at least part of the metadata by the at east one outbound message.

5. The computer readable medium of claim 4 , wherein retrieving the data from the database entity comprises:
retrieve the data based on the at least part of the metadata in the at east one outbound message.

6. A computer implemented method of database triggered messaging notification, the method comprising:
executing an operation at a database entity;
in response to executing the operation at the database entity, generating a subscription to a messaging channel for at least one user interface (UI) session, wherein the messaging channel s dedicated t the database entity via one-to-one correspondence relationship;
activating a database trigger defined for the database entity and in communication with the messaging channel, wherein the database trigger is invoked in response to executing the operation at the database entity, and wherein the database trigger generates and sends an inbound message to the messaging channel of the database entity;
receiving, at the messaging channel of the database entity, the inbound message, wherein the inbound message including metadata for the operation;
upon receiving the inbound message, sending at least one outbound message to the at least one UI session subscribed to the messaging channel;
upon receiving the at least one outbound message, a processor of a computer system retrieving data from the database entity;
submitting the retrieved data to refresh at least one volatile memory cache associated with the at least one subscribed UI session; and
pushing the retrieved data, over network, to update at least one client UI corresponding to the at least one subscribed UI session.

7. The method of claim 6 further comprising:
receiving, at the UI session, a request involving the operation at the database entity;
in response to receiving the request, retrieving initial data from the database entity; and
submitting the retrieved initial data to the at least one volatile memory cache associated with the UI session.

8. The method of claim 6 , wherein sending the at least one outbound message comprises:
transporting at east part of the metadata by the at least one outbound message to the at least one subscribed UI session.

9. The method of claim 8 , wherein retrieving the data from the database entity comprises:
retrieving the data based n the at least part of the metadata transported by the at least one outbound message.

10. A computer system providing database triggered messaging notification, the system comprising:
a memory to store computer readable instructions;
a processor communicatively coupled with the memory to execute the stored computer readable instructions to execute at least one operation at a database entity for at least one cache associated with at least one client, and
a messaging channel dedicated via one-to-one correspondence relationship to the database entity to receive at least one subscription for the at least one client in response to executing the at least one operation at the database entity, receive an inbound message from a database trigger activated, in response to the execution of the at least one operation at the database entity, and generate the least one outbound message in response to the inbound message and based on the at least one subscription, wherein the activated database trigger is defined for the database entity and communicates with the messaging channel of the database entity.

11. The system of claim 10 , wherein the processor to execute instructions further to:
reread the data from the database entity for the at least one cache in response to the at least one outbound message; and
push at least one notification to the at least one client in response to the at least one outbound message.

12. The system of claim 10 , wherein the processor to execute instructions further to:
cancel a currently executing service request in response to an outbound message of the at least one outbound message, wherein the service request involves the at least one operation at the database entity.

13. The system of claim 10 , wherein the processor to execute instructions further to:
receive a service request from a client, wherein the service request involves the at least one operation at the database entity; and
read initial data from the database entity in response to the service request.

14. The system of claim 13 , wherein the processor to execute instructions further to:
activate the messaging channel dedicated to the database entity in response to executing the at least one operation at the database entity.

15. The system of claim 14 , wherein the processor to execute instructions further to:
generate the at least one outbound message to include at least part of metadata for the at least one operation executed at the database entity, wherein the metadata is transported by the inbound message.

Assignees

• Jolfaei Masoud Aghadavoodi
• Sap Se

Inventors

• Jolfaei Masoud Aghadavoodi

Classifications

• G06F17/30386

  Physics · mapped topic

• G06F17/30864

  Physics · mapped topic

• G06F17/3051

  Physics · mapped topic

• H04L67/2842

  Electricity · mapped topic

• G06F17/30867

  Physics · mapped topic