Massive acceleration of complex data analysis

Thanks to improved performance, the market research company can better meet its customers’ needs. The process of supplying and graphically representing data has been reduced from several days to one day or from hours to minutes.

  • About IMS Health

    About IMS Health

    For more than 50 years, IMS Health has been the world’s leading provider of information services for the healthcare industry (pharmaceuticals and medical devices, funding and service providers). Its customers are the decision-makers of the pharmaceutical and healthcare industry, who are provided with important data and services relating to the market and portfolio performance of their products as well as the management of corporate divisions.

    Industry:Market research
    Application:Scoring, Purchasing behaviour analytics, Range optimization
    Database:EXASOL, Hadoop, MSSQL, Oracle DB, Sybase ASE
    BI tool:IBM Cognos, Microsoft Reporting Services, MicroStrategy, SAP Business Objects
    ETL tool:LUA Scripts, Microsoft Integration Services, Pentaho Data Integration
  • The situation

    The situation

    To collect, prepare and analyze new data sources, a high-performance system was needed at the local level in order to upload large amounts of data to a data warehouse, analyze it quickly and output it on demand without increasing costs and resources significantly.

  • The solution

    The solution

    EXASOL is a relational high-performance database that is designed for time-critical, complex analyses, planning and reporting. The solution is based on a shared-nothing cluster of standard servers operating in parallel. In-memory processing and special compression algorithms ensure top performance.