Abstract: Systems, methods, and other embodiments for supporting high availability by using in-memory cache as a database are disclosed. In one embodiment, a system includes an application server that is configured to select a sub-set of data from a remote database that is predicted to be accessed by an application server, wherein the application server includes an in-memory cache. The sub-set of data is reformatted to reduce the size. The in-memory cache is configured to act as a backup database by pre-populating the reformatted sub-set of data into the in-memory cache. In response to detecting the remote database is in an off-line state: the in-memory cache is assigned as a primary database to replace the remote database and subsequent data requests are re-directed from being processed using the remote database to being processed using the in-memory cache.

Abstract: In accordance with an embodiment, described herein is a system and method for providing a smart help browser extension for use with an analytics environment. An analytic applications environment can be provided by, or otherwise operate at, a computer system providing access to a data warehouse, or data warehouse instance. A smart help browser extension provides a user-interface based, reusable and configurable plugin that can be dynamically configured in order to provide relevant help content. An end-user can be provided with options on how to view the help content, such as via a help bubble of text, an image, or video, for example. The disclosed extension can also provide admins, or other technical users of the analytics environment, with the ability to record custom help content for other (e.g., non-technical) users of the analytics environment.