Design And Implement Of An Embedded Database Management System Sqlite

With the wide application and popularization of embedded systems, data management for embedded condition has become an important issue in development of system. At the same time, with the developing of information, mobile and multimedia technology, and being used to embedded system, single file system can not meet the needs of users and applications to the massive data management. Therefore, the database which is used to embedded system is brought out.In this paper, the concept, character, class, application and development of embedded database management system is described firstly. And then based on SQLite, its systematic structure is analyzed. Its relevant grammar, in-line function and the interface layer which comprises large numbers of API are designed. Then, the key technology of SQLite is researched in this paper. And on the basis of it, work principle of VDBE is intensively analyzed. The functional assignment and organizational form of B-tree are researched, and the B-tree algorithm for table structure and index structure is designed. Finally, the paper compiled SQLite on Windows and Linux to implement a embedded database management system.