A database architecture design method and system for an ETC parking lot scene

Abstract

This invention discloses a database architecture design method and system for ETC parking scenarios, belonging to the field of smart parking technology. It includes the following steps: First, an image database cloud is established. Then, parking information is identified and filtered through the image database cloud. Finally, the filtered information is output to the bank settlement system. By constructing an image database structure from data in various platform databases using image technology, and then building the image database cloud based on ETC recognition, the image database cloud is used to receive parking fee information and connect with the bank settlement system. This achieves cross-platform database compatibility, optimizes dynamic database calling efficiency, and enhances the creativity and efficiency of data-driven scenario applications. Furthermore, it utilizes ETC recognition devices established at road intersections for identification and fee settlement, reducing the upgrade cost of existing parking systems and facilitating the promotion of ETC parking systems.

Description

Technical Field

[0001] This invention relates to the field of smart parking technology, and more specifically, to a database architecture design method and system for ETC parking scenarios. Background Technology

[0002] With the accelerating pace of urbanization and motorization, the shortage of parking resources has become a major problem restricting traffic development and hindering urban management. According to statistics from the Ministry of Public Security, in 2020, my country's total number of motor vehicles reached 372 million, of which 281 million were cars. Data released by the National Development and Reform Commission in 2015 showed that the average ratio of cars to parking spaces in large cities was approximately 1:0.8, while in small and medium-sized cities it was approximately 1:0.5. In recent years, the contradiction between parking supply and demand has become increasingly prominent. Taking Beijing as an example, the city currently has approximately 7,000 registered parking lots with about 3.82 million parking spaces, and about 65,000 registered roadside parking spaces, while the number of cars exceeds 6.3 million. The number of parking spaces in the city is far from meeting the growing demand for cars from the public.

[0003] At the city level, transportation is always connected to the city and society. Transportation is the basic guarantee for economic and social development. To promote economic transformation and development and build smart cities, we need to firmly grasp the role of transportation as a "pioneer" and accelerate the integration of ten networks, including transportation infrastructure network, transportation network, service network, energy network, and information network, through information technology. This will enable comprehensive connection between transportation and the city and society, support and drive the development of smart cities, and connect the industrial chains of finance, services, and manufacturing.

[0004] Electronic Toll Collection (ETC) is a system that automatically performs functions such as vehicle identification, toll collection, lane equipment control, and toll data processing without requiring vehicles to stop. As of December 2020, there were 225 million ETC users nationwide, with a 70.31% usage rate for passenger vehicles.

[0005] As a contactless and secure payment method, ETC's widespread application at the city level can greatly improve user service levels and user experience, while effectively increasing the utilization efficiency of ETC devices and optimizing the allocation of social resources. Applying ETC to smart city governance, traffic management, and services can effectively support urban digital development: on the one hand, it can serve as a primary device for urban traffic sensing, enabling the collection of vehicle trajectory and status data across the entire travel chain, thus providing data support for urban traffic planning, congestion management, and public transport priority; on the other hand, ETC can connect the automotive service payment industry chain, including refueling, parking, repair, and insurance, empowering smart cities and driving the rapid development of the smart city digital transportation economy, thereby achieving a transformation in the smart city digital transportation economic development model.

[0006] The urban parking problem cannot be solved simply by expanding infrastructure. Only by rationally allocating land resources and continuously improving the intelligence level of parking management can we effectively solve problems such as high parking operating costs, traffic congestion, and poor travel experience for the public. ETC technology can serve as an important vehicle for connecting urban and intercity transportation, effectively solving the problem of urban static traffic management, improving the level of public travel services, and reducing pollutant emissions from parking lots. It is an effective means to increase the happiness of the people and an important foundation for building civilized, smart, green, and safe cities. It can also provide support for exploring and unlocking new industries and new fields.

[0007] In existing technologies, the main method of electronic payment for parking lots is mobile payment. The toll collection system is built on the public network environment, which is different from the closed private network and industry-specific management of highway toll collection. The public network environment cannot guarantee the security of ETC devices, and data transmission is also at risk of being tampered with. Furthermore, the ETC toll collection process requires cross-platform cooperation with the existing parking toll collection system, and the compatibility and communication recognition speed between cross-platform databases are particularly important. Summary of the Invention

[0008] The purpose of this invention is to provide a database architecture design method and system for ETC parking scenarios, which can achieve compatibility between cross-platform databases and enable faster data exchange and recognition.

[0009] The second objective of this invention is to provide a database architecture system designed using the above-described design method.

