An Experimental Evaluation using SQLite for Real-Time Stream Processing

AbstractThe data generated at a very high rate by sensors and RFIDs are required to be handled by continuous queries keeping real time response. Because of its purpose, DSMSs are used in several cases of these large scale systems. On the other hand, sensor terminal systems include lightweight RDBMSs generally in many cases. So if lightweight RDBMSs can handle the high rate data directly, it is convenient for several applications. This paper proposes a speed-up method of stream processing by using the lightweight RDBMS SQLite without any special modifications.