Back to results
US 10,885,062 B2Granted
Providing database storage to facilitate the aging of database-accessible data
AssigneeSap SE
InventorsMihnea Andrei, Christian Bensberg, Alexander Boehm, Adrian Dragusanu, Xun Chen, Reza Sherkat, Anisoara Nica, Martin Heidel, Rolando Blanco
Life of this patent
Estimating the term…
Abstract
Persisting data in logical tiers of an in-memory database based on aging rules of the database system. The database system can be configured to age data by moving the data from a first logical tier supporting high performance data access to a second logical tier supporting lower performance data access, thereby improving the operational efficiency of the database system.
Claims13
A method, comprising:
- repartitioning, by a database management system, a table having a first partition to include a second partition in addition to the first partition, the first partition of the table being stored in a first logical tier and the second partition of the table being stored in a second logical tier, the first logical tier being located on a first node configured to store and process queries on a first plurality of data items having a first logical tier attribute, the second logical tier being located on a second node configured to store a second plurality of data items having a second logical tier attribute, the table being repartitioned in response to one or more of the first plurality of data items in the first partition of the table satisfying the second logical tier attribute of the second logical tier, the repartitioning includes transferring, to the second logical tier, the one or more of the first plurality of data items satisfying the second logical tier attribute of the second logical tier, the first logical tier being associated with a first partition key and the second logical tier being associated with a second partition key, the first partition key and the second partition key being determined based at least on a time-correlated column in the table, and the database management system having equal access to the first logical tier and the second logical tier;
- evaluating, at the first node, a condition specified in a query to determine that the first partition of the table satisfies the condition but the second partition of the table does not satisfy the condition, the condition being evaluated based at least on the first partition key and the second partition key;
- and
- executing, based at least on the evaluating, the query, the query being executed at the first node by at least accessing the first logical tier based at least on the first partition of the table satisfying the condition specified in the query, and the query further being executed without accessing the second logical tier at the second node based at least on the second partition of the table not satisfying the condition specified in the query.
1 more element
A system, comprising:
- at least one processor;
- and
- at least one memory configured to store computer readable instructions which, when executed by the at least one processor, cause the at least one processor to perform one or more operations, the one or more operations comprising:
- repartitioning, by a database management system, a table having a first partition to include a second partition in addition to the first partition, the first partition of the table being stored in a first logical tier and the second partition of the table being stored in a second logical tier, the first logical tier being located on a first node configured to store and process queries on a first plurality of data items having a first logical tier attribute, the second logical tier being located on a second node configured to store a second plurality of data items having a second logical tier attribute, the table being repartitioned in response to one or more of the first plurality of data items in the first partition of the table satisfying the second logical tier attribute of the second logical tier, the repartitioning includes transferring, to the second logical tier, the one or more of the first plurality of data items satisfying the second logical tier attribute of the second logical tier, the first logical tier being associated with a first partition key and the second logical tier being associated with a second partition key, the first partition key and the second partition key being determined based at least on a time-correlated column in the table, and the database management system having equal access to the first logical tier and the second logical tier;
- evaluating, at the first node, a condition specified in a query to determine that the first partition of the table satisfies the condition but the second partition of the table does not satisfy the condition, the condition being evaluated based at least on the first partition key and the second partition key;
- and
- executing, based at least on the evaluating, the query, the query being executed at the first node by at least accessing the first logical tier based at least on the first partition of the table satisfying the condition specified in the query, and the query further being executed without accessing the second logical tier at the second node based at least on the second partition of the table not satisfying the condition specified in the query.
4 more elements
Dependencies are inferred from the claim text.