Which Database to use to save sensor data
-
In my software application, I need to collect data from 64 sensors simultaneously at a frequency of 20KHz and then plot it on a graph with respect to the time axis, additionally save them in the database with the configuration of sensors I made before starting my measurement so that user can retrieve measurement data corresponding to the configuration of sensors at later point of time.
I would be grateful if you please inform me which type of database, I can use to save sensor data with respect to time and configuration data in my application.
According to me, saving sensor data in a relational database, for example, MySQL will be not the right choice in this case, but I would still like to know if there are any points that support using a relational database in this case.Thanks you !!
-
@saurabh162 Do you need a database at all? Do you need a possibility to query data using complex queries?
If not you could also simply write the sensor data into a file. -
@jsulm thank you very much for your quick reply.
We need to develop an application in which the user can give the name of measurement on the GUI to load data related to the configuration of measurement and data from sensors in graphs on our GUI.
So answers to your questions are:
Do you need a database at all?
I do not know. Whether this problem can be solved without a database. As there will be thousands of measurement cycles with different configurations. If I use files to save data then please inform me which file format is best suited:
- To save data from sensors with respect to time?
- To save configuration data of sensors before starting a measurement?
- What would be the best way to link files that have the sensor's configuration information and sensor data?
Do you need the possibility to query data using complex queries?
No.
Please inform me if you need any other information.
-
Hi,
It really depends on how the data you receive is structured or if you will structure it yourself. If they can be properly to put in table like fashion then a SQL based database will be fine. Otherwise, you might want to check the NoSQL databases.
-
@SGaist thank you very much for your reply. I think qt does not have drivers for NoSQL databases and right now I am planning to save configuration data and graph data in text file and will put their names in SQL databases to link both of them.
Please inform me if you do not find my decision right or see any problem with it...Thanks !!
-
@saurabh162 said in Which Database to use to save sensor data:
will put their names in SQL databases to link both of them
Why do you need a SQL database for that? How many such links are you going to have? If not many then you can also store these links in simple files and forget about SQL databases.
-
No, Qt does indeed not have any NoSQL driver bust they usually have a C++ library to use them so that should not be the main driver of your decision.
How fast are your data coming in ?