Method for judgment and statistics of vehicle beyond bounds by a storage process

A stored procedure and vehicle technology, applied in registration/instruction of vehicle operation, traffic control system of road vehicles, calculation, etc., can solve problems such as slow calculation speed and complex statement writing, and achieve the effect of strong data processing ability

Active Publication Date: 2008-06-25
XIAMEN YAXON NETWORKS CO LTD
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, for SQL Server 2000 and previous versions, only SQL language can be used to write stored procedures. When the data operation is more complicated, especially when each piece of data needs to be processed one by one, the operation speed is relatively slow, and the writing of statements is also very complicated.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for judgment and statistics of vehicle beyond bounds by a storage process
  • Method for judgment and statistics of vehicle beyond bounds by a storage process

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] see figure 1 , figure 2 as shown, figure 1 It is a schematic diagram of the composition of the service center for realizing the method of the present invention.

[0035] The service center structure includes at least:

[0036] A business layer 11, used to provide Web services and process business processes;

[0037] A data layer 12, including a static database for storing information and a real-time database for communication;

[0038] A network layer 13, used for sending and receiving data packets of the vehicle-mounted terminal;

[0039] The data layer 12 is connected to the business layer 11 and connected to the network layer 13. The business layer 11 mainly writes instructions, parameters and file information (static database) to the database, query command responses, vehicle driving data, etc.; A command to write the relevant data uploaded by the platform. Operations on the database by the business layer 11 and the network layer 13 are all completed through ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a method which is used for the storage process and realizes the determining and accounting for vehicles which cross the border. A service centre which comprises a service layer, a data layer and a network layer is established, all the operations of the service layer and the network layer of the service centre to a data base in the data layer are realized through a storage process, the network layer of the service centre stores the data uploaded by a vehicle terminal into the driving data sheet in the data base of the data layer after the data is analyzed, the service layer stores the definite regional parameters logged by a vehicle manager in a definite regional sheet in the data base, when the service center receives determining and accounting for the vehicles which cross the border of a vehicle manager, the service center determines whether the vehicle crosses the border, and accounts the vehicle border crossing condition. The invention realizes that the border crossing state of tracing points of large scale vehicles is accounted in the data base, further accounts the border crossing frequency, the border crossing time span and the driving distance during the border crossing period, then returns the statistical result to the service layer, the purposes for improving the speed and reducing the date transmission quantity are achieved, therefore, the system processing time is shortened.

Description

technical field [0001] The invention relates to a vehicle statistics method, in particular to a method for realizing vehicle cross-border judgment and statistics by using stored procedures. Background technique [0002] Area crossing means that the vehicle's driving trajectory exceeds the limited area, and it is one of the assessment indicators for evaluating vehicle driving and driver driving performance. Counting the number of vehicle crossings, the duration of crossing the boundary, and the driving distance during the crossing period, the management of vehicles and the evaluation of drivers provide a quantitative indicator, which is conducive to the efficient management of vehicles and drivers. In the existing vehicle management method, the vehicle manager can use the driving data regularly uploaded by the vehicle platform to judge and count the vehicle's crossing state according to the given limited area. The operation of data in the database can be realized through app...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G08G1/00G08G1/123G06F17/30G07C5/08
Inventor 雷艳军常海军张萌曲建云余建成
Owner XIAMEN YAXON NETWORKS CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products