Partial Indexes for Multi-Node Database
AssigneeInternational Business Machines Corporation
InventorsEric L. BARSNESS, David L. DARRINGTON, Amanda PETERS, John M. SANTOSUOSSO
Life of this patent
Estimating the term…
Loading patent…
AssigneeInternational Business Machines Corporation
InventorsEric L. BARSNESS, David L. DARRINGTON, Amanda PETERS, John M. SANTOSUOSSO
Estimating the term…
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.
A method of distributing a database across a plurality of compute nodes provided by a parallel computing system, comprising:
A computer readable storage medium containing a program which, when executed, performs an operation for distributing a database across a plurality of compute nodes provided by a parallel computing system, comprising:
A parallel computing system, comprising:
Dependencies are inferred from the claim text.