IP Library Granted Patent US 8,365,247
Granted Patent B1
US 8,365,247 · App. 12/495,491 · Granted Jan 29, 2013

Identifying whether electronic data under test includes particular information from a database

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 8,365,247
App. No.
12/495,491
Granted
Jan 29, 2013
Kind
B1
Abstract

Electronic circuitry includes an input/output (I/O) interface, memory which stores a set of database fingerprints generated from records of a database, and an analyzing circuit coupled to the I/O interface and the memory. The analyzing circuit is constructed and arranged to derive a set of sample tokens from electronic data under test (e.g., an email, an electronic document, etc.), and form a set of sample fingerprints from the set of sample tokens. Each sample fingerprint is based on a sample token of the set of sample tokens. The analyzing circuit is further constructed and arranged to output a result signal based on a comparison between the set of sample fingerprints and the set of database fingerprints. The result signal provides an indication of whether the electronic data under test includes particular information from the database.

Claims (111)

1. A method of identifying whether electronic data under test includes particular information from a database, the method comprising:

deriving a set of sample tokens from the electronic data under test;

forming a set of sample fingerprints from the set of sample tokens, each sample fingerprint being based on a sample token of the set of sample tokens; and

outputting a result signal based on a comparison between the set of sample fingerprints and a set of database fingerprints generated from records of the database, the result signal providing an indication of whether the electronic data under test includes the particular information from the database;

wherein deriving the set of sample tokens includes:

parsing the electronic data under test into a series of un-normalized words, and

removing predefined characters from the series of un-normalized words to form, as the set of sample tokens, a series of normalized words, each normalized word including a string of actual characters;

wherein forming the set of sample fingerprints from the set of sample tokens includes:

applying a hashing function to the string of actual characters of each normalized word of the series of normalized words to generate, as the set of sample fingerprints, hash results corresponding to the series of normalized words;

wherein outputting the result signal based on the comparison between the set of sample fingerprints and the set of database fingerprints includes:

searching the set of database fingerprints for the hash results and determining whether, for any record of the database, a predetermined number of database fingerprints corresponding to that record is found to match the hash results, and

providing the result signal with one of (i) a first control value when, for any record of the database, the predetermined number of database fingerprints corresponding to that record is found to match the hash results, and (ii) a second control value when, for each record of the database, less than the predetermined number of database fingerprints corresponding to that record is found to match the hash results, the first value being different than the second value;

wherein the method further comprises:

blocking access to the electronic data under test when the result signal has the first control value, and permitting access to the electronic data under test when the result signal has the second control value;

wherein searching and determining includes:

receiving a set of fingerprint matching rules,

providing a set of intermediate search results based on searching the set of database fingerprints for the hash results, and

applying the set of fingerprint matching rules to the set of intermediate search results to identify whether, for any record of the database, the predetermined number of database fingerprints corresponding to that record is found to match the hash results;

wherein the set of database fingerprints resides in a database fingerprint structure which increases monotonically based on the database fingerprints of the set of database fingerprints; and

wherein providing the set of intermediate search results based on searching the set of database fingerprints for the hash results includes:

carrying out a binary search of the database fingerprint structure for the hash results.

2. A method as in claim 1 wherein the electronic data under test is an email message; and wherein blocking and permitting includes:

preventing transmission of the email message from a secure electronic device to a non-secure electronic device over a computerized network when the result signal has the first control value, and

allowing transmission of the email message from the secure electronic device to the non-secure electronic device over the computerized network when the result signal has the second control value.

3. A method as in claim 1 wherein the electronic data under test is an electronic document; and wherein blocking and permitting includes:

preventing copying of the electronic document from a secure electronic device to a non-secure electronic device when the result signal has the first control value, and

allowing copying of the electronic document from the secure electronic device to the non-secure electronic device when the result signal has the second control value.

4. A method as in claim 1 wherein the electronic data under test is an unencrypted version of an electronic file stored on a server; and wherein blocking and permitting includes:

generating an encrypted version of the electronic file from the unencrypted version of an electronic file and replacing, on the server, the unencrypted version of an electronic file with the encrypted version of the electronic file when the result signal has the first control value, and

allowing the unencrypted version of the electronic file stored on the server to remain intact when the result signal has the second control value.

