WO2025052470A1

WO2025052470A1 - System and method for monitoring health of one or more databases in a network

Info

Publication number: WO2025052470A1
Application number: PCT/IN2024/051667
Authority: WO
Inventors: Aayush Bhatnagar; Sandeep Bisht; Suman Singh Kanwer; Ankur MISHRA; Yogendra Pal SINGH; Pankaj Kshirsagar; Anurag Sinha; Mangesh Shantaram Kale; Supriya UPADHYE; Ravindra Yadav; Abhiman JAIN; Ezaj Ansari; Lakhichandra SONKAR
Original assignee: Jio Platforms Ltd
Current assignee: Jio Platforms Ltd
Priority date: 2023-09-07
Filing date: 2024-09-06
Publication date: 2025-03-13
Anticipated expiration: 2026-03-07

Abstract

The present invention relates to a system (108) and a method (600) for monitoring health of one or more databases (110) in a network (106) The method (600) includes step of capturing, one or more health parameters of the one or more databases (110) in the network (106) based on monitoring the one or more databases (110) in pre-defined time intervals. The method (600) further includes step of, generating a detailed report pertaining to a health status of the one or more databases (110) based on the captured one or more health parameters. The method (600) further includes step of, detecting one or more issues pertaining to the one or more databases (110) utilizing the generated detailed report. The method (600) further includes step of, transmitting a notification pertaining to details of the detected one or more issues along with one or more solutions for the detected one or more issues to a user.

Description

SYSTEM AND METHOD FOR MONITORING HEALTH OF ONE OR MORE DATABASES IN A NETWORK

FIELD OF THE INVENTION

[0001] The present invention relates to the field of wireless communication systems, more particularly relates to a method and a system for monitoring health of one or more databases in a network.

BACKGROUND OF THE INVENTION

[0002] In general, a system comprises of one or more databases. These one or more databases may face issues due to some errors, or any other kind of failures. The one or more databases may consist of multiple nodes. The one or more database nodes are storage nodes that connect to other databases and perform different operations on them, such as update, insert, delete, and select.

[0003] The one or more databases facing issues may be due to but not limited to connectivity between an application and the one or more databases, link fluctuation between the one or more databases or between the application and the one or more databases. Due to these issues, Application Programming Interface (API) services and the performance of the one or more databases may get degraded.

[0004] Due to one or more databases nodes or cluster failure may affect the functioning of the entire system. For that matter, even a partial cluster failure can impact the performance of the system.

[0005] In order to detect the failures, health monitoring of the one or more databases are performed so that the failures can be rectified. However, rectifying these failures may be cumbersome and time consuming.

[0006] In view of the above, there is a dire need for the system and a method for monitoring health of the one or more databases, which ensures that the failures in the one or more databases are avoided, and the efficiency and services of the one or more databases are maintained.

SUMMARY OF THE INVENTION

[0007] One or more embodiments of the present disclosure provides a method and a system for monitoring health of one or more databases in a network.

[0008] In one aspect of the present invention, the method for monitoring the health of the one or more databases in the network is disclosed. The method includes the step of capturing, by one or more processors, one or more health parameters of the one or more databases in the network based on monitoring the one or more databases in predefined time intervals. The method further includes the step of generating, by the one or more processors, a detailed report pertaining to a health status of the one or more databases based on the captured one or more health parameters. The method further includes the step of detecting, by the one or more processors, utilizing the generated detailed report, one or more issues pertaining to the one or more databases. The method further includes the step of transmitting, by the one or more processors, a notification pertaining to details of the detected one or more issues along with one or more solutions for the detected one or more issues to a user.

[0009] In another embodiment, the one or more health parameters includes at least one of, overall status of a database cluster, connectivity fluctuation between an application and the one or more databases, connectivity fluctuation between the one or more databases or between the application and the one or more databases, resource utilization by the one or more databases, an interface status, active connection counts, and a thread status.

[0010] In yet another embodiment, the step of detecting, utilizing the generated detailed report, one or more issues pertaining to the one or more databases, includes determining, by the one or more processors, whether the one or more health parameters of the one or more databases are within a predefined threshold. Then, comparing, by the one or more processors, the one or more health parameters of the one or more databases with the predefined threshold. In response to determining, by the one or more processors, the one or more health parameters are within the predefined threshold based on the comparison, continuing monitoring, by the one or more processors, the one or more health parameters of the one or more databases in the predefined time intervals. In response to determining, by the one or more processors, the one or more health parameters reaching the predefined threshold or exceeding the predefined threshold based on the comparison, detecting, by the one or more processors, the one or more issues pertaining to the one or more databases.

[0011] In yet another embodiment, the predefined threshold is configured in real time by the one or more processors.

[0012] In yet another embodiment, the details pertaining to the detected one or more issues are updated and stored in a Root Cause Analysis (RCA) manager.

[0013] In yet another embodiment, the RCA manager further includes at least one of, the one or more solutions for the detected one or more issues.

[0014] In yet another embodiment, the one or more processors is configured to monitor the one or more databases in the pre-defined time intervals.

[0015] In another aspect of the present invention, the system for monitoring health of one or more databases in a network is disclosed. The system includes an extraction unit, configured to capture, one or more health parameters of the one or more databases in the network based on monitoring the one or more databases in pre-defined time intervals. The system includes a report generation unit, configured to, generate, a detailed report pertaining to a health status of the one or more databases based on the captured one or more health parameters. The system further includes a detection unit, configured to, detect, utilizing the generated detailed report, one or more issues pertaining to the one or more databases. The system further includes a transceiver, configured to, transmit, a notification pertaining to details of the detected one or more issues along with one or more solutions for the detected one or more issues to a user.

[0016] In yet another aspect of the present invention, a non -transitory computer- readable medium having stored thereon computer -readable instructions is disclosed. The computer readable instructions when executed by a processor is configured to capture, one or more health parameters of the one or more databases in the network based on monitoring the one or more databases in pre-defined time intervals. The processor is further configured to generate, a detailed report pertaining to a health status of the one or more databases based on the captured one or more health parameters. The processor is further configured to detect, utilizing the generated detailed report, one or more issues pertaining to the one or more databases. The processor is further configured to, transmit, a notification pertaining to details of the detected one or more issues along with one or more solutions for the detected one or more issues to a user.

