Systems and methods for database record clustering

• US 9,965,543 B1
• Filed: 04/21/2016
• Issued: 05/08/2018
• Est. Priority Date: 04/21/2015
• Status: Active Grant

• Current Assignee: Massachusetts Mutual Life Insurance Company
• Original Assignee: Massachusetts Mutual Life Insurance Company
• Inventors: Ross, Gareth, Ben-Zvi, Yaron
• Primary Examiner(s): Al-Hashemi, Sana A
• Application Number:
  US15/134,656
• Time in Patent Office: 747 Days
• Field of Search: 707607, 707608, 707687, 707790, 707813, 707953
• CPC Class Codes: G06F 16/148 File search processing
• CPC Class Codes: G06F 16/285 Clustering or classification
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques

Abstract

A system and method for clustering client records together is disclosed. The system may include statistical models based on characteristics of a record cluster stored in a database. The statistical models may be compared against characteristics of records in a data source in order to cluster the records into different categories. The cluster of records by category may then be output to a computer system in order to send electronic messages.

Claims

1. A method of data clustering, the method comprising:

serving, by a server, over a network, a graphical user interface in an application running on an operating system of a client, wherein the graphical user interface comprises a first graphical element configured to receive a category datum and a second graphical element configured to trigger a submission of the category datum from the client to the server over the network;

in response to the submission via the second graphical element;

accessing, by the server, a first database storing a first file, a plurality of first records, and a plurality of second records, wherein the first file comprises a statistical model is configured to identify cluster client records by category and associated with the category datum, wherein each of the first records comprises a first unique identifier, a first set of personal information for a first user, and a first set of contact information for the first user, wherein each of the second records comprises a second unique identifier and a second file comprising a plurality of formatted paragraphs;

searching, by the server, the first database for a third unique identifier, wherein the third unique identifier is associated with the category datum, a record of the first records via the first unique identifier, and a record of the second records via the second unique identifier;

in response to locating, by the server, based on the searching, the third unique identifier;

accessing, by the server, the record of the first records;

copying, by the server, the first set of contact information;

serving, by the server, over the network, based on the copying, the first set of contact information to the graphical user interface such that the client is able to generate a first message to the first user based on the first set of contact information;

in response to not locating, by the server, based on the searching, the third unique identifier;

accessing, by the server, a second database storing a plurality of third records, wherein each of the third records comprises a second set of personal information for a second user and a second set of contact information for the second user;

identifying, by the server, a record of the third records;

copying, by the server, at least a portion of the record of the third records;

accessing, by the server, the first file;

comparing, by the server, the portion against the statistical model;

in response to determining, by the server, based on the comparing, that the record of the third records is associated with the category datum, in the first database;

to the first database;

generating, by the server, a fourth unique identifier and a fifth unique identifier copying, by the server, the record of the third records from the second database assigning, by the server, the record of the third records to the fourth unique identifier in the first database;

assigning, by the server, the fourth unique identifier and the second unique identifier to the fifth unique identifier;

copying, by the server, the second set of contact information;

serving, by the server, over the network, based on the copying, the second set of contact information to the graphical user interface such that the client is able to generate a second message to the second user based on the second set of contact information.

2. The method of claim 1, further comprising:

configuring, by the server, the first database such that the fifth unique identifier is locatable when searching for the third unique identifier.

3. The method of claim 1, wherein each of the first records associated with the third unique identifier and the third records associated with the fourth unique identifier in the first database comprises a first music genre datum, wherein the first database stores a list of music source identifiers, wherein each of the music source identifiers comprises a second music genre datum and a music source address datum, and further comprising:

for each of the first records associated with the third unique identifier and the third records associated with the fourth unique identifier;

determining, by the server, if there is a match between the first music genre datum and the second music genre datum;

in response to the match;

generating, by the server, a sixth unique identifier in the first database, wherein the sixth unique identifier is associated with the first music genre datum and the second music genre datum;

assigning, by the server, the first records associated with the third unique identifier and the third records associated with the fourth unique identifier corresponding to the match to the sixth identifier;

copying, by the server, the first second of contact information and the second set of contact information corresponding to the match;

serving, by the server, over the network, based on the copying, the first second of contact information and the second set of contact information corresponding to the match to the graphical user interface, wherein at least one of the first message or the second message is addressed based on the music source address datum based on the match.

4. The method of claim 3, wherein the statistical model comprises the music source identifiers.

5. The method of claim 1, wherein the network is a wide area network, wherein the server is a first server, wherein the first database is hosted on a second server, wherein the second database is hosted on a third server.

6. The method of claim 1, wherein the network is a local area network, wherein the server is a first server, wherein the first database is hosted on a second server, wherein the second database is hosted on a third server.

7. The method of claim 1, wherein the second database stored a plurality of social network service profiles, wherein each of the third records comprises each of the social network service profiles.

8. The method of claim 1, wherein the server is a first server, wherein the second database feeds information to a customer relationship management application running on a second server, wherein the second server hosts the second database.