Abstract: In accordance with embodiments, there are provided mechanisms and methods for providing a network availability alert to a user in an on-demand service. These mechanisms and methods for providing a network availability alert to a user in an on-demand service may enable embodiments to provide a user with the knowledge that the connectivity problem is not the fault of the on-demand service. In this way the user may be provided with information that best allows the user to obtain connectivity.

Abstract: Disclosed are systems, apparatus, methods and computer-readable media for updating information stored in a database system over a network. In some implementations, first contact data is retrieved from a first virtual portion of a database system, where the first contact data provides first contact information associated with at least one entity. In some instances, the first contact data is compared with second contact data, where the second contact data provides second contact information associated with the at least one entity. In some instances, at least some of the second contact information is retrieved from a social networking system. In various implementations, at least one difference between the first contact data and the second contact data is identified, where the at least one difference is capable of being presented in a user interface displayed at a computer system. In some instances, a selection identifying contact data to store is received.

Abstract: Disclosed are systems, apparatus, and methods for updating and visualizing information stored in a database system. In various implementations, a request to search contact data is received, where the contact data provides contact information associated with at least one entity. Search parameters may be retrieved responsive to the search request, where the search parameters define the search and include a geographical location associated with a source of the request. In various implementations, a first contact is identified based on the retrieved search parameters, where the first contact is identified based at least in part on a geographical distance between the first contact and the source of the request. In some implementations, a geographical representation of the first contact is generated, where the geographical representation indicates a geographical location of the first contact, and where the geographical representation is capable of being displayed at a user interface of a computer system.

Abstract: A computer-implemented server system includes or supports applications that use security tokens. The server system includes a security token module to create token types for use with the applications, to generate security tokens corresponding to created token types, and to enforce token use policies for generated security tokens. The server system also includes a database to store security tokens for the token module. The token module accommodates creation of different token types having different token formats and different token use policies, based on obtained values of a plurality of token configuration variables. The token module generates security tokens in accordance with the different token formats, and enforces the different token use policies when processing incoming security tokens.

Abstract: Methods and systems are provided for querying a multi-tenant database. One exemplary method of generating an improved query plan to a database from an input query submitted to an on demand database service over a network involves determining guidance information appropriate to the input query based at least in part on an identity of a source of the input query, determining a database hint for processing the input query based at least in part on the guidance information, and providing the database hint to the database to form the improved query plan, thereby enabling the database to return an improved result responsive to the input query based at least in part upon the database hint.

Abstract: A method executable by a server system confirms the identity of a user of a client device. The method receives an activation request from the client device and maintains information corresponding to a destination resource requested by the client device. In response to receiving the activation request, the server system sends a code to a registered device of the user. After sending the code, the server system receives a verification request from the client device. The verification request includes a user-entered representation of the code. In response to receiving the verification request the client device is activated as a new registered device for the user, and the server system seamlessly provides the destination resource to the client device using the maintained information.

Abstract: Methods and systems are provided for identifying data transactions satisfying a streaming query and providing data corresponding to those data transactions to subscribed client devices. One exemplary method involves receiving a subscription request for a streaming query from a client device, monitoring a database for indication of a data transaction corresponding to the streaming query, and in response to identifying the indication of the data transaction corresponding to the streaming query, obtaining data for an entry associated with the data transaction from the database and providing at least a portion of the obtained data to the client device.

Abstract: In accordance with embodiments disclosed herein, there are provided methods, systems, and apparatuses including, for supporting transactional message handling in an on-demand service environment including, for example: enqueuing a message specifying a transaction to be processed via a host organization; inserting a row into a database of the host organization associating the message with a status of pending, wherein the row is autocommitted to the database upon insertion; updating the status for the row to ready if a commit operation for the transaction is initiated; requesting a lock on the row; and performing final processing for the transaction based on the status for the message and based further on whether the lock is obtained for the row. Final processing may include, for example, a transaction roll back, a transaction commit, a transaction requeue, a termination of transaction processing, or an orphaned transaction clean up.

Abstract: Source values are mapped to new user-defined categories. The new user-defined categories are stored in a new user-defined field. In an embodiment, a user-selection of an existing field is received. Based on a data type of the existing field, a specific mapping interface is displayed. The interface guides the user through specification of the new field and categories, and identification of the source values to map to the new categories.

