Leading RDBMS with Significant Market Share
September 21, 2017
Leading RDBMS with Significant Market Share
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle Database
Most of the clients that I have worked on use Oracle Database 11g. The Oracle databases are used to house Enterprise Resource Planning (ERP) data. The client uses the Oracle 11i or R12 Enterprise Application which has Oracle Database as its underlying base to hold the data. This helps the customer to seamlessly integrate between the application and the database. Oracle Database 11g being robust and scalable in nature fits all sizes of business enterprises ranging from small and medium scale enterprises to bigger enterprises.
- Oracle Database is based on PL/SQL Programming construct which helps the developer or the administrator of the database to have a quick get to know about the product, as most programmers would have basic knowledge of PLSQL programming.
- From the end user's perspective as the enterprise application and Oracle databases have seamless integration amongst them, it is hardly a concern to the end user of the enterprise application.
- It also helps with seamless integration of an ETL tool like Informatica etc., with the Oracle Database as we already have inbuilt drivers for Oracle with most of the ETL tools available in the market.
- With Oracle DB2 Licensing there is a limit on database size - say up to 15 GB etc.
- Slowly but steadily Oracle is pushing their customers to move from 11g to the 12c version which has more powerful functionality. But with the higher version, the pricing also burns your pocket.
- The upgrade which quite often comes up with Oracle products is a pain for the administrator. They need to bundle all the changes and come up with one package instead of frequent updates for bug fixes and new functionalities.
- For most of our clients, it has been a value for money proposition as enough due diligence has been done before selecting the product.
- Most of our clients were using Oracle enterprise applications so it makes more sense to use Oracle Database, as it helps in seamless integration across products.
- Enough documentation and competent consultants are available in the market at a competitive rate, which makes the product cost-effective for maintenance.
If you are not working on ad-hoc queries or you already know the queries in advance and the database size is less than 600 TB it is advisable to go for Oracle. But if you have requirements which will have a significantly larger database then one should go with Hadoop or Teradata Database. With Teradata Database, the tools used are not robust and user-friendly as compared to Oracle.