Oracle Exadata Database Machine offers in-memory performance for our DB transactions
Overall Satisfaction with Oracle Exadata Database Machine
Oracle Exadata Database Machine is our enterprise standard for SQL databases. My department has a large application on Sybase ASE 16 and we evaluated a number of platforms to migrate onto from Sybase. After reviewing MS-SQL, SAP HANA, IBM DB2 and Exadata, Exadata emerged as the winner. We put in place a two year project plan to migrate about 50 TB of data, 24 databases * 7 instances, 8000 stored procedures and about 1,500 tables. Our business problem we were solving was to collapse 7 instances of our application into 1, eliminate multiple copies of data and migrate off of dedicated hardware, moving to our enterprise Exadata offering us the database as a service.
Pros
- High Speed Computing
- History Tables
Cons
- Implementation of temporary tables
- SQL Developer attempt to convert T-SQL to PL-SQL could be better
- Standardization of hardware
- Standardization of software
Oracle Exadata Database Machine had the best performance overall hands down. It clearly beat the competition and we were seeing 1000X improvement on SAP HANA. Oracle Exadata Database Machine beat that without us refactoring our code. To achieve that in HANA, we had to refactor the code somewhat. Now this was for our limited POC of 5 use cases. Given the large number of stored procedures we had in Sybase, we need to capture more production metrics but we are seeing incredible performance.
Do you think Oracle Exadata delivers good value for the price?
Yes
Are you happy with Oracle Exadata's feature set?
Yes
Did Oracle Exadata live up to sales and marketing promises?
Yes
Did implementation of Oracle Exadata go as expected?
Yes
Would you buy Oracle Exadata again?
Yes
Comments
Please log in to join the conversation