Method and system for adaptively building a column store database from a temporal row store database based on query demands
US9836507B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 17, 2014 |
| Grant date | Dec 5, 2017 |
| Priority date | — |
| Expiry date | Oct 25, 2035 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/283
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method for dynamically building a column store database from a row store database. The method includes establishing the row store database for storing data, wherein each row includes a plurality of attributes, and wherein data in row store database is current to a temporal point in time. The method includes establishing the column store database including data structured to satisfy received analytic queries. The method includes beginning from an initial state of the column store database, for each subsequently received analytic query, importing a targeted amount of data from a corresponding temporal state of the row store database into the column store database to satisfy the corresponding subsequently received analytic query.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.