[0010] To solve the above problems, the present invention adopts the following technical solution:

[0011] A database architecture design method and system for ETC parking scenarios includes the following steps:

[0012] S1. Store basic vehicle information through images and establish a basic vehicle information database;

[0013] S2. Store license plate information through images and establish a license plate information database;

[0014] S3. Construct ETC identification information image conversion software to convert ETC identification information into images and store them to establish an ETC identification information database;

[0015] S4. Install ETC recognition devices at urban traffic intersections, and each ETC recognition device generates location information images based on the geographical location information of the intersection using image conversion software, forming a recognition location information database;

[0016] S5. Construct a central dispatch module for the image database. The ETC recognition system at urban traffic intersections, in conjunction with cameras, transmits the identified vehicle information to the central dispatch module for the image database. The central dispatch module for the image database arranges the vehicle basic information image, license plate information image, location information image, and ETC recognition information image from left to right, and synthesizes a comprehensive vehicle information image to form an image database cloud.

[0017] S6. Generate settlement standard images by using image conversion software to identify the locations and charging standards of different parking systems, and establish a settlement standard database.

[0018] S7. Parking duration information in the parking system is generated into images using image conversion software to establish a parking duration database.

[0019] S8. The existing parking system uses the existing video surveillance system and license plate recognition system to capture images of basic vehicle information and license plate information, and uploads them to the cloud server for recognition.

[0020] S9. Construct a database output adaptation module. The database output adaptation module is equipped with a filtering module. Based on the existing parking system's request for different data recognition, the module filters out the corresponding comprehensive vehicle information images from the corresponding image database cloud.

[0021] S10. When the parking system detects that a vehicle has completed parking, it combines the vehicle basic information image, license plate information image, settlement standard image, and parking duration image into a charging information image and transmits it to the database output adaptation module. The database output adaptation module identifies the vehicle basic information image and license plate information image in the charging information image, and then identifies the corresponding settlement standard image and parking duration image to obtain the corresponding vehicle parking location and duration. Then, based on the parking location, it retrieves the latest vehicle comprehensive information image from all comprehensive information images of the vehicle, combines the ETC identification information image, settlement standard image, and parking duration image from the latest vehicle comprehensive information image into a deduction result image, and transmits the deduction result image to the bank settlement system.

[0022] S11. The bank settlement system identifies the deduction result image, calculates the parking fee based on the results identified from the settlement standard image and the parking duration image, and deducts the fee from the ETC account identified by the ETC identification information image.

[0023] As a preferred embodiment of the present invention, the vehicle basic information in S1 includes vehicle color, vehicle type, and vehicle brand, and different vehicle types and different vehicle brands correspond to color blocks with different RGB values, and the vehicle basic information image is composed of three color blocks.

[0024] As a preferred embodiment of the present invention, the license plate information in S2 includes license plate type, license plate area information and number information, and different license plate types, different license plate area information and different number information correspond to color blocks with different RGB values, and the license plate information image is composed of three color blocks.

[0025] As a preferred embodiment of the present invention, the ETC identification information image in S3 is converted into RGB color blocks after the ETC identification information definition values ​​are allocated, and then an encrypted image is formed by the RGB color blocks.

[0026] As a preferred embodiment of the present invention, the comprehensive vehicle information stored in the central scheduling module of the image database in S5 automatically archives the comprehensive vehicle information image at the time of the parking fee deduction and deletes other comprehensive vehicle information images.

[0027] As a preferred embodiment of the present invention, the existing parking system in S8 includes parking lots and roadside parking spaces, and the video surveillance system for roadside parking spaces can be directly upgraded using the graphic recognition function of the existing road monitoring system.

[0028] As a preferred embodiment of the present invention, in S10, the monitoring system and license plate recognition system of the parking system are connected to transmit the recognized vehicle image information to the database output adaptation module for step-by-step vehicle recognition. The recognition order is vehicle basic information and license plate information. The filtering module selects data groups that meet the conditions from the image database cloud according to the recognition module results, and uses these filtered data groups as the next recognition database to complete the vehicle screening.

[0029] As a preferred embodiment of the present invention, in step S10, before transmitting the deduction result image to the bank settlement system, the location information of the settlement standard image and the latest time vehicle comprehensive information image is checked.

[0030] A database architecture system for ETC parking scenarios includes an image database cloud, which is equipped with an image database central scheduling module and a database output adaptation module. The image database central scheduling module is connected and interacts with a vehicle basic information database, a license plate information database, an ETC recognition information database, and a recognition location information database. The database output adaptation module interacts with the parking system and the bank settlement system.

