Need help choosing a Database Server

[kenalex]

At work we have a system that generates records for all calls made on our network. The system has 4 components with each component outputting records into a text file in CSV format. Each component outputs approximately 100,000 records daily.
I am trying to choose a database server where i can store these records so they can view so as get certain statistics about the calls being made ,and also details of the calls when they are requested .So far i have a couple of databases i am looking at such as Postgresql ,Mysql and MS SQL server 2005.

 

[biglebowski]

The majority of call recording vendors use SQL for a very good reason it's stable,reliable, easily expanded and fairly easy to admin. Oracle is a brilliant db if it is configured and managed well. I was sysadmin for securelogix on a system that logged every call made by the US army & air force in europe and amounted to around 2 million records per day. We had 14 oracle db's with advanced replication and had a nightmare getting it working. The only advice I'd give is go with SQL, calculate your requirements and then add 50% on top.

When I was born I was so suprised I didn't talk for 18 months

 

[bookouri]

Oracle now also has a free "entry level" database version so you can take a look at sql server and oracle if you want to evaluate both tracks. You can load some of your csv data into just about anything and see how it performs. MySql, Oracle, Sql Server even Access if you have it available.

 

[BNPMike]

including backup/restore utilities and an uninterruptible power supply."

I don't think you need to back-up/restore something which is only fed from csvs. Just keep the csvs. If you're only reporting on stats or special requests, you don't need a UPS.

Don't jump into cliche solutions. You could easily start by using Jet. You'll having working in about 10 minutes; answering queries in 11, and doing stats by lunchtime. You'll need to partition the data, but that's a good idea anyway.

After that, choose something strategic. You don't need to worry in the slightest about what's stable or how many nodes you can grid it across. (By the way I was doing an Oracle RAC/Grid project ayear ago and it will run across 24 boxes, in fact they've got it up to serveral times that)