Patent Issued for Systems And Methods For Database Record Clustering (USPTO 10,929,437)

2021 MAR 04 (NewsRx) -- By a News Reporter-Staff News Editor at Insurance Daily News -- From Alexandria, Virginia, NewsRx journalists report that a patent by the inventors Ross, Gareth (Amherst, MA); Ben-Zvi, Yaron (Hastings on Hudson, NY), filed on February 21, 2018, was published online on March 8, 2021.

The patent’s assignee for patent number 10,929,437 is Massachusetts Mutual Life Insurance Company (Springfield, Massachusetts, United States).

News editors obtained the following quote from the background information supplied by the inventors: “A database stores a set of records. However, managing such records may be difficult due to record number, size, content, or relationships. For example, there may be a need to group records into different sets and use such sets to perform various set-specific computing operations. Thus, a need exists for a technology to cluster database records into different sets in order to execute set-specific computing operations.”

As a supplement to the background information on this patent, NewsRx correspondents also obtained the inventors’ summary information for this patent: “In one embodiment, a method of data clustering is provided. The method comprises: 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 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, generating, by the server, a fourth unique identifier and a fifth unique identifier in the first database; copying, by the server, the record of the third records from the second database to the first 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.

“Numerous other aspects, features and benefits of the present disclosure may be made apparent from the following detailed description taken together with the drawing figures.”

The claims supplied by the inventors are:

“What is claimed is:

“1. A method comprising: accessing, by a server, a first database storing a first file, a plurality of first records, and a plurality of second records responsive to receipt of a selection of a category datum from a client, wherein the first file comprises a statistical model associated with the category datum, wherein each of the first records comprises a first unique identifier and a first set of contact information for a first user, wherein each of the second records comprises a second unique identifier and a second file comprising a plurality of 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; accessing, by the server, a second database storing a plurality of third records responsive to not locating the third unique identifier, wherein each of the third records comprises a second set of contact information for a second user; copying, by the server, a portion of a record of the third records; comparing, by the server, the portion against the statistical model responsive to reading the first file; generating, by the server, a fourth unique identifier and a fifth unique identifier in the first database responsive to the record of the third records being associated with the category datum; copying, by the server, the record of the third records from the second database to the first 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; and serving, by the server, the second set of contact information to the client responsive to copying, by the server, the second set of contact information such that the client is able to generate a message to the second user based on the second set of contact information.

“2. The method of claim 1, wherein the message is a second message, and further comprising: accessing, by the server, the record of the first records responsive to locating the third unique identifier, copying, by the server, the first set of contact information, and serving, by the server, the first set of contact information to the client such that the client is able to generate a first message to the first user based on the first set of contact information.

“3. The method of claim 2, further comprising: configuring, by the server, the first database such that the fifth unique identifier is locatable when searching for the third unique identifier.

“4. The method of claim 2, 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, 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.

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

“6. The method of claim 1, 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.

“9. The method of claim 1, wherein the first database is an in-memory database.

“10. The method of claim 1, wherein the second database is an in-memory database.

“11. A system comprising: a server configured to: access a first database storing a first file, a plurality of first records, and a plurality of second records responsive to receipt of a selection of a category datum from a client, wherein the first file comprises a statistical model associated with the category datum, wherein each of the first records comprises a first unique identifier and a first set of contact information for a first user, wherein each of the second records comprises a second unique identifier and a second file comprising a plurality of paragraphs; search 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; access a second database storing a plurality of third records responsive to not locating the third unique identifier, wherein each of the third records comprises a second set of contact information for a second user; copy a portion of a record of the third records; compare the portion against the statistical model responsive to reading the first file; generate a fourth unique identifier and a fifth unique identifier in the first database responsive to the record of the third records being associated with the category datum; copy the record of the third records from the second database to the first database; assign the record of the third records to the fourth unique identifier in the first database; assign the fourth unique identifier and the second unique identifier to the fifth unique identifier; and serve the second set of contact information to the client responsive to copying, by the server, the second set of contact information such that the client is able to generate a message to the second user based on the second set of contact information.

“12. The system of claim 11, wherein the message is a second message, and the server is configured to: access the record of the first records responsive to locating the third unique identifier, copy the first set of contact information, and serve the first set of contact information to the client such that the client is able to generate a first message to the first user based on the first set of contact information.

“13. The system of claim 12, wherein the server is programmed to configure the first database such that the fifth unique identifier is locatable when searching for the third unique identifier.

“14. The system of claim 12, 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 the server is configured to: for each of the first records associated with the third unique identifier and the third records associated with the fourth unique identifier: determine if there is a match between the first music genre datum and the second music genre datum; in response to the match: generate 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; assign 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; copy the first second of contact information and the second set of contact information corresponding to the match; serve 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.

“15. The system of claim 14, wherein the statistical model comprises the music source identifiers.

“16. The system of claim 11, 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.

“17. The system of claim 11, 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.

“18. The system of claim 11, 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.

“19. The system of claim 11, wherein the first database is an in-memory database.

“20. The system of claim 11, wherein the second database is an in-memory database.”

For additional information on this patent, see: Ross, Gareth; Ben-Zvi, Yaron. Systems And Methods For Database Record Clustering. U.S. Patent Number 10,929,437, filed February 21, 2018, and published online on March 8, 2021. Patent URL: http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO1&Sect2=HITOFF&d=PALL&p=1&u=%2Fnetahtml%2FPTO%2Fsrchnum.htm&r=1&f=G&l=50&s1=10,929,437.PN.&OS=PN/10,929,437RS=PN/10,929,437

(Our reports deliver fact-based news of research and discoveries from around the world.)