CN111159189A - Vehicle driving track query method, device, equipment and storage medium - Google Patents

Vehicle driving track query method, device, equipment and storage medium Download PDF

Info

Publication number
CN111159189A
CN111159189A CN201911383521.9A CN201911383521A CN111159189A CN 111159189 A CN111159189 A CN 111159189A CN 201911383521 A CN201911383521 A CN 201911383521A CN 111159189 A CN111159189 A CN 111159189A
Authority
CN
China
Prior art keywords
time
partition
query
vehicle
track
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.)
Withdrawn
Application number
CN201911383521.9A
Other languages
Chinese (zh)
Inventor
王子榕
黄长禄
李斌
徐鹏
严宏伟
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Nanjing Leading Technology Co Ltd
Original Assignee
Nanjing Leading Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Nanjing Leading Technology Co Ltd filed Critical Nanjing Leading Technology Co Ltd
Priority to CN201911383521.9A priority Critical patent/CN111159189A/en
Publication of CN111159189A publication Critical patent/CN111159189A/en
Withdrawn legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • G06F16/278Data partitioning, e.g. horizontal or vertical partitioning

Abstract

The embodiment of the invention discloses a vehicle running track query method, a device, equipment and a storage medium, wherein the vehicle running track query method comprises the following steps: acquiring a track query request, wherein the track query request comprises a vehicle identifier and a query time interval; determining at least one time partition corresponding to the query time interval, wherein each time partition corresponds to an independent storage area; according to the vehicle identification, determining required track data in the driving track data corresponding to the at least one time partition; the driving track data of the vehicle is stored in a partition mode in advance according to the corresponding relation between the track generation time and the time partition mode. The embodiment of the invention is based on the time-slicing storage of the vehicle driving track, reduces the range of inquiring the required track data, shortens the inquiry response time and improves the inquiry efficiency of the vehicle driving track.

Description