5. A method as in claim 1 wherein receiving the set of fingerprint matching rules includes:

obtaining at least one multi-token matching rule which imposes a proximity threshold between discovered individual fingerprint matches.

6. A method as in claim 1 wherein receiving the set of fingerprint matching rules includes:

obtaining at least one matching rule which labels certain database fingerprints for optional matching to enable incorporation within the result signal of a confidence ranking which is based on a number of optional matching sample fingerprints.

7. A method as in claim 1 , further comprising:

querying the records of the database to create a list of query results, and generating the set of database fingerprints from the list of query results.

8. A method as in claim 7 wherein each query result of the list of query results includes a set of un-normalized words corresponding to a record of the database; and

wherein generating the set of database fingerprints from the list of query results includes, for each query result, (i) removing predefined characters from the set of un-normalized words of that query result to form a set of normalized words, each normalized word including a string of actual characters, (ii) applying a hashing function to the string of actual characters of each normalized word to provide a set of hash results as the set of database fingerprints, and (iii) storing the hash results in a database fingerprint structure.

9. A method as in claim 8 wherein each hash result includes a fingerprint value; and wherein storing the hash results in a database fingerprint structure includes:

ordering the hash results within the database fingerprint structure to increase monotonically based on fingerprint value.

10. Electronic circuitry, comprising:

an input/output (I/O) interface;

memory which stores a set of database fingerprints generated from records of a database; and

an analyzing circuit coupled to the I/O interface and the memory, the analyzing circuit being constructed and arranged to:

derive a set of sample tokens from electronic data under test,

form a set of sample fingerprints from the set of sample tokens, each sample fingerprint being based on a sample token of the set of sample tokens, and

output a result signal based on a comparison between the set of sample fingerprints and the set of database fingerprints, the result signal providing an indication of whether the electronic data under test includes particular information from the database;

wherein the analyzing circuit, when deriving the set of sample tokens, is constructed and arranged to:

parse the electronic data under test into a series of un-normalized words, and

remove predefined characters from the series of un-normalized words to form, as the set of sample tokens, a series of normalized words, each normalized word including a string of actual characters;

wherein the analyzing circuit, when forming the set of sample fingerprints from the set of sample tokens, is constructed and arranged to:

apply a hashing function to the string of actual characters of each normalized word of the series of normalized words to generate, as the set of sample fingerprints, hash results corresponding to the series of normalized words;

wherein the analyzing circuit, when outputting the result signal based on the comparison between the set of sample fingerprints and the set of database fingerprints, is constructed and arranged to:

search the set of database fingerprints for the hash results and determining whether, for any record of the database, a predetermined number of database fingerprints corresponding to that record is found to match the hash results, and

provide the result signal with one of (i) a first control value when, for any record of the database, the predetermined number of database fingerprints corresponding to that record is found to match the hash results, and (ii) a second control value when, for each record of the database, less than the predetermined number of database fingerprints corresponding to that record is found to match the hash results, the first value being different than the second value;

wherein the analyzing circuit is further constructed and arranged to:

block access to the electronic data under test when the result signal has the first control value, and permitting access to the electronic data under test when the result signal has the second control value;

wherein the analyzing circuit, when searching and determining, is constructed and arranged to:

receive a set of fingerprint matching rules,

provide a set of intermediate search results based on searching the set of database fingerprints for the hash results, and

apply the set of fingerprint matching rules to the set of intermediate search results to identify whether, for any record of the database, the predetermined number of database fingerprints corresponding to that record is found to match the hash results;

wherein the set of database fingerprints resides in a database fingerprint structure which increases monotonically based on the database fingerprints of the set of database fingerprints; and

wherein the analyzing circuit, when providing the set of intermediate search results based on searching the set of database fingerprints for the hash results, is constructed and arranged to:

carry out a binary search of the database fingerprint structure for the hash results.

11. Electronic circuitry as in claim 10 , further comprising:

an aggregating circuit in communication with the memory, the aggregating circuit being constructed and arranged to query the records of the database to create a list of query results, and generate the set of database fingerprints from the list of query results for storage in the memory.

12. Electronic circuitry as in claim 11 wherein each query result of the list of query results includes a set of un-normalized words corresponding to a record of the database; and

