Oracle Database, A Big Database with Big Features.
November 08, 2017

Oracle Database, A Big Database with Big Features.

Louis Marceau | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Database

In previous employments I have used Oracle Databases in various scenarios. I developed applications and tools which mined data that was in Oracle Databases. Development test environments which I have previously used were backed by Oracle Databases. As well, I have supported security applications which were also backed by Oracle Databases.
  • As expected out of an enterprises level database, Oracle DB supports wide availability to application development, through database connection options whether it be by a direct or cloud connection.
  • Oracle DB can support distributed applications, which provides support to cloud based users and application. As well as large data sets needed in data warehousing which is great for data mining.
  • Oracle DB may not be the best choice for every application or business. Oracle has a high price point and if you are not taking advantage of the enterprise level features, high users count, or big data - Oracle DB may not be the best choice. To this end, Oracle Database Lite, PostgreSQL or another DB may be a better choice. Personally, I have not heard much of Oracle Database Lite - most people think of Oracle DB as the big player and do not consider it or hear about it for smaller uses.
  • Oracle Database Lite may be limited to mobile architecture. A slimmed down version of Oracle DB with core DB features to compete in smaller server applications would be greatly desired.
  • The main positive ROI I saw while using Oracle was in data mining. I previously worked at a location where data was collected over years and years but not utilized. This was all stored in an Oracle Database. Once the we started mining that data and writing tools to mine the data - we never had any issue with database performance.
IF someone was looking for an enterprise level database which supports a wide range of development languages, interfaces, big data support, advanced database features, and needs more database support than something like PostgreSLQ could offer, I would point them towards Oracle DB. The big hold back on recommending Oracle DB is the attached price tag.