How to save frequent received data in database? -
me , 10 students doing big project need receive temperature info hardware in form av nodes, should uploaded , stored on server. engineers in embedded systems , having minor database knowledge, turning guys.
i want receive info nodes lets say, every 30 seconds. table store info in database become long if store: [nodeid, time, temp] in table. have suggestions how store info in way?
a solution store mentioned period of time , "compromize" somehow matrix of sort? still want able reach old data.
one row every 30 seconds not lot of data. it's 2880 rows per day per node. 1 time designed database had 32 1000000 rows added per day, every day. haven't looked @ while know it's got more 21 billion rows in it.
the thing bear in mind need think how you're going query it, , create sure has appropriate indexes.
have fun!
database database-design
No comments:
Post a Comment