CN-115700520-B - ETC parking scene-oriented database architecture design method and system

CN115700520BCN 115700520 BCN115700520 BCN 115700520BCN-115700520-B

Abstract

The invention discloses a database architecture design method and a system for ETC parking scenes, which belong to the technical field of intelligent parking and comprise the following steps of firstly establishing an image database cloud, then identifying and screening parking information through the image database cloud, finally outputting information of screening places to a bank settlement system, constructing an image database structure through image technology by data in each platform database, constructing an image database cloud according to ETC identification, utilizing the image database cloud to receive parking charging information and butt-joint with the bank settlement system, being compatible with a cross-platform database, optimizing database dynamic calling efficiency, improving creativity and efficiency of data scene application, utilizing an ETC identification device established at a road intersection to identify and deduct fee settlement, reducing the upgrading cost of the existing parking system and facilitating popularization of the ETC parking system.

Inventors

SONG JIE
SUN SHUYAO
ZHANG XIAOCHEN
WANG XIAOJUN
REN ZHENG
LI LI
ZHANG MENGYU
LI XI
WANG GANG
LI JIAN
LIU XU
MEI LEXIANG
GAO XIN
WANG CHAORUI
GU YAN
ZHAO LIANG

Assignees

交通运输部路网监测与应急处置中心

Dates

Publication Date: 20260505
Application Date: 20210716

Claims (9)

1. The ETC parking scene-oriented database architecture design method is characterized by comprising the following steps of: s1, storing basic information of a vehicle through pictures, and establishing a basic information database of the vehicle; s2, license plate information is stored through pictures, and a license plate information database is established; S3, constructing ETC identification information image conversion software, converting ETC identification information into an image, storing and establishing an ETC identification information database, wherein the ETC identification information picture is converted into RGB color blocks after being distributed by ETC identification information definition numerical values, and the encryption picture is formed by the RGB color blocks; s4, installing ETC recognition devices at urban traffic intersections, and generating position information pictures by image conversion software according to the geographical position information of the intersections by the ETC recognition devices to form a recognition position information database; S5, constructing an image database central dispatching module, transmitting the identification vehicle information to the image database central dispatching module by the ETC identification system of the urban traffic intersection in cooperation with the camera, and sequentially arranging the vehicle basic information picture, the license plate information picture, the position information picture and the ETC identification information picture from left to right by the image database central dispatching module to synthesize the vehicle comprehensive information picture to form an image database cloud; S6, generating settlement standard pictures through image conversion software according to the positions and charging standards of different parking systems, and establishing a settlement standard database; S7, generating a parking time information picture through image conversion software according to the parking time information in the parking system, and establishing a parking time database; s8, the existing parking system shoots basic information of the vehicle and license plate information into pictures by utilizing an existing video monitoring system and a license plate recognition system, and uploads the pictures to a cloud server for recognition; S9, constructing a database output adaptation module, wherein a screening module is arranged on the database output adaptation module, and vehicle comprehensive information pictures corresponding to vehicle comprehensive information pictures screening positions of corresponding image database clouds are selected according to different data identification requests of the existing parking system; S10, when the parking system monitors that the vehicle finishes parking, the vehicle basic information picture, the license plate information picture, the settlement standard picture and the parking time length picture are correspondingly synthesized into a charging information picture and then transmitted to the database output adaptation module, the database output adaptation module recognizes the corresponding settlement standard picture and the parking time length picture after recognizing the vehicle basic information picture and the license plate information picture in the charging information picture, obtains the corresponding parking position and the corresponding time length of the vehicle, then retrieves the vehicle comprehensive information picture in the latest time according to the parking position, synthesizes the ETC recognition information picture, the settlement standard picture and the parking time length picture in the latest time vehicle comprehensive information picture into a fee deduction result picture, and transmits the fee deduction result picture to the bank settlement system; s11, the bank settlement system identifies the fee deduction result picture, calculates the parking fee according to the result identified by the settlement standard picture and the parking time length picture, and deducts money from the ETC account identified by the ETC identification information picture.
2. The ETC parking scene oriented database architecture design method of claim 1, wherein the vehicle basic information in S1 comprises vehicle colors, vehicle types and vehicle brands, different vehicle types and different vehicle brands correspond to color blocks with different RGB values respectively, and the vehicle basic information picture consists of three color blocks.
3. The ETC parking scene-oriented database architecture design method of claim 1, wherein the license plate information in S2 comprises license plate types, license plate region information and number information, different license plate types, different license plate region information and different number information correspond to color blocks with different RGB values respectively, and a license plate information picture consists of three color blocks.
4. The method for designing the database architecture for the ETC parking scenario according to claim 1, wherein the step S5 is characterized in that the vehicle comprehensive information stored in the central scheduling module of the image database automatically files the buckled vehicle comprehensive information picture when the vehicle is buckled, and deletes other vehicle comprehensive information pictures.
5. The ETC parking scene-oriented database architecture design method of claim 1, wherein the existing parking system in S8 comprises a parking lot and roadside berths, and the video monitoring system of the roadside berths can be directly formed by modifying the upgrading pattern recognition function of the existing road monitoring system.
6. The ETC-parking-scene-oriented database architecture design method of claim 1, wherein the monitoring system of the parking system and the license plate recognition system in S10 are connected to transmit the recognized vehicle picture information to the database output adaptation module for step recognition of vehicles, the recognition sequence is sequentially vehicle basic information and license plate information, the screening module selects data sets meeting the conditions from the image database Yun Zhongshai according to the recognition module result, and the screened data sets are used as a next recognition database to finish the screening of the vehicles.
7. The method for designing an ETC parking scene oriented database architecture according to claim 1, wherein in S10, before transmitting the fee deduction result picture to a bank settlement system, the position information of the combination standard picture and the latest time vehicle comprehensive information picture is checked.
8. The ETC parking scene-oriented database architecture design method of claim 1, comprising an image database cloud, wherein the image database cloud is provided with an image database central scheduling module and a database output adaptation module, the image database central scheduling module is connected and interacted with a vehicle basic information database, a license plate information database, an ETC identification information database and an identification position information database, and the database output adaptation module is in data interaction with a parking system and a bank settlement system.
9. The method for designing a database architecture for an ETC parking scenario according to claim 8, wherein the image database cloud is arranged on an ETC multi-scenario service platform, the vehicle basic information database and the license plate information database are stored in a national vehicle management department information storage system, the ETC identification information database is stored in an ETC charging system, and the identification position information database is stored in a traffic management system.

