Back to results
US 2023/0418682 A1Published application
Elastic data partitioning of a database
AssigneeSalesforce, Inc.
InventorRohitashva MATHUR
Life of this patent
Estimating the term…
Abstract
A database entry may be stored in a container in a database table corresponding with a partition key. The partition key may be determined by applying one or more partition rules to one or more data values associated with the database entry. The database entry may be an instance of one of a plurality of data object definitions associated with database entries in the database. Each of the data object definitions may identify a respective one or more data fields included within an instance of the data object definition.
Claims20
A method comprising:
- receiving via a communication interface a request to retrieve data from a database table storing a plurality of database entries in one or more containers, the plurality of database entries including a respective one or more data values arranged in a respective one or more data fields in accordance with a respective data object definition, the database table being associated with a plurality of data object definitions including a first data object definition associated with a first partition rule and a second data object definition associated with a second partition rule different from the first partition rule, the request including a first database query identifying one or more characteristics of the data to be retrieved;
- applying the first partition rule to the one or more characteristics to identify a subset of the one or more containers, the one or more characteristics identifying the first data object definition;
- determining via a processor a second database query based on the first database query, the second database query being limited to the subset of the one or more containers;
- and
- transmitting an instruction to execute the second database query to retrieve the data.
2 more elements
A database system implemented using a server system, the database system comprising:
- a communication interface configurable to a request to retrieve data from a database table storing a plurality of database entries in one or more containers, the plurality of database entries including a respective one or more data values arranged in a respective one or more data fields in accordance with a respective data object definition, the database table being associated with a plurality of data object definitions including a first data object definition associated with a first partition rule and a second data object definition associated with a second partition rule different from the first partition rule, the request including a first database query identifying one or more characteristics of the data to be retrieved;
- and
- a processor configurable to:
- apply the first partition rule to the one or more characteristics to identify a subset of the one or more containers, the one or more characteristics identifying the first data object definition,
- determine a second database query based on the first database query, the second database query being limited to the subset of the one or more containers, and
- transmit an instruction to execute the second database query to retrieve the data.
3 more elements
One or more non-transitory computer readable media having instructions stored thereon for performing a method, the method comprising:
- receiving via a communication interface a request to retrieve data from a database table storing a plurality of database entries in one or more containers, the plurality of database entries including a respective one or more data values arranged in a respective one or more data fields in accordance with a respective data object definition, the database table being associated with a plurality of data object definitions including a first data object definition associated with a first partition rule and a second data object definition associated with a second partition rule different from the first partition rule, the request including a first database query identifying one or more characteristics of the data to be retrieved;
- applying the first partition rule to the one or more characteristics to identify a subset of the one or more containers, the one or more characteristics identifying the first data object definition;
- determining via a processor a second database query based on the first database query, the second database query being limited to the subset of the one or more containers;
- and
- transmitting an instruction to execute the second database query to retrieve the data.
2 more elements
Dependencies are inferred from the claim text.