FORM 2
THE PATENTS ACT, 1970
THE PATENTS RULE 0) 003
COMPLETE SPECIFICATION
DATABASE LAKE FOR NETWORK NODES
APPLICANT
JIO PLATFORMS LIMITED
of Office-101, Saffron, Nr. Centre Point, Panchwati 5 Rasta, Ambawadi, Ahmedabad - 380006, Gujarat, India; Nationality: India
The following specification particularly describes
the invention and the manner in which
it is to be performed

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] It is an object of the present disclosure to be used in a commercial network
having multiple nodes and involving multi-vendor, multi-technology scenarios.
[0017] It is an object of the present disclosure to improve network operations by
creating a centralized network data master database by tapping crucial data from
multiple external sources.
[0018] It is an object of the present disclosure to provide the centralized network
data master database that is used as a base data for empowering features like
network view for sites and coverage for managing the network.
[0019] It is an object of the present disclosure to provide the centralized network
data master database that acts as a platform for performing analytics functions and
building use cases.
[0020] It is an object of the present disclosure to provide various databases in a
single platform and ease development of automation use cases.
SUMMARY

[0021] In an exemplary embodiment, the present invention discloses a system for providing a centralized network master database lake. The system includes a receiving unit configured to receive a plurality of input data from a plurality of data sources. The system includes a database configured to store the plurality of input data. The system includes a processing unit configured to receive the plurality of input data from the database. The processing unit is configured to identify a plurality of attributes associated with the plurality of input data. The processing unit is configured to process, based on the plurality of attributes, the plurality of input data to determine the plurality of data sources associated with the plurality of input data. The processing unit is configured to process the plurality of input data to categorize the plurality of input data into a plurality of predefined data categories. The processing unit is configured to process 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. The processing unit is configured to update the record with the categorized plurality of input data when it is determined that the record exists. The processing unit is configured to create a new record to store the categorized plurality of input data into the centralized network master database lake when it is determined that the record does not exist. The processing unit is configured to process the record to dynamically display the categorized plurality of input data. In an embodiment, the data is getting categorized using data attributes. For example. if the input data contains latitude, longitudes, then the input data is categorized as map related data and if the input data contains site identifiers (IDs), then the input data is categorized into the site related data.
[0022]
[0023] In some embodiments, the plurality of input data is categorized as a site-related data or as a map-related data when the data source from the plurality of data sources is a planning database.
[0024] In some embodiments, when the input data is categorized as the site related data, then performing the following steps preprocessing the site related data, storing the pre-processed site related data in at least one relational database, and storing the pre-processed site related data in the centralized network master database lake.

[0025] In some embodiments, when the input data is categorized as the map related
data, then performing the following steps preprocessing the map related data,
storing the pre-processed map related data in at least one non-relational database,
and storing the pre-processed map related data in the centralized network master
database lake.
[0026] In some embodiments, the system is further configured to filter the site
related data to get a site list comprising a plurality of site records.
[0027] In some embodiments, the system is further configured to determine a
modified date and a created date for every site record in the site list.
[0028] In some embodiments, the system is further configured to 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.
[0029] In some embodiments, the system is further configured to determine an
existing site record from the site related data associated with the identified modified
site record.
[0030] In some embodiments, the system is further configured to update the
determined existing site record with details of the modified site record.
[0031] .
[0032] In some embodiments, the system is further configured to insert the
identified new site record in the at least one relational database.
[0033] In some embodiments, the system is 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.
[0034] In some embodiments, the system is further configured to determine if the
cell data is a cell physical data or a cell-level soft data.
[0035] In some embodiments, the system is further configured to update the
centralized network master database lake with the workorder data and the cell
physical data.
[0036] In some embodiments, the system is further configured to update the
centralized network master database lake 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). In some embodiments, the plurality of input data is categorized as an event-based data or as a periodic based data when the data source is the network OSS.
[0037] In an exemplary embodiment, the present invention discloses a method for providing a centralized network master database lake. The method includes receiving a plurality of input data from a plurality of data sources by a receiving unit. The method includes storing the input data in a database. The method includes receiving the plurality of input data from the database by a processing unit. The method includes identifying a plurality of attributes associated with the plurality of input data. The method includes processing, based on the plurality of attributes, the plurality of input data to determine the plurality of data sources associated with the plurality of input data. The method includes processing the plurality of input data to categorize the plurality of input data into a plurality of predefined data categories. The method includes processing 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. The method includes updating the record with the categorized plurality of input data when it is determined that the record exists. The method includes creating a new record to store the categorized plurality of input data into the centralized network master database lake when it is determined that the record does not exist. The method includes processing the record to dynamically display the categorized plurality of input data.
[0038] In an embodiment, 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.
[0039] In an embodiment, 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 pre-processed site related data in at least one relational database, and storing the pre-processed site related data in the centralized network master database lake.
[0040] In an embodiment, 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 pre-processed map related data in at least one non-relational
database and storing the pre-processed map related data in the centralized network
master database lake.
[0041] In an embodiment, the method further comprising filtering the site related
data to get a site list comprising a plurality of site records.
[0042] In an embodiment, the method further comprising determining a modified
date and a created date for every site record in the site list.
[0043] In an embodiment, the method further comprising 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.
[0044] In an embodiment, the method further comprising determining an existing
site record from the site related data associated with the identified modified site
record.
[0045] In an embodiment, the method further comprising updating the determined
existing site record with details of the modified site record.
[0046] In an embodiment, the method further comprising inserting the identified
new site record in the at least one relational database.
[0047] In an embodiment, the method 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.
[0048] an embodiment, the method further comprising determining if the cell data
is a cell physical data or a cell level soft data.
[0049] In an embodiment, the method further comprising updating the centralized
network master database lake with the workorder data and the cell physical data.
[0050] In an embodiment, the method further comprising updating the centralized
network master database lake 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).
[0051] In an embodiment, 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.