[0017] In another aspect of the present invention, a User Equipment (UE) is disclosed. One or more primary processors is communicatively coupled to one or more processors. The one or more primary processors is further coupled with a memory. The memory stores instructions which when executed by the one or more primary processors causes the UE to receive the notification from the one or more processors pertaining to the details of the detected one or more issues along with one or more solutions for the detected one or more issues.

[0018] Other features and aspects of this invention will be apparent from the following description and the accompanying drawings. The features and advantages described in this summary and in the following detailed description are not all- inclusive, and particularly, many additional features and advantages will be apparent to one of ordinary skill in the relevant art, in view of the drawings, specification, and claims hereof. Moreover, it should be noted that the language used in the specification has been principally selected for readability and instructional purposes and may not have been selected to delineate or circumscribe the inventive subject matter, resort to the claims being necessary to determine such inventive subject matter.

BRIEF DESCRIPTION OF THE DRAWINGS

[0019] The accompanying drawings, which are incorporated herein, and constitute a part of this disclosure, illustrate exemplary embodiments of the disclosed methods and systems in which like reference numerals refer to the same parts throughout the different drawings. Components in the drawings are not necessarily to scale, emphasis instead being placed upon clearly illustrating the principles of the present disclosure. Some drawings may indicate the components using block diagrams and may not represent the internal circuitry of each component. It will be appreciated by those skilled in the art that disclosure of such drawings includes disclosure of electrical components, electronic components or circuitry commonly used to implement such components.

[0020] FIG. 1 is an exemplary block diagram of an environment for monitoring health of one or more databases in a network, according to one or more embodiments of the present invention;

[0021] FIG. 2 is an exemplary block diagram of a system for monitoring the health of the one or more databases in the network, according to one or more embodiments of the present invention;

[0022] FIG. 3 is an exemplary architecture of the system of FIG. 2, according to one or more embodiments of the present invention;

[0023] FIG. 4 is an exemplary architecture for monitoring the health of the one or more databases in the network, according to one or more embodiments of the present disclosure; [0024] FIG. 5 is an exemplary signal flow diagram illustrating the flow for monitoring the health of the one or more databases in the network, according to one or more embodiments of the present disclosure; and

[0025] FIG. 6 is a flow diagram of a method for monitoring the health of the one or more databases in the network, according to one or more embodiments of the present invention.

[0026] The foregoing shall be more apparent from the following detailed description of the invention.

DETAILED DESCRIPTION OF THE INVENTION

[0027] Some embodiments of the present disclosure, illustrating all its features, will now be discussed in detail. It must also be noted that as used herein and in the appended claims, the singular forms "a", "an" and "the" include plural references unless the context clearly dictates otherwise.

[0028] Various modifications to the embodiment will be readily apparent to those skilled in the art and the generic principles herein may be applied to other embodiments. However, one of ordinary skill in the art will readily recognize that the present disclosure including the definitions listed here below are not intended to be limited to the embodiments illustrated but is to be accorded the widest scope consistent with the principles and features described herein.

[0029] A person of ordinary skill in the art will readily ascertain that the illustrated steps detailed in the figures and here below are set out to explain the exemplary embodiments shown, and it should be anticipated that ongoing technological development will change the manner in which particular functions are performed. These examples are presented herein for purposes of illustration, and not limitation. Further, the boundaries of the functional building blocks have been arbitrarily defined herein for the convenience of the description. Alternative boundaries can be defined so long as the specified functions and relationships thereof are appropriately performed. Alternatives (including equivalents, extensions, variations, deviations, etc., of those described herein) will be apparent to persons skilled in the relevant art(s) based on the teachings contained herein. Such alternatives fall within the scope and spirit of the disclosed embodiments.

[0030] Various embodiments of the present invention provide a system and a method for monitoring health of one or more databases in a network. The present invention is able to ensure that failures in the one or more databases are avoided and performance of the one or more databases are not degraded. The disclosed system and method aim at enhancing efficiency by monitoring the one or more databases thereby detecting/predicting/forecasting any kind of failures before its occurrence. In other words, the present invention provides a unique approach of protecting the one or more databases from a service failure and in advance a user can take action and prevent the system from the complete failure.

[0031] Referring to FIG. 1, FIG. 1 illustrates an exemplary block diagram of an environment 100 for monitoring health of one or more databases 110 in a network 106, according to one or more embodiments of the present invention. The environment 100 includes a User Equipment (UE) 102, a server 104, the network 106, a system 108, and the one or more databases 110. In an embodiment, the UE 102 interacts with the system 108 in order to monitor health of the one or more databases 110 in the network 106.In one embodiment, the health of the one or more databases 110 is a state of the one or more databases 110 which indicates how smoothly the one or more databases 110 are functioning. In particular, the health indicates at least one of, but not limited to, a speed, an efficiency, a performance, and a safety associated with the one or more databases 110.

[0032] For the purpose of description and explanation, the description will be explained with respect to one or more user equipment’s (UEs) 102, or to be more specific will be explained with respect to a first UE 102a, a second UE 102b, and a third UE 102c, and should nowhere be construed as limiting the scope of the present disclosure. Each of the at least one UE 102 namely the first UE 102a, the second UE 102b, and the third UE 102c is configured to connect to the server 104 via the network 106.

[0033] In an embodiment, each of the first UE 102a, the second UE 102b, and the third UE 102c is one of, but not limited to, any electrical, electronic, electromechanical or an equipment and a combination of one or more of the above devices such as smartphones, Virtual Reality (VR) devices, Augmented Reality (AR) devices, laptop, a general-purpose computer, desktop, personal digital assistant, tablet computer, mainframe computer, or any other computing device.