wherein the aggregating circuit, when generating the set of database fingerprints from the list of query results, is constructed and arranged to:

for each query result, (i) remove predefined characters from the set of un-normalized words of that query result to form a set of normalized words, each normalized word including a string of actual characters, (ii) apply a hashing function to the string of actual characters of each normalized word to provide a set of hash results as the set of database fingerprints, and (iii) store the hash results in a database fingerprint structure in the memory.

13. A method as in claim 8 ,

wherein the list of query results includes a set of data categories, each data category of the set of data categories corresponding to a field in the database; and

wherein the method further comprises:

receiving a set of fingerprint matching rules, the set of fingerprint matching rules being based on the set of data categories, and

providing the set of fingerprint rules to the database fingerprint structure.

14. A method of identifying whether electronic data under test includes particular information from a database, the method comprising:

deriving a set of sample tokens from the electronic data under test;

forming a set of sample fingerprints from the set of sample tokens, each sample fingerprint being based on a sample token of the set of sample tokens; and

outputting a result signal based on a comparison between the set of sample fingerprints and a set of database fingerprints generated from records of the database, the result signal providing an indication of whether the electronic data under test includes the particular information from the database;

wherein the method further comprises:

querying the records of the database to create a list of query results, and generating the set of database fingerprints from the list of query results;

wherein each query result of the list of query results includes a set of un normalized words corresponding to a record of the database;

wherein generating the set of database fingerprints from the list of query results includes, for each query result, (i) removing predefined characters from the set of un normalized words of that query result to form a set of normalized words, each normalized word including a string of actual characters, (ii) applying a hashing function to the string of actual characters of each normalized word to provide a set of hash results as the set of database fingerprints, and (iii) storing the hash results in a database fingerprint structure;

wherein the list of query results includes a set of data categories, each data category of the set of data categories corresponding to a field in the database;

wherein the method further comprises:

receiving a set of fingerprint matching rules, the set of fingerprint matching rules being based on the set of data categories, and

providing the set of fingerprint rules to the database fingerprint structure; and

wherein each query result of the list of query results includes a set of cells, each cell of the set of cells including an un-normalized word of the set of un-normalized words and being associated with a data category of the set of data categories, each un-normalized word of the set of un-normalized words being a value of the data category associated with the cell;

wherein removing predefined characters from the set of un-normalized words of that query result to form a set of normalized words includes:

for each cell of the set of cells of that query result, deleting the predefined characters from the un-normalized word of the cell to form a normalized word associated with the cell; and

wherein receiving the set of fingerprint matching rules includes:

obtaining at least one matching rule which labels certain database fingerprints of the set of database fingerprints for required matching, a database fingerprint being labeled for required matching being based on whether the database fingerprint is a hash result resulting from an application of the hashing function to a set of actual characters of a normalized word associated with a cell to which a particular data category of the set of data categories is associated.

15. Electronic circuitry, comprising:

an input/output (I/O) interface;

memory which stores a set of database fingerprints generated from records of a database; and

an analyzing circuit coupled to the I/O interface and the memory, the analyzing circuit being constructed and arranged to:

derive a set of sample tokens from electronic data under test,

form a set of sample fingerprints from the set of sample tokens, each sample fingerprint being based on a sample token of the set of sample tokens, and

output a result signal based on a comparison between the set of sample fingerprints and the set of database fingerprints, the result signal providing an indication of whether the electronic data under test includes particular information from the database;

wherein the analyzing circuit is further constructed and arranged to:

query the records of the database to create a list of query results, and generating the set of database fingerprints from the list of query results;

wherein each query result of the list of query results includes a set of un normalized words corresponding to a record of the database;

wherein the analyzing circuit, when generating the set of database fingerprints from the list of query results, is constructed and arranged to, for each query result, (i) remove predefined characters from the set of un normalized words of that query result to form a set of normalized words, each normalized word including a string of actual characters, (ii) apply a hashing function to the string of actual characters of each normalized word to provide a set of hash results as the set of database fingerprints, and (iii) store the hash results in a database fingerprint structure;

wherein the list of query results includes a set of data categories, each data category of the set of data categories corresponding to a field in the database;

wherein the analyzing circuit is further constructed and arranged to:

