Wyniki wyszukiwania - BazTech

Ograniczanie wyników

1 Czerepicki Andrzej

1 2019

Powiadomienia systemowe

Sesja wygasła!
Sesja wygasła!
Sesja wygasła!

Znaleziono wyników: 1

Liczba wyników na stronie

Wyniki wyszukiwania

Wyszukiwano:
w słowach kluczowych: system transportu IT

Sortuj według:

Ogranicz wyniki do:

Study on Effectiveness of Using Column-Oriented Databases in the Processing of Measurement Characteristics of an Electric Vehicle

Czerepicki Andrzej

Archives of Transport

2019

Vol. 51, iss. 3

77--84

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 effectiveness of solving depends on the number of the analyzed characteristics and the format of their representation in the computer.