[0034] The network 106 includes, by way of example but not limitation, one or more of a wireless network, a wired network, an internet, an intranet, a public network, a private network, a packet-switched network, a circuit-switched network, an ad hoc network, an infrastructure network, a Public-Switched Telephone Network (PSTN), a cable network, a cellular network, a satellite network, a fiber optic network, or some combination thereof. The network 106 may include, but is not limited to, a Third Generation (3G), a Fourth Generation (4G), a Fifth Generation (5G), a Sixth Generation (6G), a New Radio (NR), a Narrow Band Internet of Things (NB-IoT), an Open Radio Access Network (O-RAN), and the like.

[0035] The network 106 may also include, by way of example but not limitation, at least a portion of one or more networks having one or more nodes that transmit, receive, forward, generate, buffer, store, route, switch, process, or a combination thereof, etc. one or more messages, packets, signals, waves, voltage or current levels, some combination thereof, or so forth.

[0036] The environment 100 includes the server 104 accessible via the network 106. The server 104 may include by way of example but not limitation, one or more of a standalone server, a server blade, a server rack, a bank of servers, a server farm, hardware supporting a part of a cloud service or system, a home server, hardware running a virtualized server, a processor executing code to function as a server, one or more machines performing server-side functionality as described herein, at least a portion of any of the above, some combination thereof. In an embodiment, the entity may include, but is not limited to, a vendor, a network operator, a company, an organization, a university, a lab facility, a business enterprise side, a defense facility side, or any other facility that provides service.

[0037] The environment 100 further includes the one or more databases 110. As per the illustrated embodiment, the one or more databases 110 is configured to store data associated with the network 106. The one or more databases 110 is one of, but not limited to, a centralized database, a cloud-based database, a commercial database, an open-source database, a distributed database, an end-user database, a graphical database, a No-Structured Query Language (NoSQL) database, an object-oriented database, a personal database, an in-memory database, a document-based database, a time series database, a wide column database, a key value database, a search database, a cache databases, and so forth. The foregoing examples of the one or more databases 110 types are non-limiting and may not be mutually exclusive e.g., the database can be both commercial and cloud-based, or both relational and open-source, etc.

[0038] The environment 100 further includes the system 108 communicably coupled to the server 104, the UE 102, and the one or more databases 110 via the network 106. The system 108 is adapted to be embedded within the server 104 or is embedded as the individual entity.

[0039] Operational and construction features of the system 108 will be explained in detail with respect to the following figures.

[0040] FIG. 2 is an exemplary block diagram of the system 108 for monitoring the health of the one or more databases 110 in the network 106, according to one or more embodiments of the present invention. [0041] As per the illustrated and preferred embodiment, the system 108 for monitoring the health of the one or more databases 110 in the network 106, includes one or more processors 202, a memory 204, and a storage unit 206. The one or more processors 202, hereinafter referred to as the processor 202, may be implemented as one or more microprocessors, microcomputers, microcontrollers, digital signal processors, central processing units, state machines, logic circuitries, single board computers, and/or any devices that manipulate signals based on operational instructions. However, it is to be noted that the system 108 may include multiple processors as per the requirement and without deviating from the scope of the present disclosure. Among other capabilities, the processor 202 is configured to fetch and execute computer-readable instructions stored in the memory 204.

[0042] As per the illustrated embodiment, the processor 202 is configured to fetch and execute computer-readable instructions stored in the memory 204 as the memory 204 is communicably connected to the processor 202. The memory 204 is configured to store one or more computer-readable instructions or routines in a non-transitory computer-readable storage medium, which may be fetched and executed to monitor health of the one or more databases 110 in the network 106. The memory 204 may include any non-transitory storage device including, for example, volatile memory such as RAM, or non-volatile memory such as disk memory, EPROMs, FLASH memory, unalterable memory, and the like.

[0043] As per the illustrated embodiment, the storage unit 206 is configured to store data associated with the health of the one or more databases 110. In particular, the storage unit 206 stores the one or more health parameters of the one or more databases 110. The storage unit 206 is one of, but not limited to, a centralized database, a cloudbased database, a commercial database, an open-source database, a distributed database, an end-user database, a graphical database, a No-Structured Query Language (NoSQL) database, an object-oriented database, a personal database, an in-memory database, a document-based database, a time series database, a wide column database, a key value database, a search database, a cache databases, and so forth. The foregoing examples of storage unit 206 types are non-limiting and may not be mutually exclusive e.g., the database can be both commercial and cloud-based, or both relational and open-source, etc.

[0044] As per the illustrated embodiment, the system 108 includes the processor 202 for monitoring the health of the one or more databases 110 in the network 106. The processor 202 includes an extraction unit 208, a report generation unit 210, a detection unit 212, a transceiver 214, a Root Cause Analysis (RCA) manager 216 and a monitoring unit 218. The processor 202 is communicably coupled to one or more components of the system 108 such as the storage unit 206, and the memory 204. In an embodiment, operations and functionalities of the extraction unit 208, the report generation unit 210, the detection unit 212, the transceiver 214, the Root Cause Analysis (RCA) manager 216, the monitoring unit 218 and the one or more components of the system 108 can be used in combination or interchangeably.

[0045] Initially, the health of the one or more databases 110 is monitored by the monitoring unit 218 of the processor 202. In one scenario, the health of the one or more databases 110 is continuously monitored by the monitoring unit 218. In another scenario, the health of the one or more databases 110 is monitored in pre-defined time intervals by the monitoring unit 218. Herein, at least one of, but not limited to, a user and the processor 202 defines the pre-defined time intervals, based on historical data pertaining to one or more health parameters of the one or more databases 110, at which the health of the one or more databases 110 is to be monitored.

[0046] In an embodiment, based on the monitoring of the one or more databases 110 in the pre-defined time intervals, the extraction unit 208 of the processor 202 is configured to capture the one or more health parameters of the one or more databases 110 in the network 106. In one embodiment, the extraction unit 208 captures the one or more health parameters from at least one of, but not limited to, the one or more databases 110 and the storage unit 206. The one or more health parameters refers to a characteristic or a behavior of the one or more databases 110. In one embodiment, the one or more health parameters includes at least one of, but not limited to, an overall status of a database cluster, a connectivity fluctuation between an application and the one or more databases 110, a connectivity fluctuation between the one or more databases 110 or between application and the one or more databases 110, a resource utilization by the one or more databases 110, an interface status, an active connection counts, and a thread status. In one embodiment, an application includes at least one of, but not limited to, a database application. The database application is used to manage and organize the one or more databases 110. In particular, the database applications are software programs that allow users to access and the one or more databases 110.

