Reference number : GC-2017-Q1-01505, amendment number : , agreement type : G, recipient legal name : Lawrence, Ramon (The University of British Columbia), recipient country : CA, recipient province : nan, recipient city : British Columbia|Colombie-Britannique, recipient postal code : nan, program name english : Discovery Grants Program - Individual, program name french : Programme de subventions à la découverte - individuelles, program purpose english : 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 purpose french : 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., agreement title english : Embedded Databases for the Internet of Things, agreement title french : Embedded Databases for the Internet of Things, agreement number : RGPIN, agreement value : 100000.0, agreement start date : 2017-05-10, agreement end date : nan, description english : nan, description french : nan, expected results english : nan, expected results french : nan, additional information english : Grant or Award spanning more than one fiscal year. (2017-2018 to 2022-2023), additional information french : Subvention ou bourse octroyée s'appliquant à plus d'un exercice financier. (2017-2018 à 2022-2023), owner organization : nserc-crsng, owner organization title : Natural Sciences and Engineering Research Council of Canada | Conseil de recherches en sciences naturelles et en génie du Canada