Sign In to Follow Application
View All Documents & Correspondence

Method And System For Monitoring Health Status Of Database Clusters

Abstract: The present disclosure relates to a method and a system for monitoring a health status of database clusters [202]. The disclosure encompasses retrieving performance parameters of database [208] based on execution of monitoring task; categorizing the performance parameters based on at least one of configuration attributes, component attributes, temporal attributes, and aggregation attributes; compiling set of the performance parameters based on the monitoring task; generating a report comprising at least the compiled set of performance parameters; and transmitting the generated report to a user interface (UI) [212]. [FIG. 3]

Get Free WhatsApp Updates!
Notices, Deadlines & Correspondence

Patent Information

Application #
Filing Date
12 September 2023
Publication Number
14/2025
Publication Type
INA
Invention Field
COMPUTER SCIENCE
Status
Email
Parent Application

Applicants

Jio Platforms Limited
Office - 101, Saffron, Nr. Centre Point, Panchwati 5 Rasta, Ambawadi, Ahmedabad - 380006, Gujarat, India.

Inventors

1. Aayush Bhatnagar
Reliance Corporate Park, Thane-Belapur Road, Ghansoli, Navi Mumbai, Maharashtra 400701, India.
2. Sumit Thakur
Reliance Corporate Park, Thane-Belapur Road, Ghansoli, Navi Mumbai, Maharashtra 400701, India.
3. Tejesh Dakhinkar
Reliance Corporate Park, Thane-Belapur Road, Ghansoli, Navi Mumbai, Maharashtra 400701, India.
4. Pritam Nath
Reliance Corporate Park, Thane-Belapur Road, Ghansoli, Navi Mumbai, Maharashtra 400701, India.
5. Puspesh Prakash
Reliance Corporate Park, Thane-Belapur Road, Ghansoli, Navi Mumbai, Maharashtra 400701, India.
6. Mohit Chaudhary
Reliance Corporate Park, Thane-Belapur Road, Ghansoli, Navi Mumbai, Maharashtra 400701, India.
7. Shivani Singh
Reliance Corporate Park, Thane-Belapur Road, Ghansoli, Navi Mumbai, Maharashtra 400701, India.

Specification

FORM 2
THE PATENTS ACT, 1970
(39 OF 1970)
&
THE PATENT RULES, 2003
COMPLETE SPECIFICATION
(See section 10 and rule 13)
“METHOD AND SYSTEM FOR MONITORING HEALTH STATUS OF DATABASE CLUSTERS”
We, Jio Platforms Limited, an Indian National, of Office - 101, Saffron, Nr. Centre Point, Panchwati 5 Rasta, Ambawadi, Ahmedabad - 380006, Gujarat, India.
The following specification particularly describes the invention and the manner in which it is to be performed.

METHOD AND SYSTEM FOR MONITORING HEALTH STATUS OF
DATABASE CLUSTERS
FIELD OF THE DISCLOSURE
[0001] Embodiments of the present disclosure generally relate to the field of network performance systems. More particularly, embodiments of the present disclosure relate to monitoring a health status of database clusters.
BACKGROUND
[0002] The following description of related art is intended to provide background information pertaining to the field of the disclosure. This section may include certain aspects of the art that may be related to various features of the present disclosure. However, it should be appreciated that this section be used only to enhance the understanding of the reader with respect to the present disclosure, and not as admissions of prior art.
[0003] Wireless communication technology has rapidly evolved over the past few decades, with each generation bringing significant improvements and advancements. The first generation of wireless communication technology was based on antilog technology and offered only voice services. However, with the advent of the second-generation (2G) technology, digital communication and data services became possible, and text messaging was introduced. The third generation (3G) technology marked the introduction of high-speed internet access, mobile video calling, and location-based services. The fourth generation (4G) technology revolutionized wireless communication with faster data speeds, better network coverage, and improved security. Currently, the fifth generation (5G) technology is being deployed, promising even faster data speeds, low latency, and the ability to

connect multiple devices simultaneously. With each generation, wireless communication technology has become more advanced, sophisticated, and capable of delivering more services to its users.
[0004] As the 5G ecosystem expands with an increasing user base, traditional monitoring systems may generate excessive alerts, overwhelming administrators and making it difficult to prioritize and respond to critical issues. Streamlined alerting helps focus on high-priority alerts, reducing noise and alert fatigue. Various database monitoring tools often come with their unique alerting mechanisms, which can create confusion and challenges in the effective management of alerts across the environment. Implementing centralized and streamlined alert and notification support simplifies the overall alert management process, making it more efficient.
[0005] There are many issues faced in the network system providing a database management interface wherein it allows users to monitor the health of all the databases and clusters into the network. Such as:
• System Performance Monitoring and Optimization: Identifying and addressing performance bottlenecks within 5G network clusters. Monitoring resource utilization and capacity planning. Optimizing application response times and user experiences.
• Troubleshooting and Issue Resolution: Detecting and diagnosing software errors and crashes. Investigating system crashes or unexpected behavior. Tracking down the root causes of technical issues.
• Security and Threat Detection: Detecting and responding to cybersecurity threats and breaches. Identifying unauthorized access or suspicious activities. Analyzing patterns to spot potential security vulnerabilities to increase the security of 5G network data.
• Business Decision-Making: Providing insights for informed business decisions. Tracking key performance indicators (KPIs) and business

metrics. Analyzing trends to identify opportunities for growth and improvement.
• DevOps and Continuous Improvement: Monitoring software deployments and changes. Analyzing logs to facilitate continuous integration and continuous delivery (CI/CD) processes. Improving development workflows based on performance and usage data.
[0006] Thus, there exists an imperative need in the art for monitoring the health of network databases based on historical reports, which the present disclosure aims to address.
[0007] Hence, in view of these and other existing limitations, there arises an imperative need to update the session management (SM) policy associated with the network to overcome the above-mentioned limitations by providing a method and system for updating a preconfigured session management (SM) policy associated with the network, which the present disclosure aims to address.
OBJECTS OF THE DISCLOSURE
[0008] This section is provided to introduce certain objects and aspects of the present invention in a simplified form that are further described below in the description. In order to overcome at least a few problems associated with the known solutions as provided in the previous section, an object of the present invention is to substantially reduce the limitations and drawbacks of the prior arts as described hereinabove.
[0009] Some of the objects of the present disclosure, which at least one embodiment disclosed herein satisfies are listed herein below.