[0047] In one embodiment, the database cluster is the connection of more than one database to the system 108. In particular, the database clusters include multiple databases which are usually managed by a single database called as a master database. The one or more databases 110 are connected to each other via at least one of, the connections, the links and the interfaces. In one embodiment, the overall status of the database cluster is a measure of health status of the one or more databases 110 within the database cluster. In particular, the overall status of the database cluster is the combined performance measure of the one or more databases 110. The overall status of the database cluster includes information pertaining to, at least one of, but not limited to, data stored in the one or more databases 110, data modified in the one or more databases 110 or deleting data from the one or more databases 110.

[0048] In one embodiment, the resource is any hardware or software accessible by one or more databases 110 such at least one of, but not limited to, a memory. In one embodiment, the resource utilization is the measure of how much of the available resources are currently being used by the one or more databases 110. In one embodiment, the applications are software programs that allow users to access and maintain the one or more databases 110. In one embodiment, the active connection count is the total number of connections/links active from the system 108 to one or more databases 110. In one embodiment, the threads are an essential aspect of the database engine's architecture that plays a crucial role in managing concurrent user requests and the one or more databases 110 operations.

[0049] Upon extracting the one or more health parameters of the one or more databases 110, the report generation unit 210 of the processor 202 is configured to generate a detailed report pertaining to a health status of the one or more databases 110 based on the captured one or more health parameters. In particular, the detailed report generated by the report generation unit 210 includes, data pertaining to the one or more health parameters of the of the one or more databases 110.

[0050] In one embodiment, the detailed report generated by the report generation unit 210 includes at least one of, but not limited to, throughput, overall performance, memory consumption, latency, connectivity information. Herin, the throughput is the amount of data processed by the one or more databases 110 at any given point in time. The throughput is measured in the number of read or write operations performed by the one or more databases 110 per second. In particular, the more data processed by the one or more databases 110 over a defined period of time, the higher is the overall performance of the one or more databases 110. In one embodiment, the latency indicates the delay experienced by while at least one of, storing of transferring associated with the one or more databases 110. In particular, the latency would be provided in the detailed report such as milliseconds or seconds.

[0051] In one embodiment, the memory consumption refers to the amount of memory space utilized by data within the one or more databases 110. If 1 Terabyte (TB) is the memory, then in the detailed report the memory consumption will be provided such as 500 Gigabyte (GB). Further, the detailed report also includes the connectivity information between multiple nodes of the one or more databases 110 such as the links between the multiple nodes of the one or more databases 110 are active or inactive. Further, the detailed report includes the health status of the one or more databases 110. In an example, the health status of the one or more databases 110 is indicated as 90% in the detailed report. In order words, the detailed report indicates an efficiency of the one or more databases 110, i.e. 90%.

[0052] Upon generating the detailed report pertaining to the health status of the one or more databases 110, the detection unit 212 of the processor 202 is configured to utilize the generated detailed report in order to detect one or more issues pertaining to the one or more databases 110. In one embodiment, the one or more issues includes at least one of, but not limited to, link fluctuations or connectivity issues between multiple nodes of the one or more databases 110 and at least one node among the multiple nodes of the one or more databases 110 is unresponsive or unavailable. For example, connectivity between a database A and a database B is inactive, memory of the one or more databases 110 has reached 95% due to which the one or more databases 110 are facing delays in performing read/write operations.

[0053] In order to detect the one or more issues pertaining to the one or more databases 110, the detection unit 212 determines whether the one or more health parameters of the one or more databases 110 included in the generated detailed report are within a predefined threshold. In one embodiment, the predefined threshold is configured by at least one of, but not limited to, the user and the processor 202 based on the historical data pertaining to one or more databases 110. In particular, the predefined threshold is configured in real time by the detection unit 212. Herein, the pre-defined thresholds are associated with the one or more health parameters of the primary database 110 which facilitates the detection unit 212 for detecting the one or more issues pertaining to the one or more databases 110. Further, the detection unit 212 compares the one or more health parameters of the one or more databases 110 with the predefined threshold in order to whether the one or more health parameters are within the predefined threshold or exceeding the predefined threshold.

[0054] Thereafter, based on the comparison when the detection unit 212 determines that the one or more health parameters are within the predefined threshold, then the detection unit 212 notifies the monitoring unit 218 to continue the monitoring of the one or more health parameters of the one or more databases 110 in the predefined time intervals. Similarly, based on the comparison when the detection unit 212 determines that the one or more health parameters are parameters reaching the predefined threshold or exceeding the predefined threshold, then the detection unit 212 detects the one or more issues pertaining to the one or more databases 110. In an alternate embodiment, based on the comparison when the detection unit 212 determines that the one or more health parameters are parameters reaching the predefined threshold or going down below the predefined threshold, then the detection unit 212 detects the one or more issues pertaining to the one or more databases 110.

[0055] Upon detecting the one or more issues pertaining to the one or more databases 110, the detection unit 212 is further configured to provide the details pertaining to the detected one or more issues in the Root Cause Analysis (RCA) manager 216. In particular, the Root Cause Analysis (RCA) manager 216 is configured to update and store details pertaining to the detected one or more issues within the Root Cause Analysis (RCA) manager 216. For example, the Root Cause Analysis (RCA) manager 216 stores data pertaining to past and present detected one or more issues.

[0056] In one embodiment, the details pertaining to the detected one or more issues includes details related to the one or more health parameters such as a difference between the predefined threshold and the one or more health parameters. In one embodiment, the details pertaining to the detected one or more issues includes at the measures of at least one of, but not limited to, the throughput, the latency, the memory consumption pertaining to the one or more databases 110.

