BIG DATA PROPRIETARY PLATFORMS. THE CASE OF ORACLE EXADATA

Marin Fotache (), Alexandru Ticä‚ (), IONUÈš Hrubaru () and Teodor Marius Spãžnu ()
Additional contact information
Marin Fotache: Alexandru Ioan Cuza University of IaÅŸi, Faculty of Economics and Business Administration, IaÅŸi, Romania
Alexandru Ticä‚: Alexandru Ioan Cuza University of IaÅŸi, Faculty of Economics and Business Administration, IaÅŸi, Romania
IONUÈš Hrubaru: Alexandru Ioan Cuza University of IaÅŸi, Faculty of Economics and Business Administration, IaÅŸi, Romania
Teodor Marius Spãžnu: Alexandru Ioan Cuza University of IaÅŸi, Faculty of Economics and Business Administration, IaÅŸi, Romania

Review of Economic and Business Studies, 2018, issue 21, 45-78

Abstract: 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.

Keywords: Big Data; Oracle Exadata; TPC-H; MARS; R; earth package (search for similar items in EconPapers)
JEL-codes: C39 C88 M15 (search for similar items in EconPapers)
Date: 2018
References: View complete reference list from CitEc
Citations:

Downloads: (external link)
http://rebs.feaa.uaic.ro/articles/pdfs/256.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:aic:revebs:y:2018:j:21:fotachem

Access Statistics for this article

More articles in Review of Economic and Business Studies from Alexandru Ioan Cuza University, Faculty of Economics and Business Administration Contact information at EDIRC.
Bibliographic data for series maintained by Sireteanu Napoleon-Alexandru ().