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: 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 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: 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: 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 portal user data access in a multi-tenant on-demand database system. These mechanisms and methods for portal user data access in a multi-tenant on-demand database system can enable embodiments to provide portal-specific user accounts to the multi-tenant on-demand database system which have reduced configuration requirements than users directly accessing the multi-tenant on-demand database system. The ability of embodiments to provide portal-specific user accounts can reduce processing requirements of the 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: In accordance with embodiments, there are provided mechanisms and methods for debugging an assertion. These mechanisms and methods for debugging an assertion can enable improved interpretation and analysis of data validation results, more efficient development associated with data validation, etc.

Abstract: A method of searching in a database of feed items enables efficient searching through a large corpus of data. Each feed item is associated with at least one object in the database. An index of feed items is generated. For each feed item in the database, the index includes a body of the feed item and at least one foreign key that identifies an object associated with the feed item. A search request with one or more search terms is received from a first user. Using the index of feed items, a pre-filtered set of feed items is generated for the first user. The search is executed, using the index of feed items and the pre-filtered set of feed items. Search results are limited to feed items in the pre-filtered set of feed items.

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: 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.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for rule-based performance of actions on related objects. These mechanisms and methods for rule-based performance of actions on related objects can provide a generalized technique for configuring related object actions that are responsive to object updates. The ability to provide this generalized technique can enable actions to be automatically performed on objects in response to updates to related objects, in a rule-based manner.

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: 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 extending a master-detail relationship between objects. These mechanisms and methods for extending a master-detail relationship between objects can enable enhanced data usage, increased efficiency, improved user interaction, etc.

Abstract: Computer systems, methods and software for responding to remote clients with content selected based on when the request is made. The method may include selecting one or more interface components based on the time of day and/or date of the request, and returning a response including the selected interface components. The method may include adjusting the time for a time zone for the remote client and/or user. Interface components may be fully embedded in the response, or may be references to external components. Interface components may include data relating to a user task associated with the date and/or time of day, formatting information for displaying the task data to the user of the remote client, instructions for user interaction with the task data, etc.

Abstract: A system and method of identifying users of a multi-tenant database and application service is provided. The system and method is configured to generate a list of contacts from a contact database of a multi-tenant database and application service. Each contact in the list of contacts is sent a message that includes a link to web site that includes a query. Specifically, each contact visiting the web site is queried to determine if the contact is a user of a multi-tenant database and application service. Additionally, contacts are queried to determine if they are an administrator user, and if not, who is an associated administrator user. The contact database is updated to indicate contacts that are users of the multi-tenant database and application service when approved of by the associated administrator.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for creating an object within a system, utilizing a template. These mechanisms and methods for creating an object within a system, utilizing a template can enable increased efficiency, resource and time savings, more intuitive object creation, etc.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for automatic code generation for database object deletion. These mechanisms and methods for automatic code generation for database object deletion can generate code for deleting database objects in an automated manner. The ability to generate code for deleting database objects in an automated manner can enable the efficient and accurate deletion of database objects, including database objects with relationships to other database objects.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for associating a record with an account from an on-demand database system. These mechanisms and methods for associating a record with an account from an on-demand database system can enable improved synchronization between an on-demand database system and a software element separate from the on-demand database system, etc.