Amazon Plans To Move Completely Off Oracle Software By Early 2020 (cnbc.com)
Amazon plans to be completely off Oracle's proprietary database software by the first quarter of 2020, reports CNBC. The plans come after the company moved most of its infrastructure internally to Amazon Web Services. From the report: Amazon began moving off Oracle about four or five years ago, said one of the people, who asked not to be named because the project is confidential. Some parts of Amazon's core shopping business still rely on Oracle, the person said, and the full migration should wrap up in about 14 to 20 months. Another person said that Amazon had been considering a departure from Oracle for years before the transition began but decided at the time that it would require too much engineering work with perhaps too little payoff. The primary issue Amazon has faced on Oracle is the inability for the database technology to scale to meet Amazon's performance needs, a person familiar with the matter said. Another person, who said the move could be completed by mid-2019, added that there hasn't been any development of new technology relying on Oracle databases for quite a while.
Oracle can keep circling the drain.
You clearly never asked the DBAs and Sysadmin's who have many years of long and frustrating work bashing their heads against Oracle if they're happy with it. They'll tell you no, but then if you ever get the truth out, "I've got a job for life, this shit is so fragile, they can't fire us."
How do I know? I was a BOFH dealing with about a dozen servers for a mid sized company's Oracle ERP system. They were just RHEL boxes, nothing too special. Generally shit just worked. Stupid simple shit for a Unix sysadmin. I pretty much coasted along for a decade at that job, showed up four hours a day, three days a week. Getting paid $150k for it at that. I pretty much did fuck all at that job. Only reason why I'm not at that job anymore? Company went bankrupt, otherwise I would still be slacking at that place.
So, yes, I was happy with that ERP system, just not for the reason people think you'd be happy with it.
They're moving to non-relational databases, such as S3 and DynamoDB. The problem with relational databases is that they can't scale beyond a single host. This follows from the CAP theorem: Unless you are willing to sacrifice some amount of consistency or availability, you can't have partitions. S3 and DynamoDB support limitless horizontal scaling because they use eventual consistency.
The trade-off with going down the NoSQL route is that you no longer have the concept of transactions, and you have to write your software in a way that will tolerate tables being in an inconsistent state. However, the advantage of this approach is that your service will always scale. Therefore, at Amazon, they encourage you to always use NoSQL, because if you choose a relational database, you're assuming that your software won't have to scale.