Patent · US Active

Hybrid transactional and analytical processing architecture for optimization of real-time analytical querying

US12277138B2 · kind B2 · utility

0Cited by

4References

20Claims

0Family size

Assignee

AMAZON TECHNOLOGIES, INC. · US

Inventors

Ippokratis Pandis · Menlo, US
Gokul Soundararajan · Sunnyvale, US
Gopal Paliwal · Milpitas, US
Punit Rajgaria · Saratoga, US
Sanuj Basu · San Mateo, US
Todd J. Green · Canton, US
Gaurav Saxena · Pune, IN
Vadim Skipin · Berlin, DE
Johannes Wust · Berlin, DE
Hemanth Satyanarayana · Santa Clara, US
Matthew Perry Abrams · Las Cruces, US
Murali Brahmadesam · Kanchinakote, IN

Key dates

Filing date	Jun 30, 2022
Grant date	Apr 15, 2025
Priority date	—
Expiry date	Oct 11, 2042

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/283
WIPO fieldComputer technology
WIPO sectorElectrical engineering

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.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.