在物联网环境中,大量的传感器产生了海量的数据.这些数据通常都需要写入到数据库中来实现数据的分析与应用.当这些物联网海量传感器数据插入到数据库中的时候,会在存储系统中产生严重的小数据同步写性能瓶颈.针对此问题,本文设计了一种高性能数据库磁盘缓冲队列DCQD(Disk Cache Queue for Database).DCQD在保证物联网采集数据同步写入磁盘,确保不丢失数据的基础上,可以显著优化海量数据插入到数据库中的性能.实验表明,DCQD在物联网应用环境中,可以显著地提高数据采集系统的性能.
In the environment of Internet of Things, data. Usually the generated data needs to be stored a large number of sensors generate huge amounts of in the database to support data analyses and various applications. With respect to insert these huge amounts of sensor data into the database, it will lead to serious performance bottleneck of synchronous writing fragment data in the corresponding storage system. To solve this problem, this paper designs a high-performance buffering queue for database disks named as DCQD (Disk Cache Queue for Database). To ensure the collected data that can be synchro- nously wrote into disk without any data lose, DCQD can significantly optimize the performance on inserting mass data into the database. Experiments show that DCQD can significantly improve the perform- ance of data acquisition system within the environment of Internet of Things.