[0010] It is an object of the present disclosure to provide a system and a method for monitoring the health of network databases based on historical reports.
[0011] It is another object of the present disclosure to provide a solution for early Issue Detection and Rapid Response.
[0012] It is yet another object of the present disclosure to provide a solution to enhanced Security and Threat Mitigation.
SUMMARY
[0013] This section is provided to introduce certain aspects of the present disclosure in a simplified form that are further described below in the detailed description. This summary is not intended to identify the key features or the scope of the claimed subject matter.
[0014] An aspect of the present disclosure may relate to a method for monitoring a health status of database clusters. The method comprises retrieving, by a transceiver unit, from a central repository, performance parameters of at least one database based on execution of a monitoring task. The performance parameters of the at least one database are stored in the central repository. The method further comprises categorizing, by a processing unit, the performance parameters based on at least one of configuration attributes, component attributes, temporal attributes, and aggregation attributes. The method further comprises compiling, by the processing unit, a set of the performance parameters based on the monitoring task. The set of the performance parameters is selected from the categorized performance parameters of the at least one database. The method further comprises generating, by the processing unit, a report comprising at least the compiled set of performance

parameters. The method further comprises transmitting, by the transceiver unit, the generated report to a user interface (UI).
[0015] In an exemplary aspect of the present disclosure, for the execution of the monitoring task, the method comprises receiving, from the UI, by the transceiver unit, a monitoring request. The monitoring request relates to generating the report of the performance parameters of the at least one database. The monitoring request comprises at least one of the configuration attributes, the component attributes, the temporal attributes, the aggregation attributes, and execution attributes. Further, for the execution of the monitoring task, the method comprises generating, by the processing unit, the monitoring task based on the received monitoring request. Furthermore, the method comprises executing, by an execution unit connected to the processing unit, the monitoring task.
[0016] In an exemplary aspect of the present disclosure, the method comprises determining, by the processing unit, a status of connection with the at least one database. The status can be one of successful connectivity, and unsuccessful connectivity. Also, the method further comprises transmitting, by the transceiver unit, the status to the UI.
[0017] In an exemplary aspect of the present disclosure, the execution attributes comprise a trigger event configured to cause execution of the monitoring task. The trigger event is generated according to one of a scheduled event, and a manual event. The scheduled event comprises at least one of a frequency in a time duration, and one or more particular instances when the trigger event is generated. The manual event comprises an input received from the UI.
[0018] In an exemplary aspect of the present disclosure, the configuration attributes relate to configurations of the at least one database, and the configuration attributes

are selected from a group consisting of network configuration, service configuration, node configuration, and combinations thereof.
[0019] In an exemplary aspect of the present disclosure, the component attributes
5 relate to one or more components of the at least one database, and the component
attributes are selected from a group consisting of processing components, memory components, storage components, connection components, and combinations thereof.
10 [0020] In an exemplary aspect of the present disclosure, the temporal attributes
relate to a time duration using which the performance parameters of the at least one database are compiled.
[0021] In an exemplary aspect of the present disclosure, the aggregation attributes
15 relate to an aggregation type using which the performance parameters of the at least
one database are compiled, and the aggregations attributes are selected from a group consisting of average value, minimum value, maximum value, sum value, mean value, standard deviation value, and combinations thereof.
20 [0022] In an exemplary aspect of the present disclosure, the at least one database
comprises a plurality of databases.
[0023] Another aspect of the present disclosure may relate to a system for
monitoring a health status of database clusters. The system comprises a transceiver
25 unit configured to retrieve, from a central repository, performance parameters of at
least one database based on execution of a monitoring task. The performance parameters of the at least one database are stored in the central repository. The system further comprises a processing unit configured to categorize the performance parameters based on at least one of configuration attributes,
7

component attributes, temporal attributes, and aggregation attributes. The
processing unit is further configured to compile a set of the performance parameters
based on the monitoring task. The set of the performance parameters is selected
from the categorized performance parameters of the at least one database. The
5 processing unit is further configured to generate a report comprising at least the
compiled set of performance parameters. The transceiver unit is further configured to transmit the generated report to a user interface (UI).
[0024] Another aspect of the present disclosure discloses a non-transitory
10 computer-readable storage medium storing instruction for monitoring a health
status of database clusters, the storage medium comprising executable code which, when executed by one or more units of a system, causes: a transceiver unit to retrieve, from a central repository, performance parameters of at least one database based on execution of a monitoring task. The performance parameters of the at least
15 one database are stored in the central repository. Further, the executable code
which, when executed, causes a processing unit to categorize the performance parameters based on at least one of configuration attributes, component attributes, temporal attributes, and aggregation attributes. Further, the executable code which, when executed, causes the processing unit to compile a set of the performance
20 parameters based on the monitoring task. The set of the performance parameters is
selected from the categorized performance parameters of the at least one database. Further, the executable code which, when executed, causes the processing unit to generate a report comprising at least the compiled set of performance parameters. Further, the executable code which, when executed, causes the transceiver unit to
25 transmit the generated report to a user interface (UI).
[0025] Yet another aspect of the present disclosure discloses a user equipment (UE)
comprising a processor, The processor of the UE is configured to retrieve, from a
central repository, performance parameters of at least one database based on
30 execution of a monitoring task. The performance parameters of the at least one
8

database are stored in the central repository. The processor is further configured to
categorize the performance parameters based on at least one of configuration
attributes, component attributes, temporal attributes, and aggregation attributes.
The processor is further configured to compile a set of the performance parameters
5 based on the monitoring task. The set of the performance parameters is selected
from the categorized performance parameters of the at least one database. The processor is further configured to generate a report comprising at least the compiled set of performance parameters. The processor is further configured to transmit the generated report to a user interface (UI). 10
DESCRIPTION OF DRAWINGS
[0026] The accompanying drawings, which are incorporated herein, and constitute a part of this disclosure, illustrate exemplary embodiments of the disclosed methods
15 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
20 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.
[0027] FIG. 1 illustrates an exemplary block diagram of a computing device upon
25 which the features of the present disclosure may be implemented, in accordance
with exemplary implementations of the present disclosure.
9