BRIEF DESCRIPTION OF THE DRAWINGS
[0052] In the figures, similar components and/or features may have the same
reference label. Further, various components of the same type may be distinguished
by following the reference label with a second label that distinguishes among the
5 similar components. If only the first reference label is used in the specification, the
description is applicable to any one of the similar components having the same first
reference label irrespective of the second reference label.
[0053] The diagrams are for illustration only, which thus is not a limitation of the
present disclosure, and wherein:
10 [0054] FIG. 1A illustrates a broad level architecture of a centralized network master
database lake, in accordance with an embodiment of the disclosure.
[0055] FIG. 1B illustrates a system architecture for providing a centralized network
master database lake, in accordance with an embodiment of the disclosure.
[0056] FIG. 1C illustrates a network architecture for providing a centralized
15 network master database lake, in accordance with an embodiment of the disclosure.
[0057] FIG. 2 illustrates an ingestion process for ingesting data from a planning
database structure, in accordance with an embodiment of the disclosure.
[0058] FIG. 3 illustrates a subprocess for preprocessing site data, in accordance
with an embodiment of the disclosure.
20 [0059] FIG. 4 illustrates a subprocess for preprocessing map data, in accordance
with an embodiment of the disclosure.
[0060] FIG. 5 illustrates an ingestion process from Plan to build (P2B) system in
accordance with an embodiment of the disclosure.
[0061] FIG. 6 illustrates an ingestion process from the network operations support
25 systems (OSS) structures, in accordance with an embodiment of the disclosure.
[0062] FIG. 7 illustrates a logic for tagging a node, in accordance with an
embodiment of the disclosure.
[0063] FIG. 8 illustrates an exemplary use case scenario showing a reporting
wizard tool inside a web application to fetch the data, in accordance with an
30 embodiment of the disclosure.
9

[0064] FIG. 9 illustrates a dashboard created on datasets from the centralized
network master database lake, in accordance with an embodiment of the disclosure.
[0065] FIG. 10 illustrates a map showing site and coverage view, in accordance
with an embodiment of the disclosure.
5 [0066] FIG. 11 illustrates an exemplary computer system in which or with which
embodiments of the present disclosure may be implemented.
[0067] FIG. 12 illustrates an exemplary flow diagram for a method for providing a centralized network master database lake, in accordance with an embodiment of the disclosure. 10
LIST OF REFERENCE NUMERALS
100A – Centralized network master database lake architecture
100B- System architecture
100C- Network architecture
15 116- Data sources
118- System
120- Receiving unit
122- Processing unit
124- Database
20 126- Interfacing unit
128- Centralized network master database lake
130- gNodeB
132- User equipment (UE)
134- Network
25 200 – Flow Diagram
300 – Flow Diagram
400 – Flow Diagram
500 – Flow Diagram
600 – Flow Diagram
30 700 – Flow Diagram
800- An exemplary reporting wizard tool
10

900- An exemplary dashboard
1000- An exemplary map showing site and coverage view
1100- A computer system
1120 – Bus
5 1130 – Main Memory
1140 – Read Only Memory
1150 – Mass Storage Device
1160 – Communication Port
1170 – Processor
10 1200- Flow Diagram
DETAILED DESCRIPTION
[0068] In the following description, for the purposes of explanation, various
specific details are set forth in order to provide a thorough understanding of
15 embodiments of the present disclosure. It will be apparent, however, that
embodiments of the present disclosure may be practiced without these specific details. Several features described hereafter can each be used independently of one another or with any combination of other features. An individual feature may not address all of the problems discussed above or might address only some of the
20 problems discussed above. Some of the problems discussed above might not be
fully addressed by any of the features described herein.
[0069] The ensuing description provides exemplary embodiments only, and is not intended to limit the scope, applicability, or configuration of the disclosure. Rather, the ensuing description of the exemplary embodiments will provide those skilled in
25 the art with an enabling description for implementing an exemplary embodiment.
It should be understood that various changes may be made in the function and arrangement of elements without departing from the spirit and scope of the invention as set forth. [0070] Specific details are given in the following description to provide a thorough
30 understanding of the embodiments. However, it will be understood by one of
ordinary skill in the art that the embodiments may be practiced without these
11

specific details. For example, circuits, systems, networks, processes, and other
components may be shown as components in block diagram form in order not to
obscure the embodiments in unnecessary detail. In other instances, well-known
circuits, processes, algorithms, structures, and techniques may be shown without
5 unnecessary detail in order to avoid obscuring the embodiments.
[0071] Also, it is noted that individual embodiments may be described as a process which is depicted as a flowchart, a flow diagram, a data flow diagram, a structure diagram, or a block diagram. Although a flowchart may describe the operations as a sequential process, many of the operations can be performed in parallel or
10 concurrently. In addition, the order of the operations may be re-arranged. A process
is terminated when its operations are completed but could have additional steps not included in a figure. A process may correspond to a method, a function, a procedure, a subroutine, a subprogram, etc. When a process corresponds to a function, its termination can correspond to a return of the function to the calling function or the
15 main function.
[0072] The word “exemplary” and/or “demonstrative” is used herein to mean serving as an example, instance, or illustration. For the avoidance of doubt, the subject matter disclosed herein is not limited by such examples. In addition, any aspect or design described herein as “exemplary” and/or “demonstrative” is not
20 necessarily to be construed as preferred or advantageous over other aspects or
designs, nor is it meant to preclude equivalent exemplary structures and techniques known to those of ordinary skill in the art. Furthermore, to the extent that the terms “includes,” “has,” “contains,” and other similar words are used in either the detailed description or the claims, such terms are intended to be inclusive—in a manner
25 similar to the term “comprising” as an open transition word—without precluding
any additional or other elements.
[0073] Reference throughout this specification to “one embodiment” or “an embodiment” or “an instance” or “one instance” means that a particular feature, structure, or characteristic described in connection with the embodiment is included
30 in at least one embodiment of the present invention. Thus, the appearances of the
phrases “in one embodiment” or “in an embodiment” in various places throughout
12