Vehicle driving track query method, device, equipment and storage medium
Technical Field
The embodiment of the invention relates to the technical field of big data management, in particular to a vehicle driving track query method, a device, equipment and a storage medium.
Background
With the development of the internet and intelligent terminal technology, the birth of various applications brings great convenience to the life of people. In the field of network car reservation, a terminal used by a passenger and a terminal used by a driver need to inquire the driving track of a vehicle, and the driving track inquiry of the vehicle can be covered in each journey, so that the driving track of the vehicle needs to be stored along with the increase of the number of orders of the network car reservation, so as to inquire the vehicle track of each order journey subsequently.
Because the storage of the current vehicle running track is to store each track into the data table according to the vehicle travel, when the track query requirement exists, the data table needs to be scanned in a full table mode, and therefore the track data matched with the query requirement is obtained. When the query concurrency is increased, the query mode has the problems of long query response time and low query efficiency.
Disclosure of Invention
The embodiment of the invention provides a vehicle running track query method, a vehicle running track query device, vehicle running track query equipment and a storage medium, so that the vehicle running track query efficiency is improved, the query response time is shortened, and the query performance is improved.
In a first aspect, an embodiment of the present invention provides a vehicle driving track query method, including:
acquiring a track query request, wherein the track query request comprises a vehicle identifier and a query time interval;
determining at least one time partition corresponding to the query time interval, wherein each time partition corresponds to an independent storage area;
according to the vehicle identification, determining required track data in the driving track data corresponding to the at least one time partition;
the driving track data of the vehicle is stored in a partition mode in advance according to the corresponding relation between the track generation time and the time partition mode.
In a second aspect, an embodiment of the present invention further provides a vehicle travel track query device, including:
the track query request acquisition module is used for acquiring a track query request, wherein the track query request comprises a vehicle identifier and a query time interval;
the time partition determining module is used for determining at least one time partition corresponding to the query time interval, wherein each time partition corresponds to an independent storage area;
the track data determining module is used for determining required track data in the driving track data corresponding to the at least one time partition according to the vehicle identification;
the driving track data of the vehicle is stored in a partition mode in advance according to the corresponding relation between the track generation time and the time partition mode.
In a third aspect, an embodiment of the present invention further provides a computer device, including:
one or more processors;
a storage device for storing one or more programs,
when the one or more programs are executed by the one or more processors, the one or more processors implement the vehicle travel track query method according to any embodiment of the invention.
In a fourth aspect, the embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the vehicle driving track query method according to any embodiment of the present invention.
According to the embodiment of the invention, the time partition corresponding to the query time interval is determined from the database based on the query time interval in the query request, and then the required track data is determined from the independent storage area corresponding to the time partition by combining the vehicle identifier.
Drawings
Fig. 1 is a flowchart of a vehicle driving track query method according to a first embodiment of the present invention;
FIG. 2 is a flowchart of a vehicle driving track query method according to a second embodiment of the present invention;
fig. 3 is a schematic structural diagram of a vehicle travel track query device in a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of a computer device in the fourth embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
Fig. 1 is a flowchart of a vehicle travel track query method in a first embodiment of the present invention, and this embodiment is applicable to a case where a vehicle travel track within a query time interval is efficiently extracted in the face of a large increase in travel track data. The method can be executed by a vehicle driving track query device, which can be implemented in a software and/or hardware manner and can be configured in a computer device, for example, the computer device can be a device with communication and computing capabilities, such as a background server. As shown in fig. 1, the method specifically includes:
step 101, obtaining a track query request, wherein the track query request comprises a vehicle identifier and a query time interval.
The track query request refers to a request submitted by a user to query the driving track of the vehicle in a historical time. For example, the user may send a track query request to the server through an online car appointment application installed in the terminal, and the user in this embodiment may refer to a user with a car taking demand, or may refer to a car owner. The vehicle identification in the track inquiry request is used for uniquely representing the vehicle to be inquired. The vehicle identifier includes a Vehicle Identification Number (VIN), a license plate Number, or an owner identification, and the owner identification may be a registered account Number or an owner identification Number when the owner uses the online contract application. When the vehicle identification is the vehicle owner identification, the vehicle owner information and the vehicle to be inquired are required to have one-to-one binding relationship, so that the unique identification of the vehicle owner identification to the vehicle is realized.
And 102, determining at least one time partition corresponding to the query time interval, wherein each time partition corresponds to an independent storage area.
In this embodiment, the time partition refers to a time period obtained by dividing a period of time according to a time span, and a value of the time span may be adaptively set, for example, may be set to 5 minutes. Each time partition corresponds to an independent storage area, which means that the storage areas corresponding to the time partitions are not interfered with each other and are respectively used for storing the vehicle path data matched with the time of the time partition, for example, the storage area corresponding to each time partition may be a storage sub-area in a database. The server can monitor the running track of each vehicle or position and monitor each vehicle according to the vehicle identification, periodically or real-timely acquire the running track data of each vehicle, and then store the running track data of each vehicle in a partition manner by newly creating a plurality of time partitions or matching the time partitions with the established time partitions according to the generation time of the running track, wherein the generation time refers to the timestamp corresponding to each coordinate point in the track, that is, before the inquiry of a user, the running track data of the vehicle is stored in a partition manner according to the corresponding relationship between the track generation time and the time partitions in advance. Taking the time span of 5 minutes as an example, the storage area corresponding to each time partition may be used to store the trajectory data of any vehicle with the time length of 5 minutes, and the trajectory data of any vehicle in a certain time period may be continuously stored in the storage areas corresponding to a plurality of time partitions.
Specifically, all the time partitions covered by the range of the query time interval may be determined according to the time start point and the time span of the time partition, and the trajectory data in the storage area corresponding to all the time partitions may be determined. The coverage time is determined by the inquiry time interval, so that the inquiry range is reduced, the database for storing the whole track data does not need to be scanned in a full disc, and the inquiry efficiency of the vehicle running track can be improved.
Illustratively, determining at least one time partition corresponding to the query time interval includes: and comparing the time starting point and the time ending point of the query time interval with the time starting point of each time partition to determine at least one time partition corresponding to the query time interval.
The time starting point refers to the starting time of a time interval to be queried, and the time ending point refers to the corresponding ending time. The time starting point of each time partition refers to the earliest generation time of the traffic track data in the storage area corresponding to the time partition. Illustratively, if the time starting point of a time partition is 09/29/12/15/0 second in 2019, the storage area corresponding to the time partition can be used for storing the traffic track data generated from 12/15/0 second in 09/29/2019, if the span of the time partition is five minutes, the time partition corresponds to storing the traffic track data generated from 12/15/0 second in 09/29/2019 to 20/0 second in 12/20/0 second in 09/29/2019, and the time starting point of the next time partition is 21/0 second in 12/29/2019.
Specifically, the starting time and the ending time of an inquiry time interval in the track inquiry request are determined, a time partition corresponding to the starting time is determined, after the starting time partition is determined, a time partition corresponding to the ending time is determined according to the span of the time partition and the ending time of the inquiry time interval, the starting time partition, the ending time partition and all the time partitions therebetween are time partitions corresponding to the inquiry time interval, and vehicle driving track data in the inquiry time interval are stored in a storage area corresponding to the determined time partition. For example, in the above example, if the required query time interval is from about 17 minutes 0 seconds at 12 hours of 09 months 29/2019 to about 22 minutes 0 seconds at 12 hours of 09 months 29/2019, the time starting point, 2019, 09 months 29/12 hours 17 minutes 0 seconds falls in the time partition with 12 hours 15 minutes 0 seconds at 12 hours of 09 months 29/2019 as the time starting point, the time ending point, 2019, 09 months 29/12 hours 22 minutes 0 seconds falls in the time partition with 21 minutes 0 seconds at 12 hours of 09 months 29/2019 as the time starting point, and no other time partition exists in the two time partitions, the two time partitions are the time partitions corresponding to the query time interval. Optionally, the time partition corresponding to the query time interval may also be determined according to the determined start time partition and the time span value.
The time partition of coverage is determined according to the time starting point and the time ending point of the query time interval, namely the time partition of coverage of the query is calculated in advance according to the partition rule of the time partition during the query, the range of accurate query is narrowed from a database storing integral track data, the time of the query is shortened, and the query efficiency is improved.
Step 103, determining required track data in the driving track data corresponding to the at least one time partition according to the vehicle identification.
The driving track data of the vehicle is stored in a partition manner in advance according to the corresponding relation between the track generation time and the time partition, namely when the driving track data of the vehicle is stored in the storage area corresponding to the time partition, the driving track data of the vehicle is stored according to the time starting point and the time span of the time partition. The vehicle identifier is information for identifying an object to which the vehicle travel track data stored in the time zone belongs, and for example, the vehicle identifier may be a vehicle frame number, that is, in each piece of travel track data stored in the storage area corresponding to the time zone, in addition to the time stamp and the position data accurate to the second, the vehicle identifier of the vehicle to which the track data belongs may be included, so that the object of the track information is determined according to the vehicle identifier. The required track data refers to track data meeting the query requirements of the user.
For example, the driving track data of each vehicle in at least one time partition can be preliminarily determined according to at least one time partition corresponding to the query time interval, then the driving track data is screened according to the vehicle identifier in the track query request, and the track data of irrelevant vehicles is filtered out, so that the required track data is obtained, and the query accuracy is improved. After determining the trajectory data meeting the user query requirements, the server can issue the trajectory data to the user terminal, so that the user terminal displays the trajectory based on map application.
Further, according to the vehicle identifier, determining required trajectory data in the driving trajectory data corresponding to the at least one time partition includes:
screening the driving track data corresponding to the at least one time partition according to the vehicle identification, the time starting point and the time ending point of the query time interval to obtain the required track data; in the running track data stored in a partition manner in advance, coordinates correspond to time one by one.
Specifically, the determined time partitions are divided according to the specific time starting point and the specific time ending point of the query time interval, and the travel track data in the storage areas corresponding to the time partitions are screened, because the storage areas corresponding to the time partitions may include travel track data in other time ranges besides the travel track data in the query time interval, that is, the starting point of the query time interval of the user and the time starting point of any time partition are not strictly corresponding, for example, on the basis of the above example, the query time interval is two partitions of 09 month 29 12 hours 17 minutes 0 seconds in 2019 to 09 month 29 days 12 hours 22 minutes 0 seconds in 2019, the determined time partitions are two partitions of 09 month 29 days 12 hours 15 minutes 0 seconds in 2019 and 09 month 29 days 12 hours 21 minutes 0 seconds in 2019, the determined time partitions are 15 minutes 0 seconds to 17 minutes 0 seconds stored in the storage areas corresponding to the two time partitions, and the travel track data from 22 min 0 s to 26 min 0 s are not in the range of the query time interval, and the travel track data of irrelevant time needs to be screened. The time precision of the time partition and the query time interval may be adaptively set, and this embodiment is not particularly limited.
According to the specific time starting point and time ending point of the query time interval, for example, time information accurate to seconds, irrelevant driving track data are filtered according to the acquisition time of each piece of data in a storage area corresponding to the determined time partition, the driving track data of irrelevant vehicles are filtered in the filtered driving track data according to the vehicle identification of each piece of data, and then the driving track data after filtering are used as required track data according to the vehicle identification, the time starting point and the time ending point of the query time interval. For example, the travel track data of the irrelevant vehicle may be filtered according to the vehicle identifier, and then the travel track data of the irrelevant time may be filtered according to the specific time starting point and the time ending point.
According to the embodiment of the invention, the time partition corresponding to the query time interval is determined from the database based on the query time interval in the query request, and then the required track data is determined from the independent storage area corresponding to the time partition by combining the vehicle identifier.
Example two
Fig. 2 is a flowchart of a vehicle travel track query method in the second embodiment of the present invention, and in the second embodiment, further optimization is performed on the basis of the first embodiment, so that a process of storing acquired travel track data according to a time slicing rule is determined, and subsequent accurate positioning of time slices is facilitated. As shown in fig. 2, the method includes:
step 201, in the running process of the vehicle, obtaining the running track data of the vehicle in a set time interval according to the vehicle identification.
Optionally, when the set time interval is three seconds, the position information of the vehicle is acquired every three seconds, and when the set time interval is five minutes, the vehicle travel track data within the time range of 5 minutes is acquired every 5 minutes.
Specifically, in the vehicle driving process, the driving track data including the vehicle identification information is acquired every set time interval, for example, the driving track data of the vehicle is acquired every three seconds, and the data at least includes the vehicle identification information, the accurate time of data acquisition, and the position data. Or acquiring the vehicle running track data in the time interval once every five minutes, wherein the data can be the data acquired by the positioning acquisition device in the time interval, stored in the local device, and the vehicle running track data stored in the set time interval is acquired at the set time node. The specific time length of the set time interval can be adaptively set, for example, the server can periodically or real-timely acquire the vehicle driving track data according to the flexible setting of the set time interval.
Step 202, determining whether a time partition corresponding to the set time interval exists according to the matching between the set time interval and the time partition index in the database.
Optionally, the time partition index of each time partition may include the time start of the time partition and a vehicle identifier, that is, the data stored in the storage area corresponding to the time partition index is the vehicle having the vehicle identifier, and the travel track data in the time range. Different time zone indexes are created for different vehicles, so that zone storage of the travel track data of each vehicle is realized.
For example, when the storage database is HBase, the time partition index refers to a rowkey representation, the rowkey is a time starting point, and the vehicle identification code is spliced after being inverted according to a character string format, for example, the time is 09, 29, 12 in 2019, 15 in 12, and the vehicle identification code is zx12345, then the rowkey is: 512192909102zx12345, the storage area corresponding to the rowkey is vehicle travel track data acquired within a period of time, and the time span of the data stored in the time partition may be set according to actual requirements, for example, the time span of the time partition is 5 minutes, which is equivalent to that a set of vehicle travel track data corresponding to the vehicle identifier within five minutes is stored in the storage area corresponding to each rowkey.
The acquired vehicle running track data is conveniently stored in a partitioned mode according to the time partition index, and the time partition corresponding to the track query request is conveniently determined subsequently, so that the vehicle running track query efficiency is improved by establishing the time partition index.
Specifically, according to a set time interval value of the acquired vehicle travel track data, a time value comparison is performed with a time starting point included in the time partition index, and whether a time partition corresponding to the set time interval exists is determined.
For example, when a set time zone is 3 seconds, if the server acquires travel track data generated by a certain vehicle within a range from 17 minutes 30 seconds at 12 hours at 09/29/2019 to 17 minutes 33 seconds at 12 hours at 09/29/2019, the set time zone falls within a time zone having a time start point of 2019, 09/29/12 hours 15 minutes at 2019 and a time interval of 5 minutes, the time zone is a time zone corresponding to the set time zone; if the time interval is set to 5 minutes, the server acquires the travel locus data of a vehicle from 17 minutes and 30 seconds at 12 hours at 09 months 29 and 12 hours at 17 minutes and 30 seconds at 12 hours at 09 months 29 and 29 days 12 hours at 2019 and 22 minutes and 30 seconds at 12 hours at 09 months 29 and 29 days at 2019, the travel locus data of 17 minutes and 30 seconds at 12 hours at 17 minutes and 30 seconds at 12 hours at 29 days 12 at 09 months 29 and 12 hours at 2019 and 59 seconds at 2019 and 5 minutes at the time starting point is in the time zone of 12 minutes at 09 months 29 and 9 days at 09 months 12 hours at 2019 and 30 seconds at 21 minutes and 0 seconds at 21 minutes and 5 minutes at the time starting point at 09 months 29 and 12 hours at 09 months 29 and 2019 and 30 seconds at the time interval of 5 minutes.
By storing the vehicle driving track data in a partition or a fragment mode according to the time partition and establishing an index for each time partition, the scattered data is aggregated, the problem that the driving track data is directly stored in a database after being acquired and an index value needs to be established for each data is solved, the number of the index values of the data storage in the database is reduced through the time partition, the index quantity of the subsequent data query which needs to be scanned is reduced, and the data query efficiency is improved.
And 203, if the data exist, storing the acquired driving track data according to the corresponding time partition.
Specifically, according to the matching between the set time interval and the time partition index, if the corresponding time partition is determined to exist, the matched vehicle driving track data is stored into the storage area corresponding to the time partition, and the storing of the data further comprises acquiring a specific time stamp and accurate position data.
Optionally, the time partition establishing method includes dividing in advance according to a time interval or dynamically establishing according to the data acquisition time. For example, the storage space in the database is divided into a plurality of storage sub-areas corresponding to time partitions in advance, the index corresponding to each time partition is sequentially set according to a time starting point and a time interval, after the vehicle driving track data is acquired, the time partition corresponding to the vehicle driving track data is determined, and the data is stored in the storage area corresponding to the time partition. The indexes of the time partitions are divided according to the time intervals, so that query and matching are facilitated, and the efficiency of data matching is improved by pre-dividing the time partitions.
When the time partition is dynamically established according to the acquired data time, determining whether the corresponding time partition is established according to the earliest time of track generation in the acquired vehicle running track data, and if so, matching the corresponding time partition; if the time partition is not established, the time partition is newly established based on the existing time partition and the track generation time in the track data.
On the basis of the above technical solutions, optionally, the method further includes:
if the time partition corresponding to the set time interval does not exist, establishing at least one time partition based on the time starting point of the set time interval and the preset time span;
and storing the acquired travel track data in a partition mode according to the corresponding relation between the set time interval and the newly-built time partition.
Specifically, if no matching result is found according to the matching between the set time interval and the time partition index in the database, and the time partition does not exist, taking the minimum value of the timestamp in the data without the matching result as the time starting point value of the newly-built time partition, and newly building at least one time partition according to the preset time span.
Illustratively, the time for acquiring the travel track data is 26 minutes and 30 seconds at 09/29/12 in 2019, according to the above example, the latest time partition is 21 minutes and 0 seconds at 21 times and 0 seconds at 29/12 in 09/29 in 2019, and the time interval is 5 minutes, according to the matching result, the data has no corresponding time partition, according to the acquired time as the time starting point, a new time partition is newly created, the time starting point is 26 minutes and 30 seconds at 12 times and 26 minutes at 29/12 in 09/29 in 2019, and the time interval is 5 minutes, and the travel track data is stored in the storage area corresponding to the new time partition. It should be noted that the time precision of the time starting point of the newly created time partition may or may not be the same as the time precision of the starting point of the set time interval, and this embodiment is not particularly limited to this, and for example, the time precision of the time starting point of the newly created time partition may be approximately minutes, that is, the newly created time partition may also use 26 minutes and 0 seconds as the time starting point at time 12 of 09/29/2019.
If the matched corresponding time partition does not exist, the new time partition is established according to the acquired data time value, and the independent storage sub-areas corresponding to the time partition are divided, so that the phenomenon that the time partition is established in advance and the vehicle running track is not acquired in the period of time is avoided, and the use efficiency of the memory of the database is improved.
Step 204, obtaining a track query request, wherein the track query request comprises a vehicle identifier and a query time interval.
Step 205, determining at least one time partition corresponding to the query time interval, where each time partition corresponds to an independent storage area.
Specifically, the corresponding time partition is determined according to the matching relationship between the query time interval and the index of the time partition.
Step 206, according to the vehicle identification, determining required track data in the driving track data corresponding to the at least one time zone.
The driving track data of the vehicle is stored in a partition mode in advance according to the corresponding relation between the track generation time and the time partition mode.
Specifically, the required trajectory data is determined according to the matching relationship between the vehicle identifier and the vehicle identifier information included in the index of the time zone. Optionally, the data is filtered according to whether the time of each piece of data in the storage area corresponding to the determined time partition is in the query time interval, so as to determine the required trajectory data.
According to the embodiment of the invention, the acquired travel track data is stored in a partitioned manner according to the track generation time, so that a plurality of pieces of data in a period of time can be converted into one data block, and the high efficiency of subsequent query is improved; and the historical storage data is inquired subsequently, and the corresponding time partition is determined only according to the inquiry time, so that the corresponding storage sub-area is determined, the scanning inquiry range is reduced, and the inquiry efficiency is improved.
EXAMPLE III
Fig. 3 is a schematic structural diagram of a vehicle travel track query device in a third embodiment of the present invention, which is applicable to a case where a vehicle travel track in a query time interval is efficiently extracted in a case where travel track data is greatly increased. As shown in fig. 3, the apparatus includes:
a track query request obtaining module 310, configured to obtain a track query request, where the track query request includes a vehicle identifier and a query time interval;
a time partition determining module 320, configured to determine at least one time partition corresponding to the query time interval, where each time partition corresponds to an independent storage area;
a trajectory data determining module 330, configured to determine required trajectory data from the driving trajectory data corresponding to the at least one time partition according to the vehicle identifier;
the driving track data of the vehicle is stored in a partition mode in advance according to the corresponding relation between the track generation time and the time partition mode.
According to the embodiment of the invention, the time partition corresponding to the query time interval is determined from the database based on the vehicle identification and the query time interval in the query request, and the required track data is determined from the independent storage area corresponding to the time partition. The time partition predetermination reduces the range of inquiring the required track data, shortens the inquiry response time, screens the track data according to the inquiry time interval, and determines the required track data by combining the vehicle identification, thereby improving the inquiry efficiency of the vehicle driving track and the inquiry performance.
Optionally, the trajectory data determining module 330 is specifically configured to:
screening the driving track data corresponding to the at least one time partition according to the vehicle identification, the time starting point and the time ending point of the query time interval to obtain the required track data;
in the running track data stored in a partition manner in advance, coordinates correspond to time one by one.
Optionally, the time partition determining module 320 is specifically configured to:
and comparing the time starting point and the time ending point of the query time interval with the time starting point of each time partition to determine at least one time partition corresponding to the query time interval.
Optionally, the apparatus further comprises:
the driving track data acquisition module is used for acquiring driving track data of the vehicle in a set time interval according to the vehicle identification in the driving process of the vehicle;
the time partition determining module is used for determining whether a time partition corresponding to the set time interval exists or not according to the matching between the set time interval and the time partition index in the database;
and the running track data storage module is used for storing the acquired running track data according to the corresponding time partition if the running track data exists.
Optionally, the apparatus further includes a time partition newly-creating module, specifically configured to:
if the time partition corresponding to the set time interval does not exist, establishing at least one time partition based on the time starting point of the set time interval and the preset time span;
and storing the acquired travel track data in a partition mode according to the corresponding relation between the set time interval and the newly-built time partition.
The vehicle running track query device provided by the embodiment of the invention can execute the vehicle running track query method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of executing the vehicle running track query method.
Example four
Fig. 4 is a schematic structural diagram of a computer device according to a fourth embodiment of the present invention. FIG. 4 illustrates a block diagram of an exemplary computer device 12 suitable for use in implementing embodiments of the present invention. The computer device 12 shown in FIG. 4 is only one example and should not bring any limitations to the functionality or scope of use of embodiments of the present invention.
As shown in FIG. 4, computer device 12 is in the form of a general purpose computing device. The components of computer device 12 may include, but are not limited to: one or more processors or processing units 16, a system memory device 28, and a bus 18 that couples various system components including the system memory device 28 and the processing unit 16.
Bus 18 represents one or more of any of several types of bus structures, including a memory device bus or memory device controller, a peripheral bus, an accelerated graphics port, and a processor or local bus using any of a variety of bus architectures. By way of example, such architectures include, but are not limited to, Industry Standard Architecture (ISA) bus, micro-channel architecture (MAC) bus, enhanced ISA bus, Video Electronics Standards Association (VESA) local bus, and Peripheral Component Interconnect (PCI) bus.
Computer device 12 typically includes a variety of computer system readable media. Such media may be any available media that is accessible by computer device 12 and includes both volatile and nonvolatile media, removable and non-removable media.
The system storage 28 may include computer system readable media in the form of volatile storage, such as Random Access Memory (RAM)30 and/or cache storage 32. Computer device 12 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, storage system 34 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 4, and commonly referred to as a "hard drive"). Although not shown in FIG. 4, a magnetic disk drive for reading from and writing to a removable, nonvolatile magnetic disk (e.g., a "floppy disk") and an optical disk drive for reading from or writing to a removable, nonvolatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to bus 18 by one or more data media interfaces. Storage 28 may include at least one program product having a set (e.g., at least one) of program modules that are configured to carry out the functions of embodiments of the invention.
A program/utility 40 having a set (at least one) of program modules 42 may be stored, for example, in storage 28, such program modules 42 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which examples or some combination thereof may comprise an implementation of a network environment. Program modules 42 generally carry out the functions and/or methodologies of the described embodiments of the invention.
Computer device 12 may also communicate with one or more external devices 14 (e.g., keyboard, pointing device, display 24, etc.), with one or more devices that enable a user to interact with computer device 12, and/or with any devices (e.g., network card, modem, etc.) that enable computer device 12 to communicate with one or more other computing devices. Such communication may be through an input/output (I/O) interface 22. Also, computer device 12 may communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network such as the Internet) via network adapter 20. As shown, network adapter 20 communicates with the other modules of computer device 12 via bus 18. It should be understood that although not shown in the figures, other hardware and/or software modules may be used in conjunction with computer device 12, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems, among others.
The processing unit 16 executes various functional applications and data processing by running a program stored in the system storage device 28, for example, to implement a vehicle travel track query method provided by an embodiment of the present invention, including:
acquiring a track query request, wherein the track query request comprises a vehicle identifier and a query time interval;
determining at least one time partition corresponding to the query time interval, wherein each time partition corresponds to an independent storage area;
according to the vehicle identification, determining required track data in the driving track data corresponding to the at least one time partition;
the driving track data of the vehicle is stored in a partition mode in advance according to the corresponding relation between the track generation time and the time partition mode.
EXAMPLE five
The fifth embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the vehicle driving track query method provided in the embodiment of the present invention, and the method includes:
acquiring a track query request, wherein the track query request comprises a vehicle identifier and a query time interval;
determining at least one time partition corresponding to the query time interval, wherein each time partition corresponds to an independent storage area;
according to the vehicle identification, determining required track data in the driving track data corresponding to the at least one time partition;
the driving track data of the vehicle is stored in a partition mode in advance according to the corresponding relation between the track generation time and the time partition mode.
Computer storage media for embodiments of the invention may employ any combination of one or more computer-readable media. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.
Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Computer program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.

