Method and computer program product for efficiently loading and synchronizing column-oriented databases
US10671641B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Apr 25, 2016 |
| Grant date | Jun 2, 2020 |
| Priority date | — |
| Expiry date | Mar 5, 2037 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F2201/84
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
An automated method and computer program product are provided for synchronizing a column-oriented target database with a row-oriented source database. Change data are replicated from a change log of the row-oriented source database via a staging database to the column-oriented target database. The change data including inserts and deletes. Change data of the change log is read into the staging database and is consolidated and grouped into a consolidated grouping of inserts, and a consolidated grouping of deletes. The consolidated grouping of inserts from the staging database are applied to the target database in a batched manner, and the consolidated grouping of deletes from the staging database are applied to the target database in a batched manner.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.