Embedded Database SQLite Research And Visualization Tools Design

With the rapid development of related technologies such as microelectronics and network communications,embedded products with intelligent,miniaturized and portable features have penetrated into all aspects of our life,such as smart phones,car GPS,home smart video,television Boxes and other products.These products generally have poor computing power and small data storage capacity,but often have to deal with larger amounts of data,requiring a database system that matches the characteristics of the embedded device.However,the traditional database is often used in industrial servers or large storage devices,and has a comprehensive set of security measures to ensure its smooth operation.It is very important and necessary to study embedded database technology because of its high cost,high space requirement and much higher hardware requirement.Therefore,the traditional database can not be used by the embedded device and the research of embedded database technology is very important and necessary.In this paper,the concept,characteristics,key technologies,classification and research status of embedded data are introduced,and a simple comparison of the mainstream open source embedded database is made.Then,taking SQLite database management system as an example,its performance and characteristics are introduced simply,and the architecture of SQLite is analyzed in detail,The implementation mechanism of SQLite interface,compiler,VDBE engine and storage layer is deeply studied.Secondly,a SQLite visualization tool is designed to realize database operation basicly.With VS2010 as the development environment,the basic operations of database table creation,deletion and table based on MFC library are realized.In the process of functional design,the method of sub-module design is used.In the aspect of interface design,according to the system function design,Windows interface design standard and the principle of interface design,a simple and friendly interface is designed.Then,based on the software testing theory,the test cases are designed and tested in detail.In order to solve the problems of code redundancy and API calling,the code is refactored and re-tested and the software functions are validated to ensure the stability and reliability of the tool.