CN112084207B - Road network vehicle real-time query speed optimization method - Google Patents
Road network vehicle real-time query speed optimization method Download PDFInfo
- Publication number
- CN112084207B CN112084207B CN202011006345.XA CN202011006345A CN112084207B CN 112084207 B CN112084207 B CN 112084207B CN 202011006345 A CN202011006345 A CN 202011006345A CN 112084207 B CN112084207 B CN 112084207B
- Authority
- CN
- China
- Prior art keywords
- data
- license plate
- vehicle
- distributed cache
- key
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2358—Change logging, detection, and notification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24552—Database cache management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
- G06F16/9532—Query formulation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
- G06F16/9538—Presentation of query results
-
- G—PHYSICS
- G07—CHECKING-DEVICES
- G07B—TICKET-ISSUING APPARATUS; FARE-REGISTERING APPARATUS; FRANKING APPARATUS
- G07B15/00—Arrangements or apparatus for collecting fares, tolls or entrance fees at one or more control points
- G07B15/06—Arrangements for road pricing or congestion charging of vehicles or vehicle users, e.g. automatic toll systems
Abstract
The invention relates to a road network vehicle real-time query speed optimization method in the technical field of traffic information, which comprises the steps of building a distributed cache module based on a memory and storing by adopting key-value pairs; establishing an entrance data receiving service data flow of a toll station, an ETC portal data receiving service data flow and an exit data receiving service data flow of the toll station; summarizing and transmitting the data to a distributed cache module, and constructing a client side road network vehicle retrieval query module and connecting the client side road network vehicle retrieval query module with the distributed cache module in a data mode; the method comprises the steps that a user initiates a data retrieval and query request to a road network vehicle retrieval and query module, the road network vehicle retrieval and query module converts conditions input by the user into 'license plate number _ license plate color' as a query key value, and key retrieval and screening are carried out in a distributed cache module and displayed to a user terminal interface.
Description
Technical Field
The invention relates to the technical field of traffic information, in particular to a method for optimizing real-time query speed of vehicles in a road network.
Background
In recent years, with the development of economy, highway construction and operation and maintenance enter a new stage. The newly opened highway sections are more and more, the vehicle passing mileage is longer and longer, the highway traffic is more and more convenient day by day, the highway on various trucks and cars is more and more, the real-time requirement of related services such as inspection and the like on the vehicle passing information retrieval is higher and higher, and the original system carries out the vehicle retrieval based on the charging flow data and the license plate identification data. Existing vehicle information is respectively stored in 1) an artificial lane charging flow water inlet table; 2) An artificial lane charging running water outlet meter; 3) A portal flow meter; 4) ETC lane entrance and exit flow water meter; 5) a toll station license plate identification data table; 6) and a door frame license plate identification data table. In order to realize the retrieval of the vehicle traffic information, the original system needs to firstly determine the traffic medium (ETC or pass card) of the vehicle, needs to inquire from a plurality of tables 1), 2) and 4), then obtains corresponding data from the table 3) according to the inquiry result, and then carries out correlation inquiry with the tables 5) and 6) through a series of operations, thereby obtaining the traffic information of a single vehicle. The prior art has the following defects: the data storage positions are not centralized, the single pass record of one vehicle is inquired, multiple tables need to be correlated for inquiry, and a large amount of computing resources are consumed; the real-time performance of the data is poor, and the data mentioned above are gathered when the single pass record of one vehicle is inquired.
Disclosure of Invention
The invention aims to overcome the defects of the prior art and provide a road network vehicle real-time query speed optimization method which has the advantages of centralized data storage, less associated redundancy, quick query feedback and good real-time performance.
JSON is an acronym for JavaScript Object Notation in english, and is a lightweight data exchange format that stores and represents data in a text format completely independent of programming languages based on a subset of ECMAScript (js specification set by the european computer association).
The key-value pair is a Chinese name corresponding to an English key-value pair, and is an implementation of mapping in mathematical concepts, wherein a key (key) is used as an index of elements, and a value (value) represents stored and read data.
In order to achieve the purpose, the invention adopts the following technical scheme.
A road network vehicle real-time query speed optimization method specifically comprises the following steps:
step S1: building a distributed cache module based on a memory, and storing by adopting key-value pairs, wherein the 'license plate number _ license plate color' is used as a key, and station information, vehicle type and time information corresponding to the license plate number are packaged into a JSON array format to be used as values for storage;
step S2: establishing a toll station entrance data receiving service data stream, and writing the running water data and the license plate identification data of passing vehicles into a distributed cache according to the format of the step S1 when the vehicles enter the toll station entrance, and storing the running water data and the license plate identification data as vehicle passing record data;
step S3: establishing an ETC portal data receiving service data flow, and updating portal running water data and license plate identification data into corresponding vehicle passing record data in the step S2 whenever a vehicle passes through the ETC portal;
step S4: establishing a toll station exit data receiving service data stream, and writing the running water data and the license plate identification data of passing vehicles into a distributed cache according to the format of the step S1 when the vehicles enter the toll station exit, and storing the running water data and the license plate identification data as vehicle passing record data;
step S5: summarizing the vehicle passing records from the step S2 to the step S4 to obtain complete vehicle storage data, transmitting the complete vehicle storage data to a distributed cache module, and building a user-side road network vehicle retrieval query module and connecting the vehicle retrieval query module with the distributed cache module;
step 6: when a user needs to inquire, a data retrieval and inquiry request is sent to a highway network vehicle retrieval and inquiry module through terminal equipment, the highway network vehicle retrieval and inquiry module converts the condition input by the user into 'license plate number _ license plate color' as a query key value, key retrieval and screening are carried out in a distributed cache module based on a memory, if a corresponding key exists in the distributed cache module, a JSON array corresponding to the extracted key is executed, and the JSON array is displayed on a user terminal interface.
As a further improvement of the present invention, the toll station entrance data receiving service data stream extracts license plate number, license plate color, vehicle type, time and station information in the streaming data, uses "license plate number _ license plate color" as a key, and simultaneously encapsulates the corresponding vehicle type, time, station, picture and address information into data in JSON format to write the data into the memory-based distributed cache module.
As a further improvement of the invention, the toll station outlet data receiving service data stream extracts license plate number, license plate color, vehicle type, time and station information in the running water data, whether data with 'license plate number _ license plate color' as a key exists or not is positioned in a distributed cache module based on an internal memory, if so, a corresponding value is extracted, and newly added data is added into a corresponding JSON array; if the data does not exist, the 'license plate number _ license plate color' is used as a key, and the data with the vehicle type, time, site, picture and address information packaged into a JSON format is written into the memory-based distributed cache module.
Due to the application of the technical scheme, the technical scheme of the invention has the following beneficial effects: the technical scheme is based on a distributed cache module of a memory and adopts a key-value pair storage structure, so that the acquisition and storage speed of the vehicle passing data of the road network is greatly improved; the technical scheme also establishes a toll station entrance data receiving service data flow, an ETC portal data receiving service data flow and a toll station exit data receiving service data flow respectively, so that the vehicle passing class data can be acquired in multiple directions, the completeness and richness of the data are ensured, and a foundation is provided for the road network vehicle information management; the technical scheme also comprises that a road network vehicle retrieval query module is arranged to convert the conditions input by the user into 'license plate number _ license plate color' as a query key value, and key retrieval screening is carried out in the distributed cache module based on the memory.
Detailed Description
The present invention will be described in further detail with reference to the following reaction schemes and specific examples.
A road network vehicle real-time query speed optimization method specifically comprises the following steps:
step S1: building a distributed cache module based on a memory, and storing by adopting key-value pairs, wherein the 'license plate number _ license plate color' is used as a key, and station information, vehicle type and time information corresponding to the license plate number are packaged into a JSON array format to be used as values for storage;
step S2: establishing a toll station entrance data receiving service data stream, and writing the running water data and the license plate identification data of passing vehicles into a distributed cache according to the format of the step S1 when the vehicles enter the toll station entrance, and storing the running water data and the license plate identification data as vehicle passing record data;
step S3: establishing an ETC portal data receiving service data flow, and updating portal running water data and license plate identification data into corresponding vehicle passing record data in the step S2 whenever a vehicle passes through the ETC portal;
step S4: establishing a toll station exit data receiving service data stream, and writing the running water data and the license plate identification data of passing vehicles into a distributed cache according to the format of the step S1 when the vehicles enter the toll station exit, and storing the running water data and the license plate identification data as vehicle passing record data;
step S5: summarizing the vehicle passing records from the step S2 to the step S4 to obtain complete vehicle storage data, transmitting the complete vehicle storage data to a distributed cache module, and building a user-side road network vehicle retrieval query module and connecting the vehicle retrieval query module with the distributed cache module;
step 6: when a user needs to inquire, a data retrieval and inquiry request is sent to a highway network vehicle retrieval and inquiry module through terminal equipment, the highway network vehicle retrieval and inquiry module converts the condition input by the user into 'license plate number _ license plate color' as a query key value, key retrieval and screening are carried out in a distributed cache module based on a memory, if a corresponding key exists in the distributed cache module, a JSON array corresponding to the extracted key is executed, and the JSON array is displayed on a user terminal interface.
And the toll station entrance data receiving service data stream extracts license plate number, license plate color, vehicle type, time and station information in the stream data, takes the license plate number _ license plate color as a key, and simultaneously packages the corresponding vehicle type, time, station, picture and address information into data in a JSON format to be written into a distributed cache module based on the memory.
The toll station outlet data receiving service data stream extracts license plate numbers, license plate colors, vehicle types, time and station information in the stream data, whether data with 'license plate number _ license plate color' as a key exists or not is positioned in a distributed cache module based on a memory, if yes, a corresponding value is extracted, and newly added data are added into a corresponding JSON array; if the data does not exist, the 'license plate number _ license plate color' is used as a key, and the data with the vehicle type, time, site, picture and address information packaged into a JSON format is written into the memory-based distributed cache module.
The above is only a specific application example of the present invention, and the protection scope of the present invention is not limited in any way. All the technical solutions formed by equivalent transformation or equivalent replacement fall within the protection scope of the present invention.
Claims (3)
1. A road network vehicle real-time query speed optimization method is characterized by specifically comprising the following steps:
step S1: building a distributed cache module based on a memory, and storing by adopting key-value pairs, wherein the 'license plate number _ license plate color' is used as a key, and station information, vehicle type and time information corresponding to the license plate number are packaged into a JSON array format to be used as values for storage;
step S2: establishing a toll station entrance data receiving service data stream, and writing the running water data and the license plate identification data of passing vehicles into a distributed cache according to the format of the step S1 when the vehicles enter the toll station entrance, and storing the running water data and the license plate identification data as vehicle passing record data;
step S3: establishing an ETC portal data receiving service data flow, and updating portal running water data and license plate identification data into corresponding vehicle passing record data in the step S2 whenever a vehicle passes through the ETC portal;
step S4: establishing a toll station exit data receiving service data stream, and writing the running water data and the license plate identification data of passing vehicles into a distributed cache according to the format of the step S1 when the vehicles enter the toll station exit, and storing the running water data and the license plate identification data as vehicle passing record data;
step S5: summarizing the vehicle passing records from the step S2 to the step S4 to obtain complete vehicle storage data, transmitting the complete vehicle storage data to a distributed cache module, and building a user-side road network vehicle retrieval query module and connecting the vehicle retrieval query module with the distributed cache module;
step 6: when a user needs to inquire, a data retrieval and inquiry request is sent to a highway network vehicle retrieval and inquiry module through terminal equipment, the highway network vehicle retrieval and inquiry module converts the condition input by the user into 'license plate number _ license plate color' as a query key value, key retrieval and screening are carried out in a distributed cache module based on a memory, if a corresponding key exists in the distributed cache module, a JSON array corresponding to the extracted key is executed, and the JSON array is displayed on a user terminal interface.
2. The method for optimizing the real-time query speed of road network vehicles according to claim 1, wherein the method comprises the following steps: and the toll station entrance data receiving service data stream extracts license plate number, license plate color, vehicle type, time and station information in the stream data, takes the license plate number _ license plate color as a key, and simultaneously packages the corresponding vehicle type, time, station, picture and address information into data in a JSON format to be written into a distributed cache module based on the memory.
3. The method for optimizing the real-time query speed of road network vehicles according to claim 1, wherein the method comprises the following steps: the toll station outlet data receiving service data stream extracts license plate numbers, license plate colors, vehicle types, time and station information in the stream data, whether data with 'license plate number _ license plate color' as a key exists or not is positioned in a distributed cache module based on a memory, if yes, a corresponding value is extracted, and newly added data are added into a corresponding JSON array; if the data does not exist, the 'license plate number _ license plate color' is used as a key, and the data with the vehicle type, time, site, picture and address information packaged into a JSON format is written into the memory-based distributed cache module.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011006345.XA CN112084207B (en) | 2020-09-23 | 2020-09-23 | Road network vehicle real-time query speed optimization method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011006345.XA CN112084207B (en) | 2020-09-23 | 2020-09-23 | Road network vehicle real-time query speed optimization method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112084207A CN112084207A (en) | 2020-12-15 |
| CN112084207B true CN112084207B (en) | 2022-04-29 |
Family
ID=73738625
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011006345.XA Active CN112084207B (en) | 2020-09-23 | 2020-09-23 | Road network vehicle real-time query speed optimization method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112084207B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103810298A (en) * | 2014-03-07 | 2014-05-21 | 苏州科达科技股份有限公司 | Main memory database based rapid vehicle information query method and system |
| CN104462222A (en) * | 2014-11-11 | 2015-03-25 | 安徽四创电子股份有限公司 | Distributed storage method and system for checkpoint vehicle pass data |
| CN110956811A (en) * | 2019-10-31 | 2020-04-03 | 厦门路桥信息股份有限公司 | Method, medium, equipment and device for rapidly processing license plate recognition errors of parking lot |
| CN111404966A (en) * | 2020-04-03 | 2020-07-10 | 广东利通科技投资有限公司 | Data processing method of expressway video monitoring system |
-
2020
- 2020-09-23 CN CN202011006345.XA patent/CN112084207B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103810298A (en) * | 2014-03-07 | 2014-05-21 | 苏州科达科技股份有限公司 | Main memory database based rapid vehicle information query method and system |
| CN104462222A (en) * | 2014-11-11 | 2015-03-25 | 安徽四创电子股份有限公司 | Distributed storage method and system for checkpoint vehicle pass data |
| CN110956811A (en) * | 2019-10-31 | 2020-04-03 | 厦门路桥信息股份有限公司 | Method, medium, equipment and device for rapidly processing license plate recognition errors of parking lot |
| CN111404966A (en) * | 2020-04-03 | 2020-07-10 | 广东利通科技投资有限公司 | Data processing method of expressway video monitoring system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112084207A (en) | 2020-12-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101694952B (en) | Method for generating embedded telecontrol system definitions by IEC61850 SCD files | |
| CN109376210A (en) | A kind of intelligence pollution sources dynamic management system and method | |
| CN104732205A (en) | System for checking expressway toll evasion | |
| CN106600103A (en) | Statistic data model building method facing programs, plans, and decisions | |
| CN102780574A (en) | Service-oriented office data collocation method and device as well as service-oriented office data inspection method and device | |
| CN106452940A (en) | Method and device for identifying Internet business flow ownership | |
| CN107124325A (en) | A kind of power communication network operation safety evaluation method and system | |
| CN106874114A (en) | Express delivery management software system | |
| Wang et al. | Big data in telecommunication operators: data, platform and practices | |
| KR102150280B1 (en) | Linked platform for urban river management | |
| CN109618250A (en) | A kind of fiber optic network node administration method and system | |
| CN112084207B (en) | Road network vehicle real-time query speed optimization method | |
| CN111460064A (en) | Two-dimensional and three-dimensional GIS service platform | |
| CN111241055A (en) | Processing system of iron and steel enterprise data center heterogeneous data | |
| CN106599216A (en) | Computer based training courseware publishing system | |
| CN113902583A (en) | Distribution network side operation and maintenance method and system using low-voltage network equipment data | |
| CN108563706A (en) | A kind of collection big data intelligent service system and its operation method | |
| CN111739180B (en) | Path segmentation method based on ETC portal frame | |
| CN1413024A (en) | Digital TV user management system | |
| CN115545663A (en) | Urban rail transit asset information matching method based on contract asset mapping model | |
| CN113742386B (en) | Processing and analyzing method for block data of block chain account book | |
| CN111739176B (en) | ETC portal vehicle passing data processing method | |
| CN102842101A (en) | Traffic violation data processing method and system | |
| CN108108444A (en) | A kind of business event unit self-adapting system and its implementation | |
| CN113157925A (en) | Intelligent government affair analysis system based on big data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |