Performance Evaluation MySQL InnoDB and Microsoft SQL Server 2012 for Decision Support Environments

Traditional data analysis systems are driving radical changes to perform any kind of analysis on large volumes of data. The decision support systems are increasingly used in management of industrial enterprises, public sector and scientific community. In this paper we study the performance and suitability of two relational database engines for Decision Support Systems environments. The two engines are MySQL InnoDB and Microsoft SQL Server 2012. In the experiments we use Star Schema Benchmark (SSB), with a variety of datasets sizes. Microsoft SQL Server 2012 shows a quite acceptable behaviour while MySQL InnoDB achieves results below the expected for large datasets. These experiments allow us to assess the performance and suitability, of the studied engines, for small and medium size Decision Support environments.