[0031] As a preferred embodiment of the present invention, the image database cloud is set on the ETC multi-scenario service platform, the vehicle basic information database and the license plate information database are stored in the national vehicle management office information storage system, the ETC identification information database is stored in the ETC toll collection system, and the identification location information database is stored in the traffic management system.

[0032] Compared with the prior art, the advantages of this invention are:

[0033] This solution constructs an image database structure from data within various platform databases using image technology, and then builds an image database cloud based on ETC recognition. The image database cloud is used to receive parking fee information and connect with the bank settlement system, achieving cross-platform database compatibility, optimizing the efficiency of dynamic database calls, and enhancing the creativity and efficiency of data-driven application scenarios. Furthermore, it utilizes ETC recognition devices established at road intersections for recognition and fee settlement, reducing the upgrade cost of existing parking systems and facilitating the promotion of ETC parking systems. Attached Figure Description

[0034] Figure 1 This is a flowchart illustrating the architecture of the present invention;

[0035] Figure 2 This is a system structure block diagram of the present invention. Detailed Implementation

[0036] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only a part of the embodiments of the present invention, and not all of them. All other embodiments obtained by those skilled in the art based on the embodiments of the present invention without creative effort are within the scope of protection of the present invention.

[0037] In the description of this invention, it should be noted that the terms "upper," "lower," "inner," "outer," "top / bottom," etc., indicate the orientation or positional relationship based on the orientation or positional relationship shown in the accompanying drawings. They are used only for the convenience of describing the invention and for simplifying the description, and do not indicate or imply that the device or element referred to must have a specific orientation, or be constructed and operated in a specific orientation. Therefore, they should not be construed as limitations on the invention. Furthermore, the terms "first" and "second" are used for descriptive purposes only and should not be construed as indicating or implying relative importance.

[0038] In the description of this invention, it should be noted that, unless otherwise explicitly specified and limited, the terms "installed," "equipped with," "sleeved / connected," "connected," etc., should be interpreted broadly. For example, "connection" can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection or an indirect connection through an intermediate medium; it can be a connection within two components. Those skilled in the art can understand the specific meaning of the above terms in this invention based on the specific circumstances.

[0039] Example:

[0040] Please see Figure 1A database architecture design method and system for ETC parking scenarios includes the following steps:

[0041] S1. Store basic vehicle information through images and establish a basic vehicle information database;

[0042] The vehicle's basic information includes the vehicle's color, type, and brand. Different vehicle types and brands correspond to different RGB color blocks, and the vehicle's basic information image consists of three color blocks.

[0043] S2. Store license plate information through images and establish a license plate information database;

[0044] The license plate information includes the license plate type, license plate area information, and number information. Different license plate types, different license plate areas, and different number information correspond to different RGB color blocks. The license plate information image consists of three color blocks.

[0045] S3. Construct ETC identification information image conversion software to convert ETC identification information into images and store them to establish an ETC identification information database;

[0046] The ETC identification information image is an encrypted image composed of RGB color blocks after the ETC identification information is defined and numerically assigned.

[0047] S4. Install ETC recognition devices at urban traffic intersections, and each ETC recognition device generates location information images based on the geographical location information of the intersection using image conversion software, forming a recognition location information database;

[0048] In an era where visualization tools are widely used, by visualizing data into images to form visual information pictures, it is possible to achieve invisible storage of databases, multi-dimensional data retrieval, visualized data retrieval efficiency management, cross-database platform compatibility, dynamic database retrieval efficiency optimization, and enhance the creativity and efficiency of data-driven application scenarios.

[0049] S5. Construct a central dispatch module for the image database. The ETC recognition system at urban traffic intersections, in conjunction with cameras, transmits the identified vehicle information to the central dispatch module for the image database. The central dispatch module for the image database arranges the vehicle basic information image, license plate information image, location information image, and ETC recognition information image from left to right, and synthesizes a comprehensive vehicle information image to form an image database cloud.

[0050] The comprehensive vehicle information stored in the central dispatch module of the image database automatically archives the comprehensive vehicle information image at the time of the parking fee deduction and deletes other comprehensive vehicle information images, reducing unnecessary data storage in the image database cloud and improving subsequent retrieval efficiency.

[0051] S6. Generate settlement standard images by using image conversion software to identify the locations and charging standards of different parking systems, and establish a settlement standard database.

[0052] S7. Parking duration information in the parking system is generated into images using image conversion software to establish a parking duration database.

