Grant: Alliance Grants
The University of Western Ontario
$45,000.00
Development of data repository infrastructure to enable Andorix' Smart Operational Support System
FY 2023-24
Summary
The goal of this partnership is to develop and implement Operational Support System (OSS) to manage the Andorix's Operational Technology (OT) Network. In other words, building an IT solution prototype that allows Andorix to control, analyze, manage, and keep track of the services on their network. To achieve this objective, a large-scale central data repository will be designed and developed and be accessible by Andorix data scientists and business analysts through a smart BI dashboard.The benefit of building the OSS is to increase the Andorix's operational efficiency by including modules of:- Billing and usage records- Sales order automation- Inventory control- Reporting automation- Business Intelligence/Analytical- Network management.Having these specific modules provide smart control to Andorix's network infrastructure solutions and ensure an improved user experience. This will drive extra value for the occupant, which translates to increased value for the enterprises in Canada in general and for the building owners in particular.The potential outcomes of this partnership include:- A technical report describing the existing tools used for Andorix's network monitoring, control, analysis, and management.- A data source inventory survey to collect information on and classify Andorix potential data sources.- Documentation on the data extraction process for the data sources identified above.- A comprehensive report on the modern data lake solutions available in the market.- The development of the data lake layers (Raw, Conformed, and Modeled).- A technical report describing the existing Andorix's data warehousing solutions.- A study report outlining the features of the cloud Lakehouse solutions exist in the market. This report determines the solutions that fulfill Andorix's business needs.- The development of the Lakehouse layer of the Andorix's central repository.- A comparison study on the best data analytic tools identifying the key features of each solution based on the Andorix customers' needs.- The development of the BI dashboard portal.
Program
Alliance Grants
Recipient
Location
Ontario, Canada
Recipient Type
Academia
Type
Grant
Source
NSERC's Awards Data
As published
Application id
583412-2023
Name nom
Ouda, Abdelkader AH
Department département
Electrical and Computer Engineering
Organization id
36
Institution établissement
The University of Western Ontario
Province en
Ontario
Province fr
Ontario
Country en
CANADA
Country fr
CANADA
Fiscal year exercice financier
2023
Competition year année de concours
2023
Award amount
45000
Program id
ALLRP
Program name en
Alliance Grants
Program name fr
Subventions Alliance
Group en
RESEARCH PARTNERSHIPS
Group fr
PARTENARIATS DE RECHERCHE
Committee code
96
Committee name en
RPP Internal Decision Cttee
Committee name fr
Cté de décision interne - PPR
Area of application code
802
Area of application group en
Information and communication services
Area of application group fr
Services d'information et de télécommunications
Area of application en
Information systems and technology
Area of application fr
Systèmes d'information et technologie de l'information
Research subject code
2710
Research subject group en
Information technology
Research subject group fr
Information systems design
Research subject en
Technologie de l'information
Research subject fr
Conception de systèmes d'information
Application title
Development of data repository infrastructure to enable Andorix' Smart Operational Support System
Keyword
Cryptography; Cybersecurity; Data Analytics; Data Architecture and Design; Data Networking; Information Security; Multimedia Security; Networking Security
Application summary
The goal of this partnership is to develop and implement Operational Support System (OSS) to manage the Andorix's Operational Technology (OT) Network. In other words, building an IT solution prototype that allows Andorix to control, analyze, manage, and keep track of the services on their network. To achieve this objective, a large-scale central data repository will be designed and developed and be accessible by Andorix data scientists and business analysts through a smart BI dashboard.The benefit of building the OSS is to increase the Andorix's operational efficiency by including modules of:- Billing and usage records- Sales order automation- Inventory control- Reporting automation- Business Intelligence/Analytical- Network management.Having these specific modules provide smart control to Andorix's network infrastructure solutions and ensure an improved user experience. This will drive extra value for the occupant, which translates to increased value for the enterprises in Canada in general and for the building owners in particular.The potential outcomes of this partnership include:- A technical report describing the existing tools used for Andorix's network monitoring, control, analysis, and management.- A data source inventory survey to collect information on and classify Andorix potential data sources.- Documentation on the data extraction process for the data sources identified above.- A comprehensive report on the modern data lake solutions available in the market.- The development of the data lake layers (Raw, Conformed, and Modeled).- A technical report describing the existing Andorix's data warehousing solutions.- A study report outlining the features of the cloud Lakehouse solutions exist in the market. This report determines the solutions that fulfill Andorix's business needs.- The development of the Lakehouse layer of the Andorix's central repository.- A comparison study on the best data analytic tools identifying the key features of each solution based on the Andorix customers' needs.- The development of the BI dashboard portal.
