Implementation of Data Warehouse With Snowflake Schema in Electric Vehicles Realm
Yaqoob Al-Zuhairi, Ammar A. Al-Hamadani, Talib M. J. Abbas · 2024
As electric vehicles (EVs) produce less pollution compared to conventional fuel-powered vehicles, governments seek to improve the use of EVs as urban transportation service to protect the environmental and economic sustainability. Therefore, it is necessary to have an optimal and sufficient charging infrastructure in order to enable the transition to EVs at a rapid pace and their widespread adoption. This will assist in providing great driving experience so that drivers are able to recharge their EVs comfortably and quickly, maximizing the return on investment and minimizing the impact on the network. Actually, this case requires the skilful application of sophisticated tools and technologies to optimize EV charging infrastructure sites. In this sense, the goal of this paper is to propose a data warehouse system in the field of electric vehicles to integrate, analyze, and utilize data from various sources to assist policymakers and administrators who benefit from analysis results in making efficient decisions for forward planning and strategies which assist in optimizing charging infrastructure, providing best services for drivers, and improving the overall efficiency and effectiveness of electric vehicle operations and development.