[0053] S8. The existing parking system uses the existing video surveillance system and license plate recognition system to capture images of basic vehicle information and license plate information, and uploads them to the cloud server for recognition.

[0054] The existing parking system includes parking lots and roadside parking spaces. The video surveillance system for roadside parking spaces can be directly upgraded using the graphic recognition function of the existing road monitoring system, which facilitates the transformation of the existing parking system into an ETC parking fee system. This allows for parking and departure at any time, greatly reducing parking waiting time, reducing manpower consumption, and significantly lowering urban parking costs.

[0055] S9. Construct a database output adaptation module. The database output adaptation module is equipped with a filtering module. Based on the existing parking system's request for different data recognition, the module filters out the corresponding comprehensive vehicle information images from the corresponding image database cloud.

[0056] Because existing parking systems use different charging methods, the system filters based on the different identification information fed back by manual, license plate recognition charging modes and the latest upgraded ETC charging system. This improves the applicability of the system and facilitates the transformation and upgrading of old parking charging systems.

[0057] S10. When the parking system detects that a vehicle has completed parking, it combines the vehicle basic information image, license plate information image, settlement standard image, and parking duration image into a charging information image and transmits it to the database output adaptation module. The database output adaptation module identifies the vehicle basic information image and license plate information image in the charging information image, and then identifies the corresponding settlement standard image and parking duration image to obtain the corresponding vehicle parking location and duration. Then, based on the parking location, it retrieves the latest vehicle comprehensive information image from all comprehensive information images of the vehicle, combines the ETC identification information image, settlement standard image, and parking duration image from the latest vehicle comprehensive information image into a deduction result image, and transmits the deduction result image to the bank settlement system.

[0058] The parking system's monitoring system and license plate recognition system are connected to transmit the recognized vehicle image information to the database output adaptation module for step-by-step vehicle recognition. The recognition order is vehicle basic information and license plate information. The filtering module selects data groups that meet the conditions from the image database cloud based on the recognition module's results. These filtered data groups are used as the next recognition database to complete the vehicle screening. The distributed selection reduces the screening workload and improves data processing efficiency.

[0059] Before transmitting the deduction result image to the bank's settlement system, the location information of the settlement standard image and the latest vehicle comprehensive information image is checked. By verifying the information that the vehicle passed near the ETC recognition device near the parking location in the most recent time, it is possible to effectively reduce erroneous charges caused by recognition errors in old parking systems and ensure the safety of users' property.

[0060] S11. The bank settlement system identifies the deduction result image, calculates the parking fee based on the results identified from the settlement standard image and the parking duration image, and deducts the fee from the ETC account identified by the ETC identification information image.

[0061] Please see Figure 2 A database architecture system for ETC parking scenarios includes an image database cloud, which is equipped with an image database central scheduling module and a database output adaptation module. The image database central scheduling module is connected and interacts with a vehicle basic information database, a license plate information database, an ETC recognition information database, and a recognition location information database. The database output adaptation module interacts with the parking system and the bank settlement system.

[0062] Specifically, the image database is located in the ETC multi-scenario service platform, the vehicle basic information database and license plate information database are stored in the national vehicle management office information storage system, the ETC identification information database is stored in the ETC toll collection system, and the identification location information database is stored in the traffic management system.

[0063] Working principle: Data from the ETC multi-scenario service platform, the national vehicle management office information storage system, the ETC toll collection system, and the traffic management system platform databases are constructed into an image database structure using image technology. Then, an image database cloud is built based on ETC recognition. The image database cloud is used to receive parking fee information and connect with the bank settlement system. It is cross-platform database compatible, optimizes the efficiency of dynamic database calls, and enhances the creativity and efficiency of data scenario applications. Furthermore, it uses ETC recognition devices built at road intersections for recognition and toll settlement, reducing the upgrade cost of existing parking systems and facilitating the promotion of ETC parking systems.

[0064] The above description is only a preferred embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Any equivalent substitutions or modifications made by those skilled in the art within the scope of the technology disclosed in the present invention, based on the technical solution and its improved concept, should be covered within the scope of protection of the present invention.

Claims

