Methods and apparatus to partition a database

1. An apparatus to partition a database, the apparatus comprising:

memory; and

at least one processor including instructions that, when executed, cause the at least one processor to:

obtain a first query and a second query, the first query including first unstructured data to be written to a database, the second query including second unstructured data to be written to the database;

identify first dimensioning values associated with the first unstructured data and second dimensioning values associated with the second unstructured data, the first dimensioning values including a first tenant identifier and a first variant associated with the first unstructured data, the second dimensioning values including a second tenant identifier and a second variant associated with the second unstructured data, the second tenant identifier different from the first tenant identifier, the second variant different from the first variant;

select a first partition into which the first unstructured data is to be written based on the first dimensioning values;

select a second partition into which the second unstructured data is to be written based on the second dimensioning values, the second partition different from the first partition;

in response to at least one of the first partition or the second partition not existing in the database, create the at least one of the first partition or the second partition;

write the first unstructured data to the first partition; and

write the second unstructured data to the second partition.

2. The apparatus of claim 1 , wherein the first and second dimensioning values exclude time.

3. The apparatus of claim 1 , wherein the first unstructured data uses a first format identified by a first variant identifier and the second unstructured data uses a second format identified by a second variant identifier.

4. The apparatus of claim 1 , wherein the the instructions, when executed, cause the at least one processor to store the first dimensioning values as a first index in association with the first partition and store the second dimensioning values as a second index in associated with the second partition.

5. The apparatus of claim 1 , wherein the instructions, when executed, cause the at least one processor to identify third dimensioning values in connection with a third query, the third query requesting data, the at least one processor to select at least one of the first partition or the second partition for reading based on the third dimensioning values, the at least one processor to read the data from the at least one of the first partition or the second partition.

6. A non-transitory computer-readable medium comprising instructions that, when executed, cause a machine to at least:

obtain a first query and a second query, the first query including first unstructured data to be written to a database, the second query including second unstructured data to be written to the database;

identify first dimensioning values associated with the first unstructured data and second dimensioning values associated with the second unstructured data, the first dimensioning values including a first tenant identifier and a first variant associated with the first unstructured data, the second dimensioning values including a second tenant identifier and a second variant associated with the second unstructured data, the second tenant identifier different from the first tenant identifier, the second variant different from the first variant;

select a first partition into which the first unstructured data is to be written based on the first dimensioning values;

select a second partition into which the second unstructured data is to be written based on the second dimensioning values, the second partition different from the first partition;

in response to determining that at least one of the first partition or the second partition does not exist in the database, create the at least one of the first partition of the second partition;

write the first unstructured data to the first partition; and

write the second unstructured data to the second partition.

7. The non-transitory computer-readable medium of claim 6 , wherein the first and second dimensioning values exclude time.

8. The non-transitory computer-readable medium of claim 6 , wherein at least a first portion of the first unstructured data uses a first format identified by a first variant identifier and a second portion of the second unstructured data uses a second format identified by a second variant identifier.

9. The non-transitory computer-readable medium of claim 6 , wherein the instructions, when executed, further cause the machine to at least store the first dimensioning values as a first index in association with the first partition and store the second dimensioning values as a second index in association with the second partition.

10. The non-transitory computer-readable medium of claim 6 , wherein the instructions, when executed, further cause the machine to at least:

identify third dimensioning values in connection with a third query, the third query requesting data;

select at least one of the first partition or the second partition for reading based on the third dimensioning values; and

read the data from the at least one of the first partition or the second partition.

11. An apparatus to partition a database, the apparatus comprising:

means for identifying first dimensioning values associated with first unstructured data from a first query and second dimensioning values associated with second unstructured data from a second query, first unstructured data and the second unstructured data to be written to a database, the first dimensioning values including a first tenant identifier and a first variant associated with the first unstructured data, the second dimensioning values including a second tenant identifier and a second variant associated with the second unstructured data, the second tenant identifier different from the first tenant identifier, the second variant different from the first variant;

means for selecting a first partition into which the first unstructured data is to be written based on the first dimensioning values;

means for selecting a second partition into which the second unstructured data is to be written based on the second dimensioning values, the second partition different from the first partition;

means for creating, in response to determining that at least one of the first partition or the second partition does not exist in the database, the at least one of the first partition or the second partition;

means for writing the first unstructured data to the first partition; and

means for writing the second unstructured data to the second partition.

12. The apparatus of claim 11 , wherein the first and second dimensioning values exclude time.

13. The apparatus of claim 11 , wherein at least a first portion of the first unstructured data to be stored has a first format identified by a first variant identifier and at least a second portion of the second unstructured data to be stored has a second format identified by a second variant identifier.

14. The apparatus of claim 11 , wherein the means for creating is further to store the first dimensioning values as a first index in association with the first partition and store the second dimensioning values as a second index in associated with the second partition.

15. The apparatus of claim 11 , wherein the means for identifying is further to identify third dimensioning values in connection with a third query, the third query requesting data, the means for selecting is further to select at least one of the first partition or the second partition for reading based on the third dimensioning values, and further including means for reading the data from the at least one of the first partition or the second partition.