I need to build a DB where new Data from around 15,000 separate computers will be loaded in DB every minute. Data should be refined and stored in another table. Data need to be archived every 6 hours. Around 1000 users will access data at a time (worst case).
Now where will I start from? Is there any special requirements for this sort of database? How to make a stable database design for the above requirements?
Please suggest me tutorials, special cases to remember , example database structure etc.