this specification are not necessarily all referring to the same embodiment. Furthermore, the particular features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.
[0074] The terminology used herein is for the purpose of describing particular
5 embodiments only and is not intended to be limiting of the invention. As used
herein, the singular forms “a,” “an,” and “the” are intended to include the plural forms as well, unless the context clearly indicates otherwise. It will be further understood that the terms “comprises” and/or “comprising,” when used in this specification, specify the presence of stated features, integers, steps, operations,
10 elements, and/or components, but do not preclude the presence or addition of one
or more other features, integers, steps, operations, elements, components, and/or groups thereof. As used herein, the term “and/or” includes any and all combinations of one or more of the associated listed items. [0075] The disclosed system and method are applicable to 2G, 3G, 4G, 5G, 6G
15 technologies, and beyond all generations of mobile technology with multiple bands
and carriers of telecom operators. The disclosed system and method facilitate the creation of a centralized network master database lake to improve network operations and may be implemented in any commercial network involving multi-vendor, multi-technology scenarios. The centralized network master database lake
20 may be used as a base data for empowering other features such as network view for
sites and coverage for managing the network. The centralized network master database lake may be integrated with all types of management systems (MS), workorder systems and any other planned databases. The centralized network master database lake may take feed from a geographical information system (GIS)
25 which is a planning database, a site workorder application, and all other available
network MSs. The feeds may be used to keep all information up to date at one common platform. The centralized network master database lake is further used to build a variety of use cases such as centralized network site layers, reporting and dashboard visualizations. Information gathered on the centralized network master
30 database lake is required to track pre-on Air stages for efficient tracking.
13

[0076] The disclosed system and method facilitate the provision of a centralized
network master database for improving network operations and enabling other
automation use cases by enabling planning and deployment of the latest attributes
from operations support systems (OSS). Further, the disclosed system and method
5 discloses a mechanism on how datasets may be divided and grouped together. In
addition, the disclosed system and method discloses an abstract model so that all external systems may be integrated. Also, the disclosed system and method creates an inhouse web portal for a reporting framework and provides an integrated open-source tool for advanced business information (BI) activities.
10 [0077] FIG. 1A illustrates a broad-level architecture (100A) of the centralized
network master database lake (108) in accordance with an embodiment of the disclosure. Typically, operators use a variety of tools and platforms which store network information at different stages. The input stage is categorized into three different categories. The first category is a planning database structure (102) that
15 usually contains information related to nominal planning such as a nominal
identifier (ID), search ring, initial candidate list, final candidate list, planned coordinate, planned solution (small cell, macro cell), planned backhaul, deployment phase, and all administrative boundaries details. The second category is a Plan to Build (P2B) database system (104). Once the nominal is finalized and is suitable to
20 go for a site built, then all deployment related tasks are tracked in the P2B system.
This involves capturing information for different site milestones such as “installation”, “commissioning”, “acceptance test”, “cluster tests”, and the like. Also, all physical parameters and planned cell configurations are maintained in the P2B system. The network OSS (106) refers to a controller of all live sites. In any
25 original equipment manufacturer (OEM) deployment, all nodes are grouped and
controlled by one master or group of masters for the purpose of operations and management. Once the site is up and radiating, then the network OSS may give visibility on all site/cell level parameters through key performance indicators (KPIs) and configuration parameters. An operator uses multi-vendor radio nodes,
30 so all OEMs related structures are put under this category. These systems provide
live information on radiating sites in the network. Further, the centralized network
14

5

master database lake (108) leverages the latest performance events and configures events to maintain the site status and other attributes such as cell identifier (ID), PCI, tracking area code (TAC), and the like.
[0078] The next category includes a centralized network master database lake (108) structure (centralized database lake). This structure basically collects, filters, transforms, and stores the attributes from the multiple systems to form a centralized network master database lake. Table 1 includes collected exemplary key attributes.

Data Category

Attribute Name

External Source Type

Geographical Details

• State
• Maintenance point (MP) Name
• Geographical Circle Name
• Lattitude
• Longitude

Planning Database

Project Details

• Phase
• Planned Band
• Planned Connectivity

Planning Database

Electrical Infrastructure Details

Civil Infrastructure • Site Type P2B Systems
Details • name Infrastructure provider (IP)
• Tower Type
• Tower Structure Type
• Tower High
• Tower Wind Load
P2B Systems
• Rack
• Switched-mode power supply
15

