Search

EP-4736028-A1 - SYSTEM AND METHOD FOR PROVIDING A CENTRALIZED NETWORK MASTER DATABASE LAKE FOR NETWORK NODES

EP4736028A1EP 4736028 A1EP4736028 A1EP 4736028A1EP-4736028-A1

Abstract

The present invention discloses a method for providing a centralized network master database lake (128). The method receives and stores input data, identifies a plurality of attributes associated with the input data, processes the input data to categorize the input data into a plurality of predefined data categories based on the plurality of attributes, and processes the categorized input data to determine if a record associated with the categorized input data exist in the centralized network master database lake (128). The method (1200) updates the record with the categorized input data when it is determined that the record exists, creating a new record to store the categorized input data into the centralized network master database lake (128) when it is determined that the record does not exist and processing the record to dynamically display the categorized input data.

Inventors

  • BHATNAGAR, AAYUSH
  • BHATNAGAR, PRADEEP KUMAR
  • Sankaran, Sundaresh
  • AMBALIYA, Haresh B
  • Rawat, Sandeep
  • Jadon, Harendra
  • SINGH, VIKRAM

Assignees

  • Jio Platforms Limited

Dates

Publication Date
20260506
Application Date
20240603

Claims (15)

  1. 1. A system (118) for providing a centralized network master database lake (128), the system comprising: a receiving unit (120) configured to receive a plurality of input data from a plurality of data sources (116); a database (124) configured to store the plurality of input data; a processing unit (122) configured to receive the plurality of input data from the database (124); the processing unit (122) is configured to: identify a plurality of attributes associated with the plurality of input data; process the plurality of input data to categorize the plurality of input data into a plurality of predefined data categories based on the plurality of attributes; process the categorized plurality of input data to determine if a record associated with the categorized plurality of input data exists in the centralized network master database lake (128); update the record with the categorized plurality of input data when it is determined that the record exists; create a new record to store the categorized plurality of input data into the centralized network master database lake (128) when it is determined that the record does not exist; and process the records to dynamically display the categorized plurality of input data.
  2. 2. The system (118) as claimed in claim 1, wherein the plurality of input data is categorized as a site related data or as a map related data when a data source from the plurality of data sources is a planning database.
  3. 3. The system (118) as claimed in claim 2, wherein when the plurality of input data is categorized as the site related data, then performing the following steps: preprocessing the site related data; storing the preprocessed site related data in at least one relational database; and storing the preprocessed site related data in the centralized network master database lake (128).
  4. 4. The system (118) as claimed in claim 2, wherein when the plurality of input data is categorized as the map related data, then performing the following steps: preprocessing the map related data; storing the preprocessed map related data in at least one non-relational database; and storing the preprocessed map related data in the centralized network master database lake (128).
  5. 5. The system (118) as claimed in claim 3, further configured to: filter the site related data to get a site list comprising a plurality of site records; determine a modified date and a created date for every site record in the site list; identify a modified site record and a new site record from the site list based on the determined modified date and the determined created date respectively; determine an existing site record from the site related data associated with the identified modified site record; update the determined existing site record with details of the modified site record; and insert the identified new site record in the at least one relational database.
  6. 6. The system (118) as claimed in claim 1, further configured to: categorize the plurality of input data as a workorder data or as a cell data when a data source from the plurality of data sources is a plan to build (P2B) system; determine if the cell data is a cell physical data or a cell level soft data; update the centralized network master database lake (128) with the workorder data and the cell physical data; and update the centralized network master database lake (128) with the cell level soft data when it is determined that a cell associated with the cell level soft data is not active and not present in a network operations support system (OSS).
  7. 7. The system (118) as claimed in claim 1, wherein the plurality of input data is categorized as an event based data or as a periodic based data when a data source from the plurality of data sources is the network OSS.
  8. 8. A method (1200) for providing a centralized network master database lake (128), the method (1200) comprising: receiving (1202) a plurality of input data from a plurality of data sources (116) by a receiving unit (120); storing (1203) the plurality of input data into a database (124); receiving (1204) the plurality of input data from the database (124) by a processing unit (122); identifying (1206) a plurality of attributes associated with the plurality of input data; processing (1210) the plurality of input data to categorize the plurality of input data into a plurality of predefined data categories based on the plurality of attributes; processing (1212) the categorized plurality of input data to determine if a record associated with the categorized plurality of input data exists in the centralized network master database lake (128); updating (1214) the record with the categorized plurality of input data when it is determined that the record exists; creating (1216) a new record to store the categorized plurality of input data into the centralized network master database lake (128) when it is determined that the record does not exist; and processing (1218) the record to dynamically display the categorized plurality of input data.
  9. 9. The method (1200) as claimed in claim 8, wherein the plurality of input data is categorized as a site related data or as a map related data when a data source from the plurality of data sources is a planning database.
  10. 10. The method (1200) as claimed in claim 9, wherein when the plurality of input data is categorized as the site related data, then performing the following steps: preprocessing the site related data; storing the preprocessed site related data in at least one relational database; and storing the preprocessed site related data in the centralized network master database lake (128).
  11. 11. The method (1200) as claimed in claim 9, wherein when the plurality of input data is categorized as the map related data, then performing the following steps: preprocessing the map related data; storing the preprocessed map related data in at least one non-relational database; and storing the preprocessed map related data in the centralized network master database lake (128).
  12. 12. The method (1200) as claimed in claim 10, further comprising: filtering the site related data to get a site list comprising a plurality of site records; determining a modified date and a created date for every site record in the site list; identifying a modified site record and a new site record from the site list based on the determined modified date and the determined created date respectively; determining an existing site record from the site related data associated with the identified modified site record; updating the determined existing site record with details of the modified site record; and inserting the identified new site record in the at least one relational database.
  13. 13. The method (1200) as claimed in claim 8, further comprising: categorizing the plurality of input data as a workorder data or as a cell data when a data source from the plurality of data sources is a plan to build (P2B) system; determining if the cell data is a cell physical data or a cell level soft data; updating the centralized network master database lake (128) with the workorder data and the cell physical data; and updating the centralized network master database lake (128) with the cell level soft data when it is determined that a cell associated with the cell level soft data is not active and not present in a network operations support system (OSS).
  14. 14. The method (1200) as claimed in claim 8, wherein the plurality of input data is categorized as an event based data or as a periodic based data when a data source from the plurality of data sources is the network OSS.
  15. 15. A computer program product comprising a non-transitory computer-readable medium comprising instructions that, when executed by one or more processors, cause the one or more processors to perform a method for providing a centralized network master database lake (128), the method comprising: receiving (1202) a plurality of input data from a plurality of data sources (116) by a receiving unit (120); storing (1203) the plurality of input data into a database (124); receiving (1204) the plurality of input data from the database (124) by a processing unit (122); identifying (1206) a plurality of attributes associated with the plurality of input data; processing (1210) the plurality of input data to categorize the plurality of input data into a plurality of predefined data categories based on the plurality of attributes; processing (1212) the categorized plurality of input data to determine if a record associated with the categorized plurality of input data exist in the centralized network master database lake (128); updating (1214) the record with the categorized plurality of input data when it is determined that the record exists; creating (1216) a new record to store the categorized plurality of input data into the centralized network master database lake (128) when it is determined that the record does not exist; and processing (1218) the record to dynamically display the categorized plurality of input data.