[0028] FIG. 2 illustrates an exemplary block diagram of a system for monitoring a health status of database clusters, in accordance with exemplary implementations of the present disclosure.
5 [0029] FIG. 3 illustrates an exemplary method flow diagram for monitoring the
health status of database clusters, in accordance with the exemplary embodiments of the present disclosure.
[0030] FIG. 4 illustrates an exemplary flow chart for configuring service to monitor
10 databases, in accordance with the exemplary embodiments of the present
disclosure.
[0031] FIG. 5 illustrates an exemplary flow chart for generating reports from user
interface (UI), in accordance with the exemplary embodiments of the present
15 disclosure.
[0032] FIG. 6 illustrates an exemplary flow chart for analyzing the report from the UI, in accordance with the exemplary embodiments of the present disclosure.
20 [0033] The foregoing shall be more apparent from the following more detailed
description of the disclosure.
DETAILED DESCRIPTION
25 [0034] In the following description, for the purposes of explanation, various
specific details are set forth in order to provide a thorough understanding of embodiments of the present disclosure. It will be apparent, however, that embodiments of the present disclosure may be practiced without these specific details. Several features described hereafter can each be used independently of one
10

another or with any combination of other features. An individual feature may not
address any of the problems discussed above or might address only some of the
problems discussed above. Some of the problems discussed above might not be
fully addressed by any of the features described herein. Example embodiments of
5 the present disclosure are described below, as illustrated in various drawings in
which like reference numerals refer to the same parts throughout the different drawings.
[0035] The ensuing description provides exemplary embodiments only, and is not
10 intended to limit the scope, applicability, or configuration of the disclosure. Rather,
the ensuing description of the exemplary embodiments will provide those skilled in
the art with an enabling description for implementing an exemplary embodiment.
It should be understood that various changes may be made in the function and
arrangement of elements without departing from the spirit and scope of the
15 disclosure as set forth.
[0036] It should be noted that the terms "mobile device", "user equipment", "user device", “communication device”, “device” and similar terms are used interchangeably for the purpose of describing the disclosure. These terms are not
20 intended to limit the scope of the disclosure or imply any specific functionality or
limitations on the described embodiments. The use of these terms is solely for convenience and clarity of description. The disclosure is not limited to any particular type of device or equipment, and it should be understood that other equivalent terms or variations thereof may be used interchangeably without
25 departing from the scope of the disclosure as defined herein.
[0037] Specific details are given in the following description to provide a thorough
understanding of the embodiments. However, it will be understood by one of
ordinary skill in the art that the embodiments may be practiced without these
30 specific details. For example, circuits, systems, networks, processes, and other
11

components may be shown as components in block diagram form in order not to obscure the embodiments in unnecessary detail. In other instances, well-known circuits, processes, algorithms, structures, and techniques may be shown without unnecessary detail in order to avoid obscuring the embodiments. 5
[0038] Also, it is noted that individual embodiments may be described as a process
which is depicted as a flowchart, a flow diagram, a data flow diagram, a structure
diagram, or a block diagram. Although a flowchart may describe the operations as
a sequential process, many of the operations can be performed in parallel or
10 concurrently. In addition, the order of the operations may be re-arranged. A process
is terminated when its operations are completed but could have additional steps not included in the figures.
[0039] The word “exemplary” and/or “demonstrative” is used herein to mean
15 serving as an example, instance, or illustration. For the avoidance of doubt, the
subject matter disclosed herein is not limited by such examples. In addition, any aspect or design described herein as “exemplary” and/or “demonstrative” is not necessarily to be construed as preferred or advantageous over other aspects or designs, nor is it meant to preclude equivalent exemplary structures and techniques
20 known to those of ordinary skill in the art. Furthermore, to the extent that the terms
“includes,” “has,” “contains,” and other similar words are used in either the detailed description or the claims, such terms are intended to be inclusive in a manner similar to the term “comprising” as an open transition word without precluding any additional or other elements.
25
[0040] Further, the user device and/or a system as described herein to implement technical features as disclosed in the present disclosure may also comprise a “processor” or “processing unit”, wherein processor refers to any logic circuitry for processing instructions. The processor may be a general-purpose processor, a
30 special purpose processor, a conventional processor, a digital signal processor, a
12

plurality of microprocessors, one or more microprocessors in association with a
Digital Signal Processor (DSP) core, a controller, a microcontroller, Application
Specific Integrated Circuits, Field Programmable Gate Array circuits, any other
type of integrated circuits, etc. The processor may perform signal coding data
5 processing, input/output processing, and/or any other functionality that enables the
working of the system according to the present disclosure. More specifically, the processor is a hardware processor.
[0041] As used herein “interface” or “user interface” refers to a shared boundary
10 across which two or more separate components of a system exchange information
or data. The interface may also refer to a set of rules or protocols that define communication or interaction of one or more modules or one or more units with each other, which also includes the methods, functions, or procedures that may be called.
15
[0042] As used herein the transceiver unit includes at least one receiver and at least one transmitter configured respectively for receiving and transmitting data, signals, information or a combination thereof between units/components within the system and/or connected with the system.
20
[0043] As discussed in the background section, the current known solutions have several shortcomings. The present disclosure aims to overcome the above-mentioned and other existing problems in this field of technology by providing a method and a system of monitoring a health status of database clusters.
25
[0044] Hereinafter, exemplary embodiments of the present disclosure will be described in detail with reference to the accompanying drawings so that those skilled in the art can easily carry out the present disclosure.
13

