Oracle Data Warehouse is the 800 Pound Gorilla
January 04, 2019
Oracle Data Warehouse is the 800 Pound Gorilla
Score 7 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle Data Warehouse
We've recently adopted Exadata as our primary DW solution. It allows us to quickly store and query lots of data. The data is generally written in overnight batches and is constantly queried 24x7. It even supports some online business decisions to our customers. We use it company-wide. I am an administrator of the database, as well as a SQL Programmer.
- Handles workloads like a champ.
- Uses state-of-the-art analytic functions and allows for quick, easy SQL.
- "Secret Sauce" integrates the hardware and the software for faster I/O.
- Supports thousands of concurrent users.
- We had issues converting a legacy DW (with its existing indexes, etc) over to the new DW hardware. Given the memory-intensive resources, not all indexes are advised. Traditional query tuning methods do not work. You have to re-learn some tuning tactics.
- Given the number of features it has, it is far more complex to administer. Requires trained staff to support.
- Support in these areas is generally poor. Oracle is, sadly, no exception.
- I HATE the current push to the cloud. Seems like a gigantic money-grab.
- We are just now opening up a Business Intelligence area in our company. In general, the business seems in love with the quick access to data.
- Analytics and predictive functions, much of which is done with the power of the database, have helped us stay ahead of our competition.
- This is an expensive and fantastic product all at the same time. Don't be fooled that administration costs will go down when you implement this. I believe it requires as much (or more) administration as anything out there.
Oracle is, in my opinion, the top dog in this space. I feel like the other vendors are playing catch-up to where Oracle is right now. It is also likely the most expensive option out there.