Based On The Arm-linux Embedded Database And Interface Applications

With the continuous development of embedded technology, the processing ability of embedded hardware has been continuously enhanced. The traditional file-based systems could not satisfy requirements of embedded systems. Many requirements as safer data sharing, better data organization model and more humane application programming interfaces are placed in front of developers. So the embedded database management system (EDBMS) spring up under this background. EDBMS integrate traditional DBMS technology with its own characteristics, by this way, implements convenient and unified data management in embedded devices.The paper takes ARM9 development board and ARM Linux as embedded hardware and operating system for researching platform. Firstly, the SQLite has been successfully applied to target board. And in order to satisfy the data communication and data security requirement, three extra functions namely network communication, user authentication and user access right control has been designed. Secondly, in order to reinforce the range of application, heterogeneous database access interface ODBC and JDBC has been ported to ARM Linux. And by using three kinds of interfaces, develop database application to test the time performance of these three programms.This paper has two innovations. One of which is the implementation of database server based on ARM Linux platform, it aim at protecting embedded platform data not being unauthorized access and simplify the LAN communication application database development; second is database application development methodology using ODBC, JDBC interfaces, which enhance database application system versatility. The main content of the paper is as follows:(1) On the basis of deeply study of SQLite architecture and API interfaces, implement an embedded database server which has data transmission, user authentication, user access control functions. After testing, the server can refuse unauthenticate users, unauthorized users access the database.(2) Analyze common interfaces of accessing heterogeneous database management system such as ODBC, JDBC interface。Successfully apply ODBC, JDBC database application development methodology to ARM embedded platforms.(3) Develop three test programms by using SQLite API, ODBC, JDBC interfaces respectively that can operate common SQL functions. On ARM Linux platform, the test programs has been used to test the performance of SQLite API, ODBC, JDBC interface which provide a reference when choosing embedded application programming interface.