Abstract: Methods and systems are provided for querying a database. One exemplary method for obtaining data from an on-demand database supporting one or more tenants involves obtaining model database statistics based on expected utilization information for a tenant and providing the model database statistics to the on-demand database. The on-demand database utilizes the model database statistics to generate a query plan and executes the query plan to obtain data from the model database statistics.

Abstract: Methods and systems are provided for identifying data transactions satisfying a streaming query and providing data corresponding to those data transactions to subscribed client devices. One exemplary method involves a server initiating a data transaction for a database entry in a database in response to input data received from a client device, determining whether the data transaction satisfies a streaming query, and indicating an association between the database entry and the streaming query when the data transaction satisfies the streaming query.

Abstract: A scheduler integrates worker time and location into customer appointment schedules by obtaining the status of workers' meetings with customers and forwarding updated schedule messages to waiting customers if the worker is late for an appointment due to traffic or unexpected delays at the previous customer meeting. The waiting customers receiving the updated schedules can respond by accepting the updated schedule, adjusting the meeting time or cancelling the appointment. The scheduler eliminates the need for customers to have to wait for long periods of time for service workers to arrive and allows them to adjust the meeting appointment based upon their schedules.

Abstract: Mechanisms and methods for sharing database content between tenants in a multi-tenant database system are provided. The ability to temporarily store metadata related to the shared data for subsequent use optimizes the data transfer process for multiple data transfers. In an embodiment, the metadata is stored for a pre-determined period of time and fetched again after the period elapses if required. The metadata may be erased from temporary storage if an administrator updates the shared data.

Abstract: Mechanisms and methods for enabling customers to manage multi-lingual knowledge bases, so that end users can access articles based on a language the end user chooses, while also providing publishers with tools to manage articles in different languages and to translate them, either using an external vendor or leveraging in house translators, and providing administrators (knowledge managers) with the ability to setup or choose which languages are available in the knowledge base, as well as default language assignments for translations.

Abstract: This disclosure provides implementations of methods, apparatus, systems, and computer program products for creating and managing granular relationships on an online social network. In some implementations, a request to generate an information feed is associated with configuration information, which identifies a source of information updates. Each of the information updates can be of a certain type. The configuration information identifies one or more of these types. An information update can be selected from the identified information source. The selected information update has one or more of the types associated therewith. The requested information feed is generated to include the selected information update and displayed on a display device.

Abstract: In an embodiment, first and second lists of virtual machine datastore paths are obtained. The first list includes datastore paths on a datastore. The second list includes datastore paths that are associated with existing virtual machines. The first and second lists are compared and non-matching datastore paths are deleted from the datastore, thereby freeing up disk space on the datastore.

Abstract: A system and method for enabling the interchange of enterprise data through an open platform is disclosed. This open platform can be based on a standardized interface that enables parties to easily connect to and use the network. Services operating as senders, recipients, and in-transit parties can therefore leverage a framework that overlays a public network.

Abstract: More efficient querying of a multi-tenant database using dynamic tuning of database indices. A layer of meta-data associates data items with tenants, e.g., via tags, and the meta-data is used to optimize searches by channeling processing resources during a query to only those pieces of data bearing the relevant tenant's unique tag.

Abstract: Systems and methods for operating a database using distributed memory and set operations, and for evaluating graphs stored in the database. Any system may be represented as a graph structure having nodes and edges. The graph structure is stored in a distributed memory system using a key/value schema wherein each node is stored as a key and a set of neighbor nodes is stored as the corresponding value. A short path from one node to another may be determined by traversing the graph in stages, moving outward from each node in stages until common midpoint nodes are found indicating connections between the nodes. When the midpoint nodes are found, the paths connecting the nodes may be reconstructed.

Abstract: In embodiments, methods and systems for customizing a user interface to an on-demand database service. These mechanisms and methods for customizing a user interface to an on-demand database service can enable embodiments to provide a user interface designed by a tenant of the on-demand database service. The customization can include including third party content into the customized user interface, overriding a standard object, and providing content inline at a specified location.