System, method and computer program product for applying a public tag to information

• US 9,251,239 B1
• Filed: 05/13/2009
• Issued: 02/02/2016
• Est. Priority Date: 05/15/2008
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Liggett, Emily Alane, Gusev, Andrey D., Kimberlin, Susan Marie, Bergan, Jeffrey M.
• Primary Examiner(s): Perveen, Rehana
• Assistant Examiner(s): Wong, Huen
• Application Number:
  US12/465,478
• Time in Patent Office: 2,456 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24573 using data annotations, e.g. user-defined metadata
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

In accordance with embodiments, there are provided mechanisms and methods for applying a public tag to information. These mechanisms and methods for applying a public tag to information may enable embodiments to allow a user to apply a public tag to the information once. Further, applying a public tag to information may enable users with access to the information an ability to view the public tag applied to the information by the user.

Claims

1. A method, comprising:

receiving, at a database system from a first user of the database system, an indication of a first record stored in a database of the database system;

receiving, at the database system from the first user, a public tag for associating the public tag with the first record, wherein the public tag is an attribute of the first record;

determining whether the public tag is already associated with the first record;

applying the public tag to the first record only in response to a determination that the public tag is not already associated with the first record, such that only a single instance of the public tag is associated, in the database, with the first record, by;

determining that the public tag is not already associated with the first record by determining that the first record does not already have a reference to the public tag, and

referencing, in the database, the public tag with the first record;

receiving, at the database system from a second user of the database system, an indication of a second record stored in the database of the database system;

receiving, at the database system from the second user, a public tag for associating the public tag with the second record, the public tag describing an attribute of the second record;

determining whether the public tag is already associated with the second record;

applying the public tag to the second record only in response to a determination that the public tag is not already associated with the second record, such that only a single instance of the public tag is associated, in the database, with the second record, by;

determining that the public tag is not already associated with the second record by determining that the second record does not already have a reference to the public tag, and

referencing, in the database, the public tag with the second record;

providing, by the database system, a permission to view the public tag to a subset of additional users of the database system;

receiving at least one search term from one of the additional users to search for records stored in the database;

performing, by the database system, a search of public tags stored in the database using the at least one search term, including determining that the at least one search term matches the public tag; and

identifying the first record and the second record to the one of the additional users, in response to determining that the at least one search term matches the public tag.

2. The method of claim 1, wherein determining that the at least one search term matches the public tag is based on a tag name or a normalized public tag.

3. The method of claim 2, wherein the at least one search term is normalized prior to searching for the matching public tag.

7. The method of claim 1, wherein another one of the public tags in the database has a first name different from a second name of the public tag received from the first user, and in response to another user editing the first name of the other public tag to be the same as the second name of the public tag received from the first user, the other public tag is merged into the public tag received from the first user by:

identifying all records in the database having a reference to the other public tag; and

substituting, in each of the identified records, the reference to the other public tag with a reference to the public tag received from the first user.

8. The method of claim 1, wherein a number of records in the database to which the public tag is allowed to be applied is limited by the database system.

9. The method of claim 1, wherein the permission to view the public tag is provided to the subset of additional users based on a permission of the subset of additional users to view the first record and/or the second record.

10. The method of claim 1, further comprising:

receiving, at the database system, an indication of a third record;

utilizing a term extraction library to automatically identify the public tag for the third record;

applying the public tag to the third record only in response to a determination that the public tag is not already associated with the third record, such that only a single instance of the public tag is associated, in the database, with the third record; and

identifying, with the first record and the second record, the third record to the one of the additional users in response to determining that the at least one search term matches the public tag.

11. The method of claim 1, further comprising storing in the database a definition of the public tag, the definition including a tag name, wherein the public tag is searched via the tag name.

4. A non-transitory machine-readable medium storing one or more sequences of instructions which, when executed by one or more processors, cause the one or more processors to carry out the steps of:

receiving, at a database system from a first user of the database system, an indication of a first record stored in a database of the database system;

receiving, at the database system from the first user, a public tag for associating the public tag with the first record, wherein the public tag is an attribute of the first record;

determining whether the public tag is already associated with the first record;

applying the public tag to the first record only in response to a determination that the public tag is not already associated with the first record, such that only a single instance of the public tag is associated, in the database, with the first record, by;

