Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sureshkallem
Starting Member
2 Posts |
 Posted - 2012-11-17 : 08:00:18
|
| I'm looking for better data base architecture to insert the >800000 records for day and very new to DB.My requirement isThere is a more then >500 sensors continuously send the data for every second(24/7). I need to collect the data from sensors,1.To be store in data base,2.Need to be take the back up for every 1-2 minute,3.Need to create the separate table for Reporting,4.I need to create separate DB for alerts like if captured temperature is >50 deg then store data in normal dB or if <50 store in alert DB. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-11-17 : 11:02:17
|
| Do you have a starting point? Is there something you can post , which we can review?How do the sensors connect ? is there an app - using ODBC? or some other method?Are they just writing to one table? Is the data summarised and purged?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
Data base architecture for bulk data insertion