[0045] FIG. 1 illustrates an exemplary block diagram of the computing device
[100] upon which the features of the present disclosure may be implemented in
accordance with exemplary implementation of the present disclosure. In an
implementation, the computing device [100] (herein, also referred to as a computer
5 system [100]) may also implement a method [300] for monitoring a health status of
database clusters [202] utilising a system [200]. In another implementation, the
computing device [100] itself implements the method [300] for monitoring a health
status of database clusters [202] using one or more units configured within the
computing device [100], wherein said one or more units are capable of
10 implementing the features as disclosed in the present disclosure.
[0046] The computing device [100] may include a bus [102] or other communication mechanism for communicating information, and a hardware processor [104] coupled with bus [102] for processing information. The hardware
15 processor [104] may be, for example, a general-purpose microprocessor. The
computing device [100] may also include a main memory [106], such as a random-access memory (RAM), or other dynamic storage device, coupled to the bus [102] for storing information and instructions to be executed by the processor [104]. The main memory [106] also may be used for storing temporary variables or other
20 intermediate information during execution of the instructions to be executed by the
processor [104]. Such instructions, when stored in non-transitory storage media accessible to the processor [104], render the computing device [100] into a special-purpose machine that is customized to perform the operations specified in the instructions. The computing device [100] further includes a read only memory
25 (ROM) [108] or other static storage device coupled to the bus [102] for storing static
information and instructions for the processor [104].
[0047] A storage device [110], such as a magnetic disk, optical disk, or solid-state
drive is provided and coupled to the bus [102] for storing information and
30 instructions. The computing device [100] may be coupled via the bus [102] to a
14

display [112], such as a cathode ray tube (CRT), Liquid crystal Display (LCD),
Light Emitting Diode (LED) display, Organic LED (OLED) display, etc. for
displaying information to a computer user. An input device [114], including
alphanumeric and other keys, touch screen input means, etc. may be coupled to the
5 bus [102] for communicating information and command selections to the processor
[104]. Another type of user input device may be a cursor controller [116], such as
a mouse, a trackball, or cursor direction keys, for communicating direction
information and command selections to the processor [104], and for controlling
cursor movement on the display [112]. The input device typically has two degrees
10 of freedom in two axes, a first axis (e.g., x) and a second axis (e.g., y), that allow
the device to specify positions in a plane.
[0048] The computing device [100] may implement the techniques described herein using customized hard-wired logic, one or more ASICs or FPGAs, firmware
15 and/or program logic which in combination with the computing device [100] causes
or programs the computing device [100] to be a special-purpose machine. According to one implementation, the techniques herein are performed by the computing device [100] in response to the processor [104] executing one or more sequences of one or more instructions contained in the main memory [106]. Such
20 instructions may be read into the main memory [106] from another storage medium,
such as the storage device [110]. Execution of the sequences of instructions contained in the main memory [106] causes the processor [104] to perform the process steps described herein. In alternative implementations of the present disclosure, hard-wired circuitry may be used in place of or in combination with
25 software instructions.
[0049] The computing device [100] also may include a communication interface
[118] coupled to the bus [102]. The communication interface [118] provides a two-
way data communication coupling to a network link [120] that is connected to a
30 local network [122]. For example, the communication interface [118] may be an
15

integrated services digital network (ISDN) card, cable modem, satellite modem, or
a modem to provide a data communication connection to a corresponding type of
telephone line. As another example, the communication interface [118] may be a
local area network (LAN) card to provide a data communication connection to a
5 compatible LAN. Wireless links may also be implemented. In any such
implementation, the communication interface [118] sends and receives electrical, electromagnetic or optical signals that carry digital data streams representing various types of information.
10 [0050] The computing device [100] can send messages and receive data, including
program code, through the network(s), the network link [120] and the communication interface [118]. In the Internet example, a server [130] might transmit a requested code for an application program through the Internet [128], the ISP [126], the local network [122], the host [124] and the communication interface
15 [118]. The received code may be executed by the processor [104] as it is received,
and/or stored in the storage device [110], or other non-volatile storage for later execution.
[0051] The present disclosure is implemented by the system [200] (as shown in
20 FIG. 2). The system [200] may be implemented using the computing device [100]
(as shown in FIG. 1). In an implementation, the computing device [100] may be
connected to the system [200] to perform the present disclosure. Referring to FIG.
2, an exemplary block diagram of the system [200] for monitoring a health status
of database clusters [202], is shown, in accordance with the exemplary
25 implementations of the present disclosure. The system [200] comprises one or more
database clusters [202]; at least one transceiver unit [204], a central repository/
central data repository [206]; at least one database/ database service [208]
comprising the plurality of databases i.e., database clusters [202]; at least one
processing unit [210]; at least one user interface [212]; at least one execution unit
30 [214]; and at least one manager service [216]. Also, all of the components/ units of
16

the system [200] are assumed to be connected to each other unless otherwise
indicated below. As shown in the FIG. 2, all units shown within the system [200]
should also be assumed to be connected to each other. Also, in FIG. 2 only a few
units are shown, however, the system [200] may comprise multiple such units or
5 the system [200] may comprise any such number of said units, as required to
implement the features of the present disclosure. Further, in an implementation, the system [200] may be present in a user device/ equipment (may also referred herein as a UE) [201] represented by user A, user B and user C (as shown in FIG.1) to implement the features of the present disclosure. In an implementation of the
10 present disclosure, the user(s) A, B and C can have the at least one user interface
(UI) [212] on their respective UE [201]. The system [200] may be a part of the user device or may be independent of but in communication with the user device. In another implementation, the system [200] may reside in a server or a network entity. In yet another implementation, the system [200] may reside partly in the server/
15 network entity and partly in the user device.
[0052] The system [200] is configured for monitoring a health status of database clusters [202], with the help of the interconnection between the components/units of the system [200].
20
[0053] The transceiver unit [204] is configured to retrieve, from the central repository [206], performance parameters of at least one database [208] based on execution of a monitoring task. The performance parameters of the at least one database [208] are stored in the central repository [206]. The central repository
25 [206] may be a centralized location on a computer system/ server connected to a
communication network. The centralized repository [206] is responsible for storing, managing and maintaining the data of various performance parameters. The centralized repository [206] ensures consistent access to the performance parameters data by sharing across multiple components of the system [200]. The
30 performance parameters may include but not limited to query response time (time
17

take for executing queries in the database), latency (delay over the beginning of next transactions in the database queue), concurrency (handling multiple queries), and data integrity (accuracy and consistency of the data), and etc.
5 [0054] After storing the performance parameters in the centralized repository
[206], the processing unit [210] categorizes the performance parameters based on at least one of configuration attributes, component attributes, temporal attributes, and aggregation attributes. The categorizing here includes but is not limited to organizing the performance parameters data into specific groups or categories based
10 on a predefined criterion such as configuration, component, temporal and
aggregation etc. Thereafter, the processing unit [210] compiles a set of the performance parameters based on the monitoring task. The set of the performance parameters is selected from the categorized performance parameters of the at least one database [208]. The processing unit [210] then generates a report comprising at
15 least the compiled set of performance parameters. The set of performance
parameters refers to a shortlisted/ compiled set of parameters from the performance parameters upon which the report is to be generated. For e.g., components like connections related to CPU, memory and storage for specific duration of 2 hours for ‘X’ and ‘Y’ nodes of the network can be compiled for their aggregation
20 attributes like average value. This average value may indicate an ideal and
conducive value for health status of the at least one database [208].
[0055] Once the report is generated, the transceiver unit [204] transmits the generated report to the user interface (UI) [212]. 25
[0056] In an implementation of the present disclosure, the report can be generated by the user manually or by means of automation at the UI [212].
18