(SMPS)
• Battery
• Diesel generator (DG)
• Earthing
• Electrical board (EB)
(Sanctioned Load)
Infrastructure Details • eNodeB Hardware -
CDU/RDU/ remote radio head
(RRH)/SMPS
• Internet service provider
(ISP) Router - CSS/AG1
• Long term evolution (LTE)
Antenna Model, Height, azimuth
• MV Antenna - Size, Height,
Azimuth P2B Systems
OSS Details • Cell equipped status
• Cell parameters such as cell
ID, PCI, TAC, RC power, etc. Network OSS

5
10

Table 1: Collected exemplary key attributes [0079] The enriched data in the centralized network master database lake may be potentially used for a variety of use cases. One of the sample use cases is that of a map view of sites and coverage (110). Once the data is available in the centralized network master database lake (108), the same is rendered for providing an updated network view. Another sample use case is that of a reporting framework. Here all datasets may be exported by the user from a reporting portal (112) (wizard) in the web application. The next sample use case is that of performing advanced analytics through business intelligence (BI) tools (114). Any BI platform may be integrated with the centralized network master database lake (108).

16

[0080] FIG. 1B illustrates a system architecture (100B) for providing a centralized
network master database lake, in accordance with an embodiment of the disclosure.
[0081] In an aspect, the system (118) may include a receiving unit (120), a
processing unit (122), a database (124), an interfacing unit (126), and a centralized
5 network master database lake (128). The system (118) may be connected to a
plurality of data sources (116). The receiving unit (120) is configured to receive a plurality of input data from the plurality of data sources (116). The database (124) is configured to store the plurality of input data (e.g., site related data and map related data, etc). The centralized network master database lake (128) is updated
10 with all the incoming data in real-time to keep all information up to date on one
common platform. The centralized network master database lake (128) is updated with the plurality of cell-level attributes. The processing unit (122) may be implemented as one or more microprocessors, microcomputers, microcontrollers, digital signal processors, central processing units, logic circuitries, and/or any
15 devices that process data based on operational instructions. Among other
capabilities, the processing unit (122) may be configured to fetch and execute computer-readable instructions stored in a memory of the system (118). The memory may be configured to store one or more computer-readable instructions or routines in a non-transitory computer readable storage medium, which may be
20 fetched and executed to create or share data packets over a network service. The
memory may comprise any non-transitory storage device including, for example, volatile memory such as random-access memory (RAM), or non-volatile memory such as erasable programmable read only memory (EPROM), flash memory, and the like.
25 [0082] In an embodiment, the system (118) may include the interfacing unit (126).
The interfacing unit (126) may comprise a variety of interfaces, for example, interfaces for data input and output devices (I/O), storage devices, and the like. The interfacing unit (126) may facilitate communication through the system (118). The interfacing unit (126) may also provide a communication pathway for one or more
30 components of the system (118).
17

[0083] FIG. 1C illustrates a network architecture (100C) for providing a centralized
network master database lake, in accordance with an embodiment of the disclosure.
[0084] Referring to FIG. 1C, the network architecture (100C) may include a user
equipment UE (132) and a gNodeB (130) (e.g. a network node). In 5G networks,
5 gNodeB stands for “Next Generation Node B”. The gNodeB is essentially the
equivalent of the eNodeB in LTE (4G) networks. The gNodeB is the base station component in the 5G radio access network (RAN) responsible for radio communication with the UE. A person of ordinary skill in the art will appreciate that the terms “computing device(s)” and “user equipment” may be used
10 interchangeably throughout the disclosure. Although a single UE (132) is depicted
in FIG. 1C, however, any number of the UEs may be included without departing from the scope of the ongoing description.
[0085] In an embodiment, the UE (132) may include smart devices operating in a smart environment, for example, an Internet of Things (IoT) system. In such an
15 embodiment, the UE (132) may include, but is not limited to, smart phones, smart
watches, smart sensors (e.g., mechanical, thermal, electrical, magnetic, etc.), networked appliances, networked peripheral devices, networked lighting system, communication devices, networked vehicle accessories, networked vehicular devices, smart accessories, tablets, smart television (TV), computers, smart security
20 system, smart home system, other devices for monitoring or interacting with or for
the users and/or entities, or any combination thereof. A person of ordinary skill in the art will appreciate that the UE (132) may include, but is not limited to, intelligent, multi-sensing, network-connected devices, that can integrate seamlessly with each other and/or with a central server or a cloud-computing system or any
25 other device that is network-connected.
[0086] In an embodiment, the UE (132) may include, but is not limited to, a handheld wireless communication device (e.g., a mobile phone, a smart phone, a tablet device, and so on), a wearable computer device (e.g., a head-mounted display computer device, a head-mounted camera device, a wristwatch computer device,
30 and so on), a Global Positioning System (GPS) device, a laptop computer, a tablet
computer, or another type of portable computer, a media playing device, a portable
18

