US 10,592,953 B2Granted

System and method for prioritized product index searching

AssigneeWalmart Apollo, LLC

InventorsVarun Srivastava, Yiye Ruan, Yan Zheng

Life of this patent

Estimating the term…

Loading patent…

Abstract

Various embodiments include a system for grouping a set of distinct records in a database system, the database system comprising a first database cluster H and a second database cluster L. In many embodiments, the system can comprise one or more processing modules and one or more non-transitory memory storage modules storing computing instructions configured to run on the one or more processing modules. In some embodiments, the computer instructions can be configured to perform acts of determining, for each distinct record (i) of the set of distinct records, whether the record is a first priority or a second priority; for each distinct record (i) of the set of distinct records which is determined to be the first priority, storing the record in the first database cluster H, wherein the first database cluster H comprises a first computer server; and for each record (i) of the set of distinct records which is determined to be the second priority, storing the record in the second database cluster L. In these embodiments, the second database cluster L can comprise a second computer server different from the first computer server, and the first computer server can have greater processing power than the second computer server. In some embodiments, the first priority can be a higher priority than the second priority. Other embodiments are also disclosed herein.

Claims20

Dependent claims

A system for grouping a set of distinct records in a database system, the database system comprising a first database cluster H and a second database cluster L, the system comprising:

one or more processors;
and
one or more non-transitory memory storage devices storing computing instructions configured to run on the one or processors and perform acts of:
determining, for each distinct record (i) of the set of distinct records, whether each respective record is a first priority or a second priority by:
determining that a total number of records in the second database cluster L is greater than a target number;
and
when the total number of records in the second database cluster L is greater than the target number:
assigning a respective random number to a respective one of each distinct record (i) of the set of distinct records in the second database cluster L;
and
using the respective random number, as assigned to the respective one of each distinct record (i) of the set of distinct records in the second database cluster L, to determine that certain records of the set of distinct records in the second database cluster L are the first priority;
storing, in the first database cluster H and not in the second database cluster L, each distinct record (i) of the set of distinct records which are determined to be the first priority, wherein the first database cluster H comprises a first computer server;
and
storing, in the second database cluster L, each record (i) of the set of distinct records which are determined to be the second priority, wherein:
the second database cluster L comprises a second computer server different from the first computer server;
the first computer server has greater processing power than the second computer server;
and
the first priority is a higher priority than the second priority.

14 more elements

A method of grouping a set of distinct records in a database system, the database system comprising a first database cluster H and a second database cluster L, the method being implemented via execution of computer instructions configured to run at one or more processors and configured to be stored at one or more non-transitory memory storage devices, the method comprising:

determining, for each distinct record (i) of the set of distinct records, whether each respective record is a first priority or a second priority by:
determining that a total number of records in the second database cluster L is greater than a target number;
and
when the total number of records in the second database cluster L is greater than the target number:
assigning a respective random number to a respective one of each distinct record (i) of the set of distinct records in the second database cluster L;
and
using the respective random number, as assigned to the respective one of each distinct record (i) of the set of the distinct records in the second database cluster L, to determine that certain records of the set distinct records in the second database cluster L are the first priority;
storing, in the first database cluster H and not in the second database cluster L, each distinct record (i) of the set of distinct records which are determined to be the first priority, wherein the first database cluster H comprises a first computer server;
and
storing, in the second database cluster L, each record (i) of the set of distinct records which are determined to be the second priority, wherein:
the second database cluster L comprises a second computer server different from the first computer server;
the first computer server has greater processing power than the second computer server;
and
the first priority is a higher priority than the second priority.

11 more elements

Dependencies are inferred from the claim text.

Facts

Application: 15/879,300Filed 24 Jan 2018 · division
Priority: 26 Sep 2014
Published: US 2018/0150894 A131 May 2018
Granted: 17 Mar 2020
Term ends: Not estimatedThe source records don’t support an estimate.

Classification5 codes

G06Q 30/0625
By investigating goods or services: by formulating product or service queries, e.g. using keywords or predefined options
G06F 16/3326
Reformulation based on results of preceding query: using relevance feedback from the user, e.g. relevance feedback on documents, documents sets,…
G06F 16/3338
Query translation: query expansion
G06Q
Information and communication technology [ict] specially adapted for administrative, commercial, financial, managerial

Family

Application14/498,054Parent of this division · filed 26 Sep 2014
US 2018/0150894 A1Pre-grant publication · published 31 May 2018
US 9,965,788 B2Parent of this division
US 2016/0092564 A1Published application
US 10,592,953 B2This patent

From the US filing history. Foreign family members aren’t listed.