Embedded Databases for the Internet of Things

物联网嵌入式数据库

• 批准号: RGPIN-2017-03798
• 负责人: Lawrence, Ramon
• 金额: $ 1.46万
• 依托单位: University of British Columbia
• 依托单位国家: 加拿大
• 项目类别: Discovery Grants Program - Individual
• 财政年份: 2020
• 资助国家: 加拿大
• 起止时间: 2020-01-01 至 2021-12-31
• 项目状态: 已结题
• 来源: https://www.nserc-crsng.gc.ca/ase-oro/Details-Detailles_eng.asp?id=710535
• 关键词: Embedded; Databases; Internet; Things

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.

物联网连接了数十亿台设备，这些设备收集、存储和分析有关我们的环境、商业和工业流程、健康和活动以及我们的社会的数据。开发和部署这些设备是一个数十亿美元的行业，所使用的技术及其功能五花八门。通常，这些设备的硬件资源非常有限，并且为它们开发软件是高度定制化的、耗时的，而且容易出错，因为软件是专门为每个硬件平台和应用程序用例开发的。 其目标是研究技术，以极大地降低开发嵌入式设备数据收集软件的成本和时间，并将这些技术作为开放源代码软件实施和部署，供全球社区使用。第二个目标是在工业和环境监测应用中部署和评估数据收集系统，并在数据分析至关重要的这些领域与研究人员合作。 科学的方法是调查和评估专门为低资源、低功耗嵌入式设备设计的数据管理技术，这些技术针对闪存的硬件限制和独特功能优化其行为。我们之前的工作已经开发出了适用于嵌入式设备的最小的SQL关系数据库Litted、运行在仅4 KB内存上的IonDB、用于嵌入式设备的键值存储IonDB以及用于NOR闪存的新颖的优化文件系统和覆盖技术。这些技术和贡献将被完全整合和扩展，以产生最小、最节能的嵌入式设备数据库，内存在1到100 KB之间，代码空间不到256 KB。目前在该领域中没有可用的系统，其最小的数据库SQLite对于这些设备来说太大了。我们的目标是让IonDB成为无处不在的、开源的嵌入式设备系统，就像SQLite用于手机一样。 这项研究的意义在于，它解决了工业上迫切的需求，即在当前没有可用的系统的情况下，数据库可以在嵌入式设备上工作。该系统将使开发和部署嵌入式设备变得更加高效。我们的研究小组将继续与基洛纳市和葡萄园等合作伙伴合作，研究该系统在灌溉管理和环境可持续性方面的应用，以及在环境、健康和工业数据收集方面的其他应用。