Methods and apparatus to partition a database

Abstract

Methods, apparatus, systems, and articles of manufacture to partition a database are disclosed. An example apparatus includes memory, instructions in the apparatus, and processor circuitry to execute the instructions to identify a first variant associated with a request query received from a source, select a first partition based on the first variant, the first partition storing first data associated with the request query, identify a second variant associated with the request query, select a second partition based on the second variant, the second partition storing second data associated with the request query different from the first data, cause execution of a first query on the first partition, cause execution of a second query on the second partition, aggregate data associated with the request query based on a first result of the first query and a second result of the second query, and return the aggregated data to the source.

What is claimed is: 
     
         1 . An apparatus to partition a database, the apparatus comprising:
 at least one memory;   instructions in the apparatus; and   processor circuitry to execute the instructions to:
 identify a first variant associated with a request query received from a source; 
 select a first partition based on the first variant, the first partition storing first data associated with the request query; 
 identify a second variant associated with the request query; 
 select a second partition based on the second variant, the second partition storing second data associated with the request query different from the first data; 
 cause execution of a first query on the first partition; 
 cause execution of a second query on the second partition; 
 aggregate data associated with the request query based on a first result of the first query and a second result of the second query; and 
 return the aggregated data to the source. 
   
     
     
         2 . The apparatus of  claim 1 , wherein the processor circuitry is to:
 identify a third variant associated with the request query;   select a third partition based on the third variant, the third partition storing third data associated with the request query different from the first data and the second data; and   cause execution of a third query on the third partition.   
     
     
         3 . The apparatus of  claim 1 , wherein the processor circuitry is to identify the first variant and the second variant based on content included in the request query or metadata supplied in connection with the request query. 
     
     
         4 . The apparatus of  claim 1 , wherein the processor circuitry is to:
 select the first partition based on a first variant-partition link associated with the first variant; and   select the second partition based on a second variant-partition link associated with the second variant.   
     
     
         5 . The apparatus of  claim 1 , wherein the processor circuitry is to cause execution of the first query and the second query in a parallel fashion. 
     
     
         6 . The apparatus of  claim 1 , wherein the processor circuitry is to cause execution of the first query and the second query in a serial fashion. 
     
     
         7 . The apparatus of  claim 1 , wherein in response to the request query not being associated with the first variant or the second variant, the processor circuitry is to:
 cause execution of the first query on the first partition;   cause execution of the second query on the second partition; and   cause execution of a third query on a third partition, the third partition storing third data different from the first data and the second data.   
     
     
         8 . A non-transitory computer-readable medium comprising instructions that, when executed, cause a machine to at least:
 identify a first variant associated with a request query received from a source;   select a first partition based on the first variant, the first partition storing first data associated with the request query;   identify a second variant associated with the request query;   select a second partition based on the second variant, the second partition storing second data associated with the request query different from the first data;   cause execution of a first query on the first partition;   cause execution of a second query on the second partition;   aggregate data associated with the request query based on a first result of the first query and a second result of the second query; and   return the aggregated data to the source.   
     
     
         9 . The non-transitory computer-readable medium of  claim 8 , wherein the instructions, when executed, cause the machine to:
 identify a third variant associated with the request query;   select a third partition based on the third variant, the third partition storing third data associated with the request query different from the first data and the second data; and   cause execution of a third query on the third partition.   
     
     
         10 . The non-transitory computer-readable medium of  claim 8 , wherein the instructions, when executed, cause the machine to identify the first variant and the second variant based on content included in the request query or metadata supplied in connection with the request query. 
     
     
         11 . The non-transitory computer-readable medium of  claim 8 , wherein the instructions, when executed, cause the machine to:
 select the first partition based on a first variant-partition link associated with the first variant; and   select the second partition based on a second variant-partition link associated with the second variant.   
     
     
         12 . The non-transitory computer-readable medium of  claim 8 , wherein the instructions, when executed, cause the machine to cause execution of the first query and the second query in a parallel fashion. 
     
     
         13 . The non-transitory computer-readable medium of  claim 8 , wherein the instructions, when executed, cause the machine to cause execution of the first query and the second query in a serial fashion. 
     
     
         14 . The non-transitory computer-readable medium of  claim 8 , wherein in response to the request query not being associated with the first variant or the second variant, the instructions, when executed, cause the machine to:
 cause execution of the first query on the first partition;   cause execution of the second query on the second partition; and   cause execution of a third query on a third partition, the third partition storing third data different from the first data and the second data.   
     
     
         15 . An apparatus to partition a database, the apparatus comprising:
 means for identifying a first variant associated with a request query received from a source;   means for selecting a first partition based on the first variant, the first partition storing data associated with the request query;   means for identifying a second variant associated with the request query;   means for selecting a second partition based on the second variant, the second partition storing second data associated with the request query different from the first data;   means for causing execution of a first query on the first partition;   means for cause execution of a second query on the second partition;   means for aggregating data associated with the request query based on a first result of the first query and a second result of the second query; and   means for returning the aggregated data to the source.   
     
     
         16 . The apparatus of  claim 15 , further including:
 means for identifying a third variant associated with the request query;   means for selecting a third partition based on the third variant, the third partition storing third data associated with the request query different from the first data and the second data; and   means for causing execution of a third query on the third partition.   
     
     
         17 . The apparatus of  claim 15 , further including means for identifying the first variant and the second variant based on content included in the request query or metadata supplied in connection with the request query. 
     
     
         18 . The apparatus of  claim 15 , further including:
 means for selecting the first partition based on a first variant-partition link associated with the first variant; and   means for selecting the second partition based on a second variant-partition link associated with the second variant.   
     
     
         19 . The apparatus of  claim 15 , wherein the means for causing execution of the first query and the means for causing execution of the second query cause execution of the first query and the second query in a parallel fashion. 
     
     
         20 . The apparatus of  claim 15 , wherein the means for causing execution of the first query and the means for causing execution of the second query cause execution of the first query and the second query in a serial fashion.