I have a background as an embedded programmer (avrs and pics) and I have recently been taksed by my employer to build a data acquisition network that (i)Reads data from sensors and transmits them over 3G to a (ii) database and then displays them on a PC.
Acquiring the data is no problem, using a database is not something that I am a total noob at (I had a mysql primer back in college) and making the software to display said data on a PC is no problem (c#).
What I have no clue at is how to automatically interface the data acquisition units with the remote database. I know how to compose queryes etc but on a local system, how can I "remotely and automatically" execute them? I used TCP sockets many times in the past to interface with 3rd parties sending messages so I think that might be the way but I m otherwise in the dark. What is called the piece of software that runs on a server along a database and makes possible to query the latter thru a (-I suppose-) TCP connection? Is there some open source thing for this?
The amount of data is very small, around 100 unit transimmitng 10 measures and hour.
Many thanks!
Aucun commentaire:
Enregistrer un commentaire