Processing hybrid co-tenancy in a multi-database cloud

摘要

In one embodiment, the present invention includes a computer-implemented method comprising monitoring a first condition of an in-memory database. An in-memory data store stores an in-memory database. The method further comprises determining whether the first condition of the in-memory database meets a first defined criterion. If the first condition of the in-memory database meets the first defined criterion, the in-memory database is stored in a persistent data store as a storage based database. If a received query is a query of the storage based database, the query is executed using the storage based database. Metadata of the in-memory database is mapped into a metadata repository if the in-memory database is stored in the in-memory data store. Metadata of the in-memory database is remapped in the metadata repository if the in-memory database is stored in the persistent data store as the storage based database.

主权项

1. A computer-implemented method comprising:
monitoring, by an in-memory database controller, a first condition of an in-memory database;
wherein an in-memory data store stores the in-memory database; causing a separate metadata exchange agent to map metadata of the in-memory database into a metadata repository of a usage analysis engine upon determining that the in-memory database is stored in the in-memory data store; determining, by the in-memory database controller, whether the first condition of the in-memory database meets a first criterion defined by,
a quantity of processing of the in-memory database,a size of the in-memory database,a time of day, anda term of use; upon determining that the first condition of the in-memory database meets the first defined criterion, storing, by the in-memory database controller, the in-memory database in a persistent data store; monitoring a second condition of the persistent data store; determining whether the second condition of the persistent data store meets a second defined criterion; upon determining that the second condition meets the second defined criterion, storing the in-memory database as a storage based database, wherein the second condition comprises a time period, and the second defined criterion comprises a sufficient time for transferring the in-memory database to the storage based database before a next use of the in-memory database; receiving a query in the in-memory database controller; in response to receiving an Extensible Markup Language (XML) or JavaScript Object Notation (JSON) Hypertext Transfer Protocol Secure (HTTPS) xml or json https call, the metadata exchange agent issuing a Java Database Connectivity (JDBC) Hypertext Transfer Protocol Secure (HTTPS) jdbc https call to remap metadata in the storage based database, and switching flags in the metadata repository corresponding to user context received from the in-memory database controller; upon determining that the query is a query of the storage based database, executing, by the in-memory database controller, the query using the storage based database; and reading the metadata including the switched flags in the metadata repository for executing the query.