[0057] In an exemplary aspect of the present disclosure, for executing the
monitoring task, the transceiver unit [204] receives, from the UI [212], a monitoring
request. The monitoring request relates to generating the report of the performance
parameters of the at least one database [208]. The monitoring request comprises at
5 least one of the configuration attributes, the component attributes, the temporal
attributes, the aggregation attributes, and execution attributes. Thereafter for execution of the monitoring task, the processing unit [210] generates the monitoring task based on the received monitoring request. Then, the execution unit [214] executes the monitoring task.
10
[0058] In an exemplary aspect of the present disclosure, the processing unit [210] determines a status of connection with the at least one database [208]. The status here refers to one of successful connectivity, and unsuccessful connectivity. The transceiver unit [204] transmits the status to the UI [212].
15
[0059] In an exemplary aspect of the present disclosure, the execution attributes comprise a trigger event that causes execution of the monitoring task. The trigger event is generated according to one of a scheduled event, and a manual event. The scheduled event comprises at least one of a frequency in a time duration, and one
20 or more particular instances when the trigger event is generated. For example, the
scheduled event may be once every six hours, or once every 24 hours, or twice, every 24 hours, etc. In another example, the particular instances of the scheduled event may be on a particular date in a month. The manual event comprises an input received from the UI [212].
25
[0060] In an exemplary aspect of the present disclosure, the configuration attributes relate to configurations of the at least one database [208], and the configuration attributes are selected from a group consisting of network configuration, service configuration, node configuration, and combinations thereof. Meaning thereby, the
30 configuration attributes generally define how components like network, system and
19

node operate. The configuration is indicative of intending the determination of the behavior, functionality and performance of the at least one database [208].
[0061] In an exemplary aspect of the present disclosure, the component attributes
5 relate to one or more components of the at least one database [208], and the
component attributes are selected from a group consisting of processing components, memory components, storage components, connection components, and combinations thereof.
10 [0062] In an exemplary aspect of the present disclosure, the temporal attributes
relate to a time duration using which the performance parameters of the at least one database [208] are compiled. Thus, the temporal attributes are responsible for tracking time-related information such as but not limited to valid time of transaction and querying of the at least one database [208], thereby allowing access to historical
15 tracked records.
[0063] In an exemplary aspect of the present disclosure, the aggregation attributes
relate to an aggregation type using which the performance parameters of the at least
one database [208] are compiled, and the aggregation attributes are selected from a
20 group consisting of average value, minimum value, maximum value, sum value,
mean value, standard deviation value, and combinations thereof.
[0064] In an exemplary aspect of the present disclosure, the at least one database [208] comprises a plurality of databases.
25
[0065] While the present disclosure relates to functionalities provided for a 4G
and/or 5G telecommunication network, it may be appreciated by a person skilled in
the art that the elements of the present disclosure may also relate to other
telecommunication networks, such as 6G, and that such applications may be
30 construed to be within the scope of the present disclosure.
20

[0066] Referring to FIG. 3, an exemplary method flow diagram [300] for
monitoring a health status of database clusters [202], in accordance with exemplary
implementations of the present disclosure is shown. In an implementation the
5 method [300] is performed by the system [200]. Also, as shown in FIG. 3, the
method [300] starts at step [302].
[0067] At step [304], the method [300] comprises retrieving, by a transceiver unit [204], from a central repository [206], performance parameters of at least one
10 database [208] based on execution of a monitoring task. The performance
parameters of the at least one database [208] are stored in the central repository [206]. The central repository [206] may be a centralized location on a computer system/ server connected to a communication network. The centralized repository [206] is responsible for storing, managing and maintaining the data of various
15 performance parameters. The centralized repository [206] ensures consistent access
to the performance parameters data by sharing across multiple components of the system [200]. The performance parameters may include but not limited to query response time (time take for executing queries in the database), latency (delay over the beginning of next transactions in the database queue), concurrency (handling
20 multiple queries), and data integrity (accuracy and consistency of the data), and etc.
[0068] At step [306], the method [300] comprises categorizing, by a processing unit
[210], the performance parameters based on at least one of configuration attributes,
component attributes, temporal attributes, and aggregation attributes. The
25 categorizing here includes but is not limited to organizing the performance
parameters data into specific groups or categories based on a predefined criterion such as configuration, component, temporal and aggregation etc.
[0069] In an exemplary aspect of the present disclosure, the configuration attributes
30 relate to configurations of the at least one database [208], and the configuration
21

attributes are selected from a group consisting of network configuration, service
configuration, node configuration, and combinations thereof. Meaning thereby, the
configuration attributes generally define how components like network, system and
node operate. The configuration is indicative of intending the determination of the
5 behavior, functionality and performance of the at least one database [208].
[0070] In an exemplary aspect of the present disclosure, the component attributes
relate to one or more components of the at least one database [208], and the
component attributes are selected from a group consisting of processing
10 components, memory components, storage components, connection components,
and combinations thereof.
[0071] In an exemplary aspect of the present disclosure, the temporal attributes
relate to a time duration using which the performance parameters of the at least one
15 database [208] are compiled. Thus, the temporal attributes are responsible for
tracking time-related information such as but not limited to valid time of transaction and querying of the at least one database [208], thereby allowing access to historical tracked records.
20 [0072] In an exemplary aspect of the present disclosure, the aggregation attributes
relate to an aggregation type using which the performance parameters of the at least one database [208] are compiled, and the aggregations attributes are selected from a group consisting of average value, minimum value, maximum value, sum value, mean value, standard deviation value, and combinations thereof.
25
[0073] At step [308], the method [300] comprises compiling, by the processing unit [210], a set of the performance parameters based on the monitoring task. The set of the performance parameters is selected from the categorized performance parameters of the at least one database [208]. The set of performance parameters
22

