DESC: FORM 2
THE PATENTS ACT, 1970
(39 of 1970)
&
THE PATENTS RULES, 2003
COMPLETE SPECIFICATION
(See section 10 and rule 13)
1. TITLE OF THE INVENTION
SYSTEM AND METHOD FOR VALIDATING AND EXECUTING ONE OR MORE QUERIES
2. APPLICANT(S)
NAME NATIONALITY ADDRESS
JIO PLATFORMS LIMITED INDIAN OFFICE-101, SAFFRON, NR. CENTRE POINT, PANCHWATI 5 RASTA, AMBAWADI, AHMEDABAD 380006, GUJARAT, INDIA
3.PREAMBLE TO THE DESCRIPTION
THE FOLLOWING SPECIFICATION PARTICULARLY DESCRIBES THE NATURE OF THIS INVENTION AND THE MANNER IN WHICH IT IS TO BE PERFORMED.

FIELD OF THE INVENTION
[0001] The present invention generally relates to wireless communications, and more particularly relates to a system and a method for validating and executing one or more queries.
BACKGROUND OF THE INVENTION
[0002] Root Cause Analysis (RCA) involves analyzing various queries and their associated data to determine the primary cause of a failure or an issue. The effectiveness of RCA heavily relies on the accuracy and validity of the queries being analyzed. Therefore, it is essential to ensure that the queries received by a server are thoroughly validated to eliminate errors, inconsistencies, and irrelevant data.
[0003] Existing query validation techniques in servers primarily focus on basic syntax, format, and validity checks. These techniques verify the structure of the queries and ensure that they conform to the expected patterns and standards. However, they often lack the ability to perform comprehensive validation tailored specifically for RCA purposes.
[0004] Therefore, there is a need for an improved query validation and execution technique that is specifically configured for performing RCA in the servers. This technique should be capable of not only verifying the syntax and structure of queries configured for future requirements but also analyzing the content, context, and relevance of the data contained within the queries.
SUMMARY OF THE INVENTION
[0005] One or more embodiments of the present disclosure provide a system and method for validating and executing one or more queries.
[0006] In one aspect of the present invention, the method for validating and executing one or more queries is disclosed. The method includes the steps of receiving at a user interface, one or more inputs from a user. The one or more inputs pertain to selecting at least one query by the user among the one or more queries. The method further includes, validating, the selected at least one query received from the user. The method further includes executing the selected at least one query subsequent to the validation. The method further includes notifying, the user related to the execution of the selected at least one query.
[0007] In an embodiment, the selected at least one query is validated based on the one or more validation parameters.
[0008] In an embodiment, the one or more validation parameters include at least one of, one or more query headers, query syntax, query identifiers, failure metrics and severity level.
[0009] In an embodiment, the validation of the selected at least one query is performed by checking, if the selected at least one query is of a format compatible with respect to the one or more validation parameters.
[0010] In an embodiment, executing the selected at least one query received from the user includes the steps of: retrieving, the selected at least one query from the database based on receiving an execution request from the user. Further, step includes, extracting, information pertaining to one or more parameters customized by the user which are related to the at least one selected query. Thereafter, the step includes, fetching, one or more correlation logics from at least one of, a caching layer or a database. Thereafter, the step includes, identifying, corresponding data related to the selected at least one query from the database based on the customized one or more parameters which are extracted from the selected at least one query. Further, the step includes, applying, the one or more correlation logics to the identified corresponding data, and generating, one or more outputs based on the applied one or more correlation logics to the corresponding data.
[0011] In an embodiment, the one or more parameters which are customized by the user include at least one of, specific tag to identify the one or more queries, user defined time range to execute the one or more queries.
[0012] In an embodiment, upon validation and execution of the selected at least one query, the validated one or more queries are stored in a database for future use and to perform root cause analysis in order to determine one or more issues in a network element.
[0013] In another aspect of the present invention, a system for validating and executing one or more queries is disclosed. The system includes a user interface, configured to receive one or more inputs from a user, the one or more inputs pertain to selecting at least one query by the user among the one or more queries. Further, a validation unit is configured to validate, the selected at least one query received from the user. Further, an execution unit is configured to execute, the selected at least one query subsequent to validation. A notification unit is configured to notify, the user related to the execution of the selected at least one query.
[0014] In another aspect of the invention, a User Equipment (UE) is provided. The UE comprising one or more primary processors communicatively coupled to one or more processors, the one or more primary processors coupled with a memory, wherein said memory stores instructions which when executed by the one or more primary processors causes the UE to, transmit the selected at least one query with customized one or more parameters to the one or more processors to validate the selected at least one query among the one or more queries.
[0015] In another aspect of the invention, a non-transitory computer-readable medium having stored thereon computer-readable instructions is disclosed. The computer-readable instructions that when executed by a processor causes the processor to: receive one or more inputs from a user, the one or more inputs pertain to selecting at least one query by the user among the one or more queries, validate, the selected at least one query received from the user, execute, the selected at least one query subsequent to validation, notify, the user related to the execution of the selected at least one query.
[0016] 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
[0017] 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.
[0018] FIG. 1 is an exemplary block diagram of a communication system for validating and executing one or more queries, according to various embodiments of the present invention;
[0019] FIG. 2 is a block diagram of a system for validating and executing one or more queries, according to various embodiments of the present invention;
[0020] FIG. 3 is schematic representation of a workflow of the system of FIG. 2, according to various embodiments of the present invention;
[0021] FIG. 4 is an architecture for validating and executing one or more queries which can be implemented in the system of FIG. 2, according to various embodiments of the present invention;
[0022] FIG. 5 is a signal flow diagram for validating and executing one or more queries, according to various embodiments of the present invention; and
[0023] FIG. 6 shows a flow diagram of a method for validating and executing one or more queries, according to various embodiments of the present invention.
[0024] The foregoing shall be more apparent from the following detailed description of the invention.
DETAILED DESCRIPTION OF THE INVENTION
[0025] 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.
[0026] 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.
[0027] 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 way 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.
[0028] As per various embodiments depicted, the present invention discloses a system and method for validating and executing one or more queries.
[0029] Referring to FIG. 1, FIG. 1 illustrates an exemplary block diagram of a communication system 100 for validating and executing one or more queries, according to one or more embodiments of the present disclosure. The communication system 100 includes a network 105, a User Equipment (UE) 110, a server 115, and a system 120. The UE 110 aids a user to interact with the system 120. In an embodiment, the UE 110 is one of but not limited to any electronic electro-mechanical 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, smartphone, a general-purpose computer, desktop, personal digital assistant, tablet computer, mainframe computer, or any other computing device.
[0030] For the purpose of description and explanation, the description will be explained with respect to the UE 110, or to be more specific will be explained with respect to a first UE 110a, a second UE 110b, and a third UE 110c, and should nowhere be construed as limiting the scope of the present disclosure. Each of the first UE 110a, the second UE 110b, and the third UE 110c is configured to connect to the server 115 via the network 105. In alternate embodiments, the UE 110 may include a plurality of UEs as per the requirement. For ease of reference, each of the first UE 110a, the second UE 110b, and the third UE 110c, will hereinafter be collectively and individually referred to as the “User Equipment (UE) 110”.
[0031] The network 105 may 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. The network 105 may also include, 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 fibre optic network, or some combination thereof.
[0032] The network 105 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 fibre optic network, or some combination thereof. The network 105 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.
[0033] The network 105 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. The network 105 may also include, 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, a VOIP or some combination thereof.
[0034] The communication system 100 includes the server 115 accessible via the network 105. The server 115 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, one or more processors 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.
[0035] The communication system 100 further includes the system 120 communicably coupled to the server 115 and the UE 110 via the network 105. The system 120 is adapted to be embedded within the server 115 or is embedded as the individual entity. However, for the purpose of description, the system 120 is illustrated as remotely coupled with the server 115, without deviating from the scope of the present disclosure.
[0036] Operational and construction features of the system 120 will be explained in detail with respect to the following figures.
[0037] FIG. 2 illustrates an exemplary block diagram of the system 120 for validating and executing one or more queries, according to one or more embodiments of the present disclosure.
[0038] As per the illustrated embodiment, the system 120 includes one or more processors 205, a memory 210, a user interface 215, and a database 220. For the purpose of description and explanation, the description will be explained with respect to one processor 205 and should nowhere be construed as limiting the scope of the present disclosure. In alternate embodiments, the system 120 may include more than one processor 205 as per the requirement of the network 105. The one or more processors 205, hereinafter referred to as the processor 205 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.
[0039] As per the illustrated embodiment, the processor 205 is configured to fetch and execute computer-readable instructions stored in the memory 210. The memory 210 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 display the data to the user via the user interface 215. The memory 210 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.
[0040] In an embodiment, the database 220 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 database 220 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.
[0041] In an embodiment, the user interface 215 is configured to receive one or more inputs from a user. In an embodiment, the user may be at least one of, but not limited to, a network operator, a technician and a network administrator.
[0042] In an embodiment, the one or more inputs received from the user pertains to selecting at least one query by the user among the one or more queries. In an embodiment, the one or more queries include at least one of, but not limited to, network status query, performance metrics query, subscriber data query, and traffic management parameters query. In an embodiment, the user interface 215 includes a variety of interfaces, for example, interfaces for data input and output devices, referred to as Input/Output (I/O) devices, storage devices, and the like. The user interface 215 facilitates in communication of the system 120 with the UE 110.
[0043] Further, in order for the system 120 to validate and execute the one or more queries, the processor 205 includes one or more modules. In one embodiment, the one or more modules includes, but not limited to, a validation unit 225, an execution unit 230 and a notification unit 235 communicably coupled to each other.
[0044] The validation unit 225, the execution unit 230, and the notification unit 235, in an embodiment, may be implemented as a combination of hardware and programming (for example, programmable instructions) to implement one or more functionalities of the processor 205. 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 205 may be processor-executable instructions stored on a non-transitory machine-readable storage medium and the hardware for processor 205 may comprise a processing resource (for example, one or more processors), to execute such instructions. In the present examples, the memory 210 may store instructions that, when executed by the processing resource, implement the processor 205. In such examples, the system 120 may comprise the memory 210 storing the instructions and the processing resource to execute the instructions, or the memory 210 may be separate but accessible to the system 120 and the processing resource. In other examples, the processor 205 may be implemented by electronic circuitry.
[0045] Upon selecting the at least one query by the user via the user interface 215, the validation unit 225 is configured to validate the selected at least one query. The validation unit 225 validates the selected at least one query based on one or more validation parameters. In an embodiment, the one or more validation parameters include at least one of, but not limited to, one or more query headers, query syntax, query identifiers, failure metrics and severity level.
[0046] The query header refers to header parameters such as but not limited to query type, user or system identification, status, timestamps associated with the query.
[0047] The query syntax refers to the query structure for example, but not limited to, the SQL syntax for database queries.
[0048] The query identifier refers to unique identifier and/or tag assigned to the query in the system 120. In an embodiment, the query identifier can be query ID or query name such as but not limited to QUR_001, QUR002, QUR006. The query identifier facilitates tracking and managing queries effectively.
[0049] The failure metrics refers to parameters dealing with a specific metric to define the failure. For example, the parameters herein refer to call drop rate exceeding the metrics such as, but not limited to, threshold which defines a call setup failure.
[0050] The severity level refers to parameters such as but not limited to, criticality classification, impact metrics and Response Time Objectives (RTO). The severity level facilitates the users such as but not limited to network operator, network administrator to prioritize response efforts and allocate resources effectively.
[0051] In an embodiment, the one or more validation parameters are pre-defined, which are utilized by the validation unit 225 in order to validate the selected at least one query. In particular, the validation unit 225 checks if the selected at least one query is of a format compatible with the format as per the pre-defined one or more validation parameters (for example: query headers, query syntax, query identifiers, failure metrics and severity level) in order to validate the selected at least one query.
[0052] In one embodiment, if the validation of the selected at least one query fails, the validation unit 225 transmits a validation failed response to the user via the user interface 215.
[0053] Upon successful validation of the selected at least one query, the selected query is temporarily stored in the database 220. Further, subsequent to receiving, an execution request from the user via the user interface 215, the execution unit 230 is configured to retrieve the selected at least one query stored in the database 220. The execution request received from the user via the user interface 215 includes information pertaining to the at least one query which requires to be executed, basis which, the execution unit 230 retrieves the relevant at least one query from the database 220.
[0054] Further, in order to execute the selected at least one query, the execution unit 230 extracts information pertaining to one or more parameters customized by the user which are related to the selected at least one query. In one embodiment, the one or more parameters which are customized by the user include at least one of, but not limited to, specific tag to identify the one or more queries, and user defined time range to execute the one or more queries. Further, the one or more parameters may also refer to specific configurations such, as but not limited to, specific tag to identify queries, user-defined time range, selection of parameters for query execution, customized filters or conditions, and notification preferences. In an embodiment, the user such as but not limited to, the network operator, network administrator can define/customize the one or more parameters for execution of the selected at least one query along with the execution request which is received at the user interface 215.
[0055] Upon extracting information pertaining to the one or more parameters customized by the user, the execution unit 230 fetches one or more correlation logics for execution of the selected at least one query from a catching layer 415 (indicated in FIG. 4). The one or more correlation logics include at least one of, but not limited to, aggregated metrics, analytical insights, predictive models, root cause identification based on Root cause Analysis (RCA) methodologies for the execution of the selected at least one query. In an embodiment, the caching layer 420 is designed to store and manage frequently accessed data and/or computation results to facilitate rapid retrieval.
[0056] In an alternate embodiment, if the one or more correlation logics are not available in the caching layer 415, the execution unit 230 fetches the one or more correlation logics for execution of the selected at least one query from the database 220 or any third party storage systems.
[0057] Further, the execution unit 230 identifies corresponding data related to the selected at least one query from the database 220. In an embodiment, the execution unit 230 identifies the corresponding data related to the at least one query from the database 220 based on the extracted one or more parameters which are customized by the user related to the selected at least one query. The corresponding data refers to the data which is relevant to the selected at least one query, which is stored in the database 220. For example, if the selected as least one query is “call failure” query, then the corresponding data identified would be “call summary logs”. The execution unit 230 may identify the corresponding data by utilizing comparison techniques such as, but not limited to, Exploratory Data Analysis (EDA) techniques. The EDA is a process of analyzing data to understand its characteristics and to identify patterns and relationships.
[0058] Thereafter, the execution unit 230, applies the fetched one or more correlation logics to the corresponding data (stored in the database 220) pertaining to the selected at least one query. Subsequent to applying the one or more correlation logics to the corresponding data, the execution unit 230 generates one or more outputs. For example, let us consider, the selected at least one query pertains to “call failure” which is validated by the validation unit 225. Pursuant to the validation of the selected at least one query, the execution unit 230, extracts information pertaining to the one or more parameters which are customized by the user. Based on the extracted information of the one or more parameters, the execution unit 230identifies the corresponding data (herein the “call summary logs”) of the selected at least one query (herein the “call failure”) from the database 220.
[0059] Subsequent to identifying the corresponding data, the execution unit 230 applies the fetched one or more correlation logics to the corresponding data stored in the database 220. Thereafter, the execution unit 230 generates one or more outputs, thereby executing the selected at least one query.
[0060] In an embodiment, the one or more outputs pertain to at least one of, but not limited to, aggregated metrics (which, presents statistical summaries of call failure trends over specific time periods), analytical insights to present interpretations derived from the call summary logs, highlighting potential patterns or anomalies in call failures, root cause identification utilizing RCA methodologies to pinpoint underlying causes contributing to call failures, facilitating targeted resolution efforts.
[0061] Further, the execution unit 230 converts the one or more outputs into at least one of, but not limited to, a file format such, as but not limited to, CSV (Comma-Separated Values), JSON (JavaScript Object Notation), PDF (Portable Document Format), XLSX (Excel Spreadsheet), TXT (Plain Text). Thereafter, the notification unit 235 notifies the user pertaining to successful execution of the at least one query. In an embodiment, the user can download the notification pertaining to the successful execution of the at least one query via the user interface 215.
[0062] Further, the execution unit 230 transmits the one or more outputs pertaining to the execution of the selected at least one query to a load balancer 405 (information mentioned in FIG.4). The load balancer 405 forwards the received one or more outputs to the user. The user can then at their end, can verify the one or more outputs pertaining to the selected at least one query.
[0063] Upon user providing a response to the system 120 pertaining to successful verification of the one or more outputs by the user, the one or more outputs are stored in the database 220 for future requirements. In an embodiment, the verified one or more outputs pertaining to the selected at least one query are used for future requirements such as, but not limited to, perform root cause analysis to determine one or more issues in a network element. In one embodiment, the root cause analysis aims to identify the fundamental reasons and causes for network issues, such as, but not limited to, service disruptions, performance degradation, and connectivity issues.
[0064] In an embodiment, the system 120 provides flexibility to the user to validate and execute any type of query generated by any third-party user(s) and/or third-party systems.
[0065] FIG. 3 describes a schematic representation of a workflow of the system 120 of FIG. 2, according to various embodiments of the present invention. It is to be noted that the embodiment with respect to FIG. 3 will be explained with respect to the first UE 110a and the system 120 for the purpose of description and illustration and should nowhere be construed as limited to the scope of the present disclosure.
[0066] As mentioned earlier in FIG. 1, the UE 110a may include an external storage device, a bus, a main memory, a read-only memory, a mass storage device, communication port(s), and a processor. The exemplary embodiment as illustrated in FIG. 3 will be explained with respect to the first UE 110a without deviating from the scope of the present disclosure and limiting the scope of the present disclosure. The first UE 110a includes one or more primary processors 305 communicably coupled to the one or more processors 205 of the system 120.
[0067] The one or more primary processors 305 are coupled with a memory unit 310 storing instructions which are executed by the one or more primary processors 305. Execution of the stored instructions by the one or more primary processors 305 enables the first UE 110a to transmit, the selected at least one query with customized one or more parameters to the one or more processors to validate and execute the selected at least one query among the one or more queries.
[0068] As per the illustrated embodiment, the system 120 includes the one or more processors 205, the memory 210, the user interface 215, and the database 220. The operations and functions of the one or more processors 205, the memory 210, the user interface 215, and the database 220 are already explained in FIG. 2. For the sake of brevity, a similar description related to the working and operation of the system 120 as illustrated in FIG. 2 has been omitted to avoid repetition.
[0069] Further, the processor 205 which includes the validation unit 225, the execution unit 230, and the notification unit 235, are already explained in FIG. 2. Hence, for the sake of brevity, a similar description related to the working and operation of the system 120 as illustrated in FIG. 2 has been omitted to avoid repetition. The limited description provided for the system 120 in FIG. 3, should be read with the description provided for the system 120 in the FIG. 2 above, and should not be construed as limiting the scope of the present disclosure.
[0070] FIG. 4 is an exemplary architecture 400 which can be implemented in the system 120 of the FIG. 2 for validating and executing one or more queries, according to one or more embodiments of the present invention.
[0071] The exemplary embodiment as illustrated in the FIG. 4 includes a user interface 215, a Load Balancer (LB) 405, an analysis engine 410, a caching layer 415, and the database 220.
[0072] In an embodiment, the user interface 215 serves as the front-end component for the user such as but not limited to the network operator, network administrator to interact with the architecture 400. The user interface 215 is configured to receive the one or more inputs from the user. In an embodiment, the one or more inputs pertains to selecting at least one query by the user among the one or more queries. In an embodiment, the one or more queries include at least one of, but not limited to, network status query, performance metrics query, subscriber data query, and traffic management parameters query.
[0073] The one or more inputs received at the user interface 215 are forwarded to the LB 405. The LB 405 facilitates balanced distribution of the received one or more inputs from the user via the user interface 215 to the analysis engine 410. In one embodiment, the LB 405 facilitates optimizing performance and resource utilization, such as, but not limited to traffic management, improving response times, scalability support and reliability of the architecture 400.
[0074] Upon receiving the one or more inputs pertaining to selection of the at least one query from the LB 405, the analysis engine 410 validates the selected at least one query. The analysis engine 410 validates the selected at least one query based on one or more validation parameters such as but not limited to, query headers, query syntax, query identifier, failure metrics, severity level.
[0075] In one embodiment, if the validation of the selected at least one query fails, the analysis engine 410 transmits a validation failed response to the user via the user interface 215.
[0076] Upon successful validation of the selected at least one query, the selected at least one query is temporarily stored in the database 220. Further, subsequent to receiving, an execution request from the user via the user interface 215, the analysis engine 410 is configured to retrieve the selected at least one query stored in the database 220. In an embodiment, the execution request pertains to executing the at least one query.
[0077] Further, in order to execute the selected at least one query, the analysis engine 410 extracts information pertaining to one or more parameters customized by the user which are related to the selected at least one query.
[0078] Upon extracting information pertaining to the one or more parameters customized by the user, the analysis engine 410 fetches one or more correlation logics for execution of the selected at least one query from a catching layer 415.
[0079] In an alternate embodiment, if the one or more correlation logics are not available in the caching layer 415, the analysis engine 410 fetches one or more correlation logics for execution of the selected at least one query from the database 220.
[0080] Further, the analysis engine 410 identifies corresponding data related to the selected at least one query from the database 220. In an embodiment, the analysis engine 410 identifies the corresponding data related to the at least one query from the database 220 based on the extracted one or more parameters which are customized by the user related to the selected at least one query.
[0081] Thereafter, the analysis engine 410, applies the fetched one or more correlation logics to the corresponding data (stored in the database 220) pertaining to the selected at least one query. Subsequent to applying the one or more correlation logics to the corresponding data, the analysis engine 410 generates one or more outputs.
[0082] In an embodiment, the one or more outputs pertain to at least one of, but not limited to, aggregated metrics (which, presents statistical summaries of call failure trends over specific time periods), analytical insights to present interpretations derived from the call summary logs, highlighting potential patterns or anomalies in call failures, root cause identification utilizing RCA methodologies to pinpoint underlying causes contributing to call failures, facilitating targeted resolution efforts.
[0083] Further, the analysis engine 410 converts the one or more outputs into at least one of, but not limited to, a file format such, as but not limited to, CSV (Comma-Separated Values), JSON (JavaScript Object Notation), PDF (Portable Document Format), XLSX (Excel Spreadsheet), TXT (Plain Text). Thereafter, for example, via email, the user is notified pertaining to successful execution of the at least one query. In an embodiment, the user can download the notification pertaining to the successful execution of the at least one query via the user interface 215.
[0084] Further, the analysis engine 410 transmits the one or more outputs pertaining to the execution of the selected at least one query to the LB 405. The LB 405 forwards the received one or more outputs to the user. The user can then verify the one or more outputs pertaining to the selected at least one query.
[0085] Upon user providing a response at the user interface 215 pertaining to successful verification of the one or more outputs by the user, the one or more outputs is stored in the database 220 for future requirements. In an embodiment, the validated one or more outputs pertaining to the selected at least one query is used for future requirements such as, but not limited to, perform root cause analysis to determine one or more issues in a network element. In one embodiment, the root cause analysis aims to identify the fundamental reasons and causes for network issues, such as, but not limited to service disruptions, performance degradation, and connectivity issues.
[0086] FIG. 5 is an exemplary signal flow diagram for validating and executing one or more queries, according to one or more embodiments of the present invention. For the purpose of description, the signal flow diagram is described with the embodiments as illustrated in FIG. 2 and should nowhere be construed as limiting the scope of the present disclosure.
[0087] At step 505, the user interface 215 serves as the front-end component for the user such as but not limited to the network operator, network administrator to interact with the architecture 400. The user interface 215 is configured to receive one or more inputs from the user pertaining to selected at least one query.
[0088] At step 510, the one or more inputs received at the user interface 215 are forwarded to the load balancer 405.
[0089] At step 515, the LB 405 facilitates balanced distribution of the received at least one query from the user via the user interface 215 to the analysis engine 410.
[0090] At step 520, upon receiving the one or more inputs pertaining to the selected at least one query from the load balancer 405, the analysis engine 410 validates the selected at least one query. The analysis engine 410 validates the selected query based on one or more validation parameters stored for example in the database 220. Upon successful validation of the selected at least one query, the selected at least one query is temporarily stored in the database 220
[0091] At step 525, receives an execution request at the user interface 215 from the user. In an embodiment, the execution request pertains to executing the selected at least one query, which is validated at step 520.
[0092] At step 530, the execution request is inputted into the LB 405 for the balanced distribution of the received execution request from the user via the user interface 215 to the analysis engine 410.
[0093] At step 535, the LB 405 forwards the execution request to the analysis engine 410 for the execution of the selected at least one query.
[0094] At step 540, subsequent to receiving, the execution request, the analysis engine 410 is configured to fetch the selected at least one query temporarily stored in the database 220.
[0095] At step 545, the analysis engine 410 extracts information pertaining to one or more parameters customized by the user which are related to the selected at least one query.
[0096] At step 550, the analysis engine 410 fetches one or more correlation logics from the catching layer 415.
[0097] At step 555, the analysis engine 410 identifies corresponding data related to the selected at least one query from the database 220. Thereafter, the analysis engine 410 applies the fetched one or more correlation logics to the corresponding data and generates the one or more outputs.
[0098] At step 560, the analysis engine 410 transmits one or more outputs pertaining to the executed at least one query to the LB 405.
[0099] At step 565, the LB 405 forwards the received one or more outputs to the user via the user interface, and the user can verify the one or more outputs pertaining to the execution of the selected at least one query.
[00100] At step 570, upon successful verification by the user, the executed one or more outputs pertaining to the selected at least one query is stored in the database 220 for future requirements.
[00101] Referring to FIG. 6, FIG. 6 illustrates a flow diagram of the method 600 for validating and executing one or more queries according to various embodiments of the present invention. The method 600 is adapted for validating and executing one or more queries. 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.
[00102] At step 605, one or more inputs are received at a user interface from a user. In an embodiment, the user may be at least one of, but not limited to, a network operator, a technician and the network administrator. In an embodiment, the one or more inputs pertains to selecting at least one query by the user among the one or more queries. In an embodiment, the one or more queries include at least one of, but not limited to, network status query, performance metrics query, subscriber data query, and traffic management parameters query.
[00103] At step 610, the selected at least one query received from the user is validated. In an embodiment, the processor 205 validates the selected at least one query based on one or more validation parameters. In an embodiment, the one or more validation parameters include at least one of, but not limited to, one or more query headers, query syntax, query identifiers, failure metrics and severity level. The validated at least one query is stored temporarily in a database 220.
[00104] At step 615, the selected at least one query is executed subsequent to the validation. In an embodiment, subsequent to receiving, an execution request from the user via the user interface 215, the processor 205 is configured to retrieve the selected at least one query stored in the database 220. Further, in order to execute the selected at least one query, the processor 205 extracts information pertaining to one or more parameters customized by the user which are related to the selected at least one query.
[00105] Upon extracting information pertaining to the one or more parameters customized by the user, the processor 205 fetches one or more correlation logics for execution of the selected at least one query from a catching layer 415 (indicated in FIG. 4).
[00106] Further, the processor 205 identifies corresponding data related to the selected at least one query from the database 220. In an embodiment, the processor 205 identifies the corresponding data related to the at least one query from the database 220 based on the extracted one or more parameters which are customized by the user related to the selected at least one query.
[00107] Thereafter, the processor 205, applies the fetched one or more correlation logics to the corresponding data (stored in the database 220) pertaining to the selected at least one query. Subsequent to applying the one or more correlation logics to the corresponding data, the processor 205 generates one or more outputs.
[00108] At step 620, the user is notified related to the execution of the selected at least one query. In an embodiment the user can download the notification pertaining to the execution of the at least one query.
[00109] The present invention discloses a non-transitory computer-readable medium having stored thereon computer-readable instructions. The computer-readable instructions are executed by the processor 205. The processor 205 is configured to receive one or more inputs from the user, the one or more inputs pertain to selecting at least one query by the user among the one or more queries. The processor 205 is configured to execute the selected at least one query received from the user. The processor 205 is configured to validate the at least one query after execution of the at least one query. Further the processor 205 is configured notify the user related to the validated at least one query.
[00110] 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.
[00111] The present disclosure incorporates technical advancement that facilitates user to validate and execute the queries before running into the production environment. The production environment includes but not limited to live websites, banking applications, telecommunications networks, and healthcare information systems. By validating and executing one or more queries, the invention facilitates confidentiality and accuracy to the user, further user can execute any type of query such as but not limited to simple, aggregation, complex and formula query with any number of iterations. The invention facilitates extracting the information pertaining to one or more parameters customized by the user, which are related to the at least one selected query. Further the invention performs execution of the selected at least one query as per the customized one or more parameters. The invention reduces the user effort by validating the queries after the execution.
[00112] The present invention provides various advantages, includes such as, but not limited to query validation and execution, efficiency. In one embodiment, the user can validate queries by selecting specific queries and setting time constraints. The query validation capabilities allow for targeted validation of data queries to ensure accuracy and reliability. In one embodiment, the user can validate query outputs without needing to actively monitor the user interface during query execution. Such efficiency enhances the user productivity by allowing them to perform other tasks while waiting for results. In one embodiment, the users have the option to download query results via the user interface and receive them via email. The option to download provides flexibility to enable convenient access to validated data outputs. In one embodiment, the user receives notifications once query results are ready. The proactive notification system ensures users are quickly informed validation processes are completed.
[00113] 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
[00114] Communication system – 100
[00115] Network – 105
[00116] User equipment -110
[00117] Server – 115
[00118] System – 120
[00119] Processor - 205
[00120] Memory – 210
[00121] User interface- 215
[00122] Database – 220
[00123] Validation unit 225
[00124] Execution unit – 230
[00125] Notification unit 235
[00126] Load balancer – 405
[00127] Caching layer – 415
[00128] Analysis engine - 410

