The use of Open Source software helps users and administrators of databases gain significant value in analyzing the functionality and performance of their specific database products.
By establishing a connection to the database itself via a REST API with optional Open Source ZOWE features and combining it with an Open Source time-series database along with a dashboard visualization package will produce the following benefits:
- Enable client dashboards or application to view system and performance data.
- Allows users to implement and automate warnings and recommendations to avoid system risks.
- Provides flexibility to leverage modern, user friendly tooling improving the user experience.
Here is an example of a real time use case for a Database Administrator (DBA):
As a Database REST API user, I need the ability to quickly and easily access data in order to leverage solutions that analyze system issues, automate processes and alerts, and create intelligent recommendations for tuning.
We’ll take a look at implementation techniques to satisfy a performance monitoring use case, using open-source tools to visualize performance metrics exposed by an API.
Our example will be based on the Zowe API for an example IDMS database, but the techniques are general and can be applied to any product that exposes performance metrics through a REST API.