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.