IP Library Patent Application 17379693
Patent Application
App. No. 17/379,693

METHODS AND APPARATUS TO PARTITION A DATABASE

Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US None
App. No.
17/379,693
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.

Claims (68)

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.

Assignments (3)
CORRECTIVE ASSIGNMENT TO CORRECT THE THE PATENT TITLES AND REMOVE DUPLICATES IN THE SCHEDULE PREVIOUSLY RECORDED AT REEL: 059354 FRAME: 0335. ASSIGNOR(S) HEREBY CONFIRMS THE ASSIGNMENT. Recorded Jun 23, 2022
From: MCAFEE, LLC
To: JPMORGAN CHASE BANK, N.A., AS ADMINISTRATIVE AGENT
Reel/Frame 060792/0307 →
SECURITY INTEREST Recorded Mar 3, 2022
From: MCAFEE, LLC
To: JPMORGAN CHASE BANK, N.A., AS ADMINISTRATIVE AGENT AND COLLATERAL AGENT
Reel/Frame 059354/0335 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Aug 20, 2021
From: STEWART, BRIAN HOWARD; RHEES, BRIAN ROLAND; GROVER, SETH D.
To: MCAFEE, LLC
Reel/Frame 057243/0791 →