Oracle Database 12c works for me
September 18, 2019

Oracle Database 12c works for me

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

Overall Satisfaction with Oracle Database 12c

The database is being used across the entire organization. It is used to host all of the data for our homegrown software solutions. In addition, it is used to host our data warehouse and integrate the data between all of our enterprise applications. Oracle Database is used along with PL/SQL interfaces and Oracle SOA Suite.
  • Oracle Database 12c makes the development of REST Endpoints through the use of ORDS extremely easy, making for faster development
  • Oracle Database 12c makes it easy to store and retrieve data as well as integrate different systems and keep data flowing between systems.
  • Oracle Database 12c has a very strong PL/SQL interface which makes writing the business logic into the back end of our applications fast and easy.
  • Oracle Database 12c has some bugs which sometimes make it difficult to tune queries and improve the performance of our applications.
  • Oracle Database 12c has a very robust and complicated interface which makes it powerful but difficult to train new employees on how to use.
  • PL/SQL is a proprietary programming language for Oracle Database which makes it difficult to find knowledgeable job candidates fresh out of college.
  • Oracle Database 12c has had a very positive impact on our ability to build strong and robust custom applications in house without the need to come up with our own methods of data storage and management.
  • Oracle Database 12c has the strongest user interface of any database I have worked with and continuously is improving its strength with the addition of support for JSON and XML type objects in the database.
  • Oracle Database 12c is sometimes very heavy and DBA intensive, but the benefits far outweigh the costs, which we need to spend on DBA support for enabling security and access features.
MySQL does not provide anywhere near the user interface or features that Oracle Database 12c provides. Building REST endpoints on MySQL is a much more challenging process and integrating it with a web app is much more complicated than building an ORDS endpoint within the Oracle Database 12c. MySQL is great for a small company who is not looking to spend a ton of money on Oracle Database 12c
Oracle database 12C is very well suited for an enterprise-level company that needs reliable, redundant database technology that is very powerful. It is not as well suited for a small company which cannot afford to have a large budget for information technology and cannot afford to host their own IT software on-site.