Invention Grant
- Patent Title: Trigger based analytics database synchronization
-
Application No.: US15865288Application Date: 2018-01-09
-
Publication No.: US11687567B2Publication Date: 2023-06-27
- Inventor: Zundra Vennaldo Daniel , Joshua Glenn Broch , Liny Chandran , Abhishek Mishra , Manu Nazareth , Sangeeta Soman
- Applicant: VMWARE, INC.
- Applicant Address: US CA Palo Alto
- Assignee: VMWARE, INC.
- Current Assignee: VMWARE, INC.
- Current Assignee Address: US CA Palo Alto
- Agency: Thomas Horstemeyer, LLP
- Priority: IN 1741033570 2017.09.21
- Main IPC: G06F16/28
- IPC: G06F16/28 ; G06F9/54 ; G06F16/23 ; G06F16/242 ; G06F16/27

Abstract:
Trigger based analytics database synchronization is described. In one example case, a trigger is invoked based on an operation issued for a record in a transactional database. According to the trigger, one or more data values for synchronization from the transactional database to an analytics database are determined. A message including the data values is formed and added to a message queue through a message infrastructure service including a message broker. In turn, the values from the message are stored in a suitable memory space, such as a staging table, for forwarding to an analytics computing system. Using the trigger and the message infrastructure service, execution of the transactional database operation can be detached in execution from the addition of the value to the staging table and synchronization with the analytics computing system.
Public/Granted literature
- US20190087478A1 TRIGGER BASED ANALYTICS DATABASE SYNCHRONIZATION Public/Granted day:2019-03-21
Information query