IP Library Granted Patent US 9,990,478
Granted Patent B2
US 9,990,478 · App. 13/691,515 · Granted Jun 5, 2018

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

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,990,478
App. No.
13/691,515
Granted
Jun 5, 2018
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. An example method to encode auxiliary data into relational data includes generating a code comprising a plurality of groups and representative of auxiliary data, determining incremental values for the plurality of groups, generating a first key based on the code, and generating a subsequent key by modifying the first key based on the value of the first key and the incremental values.

Claims (44)

1. A method to encode auxiliary data into relational data to determine party authorization, the method comprising:

dividing, by executing an instruction with a code generator, a code representative of the auxiliary data into a plurality of groups;

determining, by executing an instruction with an increment determiner, minimum values for respective ones of the plurality of groups by subtracting a base number from each of the plurality of groups;

selecting, by executing an instruction with the increment determiner, nearest prime numbers greater than the minimum values for the respective ones of the plurality of groups as respective incremental values for the respective ones of the plurality of groups;

generating, by executing an instruction with a database key generator, a first relational database key encoded with the code representative of the auxiliary data;

generating, by executing an instruction with the database key generator, a subsequent relational database key encoded with the code representative of the auxiliary data, the subsequent relational database key generated from the first relational database key using a value of the first relational database key and the incremental values;

generating, by executing an instruction with a relational data builder, first and second database entries in a database using the first relational database key and the subsequent relational database key, the first relational database key and the subsequent relational database key encoded with the code representative of the auxiliary data to permit data corresponding to the database to be identified; and

transmitting, by executing an instruction with the relational data builder, the relational data to a requesting party via a network communication, the relational data including the first relational database key and the subsequent relational database key.

2. The method as defined in claim 1 , wherein the generating of the subsequent relational database key includes generating a value for the subsequent relational database key such that a modulo operation of the first relational database key and the subsequent relational database key based on the incremental values have identical results.

3. The method as defined in claim 1 , wherein the plurality of groups in the code have respective initial values, and the determining of the incremental values includes determining the prime numbers for the respective ones of the groups, the prime numbers for the respective ones of the groups being larger than the respective initial values of the corresponding groups.

4. The method as defined in claim 1 , further including determining respective upper values for the respective ones of the groups, wherein the generating of the subsequent relational database key includes incrementing a second one of the groups when a first one of the groups is equal to the respective upper value for the first one of the groups.

5. The method as defined in claim 1 , wherein each of the plurality of groups is representative of a character of the auxiliary data.

6. The method as defined in claim 1 , further including encrypting the auxiliary data to generate the code.

7. The method as defined in claim 1 , further including modifying the auxiliary data using a base number to generate the code.

8. The method as defined in claim 1 , further including performing an operation on the auxiliary data according to a base algorithm to generate the code.

9. The method as defined in claim 1 , wherein the first and subsequent relational database keys indicate relationships between items or pieces of the data in a database.

10. An apparatus to encode auxiliary data into relational data to determine party authorization, the apparatus comprising:

a code generator to generate a code including a plurality of groups and representative of the auxiliary data;

an increment determiner to determine minimum values for respective ones of the plurality of groups by subtracting a base number from each of the plurality of groups, and determine respective incremental values for the respective ones of the plurality of groups by selecting nearest prime numbers greater than the minimum values for the respective ones of the plurality of groups as the respective incremental values for the respective ones of the plurality of groups;

a database key generator to generate a first relational database key based on the code representative of the auxiliary data, and to generate a subsequent relational database key encoded with the code representative of the auxiliary data, the subsequent relational database key generated from the first relational database key using a value of the first relational database key and the incremental values; and

a relational data builder to:

generate first and second database entries in a database using the first relational database key and the subsequent relational database key, the first relational database key and the subsequent relational database encoded with the code representative of the auxiliary data to permit data corresponding to the database to be identified; and

transmit the relational data to a requesting party via a network communication, the relational data including the first relational database key and the subsequent relational database key, at least one of the code generator, the increment determiner, or the database key generator, the relational data builder, or the auxiliary data manager including hardware.

