• Home
  • Search
  • TPCx-BB (Big Bench) in a Single-Node Environment
  • Cite Icon2
  • https://doi.org/10.1007/978-3-030-55024-0_5Copy DOI Icon

TPCx-BB (Big Bench) in a Single-Node Environment

  • Jan 1, 2020
  • Dippy Aggarwal +6 more
Show More
  • Abstract
  • Literature Map
  • References
  • Citations
  • Similar Papers
Abstract

Big data tends to concentrate on the data volume and variety which requires large cluster capabilities to process diverse and heterogeneous data. Currently, NoSQL/Hadoop-based cluster frameworks are known to excel at handling this form of data by scaling across nodes and distributed query processing. But for certain data sizes, relational databases can also support these workloads. In this paper, we support this claim over a popular relational database engine, Microsoft* SQL Server* 2019 (pre-release candidate) using a big data benchmark, BigBench. Our work in this paper is the industry first case study that runs BigBench on a single node environment powered by Intel® XeonTM processor 8164 product family and enterprise-class Intel® SSDs. We make the following two contributions: (1) present response times of all 30 BigBench queries when run sequentially to showcase the advanced analytics and machine learning capabilities integrated within SQL Server 2019, and (2) present results from data scalability experiments over two scale factors (1 TB, 3 TB) to understand the impact of increase in data size on query runtimes. We further characterize a subset of queries to understand their resource consumption requirements (CPU/IO/memory) on a single node system. We will conclude by correlating our initial engineering study to similar research studies on cluster-based configurations providing a further hint to the potential of relational databases to run reasonably scaled big-data workloads.

Similar Papers
  • Book Chapter
  • Citations51

Setting the Direction for Big Data Benchmark Standards

  • Jan 01, 2013
  • Chaitanya Baru +4
  • Conference Article
  • Citations1

Hybrid Machine Learning-Based Intelligent Technique for Improved Big Data Analytics

  • Nov 01, 2019
  • Andronicus A Akinyelu
  • Research Article
  • Citations12

NoSQL Database Technologies

  • Jan 01, 2015
  • Journal of International Technology and Information Management
  • Michael Madison +3
  • Research Article
  • Citations1

An application of Naïve Bayes Classifier to explore big data using XLSTAT

  • Sep 15, 2018
  • INTERNATIONAL RESEARCH JOURNAL OF AGRICULTURAL ECONOMICS AND STATISTICS
  • M.S Kasture +3
  • PDF
  • Research Article
  • Citations162

Methodological challenges and analytic opportunities for modeling and interpreting Big Healthcare Data.

  • Feb 25, 2016
  • GigaScience
  • Ivo D Dinov
  • Book Chapter
  • Citations2

A Mark Based-Temporal Conceptual Graphs for Enhancing Big Data Management and Attack Scenario Reconstruction

  • Jan 01, 2015
  • Yacine Djemaiel +2
  • Research Article
  • Citations54

Benchmarking Big Data Systems and the BigData Top100 List.

  • Mar 01, 2013
  • Big Data
  • Chaitanya Baru +4
  • Conference Article
  • Citations4

Relational Database and NoSQL Inspections using MongoDB and Neo4j on a Big Data Application

  • Sep 14, 2022
  • Serhat Uzunbayir
  • Conference Article

Evaluation of Big Data Privacy and Accuracy Issues

  • Jan 01, 2016
  • Reem Bashir +1
  • Conference Article
  • Citations9

A Data as a Product Model for Future Consumption of Big Stream Data in Clouds

  • Jun 01, 2015
  • Guangyan Huang +4
  • Research Article
  • Citations44

Detecting long-memory: Monte Carlo simulations and application to daily streamflow processes

  • Feb 06, 2007
  • Hydrology and Earth System Sciences
  • W Wang +3
  • Research Article
  • Citations1

An Invigorating Perspective of a Practical Aspect of NoSQL Database

  • Sep 19, 2022
  • International Journal of Research Publication and Reviews
  • Shaida Begum
  • Conference Article

Allocation of Resources after Disaster Based on Big Data from SNS and Spatial Scan

  • Aug 01, 2016
  • Zixue Cheng +3
  • Discussion
  • Citations83

An effective model for store and retrieve big health data in cloud computing

  • Apr 19, 2016
  • Computer Methods and Programs in Biomedicine
  • Zohreh Goli-Malekabadi +2
  • Research Article
  • Citations7

Cloud computing and big data: Technologies and applications

  • May 20, 2018
  • Concurrency and Computation: Practice and Experience
  • Mostapha Zbakh +3
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.