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
METHOD AND SYSTEM FOR EXECUTING 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 communication systems, and more particularly relates to a method and system for executing one or more queries.
BACKGROUND OF THE INVENTION
[0002] A user of an electronic device (e.g., query system, server, computer or the like) stores a raw data on a database (e.g., MySQL, Microsoft Access, graph database or the like). For every analysis on the raw data, the user of the electronic device needs to create a query and needs to define an output template (including one or more output field(s) that the user wants to visualize for debugging/analysis results associated with the query). Once the query and the output fields are defined and selected, then the user executes the query on the electronic device.
[0003] Further, the electronic device provides an output back to the user on a user interface (UI) (e.g., graphical UI). Consider a scenario, now another user wants to see the data from the database, another user needs to create same query and defines the output template again. This process is time consuming since for every execution, the user(s) have to create the query and have to select the output fields. Similarly, if the user performs the same task on a daily basis, then, the user of the electronic device needs to create the query and needs to define the output template every day. This process is time consuming.
[0004] Hence, there is a need for a system and a method for executing the query on the raw data and managing a user defined output template without wasting the time.
BRIEF SUMMARY OF THE INVENTION
[0005] One or more embodiments of the present disclosure provide a method and system for executing queries.
[0006] In one aspect of the present invention, a method for executing queries is disclosed. The method includes the step of receiving, by one or more processors, via a User Equipment (UE), one or more inputs from a user associated with one or more query requests. The method includes the step of creating, by the one or more processors, the one or more query requests based on the received one or more inputs from the user, the one or more query requests include a query and a field template corresponding to the query. The method includes the step of executing, by the one or more processors, the query on a raw data available in a database utilizing the field template for the one or more query requests.
[0007] In one embodiment, for executing the query on the raw data, the field template is utilized to filter out relevant data as per the query raised by a user of the UE.
[0008] In another embodiment, the step of creating the one or more query requests based further pertains to one of modify, delete, and save the one or more query requests as per the user requirements.
[0009] In yet another embodiment, based on the one or more received inputs, the method comprises the step of fetching one or more query requests from the database.
[0010] In yet another embodiment, on retrieving the one or more query requests from the database, the method comprises the steps of selecting, by the one or more processors, the one or more retrieved query requests, and executing, by the one or more processors, the query on the raw data available in the database utilizing the retrieved field template for the one or more retrieved query requests.
[0011] In yet another embodiment, upon creating the one or more query requests, the method includes the step of validating, by the one or more processors, the one or more query requests, and transmitting, the one or more validated query requests to the database.
[0012] In yet another embodiment, upon execution of the query on the raw data, the method includes the steps of generating, by the one or more processors, a report upon execution of the query on the raw data. The method includes the steps of transmitting, by the one or more processors, the generated report to the UE of the user.
[0013] In another aspect of the present invention, a system for executing queries is disclosed. The system includes a receiving unit configured to receive, one or more inputs from a user associated with one or more query requests. The system includes a creating unit configured to create, the one or more query requests based on the received one or more inputs from the user, the one or more query requests include a query and a field template corresponding to the query. The system includes an execution unit configured to execute the query on a raw data available in a database utilizing the field template for the one or more query requests.
[0014] In another aspect of the present invention, a non-transitory computer-readable medium having stored thereon computer-readable instructions that, when executed by a processor is disclosed. The processor is configured to receive, one or more inputs from a user associated with one or more query requests. The processor is configured to create, the one or more query requests based on the received one or more inputs from the user, the one or more query requests include a query and a field template corresponding to the query. The processor is configured to execute the query on a raw data available in a database utilizing the field template for the one or more query requests.
[0015] In another aspect of the present invention, a User Equipment (UE) is disclosed. The UE includes one or more primary processors communicatively coupled to one or more processors. The one or more primary processors coupled with a memory. The memory stores instructions which when executed by the one or more primary processors causes the UE to generate and transmit one or more query requests to the one or more processers.
[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 an environment for executing queries, according to one or more embodiments of the present disclosure;
[0019] FIG. 2 is an exemplary block diagram of a system for executing the queries, according to the one or more embodiments of the present disclosure;
[0020] FIG. 3 is a schematic representation of the present system of FIG. 1 workflow, according to the one or more embodiments of the present disclosure;
[0021] FIG. 4 is a signal flow diagram illustrating executing the queries, according to the one or more embodiments of the present disclosure; and
[0022] FIG. 5 is a flow diagram illustrating a method for executing the queries, according to the one or more embodiments of the present disclosure.
[0023] The foregoing shall be more apparent from the following detailed description of the invention.
DETAILED DESCRIPTION OF THE INVENTION
[0024] 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.
[0025] 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.
[0026] A person of ordinary skill in the art will readily ascertain that the illustrated steps detailed in the figures and here below are set out to explain the exemplary embodiments shown, and it should be anticipated that ongoing technological development will change the manner in which particular functions are performed. These examples are presented herein for purposes of illustration, and not limitation. Further, the boundaries of the functional building blocks have been arbitrarily defined herein for the convenience of the description. Alternative boundaries can be defined so long as the specified functions and relationships thereof are appropriately performed. Alternatives (including equivalents, extensions, variations, deviations, etc., of those described herein) will be apparent to persons skilled in the relevant art(s) based on the teachings contained herein. Such alternatives fall within the scope and spirit of the disclosed embodiments.
[0027] As per various embodiments depicted, the present invention discloses the system and method of handling secure data for at least one User Equipment (UE) to securely and sensitively store, handle and manage security certificates and credentials.
[0028] Referring to FIG. 1, FIG. 1 illustrates an exemplary block diagram of an environment 100 for executing queries, according to one or more embodiments of the present invention. The environment 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 for generating and transmitting the one or more query requests to one or more processors 205 (as shown in FIG.2). In an embodiment, the user is at least one of, a network operator. The one or more query requests are the requests sent by the user to a database 250 (as shown in FIG.2) to perform specific operations such as retrieving, modifying, updating, deleting records or data.
[0029] 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 UE 110 from 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.
[0030] In an embodiment, each of the first UE 110a, the second UE 110b, and the third UE 110c is one of, but not limited to, any electrical, electronic, electro-mechanical or an equipment and a combination of one or more of the above devices such as virtual reality (VR) devices, augmented reality (AR) devices, laptop, a general-purpose computer, desktop, personal digital assistant, tablet computer, mainframe computer, or any other computing device.
[0031] 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 fiber 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.
[0032] 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, a defense facility, or any other facility that provides content.
[0033] The environment 100 further includes the system 120 communicably coupled to the server 115 and each of the first UE 110a, the second UE 110b, and the third UE 110c via the network 105. The system 120 is configured for executing the queries. The system 120 is adapted to be embedded within the server 115 or is embedded as the individual entity, as per multiple embodiments of the present invention.
[0034] Operational and construction features of the system 120 will be explained in detail with respect to the following figures.
[0035] Referring to FIG. 2, FIG. 2 illustrates an exemplary block diagram of the system 120 for executing the queries, according to the one or more embodiments of the present disclosure. The system 120 includes a processor 205, a memory 210, a user interface 215, and the database 250. For the purpose of description and explanation, the description will be explained with respect to one or more processors 205, or to be more specific will be explained with respect to the processor 205 and should nowhere be construed as limiting the scope of the present disclosure. The one or more processor 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.
[0036] The information related to executing the queries is provided or stored in the memory 210. 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 create or share data packets over a network service. The memory 210 may include any non-transitory storage device including, for example, volatile memory such as RAM, or non-volatile memory such as EPROM, flash memory, and the like.
[0037] The user interface 215 includes a variety of interfaces, for example, interfaces for a Graphical User Interface (GUI), a web user interface, a Command Line Interface (CLI), and the like. The user interface 215 facilitates communication of the system 120. In one embodiment, the user interface 215 provides a communication pathway for one or more components of the system 120. Examples of the one or more components include, but are not limited to, the UE 110 and the database 250.
[0038] The database 250 is configured to store the queries from the UE 110. The database 250 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 250 types are non-limiting and may not be mutually exclusive e.g., a database can be both commercial and cloud-based, or both relational and open-source, etc.
[0039] Further, the processor 205, 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.
[0040] In order for the system 120 to execute the queries, the processor 205 includes a receiving unit 220, a creating unit 225, a validation unit 230, an execution unit 235, a generation unit 240 and a transmitting unit 245 communicably coupled to each other.
[0041] The receiving unit 220 is configured to receive one or more inputs from the UE 110 of a user associated with one or more query requests. In an embodiment, the one or more query requests based further pertains to one of modify, delete, and save the one or more query requests as per the user requirements. The one or more query requests are the requests sent by the user to the database 250 to perform specific operations such as retrieving, modifying, updating, deleting records or data.
[0042] Upon receiving the one or more inputs from the UE 110 of the user, the creating unit 225 is configured to create the one or more query requests based on the received one or more inputs from the user at the UE 110. In an embodiment, the one or more query requests include a query and a field template corresponding to the query. The query is defined as an actual command or request that specifies retrieving, updating, or deleting data. In an example, the query can be, for example, identify a congested network node value (e.g., a Next Generation Node B (GNB) 302a-302c (shown in FIG.3) value) more than 25, identify a current location of the network node or the like.
[0043] As per the above one embodiment, the field template refers to a predefined format or structure that outlines how the result of the query is displayed. In an example, let us consider that the field template contains 100 columns and a first user needs only first 20 columns for analyses. In this situation, the first user can create the field template including the first 20 columns, which saves the time for user analyzing end results or final outputs. In other words, the field template acts as a filter to only display the relevant data to the user. Upon creating the one or more query requests, the one or more query requests are transmitted to the validation unit 230 for validation.
[0044] The validation unit 230 is configured to validate the one or more query requests received from the UE 110. The validation unit 230 is configured to verify if the query check is completed. If the query check is completed, the one or more query requests are validated and processed further. If any query check fails, the one or more query requests are rejected with an appropriate error message. The validated query request is then forwarded to the execution unit 235.
[0045] Upon validating the one or more query requests received from the UE 110, the system 120 is configured to fetch the one or more query requests from the database 250 based on the one or more received inputs. The system 120 is configured to select the one or more retrieved query requests. Upon selecting the one or more retrieved query requests, the one or more retrieved query requests are transmitted to the execution unit 235 for execution.
[0046] The execution unit 235 is configured to execute the query on a raw data available in the database 250 utilizing the retrieved field template for the one or more retrieved query requests. In an embodiment, the raw data includes, but not limited to, call summary logs, session logs, and trace data. In one embodiment, the call summary logs includes, but are not limited to, call start and end time, caller and recipient information, call duration, call release reason (CRR), call type, and quality metrics. In one embodiment, the session logs include, but are not limited to, session start and end time, session ID, clear code, and bandwidth usage. The raw data matching the query criteria is retrieved from the database 250. Upon executing the query on the raw data, the execution unit 235 utilizes the field template to filter out relevant data as per the query raised by the user of the UE 110. The execution unit 235 is configured to format the retrieved data according to the field template provided in the one or more query requests.
[0047] Upon execution of the query on the raw data by the execution unit 235, the generation unit 240 is configured to generate a report. In an embodiment, the report is based on the retrieved and formatted data, ensuring that the information is presented in a clear, organized, and useful manner for the user. The generated report provides valuable information about the network performance, anomalies, and potential issues to the network operator. Further, the generated reports facilitate the user in troubleshooting, optimization, and proactive management of the network 105. The generated reports are made available to the user via the user interface 215. In another embodiment, the generation unit 240 ensures that the report is structured as per the user requirements. The user interface 215 displays the report, such as Key Performance Indicators (KPIs), call summary logs, call session data, trace data for the user, that is the network administrator, or technician at the network operator.
[0048] Upon generating the report, the transmitting unit 245 is configured to transmit the one or more query requests to the database 250 upon receiving the one or more query requests. Further, the transmitting unit 245 is configured to transmit the generated report to the UE 110 of the user. Further, the user can download the generated report from the UE 110 of the user via the user interface 215. By doing so, the system 120 eliminates creation of query and the filed template for multiple times, reduces time for troubleshooting and provides seamless experience to the user. Multiple users can create and save the field template and use the field template while executing the query.
[0049] FIG. 3 illustrates an architecture 300 that can be implemented in the system of FIG.2, according to one or more embodiments of the present invention. The architecture 300 includes the user interface 215, the database 250, the GNBs 302a-302c, a probing agent 304, a conductor 306, a message broker 308, an Artificial Intelligence for Data Record (AIDR) writer 310, a normalizer 312, ingestion layers 314a-314b, an Artificial Intelligence (AI)/Machine Learning (ML) unit 316, a distributed file system 318, a computation layer 320, a computation engine 322, an inventory system/FMS 324, and a workflow unit 326.
[0050] The operations and functions of the user interface 215, and the database 250 are already explained in FIG. 2. Therefore, will be explained again to avoid repetition.
[0051] The GNBs 302a-302c are communicated with the probing agent 304. The specific instances of gNodeBs are connected within the network 105. The GNBs 302a-302c are a critical component of a Fifth Generation (5G) Radio Access Network (RAN), responsible for wireless communication between the UE 110 and a 5G core network. The probing agent 304 is a network probing tool used for scanning and identifying open and closed ports on remote hosts. The probing agent 304 is configured to operate by sending the data packets to target hosts and analyzing the responses received. The probing agent 304 communicates with the message broker 308. The message broker 308 is a middleware component for routing, transforming, and managing messages between different parts of the distributed file system 318.
[0052] The message broker 308 is coupled with the conductor 306, the AIDR writer 310, and the normalizer 312. The conductor 306 is configured to facilitate a coordinating role in orchestrating tasks or workflows within the system 120 and manages the flow of data and operations between different modules or services. The AIDR writer 310 communicates with the ingestion layer 314a. The AIDR writer refers to a specific tool or system designed to use Artificial Intelligence (AI) techniques for writing or generating data records.
[0053] The normalizer 312 is responsible for standardizing or normalizing the data. The normalizer 312 ensures that the data from different sources or formats are converted into a consistent format, which is easier to process, analyze, and use within the system 120. The ingestion layer 314a is communicated with the distributed file system 318.
[0054] The distributed file system 318 is communicated with the computation engine 322, the computation layer 320, and the AI/ML unit 316. The distributed file system 318 is a file system that allows access to files from multiple hosts shared via the network 105. The distributed file system 318 enables multiple users to collaboratively access and manipulate data as if it is stored on a local file system, while the files reside on different servers.
[0055] The inventory system/FMS 324 communicates with the ingestion layer 314b. The inventory system/FMS 324 manages inventory-related data and functionalities, tracks and manages inventory items. The ingestion layer 314b is responsible for receiving, processing, and integrating incoming data from various sources into the system 120. The ingestion layer 314b acts as a gateway for data ingestion. The ingestion layer 314b communicates with the workflow unit 326. The user interface 215 is communicating with the workflow unit 326 and the normalizer 312. The workflow unit 326 and the normalizer 312 communicate with the database 250.
[0056] The workflow unit 326 is configured to execute the query on the raw data present in the database 250 based on the field template. The workflow unit 326 is configured to create the report for the user. The workflow unit 326 is configured to transmit the generated response back to the user interface 215.
[0057] The workflow unit 326 communicates with the computation engine 322. The one or more query requests from the user are received at the workflow unit 326, which fetches the data from the database 250 and transmits the fetched data to the computation engine 322. The computation engine 322 is configured to perform the computation process on the data based on the received query, and stores at the database 250 via the workflow unit 326.
[0058] Referring to FIG. 4, FIG. 4 describes the system 120 for executing the queries, according to the one or more embodiments of the present disclosure. It is to be noted that the embodiment with respect to FIG. 4 will be explained with respect to the first UE 110a for the purpose of description and illustration and should nowhere be construed as limited to the scope of the present disclosure.
[0059] As mentioned earlier in FIG.1, each of the first UE 110a, the second UE 110b, and the third UE 110c 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 the FIG. 4 will be explained with respect to the first UE 110a. The first UE 110a includes one or more primary processors 305 communicably coupled to the one or more processors 205 of the system 120.
[0060] The one or more primary processors 405 are coupled with a memory 410 storing instructions which are executed by the one or more primary processors 405. Execution of the stored instructions by the one or more primary processors 405 enables the first UE 110a to generate and transmit the one or more query requests to the one or more processors 205.
[0061] As mentioned earlier in FIG.2, the one or more processors 205 of the system 120 includes the processor 205, the memory 210, the user interface 215, and the database 250. The operations and functions of the processor 205, the memory 210, the user interface 215, and the database 250 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. The limited description provided for the system 120 in FIG. 4, 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.
[0062] Further, the processor 205 includes the receiving unit 220, the creating unit 225, the validation unit 230, the execution unit 235, the generation unit 240 and the transmitting unit 245. The operations and functions of the receiving unit 220, the creating unit 225, the validation unit 230, the execution unit 235, the generation unit 240 and the transmitting unit 245 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. 4, 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.
[0063] FIG. 5 is a flow diagram of a method 500 for executing the queries, according to the one or more embodiments of the present disclosure. For the purpose of description, the method 500 is described with the embodiments as illustrated in FIG. 2 and should nowhere be construed as limiting the scope of the present disclosure.
[0064] At step 505, the method 500 includes the step of receiving one or more inputs from the UE 110 of the user associated with one or more query requests by the receiving unit 220. In an embodiment, the one or more query requests are created pertains to one of modify, delete, and save the one or more query requests as per the user requirements. The one or more query requests are the request sent by the user to the database 250 to perform specific operations such as retrieving, modifying, updating, deleting records or data.
[0065] At step 510, the method 500 includes the step of creating the one or more query requests based on the received one or more inputs from the user at the UE 110 by the creating unit 225. In an embodiment, the one or more query requests include a query and a field template corresponding to the query. Upon creating the one or more query requests, the one or more query requests are transmitted to the validation unit 230 for validation. Further, the method 500 includes the step of fetching the one or more query requests from the database 250 based on the one or more received inputs. The method 500 includes the steps of selecting the one or more retrieved query requests.
[0066] At step 515, the method 500 includes the step of executing the query on the raw data available in the database 250 utilizing the field template for the retrieved one or more query requests by the execution unit 235. The raw data matching the query criteria is retrieved from the database 250. Upon executing the query on the raw data, the execution unit 235 utilizes the field template to filter out relevant data as per the query raised by the user of the UE 110. The execution unit 235 is configured to format the retrieved data according to the field template provided in the one or more query requests.
[0067] FIG. 6 is a flow diagram of a method 600 for executing the query on the raw data available in the database, according to the one or more embodiments of the present disclosure.
[0068] At step 605, the method 515 includes the step of generating the report by the generation unit 240. In an embodiment, the report is based on the retrieved and formatted data, ensuring that the information is presented in a clear, organized, and useful manner for the user. In another embodiment, the generation unit 240 ensures that the report is structured as per the user requirements.
[0069] At step 610, the method 515 includes the step of transmitting the one or more query requests to the database 250 by the transmitting unit 245 upon receiving the one or more query requests. Further, the transmitting unit 245 is configured to transmit the generated report to the UE 110 of the user. Further, the user can download the generated report from the UE 110 of the user via the user interface 215.
[0070] The present invention further discloses a non-transitory computer-readable medium having stored thereon computer-readable instructions. The computer-readable instructions are executed by a processor 205. The processor 205 is configured to receive, at a User Equipment (UE) 110, one or more inputs from a user associated with one or more query requests. The processor 205 is configured to create, at the UE 110, the one or more query requests based on the received one or more inputs from the user, the one or more query requests include a query and a field template corresponding to the query. The processor 205 is configured to execute the query on a raw data available in a database 250 utilizing the field template for the one or more query requests.
[0071] 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.
[0072] The present disclosure incorporates technical advancement of creating the query and the filled template based on the user’s requirement to select the appropriate template and execute the query on the raw data available in the database by the UE of the user. Upon execution, the report is being generated based on the filed template. The present invention also supports downloading of the report from the user interface of the UE. By doing so, the present invention eliminates creation of query and the filled template for multiple times, reduces time for troubleshooting and provides seamless experience to the user. Multiple users can create and save the field template and use the field template while executing the query.
[0073] 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
[0074] Environment - 100;
[0075] Network - 105;
[0076] User Equipment – 110;
[0077] Server – 115;
[0078] System -120;
[0079] Processor -205;
[0080] Memory – 210;
[0081] User Interface - 215;
[0082] Receiving unit-220;
[0083] Creating unit - 225;
[0084] Validation unit- 230;
[0085] Execution unit-235;
[0086] Generation unit- 240;
[0087] Transmitting unit-245;
[0088] Database - 250;
[0089] GNBs- 302a-302c;
[0090] Probing agent-304;
[0091] Conductor-306;
[0092] Message broker-308;
[0093] AIDR writer- 310;
[0094] Normalizer-312;
[0095] Ingestion layer-314a, 314b;
[0096] AI/ML unit-316;
[0097] Distributed file system-318;
[0098] Computation layer-320;
[0099] Computation engine-322;
[00100] Inventory system/FMS-324;
[00101] Workflow unit-326;
[00102] Primary processor– 405;
[00103] Memory – 410.

,CLAIMS:CLAIMS
We Claim:
1. A method (500) of executing queries, the method (500) comprising the steps of:
receiving (505), by one or more processors (205), via a User Equipment (UE) (110), one or more inputs from a user associated with one or more query requests;
creating (510), by the one or more processors (205), the one or more query requests based on the received one or more inputs from the user, the one or more query requests include a query and a field template corresponding to the query; and
executing (515), by the one or more processors (205), the query on a raw data available in a database (250) utilizing the field template for the one or more query requests.

2. The method (500) as claimed in claim 1, wherein for executing the query on the raw data, the field template is utilized to filter out relevant data as per the query raised by a user of the UE (110).

3. The method (500) as claimed in claim 1, wherein the step of creating the one or more query requests pertains to one of modify, delete, and save the one or more query requests as per the user requirements.

4. The method as claimed in claim 1, wherein based on the one or more received inputs, the method comprises the step of fetching one or more query requests from the database (250).

5. The method as claimed in claim 4, wherein on retrieving the one or more query requests from the database, the method comprises the steps of selecting, by the one or more processors, the one or more retrieved query requests, and executing, by the one or more processors, the query on the raw data available in the database (250) utilizing the retrieved field template for the one or more retrieved query requests.

6. The method (500) as claimed in claim 1, wherein upon creating the one or more query requests, the method (500) comprises the step of validating, by the one or more processors (205), the one or more query requests, and transmitting, the one or more validated query requests to the database (250).

7. The method (500) as claimed in claim wherein upon execution of the query on the raw data, the method comprises the steps of:
generating (605), by the one or more processors (205), a report upon execution of the query on the raw data; and
transmitting (610), by the one or more processors (205), the generated report to the UE (110) of the user.

8. A system (120) for executing queries, the system (120) comprising:
a receiving unit (220) configured to receive, one or more inputs from a user associated with one or more query requests;
a creating unit (225) configured to create, the one or more query requests based on the received one or more inputs from the user, the one or more query requests include a query and a field template corresponding to the query; and
an execution unit (235) configured to execute the query on a raw data available in a database (250) utilizing the field template for the one or more query requests.

9. The system (120) as claimed in claim 8, wherein for executing the query on the raw data, the execution unit (235) utilizes the field template to filter out relevant data as per the query raised by a user of the UE (110).

10. The system (120) as claimed in claim 8, wherein the step of creating the one or more query requests based further pertains to one of modify, delete, and save the one or more query requests as per the user requirements.

11. The system (120) as claimed in claim 8, wherein based on the one or more received inputs, the system comprises to fetch the one or more query requests from the database (250).

12. The system (120) as claimed in claim 8, wherein on retrieving the one or more query requests from the database (250), the system comprises to select the one or more retrieved query requests, and execute, the query on the raw data available in the database (250) utilizing the retrieved field template for the one or more retrieved query requests.

13. The system (120) as claimed in claim 8, comprising
a validation unit (230) configured to validate, the one or more query requests received from the UE (110) upon receiving the one or more query requests; and
a generation unit (240) configured to generate, a report upon execution of the query on the raw data.

14. The system (120) as claimed in claim 8, comprising a transmitting unit (245) configured to:
transmit, the one or more query requests to the database (250) upon receiving the one or more query requests; and
transmit, the generated report to the UE (110) of the user.

15. A User Equipment (UE) (110), comprising:
one or more primary processors (405) communicatively coupled to one or more processors (205), the one or more primary processors (405) coupled with a memory (410), wherein said memory (410) stores instructions which when executed by the one or more primary processors (405) causes the UE (110) to:
generate and transmit, one or more query requests to the one or more processors (205);
wherein the one or more processors (205) is configured to perform the steps as claimed in claim 1.