Scientific journal

ISSN 1814-2400

INFORMATION SCIENCE AND CONTROL SYSTEMS

Grigor’ev Yu.A., Ustimov A. I.

COMPARISON OF QUERY EXECUTION TIME TO DATA WAREHOUSE IN MAPREDUCE/HADOOP AND RDBMS MYSQL

An access method to the data warehouse MapReduce/Hadoop is implemented in a cloud architecture. In foreign papers it is called Multi-Fragment-Replication Join (MFRJ). Proceeding from the full-scale experiments we compared the query execution time to the data warehouse using method of MFRJ and in RDBMS MySQL. The research showed that MFRJ is one up with dilation of fact table volume.

Keywords: MapReduce/Hadoop, RDBMS MySQL, data warehouse, query execution time