Festival-Web: uma ferramenta analítica de dados para gerenciar testes de desempenho de índices espaciais

Abstract

Spatial database systems use spatial data that represent aspects of the real world. Spatial data can be of the type point, line and region, where a point can represent the geographic position of a vehicle, a line can represent a road, and a region can represent a country’s administrative boundaries and boundaries. However, with a large volume of data and the complexity of manipulating spatial objects, query processing is an expensive task. To solve this problem, spatial indexes are used, such as the R-tree. This type of structure allows the execution of a space operation to be more accelerated. However, several factors influence the performance of spatial indices. To identify the best structure for a given application, it is necessary to perform performance tests. Through these tests, several metrics are obtained that will verify aspects of time consumed, space occupied, number of access to a certain resource, and number of times it was executed. However, performing performance tests is not trivial. Performance tests can be performed using tools, such as FESTIval. This framework allows performance testing executions in a unique way and integrated with PostgreSQL, storing the results and tests in a specific data schema. In addition, FESTIval has support for different spatial indexing structures, such as R-tree and its variations. However, there are some limitations in FESTIval, such as the lack of a graphical interface that assists the user in the creation of spatial index configurations, and means of abstraction of the results in the form of analytical graphs. In this sense, this TCC developed a web-based software application called FESTIval-web, which makes the user’s interaction with FESTIval better. FESTIval-web has four main features. The first one to manage users, aims to manage access to the FESTIval-web tool. The second functionality to manage index settings, is related to aspects of creating, updating and removing index settings that are used in performance tests. The third, managing workloads, aims to create, change, remove and query workload configurations. Finally, analysis of experiments, which aims to assist in the analysis of the results of experiments through graphs. However, FESTIval-web has limitations, such as not performing performance tests through the interface, the lack of maps that show the structures of spatial indexes formed by the experiments and that FESTIval-web is a unique application for several users.