[0057] In one embodiment, the Root Cause Analysis (RCA) manager 216 includes at least one of, but not limited to, one or more suggestions and the one or more solutions for the detected one or more issues. The one or more suggestions and the one or more solutions are related to the rectification of the detected one or more issues. For example, the Root Cause Analysis (RCA) manager 216 includes prestored one or more solutions that may have been considered for the past detected one or more issues.

[0058] In one embodiment, the Root Cause Analysis (RCA) manager 216 is further configured to provide a notification pertaining to the details of the detected one or more issues along with the at least one of, but not limited to, the one or more suggestions and the one or more solutions to the transceiver 214 of the processor 202 for rectifying the detected one or more issues.

[0059] Further, the transceiver 214 is configured to transmit, the notification pertaining to details of the detected one or more issues along with one or more solutions for the detected one or more issues to the UE 102 of the user in order to resolve the issue. Due to this approach, the time consumption for resolving the detected one or more issues is reduced and the complete system 108 failure is avoided.

[0060] In one embodiment, the monitoring unit 218 of the processor 202 configured to monitor the one or more health parameters of the one or more databases 110 in the predefined time intervals. For monitoring, the monitoring unit 218 compares the one or more health parameters of the one or more databases 110 with the one or more health parameters included in a Golden Configuration Templates (GCT). The GCT is a file or repository in which the ideal values for the one or more health parameters of the one or more databases 110 are configured and stored. In particular, the ideal values for the one or more health parameters are configured and stored by at least one of, the user and the processor 202.

[0061] In one embodiment, the one or more health parameters included in the GCT are the standard or pre-configured one or more health parameters against which the one or more health parameters of the one or more databases 110 are compared to detect performance of the one or more databases 110. In one embodiment, based on the performance one or more databases 110 the one or more health parameters associated with the GCT are optimized by at least one of, the user and the processor 202. [0062] The extraction unit 208, the report generation unit 210, the detection unit 212, the transceiver 214, the Root Cause Analysis (RCA) manager 216, and the monitoring unit 218 in an exemplary embodiment, are implemented as a combination of hardware and programming (for example, programmable instructions) to implement one or more functionalities of the processor 202. In the examples described herein, such combinations of hardware and programming may be implemented in several different ways. For example, the programming for the processor 202 may be processor-executable instructions stored on a non-transitory machine-readable storage medium and the hardware for the processor may comprise a processing resource (for example, one or more processors), to execute such instructions. In the present examples, the memory 204 may store instructions that, when executed by the processing resource, implement the processor 202. In such examples, the system 108 may comprise the memory 204 storing the instructions and the processing resource to execute the instructions, or the memory 204 may be separate but accessible to the system 108 and the processing resource. In other examples, the processor 202 may be implemented by electronic circuitry.

[0063] FIG. 3 illustrates an exemplary architecture for the system 108, according to one or more embodiments of the present invention. More specifically, FIG. 3 illustrates the system 108 for monitoring health of the one or more databases 110 in the network 106. It is to be noted that the embodiment with respect to FIG. 3 will be explained with respect to the UE 102 for the purpose of description and illustration and should nowhere be construed as limited to the scope of the present disclosure.

[0064] FIG. 3 shows communication between the UE 102, the system 108 and the one or more databases 110. For the purpose of description of the exemplary embodiment as illustrated in FIG. 3, the UE 102, uses network protocol connection to communicate with the system 108. In an embodiment, the network protocol connection is the establishment and management of communication between the UE 102, the system 108, and the one or more databases 110 over the network 106 (as shown in FIG. 1) using a specific protocol or set of protocols. The network protocol

Y1 connection includes, but not limited to, Session Initiation Protocol (SIP), System Information Block (SIB) protocol, Transmission Control Protocol (TCP), User Datagram Protocol (UDP), File Transfer Protocol (FTP), Hypertext Transfer Protocol (HTTP), Simple Network Management Protocol (SNMP), Internet Control Message Protocol (ICMP), Hypertext Transfer Protocol Secure (HTTPS) and Terminal Network (TELNET).

[0065] In an embodiment, the UE 102 includes a primary processor 302, and a memory 304 and a User Interface (UI) 306. In alternate embodiments, the UE 102 may include more than one primary processor 302 as per the requirement of the network 106. The primary processor 302, may be implemented as one or more microprocessors, microcomputers, microcontrollers, digital signal processors, central processing units, state machines, logic circuitries, single board computers, and/or any devices that manipulate signals based on operational instructions.

[0066] In an embodiment, the primary processor 302 is configured to fetch and execute computer-readable instructions stored in the memory 304. The memory 304 may be configured to store one or more computer-readable instructions or routines in a non-transitory computer-readable storage medium, which may be fetched and executed to monitor health of the one or more databases 110. The memory 304 may include any non-transitory storage device including, for example, volatile memory such as RAM, or non-volatile memory such as disk memory, EPROMs, FLASH memory, unalterable memory, and the like.

[0067] In an embodiment, the User Interface (UI) 306 includes a variety of interfaces, for example, a graphical user interface, a web user interface, a Command Line Interface (CLI), and the like. The User Interface (UI) 306 of the UE 102 allows the user to transmit a request to the system 108 for monitoring health of the one or more databases 110. In one embodiment, the user may be at least one of, but not limited to, a network operator. [0068] For example, based on the request received from the UE 102, the system 108 monitors health of the one or more databases 110. In particular, the system monitors 108 the one or more databases at the background in the predefined time interval. Further, the system 108 captures one or more health parameters of the one or more databases 110 and generates the detailed report. Depending on the generated report, the system 108 identifies the one or more issues and notifies the user via the UI 306 of the UE 102 with the one or more suggestions/recommendations for resolving the identified one or more issues. Advantageously, due to these one or more suggestions/recommendations related to the identified one or more issues, the users resolve the issue and avoids the complete system 108 failure.

[0069] As mentioned earlier in FIG.2, the system 108 includes the processors 202, the memory 204, and the storage unit 206, for monitoring health of the one or more databases 110 in the network 106, which are already explained in FIG. 2. For the sake of brevity, a similar description related to the working and operation of the system 108 as illustrated in FIG. 2 has been omitted to avoid repetition.

