Statement based migration for adaptively building and updating a column store database from a row store database based on query demands using disparate database systems
US10671594B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 17, 2014 |
| Grant date | Jun 2, 2020 |
| Priority date | — |
| Expiry date | Sep 8, 2036 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/284
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method for updating a column store database and includes establishing a row store database, wherein each row comprises a plurality of attributes. The method includes establishing a column store database including attribute vectors corresponding to at least one attribute in the row store, wherein each attribute vector includes data used to satisfy at least one of previously received analytic queries. The method includes collecting a SQL change statements beginning from a synchronization point indicating when the row store database and the column store database are synchronized, and continuing until an analytic query is received. The method includes sending the plurality of SQL change statements to the column store database upon receipt of the analytic query for updating the column store database for purposes of satisfying the query, wherein the analytic query is directed to a queried range of primary key attributes in the plurality of attributes.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.