EP-4740693-A1 - SYSTEM AND METHOD FOR DATABASE MANAGEMENT

EP4740693A1EP 4740693 A1EP4740693 A1EP 4740693A1EP-4740693-A1

Abstract

The present disclosure relates to a system (108) and a method (500) for database management The system (108) includes a receiving unit (212) to receive a signaling query from a User Equipment (UE) (102). The system (108) includes a querying unit (214) to query a primary database (208). The system (108) includes a determination unit (216) to determine if a response is received from the primary database (208) within a first pre-defined time period. The determination unit (216) further checks if the response is received from the primary database (208) within a second pre-defined time period. The querying unit (214) queries a secondary database (210) to receive the response within the second pre-defined time period. The system (108) includes a transmitting unit (218) to transmit a status of response received pertaining to the signaling query from one of the primary database (208) and the secondary database (210).

Inventors

BHATNAGAR, Aayush\
JHA, ADITYAKAR
Priyadarshi, Ajay Kumar
KUMAR, DINESH
Murmu, Raghunath
Padhan, Sanjeeb Kumar
VASHISHTH, Yog

Assignees

Jio Platforms Limited

Dates

Publication Date: 20260513
Application Date: 20240627

Claims (12)

1. A method (500) for database management, the method (500) comprising the steps of: receiving, by one or more processor (202), a signalling query from a User Equipment (UE) (102); querying, by the one or more processor (202), a primary database (208) with the signalling query received from the UE (102); determining, by the one or more processor (202), if a response is received from the primary database (208) within a first pre-defined time period; checking, by the one or more processor (202), if the response is received from the primary database (208) within a second pre-defined time period, wherein the second pre-defined time period being greater than the first pre-defined time period; in response to not receiving the response from the primary database (208) within the second pre-defined time period, querying, by the one or more processor (202), to a secondary database (210) to receive the response; and transmitting, by the one or more processor (202), a status of response received pertaining to the signalling query from one of the primary database (208) and the secondary database (210).
2. The method (500) as claimed in claim 1, wherein if the one or more processor (202) fails to receive the response from the primary database (208) within the second pre-defined time period, the method (500) comprising the steps of: logging, by the one or more processors (202), a number of the signalling queries transmitted to the primary database (208) without receiving the response; and transmitting, by the one or more processors (202), the subsequent signalling queries to the secondary database (210), in response to the number of the signalling queries transmitted to the primary database (208) crosses a pre-defined threshold count.
3. The method (500) as claimed in claim 1 , wherein the data present in the primary database (208) is mapped onto the secondary database (210).
4. The method (500) as claimed in claim 1, wherein the signalling query includes one of an attach request, an authentication request, a re-authentication request, and a de-registration request streaming from the UE (102).
5. The method (500) as claimed in claim 1, wherein the secondary database (210) is a geo-redundant database situated remotely from the primary database (208).
6. A system (108) for database management, the system (108) comprising: a receiving unit (212) configured to receive, a signalling query from a User Equipment (UE) (102); a querying unit (214) configured to query, a primary database (208) with the signalling query received from the UE (102); a determination unit (216) configured to: determine, if a response is received from the primary database within a first pre-defined time period; and check, if the response is received from the primary database (208) within a second pre-defined time period, wherein the second pre-defined time period being greater than the first pre-defined time period; the querying unit (214) configured to query, a secondary database (210) to receive the response in response to not receiving the response from the primary database (208) within the second pre-defined time period; and a transmitting unit (218) configured to transmit, a status of response received pertaining to the signalling query from one of the primary database (208) and the secondary database (210).
7. The system (108) as claimed in claim 6, wherein the data present in the primary database (208) is mapped onto the secondary database (210).
8. The system (108) as claimed in claim 6, wherein the signalling query includes one of an attach request, an authentication request, a re-authentication request, and a de-registration request streaming from the UE (102).
9. The system (108) as claimed in claim 6, wherein the secondary database (210) is a geo-redundant database situated remotely from the primary database (208).
10. The system (108) as claimed in claim 6, wherein the querying unit (214) is further configured to: log, a number of the signalling queries transmitted to the primary database (208) without receiving the response from the primary database (208) within the second pre-defined time period; and transmit the subsequent signalling queries to the secondary database (210) in response to the number of the signalling queries transmitted to the primary database (208) crosses a pre-defined threshold count.
11. A User Equipment (UE) (102) comprising of: one or more primary processors (302) communicatively coupled to one or more processors (202) of a system (108), the one or more primary processors (302) coupled with a memory (304), wherein said memory (304) stores instructions which when executed by the one or more primary processors (302) causes the UE (102) to: transmit, a signalling query to the one or more processor (202); and wherein the one or more processor (202) is further configured to perform the steps as claimed in claim 1.
2. A non-transitory computer-readable medium having stored thereon computer- readable instructions that, when executed by a processor (202), causes the processor (202) to: receive, a signalling query from a User Equipment (UE) (102); query, a primary database (208) with the signalling query received from the UE (102); determine, if a response is received from the primary database (208) within a first pre-defined time period; check, if the response is received from the primary database (208) within a second pre-defined time period, wherein the second pre-defined time period being greater than the first pre-defined time period; in response to not receiving the response from the primary database (208) within the second pre-defined time period, query, a secondary database (210) to receive the response; and transmit, a status of response received pertaining to the signalling query from one of the primary database (208) and the secondary database (210).

