Oracle ... the real database system.
June 13, 2016
Oracle ... the real database system.
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle Database
Oracle database is used by our entire organization. It solves various issues. It gives the options for any enterprise of cloud solutions. It addresses complex challenges with integrated solutions across diverse environments. More importantly the Oracle Database supports any reporting tool built on top of it. The Oracle Database also provides global support.
- Personally I use Oracle database in our environment with SAP applications. The database has made some great infrastructure updates to support SAP applications without any issues.
- Oracle database has table and Index partitioning that reduces the memory usage and CPU workload.
- Oracle database is now cloud based for accelerated analytical performance. With updated security and efficiency. I use two SAP reporting tools on top of Oracle database.
- I feel that Oracle database should come up in the areas where PLSQL procedures are used for manually loading the data if the storage is full rather than use GUI functionality that reduces the time to write code and maintain it.
- Oracle Database deployment or maintenance requires expert level skills including the operating systems it uses. I think Oracle should come up with some techniques to reduce the complexity.
- Reduce the cost in implementing and support activities.
- One of the impressive positive impact Oracle database has met is it offers the choice and flexibility to meet our business requirements in terms of scalability and cost (Since ours is a large enterprise platform).
- Negative Impact because data management cost per TB is too expensive for some organizations. If the enterprise is large then the cost is relatively low compared to small to midsize companies. That often results some companies to invest in other cheap databases.
- The Mobile platform: With the immense competition around IT, Oracle has accepted the challenge introducing Oracle mobile with cloud connectivity, enabling mobile developers to manage and deliver enterprise wide data and back end services via the cloud.
I used SAP BW and Microsoft SQL Server briefly on one of my projects and I rate Oracle database as a winner because of its portability and market presence. The performance of Oracle is extremely well especially when Oracle Database is tuned even if the database is large (>100GB). The SQL syntax offered by Oracle is much easier in my opinion compared to Microsoft's.