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 : 14:09:07
|
| I'm looking for better data base architecture/design to insert the >800000 records for day.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,to be store in DB. for that,1.Need to create separate DB to store the collected data,2.Need to be take the back up for every 1-2 minute for the stored data,3.Need to create the separate table for Reporting,issues etc4.I need to create separate DB for alerts like if captured temperature from the sensor is >50 deg then store data in normal dB or if <50 store in other DB.Please suggest the better architecture to design the DBPlease give the better architecture to design DB. |
|
|
|
|
|
Data base architecture for bulk data insertion