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 QUERYING A DATABASE IN A NETWORK

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 relates to the field of telecommunication networks, more particularly relates to a method and a system for querying a database in the telecommunication networks.
BACKGROUND OF THE INVENTION
[0002] A data lake is a centralized repository designed to store, process, and secure large amounts of structured, semi-structured, and unstructured data. It can store data in its native format and process any variety of it, irrespective of the size. Data lakes can encompass hundreds of terabytes or even peta-bytes, storing replicated data from operational sources, including databases and the like.
[0003] In everyday language, a query is simply a request for information. Similarly, the meaning of a query in database management is a request for data. A query is a question or inquiry about a set of data. For example, Structured Query Language (SQL) is used to retrieve meaningful and relevant information from databases. SQL is a programming language used to communicate with and manipulate databases. Similarly, a Query in DBMS is used to retrieve or modify data stored in the database. In simple words, a query is like a question or a request for any operation on a particular data object. Queries traverse a database and may retrieve data according to the requirements specified.
[0004] It may be desired to find the relevant feasible data to analyse and troubleshoot a network function. Suppose only ten out of the eighty odd fields in a database need to be aggregated. Further, only the data for the last ten days may need to be analysed to check the status of the network function. Based upon the analysis, a feedback can be given to the network function for enhancement and trouble shooting.
[0005] In the prior art, when data is required from a database such as a data lake, a query is built using a query builder, and the data is imported in a data sheet such as an Excel File. It may be the case that some users may not be aware of the databases available and present in the network. Besides, users might be unaware of the data lake or data warehouse and about how to build a query in specialized languages such as the SQL and the like. In such cases, the user will require to approach a developer, define parameters and provide inputs, based upon which the developer provides the required data to the user in the form of a data sheet such as an Excel file and the like.
[0006] Further, the final result delivered to the user may not match the parameters and inputs provided to the developer and the process may require a few iterations before desired data is received by the user. This is not desirable and leads to waste of time. It is desired that the user be provided the feasibility/ flexibility to create a query mechanism on databases such as a data lake in runtime. It is also desired that the queries that can be created in run time may be as simple as a simple match query and as complex as having multiple levels of aggregations.
[0007] There is, therefore, a need for a solution that overcomes the above challenges and provides a system and a method for retrieving and extracting data from data bases such as a data lake without the need of a developer or knowledge of specialized languages such as SQL and the like. The user should be able to dynamically define requirements and inputs on a database in runtime.
SUMMARY OF THE INVENTION
[0008] One or more embodiments of the present invention provides a method and a system for querying a database in a network.
[0009] In one aspect of the present invention, the method for querying the database in the network is provided. The method includes the step of receiving one or more queries from a User Equipment (UE) for extracting data from a database. The method further includes the step transmitting, each of the one or more queries to the database via a workflow unit. Each of the one or more queries are validated at the workflow unit. Further, the method includes step of retrieving the data associated with a query of each of the one or more queries from the database.
[0010] In an embodiment, the method includes the step of validating, each of the one or more queries during transmission of the each of the one or more queries to the database (220), and the retrieved data prior to transmission of the retrieved data to the UE. In an embodiment, the one or more processor aids in creating each of the one or more queries in a user friendly manner irrespective of a backend database design and programming approach.
[0011] In an embodiment, each of the one or more queries is one of a match query and a multiple level aggregation query.
[0012] In an embodiment, the data retrieved is converted into one or more of a report, chart and graph for debugging and analytics and thereafter transmitted to the user interface.
[0013] In an embodiment, the data corresponding to one of failures and errors are aggregated at a network level, interface level and from top hierarchy to bottom hierarchy, thereby aiding in retrieving data corresponding to each of the one or more queries.
[0014] In another aspect of the present invention, the system for querying the database in the network is provided. The system includes a transceiver unit and a retrieving unit. The transceiver unit is configured to receive, one or more queries from a User Equipment (UE) for extracting data from a database and transmit, each of the one or more queries to the database via a workflow unit. The retrieving unit is configured to retrieve, the data associated with a query of each of the one or more queries from the database.
[0015] In yet another aspect of the invention, a non-transitory computer-readable medium having stored thereon computer-readable instructions is disclosed. The computer-readable instructions are executed by a processor. The processor is configured to receive one or more queries from a User Equipment (UE) for extracting data from a database. The processor is further configured to transmit each of the one or more queries to the database via a workflow unit. Each of the one or more queries are validated by the processor at the workflow unit. The processor is further configured to retrieve the data associated with a query of the each of the one or more queries from the database.
[0016] In another aspect of the present invention, a User Equipment (UE) is disclosed. One or more primary processors communicatively coupled to one or more processors. The one or more primary processors are coupled with a memory. The memory stores instructions which when executed by the one or more primary processors causes the UE to transmit one or more queries for extracting data from a database to the one or more processors.
[0017] 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
[0018] 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.
[0019] FIG. 1 is an exemplary block diagram of a communication system for querying a database in a network, according to one or more embodiments of the present disclosure;
[0020] FIG. 2 is an exemplary system for querying the database in the network, according to one or more embodiments of the present disclosure;
[0021] FIG. 3 is a schematic representation of a workflow of the system of FIG. 2 communicably coupled with a User equipment (UE), according to one or more embodiments of the present disclosure;
[0022] FIG. 4 is an exemplary block diagram of an architecture of the system of the FIG. 2, according to one or more embodiments of the present disclosure;
[0023] FIG. 5 is a signal flow diagram for querying the database in the network, according to one or more embodiments of the present disclosure; and
[0024] FIG. 6 is a flow chart illustrating a method for querying the database in the network, according to one or more embodiments of the present disclosure.
[0025] The foregoing shall be more apparent from the following detailed description of the invention.
DETAILED DESCRIPTION OF THE INVENTION
[0026] 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.
[0027] 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.
[0028] 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.
[0029] Referring to FIG. 1, FIG. 1 illustrates an exemplary block diagram of a communication system 100 for querying a database 220 (as shown in FIG. 2) in a network 105, according to one or more embodiments of the present disclosure. The communication system 100 includes the 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 electrical, 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, 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. As per the illustrated embodiment, the communication system 100 includes one or more base stations 125. 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 network 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, 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 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.
[0033] The network 105 may also include, by way of example but not limitation, at least a portion of one or more network 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 120, 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 querying the database 220 in the network 105, 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 the 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 enriched data to the user via the user interface in order to perform analysis. 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 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 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.
[0041] 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. In one embodiment, the database 220 includes raw data that is either stored or generated as a result of functionalities implemented by any of the components of the processor 205 or the processing engines.
[0042] In order for the system 120 to query the database 220 in the network 105, the processor 205 includes one or more modules/units. In one embodiment, the one or more modules/units includes, but not limited to, a transceiver unit 225, a workflow unit 230, and a retrieving unit 235.
[0043] The transceiver unit 225, the workflow unit 230, and the retrieving 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.
[0044] The transceiver unit 225 is configured to receive one or more queries from the UE 110. In one embodiment, the processor 205 aids in creating each of the one or more queries in a user-friendly manner irrespective of a backend design of the database 220 and programming approach. In one embodiment, the one or more queries refers to requests made by UE 110 to retrieve specific data from the databases 220. The specific data, or data, corresponds to at least one of, but not limited to performance metrics, subscriber usage patterns, service quality indicator, billing and financial data, network configuration details, geographical and location-based data. Each of the one or more queries aids in extracting data of any number of fields for any given time frame utilizing logical conditions including at least one of, but not limited to, OR, AND, and MATCH
[0045] Subsequent to receiving the one or more queries, the transceiver unit 225 is configured to transmit each of the one or more queries to the database 220. In an embodiment, the one or more queries is one of the match query and the multiple level aggregation query. In one embodiment, the match query refers to a type of query used to retrieve specific data records that match specified criteria or/and conditions. In one embodiment, the match query is essential for complete data retrieval and analysis in various operational and management aspects of network 105, the match query includes such as, but not limited to subscriber data management, network performance monitoring, fault management, billing and usage analysis. In one embodiment, the multiple level aggregation query refers to complex data retrieval technique used to aggregate and summarize data across hierarchical levels and/or dimensions. The multiple level aggregation query is essential for analyzing complex data and deriving meaningful insights from aggregated data element. In another embodiment, the one or more queries include at least one of, but not limited to, data retrieval queries, service-specific queries, network management queries, analytics queries, configuration queries.
[0046] Further, the transceiver unit 225 is configured to transmit each of the one or more queries to the database 220 via the workflow unit 230. The workflow unit 230 is configured to validate each of the one or more queries as received from the UE 110. In one embodiment, the validation process ensures that the one or more queries submitted to the database 220 are correctly formulated and adhere to the structural and operational standards required by the database 220 and the system 120. Further, on validating each of the one or more received queries advantageously aids in data integrity, minimizing of errors, and optimized query performance within the network 105.
[0047] In an exemplary embodiment, the one or more queries included in the request are in a JavaScript Object Notation (JSON) content. The JSON content includes a header that specifies the data of one or more policies. Further, the workflow unit 230 analyzes the JSON content for the header existence and verifies the header key exists in the analyzed JSON content. Accordingly, the workflow unit 230 validates the header values by confirming the header existence and ensures the headers includes valid values. Accordingly, the workflow unit 230 successfully validates the headers within the JSON content of the one or more queries.
[0048] Subsequent to validation of each of the one or more queries at the workflow unit 230, the retrieving unit 235 is configured to retrieve the data associated with each of the one or more queries from the database 220. In one embodiment, the retrieving unit 235 is integral to system 120 and facilitates querying and retrieval of the data such as, the performance metrics from the database 220. The performance metrics includes at least one of, network latency, throughput, and other key parameters relevant to performance of the network 105. In one embodiment, the retrieving unit 235 processes each of the one or more validated queries to extract specific data sets based on at least one of, but not limited to, time intervals, network elements, and performance levels.
[0049] In one embodiment, in order to aid in retrieval of the data, the data is systematically aggregated within the database 220. More specifically, the data corresponding to one of failures and errors are aggregated at the network 105 level, interface level and from top hierarchy to bottom hierarchy, thereby aiding in retrieving data corresponding to each of the one or more queries. In one embodiment, the aggregation of failure and error data at different levels of the network hierarchy enables operators to efficiently diagnose, troubleshoot, and optimize the network performance, ensuring robust and reliable service delivery to end-user, such as, but not limited to, a subscriber.
[0050] Subsequent to retrieval of the data corresponding to each of the one or more queries by the retrieving unit 235, the workflow unit 230 is configured to validate the retrieved data. In one embodiment, the workflow unit 230 successfully validates if the retrieved data corresponds to each of the one or more queries. Upon successful validation, the data is transmitted to the UE 110. In one embodiment, prior to transmission and upon validation, the data retrieved is converted into at least one of, but not limited to, a report, a chart, and a graph. The converted data is thereafter used for debugging and analytics.
[0051] FIG. 3 describes an embodiment 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.
[0052] The first UE 110a includes an external storage device, a bus, a main memory, a read-only memory, a mass storage device, communication port(s), and a processor. The first UE 110a includes one or more primary processors 305 communicably coupled to the one or more processors 205 of the system 120.
[0053] The one or more primary processors 305 are coupled with a memory 310 for 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 one or more queries for extracting data from the database 220 to the one or more processors 205.
[0054] 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.
[0055] Further, the transceiver unit 225, the workflow unit 230, and the retrieving 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
[0056] FIG.4 is an exemplary architecture 400 for the system 120 for querying the database 220 in the network 105, according to one or more embodiments of the present invention. The architecture 400 includes the user interface 215, the workflow unit 230, and the database 220.
[0057] In one embodiment, the user creates each of the one or more queries via the user interface 215. In another embodiment, the user creates each of the one or more queries utilizing the UE 110. Further, the system 120 aids the user to create each of the one or more queries in a user-friendly manner irrespective of the backend design of the database 220 and a programming approach. The one or more queries may be mixed in complexity and scope, depending on the user needs and raw data available in the database 220.
[0058] Upon receiving the one or more queries, the workflow unit 230 validates each of the one or more queries and subsequently executes it on the raw data stored in the database 220. In one embodiment, the raw data refers to original data stored in the database 220 collected from various network elements and devices. In one embodiment, the raw data includes at least one of, but not limited to, the performance metrics, the user traffic and usage data, the device and equipment status, the location-based data, and the service quality indicators.
[0059] In one embodiment, a data reporting and analytics feature extracts the performance metrics such as, but not limited to, the signal strength, the network latency, and the device connectivity status from the database 220. In one embodiment, the data reporting and analytics feature retrieves stored data from components responsible for data indexing and storage as well as data correlation and computation components within the database 220.
[0060] Subsequent to retrieving of the stored data in response to execution of each of the one or more queries, the workflow unit 230 validates the retrieved data and transmits the retrieved data to the UE 110. In one embodiment, the workflow unit 230 displays the retrieved data at the user interface 215. In one embodiment, the retrieved data is transformed into visually intuitive graphs and charts that facilitate debugging and provide insights for analytical purposes. Further, the user may download generated reports from the user interface 215 based on executed templates according to the requirements. Additionally, the user has the option to schedule reports for automated generation and the data monitoring is available in both tabular and graphical formats after execution of reports.
[0061] FIG. 5 is an exemplary signal flow diagram querying the database 220 in the network 105, 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.
[0062] At step 505, in one embodiment, the user creates the one or more queries utilizing at least one of, but not limited to, the UE 110 and the user interface 215. In an embodiment, each of the one or more queries are dynamically generated based on user input typically using conditions specified interactively at the user interface 215. Each of the one or more queries are created in a user friendly manner irrespective of the backend design of the database 220 and programming approach.
[0063] At step 510 and 515, upon receiving the one or more queries from the user interface 215, the workflow unit 230 validates each of the one or more queries and subsequently executes it on the raw data stored in the database 220. In one embodiment, the raw data refers to original data stored in the database 220 collected from various network elements and devices. In one embodiment, the raw data is at least one of, but not limited to, the performance metrics, the user traffic and usage data, the device and equipment status, the location-based data, and the service quality indicators.
[0064] At step 520, upon executing the raw data stored in the database 220 based on each of the one or more queries, the database 220 sends a response to the workflow 230. The response includes the data retrieved from the database 220 in response to execution of each of the one or more queries.
[0065] At step 525, upon fetching the stored data, the workflow 230 validates the response and transmits the validated response to the user interface 215. In an embodiment, the user downloads generated reports from the user interface 215 based on executed templates according to the requirements. In one embodiment, the user has an option to schedule reports for automated generation and the data monitoring is available in both tabular and graphical formats after execution of reports.
[0066] FIG. 6 is a flow chart illustrating a method 600 for querying the database 220 in the network 105, according to various embodiments of the present invention. The method 600 is adapted for querying the database 220 in the network 105. 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.
[0067] At step 605, the method 600 includes the step of receiving one or more queries from the UE 110 for extracting data from the database 220. The data is at least one of, but not limited to, the performance metrics, the subscriber usage patterns, the service quality indicator, the billing and financial data, the network configuration details, and the geographical and location-based data.
[0068] At step 610, the method 600 includes the step of transmitting each of the one or more queries to the database 220 via the workflow unit 230. The workflow unit 230 is configured to validate the each of the one or more queries. In one embodiment, the validation process ensures that queries submitted to the database are correctly formulated and adhere to the structural and operational standards required by the database management system, the database management system facilitates such as, but not limited to creation, management, and utilization of database 220.
[0069] At step 615, the method 600 includes the step of retrieving the data associated with each of the one or more queries from the database 220. In one embodiment, the retrieving unit 235 is integral to the network management system and facilitates querying and retrieval of critical performance metrics from the database 220. The metrics includes, but not limited to network latency, throughput, and other key parameters relevant to network performance. Subsequent to retrieval, the retrieved data is validated at the workflow unit 230 and then transmitted to the UE 110 in the form of charts, graphs etc. for the purpose of debugging and analytics.
[0070] 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 data pertaining to a user session in the network 105 from one or more network elements. The processor 205 is configured to validate the received data. Further, the processor 205 is configured to segregate the validated data. Further, the processor 205 is configured to decode the validated data pertaining to the user session. Further the processor 205 is configured to parse the decoded data to identify irregularities in the decoded data. Further the processor 205 is configured to generate reports and insights based on parsing of the decoded data.
[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 that facilitates querying the database in the network 105 that leverages flexibility to create the query mechanism on the database such as, but not limited to, data lake in the runtime. By eliminating need of a developer or knowledge of specialized languages such as, but not limited to structured query language (SQL), python, bash scripting for retrieving and extracting the data from database. The solution enhances the end user to run the one or more queries in the user-friendly manner without any knowledge of the backend database design and programming approach. The invention facilitates the user can extract data of any number of fields for any given time frame and apply any logical conditions such as but not limited to, OR, AND, MATCH.
[0073] The present invention provides various advantages, which facilitates enhanced operational efficiency, optimal resource utilization, reduced time and the like. The user such as but not limited to network operator, network administrator, network admin can efficiently extract and analyse large volumes of the network 105 data without requiring deep technical knowledge in the querying and optimization. The real-time performance monitoring facilitates proactive monitoring and optimization of the network performance. The solution facilitates creating each of the one or more queries in the user-friendly manner irrespective of the backend database design and programming approach. The solution further facilitates converting the retrieved data into the one or more of, but not limited to, the report, the chart and the graph for debugging and analytics and thereafter transmitting the converted form to the user interface.
[0074] 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
[0075] Communication system – 100
[0076] Network – 105
[0077] User Equipment – 110
[0078] Server – 115
[0079] System – 120
[0080] Processor -205
[0081] Memory – 210
[0082] User Interface– 215
[0083] Database- 220
[0084] Transceiver unit - 225
[0085] Retrieving unit - 235
[0086] Workflow unit – 230

,CLAIMS:CLAIMS
We Claim:
1. A method (600) for querying a database in a network (105), the method comprising the steps of:
receiving (605), by one or more processors (205), one or more queries from a User Equipment (UE) (110) for extracting data from a database (220);
transmitting (610), by the one or more processors (205), each of the one or more queries to the database (220) via a workflow unit (240), wherein each of the one or more queries are validated by the one or more processors (205) at the workflow unit (240); and
retrieving (615), by the one or more processors (205), the data associated with a query of each of the one or more queries from the database (220).

2. The method (600) as claimed in claim 1, comprising validating, by the one or more processors (205), each of the one or more queries during transmission of the each of the one or more queries to the database (220), and the retrieved data prior to transmission of the retrieved data to the UE (110).

3. The method (600) as claimed in claim 1, wherein each of the one or more queries is one of a match query and a multiple level aggregation query.

4. The method (600) as claimed in claim 1, wherein the data retrieved is converted into one or more of a report, chart and graph for debugging and analytics and thereafter transmitted to the user interface (215).

5. The method (600) as claimed in claim 1, wherein data corresponding to one of failures and errors are aggregated at a network (105) level, interface level and from top hierarchy to bottom hierarchy, thereby aiding in retrieving data corresponding to each of the one or more queries.

6. A system (120) for querying a database (220) in a network (105), the system (120) comprising:
a transceiver unit (225) configured to:
receive, one or more queries from a User Equipment (UE) (110) for extracting data from a database (220); and
transmit, each of the one or more queries to the database (220) via a workflow unit (240); and
a retrieving unit (235) configured to retrieve, the data associated with a query of each of the one or more queries from the database (220).

7. The system (120) as claimed in claim 6, wherein the workflow unit (240) is configured to:
validate, each of the one or more queries during transmission of the each of the one or more queries to the database (220); and
validate, the retrieved data prior to transmission of the retrieved data to the UE (110).

8. The system (120) as claimed in claim 6, wherein each of the one or more queries is one of a match query and a multiple level aggregation query.

9. The system (120) as claimed in claim 6, wherein the data retrieved from the database (220) is converted into one or more of a report, chart and graph for debugging and analytics and thereafter transmitted to the user interface (215).

10. The system (120) as claimed in claim 6, wherein data corresponding to one of failures and errors are aggregated at a network (105) level, interface level and from top hierarchy to bottom hierarchy, thereby aiding in retrieving data corresponding to each of the one or more queries.

11. A User Equipment (UE) comprising:
one or more primary processors (305) communicatively coupled to one or more processor (205) in a system (120), the one or more primary processors (305) coupled with a memory (310), wherein said memory (310) stores instructions which when executed by the one or more primary processors (305) causes the UE (110) to:
transmit one or more queries for extracting data from a database (220) 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.