The Porting And Analysis Of Sqlite Database Based On μC/OS-Ⅲ Operating System

Along with the continuous development of embedded technology, traditional dataprocessing method in embedded system will be hard to satisfy user’s needs for rising datamanagement requirement. However, embedded database can solve the shortcomings of dataprocessing in traditional embedded system well. SQLite is an open source, portable,efficient embedded real-time in-memory database, it run in application program, noconfiguration, and as part of its managed program. SQLite database emphasis on portabilityat design time, it has been ported to many embedded platform successfully, and play animportant role in embedded system. The main part works as follows:First, on the basis of consulting relative references, for the problem of data processingin small embedded system mainly based on file, it has some drawbacks such as limited datamanagement ability, bad portability. This paper analyzed SQLite’s characteristics, anddiscussed apply SQLite to small embedded system to solve these deficiencies. Because ofthe extensive application of μC/OS-Ⅲ in small embedded system, this paper also analyzedit’s kernel structure.Second, in order to improve the data processing capacity of software based onembedded and reduce the development difficulties of application software, this paper hasresearched and analyzed SQLite database porting technology based on μC/OS-Ⅲ operatingsystem. According to the theory of software porting, give the method of porting SQLitedatabase to μC/OS-Ⅲ operating system by analyzing SQLite’s architecture and sourcecode. SQLite’s operating system interface consist of mutex, memory allocation and VFSthree subsystems, by configuring or re-writing these parts, porting SQLite to μC/OS-Ⅲsuccessfully.Finally, this paper apply SQLite to greenhouse environment monitor and controlsystem, verify the data management capacity of SQLite in multitask environment, then givethe test results and analyze the performance of the ported database.