Article,
An SMS-SQL based On-board system to manage and query a database
International Journal of Advanced Computer Science and Applications(IJACSA), (2012)
Abstract
Technological advances of recent years have facilitated the use of embedded systems. They are part of our everyday life. Thanks to them, electronic devices are increasingly present in our lives in many forms: Mobile phones, music players and managers have become the essential of modern life. Access to information anywhere at any time is increasingly a daily challenge of embedded system technology. Following an innovative idea, this paper describes an embedded system that can query any database through SMS commands to extend the consultation of data to mobile networks early generations. Based on a UNIX embedded system, the result of this work can serve as a standard consultation of databases through SQL-SMS Gateway which converts an SMS command in an SQL query. This system will open the database to the consultation via mobile without having to expose them to risks of online publication. While in the first part of this article we will discuss the state of the art of multi-agent systems and input systems onboard, the second part presents the architecture of our target system. In the third part we describe in detail the realized prototype. This article ends with a conclusion and an outlook.
