Oracle Database, great software but it will cost you.
November 01, 2017

Oracle Database, great software but it will cost you.

Anonymous | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Database

Oracle database is used as our main data storing facility. It is integral in all facets of our business.
  • Oracle queries are very fast as compared to some of the other relational databases I've worked with.
  • Oracle provides a very expressive and powerful programming language for functions, stored procedures, and packages.
  • The ability to group functions and procedures together into a package is also very convenient.
  • The biggest con is the price tag, even a small instance of Oracle Database can be very pricey.
  • Oracle provides query components outside of the ANSI standard which are great for fine tuning and optimization, but make it nearly impossible to port your Oracle instance over to another RDBMS.
  • Backups and Data migrations to another server are non trivial.
  • The decision to use Oracle Database at our company has had a negative impact on our company in my opinion. The licensing is very expensive and the same result could be achieved with a more cost effective RDBMS.
Oracle Database wins out over MySQL and PostgreSQL in terms of speed and feature set. Oracle supports a larger amount of the ANSI SQL standard and is in most cases noticeably faster in terms of querying.
In a scenario where large amounts of data need to be stored indefinitely and queried in a timely manner and the people/company involved have the funding to be able to purchase an Oracle database license without going bankrupt, I would recommend Oracle DB.