Systems to provide database updates

Patent metadata

Field	Value
Publication number	US-9774652-B2
Application number	US-201414310781-A
Country	US
Kind code	B2
Filing date	Jun 20, 2014
Priority date	Dec 13, 2013
Publication date	Sep 26, 2017
Grant date	Sep 26, 2017

Abstract

A system includes establishment of a WebSocket connection at a WebSocket endpoint of the system with a WebSocket client, registration of a callback at the WebSocket endpoint for an event associated with an update to data of the database, identification of an update to the data of the database at an HTTP endpoint of the system, sending, in response to the identification of the update, a trigger event from the HTTP endpoint, reception of the trigger event at the WebSocket endpoint, and execution of the callback by the WebSocket endpoint to transmit the update to the WebSocket client.

First claim

What is claimed is:

1. A system comprising:
a memory storing:
a database; and

a processor to execute the processor-executable process steps to cause the system to:
establish a WebSocket connection at a WebSocket endpoint of the system with a WebSocket client;
register a callback at the WebSocket endpoint for an event associated with an update to data of the database;
receive a request via an HTTP endpoint at an application server to update data of the database;
identify an update to the data of the database by the HTTP endpoint of the system, wherein the application server is closely-integrated with a database system;
in response to the identification of the update, send a database trigger event from the database system to an application running in the application server of the system, wherein the database trigger event provides a content update to the application running in the application server;
receive a trigger event at the WebSocket endpoint from the application server via the HTTP endpoint, wherein the trigger event comprises row ids of a database table; and
execute the callback by the WebSocket endpoint to transmit the update to the WebSocket client, wherein execution of the callback by the WebSocket endpoint comprises selection of data of the database associated with the row ids.

2. The system according to claim 1 , wherein the row ids of the trigger event comprise row ids of database table rows which were updated by the update.

3. A computer-implemented method comprising:
establishing a WebSocket connection at a WebSocket endpoint of the system with a WebSocket client;
registering a callback at the WebSocket endpoint for an event associated with an update to data of a database;
receiving a request via an HTTP endpoint at an application server to update data of the database;
identifying an update to the data of the database by the HTTP endpoint of the system, wherein the application server is closely-integrated with a database system;
in response to the identification of the update, sending a database trigger event from the database system to an application running in the applications server of the system, wherein the database trigger event provides a content update to the application running in the application server;
receiving a trigger event at the WebSocket endpoint from the application server via the HTTP endpoint, wherein the trigger event comprises row ids of a database table; and
executing the callback by the WebSocket endpoint to transmit the update to the WebSocket client, wherein execution of the callback by the WebSocket endpoint comprises selection of data of the database associated with the row ids.

4. The method according to claim 3 , wherein the row ids of the trigger event comprise row ids of database table rows which were updated by the update.

5. A non-transitory computer-readable medium storing program code, the program code executable by a computer system to cause to the computer system to:
establish a WebSocket connection at a WebSocket endpoint of the system with a WebSocket client;
register a callback at the WebSocket endpoint for an event associated with an update to data of the database;
receive a request via an HTTP endpoint at an application server to update data of the database;
identify an update to the data of the database by the HTTP endpoint of the system, wherein the application server is closely-integrated with a database system;
in response to the identification of the update, send a database trigger event from the database system to an application running in the applications server of the system, wherein the database trigger event provides a content update to the application running in the application server;
receive a trigger event at the WebSocket endpoint from the application server via the HTTP endpoint, wherein the trigger event comprises row ids of a database table; and
execute the callback by the WebSocket endpoint to transmit the update to the WebSocket client, wherein execution of the callback by the WebSocket endpoint comprises selection of data of the database associated with the row ids.

6. The medium according to claim 5 , wherein the row ids of the trigger event comprise row ids of database table rows which were updated by the update.

Assignees

• Foebel Florian
• Friedmann Bjoern
• Gruschko Boris
• Mohr Christian
• Strenge Martin
• Geissinger Steffen
• Sap Se

Inventors

• Foebel Florian
• Friedmann Bjoern
• Gruschko Boris
• Mohr Christian
• Strenge Martin
• Geissinger Steffen

Classifications

• H04L67/42

  Electricity · mapped topic

• G06F17/30365

  Physics · mapped topic

• H04L67/02 Primary

  based on web technology, e.g. hypertext transfer protocol [HTTP] · CPC title

• H04L67/01

  Protocols · CPC title

• G06F16/235

  Update request formulation · CPC title