Approaches to Speed up Data Processing in Relational Databases

The increasing of data volumes and the tightening of requirements by the time of data processing actualize the problem of finding methods for optimizing data structures and queries in databases. This article presents a set of methods that can help speed up the processing of data. These include the method of restructuring a completed database, a method for obtaining a parallel query plan, and methods for optimizing queries. The presented methods can be used both in a complex and independently of each other. At the end of the article, are shown the results of the experiments, which were carried out on a test database for approbation of optimization methods for a parallel query plan. (C) 2019 The Authors. Published by Elsevier B.V. This is an open access article under the CC BY-NC-ND license (https://creativecommons.org/licenses/by-nc-nd/4.0/) Peer-review under responsibility of the scientific committee of the 13th International Symposium "Intelligent Systems" (INTELS'18).