|
sureshkallem
Starting Member
India
2 Posts |
 Posted - 11/17/2012 : 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 is
There 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. |
|
Data base architecture for bulk data insertion
