Performance Study of Analytical Queries of Oracle and Vertica

  • Kyurkchiev H
  • Kaloyanova K
  • 2

    Readers

    Mendeley users who have this article in their library.
  • N/A

    Citations

    Citations of this article.

Abstract

Analyzing and mining transactional data straight from the DBMS has become increasingly more popular, provoking research in read optimization for RDBMS. One branch of such research – column orientation claims significant improvement in read performance in comparison with row oriented DBMS. Having previously looked into the strengths and weaknesses of both approaches we take on studying the performance of commercial grade DBMSs, which employ the two views. The first step in this is examining their data models. We then develop a benchmark, which is subsequently used to measure each DBMS’s performance. Evaluating the results we draw conclusions about each DBMS’s suitability and main advantages over the other.

Get free article suggestions today

Mendeley saves you time finding and organizing research

Sign up here
Already have an account ?Sign in

Find this document

There are no full text links

Authors

  • Hristo Kyurkchiev

  • Kalinka Kaloyanova

Cite this document

Choose a citation style from the tabs below

Save time finding and organizing research with Mendeley

Sign up for free