Description

SYSTEM AND METHOD FOR PROVIDING A CENTRALIZED NETWORK MASTER DATABASE LAKE FOR NETWORK NODES RESERVATION OF RIGHTS [0001] A portion of the disclosure of this patent document contains material, which is subject to intellectual property rights such as, but are not limited to, copyright, design, trademark, Integrated Circuit (IC) layout design, and/or trade dress protection, belonging to Jio Platforms Limited (JPL) or its affiliates (herein after referred as owner). The owner has no objection to the facsimile reproduction by anyone of the patent document or the patent disclosure, as it appears in the Patent and Trademark Office patent files or records, but otherwise reserves all rights whatsoever. All rights to such intellectual property are fully reserved by the owner. TECHNICAL FIELD [0002] The present disclosure relates to wireless communications, and specifically to a system and a method for improving network operations by using a centralized network master database lake. BACKGROUND [0003] The following description of related art is intended to provide background information pertaining to the field of the disclosure. This section may include certain aspects of the art that may be related to various features of the present disclosure. However, it should be appreciated that this section be used only to enhance the understanding of the reader with respect to the present disclosure, and not as admissions of prior art. [0004] Typically, in a wireless cellular network, where radiating nodes meant for providing services are deployed in spatially distributed manner targeted for the specific geography. However, managing an entire lifecycle of the network/the node is a challenge due to broadly three reasons: a) scale of deployment, i.e., a large number of nodes are present on a particular big geography, b) multiple phases are involved in a lifecycle of the nodes, ranging from planning, deployment, operations, and decommissioning, and c) lack of availability of a unified platform for observability on the nodes. [0005] Prevalent commercial cellular networks generally offer services through multiple technologies using equipment from various original equipment manufacturers (OEMs). Before commercial readiness, each of the network nodes passes from multiple deployment phases such as initial planning, site survey, construction readiness, installation, commissioning, acceptance test, regulatory submission, and the like. Observability on currently live nodes is available on the OEMs; however, due to the availability of the multiple OEMs, information is not available on a single consolidated platform and is highly distributed across multiple platforms, which acts as a bottleneck for determining complete information. [0006] There is, therefore, a need in the art for an improved mechanism to provide a centralized network master database lake to build a variety of use cases using the information. DEFINITION [0007] As used in the present disclosure, the following terms are generally intended to have the meaning as set forth below, except to the extent that the context in which they are used to indicate otherwise. [0008] The term OSS as used herein, refers to an operational support system. The OSS is the backend information technology infrastructure that allows telecommunication companies and other communication service providers (CSPs) to create, organize, provision, maintain, and manage network services and orders. [0009] The term physical cell identity as used herein, refers to physical cell identity. The PCI is a physical layer cell identifier in 4G long term evolution (LTE) and 5G new radio (NR) used to indicate the physical identity of a cell during the cell selection procedure. PCI is used for downlink synchronization. This makes PCI planning one of the most important steps in 4G LTE and 5G NR network design and construction. [0010] The term TAC as used herein, refers to tracking area code. The TAC consisting of 16 bits. This is an identifier for the tracking area and is unique within a public land mobile network (PLMN). Tracking Area Identifier (TAI): this is a globally unique tracking area identifier, made up of the PLMN ID and the TAC. OBJECTS OF THE PRESENT DISCLOSURE [0011] It is an object of the present disclosure to improve network operations by using a centralized network data master database. [0012] It is an object of the present disclosure to enable integration of planning structure, workorder structure and network operations support systems (OSS) in a single module. [0013] It is an object of the present disclosure to categorize planning structures into site level and map data. [0014] It is an object of the present disclosure to categorize the dataset of Plan to Build (P2B) system into workorder data and cell data. [0015] It is an object of the present disclosure to provide a 360-degree view on a centralized network master database lake using reporting, Business Intelligence (BI) tools and a map view. [0016]