%0 Journal Article
%T SQLite''s SQL Statement Cache Technology<br>SQLite 的SQL 语句高速缓存技术
%A DAI Yu
%A HUANG De-Cai
%A <br>戴昱
%A 黄德才
%J 计算机系统应用
%D 2012
%I 
%X With the development of embedded applications,and the growing complexity of system functions,use of embedded database is increasingly becoming a trend in embedded devices applications.SQLite for its performance and functionality advantages will be widely used in embedded applications.But embedded devices is relatively low CPU processing power,memory capacity is limited,which restricts the performance of SQLite.For these problems,this paper according to the high-speed cache principle to simplify the process of SQL statement execution lexical analysis and syntax analysis,to reduce the time consumption during operation.Experiments show that this method can effectively improve the efficiency of SQL statements implementation,maintaining the availability and reliability of system,to enhance the overall performance of SQLite.
%K embedded database
%K SQLite
%K cache
%K performance optimization<br>嵌入式数据库
%K SQLite
%K 高速缓存
%K 性能优化
%U http://www.alljournals.cn/get_abstract_url.aspx?pcid=5B3AB970F71A803DEACDC0559115BFCF0A068CD97DD29835&cid=8240383F08CE46C8B05036380D75B607&jid=D4F6864C950C88FFCE5B6C948A639E39&aid=57C6AD9B0ADA053756F608A30F7234EB&yid=99E9153A83D4CB11&vid=659D3B06EBF534A7&iid=CA4FD0336C81A37A&sid=DD74772618543076&eid=50BBDFAC8381694B&journal_id=1003-3254&journal_name=计算机系统应用&referenced_num=0&reference_num=4