350 rub
Journal Information-measuring and Control Systems №12 for 2016 г.
Article in number:
Comparison of request execution time in RDBMS and Hadoop environments
Authors:
A.I. Ustimov - Master\'s student, Department of Information Processing and Control Systems, Bauman Moscow State Technical University E-mail: artjom-ustimov@yandex.ru
Abstract:
With increasing of volumes of data being processed, problems with RDBMS using are appeared. One possible solution are new technologies based on parallel proccessing. This article compares execution time of request to 3D data warehouse in RDBMS MySQL and MapReduce/Hadoop environments. In Hadoop environment a request can be executed in parallel on multiple data warehouse nodes. But this technology doesn-t support data indexing by default. Otherwise, in MySQL environment a request is executed on single node, but it can be optimised with using of indexing. So, what option will be faster is not predictable in this case. Result of this comparison was data fragmentation and parallel processing in Hadoop prevailing under optimising and indexing in RDBMS MySQL.
Pages: 101-102
References
  1. DigitalOcean. [EHlektronnyjj resurs]. [https://www.digitalocean.com] Provereno 12.10.2016.