gaming system, and/or any other type of computer device with wireless
communication capabilities, and the like. In an embodiment, the UE (132) may
include, but is not limited to, any electrical, electronic, electro-mechanical, or an
equipment, or a combination of one or more of the above devices such as virtual
5 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, the UE (132) may include one or more in-built or externally coupled accessories including, but not limited to, a visual aid device such as a camera, an audio aid, a microphone, a keyboard, and input devices
10 for receiving input from the user (102) or the entity such as touch pad, touch enabled
screen, electronic pen, and the like. A person of ordinary skill in the art will appreciate that the UE (132) may not be restricted to the mentioned devices and various other devices may be used. [0087] The UE (132) may communicate with the system (118), through a network
15 (134). In an embodiment, the network (134) may include at least one of a Second
Generation (2G), Third Generation (3G), Fourth Generation (4G) network, a Fifth Generation (5G) network, Sixth Generation (6G) and beyond or the like. The network (134) may enable the user equipment (132) to communicate with other devices in the network architecture (100C) and/or with the system (118). The
20 network (134) may include a wireless card or some other transceiver connection to
facilitate this communication. In another embodiment, the network (134) may be implemented as or include any of a variety of different communication technologies such as a wide area network (WAN), a local area network (LAN), a wireless network, a mobile network, a Virtual Private Network (VPN), the Internet, the
25 Public Switched Telephone Network (PSTN), or the like. The UE (132) may be
communicatively coupled with the network (134). The communicatively coupling comprises of receiving, from the UE, a connection request by the network, sending an acknowledgment of the connection request to one or more network elements, and transmitting a plurality of signals in response to the connection request.
30 [0088] FIG. 2 illustrates an ingestion process for ingesting data from the planning
database structure, in accordance with an embodiment of the disclosure. As is
19

illustrated, the ingestion process is the process used for ingesting the data from
planning database structure (for example, geographical information system (GIS)).
[0089] In an aspect, at 202, a planning system provides the data that is to be
indigested. This results in producing broadly two types of data. First is site-related
5 information (data), which is in a structured format and may be stored in a relational
database. Second is map data produced by the GIS and includes data such as
administrative boundaries for state, district, cluster, and point of interest (POI) data,
and the like. All such datasets are pre-processed and stored in appropriate (non¬
relational) databases.
10 [0090] In an aspect, at 204, the data provided by the planning system is checked to
see if the data is site-related data; if yes, then at 206, the site data is pre-processed. [0091] In an aspect, at 208, the pre-processed data is saved to the relational databases.
[0092] In an aspect, at 210, the data is further stored in a centralized network master
15 database lake.
[0093] In an aspect, at 212, the data provided by the planning system is checked if the data is a map data. For example, map data may be polygon data, point of interest (POI) data, or polyline data.
[0094] In an aspect, at 214, if step 212 is affirmative (yes), then the map data is pre-
20 processed.
[0095] In an aspect, at 216 the pre-processed map data may get stored in non-relational databases that is further stored at the centralized network master database lake.
[0096] FIG. 3 illustrates a subprocess for preprocessing site data (300), in
25 accordance with an embodiment of the disclosure.
[0097] In an aspect, at 302, a filter is applied to the site data to obtain the site list for deployment scope.
[0098] In an aspect, at 304, for every record of the site list, determine a modified
date and a created date.
30 [0099] In an aspect, at 306, it is checked if a new record is identified by the created
date.
20

[0100] In an aspect, at 306, if a new record is identified by the created date, then the record of the site list is inserted at the relational database.
[0101] In an aspect, at 310, it is checked if the existing record is modified only i.e.,
identified by modified date.
5 [0102] In an aspect, at 312, when the existing record is modified i.e., identified by
modified date, then the existing records with details (such as planned coordinates, deployment scope, candidate list, final candidate etc) are updated.
[0103] In an aspect, at 314 when the existing record is not modified then it is concluded that there are no changes in common records then at 316, no action is
10 taken.
[0104] FIG. 4 illustrates a subprocess (400) for preprocessing map data, in accordance with an embodiment of the disclosure.
[0105] In an aspect, at 402, for every map data (i.e., boundary data, POI data, or polylines data), created, modified, and deleted map objects are identified.
15 [0106] In an aspect, at 404, TILEID is mapped to every map object for efficient
map visualization use cases. The TILEID is determined using a plurality of available libraries.
[0107] FIG. 5 illustrates an ingestion process (500) from the P2B system in accordance with an embodiment of the disclosure. The P2B system is configured to
20 manage input data that is categorized into work order data and cell data. In an
aspect, the workorder data may include workorder related details of the site data. Every attribute is either site related, or cell related. After a node related input data is received from the planning structure, if for that site, a deployment process starts, data for that node may start appearing in the P2B systems. In an aspect, all the input
25 data from the P2B system may be categorized into two parts:
a) Workorder details (data): This is mainly a site level data. For one site
identifier (ID), there is one workorder and that workorder contains multiple tasks such as “Installation”, “Commissioning”,” Acceptance”, etc. Such details are exclusively present in any P2B system, so it is optimal to keep all such attributes
30 under separate logical grouping.
21

b) Cell level parameters (data): The cell level parameters comprise physical
attributes such as tilt, azimuth, antenna model, and height, and soft attributes such
as PCI, RC Power, TAC, CellID, Mobile country code (MCC), Mobile network
code (MNC), Absolute radio frequency channel number (ARFCN). While physical
5 parameters come exclusively from the P2B system, but soft parameters come from
the network OSS structure as well. So, logic needs to be applied for such soft parameters to decide the final source of the same attribute if available from both systems (i.e., P2B system and network OSS). [0108] According to FIG. 5, at 502, the input data from the P2B system is checked
10 if it is a workorder data, if yes, at 504, the workorder data is updated to the
centralized network master database lake. At 506, when 502 is not affirmative, it is checked if the data is a cell physical data, if yes, then an update to centralized network master database lake is performed. However, at 508, when 506 is not affirmative, it is checked if the data is a cell level soft data; if yes, then at 510, it is
15 checked if the cell is live and present in network OSS. At 512, if 510 is affirmative,
then the parameters from the P2B system are not updated since the same set of parameters may be available from the network OSS. However, when 510 is not affirmative, then the cell soft data is updated to the centralized network master database lake.
20 [0109] FIG. 6 illustrates an ingestion process from the network OSS structures
(600), in accordance with an embodiment of the disclosure. The network OSS (or EMS) refers to a controller of all live sites. In any OEM deployment, all nodes are grouped and controlled by one master or group of masters for the purpose of operations and management. Once the site is up and radiating, then the network
25 OSS may give visibility on all site/cell level parameters through KPIs and
configuration parameters. A node that may belong to any OEM may have thousands of parameters, and fetching all the parameters from the network OSS in real time may cause increased processing on the network OSS as well as on the client system. To avoid this, a key set of parameters and their required frequency is selected. The
30 input data can be event-based data or periodic-based data. At 602, for the event-
based data, any event of node addition, deletion, up, or down is sent in real-time to
22