Description

ETC parking scene-oriented database architecture design method and system Technical Field The invention relates to the technical field of intelligent parking, in particular to a database architecture design method and system for ETC parking scenes. Background With the continuous acceleration of the process of urban and motorized, the shortage of parking resources has become a difficult problem for restricting traffic development and puzzling urban management. According to the statistics of the public security department, the holding quantity of motor vehicles in China nationwide in 2020 reaches 3.72 hundred million, and the holding quantity of the motor vehicles is 2.81 hundred million. The data released by the national development and reform commission in 2015 show that the average ratio of the large city cars to the parking spaces in China is about 1:0.8, and the average ratio of the small city to the medium city is about 1:0.5. In recent years, the contradiction between parking supply and demand is more prominent, taking Beijing as an example, about 7000 parking lots are recorded in the whole city at present, about 382 tens of thousands of parking spaces are recorded in the road side, about 6.5 tens of thousands of parking spaces are recorded in the road side, the quantity of the reserved automobiles exceeds 630 tens of thousands, and the quantity of urban parking spaces can not meet the increasing automobile use demands of people. From the urban level, traffic is always connected with cities and society, traffic transportation is a basic guarantee of economic and social development, economic transformation development is promoted, smart cities are built, the positioning of traffic 'advance officers' is required to be firmly grasped, and 'ten-network integration' of traffic infrastructure networks, transportation networks, service networks, energy networks, information networks and the like is accelerated through informatization means, so that comprehensive association of traffic with cities and society is realized, the development of smart cities is supported and driven, and industrial chains of finance, service, manufacturing and the like are opened. An Electronic Toll Collection (ETC) system is a system which automatically completes functions such as vehicle identification, toll collection operation, lane equipment control, toll collection data processing and the like through technologies such as radio frequency identification, computers and the like under the condition that a vehicle does not stop. By 12 months in 2020, national ETC users reach 2.25 hundred million, and passenger car payment utilization rate reaches 70.31%. ETC is used as a means of noninductive identification and safe payment, and can be popularized and applied to the city level to greatly improve the service level and the use experience of users, and meanwhile, the use efficiency of ETC equipment can be effectively improved, and the optimal configuration of social resources is realized. The ETC is applied to management, traffic management and service of the smart city and can effectively support urban digital development, on one hand, the ETC can be used as main equipment for urban traffic perception to realize full travel chain acquisition of vehicle running tracks and states and further provide data support for urban traffic planning, congestion management and public transportation priority, on the other hand, the ETC can open an automobile service charging industry chain of oiling, parking, maintenance, insurance and the like to energize the smart city and drive the quick development of the smart city digital traffic economy, so that the conversion of a smart city digital traffic economy development mode is realized. The problem of difficult parking in cities cannot be simply and roughly completed through extension, and the problems of high parking operation cost, traffic jam, poor people traveling experience and the like can be effectively solved only by continuously improving the intelligent level of parking management on the basis of reasonably configuring land resources. ETC technology can become an important carrier for opening urban traffic and inter-city traffic, can effectively solve the urban static traffic treatment problem, promote the public travel service level, reduce the pollutant discharge of parking lots, is an effective means for increasing the sense of well-being of life of people, is an important foundation for building civilized cities, smart cities, green cities and safe cities, and can provide support for exploring and unlocking new industries and new fields. In the prior art, the main way of parking lot electronic payment is mobile payment, a charging system is based on the environment construction of a public network, and unlike the closed private network for highway charging and the scene of industrialized management, the public network environment cannot guarantee the safety of ETC equipment, the risk