refers to a shortlisted/ compiled set of parameters from the performance parameters
upon which the report is to be generated. For e.g., components like connections
related to CPU, memory and storage for specific duration of 2 hours for ‘X’ and
‘Y’ nodes of the network can be compiled for their aggregation attributes like
5 average value. This average value may indicate an ideal and conducive value for
health status of the at least one database [208].
[0074] At step [310], the method [300] comprises generating, by the processing unit [210], a report comprising at least the compiled set of performance parameters. 10
[0075] At step [312], the method [300] comprises transmitting, by the transceiver unit [204], the generated report to a user interface (UI) [212].
[0076] In an implementation of the present disclosure, the report can be generated
15 by the user manually or by means of automation at the UI [212].
[0077] In an exemplary aspect of the present disclosure, for the execution of the monitoring task, the method [300] comprises receiving, from the UI [212], by the transceiver unit [204], a monitoring request. The monitoring request relates to
20 generating the report of the performance parameters of the at least one database
[208]. The monitoring request comprises at least one of the configuration attributes, the component attributes, the temporal attributes, the aggregation attributes, and execution attributes. Further, for the execution of the monitoring task, the method [300] comprises generating, by the processing unit [210], the monitoring task based
25 on the received monitoring request. Furthermore, the method [300] comprises
executing, by an execution unit [214] connected to the processing unit [210], the monitoring task.
23

[0078] In an exemplary aspect of the present disclosure, the method [300]
comprises determining, by the processing unit [210], a status of connection with the
at least one database [208]. The status can be one of successful connectivity, and
unsuccessful connectivity. Also, the method [300] further comprises transmitting,
5 by the transceiver unit [204], the status to the UI [212].
[0079] In an exemplary aspect of the present disclosure, the execution attributes
comprise a trigger event configured to cause execution of the monitoring task. The
trigger event is generated according to one of a scheduled event, and a manual event
10 i.e.., in other words, the monitoring task can be used to generate the report by the
user manually or by means of automation via the UI [212].
[0080] The scheduled event comprises at least one of a frequency in a time
duration, and one or more particular instances when the trigger event is generated.
15 The manual event comprises an input received from the UI [212].
[0081] In an exemplary aspect of the present disclosure, the at least one database [208] comprises a plurality of databases.
20 [0082] Thereafter, the method [300] terminates at step [314].
[0083] Referring to FIG. 4, an exemplary flow chart [400] for configuring service to monitor database/ database service [208] is shown in accordance with the present disclosure.
25
[0084] The flow chart [400] is performed in the following manner:
Step 1: At the system [200] (as shown in FIG. 2), the routine for configuring the application for executing monitoring database/ database service [208] (as
24

shown in FIG. 2) is executed. At the time of configuring, a public interval is specified for collecting database performance details.
Step 2: In order to monitor the database [208], an attempt to create a
5 connection with its corresponding database cluster [202] (as shown in FIG.
2) is executed. If the connection is established, then step 3 is executed. If the
connection is not established, step 21 is executed which involves checking of
the configuration of the database cluster [202] for performing retry for
connection again. Thereafter, the checking the connection being established
10 takes place again. If the connection is established, step 3 is executed. If the
connection is still not established, then step 23 is executed which entails that error occurred and a log of the error is generated and supplied to the system [200].
15 Step 3: A job is configured to generate the report in the public interval. This
job is given the task of monitoring. A monitoring rule is configured to run on as per the public interval to check the database performance. The application configured at step 1 runs the job after the public interval.
20 Step 4: Thereafter, performance details of the database clusters [202] are
retrieved from a central repository [206] (as shown in FIG. 2) on execution of the job.
Step 5: A data containing the performance details is then normalized into a
25 unified and integrated format for making a report of health status of the
database clusters [202] on the basis of the unified performance details of the database clusters [202].
Step 6: The report is then sent to the user after execution of the step 5.
25

[0085] Referring to FIG. 5, an exemplary flow chart [500] for generating reports from user interface (UI) [212] is shown in accordance with the present disclosure.
5 [0086] The flow chart [500] is performed in the following manner:
Step 1: A user sends the request to system [200] (as shown in FIG. 2) for generation of the report from the user interface (UI) [212] in order to monitor database [208].
10 Step 2: The system [200] checks if the database [208] is available or not. If
the database service [208] is not available, then step 21 gets executed by sending service unavailable responsea. Thereafter, step 22 is executed when the system [200] sends the error logs to the user. If the database service [208] is available, step 3 is executed.
15
Step 3: The system [200] retrieves the performance data for the database service [208] from the centralized repository [206].
Step 4: After the performance data retrieval, the system [200] prepares the
20 report from the retrieved data based on user requirement.
Step 5: Upon generation of the report, the system [200] sends the report to the user via user interface (UI) [212].
25 [0087] Referring to FIG. 6, an exemplary flow chart [600] for analyzing the report
from the UI [212] is shown in accordance with the present disclosure.
[0088] The flow chart [600] is performed in the following manner:
26

Step 1: A user sends the request to analyze the logs from user interface (UI) [212] (as shown in FIG. 2).
Step 2: Upon receipt of the request for analyzing the logs, the user is
5 connected to a specified database service [208] (as shown in FIG.2).
Step 3: Thereafter, the logs are fetched from the system [200] as per the user requirement.
10 Step 4: In the last step, the fetched logs are returned to the user and displayed
on the UI [212].
[0089] The present disclosure further discloses a non-transitory computer-readable storage medium storing instruction for monitoring a health status of database
15 clusters [202], the storage medium comprising executable code which, when
executed by one or more units of a system [200], causes a transceiver unit [204] to retrieve, from a central repository [206], performance parameters of at least one database [208] based on execution of a monitoring task. The performance parameters of the at least one database [208] are stored in the central repository
20 [206]. Further, the executable code which, when executed, causes a processing unit
[210] to categorize the performance parameters based on at least one of configuration attributes, component attributes, temporal attributes, and aggregation attributes. Further, the executable code which, when executed, causes the processing unit [210] to compile a set of the performance parameters based on the
25 monitoring task. The set of the performance parameters is selected from the
categorized performance parameters of the at least one database [208]. Further, the executable code which, when executed, causes the processing unit [210] to generate a report comprising at least the compiled set of performance parameters. Further,
27

