Updating statistics in distributed databases
AssigneeHewlett-Packard Development Company, L.P.
InventorsHoa Binh Nga Tran, Benjamin M. Vandiver, Sumeet Suresh Keswani
Life of this patent
Estimating the term…
Abstract
Updating statistics in distributed databases includes storing global statistics about at least one distributed table column distributed across multiple database nodes, where the global statistics have sensitive data for a query plan optimization process and insensitive data for the query plan optimization process, and updating the sensitive data of the global statistics more frequently than the insensitive data.
Claims15
A method for updating statistics in distributed databases, comprising:
- storing global statistics about at least one distributed table column distributed across multiple database nodes, said global statistics comprising sensitive data for a query plan optimization process and insensitive data for said query plan optimization process;
- and
- updating said sensitive data of said global statistics more frequently than said insensitive data.
A system for updating statistics in distributed databases, comprising:
- a global statistics storing engine to store statistics about a distributed table column in a distributed database, said global statistics including sensitive data for optimizing query plans and insensitive data for optimizing query plans;
- an updating engine to update said sensitive data of said global statistics independently of said insensitive data;
- and
- a query plan optimization engine to use both said sensitive data and said insensitive data.
A computer program product for updating statistics in distributed databases, comprising:
- a tangible computer readable storage medium, said tangible computer readable storage medium comprising computer readable program code embodied therewith, said computer readable program code comprising program instructions that, when executed, causes a processor to:
- store global statistics about a distributed table column in a distributed database, said global statistics comprising sensitive data that includes a minimum value, a maximum value, a row count, or combinations thereof for optimizing query plans and insensitive data for optimizing said query plan;
- update said sensitive data of said global statistics independently of said insensitive data also included in said global statistics;
- and
- use both said sensitive data and said insensitive data during a query plan optimization process.
Dependencies are inferred from the claim text.