Salesforce Com, Inc.

Salesforce, Inc.

Nathanael Black

Simon Y Wong

Walter Macklem

Arup Dutta

Jean-Baptiste Pringuey

Dan Soble

A system, method and apparatus for providing for searching of relational data via a mobile communications device are provided. Information identifying searchable tables containing fields is received using a metadata application program interface (API). The metadata API provides information about a schema of the fields and a relationship of at least one of the fields to its corresponding object. Information for generating a view of relational data is provided to the mobile communications device. The view is based on at least one of the fields of at least one of the searchable tables, and the relationship between the at least one of the fields and its corresponding object. A set of user inputs is received based on the relationship presented in the view. A query definition corresponding to the set of user inputs for searching the relational data in accordance with the set of user inputs is created and stored.

Advanced searching of relational data via a mobile device

Apparatuses, systems, and methods for generating and utilizing custom indexes for a plurality of geo-locations are described. A plurality of indexes are generated, each corresponding to one of a plurality of geo-locations, based on spatial area subdivisions of a space including the plurality of geo-locations. A points of interest (POIs) query is received, wherein results of the query are to be limited by a distance value. One or more geo-locations are identified as POIs within the distance value from a first geo-location of the plurality of geo-locations based on the corresponding indexes of the one or more identified geo-locations.

Geo-location custom indexes

An exemplary embodiment of a multi-tenant database system is provided. The system includes a multi-tenant database, an entity definition table, and a data processing engine. The database has database objects for multiple tenants, including an existing object for a designated tenant. Each entry in the existing object has a respective entity identifier. The definition table has metadata entries for the database objects, including a metadata entry for the existing object. This metadata entry has a tenant identifier for the designated tenant, an entity name for the existing object, and an old key prefix for the existing object. Each entity identifier of the existing object begins with the old key prefix. The engine performs a data truncation operation on the existing object by updating the metadata entry to replace the old key prefix with a new key prefix. This results in an updated object that is identified by the new key prefix and the tenant identifier.

Truncating data associated with objects in a multi-tenant database

An embodiment of a multi-tenant database system includes a multi-tenant database, an entity definition table, and a data processing engine. The database has objects for multiple tenants, including an existing object for a designated tenant. Each entry in the existing object has a respective entity identifier. The definition table has entries for the database objects, including a metadata entry for the existing object. This metadata entry has a tenant identifier for the designated tenant, an entity name for the existing object, and an old key prefix for the existing object. Each entity identifier of the existing object begins with the old key prefix. The engine performs a data truncation operation on the existing object by updating the metadata entry to replace the old key prefix with a new key prefix. This results in an updated object that is identified by the new key prefix and the tenant identifier.

Growing community of inventors

San Francisco, CA, United States of America

Nathanael Black