the centralized network master database lake data. At 604, a logic is applied on the
node details received from the EMS to mark it as ONAIR or Non radiating. At 606,
the marked node details are updated to the centralized network master database
lake. At 608, when the input data is periodic data, then cell-level parameters such
5 as CellID, PCI, TAC, etc, are read on a periodic basis and are updated to the
centralized network master database lake. Thus, the centralized network master database lake gets enriched on a periodic basis with all the input data.
[0110]
a) Real time required fields: Node up status, Node down status, Trigger if
10 node is created in the EMS, Trigger if node is deleted in the EMS. The presence of
these real time inputs keeps centralized network master database lake up to date with respect to the node status. Further, in an aspect, an additional logic may get applied on raw input data from the OSS to derive the correct node status.
b) Non-Real time inputs (on a periodic basis): Attributes such as CELLID,
15 PCI, TAC, node IP, hostname, virtual local area network (VLAN) details, etc., are
part of the non-real-time categories of inputs. The centralized network master database lake gets enriched on a periodic basis with all the inputs.
[0111] FIG. 7 illustrates a logic (700) for tagging the node as ONAIR and NONRADIATING, in accordance with an embodiment of the disclosure. As is
20 illustrated, at 702, if node status = up for consecutive live_days, then
live_days_threshold (e.g., admin controlled) may be set to ‘n’. In an aspect, ‘n’ may be equal to 1. In an aspect at 704, the node is marked as ONAIR. Further, at 706, once a node is tagged as ONAIR if that node is not up for the last consecutive nonradiating_days, then the nonradiating_days _threshold (e.g., admin controlled)
25 may be set to ‘m’. In an aspect ‘m’ may be equal to 30 and at 708, the node is
marked as NONRADIATING.
[0112] In an embodiment, the following are the disclosed database selections
approach of the centralized network master database lake:
• SITE LEVEL TABLES – Relational databases used to store the site level
30 details such as coordinate, address, geography tagging such as circle, city, village,
morphology, etc.
23

• BAND LEVEL TABLES– Relational databases used to store band level
details such as number of cells in that band, workorder detail if present band wise,
etc.
• CELL LEVEL PM TABLES– Relational databases are used to store the
5 daily traffic carrying status of every cell.
• CELL LEVEL CONFIG TABLES– Relational databases are used to store cell level soft parameters received from CM.
• GEOSPATIAL DATA – Non-Relational databases used to store boundaries such as circle boundary, state boundary, cluster boundary, etc.
10 [0113] FIG. 8 illustrates an exemplary use case scenario (800) showing a report
wizard tool inside a web application to fetch the data, in accordance with an embodiment of the disclosure. The reports and dashboard have a “Report wizard” where the reports can be seen under “My reports”. The dashboard having an option to create a new report that further having a report engine having select option for
15 “4G or “5G” reports and “Report measure” and “Report category” options.
Enriched data in the centralized network master database lake may be potentially used for a variety of use cases. In an aspect, the report wizard mat includes a “Module search”. [0114] In an aspect, one of the use cases is that of a reporting framework. Here all
20 datasets may be exported by the user from a report wizard in the web application.
[0115] In an aspect, next use case is that of performing advanced analytics through the BI tools. As is shown in FIG. 9 is a dashboard (900) created on datasets from the centralized network master database lake, in accordance with an embodiment of the disclosure. Any Business Intelligence (BI) platform may be integrated with
25 the centralized network master database lake. Further, supersets are integrated for
doing analytics on the centralized network master database lake. The dashboard has details of the reports where either a value can be selected or typed. A selection may be made on details such as "Owner”, “Created by”, “Status”, “Favorite”, and “Certified” etc. A search may be made on “Snapshot” (e.g., 4G macro sites, Wi-Fi,
30 5G site summary etc.). Further, details such as “Title” “Modified by” (e.g., name
of the person)”, “Status” (e.g., Published/Draft)”, “Modified by” (e.g., number of
24

days/months, 2 days ago, a month ago etc), "Created by” (e.g., name of the person)”, owners etc is also provided in the dashboard.
[0116] FIG. 10 illustrates the map (1000) showing site and coverage view, in
accordance with an embodiment of the disclosure. Once the data is available in the
5 centralized network master database lake, the same is rendered for providing an
updated network view. The platform includes multiple layers such as “Sites”. When “Outdoor” under “Sites” is selected a plurality of options such as “Approved nominal”, Planned”, On Air, Off Air are available for further selection. Further, other multiple layers such as “Indoor”, “Prediction layer”, “Measured layer”,
10 “Hybrid layer”, “Analytics, “Topologies” and “Locations and Boundaries” are also
available for the selection.
[0117] The disclosed system and method facilitate to categorize the planning datasets into the site level and the map data and is used to categorize the dataset from P2B system into Workorder data and Cell data. Further, is performed
15 classification of all external systems into three domains i.e., the planning, the
deployment and the network OSS. In addition, is provided a 360-degree view on the database centralized network master database lake using reporting, the BI tools and the map view. In an embodiment, the data is getting categorized using data attributes. For example. if the input data contains latitude, longitudes, then the input
20 data is categorized as map related data and if the input data contains site identifiers
(IDs), then the input data is categorized into the site related data.
[0118] The disclosed system and method enable the creation of a centralized network master database lake by selecting the most crucial data from external sources, which allows the implementation with minimum resources by providing
25 all key datasets in a single platform to an engineer thereby easing out development
of other automation use cases.
[0119] As may be appreciated, the disclosed system and method may be used by internal radio-access network (RAN) teams directly or indirectly. Apart from front end direct user, creation of such centralized network master database lakes eases
30 out development work for other features, which requires up to date network
25

