Canada Spends Logo

Explore our Budget 2026 analysis

Grant: Discovery Grants Program - Individual

University of British Columbia

$20,000.00

Embedded Databases for the Internet of Things

FY 2020-21

Summary
The Internet of Things connects billions of devices that collect, store, and analyze data about our environment, business and industrial processes, health and activities, and our society. Developing and deploying these devices is a multi-billion dollar industry, and there is a wide diversity of the technologies used and their capabilities. Typically, these devices have very limited hardware resources, and developing software for them is highly customized, time-consuming, and error-prone as software is developed specifically for each hardware platform and application use case. The objective is to research techniques to dramatically reduce the cost and time to develop data collection software for embedded devices and implement and deploy these techniques as open source software for the worldwide community to use. A secondary objective is to deploy and evaluate the data collection systems in industrial and environmental monitoring applications and collaborate with researchers in these domains where the data analysis is critical. The scientific approach is to investigate and evaluate data management techniques that are specifically designed for low-resource, low-power embedded devices that optimize their behavior for hardware limitations and unique features of flash memory. Our previous work has developed LittleD, the smallest, SQL relational database for embedded devices, that runs on as little as 4 KB of memory, IonDB, a key-value store for embedded devices, and novel optimized file systems and overwriting techniques for NOR flash. These technologies and contributions will be fully integrated and expanded to produce the smallest, most energy-efficient database for embedded devices with between 1 and 100 KB of memory and less than 256 KB for code space. There are no systems currently available in this space with the smallest database, SQLite, being too large for these devices. Our goal is for IonDB to be the ubiquitous, open source system for embedded devices like SQLite is for cell phones. The significance of the research is that it addresses a pressing industrial need for databases to work on embedded devices where there is no current system available. The system will make it more efficient to develop and deploy embedded devices. Our research group will continue to work with partners such as the City of Kelowna and vineyards on applications of the system for irrigation management and environmental sustainability as well as other applications in environmental, health, and industrial data collection.
Program
Discovery Grants Program - Individual
Location
British Columbia, Canada
Recipient Type
Academia
Type
Grant
Source
NSERC's Awards Data

As published

Application id
RGPIN-2017-03798
Name nom
Lawrence, Ramon
Department département
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
2020
Competition year année de concours
2017
Award amount
20000
Program id
RGPIN
Program name en
Discovery Grants Program - Individual
Program name fr
Programme de subventions à la découverte - individuelles
Group en
Discovery grants programs
Group fr
Programmes de subventions à la découverte
Committee code
1507
Committee name en
Computer Science
Committee name fr
Sciences informatiques
Area of application code
801
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
Computer software
Area of application fr
Logiciel
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
Installment
inst:4-5
Partie
2
Nb partie
5
Application title
Embedded Databases for the Internet of Things
Keyword
NSERC
Application summary
The Internet of Things connects billions of devices that collect, store, and analyze data about our environment, business and industrial processes, health and activities, and our society. Developing and deploying these devices is a multi-billion dollar industry, and there is a wide diversity of the technologies used and their capabilities. Typically, these devices have very limited hardware resources, and developing software for them is highly customized, time-consuming, and error-prone as software is developed specifically for each hardware platform and application use case. The objective is to research techniques to dramatically reduce the cost and time to develop data collection software for embedded devices and implement and deploy these techniques as open source software for the worldwide community to use. A secondary objective is to deploy and evaluate the data collection systems in industrial and environmental monitoring applications and collaborate with researchers in these domains where the data analysis is critical. The scientific approach is to investigate and evaluate data management techniques that are specifically designed for low-resource, low-power embedded devices that optimize their behavior for hardware limitations and unique features of flash memory. Our previous work has developed LittleD, the smallest, SQL relational database for embedded devices, that runs on as little as 4 KB of memory, IonDB, a key-value store for embedded devices, and novel optimized file systems and overwriting techniques for NOR flash. These technologies and contributions will be fully integrated and expanded to produce the smallest, most energy-efficient database for embedded devices with between 1 and 100 KB of memory and less than 256 KB for code space. There are no systems currently available in this space with the smallest database, SQLite, being too large for these devices. Our goal is for IonDB to be the ubiquitous, open source system for embedded devices like SQLite is for cell phones. The significance of the research is that it addresses a pressing industrial need for databases to work on embedded devices where there is no current system available. The system will make it more efficient to develop and deploy embedded devices. Our research group will continue to work with partners such as the City of Kelowna and vineyards on applications of the system for irrigation management and environmental sustainability as well as other applications in environmental, health, and industrial data collection.