Claims (10)

1. A vehicle driving track query method is characterized by comprising the following steps:
acquiring a track query request, wherein the track query request comprises a vehicle identifier and a query time interval;
determining at least one time partition corresponding to the query time interval, wherein each time partition corresponds to an independent storage area;
according to the vehicle identification, determining required track data in the driving track data corresponding to the at least one time partition;
the driving track data of the vehicle is stored in a partition mode in advance according to the corresponding relation between the track generation time and the time partition mode.
2. The method of claim 1, wherein determining required trajectory data from the travel trajectory data corresponding to the at least one time partition based on the vehicle identification comprises:
screening the driving track data corresponding to the at least one time partition according to the vehicle identification, the time starting point and the time ending point of the query time interval to obtain the required track data;
in the running track data stored in a partition manner in advance, coordinates correspond to time one by one.
3. The method of claim 1, wherein prior to obtaining the trace-query request, the method further comprises:
in the running process of the vehicle, obtaining running track data of the vehicle in a set time interval according to the vehicle identification;
determining whether a time partition corresponding to the set time interval exists according to the matching between the set time interval and a time partition index in a database;
and if so, storing the acquired travel track data according to the corresponding time partition.
4. The method of claim 3, further comprising:
if the time partition corresponding to the set time interval does not exist, establishing at least one time partition based on the time starting point of the set time interval and the preset time span;
and storing the acquired travel track data in a partition mode according to the corresponding relation between the set time interval and the newly-built time partition.
5. The method of claim 1, wherein determining at least one time partition corresponding to the query time interval comprises:
and comparing the time starting point and the time ending point of the query time interval with the time starting point of each time partition to determine at least one time partition corresponding to the query time interval.
6. A vehicle travel track inquiry apparatus, characterized by comprising:
the track query request acquisition module is used for acquiring a track query request, wherein the track query request comprises a vehicle identifier and a query time interval;
the time partition determining module is used for determining at least one time partition corresponding to the query time interval, wherein each time partition corresponds to an independent storage area;
the track data determining module is used for determining required track data in the driving track data corresponding to the at least one time partition according to the vehicle identification;
the driving track data of the vehicle is stored in a partition mode in advance according to the corresponding relation between the track generation time and the time partition mode.
7. The apparatus of claim 6, wherein the trajectory data determination module is specifically configured to:
screening the driving track data corresponding to the at least one time partition according to the vehicle identification, the time starting point and the time ending point of the query time interval to obtain the required track data;
in the running track data stored in a partition manner in advance, coordinates correspond to time one by one.
8. The apparatus of claim 6, wherein the time partition determination module is specifically configured to:
and comparing the time starting point and the time ending point of the query time interval with the time starting point of each time partition to determine at least one time partition corresponding to the query time interval.
9. A computer device, comprising:
one or more processors;
a storage device for storing one or more programs,
when executed by the one or more processors, cause the one or more processors to implement the vehicle travel track query method of any one of claims 1-5.
10. A computer-readable storage medium on which a computer program is stored, the program, when being executed by a processor, implementing the vehicle travel track query method according to any one of claims 1 to 5.
CN201911383521.9A 2019-12-28 2019-12-28 Vehicle driving track query method, device, equipment and storage medium Withdrawn CN111159189A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911383521.9A CN111159189A (en) 2019-12-28 2019-12-28 Vehicle driving track query method, device, equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911383521.9A CN111159189A (en) 2019-12-28 2019-12-28 Vehicle driving track query method, device, equipment and storage medium

