Skip to Main Content
 

Global Search Box

 
 
 
 

Files

File List


10551.pdf (1.02 MB)

ETD Abstract Container

Abstract Header

Benchmarking Performance for Migrating a Relational Application to a Parallel Implementation

Gadiraju, Krishna Karthik
http://rave.ohiolink.edu/etdc/view?acc_num=ucin1409065914

Abstract Details

2014, MS, University of Cincinnati, Engineering and Applied Science: Computer Science.
Many organizations rely on relational database platforms for OLAP-style querying (aggregation and filtering) for small to medium size applications. We investigate the impact of scaling up the data sizes for such queries. We intend to illustrate what kind of performance results an organization could expect should they migrate current applications to big data environments. This thesis benchmarks the performance of Hive, a parallel data warehouse platform that is a part of the Hadoop software stack. We set up a 4-node Hadoop cluster using Hortonworks HDP 1.3.2. We use the data generator provided by the TPC-DS benchmark to generate data of different scales. We use a representative query provided in the TPC-DS query set and run the SQL and Hive Query Language (HiveQL) versions of the same query on a relational database installation (MySQL) and on the Hive cluster. An analysis of the results shows that for all the dataset sizes used, Hive is faster than MySQL when executing the query. Hive loads the large datasets faster than MySQL, while it is marginally slower than MySQL when loading the smaller datasets.
Karen Davis, Ph.D. (Committee Chair)
Prabir Bhattacharya, Ph.D. (Committee Member)
Paul Talaga, Ph.D. (Committee Member)
60 p.
Computer Science
Hive; Hadoop; benchmarking; big data; SQL; queries

Recommended Citations

Citations

  • Gadiraju, K. K. (2014). Benchmarking Performance for Migrating a Relational Application to a Parallel Implementation [Master's thesis, University of Cincinnati]. OhioLINK Electronic Theses and Dissertations Center. http://rave.ohiolink.edu/etdc/view?acc_num=ucin1409065914

    APA Style (7th edition)

  • Gadiraju, Krishna Karthik. Benchmarking Performance for Migrating a Relational Application to a Parallel Implementation. 2014. University of Cincinnati, Master's thesis. OhioLINK Electronic Theses and Dissertations Center, http://rave.ohiolink.edu/etdc/view?acc_num=ucin1409065914.

    MLA Style (8th edition)

  • Gadiraju, Krishna Karthik. "Benchmarking Performance for Migrating a Relational Application to a Parallel Implementation." Master's thesis, University of Cincinnati, 2014. http://rave.ohiolink.edu/etdc/view?acc_num=ucin1409065914

    Chicago Manual of Style (17th edition)

ucin1409065914
1,430
© 2014, all rights reserved.
This open access ETD is published by University of Cincinnati and OhioLINK.
Release 3.2.12