Research And Optimization For Embedded Database Based On Linux

With the development of embedded devices, more and more applications are running in them. Therefore, embedded devices are required for processing more data and information. It requires Embedded Databases to store and manage the data. SQLite, as a typical case of Embedded Database, possess some characteristics, such as quick speed of execution, a bit of resource consumption, strong portability, and open source, and so on. SQLite is widely applied in Linux, Windows, Android and IOS and other operating systems. Therefore, it is a key point in the research of the industry to SQLite. Although, SQLite is powerful and widely used, it has some shortcomings and the insufficiency, such as insufficient performance of index mechanism, lack of security mechanism and synchronizing mechanism, etc. Mobile devices such as Android, IOS, and the operating system are based on kernel of Linux. Therefore, if we can improve some characteristics of the SQLite in Linux, we can make better the performance of the data management of these mobile devices.This paper summarizes the research situation of SQLite. And it makes use of the open source SQLite to research and optimize the SQLite from aspects of index mechanism, security mechanism and synchronizing mechanism. Lastly, function testing and performance testing are conducted in the Linux operating system.The results prove the feasibility of the optimization scheme.