Table-per-partition
US10936613B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | May 3, 2017 |
| Grant date | Mar 2, 2021 |
| Priority date | — |
| Expiry date | Jul 29, 2038 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/278
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
The present approach improves the query performance of a database in a manner that is transparent to a user. In one aspect, this approach creates separate partition tables that are not directly accessible to a user of the database. A client-facing aspect of the database is a logical model which may correspond to a single, main table with which the user interacts. Thus, queries or operations may be generated on the client side in the context of the logical model. A database or query layer can then, transparent to the user, translate the user generated requests into query language that addresses the proper partitions to generate a result set or otherwise perform a database operation.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.