A client had extensive investment in standalone Oracle implementations. A reporting application was experiencing rapid growth in both data volumes and the end user community so they were looking to define a minimally disruptive performance roadmap. The existing solution had years of investment and they wanted a best fit solution to enable them to continue to move forwards with the platform and meet the increasing demands.
After a brief solution assessment, we identified a step change opportunity through exploiting Oracle 12c's Database In-Memory (columnar storage) feature. By leveraging a three way partnership with the client's internal centralised performance team and Oracle UK, we designed a set of tests to objectively measure key performance statistics across a range of representative parallel workloads. Test execution was then carried out utilising our Performance Accelerator load simulator and results collated and interpreted by our performance consultant.
The resulting performance report was able to identify key areas of gain (in some cases up to 700 times faster) as well as recommend refactoring opportunities to better exploit the performance of both the standard Oracle 12c solution design and the proposed Database In-Memory uplift.
More importantly, opportunities were identified to migrate and consolidate functional capabilities into the reporting application from other software components to maximise the investment in this technology. To demonstrate this, a thorough cost-benefit analysis was performed to evaluate the increased licensing costs against savings in data storage and architecture simplification.