Performance, scalability, fast, installed: this is Oracle Exadata.
November 01, 2017

Performance, scalability, fast, installed: this is Oracle Exadata.

Gurcan Orhan | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Exadata Database Machine

The most valuable feature of the solution is that it is durable. It is a highly relevant option with extreme performance. The extreme performance is one of the key features when you're using Exadata. There are known points that you need to take care of, simply "beware of update".!

I implemented a data warehouse on Exadata. Before this solution, we were aiming for this to be completed by 8 a.m., when our ETLs would finish. With the help of Exadata's special features, this was reduced to 3 a.m.

This solution allows us to bring more data within the same time period. It provides us with more subject areas that provide more reports to our users. Our ETL times reduced to 65%, then to 50%.

Pros

  • Oracle Database : Deliver industry-leading security, high availability and scalability with Oracle Database, which has been significantly enhanced to take advantage of the Oracle Exadata Storage Servers.
  • Exadata Smart Scan : Improve query performance by offloading intensive query processing and data mining scoring to scalable intelligent storage servers.
  • Smart Flash Cache : Transparently cache 'hot' read and write data to fast solid-state storage, improving query response times and throughput. Exadata systems use the latest PCI flash technology rather than flash disks. PCI flash delivers ultra-high performance by placing flash directly on the high speed PCI bus rather than behind slow disk controllers.
  • Hybrid Columnar Compression : Reduce the size of data warehousing tables by 10x, and archive tables by 50x, to improve performance and lower storage costs for primary, standby, and backup databases. Query high, query low, archive high and archive low.
  • Infiniband Network : Connect multiple Oracle Exadata Database Machines using the InfiniBand fabric to form a larger single system image configuration. Each InfiniBand link provides 40 Gigabits of bandwidth–many times higher than traditional storage or server networks.
  • Petabyte Scalability : Easily scale data warehouse to support enterprise data growth.

Cons

  • There's nothing bad to say about Exadata. It's stable, durable, and always up and running. My DBAs do online patches and online backup.
  • I would like to see more database features and maybe more archiving features, because we need to do data archiving. I would like to see additional database memory.
  • It could be cheaper. :-)
  • Durability
  • Scalability
  • Extreme Performance
  • Installed out-of-the-box
We had already chosen Oracle Exadata, so we didn't compare this solution with other products.
  • First, get the database on Oracle. If you are in an Oracle stack, it would be much better to use the Oracle products. If you are driving a Ferrari, you wouldn’t put a Mercedes engine in it. If you are writing a query, you cannot rely on other brands. Since I'm an architect, when I look for a product, I look for performance.
  • The installation is easy because it comes out-of-the-box and you just start using it.
  • Previous to Oracle Exadata, we were using a normal Oracle RAC service. We were just waiting for this product to come out.

  • I'm currently writing a data warehouse on Exadata. Before this solution, we were aiming for this to be completed by 8 a.m., when our ETLs would finish. With the help of Exadata's special features, this was reduced to 3 a.m. This solution allows us to bring more data within the same time period. It provides us with more subject areas that provide more reports to our users. Our ETL times reduced to 65%, then to 50%.

Comments

More Reviews of Oracle Exadata

  1. Home
  2. Data Warehouse Software
  3. Oracle Exadata Reviews
  4. User Review of Oracle Exadata