Abstract: Methods and apparatuses for operating a database system are described. The method comprises, for example, analyzing a plurality of database queries, generating a data structure object within the database of the database system , wherein the data structure object comprises at least one data set indicated by the plurality of database queries and dynamically modifying the data structure object based on hardware loads.

Abstract: A system and method for realtime snapshot indices is presented. A query is calculated on all target data of a data warehouse, with all variable combinations, to generate a result. The result is stored in a snapshot index associated with the data warehouse. The result is recalcualated to generate a subresult, and the snapshot index is updated with the subresult. A conversion routine is generated to recalculate the subresult into a separate table, and the separate table is then recalculated by a background job to recalculate the subresult.

Abstract: In one aspect, a universal storage manager in a multi-tenant computing system receives at least one message requesting a change to a storage infrastructure of the multi-tenant computing system. Thereafter, the universal storage manager associates the requested change with one of a plurality of operations changing the storage infrastructure. Once this association is made, the universal storage manager initiates the associated operation to change the storage infrastructure. Related apparatus, systems, techniques and articles are also described.

Abstract: Described herein are systems and methods for three phase exception handling ensuring high availability of services. Via unified application program interface (API), one or more inspector instances are observing the behavior one or more services. The three phase exception handling is triggered upon observing an abnormal service behavior. Phase one comprises executing one or more commands from the unified API by the one or more inspector instances in attempt to resolve the abnormal service behavior and notifying a centralized inspector engine. Phase two comprises executing one or more predefined rules according to the current service state by the centralized inspector engine in attempt to resolve the abnormal service behavior and notifying an administrator. Phase three comprises abnormal service behavior analysis by the administrator and executing customized by the administrator rules to resolve the abnormal service behavior.

Abstract: A method includes generating at a client, operating on a user computer, a URL request having URL parameters according to a representational state transfer (REST) protocol, transmitting the URL request from the client to a gateway, which is operating on a server computer, and extracting via the gateway the URL parameters according to the REST protocol. The method further includes generating via the gateway a query for hosted content identified by the URL parameters, transmitting the query to the database, generating a search report for the query, and transmitting the search report from the database to the gateway. The method further includes encoding via the gateway the search report in an XML representation according to the REST protocol, and transmitting the search report in the XML representation from the gateway to the client where the client decodes the search report in the XML representation via the REST protocol for display.

Abstract: In one aspect, a universal storage manager in a multi-tenant computing system receives at least one message requesting a change to a storage infrastructure of the multi-tenant computing system. Thereafter, the universal storage manager associates the requested change with one of a plurality of operations changing the storage infrastructure. Once this association is made, the universal storage manager initiates the associated operation to change the storage infrastructure. Related apparatus, systems, techniques and articles are also described.

Abstract: Exemplary methods and systems may clone a tenant database and send updates to the clone. By doing so, methods and systems may determine a difference between the clone and the tenant, making it possible to test upgrades for a tenant based on the difference. With this capability, a provider-tenant system may upgrade tenant business applications and customize tenant databases.

Abstract: Described herein are systems and methods for three phase exception handling ensuring high availability of services. Via unified application program interface (API), one or more inspector instances are observing the behavior one or more services. The three phase exception handling is triggered upon observing an abnormal service behavior. Phase one comprises executing one or more commands from the unified API by the one or more inspector instances in attempt to resolve the abnormal service behavior and notifying a centralized inspector engine. Phase two comprises executing one or more predefined rules according to the current service state by the centralized inspector engine in attempt to resolve the abnormal service behavior and notifying an administrator. Phase three comprises abnormal service behavior analysis by the administrator and executing customized by the administrator rules to resolve the abnormal service behavior.

Abstract: The present invention discloses methods and systems for hosting tenants over a network in a computer-based environment in which a provider may receive data structures corresponding to a first tenant, determine which of the data structures are specific to the first tenant and which the data structures are shared with the other tenant; generate a tenant template that stores the data structures specific to the first tenant, and use the tenant template to generate a tenant database corresponding to the first tenant and storing the data structures specific to the first tenant.

Abstract: Embodiments of methods and systems consistent with the present invention prevent unauthorized overwriting of shared data by tenants in a provider-tenant system by granting and verifying permissions associated with the tenant. Permissions may be related to table links to shared data stored at a provider database. Thus, tenants may write only to certain designated data structures or groups of data structures, and any attempted unauthorized access creates an exception.

Abstract: Exemplary methods and systems may clone a tenant database and send updates to the clone. By doing so, methods and systems may determine a difference between the clone and the tenant, making it possible to test upgrades for a tenant based on the difference. With this capability, a provider-tenant system may upgrade tenant business applications and customize tenant databases.

Abstract: The present invention discloses methods and systems for hosting tenants over a network in a computer-based environment in which a provider may store a shared data structure having shared data. To register a tenant space during deployment, the provider copies a tenant template stored in a database, populates the copy of the template with initial data, and then registers the dummy template with a system directory. After deploying the tenant space based on the tenant template, the provider replaces the initial data of the registered template with tenant-specific data obtained from the deployed tenant space.

Abstract: The present invention discloses methods and systems for hosting tenants over a network in a computer-based environment in which a provider may receive data structures corresponding to a first tenant, determine which of the data structures are specific to the first tenant and which the data structures are shared with the other tenant; generate a tenant template that stores the data structures specific to the first tenant, and use the tenant template to generate a tenant database corresponding to the first tenant and storing the data structures specific to the first tenant.

Abstract: Exemplary methods and systems may allow for a first tenant of a plurality of tenants to access a data structure at a provider database, wherein each of the plurality of tenants has common access to the data structure. By receiving, from the first tenant, a data request identifying the data structure, and querying, based on the data request, a tenant database associated with the first tenant for the identified data structure a determination may be made, based on the data request, that the identified data structure is located at the provider database. A tenant may redirect the data request to the provider database based on a data structure link reflecting a logical connection to an address of the identified data structure. With this capability a tenant may easily access data structures at a provider database.