Abstract: Disclosed are methods, apparatus, systems, and computer-readable storage media for identifying similar labels. In some implementations, one or more servers maintain a plurality of data entries in one or more database tables storing textual data, each data entry of a first portion of the data entries including: a text sequence, a label, and a text-to-label association score, and each data entry of a second portion of the data entries including: a first label, a second label, and a similarity score. The one or more servers analyze the data of the first portion of data entries to generate one or more pairs, each pair including information identifying a first label and a second label. The one or more servers calculate a similarity score for each of the one or more pairs and store the respective similarity scores in the second portion of the data entries.

Abstract: Disclosed are methods, apparatus, systems, and computer-readable storage media for identifying a topic for a text. In some implementations, one or more servers maintain a plurality of data entries in one or more database tables storing text data, each data entry of a first portion of the data entries including: a text sequence, a topic, and a text-to-topic association score indicating a number of times that the text sequence appears in a processed text associated with the topic, each data entry of a second portion of the data entries including a total word score indicating a number of times that a respective text sequence appears in one or more processed texts. The one or more servers may receive an incoming text and identify a topic for the incoming text by processing the text sequences of the incoming text in relation to the data entries in the database tables.

Abstract: Disclosed are systems, apparatus, methods and computer-readable storage media for determining whether to continue relationships in an online social network. For example, a server can maintain data entries in one or more database tables. A given data entry can include: an identification of an entity, an identification of a user having a social networking relationship with the entity, and an affinity score indicating an amount of interaction by the user with the entity. For each entry, a ratio of the affinity score to a measure of an amount of content associated with the entity and published in a feed accessible by the user can be determined. Depending on the implementation, such ratios can be compared with a threshold and/or ranked to identify candidates for discontinuing social networking relationships.