Oracle Databases - Extremely Powerful In The Right Hands
January 21, 2019
Oracle Databases - Extremely Powerful In The Right Hands
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle Database
Our company is using Oracle databases to support almost all aspects of the business. We use it for our ERP system, Commerce integrations, Marketing, Sales, etc. Since we use many Oracle applications, the Oracle databases go hand in hand as the back end storage mechanism for all the various apps we utilize.
- Oracle databases are ideal for maintaining data (insert, update, delete).
- The SQL (Structured Query Language) and PL/SQL (Procedural Language / Structured Query Language) languages are very powerful ways to interact with Oracle databases and retrieve data.
- The databases have administrator tools that make maintenance of the databases simple.
- Some error messages tend to be a bit ambiguous.
- Although Oracle is a relational database, they rules are not strictly enforced. I suppose this allows for more flexibility and customization, but it would be nice to have inherent foreign keys, etc.
- There have been times where updating the database has resulted in some functionality (i.e. keywords, tuning methods, etc.) to be deprecated which has required my teams to rewrite code.
- Oracle databases are critical to our business. Using the products allows us to conduct business far more efficiently than without the use of them.
- We have endless reporting available to us via Oracle databases. They are essentially a warehouse of data waiting to be used. Whether we write custom queries to pull the data we need or use any of our various Oracle applications (some with built-in reports), we can pull out the data we need to better manage our business.
- As with most Oracle products, they come with a usually substantial price tag. But I believe the ROI from Oracle databases more than make up for it.
It has been many, many years since I've used Microsoft Access. That being said, it was really my first introduction to databases. I was intrigued by the potential and how simple it can be to create your own forms, databases, etc. Oracle is like Microsoft on steroids. It is far more powerful than Access ever was. Granted, you may need to combine several Oracle products to achieve the types of results that Access had bundled into a single package, but the possibilities with Oracle are far greater.