Index maintenance in a multi-node database
US8090710B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Apr 22, 2008 |
| Grant date | Jan 3, 2012 |
| Priority date | — |
| Expiry date | Jul 27, 2030 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/22
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Embodiments of the invention enable a database spread over multiple nodes to allow each node to have different indexes over the data in tables, depending on how each node would benefit (or not benefit) from having the index(es). When a database table is spread across the nodes of a multi-node or distributed system, each node may maintain only the portion of the index relevant to that node, if doing so would improve the performance of query processing operations on that node. Further, the database may periodically redistributed across the compute nodes based on index performance. Doing so allows the database system to intelligently trade off between consuming space for the index on a node and the usefulness of having an index on that node.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.