Performance of row table to columnar table replication
AssigneeInternational Business Machines Corporation
InventorsXue Bo, Xiaobo Wang, He Fang Zhang, YU LIU, Peng Hui Jiang
Life of this patent
Estimating the term…
Loading patent…
AssigneeInternational Business Machines Corporation
InventorsXue Bo, Xiaobo Wang, He Fang Zhang, YU LIU, Peng Hui Jiang
Estimating the term…
A method, computer program product, and computer system are provided. Statistics for each columnar table are extracted from an online analytical processing (OLAP) database catalog. A transaction table map is created from transaction log records of an online transaction processing (OLTP) database. The transaction table map includes a counter of log records in a transaction and a timestamp indicating a longevity of the transaction. Based on the counter or the longevity exceeding a predefined threshold, the transaction is transformed, and sent to the OLAP database where it is replayed.
A method, comprising:
A computer program product, the computer program product comprising a non-transitory tangible storage device having program code embodied therewith, the program code executable by a processor of a computer to perform a method, the method comprising:
A computer system, comprising:
Dependencies are inferred from the claim text.