Study on effectiveness of using column-oriented databases in the processing of measurement characteristics of an electric vehicle

Abstract

Electric vehicles are increasingly popular means of transport. One of the most important problems of their operation is to optimize the use of a battery pack. It requires to analyze the operational characteristics of a vehicle in motion, which are stored in a database. If the measurement data are collected from many vehicles, the efficiency of their analysis is important. The objective of this article is to study the possibilities of using modern column-oriented databases in order to increase the efficiency of the analysis of selected operational characteristics of an electric vehicle. The research problem is a comparative analysis of the processing efficiency of selected measurement characteristics of an electric vehicle in relational and column-oriented data structures. Important analytical functions were formulated and recorded in the form of database queries. An experiment consisting in multiple execution of functions packages on various database structures, including a column-oriented one, was carried out. The execution time of packages and the IT system load were collected and analyzed. The analysis of the experiment results allows to conclude that the use of the column-oriented data structures made it possible to shorten the time of executing the functions analyzing the energy consumption by the electric vehicle’s drive system. Depending on the type of the analyzed characteristics of the vehicle and its method of representation in the database, a significant reduction of the analysis time compared to the relational structure was obtained. Also, a decrease in the load on the computer system during data processing on the column-oriented structures was noted. The use of the column-oriented databases in the processing and analysis of measurement operational characteristics of electric vehicles is justified and it can bring measurable effects. It should be considered that the effective-ness of solving depends on the number of the analyzed characteristics and the format of their representation in the computer.