CN110097661A - A kind of vehicle mileage data statistics method and device - Google Patents
A kind of vehicle mileage data statistics method and device Download PDFInfo
- Publication number
- CN110097661A CN110097661A CN201910333778.7A CN201910333778A CN110097661A CN 110097661 A CN110097661 A CN 110097661A CN 201910333778 A CN201910333778 A CN 201910333778A CN 110097661 A CN110097661 A CN 110097661A
- Authority
- CN
- China
- Prior art keywords
- mileage
- vehicle
- value
- data
- aggregate
- 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
Classifications
-
- G—PHYSICS
- G07—CHECKING-DEVICES
- G07C—TIME OR ATTENDANCE REGISTERS; REGISTERING OR INDICATING THE WORKING OF MACHINES; GENERATING RANDOM NUMBERS; VOTING OR LOTTERY APPARATUS; ARRANGEMENTS, SYSTEMS OR APPARATUS FOR CHECKING NOT PROVIDED FOR ELSEWHERE
- G07C5/00—Registering or indicating the working of vehicles
- G07C5/02—Registering or indicating driving, working, idle, or waiting time only
-
- G—PHYSICS
- G07—CHECKING-DEVICES
- G07C—TIME OR ATTENDANCE REGISTERS; REGISTERING OR INDICATING THE WORKING OF MACHINES; GENERATING RANDOM NUMBERS; VOTING OR LOTTERY APPARATUS; ARRANGEMENTS, SYSTEMS OR APPARATUS FOR CHECKING NOT PROVIDED FOR ELSEWHERE
- G07C5/00—Registering or indicating the working of vehicles
- G07C5/08—Registering or indicating performance data other than driving, working, idle, or waiting time, with or without registering driving, working, idle or waiting time
Abstract
The present invention provides a kind of vehicle mileage data statistics methods, comprising the following steps: receives and parses through the vehicle data information of car-mounted terminal upload;Mileage record aggregate-value is obtained, in the case where original mileage record aggregate-value is less than vehicle mileage value, vehicle mileage value is replaced to mileage record aggregate-value original in first database;It is presetting every day entry time point, is obtaining the mileage record aggregate-value in first database, and mileage record aggregate-value, mileage record date is associated with vehicle identification information;Record data based on the day accumulative mileage in the second database, using after vehicle day mileage record aggregate-value and vehicle day before yesterday mileage record aggregate-value between difference as the mileage value of day operation before vehicle, formed one vehicle day mileage statistical data.The present invention provides a kind of vehicle mileage data statistics devices.The present invention can be handled vehicle mileage data, and accurately count vehicle day mileage and moon mileage.
Description
Technical field
The present invention relates to vehicle networking technical fields, and in particular to a kind of vehicle mileage data statistics method and device.
Background technique
Vehicle mileage is that vehicle user, car operation company and vehicle factor etc. carry out vehicle risk assessment, vehicle to its vehicle
The important factor in order of the items such as after-sales service.Vehicle mileage can be divided into a day mileage, moon mileage and Nian Licheng.With regard to car operation
For company, vehicle mileage can not only help practical driving of its management vehicle of car operation corporate statistics and analysis to use feelings
Condition helps car operation company analysis vehicle to provide foundation using user behavior, but also mentions for car operation company to vehicle
For the data supporting of after-sales maintenance service.However, in existing vehicle day mileage and moon mileage statistic processes, due to vehicle
Mileage upload after each data processing link caused by the technical problems such as delay, jump and wrong data, cause most
The not accurate situation of the shortage of data and data of finish-unification meter, and statistical efficiency is not high in data handling procedure;Therefore, how effectively
Ground handles the vehicle mileage data after being uploaded to server, to accurately count vehicle day mileage and moon mileage number
According to, and statistical result is showed into the users such as car operation company, it is the technical issues that need to address.
Summary of the invention
For overcome the deficiencies in the prior art, the present invention provides a kind of vehicle mileage data statistics method and device, energy
It is enough effectively to handle to being uploaded to the vehicle mileage data after server, and accurately count vehicle day mileage and moon mileage
Data, while solving delay caused by each data processing link after the upload of vehicle mileage data, cause finally to count
Shortage of data and the not accurate problem of data, statistical efficiency are high.
Technical scheme is as follows:
A kind of vehicle mileage data statistics method, comprising the following steps:
Receive and parse through car-mounted terminal upload vehicle data information, obtain vehicle data information in vehicle mileage value and with
The associated vehicle identification information of vehicle mileage value;
According to vehicle identification information, it is tired to obtain original mileage record corresponding with the vehicle identification information in first database
Evaluation, judges whether original mileage record aggregate-value is less than vehicle mileage value, is less than vehicle in original mileage record aggregate-value
In the case where mileage value, vehicle mileage value as mileage record aggregate-value to be updated and is replaced original in first database
Mileage record aggregate-value;
Presetting every day entry time point, obtain first database in mileage record aggregate-value, and by mileage record aggregate-value,
The mileage record date is associated with vehicle identification information, forms one article of day accumulative mileage record data of corresponding vehicle and is stored in the
The day of two databases is in mileage table;
Data are recorded based on the day accumulative mileage in the second database, obtain the adjacent mileage in two dates front and back of same vehicle
Record aggregate-value, using after vehicle day mileage record aggregate-value and vehicle day before yesterday mileage record aggregate-value between difference as vehicle before
The mileage value of day operation, formed one vehicle day mileage statistical data.
Further, vehicle mileage value as mileage record aggregate-value to be updated and is replaced original in first database
Mileage record aggregate-value after it is further comprising the steps of:
In the default mileage record aggregate-value for monthly recording time point, obtaining in first database, and by mileage record aggregate-value,
Mileage record date and vehicle identification information are associated, form a month to date mileage record data of corresponding vehicle and are stored in
The moon of second database is in mileage table;
Month to date mileage record data based on the second database, the mileage record for obtaining two months front and back Adjacent vehicles are accumulative
Value, using after vehicle the moon mileage record aggregate-value and vehicle before between the moon mileage record aggregate-value difference as moon operation before vehicle
Mileage value, formed one the vehicle mileage moon statistical data.
Further, the vehicle data information of car-mounted terminal upload is received and parsed through, the vehicle in vehicle data information is obtained
Mileage value and with the associated vehicle identification information of vehicle mileage value, specifically include:
Receive the vehicle data information that car-mounted terminal uploads;
Judge whether the vehicle data information is real-time vehicle data;
Vehicle data information be real-time vehicle data in the case where, obtain vehicle data information in vehicle mileage value and with
The associated vehicle identification information of vehicle mileage value;
It is then mileage fragment letter by the vehicle data information flag in the case where vehicle data information is not real-time vehicle data
It ceases and is stored in the second database.
Further, judge whether vehicle mileage value is greater than or equal to the first default mileage value and is less than or equal to second in advance
If before mileage value, further includes:
Judge whether vehicle mileage value is greater than or equal to the first default mileage value and is less than or equal to the second default mileage value, in vehicle
In the case that mileage value is greater than or equal to the first default mileage value and is less than or equal to the second default mileage value, then according to vehicle
Identification information obtains original mileage record aggregate-value corresponding with the vehicle identification information in first database.
The present invention also provides a kind of vehicle mileage data statistics device, which is applied in LINUX server, including
With lower module:
Receiving module obtains the vehicle in vehicle data information for receiving and parsing through the vehicle data information of car-mounted terminal upload
Mileage value and with the associated vehicle identification information of vehicle mileage value;
Judgment module, for obtaining original corresponding with the vehicle identification information in first database according to vehicle identification information
The mileage record aggregate-value of beginning, judges whether original mileage record aggregate-value is less than vehicle mileage value, remembers in original mileage
It records in the case that aggregate-value is less than vehicle mileage value, vehicle mileage value as mileage record aggregate-value to be updated and is replaced the
Original mileage record aggregate-value in one database;
Obtain module, for presetting every day entry time point, obtain the mileage record aggregate-value in first database, and will in
Cheng Jilu aggregate-value, mileage record date are associated with vehicle identification information, form the day accumulative mileage note of corresponding vehicle
It records data and is stored in the day of the second database in mileage table;
Processing module obtains two dates of same vehicle for recording data based on the day accumulative mileage in the second database
The adjacent mileage record aggregate-value in front and back, by after vehicle day mileage record aggregate-value and vehicle day before yesterday mileage record aggregate-value between
Mileage value of the difference as day operation before vehicle, formed one vehicle day mileage statistical data.
Further, module is obtained, is also used to monthly record time point default, obtains the mileage note in first database
Aggregate-value is recorded, and mileage record aggregate-value, mileage record date and vehicle identification information are associated, forms corresponding vehicle
One month to date mileage record data is simultaneously stored in the moon of the second database in mileage table;
Processing module is also used to the month to date mileage record data based on the second database, obtains adjacent vehicle before and after two months
Mileage record aggregate-value, by after vehicle the moon mileage record aggregate-value and vehicle before between the moon mileage record aggregate-value difference make
For before vehicle the moon run mileage value, formed one the vehicle mileage moon statistical data.
Further, receiving module, comprising:
Receiving subelement, for receiving the vehicle data information of car-mounted terminal upload;
First judgment sub-unit, for judging whether the vehicle data information is real-time vehicle data;
Subelement is obtained, for obtaining in vehicle data information in the case where vehicle data information is real-time vehicle data
Vehicle mileage value and with the associated vehicle identification information of vehicle mileage value;
Subelement is marked, in the case where vehicle data information is not real-time vehicle data, then by the vehicle data information
Labeled as mileage fragment information and it is stored in the second database.
Further, judgment module, comprising:
Second judgment sub-unit, for judging whether vehicle mileage value is greater than or equal to the first default mileage value and is less than or equal to
Second default mileage value is greater than or equal to the first default mileage value in vehicle mileage value and is less than or equal to the second default mileage value
In the case where, then according to vehicle identification information, obtain in first database it is corresponding with the vehicle identification information it is original in
Cheng Jilu aggregate-value;
Third judgment sub-unit, whether the mileage record aggregate-value for judging original is less than vehicle mileage value, in original
In the case that Cheng Jilu aggregate-value is less than vehicle mileage value, vehicle mileage value as mileage record aggregate-value to be updated and is replaced
Change mileage record aggregate-value original in first database.
The present invention passes through the vehicle mileage value obtained in vehicle data information first, and in original mileage record aggregate-value
In the case where less than vehicle mileage value, vehicle mileage value is replaced to mileage record aggregate-value original in first database;Then
It is presetting every day entry time point, is obtaining the mileage record aggregate-value in first database, and monthly record the time default
Point obtains the mileage record aggregate-value in first database, is respectively formed day tables of data of mileage record aggregate-value and moon mileage
It records the tables of data of aggregate-value and counts the mileage value of vehicle day operation and the mileage value of moon operation accordingly, statistical data is accurate
And statistical efficiency is high.
It is that the present invention generates the utility model has the advantages that
1. the present invention can be handled effectively to being uploaded to the vehicle mileage data after server, and accurately count vehicle
Day mileage and moon mileage;
2. the present invention solves delay caused by each data processing link after the upload of vehicle mileage data, cause finally to count
Shortage of data and the not accurate problem of data, statistical efficiency it is high.
Detailed description of the invention
The attached drawing constituted part of this application is used to provide further understanding of the present invention, schematic reality of the invention
It applies example and its explanation is used to explain the present invention, do not constitute improper limitations of the present invention.In the accompanying drawings:
Fig. 1 is the flow chart of vehicle mileage data statistics method described in the embodiment of the present invention;
Fig. 2 is the flow chart for receiving and parsing through method of vehicle data information described in the embodiment of the present invention;
Fig. 3 is the schematic diagram of vehicle mileage data statistics device described in the embodiment of the present invention;
Fig. 4 is the schematic diagram of receiving module described in the embodiment of the present invention.
Specific embodiment
The embodiment of the present invention is described in detail below in conjunction with attached drawing, but the present invention can be defined by the claims
Implement with the multitude of different ways of covering.
As shown in Fig. 1, a kind of vehicle mileage data statistics method, comprising the following steps:
Step S101: receiving and parsing through the vehicle data information of car-mounted terminal upload, obtains in the vehicle in vehicle data information
Journey value and with the associated vehicle identification information of vehicle mileage value.
As shown in Fig. 2, step S101, specifically includes the following steps:
Step S10101: the vehicle data information that car-mounted terminal uploads is received;
Step S10102: judge whether the vehicle data information is real-time vehicle data;
Step S10103: in the case where vehicle data information is real-time vehicle data, the vehicle in vehicle data information is obtained
Mileage value and with the associated vehicle identification information of vehicle mileage value;
Step S10104: in the case where vehicle data information is not real-time vehicle data, then by the vehicle data information flag
For mileage fragment information and it is stored in Mysql database;In the case where vehicle data information is real-time vehicle data, into step
Rapid S102.
In above-mentioned steps S10104, Mysql database (i.e. heretofore described " the second database ") is located at vehicle number
According in LINUX server, it is used as historgraphic data recording system, it is (i.e. of the invention from Redis database to be mainly used for record
Described in " first database ") vehicle mileage value, and vehicle, mileage time, mileage value can be associated with guarantor well
It deposits, can efficiently be checked out when needing for statistical analysis.
In the process of moving, car-mounted terminal can collect the vehicle data information of user's traveling to vehicle, and real-time transmission is to vehicle
Data LINUX server, vehicle data LINUX server first determine whether the vehicle number after receiving vehicle data information
It is believed that breath whether be real-time vehicle data, when vehicle data information be real-time vehicle data when, just to the vehicle data information into
Row parsing obtains vehicle identification information (i.e. vehicle ID number), record time and vehicle mileage value etc.;Wherein, vehicle data information
Being includes the vehicles data such as vehicle mileage, vehicles identifications, motor, battery, GPS, alarm.
Step S102: judge whether vehicle mileage value is greater than or equal to the first default mileage value and is less than or equal to second in advance
If mileage value, the case where vehicle mileage value is greater than or equal to the first default mileage value and is less than or equal to the second default mileage value
Under, then according to vehicle identification information, obtain original mileage record corresponding with the vehicle identification information in Redis database
Aggregate-value.
Above-mentioned steps S102 is mainly used for judging whether vehicle mileage value is effective, and " first is depended in deterministic process
The setting of default mileage value " " the second default mileage value ", such as in the specific implementation process, set the first default mileage value to
0, the second default mileage value is set as 990,000, when vehicle mileage value is in the section between 0 to 990,000 kilometer, then by the vehicle
Mileage value is determined as virtual value.
Step S103: judging whether original mileage record aggregate-value is less than vehicle mileage value, in original mileage record
In the case that aggregate-value is less than vehicle mileage value, vehicle mileage value as mileage record aggregate-value to be updated and is replaced
Original mileage record aggregate-value in Redis database.
Above-mentioned steps S103 passes through the original mileage record aggregate-value that will record in vehicle mileage value and Redis database
It compares, achievees the purpose that judge vehicle mileage value with the presence or absence of jump situation, wherein original mileage record aggregate-value exists
It is 0 when original state, thereafter when the vehicle mileage value of upload is greater than mileage record aggregate-value, then mileage record aggregate-value substitutes
Mileage record aggregate-value is to realize the original mileage record aggregate-value updated in Redis database, for example, being embodied
In the process, according to the vehicle ID number in vehicle data information, the vehicle that vehicle ID number is 555 is obtained in Redis database
CarMileage (i.e. vehicle mileage value) is set as variable 2 by CarMileage (i.e. vehicle mileage value), will be in Redis database
The original mileage record aggregate-value of record is set as variable 1;Reduced parameters 1 and variable 2, if variable 2 is big, by vehicle ID number
It is stored in Redis database for the CarMileage (i.e. vehicle mileage value) of 555 vehicle, does not otherwise update Redis database
In original mileage record aggregate-value.
It should be noted that the Redis database (i.e. first database) in the present embodiment is the high-performance of an open source
Key-value storage system has the function of caching vehicle data;Compared with other databases, Redis database supports storage
Value type it is more, have the characteristics of high operational efficiency, at the same can prevent from restarting due to equipment, the system failure and cause
The case where Redis internal storage data is lost.
Step S104: presetting every day entry time point, obtains the mileage record aggregate-value in Redis database, and will
Mileage record aggregate-value, mileage record date are associated with vehicle identification information, form the day accumulative mileage of corresponding vehicle
Record data are simultaneously stored in the day of Mysql database in accumulative mileage tables of data;
Above-mentioned steps S104 is mainly used for constructing day accumulative mileage tables of data, wherein presetting every day entry time point can be set
For any one daily time point, and in the present embodiment, presetting every day entry time point is daily 0 point;In one day is accumulative
Cheng Jilu data include car number (i.e. vehicle identification information), mileage record time and mileage record aggregate-value, such as vehicle
Number 555,2018-12-25 00:00:00 and 16032.9 kilometers.
Step S105: data are recorded based on the day accumulative mileage in Mysql database, obtain two dates of same vehicle
The adjacent mileage record aggregate-value in front and back, by after vehicle day mileage record aggregate-value and vehicle day before yesterday mileage record aggregate-value between
Mileage value of the difference as day operation before vehicle, formed one vehicle day mileage statistical data.
Above-mentioned steps S105 is mainly used in Mysql database, records data statistics according to day accumulative mileage and goes out vehicle
Day mileage record data;Adjacent mileage record aggregate-value before and after two dates of same vehicle, for example, vehicle ID number is
555 vehicle, when record date is 2018-12-25 00:00:00, mileage record aggregate-value is 16032.9 kilometers, and
When record date is 2018-12-26 00:00:00, mileage record aggregate-value is 17032.9 kilometers, then vehicle ID number is
555 vehicle is 1000 kilometers in the mileage value of 25 day operation December in 2018, vehicle ID number 555,2018-12-25 and 1000
Kilometer it is associated and formed one vehicle day mileage statistical data.
After step s 103, also into step S106 and step S107, step S106 is mainly used for constructing the present embodiment
Month to date mileage table, step S107 are mainly used for counting the moon mileage record data of vehicle.
Step S106: in the default mileage record aggregate-value for monthly recording time point, obtaining in first database, and will in
Cheng Jilu aggregate-value, mileage record date and vehicle identification information are associated, form a month to date mileage of corresponding vehicle
Record data are simultaneously stored in the month to date mileage table of Mysql database;
In above-mentioned steps S106, default monthly record time point can be set to monthly any one time point, and in this implementation
In example, presetting monthly record time point is monthly 0 point on the 1st;One month to date mileage record data includes car number (i.e. vehicle
Identification information), mileage record time and mileage record aggregate-value, such as car number 555,2018-12-25 00:00:00 and
16032.9 kilometer.
Step S107: the month to date mileage record data based on Mysql database obtain same two month of vehicle front and back
Adjacent mileage record aggregate-value, by after vehicle the moon mileage record aggregate-value and vehicle before difference between moon mileage record aggregate-value
As before vehicle the moon run mileage value, formed one the vehicle mileage moon statistical data.
In above-mentioned steps S107, adjacent mileage record aggregate-value before and after same two month of vehicle, such as vehicle ID number
For 555 vehicle, for record date in 2018-12-01 00:00:00, mileage record aggregate-value is 16032.9 kilometers, and
When record date is 2019-01-01 00:00:00, mileage record aggregate-value is 19032.9 kilometers, then vehicle ID number
It in the mileage value that in December, 2018 runs is 3000 kilometers for 555 vehicle, vehicle ID number 555,2018-12-25 and 3000
Kilometer it is associated and formed one the vehicle moon mileage record data.
Vehicle mileage data statistics method described in the embodiment of the present invention, by obtaining the vehicle in vehicle data information first
Mileage value, and in the case where original mileage record aggregate-value is less than vehicle mileage value, vehicle mileage value is replaced first
Original mileage record aggregate-value in database;Then it is presetting every day entry time point, is obtaining the mileage in first database
Aggregate-value is recorded, and in the default mileage record aggregate-value for monthly recording time point, obtaining in first database, is respectively formed
The tables of data of day mileage record aggregate-value and the tables of data of moon mileage record aggregate-value simultaneously count in vehicle day operation accordingly
The mileage value of journey value and moon operation, therefore, the embodiment of the present invention can be effectively to being uploaded to the vehicle mileage after server
According to being handled, and vehicle day mileage and moon mileage are accurately counted, while after solving the upload of vehicle mileage data
Delay caused by each data processing link jumps and the technical problems such as wrong data, cause the shortage of data finally counted and
Accurately situation, statistical efficiency height, the accuracy of data statistics result do not further increase data.
As shown in Fig. 3, the present embodiment additionally provides a kind of vehicle mileage data statistics device, is applied to LINUX and takes
It is engaged in device, comprises the following modules:
Receiving module obtains the vehicle in vehicle data information for receiving and parsing through the vehicle data information of car-mounted terminal upload
Mileage value and with the associated vehicle identification information of vehicle mileage value;
Judgment module, for obtaining original corresponding with the vehicle identification information in first database according to vehicle identification information
The mileage record aggregate-value of beginning, judges whether original mileage record aggregate-value is less than vehicle mileage value, remembers in original mileage
It records in the case that aggregate-value is less than vehicle mileage value, vehicle mileage value as mileage record aggregate-value to be updated and is replaced the
Original mileage record aggregate-value in one database;
Obtain module, for presetting every day entry time point, obtain the mileage record aggregate-value in first database, and will in
Cheng Jilu aggregate-value, mileage record date are associated with vehicle identification information, form the day accumulative mileage note of corresponding vehicle
It records data and is stored in the day of the second database in mileage table;
Processing module obtains two dates of same vehicle for recording data based on the day accumulative mileage in the second database
The adjacent mileage record aggregate-value in front and back, by after vehicle day mileage record aggregate-value and vehicle day before yesterday mileage record aggregate-value between
Mileage value of the difference as day operation before vehicle, formed one vehicle day mileage statistical data.
Preferably, the acquisition module is also used in the default mileage for monthly recording time point, obtaining in first database
Aggregate-value is recorded, and mileage record aggregate-value, mileage record date and vehicle identification information are associated, forms corresponding vehicle
A month to date mileage record data and be stored in the moon of the second database in mileage table;
The processing module is also used to the month to date mileage record data based on the second database, obtains phase before and after two months
The mileage record aggregate-value of adjacent vehicle, by after vehicle the moon mileage record aggregate-value and vehicle before between moon mileage record aggregate-value it is poor
Value as before vehicle the moon operation mileage value, formed one the vehicle mileage moon statistical data.
Preferably, as shown in Fig. 4, the receiving module, comprising:
Receiving subelement, for receiving the vehicle data information of car-mounted terminal upload;
First judgment sub-unit, for judging whether the vehicle data information is real-time vehicle data;
Subelement is obtained, for obtaining in vehicle data information in the case where vehicle data information is real-time vehicle data
Vehicle mileage value and with the associated vehicle identification information of vehicle mileage value;
Subelement is marked, in the case where vehicle data information is not real-time vehicle data, then by the vehicle data information
Labeled as mileage fragment information and it is stored in the second database.
Preferably, the judgment module, comprising:
Second judgment sub-unit, for judging whether vehicle mileage value is greater than or equal to the first default mileage value and is less than or equal to
Second default mileage value is greater than or equal to the first default mileage value in vehicle mileage value and is less than or equal to the second default mileage value
In the case where, then according to vehicle identification information, obtain in first database it is corresponding with the vehicle identification information it is original in
Cheng Jilu aggregate-value;
Third judgment sub-unit, whether the mileage record aggregate-value for judging original is less than vehicle mileage value, in original
In the case that Cheng Jilu aggregate-value is less than vehicle mileage value, vehicle mileage value as mileage record aggregate-value to be updated and is replaced
Change mileage record aggregate-value original in first database.
A kind of vehicle mileage data statistics device provided in an embodiment of the present invention and above-mentioned vehicle mileage data statistics method
For identical technical concept, beneficial effect having the same, details are not described herein again.
Claims (8)
1. a kind of vehicle mileage data statistics method, which is characterized in that the described method comprises the following steps:
Receive and parse through car-mounted terminal upload vehicle data information, obtain vehicle data information in vehicle mileage value and with
The associated vehicle identification information of vehicle mileage value;
According to vehicle identification information, it is tired to obtain original mileage record corresponding with the vehicle identification information in first database
Evaluation, judges whether original mileage record aggregate-value is less than vehicle mileage value, is less than vehicle in original mileage record aggregate-value
In the case where mileage value, vehicle mileage value as mileage record aggregate-value to be updated and is replaced original in first database
Mileage record aggregate-value;
Presetting every day entry time point, obtain first database in mileage record aggregate-value, and by mileage record aggregate-value,
The mileage record date is associated with vehicle identification information, forms one article of day accumulative mileage record data of corresponding vehicle and is stored in the
The day of two databases is in mileage table;
Data are recorded based on the day accumulative mileage in the second database, obtain the adjacent mileage in two dates front and back of same vehicle
Record aggregate-value, using after vehicle day mileage record aggregate-value and vehicle day before yesterday mileage record aggregate-value between difference as vehicle before
The mileage value of day operation, formed one vehicle day mileage statistical data.
2. vehicle mileage data statistics method as described in claim 1, which is characterized in that using vehicle mileage value as to be updated
Mileage record aggregate-value and replace further comprising the steps of after mileage record aggregate-value original in first database:
In the default mileage record aggregate-value for monthly recording time point, obtaining in first database, and by mileage record aggregate-value,
Mileage record date and vehicle identification information are associated, form a month to date mileage record data of corresponding vehicle and are stored in
The moon of second database is in mileage table;
Month to date mileage record data based on the second database, the mileage record for obtaining two months front and back Adjacent vehicles are accumulative
Value, using after vehicle the moon mileage record aggregate-value and vehicle before between the moon mileage record aggregate-value difference as moon operation before vehicle
Mileage value, formed one the vehicle mileage moon statistical data.
3. vehicle mileage data statistics method as described in claim 1, which is characterized in that
Receive and parse through car-mounted terminal upload vehicle data information, obtain vehicle data information in vehicle mileage value and with
The associated vehicle identification information of vehicle mileage value, specifically includes:
Receive the vehicle data information that car-mounted terminal uploads;
Judge whether the vehicle data information is real-time vehicle data;
Vehicle data information be real-time vehicle data in the case where, obtain vehicle data information in vehicle mileage value and with
The associated vehicle identification information of vehicle mileage value;
It is then mileage fragment letter by the vehicle data information flag in the case where vehicle data information is not real-time vehicle data
It ceases and is stored in the second database.
4. a kind of vehicle mileage data processing method as described in claim 1, which is characterized in that
Judge whether vehicle mileage value is greater than or equal to the first default mileage value and is less than or equal to before the second default mileage value,
Further include:
Judge whether vehicle mileage value is greater than or equal to the first default mileage value and is less than or equal to the second default mileage value, in vehicle
In the case that mileage value is greater than or equal to the first default mileage value and is less than or equal to the second default mileage value, then according to vehicle
Identification information obtains original mileage record aggregate-value corresponding with the vehicle identification information in first database.
5. a kind of vehicle mileage data statistics device is applied in LINUX server, which is characterized in that comprise the following modules:
Receiving module obtains the vehicle in vehicle data information for receiving and parsing through the vehicle data information of car-mounted terminal upload
Mileage value and with the associated vehicle identification information of vehicle mileage value;
Judgment module, for obtaining original corresponding with the vehicle identification information in first database according to vehicle identification information
The mileage record aggregate-value of beginning, judges whether original mileage record aggregate-value is less than vehicle mileage value, remembers in original mileage
It records in the case that aggregate-value is less than vehicle mileage value, vehicle mileage value as mileage record aggregate-value to be updated and is replaced the
Original mileage record aggregate-value in one database;
Obtain module, for presetting every day entry time point, obtain the mileage record aggregate-value in first database, and will in
Cheng Jilu aggregate-value, mileage record date are associated with vehicle identification information, form the day accumulative mileage note of corresponding vehicle
It records data and is stored in the day of the second database in mileage table;
Processing module obtains two dates of same vehicle for recording data based on the day accumulative mileage in the second database
The adjacent mileage record aggregate-value in front and back, by after vehicle day mileage record aggregate-value and vehicle day before yesterday mileage record aggregate-value between
Mileage value of the difference as day operation before vehicle is formed and mileage statistical data and is synchronized in third database a vehicle day.
6. a kind of vehicle mileage data statistics device as claimed in claim 5, which is characterized in that
The acquisition module is also used in the default mileage record aggregate-value for monthly recording time point, obtaining in first database,
And be associated mileage record aggregate-value, mileage record date and vehicle identification information, one month for forming corresponding vehicle is tired
It counts mileage record data and is stored in the moon of the second database in mileage table;
The processing module is also used to the month to date mileage record data based on the second database, obtains phase before and after two months
The mileage record aggregate-value of adjacent vehicle, by after vehicle the moon mileage record aggregate-value and vehicle before between moon mileage record aggregate-value it is poor
Mileage value of the value as moon operation before vehicle, forms and statistical data and is synchronized in third database a vehicle mileage moon.
7. a kind of vehicle mileage data statistics device as claimed in claim 5, which is characterized in that
The receiving module, comprising:
Receiving subelement, for receiving the vehicle data information of car-mounted terminal upload;
First judgment sub-unit, for judging whether the vehicle data information is real-time vehicle data;
Subelement is obtained, for obtaining in vehicle data information in the case where vehicle data information is real-time vehicle data
Vehicle mileage value and with the associated vehicle identification information of vehicle mileage value;
Subelement is marked, in the case where vehicle data information is not real-time vehicle data, then by the vehicle data information
Labeled as mileage fragment information and it is stored in the second database.
8. a kind of vehicle mileage data processing unit as claimed in claim 5, which is characterized in that
The judgment module, comprising:
Second judgment sub-unit, for judging whether vehicle mileage value is greater than or equal to the first default mileage value and is less than or equal to
Second default mileage value is greater than or equal to the first default mileage value in vehicle mileage value and is less than or equal to the second default mileage value
In the case where, then according to vehicle identification information, obtain in first database it is corresponding with the vehicle identification information it is original in
Cheng Jilu aggregate-value;
Third judgment sub-unit, whether the mileage record aggregate-value for judging original is less than vehicle mileage value, in original
In the case that Cheng Jilu aggregate-value is less than vehicle mileage value, vehicle mileage value as mileage record aggregate-value to be updated and is replaced
Change mileage record aggregate-value original in first database.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910333778.7A CN110097661A (en) | 2019-04-24 | 2019-04-24 | A kind of vehicle mileage data statistics method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910333778.7A CN110097661A (en) | 2019-04-24 | 2019-04-24 | A kind of vehicle mileage data statistics method and device |
Publications (1)
Publication Number | Publication Date |
---|---|
CN110097661A true CN110097661A (en) | 2019-08-06 |
Family
ID=67445789
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910333778.7A Pending CN110097661A (en) | 2019-04-24 | 2019-04-24 | A kind of vehicle mileage data statistics method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110097661A (en) |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111198775A (en) * | 2019-12-19 | 2020-05-26 | 潍柴动力股份有限公司 | Method and system for correcting abnormal EEPROM storage state and motor vehicle |
CN111798591A (en) * | 2020-05-29 | 2020-10-20 | 广州亚美智造科技有限公司 | Method and device for determining total mileage of vehicle, computer equipment and storage medium |
CN112380059A (en) * | 2020-11-13 | 2021-02-19 | 武汉蓝星科技股份有限公司 | Vehicle instrument mileage information storage method and system |
CN113139019A (en) * | 2021-06-18 | 2021-07-20 | 智己汽车科技有限公司 | Method and device for recording mileage data of vehicle on block chain |
CN113911051A (en) * | 2021-11-04 | 2022-01-11 | 艾尔卡(北京)科技有限公司 | Method and device for obtaining current driving mileage of vehicle and electronic equipment |
CN115439955A (en) * | 2022-08-30 | 2022-12-06 | 高新兴物联科技股份有限公司 | Vehicle mileage unit determination method, device, equipment and readable storage medium |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20050015186A1 (en) * | 2003-06-02 | 2005-01-20 | John Kelly | Method and system of managing service reminders using mileage estimates |
CN102072735A (en) * | 2009-11-24 | 2011-05-25 | 深圳市赛格导航科技股份有限公司 | Method and system for calculating mileage quickly |
CN102385620A (en) * | 2011-10-25 | 2012-03-21 | 深圳市赛格导航科技股份有限公司 | Mileage data statistics processing method and system based on document database |
CN106682232A (en) * | 2017-01-13 | 2017-05-17 | 西安电子科技大学 | Statistical statement generating method of vehicle monitoring system |
CN206683653U (en) * | 2016-09-13 | 2017-11-28 | 安徽江淮汽车集团股份有限公司 | A kind of vehicle mileage standby system and automobile |
CN108549721A (en) * | 2018-04-24 | 2018-09-18 | 上汽通用五菱汽车股份有限公司 | Synchronous updating method, server and the readable storage medium storing program for executing of vehicle mileage data |
-
2019
- 2019-04-24 CN CN201910333778.7A patent/CN110097661A/en active Pending
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20050015186A1 (en) * | 2003-06-02 | 2005-01-20 | John Kelly | Method and system of managing service reminders using mileage estimates |
CN102072735A (en) * | 2009-11-24 | 2011-05-25 | 深圳市赛格导航科技股份有限公司 | Method and system for calculating mileage quickly |
CN102385620A (en) * | 2011-10-25 | 2012-03-21 | 深圳市赛格导航科技股份有限公司 | Mileage data statistics processing method and system based on document database |
CN206683653U (en) * | 2016-09-13 | 2017-11-28 | 安徽江淮汽车集团股份有限公司 | A kind of vehicle mileage standby system and automobile |
CN106682232A (en) * | 2017-01-13 | 2017-05-17 | 西安电子科技大学 | Statistical statement generating method of vehicle monitoring system |
CN108549721A (en) * | 2018-04-24 | 2018-09-18 | 上汽通用五菱汽车股份有限公司 | Synchronous updating method, server and the readable storage medium storing program for executing of vehicle mileage data |
Cited By (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111198775A (en) * | 2019-12-19 | 2020-05-26 | 潍柴动力股份有限公司 | Method and system for correcting abnormal EEPROM storage state and motor vehicle |
CN111198775B (en) * | 2019-12-19 | 2023-07-18 | 潍柴动力股份有限公司 | Method and system for correcting EEPROM storage state abnormality and motor vehicle |
CN111798591A (en) * | 2020-05-29 | 2020-10-20 | 广州亚美智造科技有限公司 | Method and device for determining total mileage of vehicle, computer equipment and storage medium |
CN111798591B (en) * | 2020-05-29 | 2022-03-08 | 广州亚美智造科技有限公司 | Method and device for determining total mileage of vehicle, computer equipment and storage medium |
CN112380059A (en) * | 2020-11-13 | 2021-02-19 | 武汉蓝星科技股份有限公司 | Vehicle instrument mileage information storage method and system |
CN112380059B (en) * | 2020-11-13 | 2024-02-23 | 武汉蓝星科技股份有限公司 | Method and system for storing mileage information of vehicle instrument |
CN113139019A (en) * | 2021-06-18 | 2021-07-20 | 智己汽车科技有限公司 | Method and device for recording mileage data of vehicle on block chain |
US11695566B2 (en) | 2021-06-18 | 2023-07-04 | Zhiji Automotive Technology Co., Ltd. | Method and apparatus for recording mileage data of vehicle on blockchain |
CN113911051A (en) * | 2021-11-04 | 2022-01-11 | 艾尔卡(北京)科技有限公司 | Method and device for obtaining current driving mileage of vehicle and electronic equipment |
CN115439955A (en) * | 2022-08-30 | 2022-12-06 | 高新兴物联科技股份有限公司 | Vehicle mileage unit determination method, device, equipment and readable storage medium |
CN115439955B (en) * | 2022-08-30 | 2023-10-20 | 高新兴物联科技股份有限公司 | Vehicle mileage unit determination method, device, equipment and readable storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110097661A (en) | A kind of vehicle mileage data statistics method and device | |
CN109558988B (en) | Electric vehicle energy consumption prediction method and system based on big data fusion | |
CN108803559B (en) | Vehicle fault analysis method, device and system | |
CN110517084B (en) | Vehicle function activity analysis method and system | |
CN109523819B (en) | Passenger IC card data and station matching method based on bus arrival and departure | |
CN103278833A (en) | Line recommendation system and method based on Beidou satellite/GPS (global positioning system) data | |
CN106157621B (en) | A kind of intelligent Road management system based on data analysis | |
CN112116105A (en) | Enterprise-level new energy automobile supervision system based on Internet of things platform | |
CN104965434A (en) | Intelligent management system for commercial vehicle tire and wheel position information | |
CN112208337A (en) | Mileage deviation correcting method and device for electric two-wheeled vehicle and electric two-wheeled vehicle | |
CN108200551A (en) | A kind of recording method of oil-filling data, device, terminal device and server | |
CN106570182B (en) | Method and system for identifying getting-off station of bus | |
CN111291035B (en) | Method and device for slicing data and related products | |
CN103312540B (en) | Customer service demand parameter is determined method and apparatus | |
CN115544900B (en) | Method for analyzing electric vehicle endurance mileage influence factors based on shape algorithm | |
CN104077704A (en) | System and method for collecting vehicle refueling information on basis of OBD devices of vehicles | |
CN116757538A (en) | Dynamic assessment system and method for energy efficiency and carbon emission performance of vehicles | |
CN103607408A (en) | Fuel consumption accounting method and device based on real-time fuel consumption information acquisition | |
CN103678716B (en) | A kind of Distributed Storage based on formatted data collection and computational methods | |
CN110348092B (en) | Track data simulation method and device | |
CN108038137B (en) | Offshore wind energy evaluation system based on distributed analytic engine | |
Horvath | CO2 emission of Real Time Monitoring in China | |
CN113781771B (en) | Online operation method of IVE model | |
WO2023093289A1 (en) | Vehicle state remote monitoring method and system | |
CN117171701B (en) | Vehicle running data processing method, device, equipment and medium |
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 |