determining that the public tag is not already associated with the first record by determining that the first record does not already have a reference to the public tag, and

referencing, in the database, the public tag with the first record;

receiving, at the database system from a second user of the database system, an indication of a second record stored in the database of the database system;

receiving, at the database system from the second user, a public tag for associating the public tag with the second record, the public tag describing an attribute of the second record;

determining whether the public tag is already associated with the second record;

applying the public tag to the second record only in response to a determination that the public tag is not already associated with the second record, such that only a single instance of the public tag is associated, in the database, with the second record, by;

determining that the public tag is not already associated with the second record by determining that the second record does not already have a reference to the public tag, and

referencing, in the database, the public tag with the second record;

providing, by the database system, a permission to view the public tag to a subset of additional users of the database system;

receiving at least one search term from one of the additional users to search for records stored in the database;

performing, by the database system, a search of public tags stored in the database using the at least one search term, including determining that the at least one search term matches the public tag; and

identifying the first record and the second record to the one of the additional users, in response to determining that the at least one search term matches the public tag.

5. An apparatus, comprising:

a processor; and

one or more stored sequences of instructions which, when executed by the processor, cause the processor to carry out the steps of;

receiving, at a database system from a first user of the database system, an indication of a first record stored in a database of the database system;

receiving, at the database system from the first user, a public tag for associating the public tag with the first record, wherein the public tag is an attribute of the first record;

determining whether the public tag is already associated with the first record;

applying the public tag to the first record only in response to a determination that the public tag is not already associated with the first record, such that only a single instance of the public tag is associated, in the database, with the first record, by;

determining that the public tag is not already associated with the first record by determining that the first record does not already have a reference to the public tag, and

referencing, in the database, the public tag with the first record;

receiving, at the database system from a second user of the database system, an indication of a second record stored in the database of the database system;

receiving, at the database system from the second user, a public tag for associating the public tag with the second record, the public tag describing an attribute of the second record;

determining whether the public tag is already associated with the second record;

applying the public tag to the second record only in response to a determination that the public tag is not already associated with the second record, such that only a single instance of the public tag is associated, in the database, with the second record, by;

determining that the public tag is not already associated with the second record by determining that the second record does not already have a reference to the public tag, and

referencing, in the database, the public tag with the second record;

providing, by the database system, a permission to view the public tag to a subset of additional users of the database system;

receiving at least one search term from one of the additional users to search for records stored in the database;

performing, by the database system, a search of public tags stored in the database using the at least one search term, including determining that the at least one search term matches the public tag; and

identifying the first record and the second record to the one of the additional users, in response to determining that the at least one search term matches the public tag.

6. A method for transmitting code for use in a multi-tenant database system on a transmission medium, the method comprising transmitting code for:

receiving, at a database system from a first user of the database system, an indication of a first record stored in a database of the database system;

receiving, at the database system from the first user, a public tag for associating the public tag with the first record, wherein the public tag is an attribute of the first record;

determining whether the public tag is already associated with the first record;

applying the public tag to the first record only in response to a determination that the public tag is not already associated with the first record, such that only a single instance of the public tag is associated, in the database, with the first record, by;

determining that the public tag is not already associated with the first record by determining that the first record does not already have a reference to the public tag, and

referencing, in the database, the public tag with the first record;

receiving, at the database system from a second user of the database system, an indication of a second record stored in the database of the database system;

receiving, at the database system from the second user, a public tag for associating the public tag with the second record, the public tag describing an attribute of the second record;

determining whether the public tag is already associated with the second record;

applying the public tag to the second record only in response to a determination that the public tag is not already associated with the second record, such that only a single instance of the public tag is associated, in the database, with the second record, by;

determining that the public tag is not already associated with the second record by determining that the second record does not already have a reference to the public tag, and

referencing, in the database, the public tag with the second record;

providing, by the database system, a permission to view the public tag to a subset of additional users of the database system;

receiving at least one search term from one of the additional users to search for records stored in the database;

performing, by the database system, a search of public tags stored in the database using the at least one search term, including determining that the at least one search term matches the public tag; and

identifying the first record and the second record to the one of the additional users, in response to determining that the at least one search term matches the public tag.