IP Library Granted Patent US 11,106,765
Granted Patent B2
US 11,106,765 · App. 15/973,098 · Granted Aug 31, 2021

Methods, apparatus, and articles of manufacture to encode auxiliary data into relational database keys and methods, apparatus, and articles of manufacture to obtain encoded data from relational database keys

Inventors: Leonid Ayzenshtat (Jacksonville, FL); Nikolay Georgiev (San Jose, CA); Kalyanaraman Rajamani (Tampa, FL)
Assignee: The Nielsen Company (US), LLC
G06F21/16G06F21/10
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 11,106,765
App. No.
15/973,098
Granted
Aug 31, 2021
Kind
B2
Abstract

Methods, apparatus, and articles of manufacture to encode auxiliary data into relational database keys and methods, apparatus, and articles of manufacture to obtain encoded data from relational database keys are disclosed. Example apparatus disclosed herein include a code determiner to divide a relational database key value into a first number of groups. Disclosed example apparatus also includes an encoded data determiner to determine remainders for respective ones of the groups based on corresponding incremental values, and modify the remainders to obtain the encoded data.

Claims (51)

1. An apparatus to decode encoded data from relational data, the apparatus comprising:

memory;

an interface to access network communications to obtain a relational database key value, a first base number, and a second base number, the relational database key value corresponding to encoded auxiliary data; and

a processor to execute instructions to:

divide the relational database key value into a first number of groups;

determine first remainders for respective ones of the groups based on corresponding first incremental values;

modify the first remainders using the first base number to generate first encoded values; and

when the first encoded values do not correspond to a first result:

determine second remainders for respective ones of the groups based on corresponding second incremental values; and

modify the second remainders using Rail the second base number to obtain the encoded auxiliary data.

2. The apparatus of claim 1 , wherein the processor is to:

divide a second relational database key value into the first number of groups; and

determine third remainders for the respective ones of the groups based on the corresponding second incremental values, the third remainders being equal to the first remainders for corresponding groups.

3. The apparatus of claim 1 , wherein the processor is to modify the first remainders by at least one of adding, subtracting, multiplying, or dividing the first remainders with the first base number to obtain the encoded auxiliary data.

4. The apparatus of claim 1 ; wherein the processor is to:

obtain the first incremental values; and

determine the first remainders by performing a modulo operation on the groups using the first incremental values.

5. The apparatus of claim 1 , wherein the processor is to assemble modified remainders corresponding to the groups to obtain the encoded auxiliary data.

6. The apparatus of claim 1 , wherein the processor is to decrypt the encoded auxiliary data.

7. The apparatus of claim 1 , wherein the processor is to obtain at least one of a plurality of base numbers or a plurality of incremental values.

8. A non-transitory computer readable storage medium comprising computer readable instructions which; when executed, cause a machine to at least:

access network communications to obtain a relational database key value, a first base number, and a second base number, the relational database key value corresponding to encoded auxiliary data;

divide the relational database key value into a first number of groups;

determine first remainders for respective ones of the groups based on corresponding first incremental values;

modify the first remainders using the first base number to generate first encoded values;

when the first encoded values do not correspond to first auxiliary data:

determine second remainders for respective ones of the groups based on corresponding second incremental values; and

modify the second remainders using the second base number to obtain the encoded auxiliary data.

9. The non-transitory computer readable storage medium of claim 8 , wherein the instructions are further to cause the machine to extract the relational database key value from relational data.

10. The non-transitory computer readable storage medium of claim 8 , wherein the instructions cause the machine to:

divide a second relational database key value into the first number of groups; and

determine third remainders for the respective ones of the groups based on the corresponding second incremental values, the third remainders being equal to the first remainders for corresponding groups.

11. The non-transitory computer readable storage medium of claim 8 , wherein the encoded auxiliary data includes a first number of alphanumeric characters.

12. The non-transitory computer readable storage medium of claim 8 , wherein the instructions cause the machine to modify the first remainders by at least one of adding, subtracting, multiplying, or dividing the first remainders with the first base number to obtain the encoded auxiliary data.

13. The non-transitory computer readable storage medium of claim 8 , wherein the instructions cause the machine to decrypt an encoded value including the modified remainders to obtain the encoded auxiliary data.

14. The non-transitory computer readable storage medium of claim 8 , wherein the instructions cause the machine to obtain the first incremental values, and to determine the first remainders by performing modulo operations on the groups using the first incremental values.

15. The non-transitory computer readable storage medium of claim 8 , wherein the instructions cause the machine to obtain at least one of a plurality of base numbers or a plurality of incremental values.

16. A method to decode auxiliary data from relational data, the method comprising:

accessing network communications to obtain a relational database key value, a first base number, and a second base number, the relational database key value corresponding to encoded auxiliary data;

dividing, by executing an instruction with a processor, the relational database key value into a first number of groups;

determining, by executing an instruction with the processor, first remainders for respective ones of the groups based on corresponding first incremental values;

modifying, by executing an instruction with the processor, the first remainders using the first base number to generate first encoded values; and

when the first encoded values do not correspond to a first result;

determining second remainders for respective ones of the groups based on corresponding second incremental values; and

modifying the second remainders using the second base number to obtain the encoded auxiliary data.

17. The method of claim 16 , further including extracting the relational database key value from relational data.

18. The method of claim 16 , further including:

dividing a second relational database key value into the first number of groups; and

determining third remainders for the respective ones of the groups based on the corresponding second incremental values, the third remainders being equal to the third remainders for corresponding groups.

19. The method of claim 16 , further including decrypting an encoded value including the modified remainders to obtain the encoded auxiliary data.

20. The method of claim 16 , further including obtaining the first incremental values, and determining the first remainders by performing modulo operations on the groups using the first incremental values.

Assignments (8)
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 →
SECURITY INTEREST Recorded May 8, 2023
From: GRACENOTE DIGITAL VENTURES, LLC; GRACENOTE MEDIA SERVICES, LLC; GRACENOTE, INC.; TNC (US) HOLDINGS, INC.; THE NIELSEN COMPANY (US), LLC
To: ARES CAPITAL CORPORATION
Reel/Frame 063574/0632 →
SECURITY INTEREST Recorded Apr 28, 2023
From: GRACENOTE DIGITAL VENTURES, LLC; GRACENOTE MEDIA SERVICES, LLC; GRACENOTE, INC.; TNC (US) HOLDINGS, INC.; THE NIELSEN COMPANY (US), LLC
To: CITIBANK, N.A.
Reel/Frame 063561/0381 →
SECURITY AGREEMENT Recorded Jan 31, 2023
From: GRACENOTE DIGITAL VENTURES, LLC; GRACENOTE MEDIA SERVICES, LLC; GRACENOTE, INC.; TNC (US) HOLDINGS, INC.; THE NIELSEN COMPANY (US), LLC
To: BANK OF AMERICA, N.A.
Reel/Frame 063560/0547 →
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 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jun 7, 2018
From: AYZENSHTAT, LEONID; GEORGIEV, NIKOLAY; RAJAMANI, KALYANARAMAN
To: THE NIELSEN COMPANY (US), LLC
Reel/Frame 046013/0633 →
Continuity (2)
Continuation 13691515 · Nov 30, 2012
Related Publication 20180253537A1 · Sep 6, 2018