[0070] Further, as mentioned earlier the processor 202 includes the extraction unit 208, the report generation unit 210, the detection unit 212, the transceiver 214, the Root Cause Analysis (RCA) manager 216, and the monitoring unit 218 which are already explained in FIG. 2. Hence, for the sake of brevity, a similar description related to the working and operation of the system 108 as illustrated in FIG. 2 has been omitted to avoid repetition. The limited description provided for the system 108 in FIG. 3, should be read with the description provided for the system 108 in the FIG. 2 above, and should not be construed as limiting the scope of the present disclosure.

[0071] FIG. 4 is an exemplary the system 108 architecture 400 for monitoring health of the one or more databases 110 in the network 106, according to one or more embodiments of the present disclosure. [0072] The architecture 400 includes an Application Programming Interface (API) consumer 402, an UI API dashboard 404, a common API gateway 406, a plurality of API providers (an API provider- 1 408a, an API provider-2 408b, an API provider-N 408c), an API publisher 410, an analyser 416, a one cache 420, a persistence database 422a and a cache 422b communicably coupled to each other via the network 106.

[0073] The architecture 400 of the present invention comprises of the API consumer 402. The API consumer 402 may be at least one of, an application, a developer or an enterprise that intend to use Application Programming Interfaces (APIs) for their respective use cases such as monitoring the health of the at least one of, the persistent database 422a and the cache 422b. Herein, the persistent database 422a and the cache 422b are included in the one or more databases 110. The Persistent database 422a is a database for all persistent records, the persistent database 422a is a scalable, a document oriented, a schema free database. The persistent database 422a is at least one of, but not limited to, Elastic search, and Redis, etc. The cache 422b is a distributed cache which is an in-memory data structure store, used as a database, cache and a message broker. The message broker is software that enables the applications, systems and services to communicate with each other and exchange information.

[0074] In an embodiment, the UI API Dashboard 404 is a User Interface (UI) from where the user transmits the request or API calls for monitoring the health of the at least one of, the persistent database 422a and the cache 422b and visualize notification pertaining to the details of the detected one or more issues along with one or more solutions for the detected one or more issues.

[0075] In an embodiment, the common API gateway 406 may be a part of the system 108. The common API gateway 406 is a data-plane entry point for the API calls that represent API consumer 402 requests to monitor the health of at least one of, the persistent database 422a and the cache 422b. The common API gateway 406 typically performs request/ API calls processing based on defined policies, including authentication, authorization, access control, routing, and load balancing.

[0076] The common API gateway 406 comprises one or more modules, such as the CAPIF 406a, an Access Management System (AMS) 406b, an Identity and Access Management (IAM) 406d and an Elastic Load Balancer (ELB) 406c. The CAPIF 406a module is a complete 3rd Generation Partnership Project (3GPP) API framework that covers functionality related to monitoring the health of at least one of, the persistent database 422a and the cache 422b. In one embodiment, the persistent database 422a and the cache 422b are referred to the one or more databases 110 in the invention which are communicably couple to the CAPIF 406a. The CAPIF 406a also deals with security and authorization of the persistent database 422a and the cache 422b when the API consumer 402 requests for accessing data from the at least one of, the persistent database 422a and the cache 422b. The CAPIF 406a is referred to as the monitoring unit 218 in the invention which monitors the persistent database 422a and the cache 422b in the pre-defined time intervals. In particular, the CAPIF 406a is a common API gateway for API consumer 402, and the API providers 408. The CAPIF 406a also deals with security and authorization of the APIs. The AMS 406b module outsources the task of providing ongoing support for applications to an external provider that specializes in this type of maintenance and monitoring. The AMS 406b performs access control policy check and enrichment of the API call. The IAM 406d module is used for authentication and authorization of a third-party consumers. The ELB 406c module automatically distributes incoming traffic pertaining to API calls across multiple targets and virtual appliances in one or more availability zones.

[0077] In one embodiment, the plurality of API Providers 408 is an application that hosts the APIs and uses CAPIF 406a to expose their APIs. Similar to the API consumer 402, the API publisher 410 comprises an API developer, an API playground, and an enterprise architecture. Further, the API publisher 410 comprises a subscription engine 412 which manages the user subscriptions, billing and quota enforcement and a marketplace engine 414 which serves as a platform for listing APIs, allowing consumers to discover, evaluate, and subscribe to APIs.

[0078] In one embodiment, the analyser 416 acts as the detection unit 212 in order to detect one or more issues pertaining to at least one of, the persistent database 422a and the cache 422b. In one embodiment, the analyser 416 may utilize the Artificial Intelligence/Machine Learning (AI/ML) decisions to detect one or more issues. In one embodiment, the one Cache 420 is a unified data cache/data store to store details pertaining to the detected one or more issues in at least one of, the persistent database 422a and the cache 422b.

[0079] FIG. 5 is a signal flow diagram illustrating the flow for monitoring health of the one or more databases 110 in the network 106, according to one or more embodiments of the present disclosure.

[0080] At step 502, the user transmits the request to the system 108 via the UE 102 for monitoring health of the one or more databases 110 in the network 106.

[0081] At step 504, the system 108 captures the one or more health parameters of the one or more databases 110 based on the received request.

[0082] At step 506, the system 108 utilizes the captured one or more health parameters of the one or more databases 110 to generate the detailed report pertaining to the health status of the one or more databases 110 in the network 106.

[0083] At step 508, the system 108 detects the one or more issues pertaining to the one or more databases 110 utilizing the generated detailed report. Further, the system 108 generates the notification related to details of the detected one or more issues along with the one or more solutions for the detected one or more issues.

[0084] At step 510, the system 108 notifies the user regarding the details of the detected one or more issues along with the one or more solutions for resolving the detected one or more issues. [0085] FIG. 6 is a flow diagram of a method 600 for monitoring health of the one or more databases 110 in the network 106, according to one or more embodiments of the present invention. For the purpose of description, the method 600 is described with the embodiments as illustrated in FIG. 2 and should nowhere be construed as limiting the scope of the present disclosure.