Publications (1)

Publication Number Publication Date
CN111159189A true CN111159189A (en) 2020-05-15

Family

ID=70558819

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911383521.9A Withdrawn CN111159189A (en) 2019-12-28 2019-12-28 Vehicle driving track query method, device, equipment and storage medium

Country Status (1)

Country Link
CN (1) CN111159189A (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113486083A (en) * 2021-06-30 2021-10-08 高新兴科技集团股份有限公司 Data processing method, system, computer storage medium and electronic device
CN114760323A (en) * 2022-03-02 2022-07-15 浙江吉利控股集团有限公司 Vehicle position information processing method, processing system and storage medium
WO2024001756A1 (en) * 2022-06-27 2024-01-04 中国第一汽车股份有限公司 Data storage method and apparatus, and electronic device and storage medium

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113486083A (en) * 2021-06-30 2021-10-08 高新兴科技集团股份有限公司 Data processing method, system, computer storage medium and electronic device
CN114760323A (en) * 2022-03-02 2022-07-15 浙江吉利控股集团有限公司 Vehicle position information processing method, processing system and storage medium
WO2024001756A1 (en) * 2022-06-27 2024-01-04 中国第一汽车股份有限公司 Data storage method and apparatus, and electronic device and storage medium

Similar Documents

Publication Publication Date Title
CN109712392B (en) Parking information processing method, device, equipment and storage medium based on block chain
CN111159189A (en) Vehicle driving track query method, device, equipment and storage medium
CN109032534B (en) Unmanned vehicle message transmission method, device, equipment and medium
CN106933630B (en) Client upgrading method, device, equipment and storage medium
CN110472095B (en) Voice guidance method, device, equipment and medium
WO2019095673A1 (en) Employee training enrollment method, application server, and computer readable storage medium
US20150330798A1 (en) Grid-based arrival time prediction
US8779949B2 (en) De-noising scheduled transportation data
CN112562388B (en) Vehicle connection management method and device and storage medium
CN112182132B (en) Subway user identification method, system, equipment and storage medium
CN111028074B (en) Method, system, server and storage medium for updating and inquiring overdue bill
WO2023241388A1 (en) Model training method and apparatus, energy replenishment intention recognition method and apparatus, device, and medium
CN111785000A (en) Vehicle state data uploading method and device, electronic equipment and storage medium
EP3674178A1 (en) Parking control method and apparatus, electronic device and storage medium
CN109284108B (en) Unmanned vehicle data storage method and device, electronic equipment and storage medium
WO2023179319A1 (en) Alarm method and device
CN109572687B (en) Parking control method and device, electronic equipment and storage medium
CN108827329B (en) City navigation method, system, equipment and storage medium
CN113760950B (en) Index data query method, device, electronic equipment and storage medium
CN114116946A (en) Data processing method and device, electronic equipment and storage medium
CN110515807B (en) Database table monitoring method, device, equipment and storage medium
CN114398475A (en) Data processing method, data processing device, electronic equipment and storage medium
CN113946601A (en) Personnel data query method, device, equipment and storage medium
CN112863223B (en) Bus information prompting method, device, storage medium and program product
CN113761306A (en) Vehicle-end data processing method and device

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
WW01 Invention patent application withdrawn after publication

Application publication date: 20200515

WW01 Invention patent application withdrawn after publication