Reducing Data Access Time using Table Partitioning Techniques

Abstract

Data are used in a large number of different fields. Large databases with huge amounts of data come to the fore. They are a very important part of many of information systems, from commercial systems, through technical and technological systems, the web, and mobile applications to the management of scientific data in various fields. Fast access to data is, therefore, becoming increasingly important today and great emphasis is placed on improving it. Initially, the data access time may be only slightly increased working with smaller tasks, but with a larger number of larger tasks, there is a significantly higher data access time that needs to be reduced. From the point of view of efficiency, it is not appropriate or necessary to access all data, and therefore it is necessary to divide this data into smaller parts and thus create partitions, which will facilitate the execution of certain operations and bring efficiency, whether in terms of time or performance. This paper discusses partitioning, its various techniques, methods, and the benefits it brings. It compares access times to tables with and without partitions, regarding various numbers of table parts that are accessed.