11. The apparatus as defined in claim 10 , wherein the code generator is to generate the code by modifying the auxiliary data using a base number.

12. The apparatus as defined in claim 10 , wherein the increment determiner is to determine the incremental values to be prime numbers greater than the respective minimum values of the code for the plurality of groups.

13. The apparatus as defined in claim 10 , wherein the database key generator is to generate the subsequent relational database key by modifying a value of one of the groups of the first relational database key by an incremental value of the one of the groups.

14. The apparatus as defined in claim 10 , wherein the increment determiner is to determine respective upper values for respective ones of the groups, the database key generator to generate the subsequent relational database key by incrementing a second one of the groups when a first one of the groups is equal to the respective upper value for the first one of the groups.

15. The apparatus as defined in claim 10 , wherein the first and subsequent relational database keys indicate relationships between items or pieces of the data in the database.

16. A tangible computer readable storage medium comprising computer readable instructions which, when executed, cause a processor to:

divide, with a code generator, a code representative of auxiliary data into a plurality of groups;

determine, with an increment determiner, minimum values for respective ones of the plurality of groups by subtracting a base number from each of the plurality of groups;

select, with the increment determiner, nearest prime numbers greater than the minimum values for the respective ones of the plurality of groups as respective incremental values for the respective ones of the plurality of groups;

generate, with a database key generator, a first relational database key based on the code representative of the auxiliary data;

generate, with the database key generator, a subsequent relational database key encoded with the code representative of the auxiliary data, the subsequent relational database key generated from the first relational database key using a value of the first relational database key and the incremental values;

generate, with a relational data builder, first and second database entries in a database using the first relational database key and the subsequent relational database key, the first relational database key and the subsequent relational database key encoded with the code representative of the auxiliary data to permit data corresponding to the database to be identified; and

transmit, using the relational data builder, the relational data to a requesting party via a network communication, the relational data including the first relational database key and the subsequent relational database key.

17. The tangible computer readable storage medium as defined in claim 16 , wherein the instructions are to cause the processor to generate the subsequent relational database key by generating a value for the subsequent relational database key such that a modulo operation of the first relational database key and the subsequent relational database key based on the incremental values have identical results.

18. The tangible computer readable storage medium as defined in claim 16 , wherein the plurality of groups in the code have respective initial values, and the determining of the incremental values includes determining the prime numbers for the respective ones of the groups, the prime numbers for the respective ones of the groups being larger than the respective initial values of the corresponding groups.

19. The tangible computer readable storage medium as defined in claim 16 , wherein the instructions are further to cause the processor to determine respective upper values for respective ones of the groups, the instructions to cause the processor to generate the subsequent relational database key by incrementing a second one of the groups when a first one of the groups is equal to the respective upper values for the first one of the groups.

20. The tangible computer readable storage medium as defined in claim 16 , wherein each of the plurality of groups is representative of a character of the auxiliary data.

21. The tangible computer readable storage medium as defined in claim 16 , wherein the instructions are further to cause the processor to encrypt the auxiliary data to generate the code.

22. The tangible computer readable storage medium as defined in claim 16 , wherein the instructions are further to cause the processor to modify the auxiliary data using a base number to generate the code.

23. The tangible computer readable storage medium as defined in claim 16 , wherein the instructions are to cause the processor to perform an operation on the auxiliary data according to a base algorithm to generate the code.

24. The tangible computer readable storage medium as defined in claim 16 , wherein the first and subsequent relational database keys indicate relationships between items or pieces of the data in the database.

Assignments (10)
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 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 →
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 →
RELEASE (REEL 037172 / FRAME 0415) Recorded Oct 13, 2022
From: CITIBANK, N.A.
To: THE NIELSEN COMPANY (US), LLC
Reel/Frame 061750/0221 →
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 13, 2013
From: AYZENSHTAT, LEONID; GEORGIEV, NIKOLAY; RAJAMANI, KALYANARAMAN
To: THE NIELSEN COMPANY (US), LLC
Reel/Frame 029806/0928 →