Pre-loading of an in memory database
OwnerEric Lawrence Barsness, David L. Darrington +2inventors
InventorsEric Lawrence Barsness, David L. Darrington, Amanda Peters, John Matthew Santosuosso
Life of this patent
Estimating the term…
Abstract
A method and apparatus for pre-loading an in memory database in a parallel computing system. A node manager uses empirical evidence gained from monitoring prior query execution times and patterns to determine how to effectively load the in memory database. The structure of the database may also be analyzed to determine effective ways to pre-load the database. The node manager may also allow a system administrator to force placement of database structures in particular nodes.
Claims20
A parallel computer system comprising:
- a plurality of fully functional compute nodes;
- a node manager for managing the compute nodes and collecting historical information about the operation of an in memory database on the nodes;
- and
- a database loader for pre-loading the in memory database based on the historical information to optimize the database efficiency.
A computer implemented method for pre-loading an in memory database into the compute nodes of a parallel computer system where the method comprises the steps of:
- accessing historical information about the database operating in the computer system;
- reading a data file containing a database structures;
- determining an optimal compute node mapping for the database structure based on the historical information;
- and
- loading the database structure in the database.
A computer-readable program product comprising:
- a node manager for managing the compute nodes and collecting historical information about the operation of an in memory database on the nodes;
- a database loader for pre-loading the in memory database based on the historical information to optimize the database efficiency;
- and
- computer recordable media bearing the database loader.
Dependencies are inferred from the claim text.