Oracle - Reliable Enterprise Relationship SQL Database
February 12, 2019

Oracle - Reliable Enterprise Relationship SQL Database

Gabriel Samaroo | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Database

The Engineering and Business Intelligence teams use Oracle Database as their primary data store. The Oracle Databases serves as a data warehouse that powers all of our applications. Oracle Database is very reliable and performant. With its many features, it can easily be queried in a SQL client or connected to any application (Java in our case).
  • Great SQL client that allows for advanced querying.
  • Extensive support for stored procedures, functions, materialized views, windowing functions, and other useful SQL operations.
  • Stable. Oracle Database has been around for many years and has a large developer community.
  • Expensive. There are several free alternatives (Postgres, MySQL).
  • More difficult to install and setup than other alternatives (ie: MySQL).
  • Difficult to support and administer (ie: backups).
  • High performing and reliable Database means fewer database problems (we only needed a single DBA).
  • Oracle certifications are fairly common and can be an easy way to filter and identify quality SQL developers. Saves time in the search process.
  • Vast amounts of Oracle community forums and blogs provide easy and accessible support for various issues.
Oracle Database is as good as any of the other relational databases I've used. The main reason why I would personally choose to use MySQL or Postgres over Oracle is that those options are free, and provide the same functionality. Today there are so many options that make it easy to setup and manage a DB (ie: Amazon RDS), so getting a lower costing DB makes a lot of sense to me.
Oracle Database is very efficient and stable. If you have the money to spend and care a lot about security and availability, then Oracle Database can be a great option. If you're a start-up or don't want to pay anything, there are multiple free alternatives like Postgres and MySQL. Oracle also integrates nicely with many other applications and services, so it might be a good solution depending on your particular platform.