BIG DATA PROPRIETARY PLATFORMS. THE CASE OF ORACLE EXADATA

» TABLE OF CONTENTS
» SEE ARCHIVE
» DOWNLOAD THE PDF FILE.

By: MARIN FOTACHE, ALEXANDRU TICĂ, IONUȚ HRUBARU, TEODOR MARIUS SPÎNU
JEL: M15, C39, C88
Keywords: Big Data, Oracle Exadata, TPC-H, MARS, R, earth package.

The most prominent Big Data solutions – such as NoSQL systems, Hadoop Frameworks, Spark, etc. – have been open-sourced. Nevertheless, commercial providers have targeted niches of this huge market with products more or less viable and affordable. This paper addresses the problem of benchmarking Big Data platforms with a focus on Oracle Exadata solution provided by one the most important data technologies vendor. Many classical benchmark approaches, such as TPC-H, are based on a predefined set of queries, and consequently they are not prone to predictive modeling. By contrast, for the TPC-H benchmark schema, we generate a set of 500 random queries containing not only tuple filters (WHERE), but also tuple grouping (GROUP BY) and group filters (HAVING), we collected results of the queries execution on four Oracle Exadata settings. Query duration was the outcome variable. Various query parameters, such as the number of joins, the number of attributes of different types within SELECT and WHERE clauses, and also some environment metrics served as predictors. Results were interpreted using exploratory data analysis and also Multivariate Adaptive Regression Splines (MARS) for both predicting the performance and explaining the main drivers of the system performance.