Statistical statement generating method of vehicle monitoring system

Abstract

The invention discloses a statistical statement generating method of a vehicle monitoring system. The problem that overlong consumed time is caused by the low querying efficiency and the low data reusability when an existing statistical statement is generated is mainly solved. The statistical statement generating method in the technical scheme includes the steps that 1) a real-time table is established; 2) a history list is established; 3) a daily statistical table is established; 4) real-time data is obtained and stored in the real-time table; 5) when current time is zero o'clock in the morning, the history list is updated, and when current time is non-zero o'clock in the morning, the method returns to the step 4); 6) the real-time data is calculated, daily statistical data is obtained and stored in the daily statistical table, the real-time table is emptied, and the method returns to the step 4); 7) the daily statistical data meeting the requirements is screened to generate the statistical statement. According to the statistical statement generating method, the real-time data and history data are partitioned, the daily statistical data with the day as the particle size is stored in a database, it is avoided that a large amount of history data is scanned, the querying efficiency is improved, the data reusability is improved, the generating time of the statistical statement is shortened, and the statistical statement generating method can be used for real-time statistics of travelling chartered vehicles, third-grade-or-above route passenger vehicles and dangerous chemical vehicles.

Description

Technical field [0001] The invention belongs to the technical field of computer statistics, and particularly relates to a method for generating statistical reports, which can be used for real-time statistics of "two passengers and one danger" vehicles. Background technique [0002] At present, my country's transportation industry is developing rapidly, and the number of "two passengers and one danger" vehicles is increasing year by year, which brings certain hidden dangers to traffic safety. The so-called "two passengers and one dangerous" vehicles refer to chartered buses for tourism, passenger buses of Class 3 or higher, and special road vehicles for transporting hazardous chemicals, fireworks and firecrackers, and civilian explosives, because such vehicles involve the masses in their driving. Its personal safety and impact on the surrounding environment have been highly valued by the country and people. [0003] The "two passengers and one danger" vehicle monitoring system base...

AI Technical Summary

Problems solved by technology

However, because this method does not consider the correlation between statistical analysis of vehicle information and time, the query results are different in different time periods. At the same time, because this method does not involve the differential processing of time periods, the reusability of query results is not high.

Images