Embedded Databases for the Internet of Things

物联网嵌入式数据库

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

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