Description

SYSTEM AND METHOD FOR DATABASE MANAGEMENT FIELD OF THE INVENTION [0001] The present invention relates to serving data access queries in telecommunication networks, more particularly relates to a system and method for database management. BACKGROUND OF THE INVENTION [0002] Modern telecommunications systems have evolved significantly, offering consumers not only telephony capabilities but also access to a wide range of content. The expansion of network capabilities has led to increased interconnectivity and new opportunities for the use of mobile communication devices in various contexts. [0003] In the telecommunications industry, achieving high service availability is very crucial for customer satisfaction. In one example, each customer, upon subscribing to a particular vendor’s services, is provided with subscription data, that may include services includes in the subscription, authentication data, service-related data, operation specific data and the like. In another example, subscriber specific dynamic data is also stored in a database by the service provider. Both types of data are stored in a common database. Typically, service providers maintain a local database to store the subscriber related data. So that, when the subscriber makes a data access query, the data is retrieved from the local database and is served to the customer. [0004] However, the problem arises when the customer makes a query, and the local database is unavailable to cater to the query. There might be an outage due to several reasons, such as flood, earthquake, long power outage, and such, the database might be down and unable to serve the query. Failed transactions due to a primary database failure may result in customer dissatisfaction and inconvenience. [0005] Therefore, there is a need for a solution that will provide an assured continuity with uninterrupted service provision, irrespective of outage of the local database. SUMMARY OF THE INVENTION [0006] One or more embodiments of the present disclosure provide a system and a method for database management. [0007] In one aspect of the present invention, the system for database management is disclosed. The system includes a receiving unit configured to receive a signaling query from a User Equipment (UE). The system further includes a querying unit configured to query a primary database with the signaling query received from the UE. The system further includes a determination unit configured to determine if a response is received from the primary database within a first pre-defined time period. The determination unit is further configured to check if the response is received from the primary database within a second pre-defined time period. The second pre-defined time period being greater than the first pre-defined time period. The querying unit is further configured to query a secondary database to receive the response in response to not receiving the response from the primary database within the second pre-defined time period. The system further includes a transmitting unit configured to transmit a status of response received pertaining to the signaling query from one of the primary database and the secondary database. [0008] In an embodiment, the data present in the primary database is mapped onto the secondary database. [0009] In an embodiment, the signaling query includes one of an attach request, an authentication request, a re-authentication request, and a de -registration request streaming from the UE. [0010] In an embodiment, the secondary database is a geo-redundant database situated remotely from the primary database. [0011] In an embodiment, the querying unit is further configured to log a number of the signaling queries transmitted to the primary database without receiving the response from the primary database within the second pre-defined time period. The querying unit is further configured to transmit the subsequent signaling queries to the secondary database in response to the number of the signaling queries transmitted to the primary database crosses a pre-defined threshold count. [0012] In another aspect of the present invention, the method for database management is disclosed. The method includes the step of receiving a signaling query from a User Equipment (UE). The method further includes the step of querying a primary database with the signaling query received from the UE. The method further includes the step of determining if a response is received from the primary database within a first pre-defined time period. The method further includes the step of checking if the response is received from the primary database within a second pre-defined time period. The second pre-defined time period being greater than the first pre-defined time period. Further, in response to not receiving the response from the primary database within the second pre-defined time period, querying to a secondary database to receive the response. The method further includes the step