Friday, December 7, 2012

Adopting Exadata to Improve BI Solution Performance

Probably the most important thing will be their code: make sure that it employs set base (as opposed to row by row) processing, parallelism, compression, bulk direct path loading, and transformation techniques vs DML.

EHCC greatly assists with processing of data.

Infiniband also helps with the transfer of data as well - not just between the database nodes and Exadata storage cells but also when ingesting the data from the sources as well (i.e. the data warehouse is not a bottleneck).

Backup and recovery is faster which means unlike many data warehouses which their DR plan mainly consist of complete reload from sources, this provides a true DR and even better DR via data guard than simply "rebuild".

Unanticipated queries where you do not have cubes or views developed aren't such an issue either. Exadata is able to address the unanticipated ones. And these can be the most valuable ones too - new questions that result in more improvement over previous ways.



No comments:

Post a Comment