information. The centralized network master database lake may be used for external clients, if required.
[0120] FIG. 11 illustrates an exemplary computer system 1100 in which or with
which embodiments of the present disclosure may be implemented. As shown in
5 FIG. 11, the computer system 1100 may include an external storage device 1110, a
bus 1120, a main memory 1130, a read-only memory 1140, a mass storage device 1150, communication port(s) 1160, and a processor 1170. A person skilled in the art will appreciate that the computer system 1100 may include more than one processor and communication ports. The processor 1170 may include various
10 modules associated with embodiments of the present disclosure. The
communication port(s) 1160 may be any of an RS-232 port for use with a modem-based dialup connection, a 10/100 Ethernet port, a Gigabit or 10 Gigabit port using copper or fiber, a serial port, a parallel port, or other existing or future ports. The communication port(s) 1160 may be chosen depending on a network, such a Local
15 Area Network (LAN), Wide Area Network (WAN), or any network to which the
computer system 1100 connects.
[0121] The main memory 1130 may be random access memory (RAM), or any other dynamic storage device commonly known in the art. The read-only memory 1140 may be any static storage device(s) e.g., but not limited to, a Programmable
20 read only memory (PROM) chips for storing static information e.g., start-up or
basic input/output system (BIOS) instructions for the processor 1170. The mass storage device 1150 may be any current or future mass storage solution, which can be used to store information and/or instructions. Exemplary mass storage device 1150 includes, but is not limited to, Parallel Advanced Technology Attachment
25 (PATA) or Serial Advanced Technology Attachment (SATA) hard disk drives or
solid-state drives (internal or external, e.g., having Universal Serial Bus (USB) and/or Firewire interfaces), one or more optical discs, Redundant Array of Independent Disks (RAID) storage, e.g. an array of disks. [0122] The bus 1120 communicatively couples the processor 1170 with the other
30 memory, storage, and communication blocks. The bus 1120 may be, e.g. a
Peripheral Component Interconnect (PCI)/PCI Extended (PCI-X) bus, Small
26

Computer System Interface (SCSI), Universal Serial Bus (USB), or the like, for
connecting expansion cards, drives, and other subsystems as well as other buses,
such a front side bus (FSB), which connects the processor 1170 to the computer
system 1100.
5 [0123] Optionally, operator and administrative interfaces, e.g. a display, keyboard,
joystick, and a cursor control device, may also be coupled to the bus 1120 to support
direct operator interaction with the computer system 1100. Other operator and
administrative interfaces can be provided through network connections connected
through the communication port(s) 1160. Components described above are meant
10 only to exemplify various possibilities. In no way should the aforementioned
exemplary computer system 1100 limit the scope of the present disclosure.
[0124] FIG. 12 illustrates an exemplary flow diagram for a method 1200 for
providing a centralized network master database lake.
[0125] At step 1202, the method discloses receiving a plurality of input data from
15 a plurality of data sources.
[0126] At step 1203, the method discloses storing the input data in a database.
[0127] At step 1204, the method discloses receiving the plurality of input data from
the database.
[0128] At step 1206, the method discloses identifying a plurality of attributes
20 associated with the plurality of input data.
[0129] At step 1208, the method discloses processing, based on the plurality of
attributes, the plurality of input data to determine the plurality of data sources
associated with the plurality of input data.
[0130] At step 1210, the method discloses processing the plurality of input data to
25 categorize the plurality of input data into a plurality of predefined data categories.
[0131] At step 1212, the method discloses processing 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.
[0132] At step 1214, the method discloses updating the record with the categorized
30 plurality of input data when it is determined that the record exists.
27

[0133] At step 1216, the method discloses creating a new record to store the categorized plurality of input data into the centralized network master database lake when it is determined that the record does not exist.
[0134] At step 1218, the method discloses processing the record to dynamically
5 display the categorized plurality of input data. In an aspect, once the data is
available in the centralized network master database lake, the same is rendered for
providing an updated network view. Another sample use case is that of a reporting
framework. Here all datasets may be exported by the user from a reporting portal
(wizard) in the web application. The next sample use case is that of performing
10 advanced analytics through business intelligence (BI) tools. Any BI platform may
be integrated with the centralized network master database lake.
[0135] In an exemplary embodiment, the present invention discloses a system for
providing a centralized network master database lake. The system comprising a
receiving unit configured to receive a plurality of input data from a plurality of data
15 sources. The system comprising a database configured to store the plurality of input
data. The system comprising a processing unit configured to receive the plurality
of input data from the database. The processing unit is configured to identify a
plurality of attributes associated with the plurality of input data; process, based on
the plurality of attributes, the plurality of input data to determine the plurality of
20 data sources 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. Process 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. Update the record with the categorized plurality of
25 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 when it is determined that the record does not exist and process the record to dynamically display the categorized plurality of input data.
[0136] In some embodiments, the plurality of input data is categorized as site-
30 related data or as map-related data when a data source from the plurality of data
sources is a planning database.
28

