IP Library Granted Patent US 9,378,267
Granted Patent B2
US 9,378,267 · App. 14/631,298 · Granted Jun 28, 2016

Methods and apparatus to search datasets

View Patent ↗
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 9,378,267
App. No.
14/631,298
Granted
Jun 28, 2016
Kind
B2
Abstract

Methods and apparatus to search datasets are disclosed. An example disclosed apparatus includes a count generator to generate a plurality of counts, the counts respectively indicative of a number of corresponding records in a database satisfying a respective one of a plurality of criteria present in the database; a grouper to assign first and second criteria of a search request to a first group according to a logical relationship between the first and second criteria; an identifier to determine, via the plurality of counts, which of the first and second criteria in the first group is satisfied by a least amount of records in the database; and a reduced set generator to form a reduced set of records to be searched based on the determined one of the first and second criteria satisfying the least amount of records in the database.

Claims (30)

1. An apparatus, comprising:

a count generator to generate a plurality of counts, the counts respectively indicative of a number of corresponding records in a database satisfying a respective one of a plurality of criteria present in the database;

a grouper to assign first and second criteria of a search request to a first group according to a logical relationship between the first and second criteria;

an identifier to determine, via the plurality of counts, which of the first and second criteria in the first group is satisfied by a least amount of records in the database;

a reduced set generator to identify a reduced set of records in the database to be searched, the reduced set of records corresponding to the first or second criteria that is satisfied by the least amount of records in the database; and

an analyzer to search the reduced set of records from the database, the reduced set of records reducing a search time associated with the search request, wherein first ones of the plurality of counts corresponding to static ones of the plurality of criteria are generated according to a schedule, and second ones of the plurality of counts corresponding to dynamic ones of the plurality of criteria are generated in response to receiving a search request, at least one of the count generator, the grouper, the identifier, the reduced set generator or the analyzer including hardware.

2. The apparatus as defined in claim 1 , further including an interface is to determine whether a second search request includes more than one criterion.

3. The apparatus as defined in claim 2 , wherein the analyzer to search the database without generating the reduced set of records when the second search request includes only one criterion.

4. The apparatus as defined in claim 1 , wherein the database includes a product database, and the plurality of criteria are characteristic-value pairs.

5. The apparatus as defined in claim 1 , wherein the logical relationship between the first and second criteria is defined by an AND operator.

6. A method, comprising:

generating, with a processor, a plurality of counts, the counts respectively indicative of a corresponding number of records in a database satisfying a respective one of a plurality of criteria present in the database;

assigning, with the processor, first and second criteria of a search request to a first group according to a logical relationship between the first and second criteria;

determining, with the processor, based on at least some of the plurality of counts, which of the first and second criteria in the first group is satisfied by a least amount of records in the database;

forming, with the processor, a reduced set of records in the database to be searched, the reduced set of records corresponding to the first or second criteria that is satisfied by the least amount of records in the database; and

searching the reduced set of records from the database, the reduced set of records reducing a search time associated with the search request, wherein first ones of the plurality of counts corresponding to static ones of the plurality of criteria are generated according to a schedule, and second ones of the plurality of counts corresponding to dynamic ones of the plurality of criteria are generated in response to receiving a search request.

7. The method as defined in claim 6 , further including determining whether a second search request includes more than one criterion.

8. The method as defined in claim 7 , further including searching the database without generating the reduced set of records when the second search request includes only one criterion.

9. The method as defined in claim 6 , wherein the database includes a product database, and the plurality of criteria are characteristic-value pairs.

10. The method as defined in claim 6 , wherein the logical relationship between the first and second criteria is defined by an AND operator.

11. A tangible machine readable storage medium comprising instructions that, when executed, cause a machine to at least:

generate a plurality of counts, the counts respectively indicative of a corresponding number of records in a database satisfying a respective one of a plurality of criteria present in the database;

assign first and second criteria of a search request to a first group according to a logical relationship between the first and second criteria;

determine, based on at least some of the counts, which of the first and second criteria in the first group is satisfied by a least amount of records in the database;

form a reduced set of records to be searched in the database corresponding to the determined one of the first and second criteria satisfying the least amount of records in the database; and

search the reduced set of records in the database, the reduced set of records reducing a search time associated with the search request, wherein first ones of the plurality of counts corresponding to static ones of the plurality of criteria are generated according to a schedule, and second ones of the plurality of counts corresponding to dynamic ones of the plurality of criteria are generated in response to receiving a search request.

12. The storage medium as defined in claim 11 , wherein the instructions, when executed, cause the machine to determine whether a second search request includes more than one criterion.

13. The storage medium as defined in claim 12 , wherein the instructions, when executed, cause the machine to search the database without generating the reduced set of records when the second search request includes only one criterion.

14. The storage medium as defined in claim 11 , wherein the database includes a product database, and the plurality of criteria are characteristic-value pairs.

15. The storage medium as defined in claim 11 , wherein the logical relationship between the first and second criteria is defined by an AND operator.

