Canada Spends Logo

Explore our Budget 2026 analysis

Grant: Engage Grants Program

University of British Columbia

$24,000.00

Improving the efficiency of network monitoring by database optimization

FY 2009-10

Summary
Organizations of all sizes rely on networks for their operations. Network monitoring is the real-time collection and analysis of network resources, traffic, and capabilities in order to maximize the security, availability, reliability, and performance of network resources and the interconnected systems. Network monitoring in this proposal involves the collection of network traffic data using network monitors, data warehousing, and the analysis and user interface to the data to detect and respond to issues. Network monitoring allows an organization to reduce its network costs, improve performance, and reduce maintenance overhead. This proposal investigates data warehousing optimization for an organization that provides a network monitoring service. The data generated by the network monitors are real-time data streams that must be filtered, archived, and analyzed in real-time. The organization currently uses an open source database system for archiving the data and several optimizations to store and query it efficiently. For each client that uses the network monitoring service, dedicated or virtualized hardware is allocated for data processing. The costs for data processing represent a significant business cost and limit the scalability of the approach. The goal is to improve the organization's data warehousing performance in order to allow for more efficient processing, larger network clients, and reduce the operational hardware costs. These improvements will be realized by technology transfer of research on real-time and stream databases to improve the current system. Undergraduate and graduate students will conduct the research and implementation. The research collaboration will result in potential improvements being proposed and evaluated on company data which will then be implemented in the production system by organization engineers. Improved data warehousing techniques will make this company more profitable and competitive, and allow the technology to be used in larger network installations.
Program
Engage Grants Program
Location
British Columbia, Canada
Recipient Type
Academia
Type
Grant
Source
NSERC's Awards Data

As published

Application id
395246-2009
Name nom
Lawrence, Ramon
Department département
Okanagan - Psychology & Computer Science
Organization id
2
Institution établissement
University of British Columbia
Province en
British Columbia
Province fr
Colombie-Britannique
Country en
CANADA
Country fr
CANADA
Fiscal year exercice financier
2009
Competition year année de concours
2009
Award amount
24000
Program id
EGP
Program nane en
Engage Grants Program
Program name fr
Programme de subventions d'engagement partenariat
Group en
Research partnerships programs
Group fr
Programmes de partenariat
Committee code
1554
Committee name en
Pacific Internal Decision Committee
Committee name fr
Comité de décision interne pour le Pacifique
Area of application code
1207
Area of application group en
Advancement of knowledge
Area of application group fr
Avancement des connaissances
Area of application en
Information, computer and communication technologies
Area of application fr
Technologie de l'information, des ordinateurs et des réseaux de communications
Research subject code
2711
Research subject group en
Information technology
Research subject group fr
Technologie de l'information
Research subject en
Database management
Research subject fr
Gestion de bases de données
Partie
1
Nb partie
1
Application title
Improving the efficiency of network monitoring by database optimization
Keyword
NA
Application summary
Organizations of all sizes rely on networks for their operations. Network monitoring is the real-time collection and analysis of network resources, traffic, and capabilities in order to maximize the security, availability, reliability, and performance of network resources and the interconnected systems. Network monitoring in this proposal involves the collection of network traffic data using network monitors, data warehousing, and the analysis and user interface to the data to detect and respond to issues. Network monitoring allows an organization to reduce its network costs, improve performance, and reduce maintenance overhead. This proposal investigates data warehousing optimization for an organization that provides a network monitoring service. The data generated by the network monitors are real-time data streams that must be filtered, archived, and analyzed in real-time. The organization currently uses an open source database system for archiving the data and several optimizations to store and query it efficiently. For each client that uses the network monitoring service, dedicated or virtualized hardware is allocated for data processing. The costs for data processing represent a significant business cost and limit the scalability of the approach. The goal is to improve the organization's data warehousing performance in order to allow for more efficient processing, larger network clients, and reduce the operational hardware costs. These improvements will be realized by technology transfer of research on real-time and stream databases to improve the current system. Undergraduate and graduate students will conduct the research and implementation. The research collaboration will result in potential improvements being proposed and evaluated on company data which will then be implemented in the production system by organization engineers. Improved data warehousing techniques will make this company more profitable and competitive, and allow the technology to be used in larger network installations.