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.
closed as not constructive by joeqwerty, Brent Pabst, Chris S♦ Dec 14 '12 at 19:38
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.
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 (5x9 - 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".
Ah, no, there is a LOT of data no that. Ther are standardized performance tests for that.
|show 1 more comment|