3 ms·
I'm not a database person, but I wonder what makes Oracle databases so much superior to free alternatives like, say, Postgres, that companies put up with the en
by adrianN 11y ago
I'm not a database person, but I wonder what makes Oracle databases so much superior to free alternatives like, say, Postgres, that companies put up with the enormous costs and hostile attitude.
Can somebody explain why it makes sense from a business perspective to use Oracle products?
- endymi0n 11y ago1. Like SAP or Salesforce, they don't sell to sane IT guys, but to enterprise executives that are far away from ops and just let them deal with it. 2. Ass insurance. You pay enormous amounts of money for the knowledge there's a dependable fix to the database in X hours, should there be a problem. 3. Certifications and tutorials. How do you know a DBA is any good if you don't know about databases yourself? 4. Permissions. Oracle let's you shield the database like no other competitor can. If you need DBA's that can't look into the database or character-level permissions because you don't trust the people you work with, Oracle is an enterprises' wet dream.
- imglorp 11y ago> You pay enormous amounts of money for the knowledge there's a dependable fix to the database in X hours That's a problem right there. If you're paying ludicrous or plaid amounts, say 7 or 8 figures, then X might be reasonable and you'll get a decent team to work with you and fix your issue. However, if you're only paying enormous amounts, then X becomes "whenever they feel like it", and a fix specifically requested for you is out of the question. You have to wait for the next patch cycle and hope your bug is fixed in the next patch. Anybody you talk to will begin every sentence with "I'm sorry you're having this problem," and they will be offshore. Source: my company used a shitty db which oracle bought to squash competition and drive you towards the Big O product. We paid only 6 figures for support and got nothing useful. Then they bought Sun, which we were also into, and the same thing happened to us.
- bni 11y agoLegacy systems hardcoded to Oracle; Bought from 3rd parties that companies cannot change to work with other databases. The people bribed to buy Oracle are probably long gone from the company.
- threeseed 11y agoI got downvoted in a previous thread about this but I've worked at quite a few Oracle shops now: 1. PostgreSQL and most open source software is unsupported in most countries. There are a few mom + pop shops (usually one or two guys) who will provide support but usually without SLAs, 24/7, escalation support, legal frameworks etc. Support is for me generally useless but managers love them and CTOs expect them. 2. For every 1 PostgreSQL DBA there are 20 Oracle ones. 3. The costs of your database is nothing compared to the cost of your employees (money) or the cost of your project failing (politically). So if your best PostgreSQL DBA quits and you can't find another one or can't get training from the vendor then you're in trouble. None of this is specific to Oracle. It's open source versus "enterprise" software. The trend is towards using enterprise flavours of open source software e.g. Hadoop (Hortonworks/Cloudera), Cassandra (Datastax), MongoDB (MongoDB).
- marcosdumay 11y ago> For every 1 PostgreSQL DBA there are 20 Oracle ones. And only one has any idea what he's doing. It's the MSCE effect, where incompetent people flock to the platform where they most easily can get a a job, and a trusted certificate where you must only recall some answers is a great tool for them.
- mcherm 11y agoWhen we first began using Oracle DB extensively Postgres was not in a state where it could have handled our needs. Now we have existing systems that work on Oracle. It would be extremely expensive to change that -- both in money, and in risk, and in developer time. New apps are not being built on Oracle DB.