digoal
2020-03-26
PostgreSQL , IoT
什么样的数据库适合IoT?
Is a database necessary for IoT?
The Internet of Things creates many tedious challenges, especially in the field of database management systems, like integrating tons of voluminous data in real-time, processing events as they stream and dealing with the security of data. For instance, IoT based traffic sensors applied in smart cities would produce huge amounts of data on traffic in real-time.
Databases have a very important role to play in handling IoT data adequately. Therefore, along with a proper platform, the right database is equally important. As IoT operates across a diverse environment in the world, it becomes very challenging to choose an adequate database.
The factors that should be considered before choosing a database for IoT applications are:
IoT场景特色
- Size, scale and indexing
- Effectiveness while handling a huge amount of data
- User-friendly schema
- Portability
- Query languages
- Process modelling and transactions
- Heterogeneity and integration
- Time series aggregation
- Archiving
- Security and cost
The types of data in the Internet of Things are:
数据类型
- RFID: Radio frequency identification
- Addresses/unique identifiers
- Descriptive data for processes, systems and objects
- Pervasive environmental data and positional data
- Sensor data: Multi-dimensional time series data
- Historical data
- Physics models: Models that are templates for reality
- State of actuators and command data for control
PG适合边缘、也适合数据中心. 理由如下:
1、IoT需要一间可以压缩到盒子里的数据工厂。
PG类BSD许可, 无分发风险，轻松嵌入到终端.
2、PG可扩展, 开源的有2000个以上扩展插件， 处理几乎所有场景的数据诉求。
苹果手机是怎么流行起来的, app store起了决定性作用.
3、PG开放接口, 方便扩展, 插件应有尽有: 数据压缩降低成本，GIS, 图处理, 流式计算, JOB, 自动归档, sharding, 机器学习, 相似运算，化学计算，指纹检索，范围类型, 并行计算，跨界数据融合等等. 非常适合IoT
https://opensourceforu.com/2017/05/best-open-source-databases-iot-applications/
https://opensourceforu.com/2018/05/open-source-databases-that-work-best-for-iot/
https://www.quora.com/What-are-suitable-databases-for-IoT
您的愿望将传达给PG kernel hacker、数据库厂商等, 帮助提高数据库产品质量和功能, 说不定下一个PG版本就有您提出的功能点. 针对非常好的提议，奖励限量版PG文化衫、纪念品、贴纸、PG热门书籍等，奖品丰富，快来许愿。开不开森.