[0086] At step 602, the method 600 includes the step of capturing the one or more health parameters of the one or more databases 110 in the network 106 based on monitoring the one or more databases 110 in pre-defined time intervals. In one embodiment, the extraction unit 208 captures the one or more health parameters of the one or more databases 110. For example, let us assume the network 106 includes 10 databases and the processor 202 monitors the 10 databases every day. While monitoring, the extraction unit 208 captures the one or more health parameters such as the link fluctuations or connectivity issues between 10 databases.

[0087] At step 604, the method 600 includes the step generating the detailed report pertaining to the health status of the one or more databases 110 based on the captured one or more health parameters. In one embodiment, the report generation unit 210 generates the detailed report pertaining to the health status of the one or more databases 110. For example, the details pertaining to the one or more health parameters such as the link fluctuations or connectivity issues between 10 databases are included in the generated report.

[0088] At step 606, the method 600 includes the step of detecting the one or more issues pertaining to the one or more databases 110 utilizing the generated detailed report. In one embodiment, the detection unit 212 detects the one or more issues pertaining to the one or more databases 110 by determining whether the one or more health parameters of the one or more databases are within the predefined threshold or exceeding the predefined threshold. In an embodiment, the pre-defined threshold is taken into consideration as ideal working condition of the one or more databases 110. [0089] For example, let us assume there are 10 databases in the network 106. The pre-defined threshold for the 10 databases is configured by the detection unit 212 in such a way that more than 7 databases among the 10 databases in the network 106 must be available or responsive. In order to detect the one or more issues pertaining to the one or more databases 110, the detection unit 212 compares the one or more health parameters of the 10 databases with the predefined thresholds. In one scenario, based on comparison, if the detection unit 212 determines that the 8 databases among the 10 databases in the network 106 are available or responsive then the steps from the step 602 is again repeated. In another scenario, based on comparison, if the detection unit 212 determines that 7 databases or less than 7 databases among the 10 databases in the network 106 are available or responsive then the detection unit 212 detects the one or more issues pertaining to link fluctuations or connectivity issues between the 10 databases.

[0090] Further, the detection unit 212 updates the details of the detected one or more issues in the Root Cause Analysis (RCA) manager 216. In one embodiment, subsequent to updating the one or more issues, the Root Cause Analysis (RCA) manager 216 checks for the at least one of, the one or more suggestions and the one or more solutions for the updated one or more issues based on the historical data. Herin the historical data pertains to the one or more suggestions/the one or more solutions for the one or more issues updated in the past.

[0091] For example, if the updated one or more issues are similar to one or more issues of the past, then the Root Cause Analysis (RCA) manager 216 provides at least one of, the one or more suggestions and the one or more solutions for the updated one or more issues similar to the one or more suggestions and the one or more solutions provided in the past. In particular, the Root Cause Analysis (RCA) manager 216 may consists of 3 solutions for one issue. Further, the Root Cause Analysis (RCA) manager 216 provides the notification pertaining to the details of the detected one or more issues along with the at least one of, but not limited to, the one or more suggestions and the one or more solutions for resolving the detected one or more issues. [0092] At step 608, the method 600 includes the step of transmitting the notification pertaining to details of the detected one or more issues along with one or more solutions for the detected one or more issues to the user. In one embodiment, the transceiver 214 transmits the notification pertaining to details of the detected one or more issues along with one or more solutions for the detected one or more issues to the user. Advantageously, due to the one or more solutions suggestions or solutions to the detected one or more issues, the users may resolve the detected one or more issues so that the performance of the one or more databases 110 are not degraded and the complete system 108 failure is avoided.

[0093] In yet another aspect of the present invention, a non-transitory computer- readable medium having stored thereon computer-readable instructions that, when executed by a processor 202. The processor 202 is configured to capture, one or more health parameters of the one or more databases 110 in the network 106 based on monitoring the one or more databases 110 in pre-defined time intervals. The processor 202 is further configured to generate, a detailed report pertaining to a health status of the one or more databases 110 based on the captured one or more health parameters. The processor 202 is further configured to detect, utilizing the generated detailed report, one or more issues pertaining to the one or more databases 110. The processor 202 is further configured to, transmit, a notification pertaining to details of the detected one or more issues along with one or more solutions for the detected one or more issues to a user.

[0094] A person of ordinary skill in the art will readily ascertain that the illustrated embodiments and steps in description and drawings (FIG.1-6) are set out to explain the exemplary embodiments shown, and it should be anticipated that ongoing technological development will change the manner in which particular functions are performed. These examples are presented herein for purposes of illustration, and not limitation. Further, the boundaries of the functional building blocks have been arbitrarily defined herein for the convenience of the description. Alternative boundaries can be defined so long as the specified functions and relationships thereof are appropriately performed. Alternatives (including equivalents, extensions, variations, deviations, etc., of those described herein) will be apparent to persons skilled in the relevant art(s) based on the teachings contained herein. Such alternatives fall within the scope and spirit of the disclosed embodiments.

[0095] The present disclosure provides technical advancements of proactive detection of the one or more issues relates to one or more databases. Better management of available one or more database nodes for efficient system utilization. Monitoring of resource utilization of one or more database nodes. Protection of the system from resource crunches. Thresholds can be defined, and configurable in runtime. Reduction in time consumption for detecting one or more issues. Suggestions and pattern creation for better performance, decision making based on behavior and performance of database. Providing notifications to the respective users regarding the detected one or more issues along with the suggestions and solutions for the detected one or more issues

[0096] The present invention offers multiple advantages over the prior art and the above listed are a few examples to emphasize on some of the advantageous features. The listed advantages are to be read in a non-limiting manner.

REFERENCE NUMERALS

[0097] Environment - 100;

[0098] User Equipment (UE) - 102;

[0099] Server - 104;

[00100] Network- 106;

[00101] System -108;

[00102] One or more databases - 110;

[00103] Processor - 202;

[00104] Memory - 204;

[00105] Storage unit - 206;

[00106] Extraction unit - 208;

[00107] Report Generation unit - 210;

[00108] Detection unit - 212;

[00109] Transceiver unit - 214;

[00110] RCA manager- 216;

