The Research And Application Of Embedded Database Based On Web

The combination of the network, embedded and database technology can greatly enhance the intelligence and the flexibility of the embedded devices. The data on embedded devices can be managed conveniently and effectively if the database system is transplanted into the embedded devices. And the embedded devices could be networked if the Web server is transplanted into it. The users can connect the embedded Web server through the browser to visit the embedded database and ultimately manage the data of the embedded devices by connecting the embedded devices to the Internet. This thesis studies the design of the embedded database and the application of the embedded Web server. The main research work is as follows:1) Design and realize an embedded database system. A miniature embedded database system called MiniSQlite is designed and realized with the C language. As the normal database system, MiniSQlite can create, remove table as well as insert, delete, modify and query the records of the table, etc. Meanwhile it can support the subclass of SQL-92 Standard and supply the application programming interface (API). At the same time, this thesis gives the primary research on encryption system of the embedded database according to the characteristic of the file database system.2) Realize the embedded Web server. Study the theory and design method of the embedded Web server, and the theory of the CGI (Common Gateway Interface). Boa is chosen as the embedded Web server and transplanted into embedded system. Realize the dynamic Web technology with the CGI.3) Build a miniature embedded system. This thesis constructs an embedded system with S3C2410 as hardware platform, embedded Linux as operating system, Boa as embedded Web server, and MiniSQlite as database system. By this means, it realizes the information interaction among the users, embedded Web server and embedded devices.4) Finally develop a miniature application based on this embedded system—train ticket query system. The client can check the basic information of train by PC's browser, and the administrator could implement a series of operations such as inserting, modifying, deleting, backing up and restoring about the basic information of the train tickets after validating the identity.To sum up, firstly, in this thesis, designs an embedded database. Then a miniature embedded system has been built based on the embedded database. Finally embedded Web Server has been transplanted into this system. Thus, the data of embedded database could be managed by browsers remotely.