CN111597210A - Road network track bidirectional query method based on dynamic pre-storage - Google Patents
Road network track bidirectional query method based on dynamic pre-storage Download PDFInfo
- Publication number
- CN111597210A CN111597210A CN202010379782.XA CN202010379782A CN111597210A CN 111597210 A CN111597210 A CN 111597210A CN 202010379782 A CN202010379782 A CN 202010379782A CN 111597210 A CN111597210 A CN 111597210A
- Authority
- CN
- China
- Prior art keywords
- dynamic
- query
- track
- shortest path
- sub
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 24
- 230000002457 bidirectional effect Effects 0.000 title claims abstract description 22
- 238000004364 calculation method Methods 0.000 claims abstract description 21
- 230000003068 static effect Effects 0.000 claims description 4
- 238000005457 optimization Methods 0.000 abstract description 3
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000000977 initiatory effect Effects 0.000 description 1
- 238000005070 sampling Methods 0.000 description 1
- 238000010845 search algorithm Methods 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
Images
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/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
-
- 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/24553—Query execution of query operations
- G06F16/24554—Unary operations; Data partitioning operations
- G06F16/24556—Aggregation; Duplicate elimination
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
-
- 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/29—Geographical information databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Remote Sensing (AREA)
- Navigation (AREA)
Abstract
The invention provides a road network track bidirectional query method based on dynamic pre-storage, which is applied to the field of track query optimization. The method can optimize the traditional solution based on the pre-storage according to the dynamic time warping, the point-to-cluster grouping and the bidirectional search based on the dynamic pre-storage, reduce a large amount of repeated calculation during the shortest path query among the tracks and obviously improve the query efficiency. The technology mainly comprises three parts, wherein the first part firstly carries out dynamic time warping on the historical track and is divided into sub-track pairs. And the second part is to determine which road sections the sub-track pairs fall on respectively, the end points of the road sections respectively form SD (Source-Destination) point pair sets, and the point pair sets are grouped by using a clustering method after duplication removal. And the third part executes bidirectional search based on dynamic prestorage on each group of grouped point pair set, and utilizes the result to assist the dynamic shortest path query among the tracks to obtain a final result.
Description
One, the technical field
The invention belongs to the field of track query optimization, and is mainly used for reducing a large amount of repeated calculation during shortest path query among tracks and improving query efficiency.
Second, background Art
With the development of the internet of things, sensor equipment is optimized continuously, and the collection of vehicle track data is more and more convenient. The intelligent traffic as one of the important applications of the internet of things cannot inquire and analyze a large amount of track data. The dynamic change of the shortest path between the tracks is analyzed, and the distance peak is found out, so that the method has important significance on the bus route and even the route planning of unmanned automatic driving vehicles. The difficulty is that the time of a given query track may not be completely overlapped, a section of historical track may cross a plurality of road sections of a road network, and the speeds of the mobile objects on the road sections are different, which is not beneficial to the calculation of the dynamic shortest path; and because the urban road network is large in scale, the calculation cost of the shortest path between the tracks is extremely high, and a large amount of repeated calculation exists between the sub-track pairs, the query efficiency is greatly reduced.
Therefore, how to reduce the repeated calculation in the shortest path query among the tracks is an important problem to be solved. The traditional solution adopts the shortest path between the top points of the road network of the pre-stored part to accelerate the query, however, when the mobile object does not fall on the pre-stored path, the repeated calculation of the common path between the sub-track pairs can not be reduced, so the invention designs a bidirectional search algorithm based on dynamic pre-storage, and the algorithm reduces the calculation of the common path between a large number of sub-track pairs, optimizes the traditional method and accelerates the query.
Third, the invention
[ OBJECTS OF THE INVENTION ]
In order to reduce repeated calculation of a large number of common paths between sub-track pairs during dynamic shortest path query between tracks, query efficiency is improved.
[ technical solution ] A
The invention provides an optimization solution for the dynamic shortest path query among tracks, and the solution is designed for the problem that a large amount of repeated calculation exists in the shortest path query among pairs of sub-tracks after the dynamic time of the tracks is regular. The method mainly comprises the following steps:
firstly, dynamically time warping two tracks to be inquired, dividing the tracks into sub track pair sets corresponding to time units, then grouping point pair combinations possibly related to the sub tracks between end points of a road section (default duplication removal), wherein the grouping method adopts a clustering method, and bidirectional searching based on dynamic pre-storage is respectively carried out on each group of point pair inquiry sets after grouping to obtain the shortest path. After the result is obtained, the query result between the sub-track pairs only needs to be added with a small part of movement on the road section. And finally, collecting the query results among all the sub-track pairs to obtain the dynamic shortest path among the tracks to be queried.
[ PROBLEMS ] the present invention
The road network track bidirectional query algorithm based on dynamic prestoring optimizes the traditional solution based on prestoring, can reduce a large amount of repeated calculation during shortest path query among tracks, and obviously improves the query efficiency.
Description of the drawings
FIG. 1 dynamic time warping
FIG. 2 sub-track corresponds to SD point pair situation
FIG. 3 bidirectional search based on dynamic prestoring
Fifth, detailed description of the invention
The invention will be further explained with reference to the drawings.
The method is mainly divided into three parts, wherein the first part firstly carries out dynamic time warping on the historical track and is divided into sub-track pairs. And the second part is to determine which sections the sub-track pairs respectively fall on, and the end points of the sections respectively form an SD (Source-Destination) point pair set. And de-duplicating the point pair set, and then grouping by using a clustering method. And the third part executes bidirectional search based on dynamic prestorage on each group of grouped point pair set, and utilizes the result to assist the dynamic shortest path query among the tracks to obtain a final result.
(1) Dynamic time warping
Because the time of the sampling devices is not synchronous, the time inflection points between the track segments are different, which causes certain trouble to the dynamic shortest path query of the road network, because if two moving objects are not in the same time unit, the calculation of the shortest path between the two moving objects has no meaning, and unnecessary calculation is also generated. The line segment between the inflection points can be regarded as a linear equation with respect to time, and the determined position of each time can be determined by calculation, so that the two trajectories need to be divided again, so that the inflection points between the trajectories are the same, as shown in fig. 1, the inflection points of the two trajectories are not completely the same at first, and after dynamic time warping, the two trajectories can be converted into the trajectories with the same inflection points. After the operation, the calculation of the shortest path of the track can be more accurate and convenient. Therefore, the shortest path query between the two mobile objects can be converted into a set of the shortest path query results between a group of sub-track pairs. The divided sub-track pairs satisfy two conditions: (a) the two sub-tracks have the same time period; (b) each sub-track represents motion within a certain road segment.
(2) SD point pair grouping
By judging which road sections the sub-track pairs after the dynamic time warping fall on respectively, the dynamic shortest path query problem among the road network tracks can be converted into a set of static problems and dynamic calculation. The static part is a series of SD point pairs formed by the end points of the road sections where the sub-track pairs fall, the left side of FIG. 2 is an example of corresponding the regularized sub-tracks to the corresponding road sections, and the obtained SD point pairs are shown on the right side of FIG. 2. It can be seen from the above example that there may be duplication between SD point pairs corresponding to sub-track pairs, and all SD point pairs need to be removed from duplication to form a query set QTSD ═ PO(s)1,d1),PO(s2,d2),...,PO(sn,dn) N is the number of SD point pairs, PO(s)i,di) Represents a shortest path query between one SD point pair.
When the historical track of the moving object is long and spans a plurality of road segments, more than one common path may exist between query result sets of the query set QTSD, so that the query sets can be properly grouped by adopting a clustering method, and repeated calculation of the common path can be reduced as much as possible. Grouping is based on a Q-line clustering algorithm, and ensures that the point pair sets in the same group are relatively close to the starting point and the ending point.
(3) Bidirectional search based on dynamic prestoring
And after grouping, respectively executing shortest path query for the point pairs in each group. Using a two-way search method based on dynamic precomputation, first for the first pair of POs(s) in each group1,d1) And inquiring and storing a shortest path as a dynamically prestored content, and when the shortest path between the remaining point pairs in the group is inquired, adopting bidirectional search until the head and the tail of the shortest path are expanded to the shortest path between the first pair stored above, so that a long section of common path in the middle is not required to be repeatedly calculated.
To facilitate understanding, a simple example is given, as shown in fig. 3. Assume that the set has only two pairs of query POs(s)1,d1),PO(s2,d2) First, s is calculated1To d1A shortest Path ofpreThen calculates s based on the path2To d2Wherein the dotted line portion corresponds to the Path described in the algorithmmid,s2Is connected to PathpreThe previous shortest Path corresponds to Paths,d2Is connected to PathpreThe previous shortest Path corresponds to PathdFinal PO(s)2,d2) The query result of (1) is Paths+Pathmid+Pathmid. May also exist s2And d2Cannot connect to the pre-computed PathpreIn the above case, the returned result is shown by the red line in the figure.
And finally, combining the results to assist in the dynamic shortest path query among the tracks to obtain a final result.
Claims (4)
1. A road network track bidirectional query method based on dynamic prestoring is generally characterized in that a large amount of repeated calculation exists in track dynamic shortest path query, in order to reduce repeated calculation of common paths and improve query efficiency, the invention optimizes a traditional solution based on prestoring according to dynamic time warping, point-to-cluster grouping and bidirectional search based on dynamic prestoring, and the process comprises the following three parts:
(1) dynamic time warping: performing dynamic time warping on two tracks to be queried, and dividing the two tracks into sub-track pair sets corresponding to time units;
(2) sub-track pairs are grouped: and (3) determining which road sections the sub-track pairs obtained in the step (1) respectively fall on, wherein the end points of the road sections respectively form an SD (Source-Destination) point pair set. De-duplicating the point pair sets and then grouping by using a clustering method;
(3) bidirectional search based on dynamic pre-storage: and performing bidirectional search based on dynamic pre-storage on each group of point pair set after grouping, and utilizing bidirectional search results to assist in dynamic shortest path query among tracks to obtain a final result.
2. The road network track bidirectional query method based on dynamic pre-storage as claimed in claim 1, wherein in step (1), a general dynamic time warping method is improved to ensure that the divided sub-track pairs can satisfy two conditions: the two sub-tracks have the same time period; each sub-track represents motion within a certain road segment.
3. The method according to claim 1, wherein in step (2), dynamic shortest path query among the tracks is converted into a combination of static problem and dynamic calculation, the static part is shortest path calculation among the end point pairs of the road segments, and a clustering grouping method is used to ensure that the point pair sets in the same group are relatively close to the start point and the end point after grouping.
4. The method according to claim 1, wherein in step (3), when performing bidirectional search based on dynamic pre-storage on each group of point pair sets after grouping, the shortest path between a pair of SD points is pre-calculated and recorded, the shortest path between the remaining point pairs is calculated and can be searched in bidirectional mode, when both ends of the search can be connected to the calculated shortest path, the search is stopped, and the bidirectional search result is used to assist the query of the dynamic shortest path between the tracks.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202010379782.XA CN111597210A (en) | 2020-05-07 | 2020-05-07 | Road network track bidirectional query method based on dynamic pre-storage |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202010379782.XA CN111597210A (en) | 2020-05-07 | 2020-05-07 | Road network track bidirectional query method based on dynamic pre-storage |
Publications (1)
Publication Number | Publication Date |
---|---|
CN111597210A true CN111597210A (en) | 2020-08-28 |
Family
ID=72182445
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202010379782.XA Pending CN111597210A (en) | 2020-05-07 | 2020-05-07 | Road network track bidirectional query method based on dynamic pre-storage |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN111597210A (en) |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102054355A (en) * | 2011-01-07 | 2011-05-11 | 同济大学 | Virtual vehicle routing method applicable to large-scale traffic flow simulation |
US20140164389A1 (en) * | 2012-12-07 | 2014-06-12 | International Business Machines Corporation | Mining trajectory for spatial temporal analytics |
CN110220528A (en) * | 2019-06-10 | 2019-09-10 | 福州大学 | A kind of two-way dynamic path planning method of automatic Pilot unmanned vehicle based on A star algorithm |
CN110443311A (en) * | 2019-08-07 | 2019-11-12 | 长安大学 | A kind of traffic trajectory clustering similarity calculation method based on shape factor adjustment |
-
2020
- 2020-05-07 CN CN202010379782.XA patent/CN111597210A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102054355A (en) * | 2011-01-07 | 2011-05-11 | 同济大学 | Virtual vehicle routing method applicable to large-scale traffic flow simulation |
US20140164389A1 (en) * | 2012-12-07 | 2014-06-12 | International Business Machines Corporation | Mining trajectory for spatial temporal analytics |
CN110220528A (en) * | 2019-06-10 | 2019-09-10 | 福州大学 | A kind of two-way dynamic path planning method of automatic Pilot unmanned vehicle based on A star algorithm |
CN110443311A (en) * | 2019-08-07 | 2019-11-12 | 长安大学 | A kind of traffic trajectory clustering similarity calculation method based on shape factor adjustment |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN101694749B (en) | Method and device for speculating routes | |
Song et al. | PRESS: A novel framework of trajectory compression in road networks | |
CN104952248B (en) | A kind of vehicle convergence Forecasting Methodology based on Euclidean space | |
CN101750089B (en) | Road network connectivity detection method and device based on mass e-maps | |
CN105069415A (en) | Lane line detection method and device | |
CN113415317B (en) | Control method of virtual linked high-speed train group | |
CN105643157A (en) | Automatic girder welding obstacle predicting method for optimizing GRNN based on correction type fruit fly algorithm | |
CN106530779B (en) | Path planning method and system based on urban traffic control signal lamp | |
CN112461299B (en) | Turnout section track feature identification method and device | |
CN108132056B (en) | Method for deducing bus route through GPS | |
CN107423761B (en) | Rail locomotive energy-saving optimization operation method based on feature selection and machine learning | |
CN105825671A (en) | Method and system for analyzing accompanying vehicles based on big data vehicle full track collision | |
CN111469888A (en) | Method and system for planning ATO (automatic train operation) rapid target curve | |
CN114155319A (en) | Method, system and device for generating auxiliary lane change information by high-precision map | |
CN105806355B (en) | A kind of vehicle green path navigation system and method | |
CN102194312B (en) | Road merging method and road merging device | |
CN111597210A (en) | Road network track bidirectional query method based on dynamic pre-storage | |
CN101457253A (en) | Sequencing sequence error correction method, system and device | |
CN102111372A (en) | Pulse counteraction mode-based peak clipping method | |
CN111076736B (en) | Vehicle-mounted system based on FPGA design and A star path searching method | |
CN112464517A (en) | Method for searching shortest path by simulation vehicle based on existing road data | |
CN117740011A (en) | Method and device for automatic driving | |
CN110459067B (en) | Traffic green road signal coordination control evaluation method and system based on vehicle individuals | |
CN114428807B (en) | Method for constructing semantic system and cognition optimization of ground maneuvering target motion trail | |
CN113465612B (en) | Parallel path planning method and system based on double-layer index |
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 | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20200828 |
|
WD01 | Invention patent application deemed withdrawn after publication |