receive a set of fingerprint matching rules, the set of fingerprint matching rules being based on the set of data categories, and

provide the set of fingerprint rules to the database fingerprint structure; and

wherein each query result of the list of query results includes a set of cells, each cell of the set of cells including an un-normalized word of the set of un-normalized words and being associated with a data category of the set of data categories, each un-normalized word of the set of un-normalized words being a value of the data category associated with the cell;

wherein the analyzing circuit, when removing predefined characters from the set of un-normalized words of that query result to form a set of normalized words, is constructed and arranged to:

for each cell of the set of cells of that query result, delete the predefined characters from the un-normalized word of the cell to form a normalized word associated with the cell; and

wherein the analyzing circuit, when receiving the set of fingerprint matching rules, is constructed and arranged to:

obtain at least one matching rule which labels certain database fingerprints of the set of database fingerprints for required matching, a database fingerprint being labeled for required matching being based on whether the database fingerprint is a hash result resulting from an application of the hashing function to a set of actual characters of a normalized word associated with a cell to which a particular data category of the set of data categories is associated.

Assignments (14)
RELEASE OF SECURITY INTEREST IN PATENTS PREVIOUSLY RECORDED AT REEL/FRAME (053546/0001) Recorded Jun 23, 2022
From: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A., AS NOTES COLLATERAL AGENT
To: DELL MARKETING L.P. (ON BEHALF OF ITSELF AND AS SUCCESSOR-IN-INTEREST TO CREDANT TECHNOLOGIES, INC.); DELL INTERNATIONAL L.L.C.; DELL PRODUCTS L.P.; DELL USA L.P.; EMC CORPORATION; DELL MARKETING CORPORATION (SUCCESSOR-IN-INTEREST TO FORCE10 NETWORKS, INC. AND WYSE TECHNOLOGY L.L.C.); EMC IP HOLDING COMPANY LLC
Reel/Frame 071642/0001 →
RELEASE OF SECURITY INTEREST IN PATENTS PREVIOUSLY RECORDED AT REEL/FRAME (045455/0001) Recorded May 20, 2022
From: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A., AS NOTES COLLATERAL AGENT
To: DELL MARKETING CORPORATION (SUCCESSOR-IN-INTEREST TO ASAP SOFTWARE EXPRESS, INC.); DELL MARKETING L.P. (ON BEHALF OF ITSELF AND AS SUCCESSOR-IN-INTEREST TO CREDANT TECHNOLOGIES, INC.); DELL USA L.P.; DELL INTERNATIONAL L.L.C.; DELL PRODUCTS L.P.; DELL MARKETING CORPORATION (SUCCESSOR-IN-INTEREST TO FORCE10 NETWORKS, INC. AND WYSE TECHNOLOGY L.L.C.); EMC CORPORATION (ON BEHALF OF ITSELF AND AS SUCCESSOR-IN-INTEREST TO MAGINATICS LLC); EMC IP HOLDING COMPANY LLC (ON BEHALF OF ITSELF AND AS SUCCESSOR-IN-INTEREST TO MOZY, INC.); SCALEIO LLC
Reel/Frame 061753/0001 →
RELEASE OF SECURITY INTEREST IN PATENTS PREVIOUSLY RECORDED AT REEL/FRAME (040136/0001) Recorded Apr 26, 2022
From: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A., AS NOTES COLLATERAL AGENT
To: DELL MARKETING CORPORATION (SUCCESSOR-IN-INTEREST TO ASAP SOFTWARE EXPRESS, INC.); DELL MARKETING L.P. (ON BEHALF OF ITSELF AND AS SUCCESSOR-IN-INTEREST TO CREDANT TECHNOLOGIES, INC.); DELL USA L.P.; DELL INTERNATIONAL L.L.C.; DELL PRODUCTS L.P.; DELL MARKETING CORPORATION (SUCCESSOR-IN-INTEREST TO FORCE10 NETWORKS, INC. AND WYSE TECHNOLOGY L.L.C.); EMC CORPORATION (ON BEHALF OF ITSELF AND AS SUCCESSOR-IN-INTEREST TO MAGINATICS LLC); EMC IP HOLDING COMPANY LLC (ON BEHALF OF ITSELF AND AS SUCCESSOR-IN-INTEREST TO MOZY, INC.); SCALEIO LLC
Reel/Frame 061324/0001 →
RELEASE OF SECURITY INTEREST Recorded Nov 3, 2021
From: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH
To: ASAP SOFTWARE EXPRESS, INC.; AVENTAIL LLC; CREDANT TECHNOLOGIES, INC.; DELL USA L.P.; DELL INTERNATIONAL, L.L.C.; DELL MARKETING L.P.; DELL PRODUCTS L.P.; DELL SOFTWARE INC.; DELL SYSTEMS CORPORATION; EMC CORPORATION; EMC IP HOLDING COMPANY LLC; FORCE10 NETWORKS, INC.; MAGINATICS LLC; MOZY, INC.; SCALEIO LLC; WYSE TECHNOLOGY L.L.C.
Reel/Frame 058216/0001 →
SECURITY AGREEMENT Recorded Apr 22, 2020
From: CREDANT TECHNOLOGIES INC.; DELL INTERNATIONAL L.L.C.; DELL MARKETING L.P.; DELL PRODUCTS L.P.; DELL USA L.P.; EMC CORPORATION; FORCE10 NETWORKS, INC.; WYSE TECHNOLOGY L.L.C.; EMC IP HOLDING COMPANY LLC
To: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A.
Reel/Frame 053546/0001 →
SECURITY AGREEMENT Recorded Mar 21, 2019
From: CREDANT TECHNOLOGIES, INC.; DELL INTERNATIONAL L.L.C.; DELL MARKETING L.P.; DELL PRODUCTS L.P.; DELL USA L.P.; EMC CORPORATION; FORCE10 NETWORKS, INC.; WYSE TECHNOLOGY L.L.C.; EMC IP HOLDING COMPANY LLC
To: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A.
Reel/Frame 049452/0223 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Sep 29, 2016
From: EMC CORPORATION
To: EMC IP HOLDING COMPANY LLC
Reel/Frame 040203/0001 →
SECURITY AGREEMENT Recorded Sep 21, 2016
From: ASAP SOFTWARE EXPRESS, INC.; AVENTAIL LLC; CREDANT TECHNOLOGIES, INC.; DELL USA L.P.; DELL INTERNATIONAL L.L.C.; DELL MARKETING L.P.; DELL PRODUCTS L.P.; DELL SOFTWARE INC.; DELL SYSTEMS CORPORATION; EMC CORPORATION; EMC IP HOLDING COMPANY LLC; FORCE10 NETWORKS, INC.; MAGINATICS LLC; MOZY, INC.; SCALEIO LLC; SPANNING CLOUD APPS LLC; WYSE TECHNOLOGY L.L.C.
To: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A., AS NOTES COLLATERAL AGENT
Reel/Frame 040136/0001 →
SECURITY AGREEMENT Recorded Sep 21, 2016
From: ASAP SOFTWARE EXPRESS, INC.; AVENTAIL LLC; CREDANT TECHNOLOGIES, INC.; DELL USA L.P.; DELL INTERNATIONAL L.L.C.; DELL MARKETING L.P.; DELL PRODUCTS L.P.; DELL SOFTWARE INC.; DELL SYSTEMS CORPORATION; EMC CORPORATION; EMC IP HOLDING COMPANY LLC; FORCE10 NETWORKS, INC.; MAGINATICS LLC; MOZY, INC.; SCALEIO LLC; SPANNING CLOUD APPS LLC; WYSE TECHNOLOGY L.L.C.
To: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT
Reel/Frame 040134/0001 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Feb 23, 2010
From: RSA SECURITY HOLDING, INC.
To: EMC CORPORATION
Reel/Frame 023975/0151 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Feb 23, 2010
From: RSA SECURITY LLC
To: RSA SECURITY HOLDING, INC.
Reel/Frame 023975/0453 →
MERGER Recorded Jan 27, 2010
From: RSA SECURITY INC
To: RSA SECURITY LLC
Reel/Frame 023852/0644 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jan 21, 2010
From: RSA SECURITY LLC
To: RSA SECURITY HOLDING, INC.
Reel/Frame 023824/0729 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jan 21, 2010
From: RSA SECURITY HOLDING, INC.
To: EMC CORPORATION
Reel/Frame 023825/0109 →