Back to results
US 9,805,107 B2Granted
Systems and methods for dynamic partitioning in a relational database
AssigneeTelduráðgevin Sp/f
InventorEyjólfur Gislason
Life of this patent
Estimating the term…
Abstract
Systems and methods for dynamic partitioning in a relational database are described herein. A system can be configured to receive a data object definition statement to define a data object, where the data object definition statement associates an expression with the data object, and where the expression defines a correlation between an attribute of the data object and a prospective partition of the data object. The system can then receive a data manipulation statement to manipulate data in the data object, and in response to receiving the data manipulation statement, process the data manipulation statement, where processing includes initiating evaluation of the expression to identify a target partition based on the correlation between the attribute and the prospective partition.
Claims18
A computer-based database management system comprising:
- a processor;
- and
- a memory coupled to the processor, the memory for storing instructions, which when executed by the processor, cause the processor to:
- receive a data object definition statement to define a data object, wherein the data object definition statement associates an expression with the data object, wherein the expression defines a correlation between an attribute of the data object and a prospective partition of the data object, and wherein the expression does not include a literal identification of the prospective partition;
- process the data object definition statement, wherein processing the data object definition statement includes storing the expression in a data dictionary;
- receive a data manipulation statement to manipulate data in the data object;
- and
- in response to receiving the data manipulation statement, process the data manipulation statement, wherein processing includes:
- accessing the data dictionary to obtain the expression;
- initiating evaluation of the expression to obtain a character value, wherein the evaluation of the expression is based on the attribute of the data object and results in the character value, which is an identification of the prospective partition;
- identifying a target partition using the identification of the prospective partition;
- and
- creating the target partition when the target partition does not already exist or modifying the target partition when the target partition does exist.
10 more elements
A method comprising:
- receiving, at processor-based system implementing a computer-implemented database management system, a data object definition statement to define a data object, wherein the data object definition statement associates an expression with the data object, wherein the expression defines a correlation between an attribute of the data object and a prospective partition of the data object, and wherein the expression does not include a literal identification of the prospective partition;
- processing the data object definition statement, wherein processing the data object definition statement includes storing the expression in a data dictionary;
- receiving, at the computer-implemented database management system, a data manipulation statement to manipulate data in the data object;
- and
- in response to receiving the data manipulation statement, processing the data manipulation statement by the processor-based system, wherein processing includes:
- accessing the data dictionary to obtain the expression;
- initiating evaluation of the expression to obtain a character value, wherein the evaluation of the expression is based on the attribute of the data object and results in the character value, which is an identification of the prospective partition;
- identifying a target partition using the identification of the prospective partition;
- and
- creating the target partition when the target partition does not already exist or modifying the target partition when the target partition does exist.
7 more elements
A machine-readable storage medium comprising instructions, which when executed by a machine, cause the machine to:
- receive a data object definition statement to define a data object, wherein the data object definition statement associates an expression with the data object, wherein the expression defines a correlation between an attribute of the data object and a prospective partition of the data object, and wherein the expression does not include a literal identification of the prospective partition;
- process the data object definition statement, wherein processing the data object definition statement includes storing the expression in a data dictionary;
- receive a data manipulation statement to manipulate data in the data object;
- and
- in response to receiving the data manipulation statement, process the data manipulation statement, wherein the instructions to process the data manipulation statement include instructions that cause the machine to:
- access the data dictionary to obtain the expression;
- initiate evaluation of the expression to obtain a character value, wherein the evaluation of the expression is based on the attribute of the data object and results in the character value, which is an identification of the prospective partition;
- identify a target partition using the identification of the prospective partition;
- and
- create the target partition when the target partition does not already exist or modify the target partition when the target partition does exist.
7 more elements
Dependencies are inferred from the claim text.