[0137] In some embodiments, when the plurality of input data is categorized as site-
related data, then performing the following steps: preprocessing (e.g., filtering) the
site-related data, storing the pre-processed site-related data in at least one relational
database, and storing the pre-processed site-related data in the centralized network
5 master database lake.
[0138] In some embodiments, when the plurality of input data is categorized as the map related data, then performing the following steps: pre-processing the map-related data, storing the pre-processed map-related data in at least one non-relational database, and storing the pre-processed map-related data in the
10 centralized network master database lake.
[0139] In some embodiments, the system is further configured to filter the site related data to get a site list comprising a plurality of site records.
[0140] In some embodiments, the system is further configured to determine a modified date and a created date for every site record in the site list.
15 [0141] In some embodiments, the system is further configured to 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.
[0142] In some embodiments, the system is further configured to determine an existing site record from the site related data associated with the identified modified
20 site record.
[0143] In some embodiments, the system is further configured to update the determined existing site record with details of the modified site record. [0144] In some embodiments, the system is further configured to insert the identified new site record in the at least one relational database.
25 [0145] In some embodiments, the system is 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.
[0146] In some embodiments, the system is further configured to determine if the cell data is cell physical data or cell-level soft data.
29

[0147] In some embodiments, the system is further configured to update the centralized network master database lake with the workorder data and the cell physical data.
[0148] In some embodiments, the system is further configured to update the
5 centralized network master database lake 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).
[0149] In some embodiments, 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
10 sources is the network OSS.
[0150] In an exemplary embodiment, the present invention discloses a method for providing a centralized network master database lake. The method includes receiving a plurality of input data from a plurality of data sources by a receiving unit. The method includes storing the input data in a database. The method includes
15 receiving the plurality of input data from the database by a processing unit. The
method includes identifying a plurality of attributes associated with the plurality of input data. The method includes processing, based on the plurality of attributes, the plurality of input data to determine the plurality of data sources associated with the plurality of input data. The method includes processing the plurality of input data
20 to categorize the plurality of input data into a plurality of predefined data categories.
The method includes processing 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. The method includes updating the record with the categorized plurality of input data when it is determined that the record
25 exists. The method includes creating a new record to store the categorized plurality
of input data into the centralized network master database lake when it is determined that the record does not exist. The method includes processing the record to dynamically display the categorized plurality of input data. [0151] In an embodiment, the plurality of input data is categorized as a site related
30 data or as a map related data when a data source from the plurality of data sources
is a planning database.
30

[0152] In an embodiment, 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 pre-processed site related data in at least one relational database
and storing the pre-processed site related data in the centralized network master
5 database lake.
[0153] In an embodiment, 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 pre-processed map related data in at least one non-relational
database and storing the pre-processed map related data in the centralized network
10 master database lake.
[0154] In an embodiment, the method further comprising filtering the site related
data to get a site list comprising a plurality of site records.
[0155] In an embodiment, the method further comprising determining a modified
date and a created date for every site record in the site list.
15 [0156] In an embodiment, the method further comprising 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.
[0157] In an embodiment, the method further comprising determining an existing
site record from the site related data associated with the identified modified site
20 record.
[0158] In an embodiment, the method further comprising updating the determined
existing site record with details of the modified site record.
[0159] In an embodiment, the method further comprising inserting the identified
new site record in the at least one relational database.
25 [0160] In an embodiment, the method 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.
[0161] an embodiment, the method further comprising determining if the cell data
is a cell physical data or a cell level soft data.
30 [0162] In an embodiment, the method further comprising updating the centralized
network master database lake with the workorder data and the cell physical data.
31

[0163] In an embodiment, the method further comprising updating the centralized network master database lake 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).
[0164] In an embodiment, 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.
[0165] While the foregoing describes various embodiments of the invention, other and further embodiments of the invention may be devised without departing from the basic scope thereof. The scope of the invention is determined by the claims that follow. The invention is not limited to the described embodiments, versions, or examples, which are included to enable a person having ordinary skill in the art to make and use the invention when combined with information and knowledge available to the person having ordinary skill in the art.
ADVANTAGES OF THE PRESENT DISCLOSURE
[0166] The present disclosure facilitates to improve network operations by using a
centralized network data master database.
[0167] The present disclosure enables the integration of planning structure, work
order structure, and network OSS in a single module.
[0168] The present disclosure categorizes planning structures into site level and
map data.
[0169] The present disclosure is used to categorize Plan to Build (P2B) system into
workorder data and cell data.
[0170] The present disclosure provides a 360-degree view of a centralized network
master database lake using reporting, Business Intelligence (BI) tools, and a map
view.
[0171] The present disclosure is used in a commercial network having multiple
nodes and involving multi-vendor, multi-technology scenarios.

[0172] The present disclosure improves network operations by creating a
centralized network data master database by tapping crucial data from multiple
external sources.
[0173] The present disclosure provides the centralized network data master
database that is used as a base data for empowering features like network view for
sites and coverage for managing the network.
[0174] The present disclosure provides the centralized network data master
database that acts as a platform for performing analytics functions and building use
cases.
[0175] The present disclosure provides various databases in a single platform and
ease development of automation use cases.

WE CLAIM:
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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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.