公开(公告)号：US20240004897A1

公开(公告)日：2024-01-04

申请号：US17810314

申请日：2022-06-30

Applicant: Amazon Technologies, Inc.

Inventor： Ippokratis Pandis ,  Gokul Soundararajan ,  Gopal Paliwal ,  Punit Rajgaria ,  Sanuj Basu ,  Todd Jeffrey Green ,  Gaurav Saxena ,  Vadim Skipin ,  Johannes Wust ,  Hemanth Satyanarayana ,  Matthew Perry Abrams ,  Murali Brahmadesam

IPC: G06F16/27 ,  G06F16/25 ,  G06F16/28 ,  G06F16/23

CPC classification number: G06F16/27 ,  G06F16/25 ,  G06F16/283 ,  G06F16/2379

Abstract: Methods for replicating transactional tables of a transactional database to an analytical database and maintaining updates to those transactional table representations are disclosed. Snapshots of the transactional tables are provided to the analytical database via a transport mechanism, such as a data storage service or a data streaming service, and stored at the analytical database. Then, checkpoints comprising portions of a change-data-capture log that has recorded transactional changes to the transactional tables of the transactional database are provided to the analytical database via the same or different transport mechanism and used to commit those transactional changes to the snapshot representations. The snapshot representations may be used to respond to incoming analytical queries in order to provide real-time querying results.

公开(公告)号：US12277138B2

公开(公告)日：2025-04-15

申请号：US17810314

申请日：2022-06-30

Applicant: Amazon Technologies, Inc.

Inventor： Ippokratis Pandis ,  Gokul Soundararajan ,  Gopal Paliwal ,  Punit Rajgaria ,  Sanuj Basu ,  Todd Jeffrey Green ,  Gaurav Saxena ,  Vadim Skipin ,  Johannes Wust ,  Hemanth Satyanarayana ,  Matthew Perry Abrams ,  Murali Brahmadesam

IPC: G06F16/27 ,  G06F16/23 ,  G06F16/25 ,  G06F16/28

Abstract: Methods for replicating transactional tables of a transactional database to an analytical database and maintaining updates to those transactional table representations are disclosed. Snapshots of the transactional tables are provided to the analytical database via a transport mechanism, such as a data storage service or a data streaming service, and stored at the analytical database. Then, checkpoints comprising portions of a change-data-capture log that has recorded transactional changes to the transactional tables of the transactional database are provided to the analytical database via the same or different transport mechanism and used to commit those transactional changes to the snapshot representations. The snapshot representations may be used to respond to incoming analytical queries in order to provide real-time querying results.