,CLAIMS:CLAIMS

We Claim:
1. A method (600) for validating and executing one or more queries, the method (600) comprises the steps of:
receiving (605), at a user interface (215), one or more inputs from a user, the one or more inputs pertain to selecting at least one query by the user among the one or more queries;
validating (610), by the one or more processors, the selected at least one query received from the user; executing (615), by the one or more processors (205), the selected at least one query subsequent to the validation;
notifying (620), by the one or more processors (205), the user related to the execution of the selected at least one query.

2. The method (600) as claimed in claim 1, wherein the one or more processors (205), validates the selected at least one query based on one or more validation parameters.

3. The method as claimed in claim 2, wherein the one or more validation parameters include at least one of, one or more query headers, query syntax, query identifiers, failure metrics and severity level.

4. The method as claimed in claim 2, wherein the one or more processors (205), validates the selected at least one query by checking, if the selected at least one query is of a format compatible with respect to the one or more validation parameters.

5. The method as claimed in claim 1, wherein the step of, validating, the selected at least one query, further includes the step of, storing the validated at least one query in a database.

6. The method (600) as claimed in claim 1, wherein the step of executing the selected at least one query received from the user, includes the steps of:
retrieving, by the one or more processors (205), the selected at least one query from the database based on receiving an execution request from the user;
extracting, by the one or more processors (205), information pertaining to one or more parameters customized by the user which are related to the at least one selected query;
fetching, by the one or more processors (205), one or more correlation logics from at least one of, a caching layer or a database (220);
identifying, by the one or more processors (205), corresponding data related to the selected at least one query from the database based on the customized one or more parameters which are extracted from the selected at least one query;
applying, by the one or more processors (205), the one or more correlation logics to the identified corresponding data; and
generating, by the one or more processors (205), one or more outputs based on the applied one or more correlation logics to the corresponding data.

