基于车辆的关系型数据库性能提升  

Performance Improvement of Vehicle Based on Relational Database

作　　者：刘路 孙代青 王瑞 王光福 张文成 LIU Lu;SUN Daiqing;WANG Rui;WANG Guangfu;ZHANG Wencheng(Technology Center of Shaanxi Automobile Group Company Limited,Xi'an 710200,China)

机构地区：[1]陕西汽车集团股份有限公司技术中心,陕西西安710200

出　　处：《汽车实用技术》2023年第9期124-128,共5页Automobile Applied Technology

摘　　要：随着电器架构的日益增多,车辆运行过程中会上报大量的行车数据,使用数据库处理的数据量增加,请求难度也在升级,为了能够长期稳定地保存大量的车辆数据,快速查询出所需数据为研发工程师提供数据分析,需要设计出适合存放车辆数据的关系型数据库。PostgreSQL作为先进的开源数据库,支持复杂查询、并发控制等功能。文章针对基于车辆的关系型数据库提出多线程并行查询、创建数据表索引、添加数据库分区以及应用程序连接池的设计优化方法,针对性地对数据库的运行效率提供优化策略。测试结果表明,文章所提出的数据库性能提升方法能将数据请求效率提升数倍,数据库的性能得到极大提升。With the increasing of electrical architecture,a large amount of driving data will be reported during vehicle operation.The amount of data processed in the database increases,and the difficulty of request is also upgrading.In order to save a large amount of vehicle data for a long time and stably,quicklyquery the required data to provide data analysis for R&D engineers,it isnecessary to design a relationaldatabase suitable forstoring vehicle data.As an advanced open source database,PostgreSQLsupports complex queries,concurrency control and other functions.This paper proposes a design optimization method of multi thread parallel query,creating data table index,adding database partition and application connection poolforvehicle based relationaldatabase,and provides targeted optimization strategies for database operation efficiency.The test results show that the database performance improvement method proposed in this paper can improve the data request efficiency several times,and the database performance has been greatly improved.

关 键 词：关系型数据库 POSTGRESQL 并行查询 数据表索引 数据库分区 

分 类 号：U472.7[机械工程—车辆工程] TP392[交通运输工程—载运工具运用工程]