A query method and device for data record of bayonet passing vehicles

Abstract

Embodiments of the invention provide a barrier gate vehicle passing data record query method and apparatus. The method comprises the steps of receiving a query request; obtaining index files corresponding to to-be-queried fields, and querying record numbers corresponding to contents of the to-be-queried fields in the index files; according to a preset offset, calculating the positions of the to-be-queried record numbers in data files in sequence; in the positions, searching for content numbers and field names of the fields corresponding to the record numbers; according to the field names, obtaining field files corresponding to the field names, and according to the content numbers of the fields, querying contents corresponding to the content numbers of the fields in the field files; and outputting the to-be-queried fields and target fields corresponding to the to-be-queried fields. By applying the method and the apparatus, the storage space for storing barrier gate vehicle passing datarecords and the hardware cost are reduced; and the barrier gate vehicle passing data record query speed is increased.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a query method and device for checkpoint passing data records. Background technique [0002] With the rapid development of the monitoring industry and the increase of intelligent transportation and smart bayonet devices, more and more vehicle passing data records have been generated. How to efficiently store and query these massive vehicle passing data records is the main problem at present. [0003] Usually, a vehicle passing data record refers to a piece of structured data. For example, a vehicle passing data record refers to the information generated by a vehicle passing through an electronic checkpoint, which may include: the time of passing through the checkpoint, the license plate number, the time of passing through the checkpoint Fields such as serial number, vehicle color, and vehicle type. In practical applications, the database system stores the massive check...

AI Technical Summary

Problems solved by technology

However, the structure of the traditional database system is complex, and it usually supports large and comprehensive functions. Therefore, it is difficult to effectively manage the passing data by using the query method supported by the traditional database, and the query speed is slow, and it also requires a large amount of storage space.

Images