7. The method (600) as claimed in claim 6, wherein the one or more parameters include at least one of, specific tag to identify the one or more queries, user defined time range to execute the one or more queries.

8. The method (600) as claimed in claim 1, wherein upon execution and validation of the at least one query, by the one or more processors (205), the validated one or more queries are stored in the database for future use and to perform root cause analysis in order to determine one or more issues in a network element.

9. A system (120) for validating and executing one or more queries, the system (120) comprising:
a user interface (215), configured to, receive, one or more inputs from a user, the one or more inputs pertain to selecting at least one query by the user among the one or more queries;
a validation unit (230), configured to validate, the selected at least one query received from the user; and
an execution unit (225), configured to execute, the selected at least one query subsequent to the validation;
a notification unit (235), configured to, notify, the user related to the execution of the selected at least one query.

10. The system (120) as claimed in claim 9, wherein the validation unit, validates the selected at least one query based on one or more validation parameters.

11. The system as claimed in claim 9, wherein the validation unit, stores the selected at least one query, in a database.

12. The system (120) as claimed in claim 9, wherein the execution unit (225), executes the selected at least one query received from the user, by:
retrieving, the selected at least one query from the database based on receiving an execution request from the user;
extracting, information pertaining to one or more parameters customized by the user which are related to the at least one selected query;
fetching, one or more correlation logics from at least one of, a caching layer or a database (220);
identifying, corresponding data related to the selected at least one query from the database based on the customized one or more parameters which are extracted from the selected at least one query;
applying, the one or more correlation logics to the identified corresponding data; and
generating, one or more outputs based on the applied one or more correlation logics to the corresponding data.

13. The system (120) as claimed in claim 12, wherein the one or more parameters include at least one of, specific tag to identify the one or more queries, user defined time range to execute the one or more queries.

14. The system (120) as claimed in claim 9, wherein upon validation and execution of the at least one query, the validated one or more queries are stored in a database for future use and to perform root cause analysis in order to determine one or more issues in a network element.
15. The system as claimed in claim 9, wherein the one or more validation parameters include at least one of, one or more query headers, query syntax, query identifiers, failure metrics and severity level.

16. The system as claimed in claim 9, wherein the one or more processors, validates the selected at least one query by checking, if the selected at least one query is of a format compatible with respect to the one or more validation parameters.

17. A User Equipment (UE), comprising:
one or more primary processors communicatively coupled to one or more processors, the one or more primary processors coupled with a memory (210), wherein said the memory (210) stores instructions which when executed by the one or more primary processors causes the UE to:
transmit, the selected at least one query with customized one or more parameters to the one or more processors to validate and execute the selected at least one query among the one or more queries,
wherein the one or more processors is configured to perform the steps as claimed in claim 1.