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.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Data base architecture for bulk data insertion

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 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.

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
Go to Top of Page
   

- Advertisement -