1. Home
  2. Relational Databases
  3. Oracle Database Reviews
  4. User Review of Oracle Database
The database for complex and high throughput workloads - Oracle 12
January 24, 2018

The database for complex and high throughput workloads - Oracle 12

Mathias Magnusson | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Reseller

Overall Satisfaction with Oracle Database 12c

It is used throughout my key client's organisation. Currently implementing it with multi-tenant for all development and testing on an EXADATA platform. Next step is to move up production for all databases to 12c too, also on EXADATA.

With multi-tenant we address several problems, one is the ability to get all developers and testers to be on the target platform of EXADATA. Another is to enable rapid deployment of development and testing databases.
  • Virtualized databases - Multi-Tenant is the flagship feature of 12c. It is a wonderful feature, especially in development and testing where everyone wants a copy of exactly how all production databases are structured.
  • Classic Oracle DB stability - it just works.
  • Full featured database beyond pur SQL. AQ, Oracle Text, file watcher, XML, JSON, and so on with all the extra technologies one gets with the platform.
  • The product is complete, but sure there are nice things that could be added. Such as having INSERT be able to write it as column = value instead of first listing columns and then values while having to manually make sure they match up.
  • We ended up on Oracle on EXADATA for this one client as their evaluation told them that that was the only way their systems could deliver the performance needed. Sure a complete rewrite could have optimized it for other platforms, but there was neither time nor money available for that.
As it is a general purpose database, it is hard to see it as less appropriate. But anything requiring just a couple of tables with just a handful of rows would not be the reason for the full complexity of a full-featured database. Same thing with niche solutions where a database specifically for that need exists. But for 99% of all data driven applications, Oracle would be my default choice.