HYBRID TRANSACTIONAL AND ANALYTICAL PROCESSING ARCHITECTURE FOR OPTIMIZATION OF REAL-TIME ANALYTICAL QUERYING

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 da...

Full description

Saved in:
Bibliographic Details
Main Authors Satyanarayana, Hemanth, Basu, Sanuj, Green, Todd Jeffrey, Abrams, Matthew Perry, Brahmadesam, Murali, Saxena, Gaurav, Wust, Johannes, Paliwal, Gopal, Skipin, Vadim, Pandis, Ippokratis, Soundararajan, Gokul, Rajgaria, Punit
Format Patent
LanguageEnglish
Published 04.01.2024
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary: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.
Bibliography:Application Number: US202217810314