Oracle Database, great software but it will cost you.
November 01, 2017
Oracle Database, great software but it will cost you.
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.
- MySQL and PostgreSQL
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.