| In the remote monitoring and supervision system of information appliances, it needs to collect and handle plenty of real-time data. In addition, storing and managing various kinds of data needs a background database to support. Because the software and hardware resources of embedded system are limited, traditional enterprise databases such as Oracle, Sybase are swollen conspicuously, which makes them difficult to take effect.Therefore, in this paper, through analyzing the main function and the actual state of current embedded database system synthetically, aiming at the concrete features of embedded devices and combining the actual applied demand in home gateway, we design a embedded database system---MySQLite in Linux, which could store, operate and manage the data of information appliances effectively. We also construct an embedded home gateway---S3C44BOX+uCLinux+MySQLite+Boa based on the database: we design hardware platform focus on embedded microprocessor S3C44BOX, cut down and transplant uCLinux as the embedded OS, apply Common Gateway Interface (CGI) theory, and use MySQLite as the data storing and managing background, to achieve the dynamic interaction among users, embedded web server, gateway application and information application by software programming. The implementation of MySQLite refers to accidence analyzer, syntax analyzer and the optimization of index mechanism and so on. The development process of the system is organized and actualized according to software project. It supports the ACID affair, SQL92 standard subset, integrated with its concrete application and the embedded OS---uCLinux, MySQLite doesn't need unattached running engine, the program calls its relevant API function to realize the access operation directly, thereby simplifying the whole development process of the application, improving the efficiency of access records of home gateway, it can satisfy the requirement of data management of embedded remote monitoring and supervision system. |
PDF Full Text Request