與常見的數(shù)據(jù)庫(kù)相比，嵌入式數(shù)據(jù)庫(kù)具有體積小、功能齊備、可移植性、健壯性等特點(diǎn)，本文分和比較了典型的嵌入式數(shù)據(jù)庫(kù)SQLite和Berkeley DB。首先從體系結(jié)構(gòu)、子系統(tǒng)間調(diào)用關(guān)系、任務(wù)執(zhí)行過(guò)程等角度對(duì)SQLite和Berkeley DB進(jìn)行了詳細(xì)分析，然后重點(diǎn)從數(shù)據(jù)類型、存儲(chǔ)方式、模式、數(shù)據(jù)庫(kù)引擎和錯(cuò)誤處理及加密功能等方面討論了SQLite和Berkeley DB的異同點(diǎn)，最后列舉了一個(gè)基于ARM—Linux的SQLite應(yīng)用實(shí)例。
關(guān)鍵詞: SQLite、Berkeley DB、SQL、虛擬數(shù)據(jù)庫(kù)引擎（VDBE）
Abstract：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 ARM—Linux.
Keywords：SQLite，Berkeley DB，SQL，VDBE