Abstract: In accordance with embodiments, there are provided mechanisms and methods for transporting a task to a handler, utilizing a queue. These mechanisms and methods for transporting a task to a handler, utilizing a queue can enable improved task management, increased efficiency, dynamic task processing, etc.

Abstract: Methods and systems for optimizing queries in a multi-tenant store are described. In one embodiment, such a method includes retrieving data from a multi-tenant database system having a relational data store and a non-relational data store, receiving a request specifying data to be retrieved, retrieving one or more locations of the data to be retrieved, generating a database query based on the request, in which the database query specifies a plurality of data elements to be retrieved, the plurality of data elements including one or more data elements residing within the non-relational data store and one or more other data elements residing within the relational data store, generating an optimized database query having an optimized query syntax that is distinct from a query syntax of the database query, and executing the optimized database query against the multi-tenant database system to retrieve the data.

Abstract: Methods and systems for performing cross store joins in a multi-tenant store are described. In one embodiment, such a method includes retrieving data from a multi-tenant database system having a relational data store and a non-relational data store, receiving a request specifying data to be retrieved from the multi-tenant database system, retrieving, based on the request, one or more locations of the data to be retrieved, generating a database query based on the request, in which the database query specifies a plurality of data elements to be retrieved, the plurality of data elements including one or more data elements residing within the non-relational data store and one or more other data elements residing within the relational data store, and executing the database query against the multi-tenant database system to retrieve the data.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for storing documents that are being tracked in an on-demand service. These mechanisms and methods for storing documents in an on-demand service can enable embodiments to provide the sharing of documents and the storing of the documents in association with a tag. The ability of embodiments to provide the sharing of documents and the storing can enable an efficient searching for a shared document. In an embodiment, the shared document is categorized upon being stored.

Abstract: There are provided mechanisms and methods for maintaining data stored in a data structure. These mechanisms and methods for maintaining data stored in a data structure can provide maintenance operations with improved efficiency, functionality, etc.

Abstract: Methods and systems are presented for recommending similar questions to one that a user has entered into a search engine. Previously-entered questions are subject to a clustering algorithm and placed into a hierarchy of clusters, with clusters set within clusters. For each cluster within the hierarchy, a representative vector, based on feature vectors of the items within the cluster, is calculated. A feature vector for the user's question is calculated and used, along with the representative vectors at each level in the hierarchy, to traverse and navigate the cluster hierarchy. When a leaf cluster is found, the items in the leaf cluster, such as the previously-entered questions are returned to the user. A subset of items in the leaf cluster, or items from other leaf clusters within a branch cluster, can be selected based on the number of items desired to be returned.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for associating a permission set with one or more users. These mechanisms and methods for associating a permission set with one or more users can enable improved access management, increased efficiency, enhanced security, reduced risk, greater governance, least privilege access, greater auditability, etc.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for determining a risk score for an entity. These mechanisms and methods for determining a risk score for an entity can enable more effective monitoring of a system, can create more relevant data associated with the entity, etc.

Abstract: Methods and systems for secure client-side communication between multiple domains is provided. Such methods and systems can provide for decreased communication latency particularly effective for dynamic multi-domain and/or multi-tenant environments while allowing for granular security or specific security of messages and operations with regard to users, user sessions, groups, organizations, permissions sets, applications, or any other logical delineation. Such methods and systems may involve a variety of security components, for example, at least one set of instructions including a plurality of defined instruction to be utilized by users of the set of instructions to communicate, and cryptographic construct data in order to verify the data integrity and the authenticity of messages sent and received using the secure client-side communication between multiple domains.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for performing one or more actions based on a comparison of data associated with a client to one or more criteria. These mechanisms and methods for performing one or more actions based on a comparison of data associated with a client to one or more criteria can enable improved data collection and analysis, enhanced client knowledge of a system, etc.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for transmitting a group of data elements. These mechanisms and methods for grouping a plurality of data elements can enable more efficient data transmission, improved synchronization and data management, etc.

Abstract: Methods and systems for automatically determining, from a body of emails, blogs, and other documents, authors of the documents who are authorities on certain subjects, and what those subjects are. An intersection of the semantic footprints of documents by an author are deemed to be the derived skills footprint of the author. The derived skills footprints of many authors are compared with a user's query to determine who is the best person that could respond to the user.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for deriving commonalities among data entries. These mechanisms and methods for deriving commonalities among data entries can identify characteristics that are known to be common to at least some data entries in addition to unknown characteristics that are common to data entries. The ability to identify common known and unknown characteristics among data entries may allow data entries to be grouped according to the identified common known and unknown characteristics.

Abstract: Methods and systems for bulk uploading of data in an on-demand service environment are described. In one embodiment, such a method includes retrieving a bulk transaction request from a transaction queue within a host organization, where the bulk transaction request specifies a plurality of database transactions to be processed against a multi-tenant database system of the host organization. Such a method further includes determining a current computational load of the multi-tenant database system, processing a subset of the plurality of database transactions specified by the bulk transaction request against the multi-tenant database system when the current computational load is below a threshold, and updating a bulk transaction results log based on the subset of the plurality of database transactions processed. Remaining database transactions specified by the bulk transaction request may then be re-queued for later processing.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for performing one or more actions based on determined access permissions for a plurality of users. These mechanisms and methods for performing one or more actions based on determined access permissions for a plurality of users can enable improved data collection and analysis, enhanced client knowledge of system access, etc.

Abstract: A method for managing an asset in a database system is provided. The method embodiment includes receiving by a node hosting an asset management service module asset information corresponding to an asset, and generating automatically by the asset management service module an asset identifier based on the received asset information. In an embodiment, the asset identifier uniquely identifies the asset and includes a manufacturer's serial number of the asset and at least one of a make and a model of the asset. The asset information is associated with the asset identifier, and the asset information and the asset identifier are stored in a database system.

Abstract: Methods and systems for query optimization for a multi-tenant database system are provided. Some embodiments comprise receiving, at a network interface of a server computer in a multi-tenant database system, an original query transmitted to the multi-tenant database system by a user associated with a tenant, wherein the original query is associated with data accessible by the tenant, and wherein the multi-tenant database system includes a first two-column custom index. Metadata associated with the data accessible by the tenant is retrieved, using a processor of the server computer, wherein at least a portion of the data accessible by the tenant is stored in a common table within the multi-tenant database system. A tenant-selective query syntax is determined, using the processor, wherein determining comprises analyzing at least one of metadata generated from information about the tenant or metadata generated from the data accessible by the tenant.

Abstract: Embodiments enable reduction of database downtime in a live production environment of an on-demand database service during repair and/or maintenance tasks. A source database and a target database are provided. Data is copied from the source database to the target database to create a mirrored set of data. Access is limited to one or more designated tables in the target database. General traffic is redirected from the source database to the target database, wherein the redirection occurs for a duration of a maintenance period. Data modifications that occur in the target database during the maintenance period are captured and then replicated into the source database. Finally, general traffic is redirected from the target database to the source database.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for synchronizing entities. These mechanisms and methods for synchronizing entities can enable improved data synchronization, improved data management, etc.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for authenticating and authorizing an external entity. These mechanisms and methods for authenticating and authorizing an external entity can enable improved data security, more efficient data transfer, improved data access channels, etc.