the executable code which, when executed, causes the transceiver unit [204] to transmit the generated report to a user interface (UI) [212].
[0090] The present disclosure also discloses a user equipment (UE) [201]
5 comprising a processor [2012], The processor [2012] of the UE [201] is configured
to retrieve, from a central repository [206], performance parameters of at least one database [208] based on execution of a monitoring task. The performance parameters of the at least one database [208] are stored in the central repository [206]. The processor [2012] is further configured to categorize the performance
10 parameters based on at least one of configuration attributes, component attributes,
temporal attributes, and aggregation attributes. The processor [2012] is further configured to compile a set of the performance parameters based on the monitoring task. The set of the performance parameters is selected from the categorized performance parameters of the at least one database [208]. The processor [2012] is
15 further configured to generate a report comprising at least the compiled set of
performance parameters. The processor [2012] is further configured to transmit the generated report to a user interface (UI) [212].
[0091] Further, in accordance with the present disclosure, it is to be acknowledged
20 that the functionality described for the various components/units can be
implemented interchangeably. While specific embodiments may disclose a
particular functionality of these units for clarity, it is recognized that various
configurations and combinations thereof are within the scope of the disclosure. The
functionality of specific units as disclosed in the disclosure should not be construed
25 as limiting the scope of the present disclosure. Consequently, alternative
arrangements and substitutions of units, provided they achieve the intended functionality described herein, are considered to be encompassed within the scope of the present disclosure.
28

[0092] As is evident from the above, the present disclosure provides a technically
advanced solution for monitoring health status of database clusters [202]. This
monitoring is performed based on historical reports. The present disclosure
encompasses many advantages, some of which are mentioned herein:
5 1. Early Issue Detection and Rapid Response: It refers to the practice of
identifying problems or potential issues as soon as they arise and taking
swift action to address them before they escalate into larger, more complex
challenges. As 5G adoption grows and the trials of 6G are in process, the
goal is to proactively manage and mitigate risks while minimizing the
10 negative impact on the overall system.
2. Compliance and regulatory adherence: It refers to the process of ensuring
that individuals, organizations, or systems adhere to relevant laws,
regulations, standards, and guidelines that apply to their specific industry or
context. It involves generating audit trails and documentation of activities
15 for regulatory purposes.
3. Enhanced Security and Threat Mitigation: It is a critical component of
safeguarding individuals, organizations, systems, and assets against various
types of threats, risks, and vulnerabilities. In 5G system, these efforts
involve detecting and responding to security breaches, unauthorized access,
20 and suspicious activities, and analysis of logs of application to identify
patterns indicative of cyberattacks or data breaches.
4. Incident Reconstruction and Forensic Analysis: It is processes used to
understand and reconstruct events that have occurred, particularly in
situations involving crimes, cybersecurity breaches, or other significant
25 incidents. These processes involves gathering and analyzing evidence to
piece together a detailed and accurate account of what happened.
5. User Behaviour Analysis and User Experience Enhancement: These
interconnected concepts play a significant role in understanding and
optimizing user interactions with products, services, applications.
30
29

[0093] While considerable emphasis has been placed herein on the disclosed
implementations, it will be appreciated that many implementations can be made and
that many changes can be made to the implementations without departing from the
principles of the present disclosure. These and other changes in the implementations
5 of the present disclosure will be apparent to those skilled in the art, whereby it is to
be understood that the foregoing descriptive matter to be implemented is illustrative and non-limiting.
30

We Claim:
1. A method [300] for monitoring a health status of database clusters [202], the
method [300] comprising:
- retrieving, by a transceiver unit [204], from a central repository [206], performance parameters of at least one database [208] based on execution of a monitoring task, wherein the performance parameters of the at least one database [208] are stored in the central repository [206];
- categorizing, by a processing unit [210] connected to the transceiver unit [204], the performance parameters based on at least one of configuration attributes, component attributes, temporal attributes, and aggregation attributes;
- compiling, by the processing unit [210], a set of the performance parameters based on the monitoring task, wherein the set of the performance parameters is selected from the categorized performance parameters of the at least one database [208];
- generating, by the processing unit [210], a report comprising at least the compiled set of performance parameters; and
- transmitting, by the transceiver unit [204], the generated report to a user interface (UI) [212].
2. The method [300] as claimed in claim 1, wherein execution of the monitoring
task comprises:
- receiving, from the UI [212], by the transceiver unit [204], a monitoring
request, wherein the monitoring request relates to generating the report of
the performance parameters of the at least one database [208], and wherein
the monitoring request comprises at least one of the configuration attributes,
the component attributes, the temporal attributes, the aggregation attributes,
and execution attributes;

- generating, by the processing unit [210], the monitoring task based on the received monitoring request; and
- executing, by an execution unit [214] connected to the processing unit [210], the monitoring task.
3. The method [300] as claimed in claim 2, wherein the method [300] comprises:
- determining, by the processing unit [210], a status of connection with the at least one database [208], wherein the status is one of successful connectivity, and unsuccessful connectivity; and
- transmitting, by the transceiver unit [204], the status to the UI [212].
4. The method [300] as claimed in claim 2, wherein the execution attributes
comprise a trigger event configured to cause execution of the monitoring task,
wherein the trigger event is generated according to one of a scheduled event,
and a manual event, and wherein,
- the scheduled event comprises at least one of a frequency in a time duration, and one or more particular instances when the trigger event is generated, and
- the manual event comprises an input received from the UI [212].

5. The method [300] as claimed in claim 1, wherein the configuration attributes relate to configurations of the at least one database [208], and the configuration attributes are selected from a group consisting of network configuration, service configuration, node configuration, and combinations thereof.
6. The method [300] as claimed in claim 1, wherein the component attributes relate to one or more components of the at least one database [208], and the component attributes are selected from a group consisting of processing

