DATABASE TRIGGER-BASED EVENTING FOR DATA CHANGES BASED ON A PUBLISH/SUBSCRIBE MECHANISM

• US 20180129694A1
• Filed: 11/04/2016
• Published: 05/10/2018
• Est. Priority Date: 11/04/2016
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Hoffner, Andreas, Schuhart, Henrike, Sabiwalsky, Dirk, Singler, Joerg
• Granted Patent: US 10,360,207 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: G06F 9/54 Interprogram communication
• CPC Class Codes: G06F 9/542 Event management; Broadcasting; Multicasting; Notifications

Abstract

Methods and apparatus, including computer program products, are provided for handling database table changes. The method may include receiving, at an event processor, a request from an application to subscribe to a database table event at an in-memory database; storing, at the event processor, a subscription to the database table event; sending, by the event processor, a subscription request to the in-memory database, wherein the subscription request indicates a subscription to the database table event; handling, at the event processor, a notification, wherein the notification is received on behalf of the application in order to determine whether to publish the notification to an endpoint coupled to at least the application, wherein the notification indicates an identity of at least one database table at the in-memory database that has changed; and publishing the notification to the endpoint. Related systems, methods, and articles of manufacture are also disclosed.

Claims

1. A method comprising:

receiving, at an event processor, a request from an application to subscribe to a database table event at an in-memory database;

storing, at the event processor, a subscription to the database table event;

sending, by the event processor, a subscription request to the in-memory database, wherein the subscription request indicates a subscription to the database table event;

handling, at the event processor, a notification, wherein the notification is received on behalf of the application in order to determine whether to publish the notification to an endpoint coupled to at least the application, wherein the notification indicates an identity of at least one database table at the in-memory database that has changed; and

publishing the notification to the endpoint.

2. The method of claim 1, wherein a cloud-based application providing resource control includes the event processor.

3. The method of claim 1, wherein the resource control includes supply chain management and/or human resource management.

4. The method of claim 2, wherein a user equipment includes the application and couples to the cloud-based application.

5. The method of claim 1 further comprising:

receiving, by the event processor, the notification sent by the in-memory database.

6. The method of claim 5, wherein the event processor includes an event broker configured to read the notification and read whether the notification includes the at least one database table under a subscription request from the application.

7. The method of claim 1, wherein when a change to the at least one database table is committed, an after commit handler at the database triggers a database notification handler to determine whether the event processor subscribes, on behalf of the application, to the change.

8. The method of claim 7, wherein when the determination indicates the event processor subscribes, on behalf of the application, to the change, the database notification handler sends the notification to the event processor.

9. The method of claim 1, wherein the event processor stores subscriptions to a plurality of database table events provided by a plurality of applications including different types of applications.

10. The method of claim 1, wherein the publishing comprises sending, by the event processor, a list of database tables that have changed at the in-memory database.

11. A system including at least one processor and at least one memory including program code which when executed causes operations comprising:

receiving, at an event processor, a request from an application to subscribe to a database table event at an in-memory database;

storing, at the event processor, a subscription to the database table event;

sending, by the event processor, a subscription request to the in-memory database, wherein the subscription request indicates a subscription to the database table event;

handling, at the event processor, a notification, wherein the notification is received on behalf of the application in order to determine whether to publish the notification to an endpoint coupled to at least the application, wherein the notification indicates an identity of at least one database table at the in-memory database that has changed; and

publishing the notification to the endpoint.

12. The system of claim 11, wherein a cloud-based application providing resource control includes the event processor.

13. The system of claim 11, wherein the resource control includes supply chain management and/or human resource management.

14. The system of claim 13, wherein a user equipment includes the application and couples to the cloud-based application.

15. The system of claim 11 further comprising:

receiving, by the event processor, the notification sent by the in-memory database.

16. The system of claim 15, wherein the event processor includes an event broker configured to read the notification and read whether the notification includes the at least one database table under a subscription request from the application.

17. The system of claim 15, wherein when a change to the at least one database table is committed, an after commit handler at the database triggers a database notification handler to determine whether the event processor subscribes, on behalf of the application, to the change.

18. The system of claim 17, wherein when the determination indicates the event processor subscribes, on behalf of the application, to the change, the database notification handler sends the notification to the event processor.

19. The system of claim 18, wherein the event processor stores subscriptions to a plurality of database table events provided by a plurality of applications including different types of applications, and wherein the publishing comprises sending, by the event processor, a list of database tables that have changed at the in-memory database.

20. A non-transitory computer-readable storage medium including program code which when executed causes operations comprising:

receiving, at an event processor, a request from an application to subscribe to a database table event at an in-memory database;

storing, at the event processor, a subscription to the database table event;

sending, by the event processor, a subscription request to the in-memory database, wherein the subscription request indicates a subscription to the database table event;

handling, at the event processor, a notification, wherein the notification is received on behalf of the application in order to determine whether to publish the notification to an endpoint coupled to at least the application, wherein the notification indicates an identity of at least one database table at the in-memory database that has changed; and

publishing the notification to the endpoint.