Performance Comparison of InterSystems Caché and Oracle in a Data Mart Application - Sponsored Whitepaper

Telecommunications companies, because they generate and must analyze enormous amounts of information, are among the most demanding database users in the world. In order to make practicable business intelligence solutions, telecommunications firms typically select key pieces of raw data to be loaded into a “data mart”, where it is indexed and aggregated in various ways before being made available for analysis. Even so, the data marts in question may be hundreds of gigabytes in size. Database performance, both in the creation of the data mart, and in the query response time of the data mart, is critical to the timely analysis of information, and ultimately to the ability of the enterprise to identify and act upon changes in their business environment.

This paper presents the results of comparative performance tests between InterSystems Caché and Oracle 9i. They were performed by the mobile telecommunications software company Airwide Solutions, as they evaluated database technology for incorporation into a new business intelligence application relating to mobile phone usage.