Below are some of our favorite sessions from last years Enkitec Extreme Exadata Expo (E4) conference.
My PX Goes to 11 by Kerry Osborne & Chris Wones
This session provides a case study detailing the implementation of extreme parallelism in a very large DW environment. The system was implemented on a RAC cluster hosted on 2 Exadata X3-8’s. The application provides in-depth analysis for product performance and shopping behaviors to the retail industry. This presentation combines the business case with the technical hurdles that had to be overcome in order to enable the system to work. One of the biggest challenges was the decision/requirement to not do any pre-aggregation of data, meaning that every report had to hit the raw data. Exadata provided the perfect platform allowing the power of SQL to be applied but still allowing a large portion of the work to be pushed down to the data.
Exadata vs. Teradata in the Healthcare Industry by Tim Fox
This session will recap a Proof of Concept (POC) where 40TB database was migrated from Teradata to Exadata so that a head to head comparison could be done. The application at the center of the test was Epic’s Clarity Data Warehouse which is in use at many, large healthcare organizations in the US. We will discuss the following aspects of this test: architecture comparison, data migration/conversion of 40TB, test execution and recording results and unique challenges with very large databases. The results of this POC are truly staggering. To find out who won, and by how much, come to this session. This is a “must see.”