If I was planning on choosing a database management system and know that the data needs to be available as close to 100% as possible and that it needs to scale as well as possible, is there a “best” database management system for that at this time? This assumes that I am not looking at other factors such as cost. I’m having such a hard time comparing different DBMS (such as Oracle, Microsoft SQL Server, MySQL) and looking to see if there is a single one that outperforms the other. I think an answer is because there is no research that exists to do this comparison. Does anyone know otherwise? Thanks.
Answer
is there a “best” database management system for that at this time?
Oracle Exadata. Hands down. We used the last generation in my second last project on a 3 instance full autoamtic replaction system with each insatnce having5 mondes, 21.000gb of storage and it flew- that was the smallest setup they sold, btw., cost more than a quarter million USD per instance. We used that with a 100% uptime requirement (5×9 – 99.999) and double redundancy did it, especially as the replication was over 10km in 2 data centers with a 10g fiber link dedicated to the database server.
You can easily scale that to 100.000gb with storage nodes reaching a million IOPS per storage node with an all SSD configuration. THe price will approach a million per instance then. ORacle sold like 1000 systems last year, we took 3.
The reason they fly is that they have some ery non-standard hardware (infiniband – still new in many data centers) and are selling optimized hardware to go with the software – super appliance, and “money does not matter”.
I think an answer is because there is no research that exists to do this comparison.
Ah, no, there is a LOT of data no that. Ther are standardized performance tests for that.
Attribution
Source : Link , Question Author : O_O , Answer Author : TomTom
