H/S Co-design of Embedded DBMS with High Speed Buffer Support

With the development of ubiquitous computing and ambient intelligence, the requirement of embedding data and evaluating database queries is a growing variety of ultra-light computing devices. In the same time, embedded system and system-on-chip (SoC) architecture are becoming commonly used in computing area, because of the low design cost and extensible architecture. We design a special system called DBoC (database on chip) in our previous paper, in which there is a special core for SQLs running. In this paper, we present a DBoC with high speed buffer support to accelerate the data access.The method used in this paper to accelerate access is that we add a high speed buffer between DBoC and main memory. This method likes a data cache, but the data cache is passive for data access and is not useful in database because the locality in database is not good. on the contrary, our method is active, because we design a powerful BC (buffer controller) for data exchanging and signal transmission. The experiment shows significant efficiency improvement of SQLs in DBoC. The efficiency improvement of create table, drop table, select, insert, delete and update are 30.0%, 28.2%, 57.4%, 23.8%, 59.7% and 55.5% respectively.