Since, I am new to Database world, I would like you all to forgive my ignornace and pls pour in your sguuestions and help. thanks in advance!
Objective: To set up a machine ( desktop ) to run a Database ( like SQL Server / Oracle...etctec ) which can log incoming data, that grows to the size of 10MB of Textual Data Files ( each file is about 2Kb) at the end of a single day.
Number of Fields in the Table = 15 (Max).
The Machine that I have: Deaktop PC running,
Win 2k / XP
Processor: 1Ghz Pentium
Is this enough ? We are planning on buying a RAID disk to back up data. How is that going to affect the choice of Database we are going to use ? Do we really need a RAID ? or a fast SCSI disk ?
the amount of traffic you're describing is hardly a concern with the configuration that you have (in fact your ram may be an overkill, but don't worry about it, the more the merrier)
don't worry about raid or scsi (though points given by tampu are all valid). we're talking about a growth of 3.6G a year, at the most. in addition you haven't mentioned your purging requirements, so i think the disk size and its type are very-very fine.
backups? do you disk dumps, then turn around and put them on tape. if you want to demonstrate rapid recovery capabilities, keep retention period on disk for 2 days befor overlaying it.