[00111] Monitoring unit - 218 ;

[00112] Primary Processor - 302;

[00113] Memory - 304;

[00114] User Interface (UI) - 306;

[00115] API consumer - 402;

[00116] UI API Dashboard - 404;

[00117] Common API Gateway - 406;

[00118] API Provider - 408;

[00119] API Publisher - 410;

[00120] Subscription Engine - 412;

[00121] Market Place - 414;

[00122] One cache - 420;

[00123] Analyser - 416; [00124] Persistent database - 422a;

[00125] Cache - 422b.

Claims

CLAIMS We Claim:

1. A method (600) for monitoring health of one or more databases (110) in a network (106), the method (600) comprising the steps of: capturing, by one or more processors (202), one or more health parameters of the one or more databases (110) in the network (106) based on monitoring the one or more databases (110) in pre-defined time intervals; generating, by the one or more processors (202), a detailed report pertaining to a health status of the one or more databases (110) based on the captured one or more health parameters; detecting, by the one or more processors (202), utilizing the generated detailed report, one or more issues pertaining to the one or more databases (110); and transmitting, by the one or more processors (202), a notification pertaining to details of the detected one or more issues along with one or more solutions for the detected one or more issues to a user.

2. The method (600) as claimed in claim 1, wherein the one or more health parameters includes at least one of, overall status of a database cluster, connectivity fluctuation between an application and the one or more databases (110), connectivity fluctuation between the one or more databases (110) or between the application and the one or more databases (110), resource utilization by the one or more databases (110), an interface status, active connection counts, and a thread status.

3. The method (600) as claimed in claim 1, wherein the step of detecting, utilizing the generated detailed report, one or more issues pertaining to the one or more databases (110), includes the steps of: determining, by the one or more processors (202), whether the one or more health parameters of the one or more databases (110) are within a predefined threshold; comparing, by the one or more processors (202), the one or more health parameters of the one or more databases (110) with the predefined threshold; in response to determining, by the one or more processors (202), the one or more health parameters are within the predefined threshold based on the comparison, continuing monitoring, by the one or more processors (202), the one or more health parameters of the one or more databases (110) in the predefined time intervals; and in response to determining, by the one or more processors (202), the one or more health parameters reaching the predefined threshold or exceeding the predefined threshold based on the comparison, detecting, by the one or more processors (202), the one or more issues pertaining to the one or more databases (HO).

4. The method (600) as claimed in claim 3, wherein the predefined threshold is configured in real time by the one or more processors.

5. The method (600) as claimed in claim 1, wherein the details pertaining to the detected one or more issues are updated and stored in a Root Cause Analysis (RCA) manager (216).

6. The method as claimed in claim 5, wherein the RCA manager (216) further includes at least one of, the one or more solutions for the detected one or more issues.

7. The method as claimed in claiml, wherein the one or more processors (202) is configured to monitor the one or more databases (110) in the pre-defined time intervals.

. A system (108) for monitoring health of one or more databases (110) in a network (106), the system (108) comprising: an extraction unit (208), configured to capture, one or more health parameters of the one or more databases (110) in the network (106) based on monitoring the one or more databases (110) in pre-defined time intervals; a report generation unit (210), configured to, generate, a detailed report pertaining to a health status of the one or more databases (110) based on the captured one or more health parameters; a detection unit (212), configured to, detect, utilizing the generated detailed report, one or more issues pertaining to the one or more databases (110); and a transceiver (214), configured to, transmit, a notification pertaining to details of the detected one or more issues along with one or more solutions for the detected one or more issues to a user.

9. The system (108) as claimed in claim 8, wherein the one or more health parameters includes at least one of, overall status of a database cluster, connectivity fluctuation between an application and the one or more databases (110), connectivity fluctuation between the one or more databases (110) or between the application and the one or more databases (110), resource utilization by the one or more databases (110), an interface status, active connection counts, and a thread status.

10. The system (108) as claimed in claim 8, wherein the detection unit (212) detects, utilizing the generated detailed report, one or more issues pertaining to the one or more databases (110), by: determining, whether the one or more health parameters of the one or more databases (110) are within a predefined threshold; comparing, the one or more health parameters of the one or more databases (110) with the predefined threshold; in response to determining, the one or more health parameters are within the predefined threshold based on the comparison, continuing monitoring, the one or more health parameters of the one or more databases (110) in the predefined time intervals; and in response to determining, the one or more health parameters reaching the predefined threshold or exceeding the predefined threshold based on the comparison, detecting, the one or more issues pertaining to the one or more databases (110).

11. The system (108) as claimed in claim 10, wherein the predefined threshold is configured in real time by the detection unit (212).

12. The system (108) as claimed in claim 8, wherein the details pertaining to the detected one or more issues are updated and stored in a Root Cause Analysis (RCA) manager (216).

13. The system (108) as claimed in claim 12, wherein the RCA manager (216) further includes at least one of, the one or more solutions for the detected one or more issues.

14. The system (108) as claimed in claim 8, wherein a monitoring unit (218) is configured to monitor the one or more databases (110) in the pre-defined time intervals.

15. A User Equipment (UE) (102), comprising: one or more primary processors (302) communicatively coupled to one or more processors (202), the one or more primary processors (302) coupled with a memory (304), wherein said memory (304) stores instructions which when executed by the one or more primary processors (302) causes the UE (102) to: receive, the notification from the one or more processors (202) pertaining to the details of the detected one or more issues along with one or more solutions for the detected one or more issues; and wherein the one or more processors (202) is configured to perform the steps as claimed in claim 1.

16. A non-transitory computer-readable medium having stored thereon computer- readable instructions that, when executed by a processor (202), causes the processor (202) to: capture, one or more health parameters of the one or more databases (110) in the network (106) based on monitoring the one or more databases (110) in predefined time intervals; generate, a detailed report pertaining to a health status of the one or more databases (110) based on the captured one or more health parameters; detect, utilizing the generated detailed report, one or more issues pertaining to the one or more databases (110); and transmit, a notification pertaining to details of the detected one or more issues along with one or more solutions for the detected one or more issues to a user.