Query handling in databases with replicated data
US8782075B2 · kind B2 · utility
4Cited by
10References
13Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | May 8, 2007 |
| Grant date | Jul 15, 2014 |
| Priority date | — |
| Expiry date | Mar 17, 2031 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2471
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
The same data is stored in at least two different database management systems (DBMS's), including a columnar DBMS (320.2) and a non-columnar (e.g. row-oriented) DBMS (320.1). The columnar DBMS may provide fast responses to queries involving aggregation, and such queries can be routed to the columnar DBMS. A query may be routed to the non-columnar DBMS if for example the query execution involves only small DBMS tables on the non-columnar DBMS. In some situations, an execution time estimate can be obtained from each DBMS, and the query is routed to the DBMS providing the shortest estimate.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.