The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Apr. 14, 2025
Filed:
Jun. 29, 2022
Amazon Technologies, Inc., Seattle, WA (US);
Ippokratis Pandis, Menlo Park, CA (US);
Gokul Soundararajan, San Jose, CA (US);
Gopal Paliwal, Milpitas, CA (US);
Punit Rajgaria, Saratoga, CA (US);
Sanuj Basu, San Mateo, CA (US);
Todd Jeffrey Green, Davis, CA (US);
Gaurav Saxena, Cupertino, CA (US);
Vadim Skipin, Berlin, DE;
Johannes Wust, Kleinmachnow, DE;
Hemanth Satyanarayana, Santa Clara, CA (US);
Matthew Perry Abrams, Las Cruces, NM (US);
Murali Brahmadesam, Tiruchirappalli, IN;
Amazon Technologies, Inc., Seattle, WA (US);
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.