Assignments (10)
RELEASE (REEL 053473 / FRAME 0001) Recorded May 11, 2023
From: CITIBANK, N.A.
To: A. C. NIELSEN COMPANY, LLC; EXELATE, INC.; GRACENOTE, INC.; GRACENOTE MEDIA SERVICES, LLC; THE NIELSEN COMPANY (US), LLC; NETRATINGS, LLC
Reel/Frame 063603/0001 →
RELEASE (REEL 054066 / FRAME 0064) Recorded May 11, 2023
From: CITIBANK, N.A.
To: A. C. NIELSEN COMPANY, LLC; EXELATE, INC.; GRACENOTE, INC.; GRACENOTE MEDIA SERVICES, LLC; THE NIELSEN COMPANY (US), LLC; NETRATINGS, LLC
Reel/Frame 063605/0001 →
RELEASE (REEL 037172 / FRAME 0415) Recorded Oct 13, 2022
From: CITIBANK, N.A.
To: THE NIELSEN COMPANY (US), LLC
Reel/Frame 061750/0221 →
SECURITY INTEREST Recorded Mar 25, 2021
From: NIELSEN CONSUMER LLC; BYZZER INC.
To: BANK OF AMERICA, N.A., AS ADMINISTRATIVE AGENT AND COLLATERAL AGENT
Reel/Frame 055742/0719 →
PARTIAL RELEASE OF SECURITY INTEREST Recorded Mar 10, 2021
From: CITIBANK, N.A.
To: NIELSEN CONSUMER NEUROSCIENCE, INC.; NIELSEN CONSUMER LLC
Reel/Frame 055557/0949 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Feb 17, 2021
From: THE NIELSEN COMPANY (US), LLC
To: NIELSEN CONSUMER LLC
Reel/Frame 055325/0353 →
CORRECTIVE ASSIGNMENT TO CORRECT THE PATENTS LISTED ON SCHEDULE 1 RECORDED ON 6-9-2020 PREVIOUSLY RECORDED ON REEL 053473 FRAME 0001. ASSIGNOR(S) HEREBY CONFIRMS THE SUPPLEMENTAL IP SECURITY AGREEMENT. Recorded Oct 7, 2020
From: A.C. NIELSEN (ARGENTINA) S.A.; A.C. NIELSEN COMPANY, LLC; ACN HOLDINGS INC.; ACNIELSEN CORPORATION; ACNIELSEN ERATINGS.COM; AFFINNOVA, INC.; ART HOLDING, L.L.C.; ATHENIAN LEASING CORPORATION; CZT/ACN TRADEMARKS, L.L.C.; EXELATE, INC.; GRACENOTE, INC.; GRACENOTE DIGITAL VENTURES, LLC; GRACENOTE MEDIA SERVICES, LLC; NETRATINGS, LLC; NIELSEN AUDIO, INC.; NIELSEN CONSUMER INSIGHTS, INC.; NIELSEN CONSUMER NEUROSCIENCE, INC.; NIELSEN FINANCE CO.; NIELSEN FINANCE LLC; NIELSEN INTERNATIONAL HOLDINGS, INC.; NIELSEN MOBILE, LLC; NMR INVESTING I, INC.; TCG DIVESTITURE INC.; TNC (US) HOLDINGS, INC.; THE NIELSEN COMPANY (US), LLC; VIZU CORPORATION; VNU MARKETING INFORMATION, INC.; NMR LICENSING ASSOCIATES, L.P.; NIELSEN HOLDING AND FINANCE B.V.; THE NIELSEN COMPANY B.V.; VNU INTERNATIONAL B.V.
To: CITIBANK, N.A
Reel/Frame 054066/0064 →
SUPPLEMENTAL SECURITY AGREEMENT Recorded Jun 9, 2020
From: A. C. NIELSEN COMPANY, LLC; ACN HOLDINGS INC.; ACNIELSEN CORPORATION; ACNIELSEN ERATINGS.COM; AFFINNOVA, INC.; ART HOLDING, L.L.C.; ATHENIAN LEASING CORPORATION; CZT/ACN TRADEMARKS, L.L.C.; EXELATE, INC.; GRACENOTE, INC.; GRACENOTE DIGITAL VENTURES, LLC; GRACENOTE MEDIA SERVICES, LLC; NETRATINGS, LLC; NIELSEN AUDIO, INC.; NIELSEN CONSUMER INSIGHTS, INC.; NIELSEN CONSUMER NEUROSCIENCE, INC.; NIELSEN FINANCE CO.; NIELSEN FINANCE LLC; NIELSEN INTERNATIONAL HOLDINGS, INC.; NIELSEN MOBILE, LLC; NIELSEN UK FINANCE I, LLC; NMR INVESTING I, INC.; TCG DIVESTITURE INC.; TNC (US) HOLDINGS, INC.; THE NIELSEN COMPANY (US), LLC; VIZU CORPORATION; VNU MARKETING INFORMATION, INC.; NMR LICENSING ASSOCIATES, L.P.; NIELSEN HOLDING AND FINANCE B.V.; THE NIELSEN COMPANY B.V.; VNU INTERNATIONAL B.V.
To: CITIBANK, N.A.
Reel/Frame 053473/0001 →
SUPPLEMENTAL IP SECURITY AGREEMENT Recorded Nov 30, 2015
From: THE NIELSEN COMPANY ((US), LLC
To: CITIBANK, N.A., AS COLLATERAL AGENT FOR THE FIRST LIEN SECURED PARTIES
Reel/Frame 037172/0415 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Feb 25, 2015
From: RABOLT, KENNETH; KARUPPIAH, NAGARAJAN
To: THE NIELSEN COMPANY (US), LLC
Reel/Frame 035030/0594 →