End-to-end display of multiple databases in a user interface (UI) with artificial intelligence (AI)
In some cases, an application receives logs from multiple databases associated with an enterprise in which at least a first database is provided by a first database vendor and a second database is provided by a second database vendor. An artificial intelligence (AI) predicts, based at least in part on the logs, a set of issues and a status associated with individual databases of the multiple databases. The application displays, in a user interface (UI), at least a subset of the multiple databases along with the status of the individual databases included in the subset. The AI predicts, based at least in part on the logs and the set of issues, one or more solutions to individual issues in the set of issues. The application displays, in the UI, the one or more solutions proximate to where the status of the individual databases is displayed.
1 . A computing device comprising:
one or more processors; and
one or more non-transitory computer-readable storage media to store instructions executable by the one or more processors to perform operations comprising:
receiving logs from multiple databases associated with an enterprise, the multiple databases including at least a first database provided by a first database vendor and a second database provided by a second database vendor that is different from the first database vendor;
predicting, using an artificial intelligence algorithm and based at least in part on the logs, a set of issues associated with individual databases of the multiple databases;
determining, using the artificial intelligence algorithm and based on the set of issues, a status of the individual databases of the multiple databases;
displaying, in a user interface of a software application, at least a subset of the multiple databases along with the status of the individual databases included in the subset;
predicting, using the artificial intelligence algorithm and based at least in part on the logs and the set of issues, one or more solutions to individual issues in the set of issues; and
displaying, in the user interface of the software application, the one or more solutions proximate to a location in the user interface where the status of the individual databases is displayed.
2 . The computing device of claim 1 , the operations further comprising:
receiving, via the user interface, one or more criteria; and
filtering the multiple databases, using the one or more criteria, to create the subset of the multiple databases.
3 . The computing device of claim 2 , wherein the one or more criteria comprise:
a criticality level associated with the logs;
a number of logs generated;
a time period within which the logs are generated; or
any combination thereof.
4 . The computing device of claim 1 , wherein the set of issues comprise:
a processor utilization greater than a utilization threshold;
a memory utilization greater than a memory threshold;
a storage utilization greater than a storage threshold;
a bandwidth utilization greater than a bandwidth threshold; or
any combination thereof.
5 . The computing device of claim 1 , the operations further comprising:
determining that a particular issue in the set of issues is associated with a particular database of the multiple databases;
determining a particular database vendor associated with the particular database;
accessing a knowledgebase associated with the particular database vendor;
determining that the particular issue is included in the knowledgebase;
identifying a software-based solution to the particular issue in the knowledgebase; and
automatically applying the software-based solution to address the particular issue.
6 . The computing device of claim 1 , the operations further comprising:
determining that a particular issue in the set of issues is associated with a particular database of the multiple databases;
determining a particular database vendor associated with the particular database;
accessing a knowledgebase associated with the particular database vendor;
determining that the particular issue is not included in the knowledgebase; and
automatically raising a ticket with the particular database vendor, the ticket including at least a particular log of the logs that is associated with the particular issue.
7 . The computing device of claim 1 , the operations further comprising:
determining that a particular issue in the set of issues is associated with a server hosting a particular database of the multiple databases;
determining a vendor associated with the server;
accessing a knowledgebase associated with the vendor;
determining that the particular issue is included in the knowledgebase;
identifying a software-based solution to the particular issue; and
automatically applying the software-based solution to address the particular issue.
8 . A memory device to store instructions executable by one or more processors to perform operations comprising:
receiving logs from multiple databases associated with an enterprise, the multiple databases including at least a first database provided by a first database vendor and a second database provided by a second database vendor that is different from the first database vendor;
predicting, using an artificial intelligence algorithm and based at least in part on the logs, a set of issues associated with individual databases of the multiple databases;
determining, using the artificial intelligence algorithm and based on the set of issues, a status of the individual databases of the multiple databases;
displaying, in a user interface of a software application, at least a subset of the multiple databases along with the status of the individual databases included in the subset;
predicting, using the artificial intelligence algorithm and based at least in part on the logs and the set of issues, one or more solutions to individual issues in the set of issues; and
displaying, in the user interface of the software application, the one or more solutions proximate to a location in the user interface where the status of the individual databases is displayed.
9 . The memory device of claim 8 , the operations further comprising:
receiving, via the user interface, one or more criteria; and
filtering the multiple databases, using the one or more criteria, to create the subset of the multiple databases.
10 . The memory device of claim 9 , wherein the one or more criteria comprise:
a criticality level associated with the logs;
a number of logs generated;
a time period within which the logs are generated; or
any combination thereof.
11 . The memory device of claim 8 , the operations further comprising:
determining that a particular issue of the set of issues associated with a particular database of the multiple databases comprises a hardware-related issue; and
displaying a solution in the one or more solutions that includes replacing a hardware component in a server hosting the particular database.
12 . The memory device of claim 8 , the operations further comprising:
displaying a resource utilization amount in the status of the individual databases of the multiple databases.
13 . The memory device of claim 12 , wherein the resource utilization amount comprises:
a processor utilization amount;
a memory utilization amount;
a storage utilization amount;
a bandwidth utilization amount; or
any combination thereof.
14 . The memory device of claim 8 , the operations further comprising:
receiving, via the user interface, one or more criteria;
filtering the logs, using the one or more criteria, to create filtered logs; and
displaying the filtered logs proximate to a location in the user interface where the status of the individual databases is displayed.
15 . A computer-implemented method comprising:
receiving logs from multiple databases associated with an enterprise, the multiple databases including at least a first database provided by a first database vendor and a second database provided by a second database vendor that is different from the first database vendor;
predicting, using an artificial intelligence algorithm and based at least in part on the logs, a set of issues associated with individual databases of the multiple databases;
determining, using the artificial intelligence algorithm and based on the set of issues, a status of the individual databases of the multiple databases;
displaying, in a user interface of a software application, at least a subset of the multiple databases along with the status of the individual databases included in the subset;
predicting, using the artificial intelligence algorithm and based at least in part on the logs and the set of issues, one or more solutions to individual issues in the set of issues; and
displaying, in the user interface of the software application, the one or more solutions proximate to a location in the user interface where the status of the individual databases is displayed.
16 . The computer-implemented method of claim 15 , further comprising:
receiving, via the user interface, one or more criteria; and
filtering the multiple databases, using the one or more criteria, to create the subset of the multiple databases.
17 . The computer-implemented method of claim 16 , wherein the one or more criteria comprise:
a criticality level associated with the logs;
a number of logs generated;
a time period within which the logs are generated; or
any combination thereof.
18 . The computer-implemented method of claim 15 , further comprising:
determining that a particular issue in the set of issues is associated with a particular database of the multiple databases;
determining a particular database vendor associated with the particular database;
accessing a knowledgebase associated with the particular database vendor;
determining that the particular issue is included in the knowledgebase;
identifying a software-based solution to the particular issue in the knowledgebase; and automatically applying the software-based solution to address the particular issue.
19 . The computer-implemented method of claim 18 , wherein the software-based solution comprises:
a workaround;
a software patch; or
a software update.
20 . The computer-implemented method of claim 15 , wherein the set of issues comprise:
a processor utilization greater than a utilization threshold;
a memory utilization greater than a memory threshold;
a storage utilization greater than a storage threshold;
a bandwidth utilization greater than a bandwidth threshold; or
any combination thereof.