Patent application number | Description | Published |
20080201701 | METHODS AND SYSTEMS FOR UPGRADING AND INSTALLING APPLICATION PACKAGES TO AN APPLICATION PLATFORM - Systems and methods for installing and upgrading application packages to an application platform. The systems and methods are particularly useful in an on-demand database service. Application packages may be uploaded to a directory by developing users (developers) for installation by subscribing users (subscribers). Alternatively, a developer may send identification information to a subscribing user to allow that user to access and install that application package created by the developer. Application packages may also be upgraded. If a developer changes the original source package, a subscriber can choose to pull into their organization the change(s) made by the publisher while preserving any data rows the subscriber had created since first importing the package. One or more flags may be set in the package definition to determine whether and to what extent customizations to a package may be made and upgraded by the subscriber and/or developer. A “manageable” field is provided to identify whether customizations to a particular object are subject to upgrade; if the package or an object in the package is marked as managed, a user is allowed to customize the package or the object, and these customizations will not be altered upon upgrading of the package. A “control” field is provided to identify whether an object may be modified by the developer and/or the subscriber. An “immutable” field is provided to identify whether an object can or cannot be altered by anyone. | 08-21-2008 |
20080270354 | METHOD AND SYSTEM FOR ALLOWING ACCESS TO DEVELOPED APPLICATIONS VIA A MULTI-TENANT ON-DEMAND DATABASE SERVICE - In accordance with embodiments, there are provided mechanisms and methods for allowing access to developed applications via a multi-tenant on-demand database service, in a controlled environment. These mechanisms and methods for providing such access can enable embodiments to provide additional control over the development process as well as the access of such developed applications. The ability of embodiments to provide such additional control may lead to an improved application development framework, etc. | 10-30-2008 |
20080270987 | METHOD AND SYSTEM FOR ALLOWING ACCESS TO DEVELOPED APPLICATIONS VIA A MULTI-TENANT ON-DEMAND DATABASE SERVICE - In accordance with embodiments, there are provided mechanisms and methods for allowing access to developed applications via a multi-tenant on-demand database service, in a controlled environment. These mechanisms and methods for providing such access can enable embodiments to provide additional control over the development process as well as the access of such developed applications. The ability of embodiments to provide such additional control may lead to an improved application development framework, etc. | 10-30-2008 |
20090049065 | ON-DEMAND DATABASE SERVICE SYSTEM, METHOD, AND COMPUTER PROGRAM PRODUCT FOR VALIDATING A DEVELOPED APPLICATION - In accordance with embodiments, there are provided mechanisms and methods for validating a developed application. These mechanisms and methods for providing such validation can enable embodiments to ensure that new versions of developed applications will operate in the same application environment of a previous version. The ability of embodiments to provide such validation may lead to an improved application migration development/runtime framework, etc. | 02-19-2009 |
20090049101 | ON-DEMAND DATABASE SERVICE SYSTEM AND METHOD FOR DETERMINING WHETHER A DEVELOPED APPLICATION WILL OPERATE PROPERLY WITH AT LEAST ONE OTHER APPLICATION - In accordance with embodiments, there are provided mechanisms and methods for determining whether a developed application associated with an on-demand database service will operate properly with at least one other application. These mechanisms and methods for providing such determination can enable embodiments to ensure that new versions of developed applications will operate in the same application environment of a previous version. The ability of embodiments to make such determination may lead to an improved application migration development/runtime framework, etc. | 02-19-2009 |
20090049102 | ON-DEMAND DATABASE SERVICE SYSTEM, METHOD, AND COMPUTER PROGRAM PRODUCT FOR ENFORCING THE INCLUSION OF TESTS IN A DEVELOPED APPLICATION - In accordance with embodiments, there are provided mechanisms and methods for enforcing the inclusion of tests in a developed application. These mechanisms and methods for providing such enforcement can enable embodiments to ensure that new versions of developed applications will operate in the same application environment of a previous version. The ability of embodiments to enforce the inclusion of tests may lead to an improved application migration development/runtime framework, etc. | 02-19-2009 |
20090049288 | SYSTEM, METHOD, AND COMPUTER PROGRAM PRODUCT FOR RUNTIME INVOCATION OF AN APPROPRIATE VERSION OF PROGRAM INSTRUCTIONS IN AN ON-DEMAND DATABASE - In accordance with embodiments, there are provided mechanisms and methods for runtime invocation of an appropriate version of program instructions in an on-demand database service. These mechanisms and methods for providing such runtime invocation can enable embodiments to ensure that new versions of developed applications will operate in the same application environment of a previous version. The ability of embodiments to provide such runtime invocation may lead to an improved application migration development/runtime framework, etc. | 02-19-2009 |
20090276395 | QUERY OPTIMIZATION IN A MULTI-TENANT DATABASE SYSTEM - 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. | 11-05-2009 |
20090276405 | SYSTEM, METHOD AND COMPUTER PROGRAM PRODUCT FOR GENERATING A SET OF INSTRUCTIONS TO AN ON-DEMAND DATABASE SERVICE - In accordance with embodiments, there are provided mechanisms and methods for generating a set of instructions to an on-demand database service. These mechanisms and methods for generating a set of instructions to an on-demand database service can enable embodiments to generate instructions capable of operating on objects, without having any knowledge of the objects on which the instructions are going to operate, until runtime. The ability of embodiments to provide this instruction generation may allow generic instructions to be generated, independent of the objects on which they will operate. | 11-05-2009 |
20100191719 | QUERY OPTIMIZATION IN A MULTI-TENANT DATABASE SYSTEM - The present invention provides techniques for managing a multi-tenant database system. In one embodiment the method includes providing access to data stored in a multi-tenant data structure that is implemented by storing data for multiple tenants on a pool of computer servers defining the multi-tenant data structure that having a plurality of data columns and one or more index columns. The one or more index columns define a first data field for a first tenant of the multi-tenant data structure and a second data field for a second tenant of the multi-tenant data structure. The first field indicates a first data type and the second field indicates a second data type, wherein the second data type is different than the first data type. Once created, records having data values in the first and second fields are stored to a single column in the data structure. The single column includes data values having different data types for different tenants in the multi-tenant data structure. Operations are monitored so that one or more requests to access the multi-tenant data structure among are distributing the pool of computer servers to maintain load balancing among the servers of the pool. | 07-29-2010 |
20100205165 | SYSTEM, METHOD AND COMPUTER PROGRAM PRODUCT FOR QUERYING DATA RELATIONSHIPS OVER A NETWORK - In accordance with embodiments, there are provided mechanisms and methods for querying data relationships over a network. These mechanisms and methods for querying data relationships over a network can enable embodiments to provide the capability to query for more than a single entity at a time. The ability of embodiments to query for more than a single entity at a time can enable improved network throughput, faster response time and more efficient utilization of resources. | 08-12-2010 |
20100205227 | CUSTOM ENTITIES AND FIELDS IN A MULTI-TENANT DATABASE SYSTEM - Systems and methods for hosting variable schema data such as dynamic tables and columns in a fixed physical database schema. Standard objects, such as tables are provided for use by multiple tenants or organizations in a multi-tenant database system. Each organization may add or define custom fields for inclusion in a standard object. Custom fields for multiple tenants are stored in a single field within the object data structure, and this single field may contain different data types for each tenant. Indexing columns are also provided, wherein a tenant may designate a field for indexing. Data values for designated fields are copied to an index column, and each index column may include multiple data types. Each organization may also define custom objects including custom fields and indexing columns. Custom objects for multiple tenants are stored in a single custom object data structure. The primary key values for the single custom object table are globally unique, but also include an object-specific identifier which may be re-used among different entities. | 08-12-2010 |
20100205595 | METHOD AND SYSTEM FOR ALLOWING ACCESS TO DEVELOPED APPLICATIONS VIA A MULTI-TENANT ON-DEMAND DATABASE SERVICE - In accordance with embodiments, there are provided mechanisms and methods for allowing access to developed applications via a multi-tenant on-demand database service, in a controlled environment. These mechanisms and methods for providing such access can enable embodiments to provide additional control over the development process as well as the access of such developed applications. The ability of embodiments to provide such additional control may lead to an improved application development framework, etc. | 08-12-2010 |
20100211619 | DISTRIBUTIVE STORAGE TECHNIQUES FOR MULTI-TENANT DATABASES - The present invention provides techniques for managing information on a multi-tenant database system. In one embodiment a method comprises storing the information on the database among a plurality of tables. The plurality of tables is arranged in columns and rows. Each of a subset of the plurality of tables has sets of the rows distributed amongst different storage nodes on the database. A first of the sets is located at a first node, and a second of the sets is located a second node. Data storage and retrieval capabilities are provided to the database, including access to the information, in response to requests from one of a plurality of remotely disposed computer systems. Also disclosed is a machine-readable medium carrying one or more sequences of instructions for managing computer applications when executed by one or more processors and cause the one or more processors to carry out steps of the method. A data center for managing information on a multi-tenant database is also disclosed that carries-out the functions of the method. | 08-19-2010 |
20100217758 | METHOD, SYSTEM, AND COMPUTER PROGRAM PRODUCT FOR OPTIMIZING A DATABASE QUERY - 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. | 08-26-2010 |
20100223254 | METHOD, SYSTEM, AND COMPUTER PROGRAM PRODUCT FOR OPTIMIZING A MULTI-TENANT DATABASE SYSTEM - 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. | 09-02-2010 |
20100223255 | OPTIMIZATION ENGINE IN A MULTI-TENANT DATABASE SYSTEM - 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. | 09-02-2010 |
20100235837 | QUERY OPTIMIZATION IN A MULTI-TENANT DATABASE SYSTEM - The present invention provides techniques for managing process space on a multi-tenant database system that features a method that provides to multiple users of two or more organizations, over a network, access to information stored in a database repository shared by the two or more organizations. The database repository implements security protocols to restrict a set of first users to a first sub-portion of the information. The set of first users belongs to one of the two or more organizations. The first sub-portion of the information is different from a second sub-portion accessible by users from another organization. Access of the information by the multiple users is monitored. A first processing space for the set of first users is generated in response to the access of the database repository. The first processing space is distinct from a second processing space for the users from the other organization. | 09-16-2010 |
20100274779 | QUERY OPTIMIZATION IN A MULTI-TENANT DATABASE SYSTEM - The present invention provides techniques for storing information on a multi-tenant database system to control query latency that includes a method that stores the information on the database among a plurality of tables arranged in columns and rows. For each of a subset of the plurality of tables, sets of the rows are distributed amongst different storage nodes on the database, with the set of rows stored at a common node having a common index value. Data storage and retrieval capabilities to the database are provided to allow access to the information, in response to requests from one of a plurality of remotely disposed computer systems. The retrieval capability includes a query condition that includes a query index value, with the query condition and the query index value being established to control retrieval latency. Also disclosed is a machine-readable medium carrying one or more sequences of instructions for storing information on a multi-tenant database system to control query latency when executed by one or more processors and cause the one or more processors to carry out steps of the method. A data center for storing information on a multi-tenant database system to control query latency is also disclosed that carries-out the functions of the method. | 10-28-2010 |
20100281014 | METHOD, SYSTEM, AND COMPUTER PROGRAM PRODUCT FOR QUERYING IN A MULTI-TENANT DATABASE - 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. | 11-04-2010 |
20100281015 | METHOD, SYSTEM, AND COMPUTER PROGRAM PRODUCT FOR MANAGING A MULTI-TENANT DATABASE SYSTEM - 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. | 11-04-2010 |
20100281016 | MULTI-TENANT DATABASE SYSTEM - 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. | 11-04-2010 |
20100299663 | SYSTEM, METHOD AND COMPUTER PROGRAM PRODUCT FOR VERSIONING AND DEPRECATION OF COMPONENTS OF AN APPLICATION - In accordance with embodiments, there are provided mechanisms and methods for versioning components of an application. These mechanisms and methods for versioning components of an application can ensure that an updated application maintains backwards compatibility, such that the application developer may maintain a single application while supporting multiple prior versions of the application. | 11-25-2010 |
20100299664 | SYSTEM, METHOD AND COMPUTER PROGRAM PRODUCT FOR PUSHING AN APPLICATION UPDATE BETWEEN TENANTS OF A MULTI-TENANT ON-DEMAND DATABASE SERVICE - In accordance with embodiments, there are provided mechanisms and methods for pushing an application update between tenants of a multi-tenant on-demand database service. These mechanisms and methods for pushing an application update between tenants of a multi-tenant on-demand database service can enable tenants providing the application update to force instances of the application utilized by other tenants to be updated. This may allow the tenants providing the application update to ensure that instances of the application utilized by other tenants are updated. | 11-25-2010 |
20110004668 | METHOD AND SYSTEM FOR SYNCHRONIZING A SERVER AND AN ON-DEMAND DATABASE SERVICE - In accordance with embodiments, there are provided mechanisms and methods for synchronizing a server and an on-demand database service. These mechanisms and methods for synchronizing a server and an on-demand database service can enable embodiments to synchronize a larger amount of data. The ability of embodiments to provide such feature can enable more effective synchronization of a user-level sharing entity database with a multi-user on-demand database service. | 01-06-2011 |
20110208739 | SYSTEM, METHOD AND COMPUTER PROGRAM PRODUCT FOR CONDITIONALLY PERFORMING A QUERY INCLUDING AN AGGREGATE FUNCTION - In accordance with embodiments, there are provided mechanisms and methods for conditionally performing a query including an aggregate function. These mechanisms and methods for conditionally performing a query including an aggregate function can limit performance of queries including aggregate functions based on a number or records associated with such performance of such aggregate functions. The ability to limit performance of queries including aggregate functions can enable performance quality of a computer system to be maintained. | 08-25-2011 |
20110231835 | SYSTEM, METHOD AND COMPUTER PROGRAM PRODUCT FOR CONDITIONALLY ENABLING AN INSTALLATION ASPECT - In accordance with embodiments, there are provided mechanisms and methods for conditionally enabling an installation aspect. These mechanisms and methods for conditionally enabling an installation aspect can enable an improved determination of boundaries associated with the code, improved communication between code developers and users, improved security and access restriction, etc. | 09-22-2011 |
20110246435 | SYSTEM, METHOD AND COMPUTER PROGRAM PRODUCT FOR MAINTAINING DATA STORED IN A DATA STRUCTURE - 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. | 10-06-2011 |
20110246449 | IMPLEMENTING COMPOSITE CUSTOM INDICES IN A MULTI-TENANT DATABASE - 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. Finally, using the processor, an improved query is generated using the query syntax, wherein the improved query is based at least in part upon the original query and data stored in the first two-column custom index. | 10-06-2011 |
20110258178 | METHODS AND SYSTEMS FOR PERFORMING CROSS STORE JOINS IN A MULTI-TENANT STORE - 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. | 10-20-2011 |
20110258179 | METHODS AND SYSTEMS FOR OPTIMIZING QUERIES IN A MULTI-TENANT STORE - 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. | 10-20-2011 |
20110258233 | METHODS AND SYSTEMS FOR PROVIDING CUSTOM SETTINGS IN AN ON-DEMAND SERVICE ENVIRONMENT - In accordance with embodiments, there are provided mechanisms and methods for providing custom settings in an on-demand service environment. In an embodiment and by way of example, a method providing custom settings in an on-demand service environment is provided. The method embodiment includes naming the custom object, creating fields for the custom object, assigning a behavior for each field, setting the custom object to a specified type, and if the custom object is of a hierarchical type, then assigning permissions to users with regarding the created fields. | 10-20-2011 |
20120041986 | CUSTOM ENTITIES AND FIELDS IN A MULTI-TENANT DATABASE SYSTEM - Systems and methods for hosting variable schema data such as dynamic tables and columns in a fixed physical database schema. Standard objects, such as tables are provided for use by multiple tenants or organizations in a multi-tenant database system. Each organization may add or define custom fields for inclusion in a standard object. Custom fields for multiple tenants are stored in a custom data column within the object data structure, and this single custom data column may contain different data types for each tenant. | 02-16-2012 |
20120084300 | METHODS AND SYSTEMS FOR OPTIMIZING TEXT SEARCHES OVER STRUCTURED DATA IN A MULTI-TENANT ENVIRONMENT - Search systems and methods for searching structured data and enhancing the relevancy of search results provided to a requesting user or application. Enhanced search results are provided by searching a cache of a user's most recently used items to eliminate or reduce search indexing latency. Also, more relevant search results are provided by re-ranking results based on use history, data security models and/or hierarchical user role models. Further, enhanced search results are provided by including user information in the search index | 04-05-2012 |
20120089602 | METHODS AND SYSTEMS FOR OPTIMIZING TEXT SEARCHES OVER STRUCTURED DATA IN A MULTI-TENANT ENVIRONMENT - Search systems and methods for searching structured data and enhancing the relevancy of search results provided to a requesting user or application. Enhanced search results are provided by searching a cache of a user's most recently used items to eliminate or reduce search indexing latency. Also, more relevant search results are provided by re-ranking results based on use history, data security models and/or hierarchical user role models. Further, enhanced search results are provided by including user information in the search index. | 04-12-2012 |
20120110020 | METHODS AND SYSTEMS FOR CONTROLLING ACCESS TO CUSTOM OBJECTS IN A DATABASE - In embodiments, methods and systems for controlling access to custom objects are provided. These techniques for controlling access to custom objects can enable embodiments to utilize a key for the protection of the security of data that is to remain private while not compromising efficiency of a query. The key for a requested custom object is identified and then used so that only an appropriate portion of a custom entity share table is searched to locate access information. It is then determined whether the user can access at least a portion of the custom object, and the appropriate and allowed data is sent to the user. | 05-03-2012 |
20120151444 | ON-DEMAND DATABASE SERVICE SYSTEM AND METHOD FOR DETERMINING WHETHER A DEVELOPED APPLICATION WILL OPERATE PROPERLY WITH AT LEAST ONE OTHER APPLICATION - In accordance with embodiments, there are provided mechanisms and methods for determining whether a developed application associated with an on-demand database service will operate properly with at least one other application. These mechanisms and methods for providing such determination can enable embodiments to ensure that new versions of developed applications will operate in the same application environment of a previous version. The ability of embodiments to make such determination may lead to an improved application migration development/runtime framework, etc. | 06-14-2012 |
20120166871 | Methods and Systems for Providing Fault Recovery to Side Effects Occurring During Data Processing - Embodiments may recover from faults by forming a new set of rows by removing rows associated with faulting save operations and repeating the saving and forming operations using the new set of rows until a set of rows that can be saved from the known start state without fault is determined. When the subset of successful rows is found, embodiments are able to provide assurance that no side effects (i.e., code or operations triggered by saving of a data to a particular location) have been executed on behalf of any of the failed rows (side effects from custom PL/SOQL code included) by deferring execution of triggers until an entire set of rows can be saved and committed. | 06-28-2012 |
20120233354 | METHOD AND SYSTEM FOR SYNCHRONIZING A SERVER AND AN ON-DEMAND DATABASE SERVICE - In accordance with embodiments, there are provided mechanisms and methods for synchronizing a server and an on-demand database service. These mechanisms and methods for synchronizing a server and an on-demand database service can enable embodiments to synchronize a larger amount of data. The ability of embodiments to provide such feature can enable more effective synchronization of a user-level sharing entity database with a multi-user on-demand database service. | 09-13-2012 |
20120259839 | FIREWALLS FOR SECURING CUSTOMER DATA IN A MULTI-TENANT ENVIRONMENT - Network security is enhanced in a multi-tenant database network environment using a query plan detection module to continually poll the database system to locate and raise an alert for suspect query plans. Security also can be enhanced using a firewall system sitting between the application servers and the client systems that records user and organization information for each client request received, compares this with information included in a response from an application server, and verifies that the response is being sent to the appropriate user. Security also can be enhanced using a client-side firewall system with logic executing on the client system that verifies whether a response from an application server is being sent to the appropriate user system by comparing user and organization id information stored at the client with similar information in the response. | 10-11-2012 |
20120260341 | FIREWALLS FOR SECURING CUSTOMER DATA IN A MULTI-TENANT ENVIRONMENT - Network security is enhanced in a multi-tenant database network environment using a query plan detection module to continually poll the database system to locate and raise an alert for suspect query plans. Security also can be enhanced using a firewall system sitting between the application servers and the client systems that records user and organization information for each client request received, compares this with information included in a response from an application server, and verifies that the response is being sent to the appropriate user. Security also can be enhanced using a client-side firewall system with logic executing on the client system that verifies whether a response from an application server is being sent to the appropriate user system by comparing user and organization id information stored at the client with similar information in the response. | 10-11-2012 |
20120310931 | METHODS AND SYSTEMS FOR OPTIMIZING TEXT SEARCHES OVER STRUCTURED DATA IN A MULTI-TENANT ENVIRONMENT - Search systems and methods for searching structured data and enhancing the relevancy of search results provided to a requesting user or application. Enhanced search results are provided by searching a cache of a user's most recently used items to eliminate or reduce search indexing latency. Also, more relevant search results are provided by re-ranking results based on use history, data security models and/or hierarchical user role models. Further, enhanced search results are provided by including user information in the search index | 12-06-2012 |
20120310989 | CUSTOM ENTITIES AND FIELDS IN A MULTI-TENANT DATABASE SYSTEM - Systems and methods for hosting variable schema data such as dynamic tables and columns in a fixed physical database schema. Standard objects, such as tables are provided for use by multiple tenants or organizations in a multi-tenant database system. Each organization may add or define custom fields for inclusion in a standard object. Custom fields for multiple tenants are stored in a custom data column within the object data structure, and this single custom data column may contain different data types for each tenant, | 12-06-2012 |
20130013773 | METHOD, SYSTEM, AND COMPUTER PROGRAM PRODUCT FOR MANAGING A MULTI-TENANT DATABASE SYSTEM - 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. | 01-10-2013 |
20130046752 | OPTIMIZATION ENGINE IN A MULTI-TENANT DATABASE SYSTEM - 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. | 02-21-2013 |
20130060792 | SYSTEM AND METHODS OF IMPROVING A MULTI-TENANT DATABASE QUERY USING CONTEXTUAL KNOWLEDGE ABOUT NON-HOMOGENEOUSLY DISTRIBUTED TENANT DATA - In embodiments, methods and systems for improving a query in a database system are provided. These method and system embodiments can enable greater contextual knowledge about the types and use of data in tables underlying a relational database to be employed to improve query efficiency. By employing contextual information, embodiments can provide improved queries and/or make recommendations to a query optimizer of a database system to improve its operation based upon knowledge of the data and/or application gathered. Embodiments can be useful in improving query performance in multi-tenant database systems. | 03-07-2013 |
20130238595 | METHODS AND SYSTEMS FOR OPTIMIZING QUERIES IN A MULTI-TENANT STORE - 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. | 09-12-2013 |
20130238655 | METHOD AND SYSTEM FOR ALLOWING ACCESS TO DEVELOPED APPLICATIONS VIA A MULTI-TENANT ON-DEMAND DATABASE SERVICE - In accordance with embodiments, there are provided mechanisms and methods for allowing access to developed applications via a multi-tenant on-demand database service, in a controlled environment. These mechanisms and methods for providing such access can enable embodiments to provide additional control over the development process as well as the access of such developed applications. The ability of embodiments to provide such additional control may lead to an improved application development framework, etc. | 09-12-2013 |
20130246356 | SYSTEM, METHOD AND COMPUTER PROGRAM PRODUCT FOR PUSHING AN APPLICATION UPDATE BETWEEN TENANTS OF A MULTI-TENANT ON-DEMAND DATABASE SERVICE - In accordance with embodiments, there are provided mechanisms and methods for pushing an application update between tenants of a multi-tenant on-demand database service. These mechanisms and methods for pushing an application update between tenants of a multi-tenant on-demand database service can enable tenants providing the application update to force instances of the application utilized by other tenants to be updated. This may allow the tenants providing the application update to ensure that instances of the application utilized by other tenants are updated. | 09-19-2013 |
20130246411 | METHODS AND SYSTEMS FOR OPTIMIZING TEXT SEARCHES OVER STRUCTURED DATA IN A MULTI-TENANT ENVIRONMENT - Search systems and methods for searching structured data and enhancing the relevancy of search results provided to a requesting user or application. Enhanced search results are provided by searching a cache of a user's most recently used items to eliminate or reduce search indexing latency. Also, more relevant search results are provided by re-ranking results based on use history, data security models and: or hierarchical user role models. Further, enhanced search results are provided by including user information in the search index | 09-19-2013 |
20130246450 | SYSTEM AND METHODS OF IMPROVING A MULTI-TENANT DATABASE QUERY USING CONTEXTUAL KNOWLEDGE ABOUT NON-HOMOGENEOUSLY DISTRIBUTED TENANT DATA - In embodiments, methods and systems for improving a query in a database system are provided. These method and system embodiments can enable greater contextual knowledge about the types and use of data in tables underlying a relational database to be employed to improve query efficiency. By employing contextual information, embodiments can provide improved queries and/or make recommendations to a query optimizer of a database system to improve its operation based upon knowledge of the data and/or application gathered. Embodiments can be useful in improving query performance in multi-tenant database systems. | 09-19-2013 |
20130246471 | QUERY OPTIMIZATION IN A MULTI-TENANT DATABASE SYSTEM - The present invention provides techniques for managing process space on a multi-tenant database system that features a method that provides to multiple users of two or more organizations, over a network, access to information stored in a database repository shared by the two or more organizations. The database repository implements security protocols to restrict a set of first users to a first sub-portion of the information. The set of first users belongs to one of the two or more organizations. The first sub-portion of the information is different from a second sub-portion accessible by users from another organization. Access of the information by the multiple users is monitored. A first processing space for the set of first users is generated in response to the access of the database repository. The first processing space is distinct from a second processing space for the users from the other organization. | 09-19-2013 |
20130246472 | QUERY OPTIMIZATION IN A MULTI-TENANT DATABASE SYSTEM - The present invention provides techniques for managing process space on a multi-tenant database system that features a method that provides to multiple users of two or more organizations, over a network, access to information stored in a database repository shared by the two or more organizations. The database repository implements security protocols to restrict a set of first users to a first sub-portion of the information. The set of first users belongs to one of the two or more organizations. The first sub-portion of the information is different from a second sub-portion accessible by users from another organization. Access of the information by the multiple users is monitored. A first processing space for the set of first users is generated in response to the access of the database repository. The first processing space is distinct from a second processing space for the users from the other organization. | 09-19-2013 |
20130275424 | METHODS AND SYSTEMS FOR OPTIMIZING TEXT SEARCHES OVER STRUCTURED DATA IN A MULTI-TENANT ENVIRONMENT - Search systems and methods for searching structured data and enhancing the relevancy of search results provided to a requesting user or application. Enhanced search results are provided by searching a cache of a user's most recently used items to eliminate or reduce search indexing latency. Also, more relevant search results are provided by re-ranking results based on use history, data security models and/or hierarchical user role models. Further, enhanced search results are provided by including user information in the search index | 10-17-2013 |
20130318057 | TECHNIQUES FOR IMPLEMENTING BATCH PROCESSING IN A MULTI-TENANT ON-DEMAND DATABASE SYSTEM - In accordance with embodiments, there are provided techniques for implementing batch processing in a multi-tenant database system. These techniques for implementing batch processing in a multi-tenant database system may enable embodiments to provide great flexibility to a tenant of the architecture to perform desired functions on content of the database while allowing the owner of the architecture schedule the processing of the functions on the content. | 11-28-2013 |
20140046915 | METHODS AND SYSTEMS FOR BULK ROW SAVE LOGIC IN AN OBJECT RELATIONAL MAPPING LAYER AND APPLICATION FRAMEWORK - In accordance with embodiments, there are provided mechanisms and methods for saving multiple rows together through an object relational mapping layer to a database. These mechanisms and methods for saving multiple rows together can enable embodiments to detect faults in the save operation(s) and recover. The ability of embodiments to detect faults in the save operation(s) and recover can enable embodiments to provide a robust forgiving published API that saves a set of rows together whenever possible. | 02-13-2014 |
20140067439 | TRAVEL DATA INGESTION AND SESSIONIZATION IN A MULTI-TENANT CLOUD ARCHITECTURE - A travel sessionizer captures raw event data from a user device, the raw event data representing user shopping behavior, and parses the raw event data into one or more travel sessions. Each of the one or more travel sessions represents shopping behavior for a single user corresponding to a specified date range. The travel sessionizer denormalizes the one or more travel sessions to organize travel session data by individual property days, where each individual property day represents travel session data corresponding to a separate property on a given day. The travel sessionizer then provides the individual property day data to a profit optimization module for further processing. | 03-06-2014 |
20140067469 | TRAVEL DEMAND FORECAST USING SHOPPING DATA - A profit optimization module identifies historical transaction data associated with a travel property. The historical transaction data includes bookings made for a same day of the week as the day of arrival during a forecast period for a plurality of previous weeks. The profit optimization module also identifies lost business data associated with the travel property from the historical transaction data. The lost business data includes at least one of a regret or a denial. The profit optimization module forecasts a demand for bookings at the travel property on a day of arrival, wherein the demand for bookings is based on at least in part on the historical transaction data and the lost business data. In addition, the profit optimization module determines an offer price for a booking of a unit at the travel property, wherein the offer price is based on a capacity of the travel property and the forecasted demand for bookings at the travel property, and wherein the offer price is designed to increase a profit for the travel property. | 03-06-2014 |
20140095545 | METHODS AND SYSTEMS FOR CONTROLLING ACCESS TO CUSTOM OBJECTS IN A DATABASE - In embodiments, methods and systems for controlling access to custom objects are provided. These techniques for controlling access to custom objects can enable embodiments to utilize a key for the protection of the security of data that is to remain private while not compromising efficiency of a query. The key for a requested custom object is identified and then used so that only an appropriate portion of a custom entity share table is searched to locate access information. It is then determined whether the user can access at least a portion of the custom object, and the appropriate and allowed data is sent to the user. | 04-03-2014 |
20140165033 | ON-DEMAND DATABASE SERVICE SYSTEM, METHOD, AND COMPUTER PROGRAM PRODUCT FOR VALIDATING A DEVELOPED APPLICATION - In accordance with embodiments, there are provided mechanisms and methods for validating a developed application. These mechanisms and methods for providing such validation can enable embodiments to ensure that new versions of developed applications will operate in the same application environment of a previous version. The ability of embodiments to provide such validation may lead to an improved application migration development/runtime framework, etc. | 06-12-2014 |
20140173582 | METHODS AND SYSTEMS FOR UPGRADING AND INSTALLING APPLICATION PACKAGES TO AN APPLICATION PLATFORM - Systems and methods for installing and upgrading application packages to an application platform. Application packages may be uploaded to a directory by developing users (developers) for installation by subscribing users (subscribers). Alternatively, a developer may send identification information to a subscribing user to allow that user to access and install that application package created by the developer. Application packages may also be upgraded. If a developer changes the original source package, a subscriber can choose to pull into their organization the change(s) made by the publisher while preserving any data rows the subscriber had created since first importing the package. | 06-19-2014 |
20140250065 | METHOD AND SYSTEM FOR SYNCHRONIZING A SERVER AND AN ON-DEMAND DATABASE SERVICE - In accordance with embodiments, there are provided mechanisms and methods for synchronizing a server and an on-demand database service. These mechanisms and methods for synchronizing a server and an on-demand database service can enable embodiments to synchronize a larger amount of data. The ability of embodiments to provide such feature can enable more effective synchronization of a user-level sharing entity database with a multi-user on-demand database service. | 09-04-2014 |
20140337064 | NOSQL ONLINE ANALYTICAL PROCESSING ARCHITECTURE - A breadth-first join module receives, at a runtime, a query for travel data, wherein the travel data is stored in a data store, the data store comprising parent and child data structures arranged in a hierarchy. The breadth-first join module identifies a first child data structure associated with the travel data, the first child data structure comprising a plurality of pointers, wherein each of the plurality of pointers is associated with one of a plurality of first level parent data structures in the data store and queries each of the plurality of first level parent data structures to resolve the plurality of pointers in the first child data structure, wherein the plurality of first level parent data structures comprise travel data objects associated with the plurality of pointers, and wherein at least one of the plurality of first level parent data structures comprises a pointer to a second level parent data structure. The breadth-first join module queries the second level parent data structure to resolve the pointer in the at least one first level parent data structure, wherein all of the plurality of pointers in the first child data structure are resolved prior to querying the second level parent data structure. | 11-13-2014 |