摘要
SQLite的事务处理机制在写操作密集的应用中会引起频繁擦写Flash,导致Flash过早失效。针对上述问题,通过分析SQLite的事务处理流程及自动提交模式,采用延时提交的方法降低Flash的擦写频率,并将数据分为关键或不可重现数据以及可重现数据,分别进行处理,以保证数据的安全性。
In some applications with intensive writing,Flash becomes invalid earlier than expected if SQLite writes database file too frequently.In order to solve the problem,by analyzing the transaction processing procedure and auto-commit mode of SQLite,this paper uses the method of delay commit to reduce the frequency of erasing and writing Flash.It divides data into the key or un-reproducible data and reproducible data,and treats them with appropriate methods,which ensures the security of data.
出处
《计算机工程》
CAS
CSCD
北大核心
2010年第15期94-96,共3页
Computer Engineering
关键词
事务处理
自动提交
延时提交
数据分级
transaction processing
auto-commit
delay commit
data classification