components, memory components, storage components, connection components, and combinations thereof.
7. The method [300] as claimed in claim 1, wherein the temporal attributes relate to a time duration using which the performance parameters of the at least one database [208] are compiled.
8. The method [300] as claimed in claim 1, wherein the aggregation attributes relate to an aggregation type using which the performance parameters of the at least one database [208] are compiled, and the aggregations attributes are selected from a group consisting of average value, minimum value, maximum value, sum value, mean value, standard deviation value, and combinations thereof.
9. The method [300] as claimed in 1, wherein the at least one database [208] comprises a plurality of databases.
10. A system [200] for monitoring a health status of database clusters [202], the system [200] comprising:
- a transceiver unit [204] configured to retrieve, from a central repository [206], performance parameters of at least one database [208] based on execution of a monitoring task, wherein the performance parameters of the at least one database [208] are stored in the central repository [206];
- a processing unit [210] connected to the transceiver unit [204], the processing unit [210] configured to:
categorize the performance parameters based on at least one of configuration attributes, component attributes, temporal attributes, and aggregation attributes;

compile a set of the performance parameters based on the monitoring task, wherein the set of the performance parameters is selected from the categorized performance parameters of the at least one database [208]; and
generate a report comprising at least the compiled set of performance parameters; and
- the transceiver unit [204] configured to transmit the generated report to a
user interface (UI) [212].
11. The system [200] as claimed in claim 10, wherein to execute the monitoring
task:
- the transceiver unit [204] is configured to receive, from the UI [212], a monitoring request, wherein the monitoring request relates to generating the report of the performance parameters of the at least one database [208], and wherein the monitoring request comprises at least one of the configuration attributes, the component attributes, the temporal attributes, the aggregation attributes, and execution attributes;
- the processing unit [210] is configured to generate the monitoring task based on the received monitoring request; and
- an execution unit [214] connected to the processing unit [210], the execution unit configured to execute the monitoring task.
12. The system [200] as claimed in claim 11, wherein:
- the processing unit [210] is configured to determine a status of connection with the at least one database [208], wherein the status is one of successful connectivity, and unsuccessful connectivity; and
- the transceiver unit [204] is configured to transmit the status to the UI [212].
13. The system [200] as claimed in claim 11, wherein the execution attributes
comprise a trigger event configured to cause execution of the monitoring task,

wherein the trigger event is generated according to one of a scheduled event, and a manual event, and wherein,
- the scheduled event comprises at least one of a frequency in a time duration, and one or more particular instances when the trigger event is generated, and
- the manual event comprises an input received from the UI [212].

14. The system [200] as claimed in claim 10, wherein the configuration attributes relate to configurations of the at least one database [208], and the configuration attributes are selected from a group consisting of network configuration, service configuration, node configuration, and combinations thereof.
15. The system [200] as claimed in claim 10, wherein the component attributes relate to one or more components of the at least one database [208], and the component attributes are selected from a group consisting of processing components, memory components, storage components, connection components, and combinations thereof.
16. The system [200] as claimed in claim 10, wherein the temporal attributes relate to a time duration using which the performance parameters of the at least one database [208] are compiled.
17. The system [200] as claimed in claim 10, wherein the aggregation attributes relate to an aggregation type using which the performance parameters of the at least one database [208] are compiled, and the aggregation attributes are selected from a group consisting of average value, minimum value, maximum value, sum value, mean value, standard deviation value, and combinations thereof.

18. The system [200] as claimed in claim 10, wherein the at least one database [208] comprises a plurality of databases.
19. A user equipment (UE) [201] comprising a processor [2012], the processor [2012] configured to:

- retrieve, from a central repository [206], performance parameters of at least one database [208] based on execution of a monitoring task, wherein the performance parameters of the at least one database [208] are stored in the central repository [206];
- categorize the performance parameters based on at least one of configuration attributes, component attributes, temporal attributes, and aggregation attributes;
- compile a set of the performance parameters based on the monitoring task, wherein the set of the performance parameters is selected from the categorized performance parameters of the at least one database [208];
- generate a report comprising at least the compiled set of performance parameters; and
- transmit the generated report to a user interface (UI) [212].

Documents

Application Documents

# Name Date
1 202321061431-STATEMENT OF UNDERTAKING (FORM 3) [12-09-2023(online)].pdf 2023-09-12
2 202321061431-PROVISIONAL SPECIFICATION [12-09-2023(online)].pdf 2023-09-12
3 202321061431-POWER OF AUTHORITY [12-09-2023(online)].pdf 2023-09-12
4 202321061431-FORM 1 [12-09-2023(online)].pdf 2023-09-12
5 202321061431-FIGURE OF ABSTRACT [12-09-2023(online)].pdf 2023-09-12
6 202321061431-DRAWINGS [12-09-2023(online)].pdf 2023-09-12
7 202321061431-Proof of Right [03-01-2024(online)].pdf 2024-01-03
8 202321061431-FORM-5 [11-09-2024(online)].pdf 2024-09-11
9 202321061431-ENDORSEMENT BY INVENTORS [11-09-2024(online)].pdf 2024-09-11
10 202321061431-DRAWING [11-09-2024(online)].pdf 2024-09-11
11 202321061431-CORRESPONDENCE-OTHERS [11-09-2024(online)].pdf 2024-09-11
12 202321061431-COMPLETE SPECIFICATION [11-09-2024(online)].pdf 2024-09-11
13 202321061431-Request Letter-Correspondence [18-09-2024(online)].pdf 2024-09-18
14 202321061431-Power of Attorney [18-09-2024(online)].pdf 2024-09-18
15 202321061431-Form 1 (Submitted on date of filing) [18-09-2024(online)].pdf 2024-09-18
16 202321061431-Covering Letter [18-09-2024(online)].pdf 2024-09-18
17 202321061431-CERTIFIED COPIES TRANSMISSION TO IB [18-09-2024(online)].pdf 2024-09-18
18 Abstract 1.jpg 2024-10-04
19 202321061431-FORM 3 [07-10-2024(online)].pdf 2024-10-07
20 202321061431-ORIGINAL UR 6(1A) FORM 1 & 26-200125.pdf 2025-01-24