1. A database architecture design method for ETC parking scenarios, characterized in that, It includes the following steps: S1. Store basic vehicle information through images and establish a basic vehicle information database; S2. Store license plate information through images and establish a license plate information database; S3. Construct ETC identification information image conversion software to convert ETC identification information into images and store them to establish an ETC identification information database. The ETC identification information images are converted into RGB color blocks after the ETC identification information defines numerical values ​​and is then used to create encrypted images composed of RGB color blocks. S4. Install ETC recognition devices at urban traffic intersections, and each ETC recognition device generates location information images based on the geographical location information of the intersection using image conversion software, forming a recognition location information database; S5. Construct a central dispatch module for the image database. The ETC recognition system at urban traffic intersections, in conjunction with cameras, transmits the identified vehicle information to the central dispatch module for the image database. The central dispatch module for the image database arranges the vehicle basic information image, license plate information image, location information image, and ETC recognition information image from left to right, and synthesizes a comprehensive vehicle information image to form an image database cloud. S6. Generate settlement standard images by using image conversion software to identify the locations and charging standards of different parking systems, and establish a settlement standard database. S7. Parking duration information in the parking system is generated into images using image conversion software to establish a parking duration database. S8. The existing parking system uses the existing video surveillance system and license plate recognition system to capture images of basic vehicle information and license plate information, and uploads them to the cloud server for recognition. S9. Construct a database output adaptation module. The database output adaptation module is equipped with a filtering module. Based on the existing parking system's request for different data recognition, the module filters out the corresponding comprehensive vehicle information images from the corresponding image database cloud. S10. When the parking system detects that a vehicle has completed parking, it combines the vehicle basic information image, license plate information image, settlement standard image, and parking duration image into a charging information image and transmits it to the database output adaptation module. The database output adaptation module identifies the vehicle basic information image and license plate information image in the charging information image, and then identifies the corresponding settlement standard image and parking duration image to obtain the corresponding vehicle parking location and duration. Then, based on the parking location, it retrieves the latest vehicle comprehensive information image from all comprehensive information images of the vehicle, combines the ETC identification information image, settlement standard image, and parking duration image from the latest vehicle comprehensive information image into a deduction result image, and transmits the deduction result image to the bank settlement system. S11. The bank settlement system identifies the deduction result image, calculates the parking fee based on the results identified from the settlement standard image and the parking duration image, and deducts the fee from the ETC account identified by the ETC identification information image.

2. The database architecture design method for ETC parking scenarios according to claim 1, characterized in that: The vehicle basic information in S1 includes vehicle color, vehicle type, and vehicle brand. Different vehicle types and different vehicle brands correspond to color blocks with different RGB values. The vehicle basic information image consists of three color blocks.

3. The database architecture design method for ETC parking scenarios according to claim 1, characterized in that: The license plate information in S2 includes license plate type, license plate area information, and number information. Different license plate types, different license plate area information, and different number information correspond to color blocks with different RGB values. The license plate information image consists of three color blocks.

4. The database architecture design method for ETC parking scenarios according to claim 1, characterized in that: The comprehensive vehicle information stored in the central scheduling module of the image database in S5 is automatically archived when a vehicle is charged parking fees, and other comprehensive vehicle information images are deleted.

5. The database architecture design method for ETC parking scenarios according to claim 1, characterized in that: The existing parking system in S8 includes parking lots and roadside parking spaces, and the video surveillance system for roadside parking spaces can be directly upgraded using the graphic recognition function of the existing road monitoring system.

6. The database architecture design method for ETC parking scenarios according to claim 1, characterized in that: In S10, the parking system's monitoring system and license plate recognition system are connected to transmit the recognized vehicle image information to the database output adaptation module for step-by-step vehicle recognition. The recognition order is vehicle basic information and license plate information. The filtering module selects data groups that meet the conditions from the image database cloud based on the recognition module's results. These filtered data groups are used as the next recognition database to complete the vehicle screening.

7. According to claim 1, in the database architecture design method for ETC parking scenarios, before transmitting the deduction result image to the bank settlement system in step S10, the location information of the settlement standard image and the latest time vehicle comprehensive information image is checked.

8. A database architecture design method for ETC parking scenarios according to claim 1, including an image database cloud, characterized in that: The image database cloud is equipped with an image database central scheduling module and a database output adaptation module. The image database central scheduling module is connected and interacts with the vehicle basic information database, license plate information database, ETC recognition information database and recognition location information database. The database output adaptation module interacts with the parking system and the bank settlement system.

9. A database architecture design method for ETC parking scenarios according to claim 8, characterized in that: The image database is located on the ETC multi-scenario service platform, the vehicle basic information database and license plate information database are stored in the national vehicle management office information storage system, the ETC identification information database is stored in the ETC toll collection system, and the identification location information database is stored in the traffic management system.

Images