嵌入式数据库典型技术SQLite和Berkeley DB的研究

Research on Typical Technologies of embedded database-SQLite and Berkeley DB

与常见的数据库相比,嵌入式数据库具有体积小、功能齐备、可移植性、健壮性等特点,本文分析和比较了典型的嵌入式数据库SQLite和BerkeleyDB。首先从体系结构、子系统间调用关系、任务执行过程等角度对SQLite和BerkeleyDB进行了详细分析,然后重点从数据类型、存储方式、模式、数据库引擎和错误处理及加密功能等方面讨论了SQLite和BerkeleyDB的异同点,最后列举了一个基于ARM—Linux的SQLite应用实例。

Compared with the normal database, the embedded database has some distinct features, such as small volume,necessary functions,portability、robustness and so on. This paper analyses and compare the SQLite with Berkeley DB, including the architecture,relationship among subsystems and the processing execution. And then, the author discusses the difference between the SQLite and Berkeley DB on data type,storage method, mode,VDBE and error management. At last ,there is an example of the SQLite applied on the ARbl--Linux.