CN103810298A - Main memory database based rapid vehicle information query method and system - Google Patents
Main memory database based rapid vehicle information query method and system Download PDFInfo
- Publication number
- CN103810298A CN103810298A CN201410083611.7A CN201410083611A CN103810298A CN 103810298 A CN103810298 A CN 103810298A CN 201410083611 A CN201410083611 A CN 201410083611A CN 103810298 A CN103810298 A CN 103810298A
- Authority
- CN
- China
- Prior art keywords
- information
- control
- ensure effective
- effective monitoring
- illegal activities
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Traffic Control Systems (AREA)
Abstract
A main memory database based rapid vehicle information query method and system is provided, wherein an enquiry form for recording the vehicle information data is created in a main memory database to replace a traditional physical database, all functions of the main memory database are logical, then unnecessary interaction operation with physical equipment is avoided, and big data query is also supported to remarkably increase the passing efficiency. The information of vehicles under surveillance is acquired and inserted into the enquiry form, and the vehicle is queried only through acquiring the data of the license plate number and querying and comparing the data of the license plate number with the stored data in a memory. The query of the information of the vehicle under surveillance does not depend on the network, and the requirement on the network reliability is lowered.
Description
Technical field
The present invention relates to a kind of database technology.Relate in particular to a kind of information of vehicles method for quickly querying and system based on memory database.
Background technology
Along with the jumbo growth of automobile pollution in the development of automobile industry and city, the automobile how quantity being grown stronger day by day is effectively managed, and is the task of top priority of pendulum in face of relevant department.License plate number, as the effective carrier of identification information of vehicles, by identification license plate number and be connected and can transfer detailed information of vehicles data with the information of vehicles register system of relevant department.Often need in vehicular traffic, obtain the license plate number information of vehicle at traffic block port as slip-road, major urban arterial highway traffic light intersection and large parking lot gateway etc., and the information of extracting is connected with the information of vehicles register system of relevant department, the database of the license plate number information of the vehicle obtaining and relevant department is inquired about, compared.
Existing vehicle information database mainly adopts conventional physical database.Chinese patent literature CN103310659A discloses a kind of Surface parking lots parking spot Query system and querying method thereof, this system mainly comprises netscape messaging server Netscape, inquiry terminal, vehicle reader, read license plate number information by vehicle reader, and the license plate number information reading is sent to inquiry terminal, inquiry terminal is retrieved a large amount of information of vehicles data of storing in license plate number and netscape messaging server Netscape.While inquiring about license plate number each time, need send query statement and license plate number information to netscape messaging server Netscape by inquiry terminal, information server is according to the vehicle data of storing in the content search physical database of receiving.It is mutual that inquiry each time all needs the application program of inquiry terminal and netscape messaging server Netscape to carry out once, and the expense that is connected when application program is mutual with physical database is each time a problem can not be ignored.When system applies is during in Large-sized Communication bayonet socket, need to inquire about a large amount of information of vehicles data, system need constantly be inquired about physical database by network, cause larger connection expense, thereby reduce search efficiency, if network breaks down, easily caused inquiry, compare unsuccessfully.
Summary of the invention
For this reason, technical matters to be solved by this invention is that the connection expense that available technology adopting inquires about, causes while comparing data in physical database is larger, and search efficiency is low, higher to network reliability degree of dependence.Thereby propose a kind of based on memory database information of vehicles method for quickly querying and system take license plate number as querying condition.
For solving the problems of the technologies described above, the technical scheme of employing of the present invention is:
An information of vehicles method for quickly querying based on memory database, comprises the following steps:
S1: send the instruction that creates question blank, create question blank in memory database, described question blank is for recording the information of vehicles data of deploying to ensure effective monitoring and control of illegal activities;
S2: the information of vehicles of deploying to ensure effective monitoring and control of illegal activities of inquiry physical data library storage, and the information of vehicles data of deploying to ensure effective monitoring and control of illegal activities described in transferring are inserted described question blank storage in memory database;
S3: receive vehicle license plate information record that Real-time Obtaining arrives;
S4: according to the license board information getting, retrieve described question blank, inquire about deploy to ensure effective monitoring and control of illegal activities information of vehicles output corresponding with license board information in described question blank.
In described step S1, in memory database, create question blank and further comprise:
Create accurate question blank: described in deploy to ensure effective monitoring and control of illegal activities and include the correspondence complete license plate number of vehicle of deploying to ensure effective monitoring and control of illegal activities in information of vehicles;
Create fuzzy query table: described in deploy to ensure effective monitoring and control of illegal activities and include the part license plate number of the corresponding vehicle of deploying to ensure effective monitoring and control of illegal activities in information of vehicles.
Described in the information of vehicles of deploying to ensure effective monitoring and control of illegal activities described in described fuzzy query table also comprises, deploy to ensure effective monitoring and control of illegal activities vehicle car plate length and described in the deploy to ensure effective monitoring and control of illegal activities car plate color of vehicle, and all storages separately of each license plate number in license plate number.
Deploy to ensure effective monitoring and control of illegal activities described in the information of vehicles of deploying to ensure effective monitoring and control of illegal activities described in described accurate question blank also the comprises car plate color of vehicle.
In step S4, also comprise first the license plate number in the license board information getting is inquired about in described accurate question blank, if inquire record, whether the color of the car plate that then judgement gets is corresponding with the color of the described vehicle license plate of deploying to ensure effective monitoring and control of illegal activities, if correspondence is exported Query Result; If inquiry, less than record, is then inquired about the step of fuzzy query table.
In the step of inquiry fuzzy query table, further comprising the steps of:
The step that the length of the car plate getting and the length of the vehicle license plate of deploying to ensure effective monitoring and control of illegal activities are compared;
By the car plate color getting with described in the step that the car plate color of vehicle compares of deploying to ensure effective monitoring and control of illegal activities;
The step that the license plate number of correspondence position in the car plate getting and the license plate number of the vehicle correspondence position of deploying to ensure effective monitoring and control of illegal activities are compared;
Compare in any step the step that stops inquiring about fuzzy query table when inconsistent.
An information of vehicles quick reference system based on memory database, comprises with lower module:
Instruction transmission and creation module: send the instruction that creates question blank, create question blank in memory database, described question blank is for recording the information of vehicles data of deploying to ensure effective monitoring and control of illegal activities;
Data query and insert module: the information of vehicles of deploying to ensure effective monitoring and control of illegal activities of inquiry physical data library storage, and the information of vehicles data of deploying to ensure effective monitoring and control of illegal activities described in transferring are inserted described question blank storage in memory database;
License board information acquisition module: receive vehicle license plate information record that Real-time Obtaining arrives;
Inquiry and output module: according to the license board information getting, retrieve described question blank, inquire about deploy to ensure effective monitoring and control of illegal activities information of vehicles corresponding deploy to ensure effective monitoring and control of illegal activities information of vehicles and the positional information of output corresponding with license board information in described question blank.
Described question blank further comprises:
(1) accurate question blank: described in deploy to ensure effective monitoring and control of illegal activities and include the correspondence complete license plate number of vehicle of deploying to ensure effective monitoring and control of illegal activities in information of vehicles;
(2) fuzzy query table: described in deploy to ensure effective monitoring and control of illegal activities and include the part license plate number of the corresponding vehicle of deploying to ensure effective monitoring and control of illegal activities in information of vehicles.
Described in the information of vehicles of deploying to ensure effective monitoring and control of illegal activities described in described fuzzy query table also comprises, deploy to ensure effective monitoring and control of illegal activities vehicle car plate length and described in the deploy to ensure effective monitoring and control of illegal activities car plate color of vehicle, and all storages separately of each numeral in license plate number.
Deploy to ensure effective monitoring and control of illegal activities described in the information of vehicles of deploying to ensure effective monitoring and control of illegal activities described in described accurate question blank also the comprises car plate color of vehicle.
In described inquiry and output module, also comprise first the license plate number in the license board information getting is inquired about in described accurate question blank, if inquire record, whether the color of the car plate that then judgement gets is corresponding with the color of the described vehicle license plate of deploying to ensure effective monitoring and control of illegal activities, if correspondence is exported Query Result; If inquiry, less than record, is then inquired about fuzzy query table.
Described inquiry and output module, in the process of the described fuzzy query table of inquiry, also comprise:
The length of the car plate getting and the length of the vehicle license plate of deploying to ensure effective monitoring and control of illegal activities are compared;
By the car plate color getting with described in the deploy to ensure effective monitoring and control of illegal activities car plate color of vehicle compare;
The license plate number of correspondence position in the car plate getting and the license plate number of the vehicle correspondence position of deploying to ensure effective monitoring and control of illegal activities are compared;
Compare and stop inquiring about fuzzy query table when inconsistent in any step.
Technique scheme of the present invention has the following advantages compared to existing technology:
1. information of vehicles method for quickly querying and the system based on memory database, by create the question blank for recording information of vehicles data in memory database, can replace traditional physical database, the all functions of memory database are all in logic, can reduce unnecessary and interactive operation physical equipment, and support can significantly improve traffic efficiency by large data query.By transferring the information of vehicles of deploying to ensure effective monitoring and control of illegal activities, and insert in described question blank, to the inquiry of vehicle, only need be by obtaining license plate number data and inquiring about, compare with the internal storage data being stored in internal memory.Can rely on network and inquire about the information of vehicles of deploying to ensure effective monitoring and control of illegal activities, reduce the requirement to network reliability.
2. the question blank of the information of vehicles method for quickly querying based on memory database and system comprises accurate question blank and a fuzzy query table, and accurately question blank can inquire information of vehicles data accurately by license plate number data accurately.Fuzzy query table, stores fuzzy query conditions, only need can inquire the information of vehicles data of deploying to ensure effective monitoring and control of illegal activities by part license plate number coupling, improves search efficiency.
3. the fuzzy query table of an information of vehicles method for quickly querying based on memory database and system has deploy to ensure effective monitoring and control of illegal activities described in having each license plate number information of vehicle of independent storage space corresponding stored, can realize by the inquiry of selected part license plate number and can obtain the information of vehicles data of deploying to ensure effective monitoring and control of illegal activities, by storage deploy to ensure effective monitoring and control of illegal activities license plate number length and the license plate number color of vehicle, improve the accuracy of inquiry by increasing querying condition.
4. the accurate question blank of the information of vehicles method for quickly querying based on memory database and the system car plate color for car plate of deploying to ensure effective monitoring and control of illegal activities described in also including, improves the accuracy of inquiry by increasing this querying condition of car plate color.
5. information of vehicles method for quickly querying and the system based on memory database first inquired about accurate question blank, in accurate question blank, inquire about by accurate license plate number and car plate color, can realize the accurate inquiry of the vehicle of deploying to ensure effective monitoring and control of illegal activities, if accurately question blank inquiry is then inquired about fuzzy query table less than record, avoid inquiry to occur omitting.
6. information of vehicles method for quickly querying and the system based on memory database, in fuzzy query step, the license plate number length that gets of judgement with described in the deploy to ensure effective monitoring and control of illegal activities car plate length of vehicle whether consistent, can filter the license board information of license plate number length violation, whether the car plate color of judgement the car plate color getting and the vehicle of deploying to ensure effective monitoring and control of illegal activities is consistent, can filter the license board information that car plate color is not inconsistent, selected part license plate number is as querying condition, comparison by part license plate number can realize fuzzy query, improves efficiency and the precision of inquiry.
Accompanying drawing explanation
For content of the present invention is more likely to be clearly understood, below according to a particular embodiment of the invention and by reference to the accompanying drawings, the present invention is further detailed explanation, wherein
Fig. 1 is the process flow diagram of a kind of information of vehicles method for quickly querying based on memory database of one embodiment of the invention;
Fig. 2 is the structural representation of a kind of information of vehicles quick reference system based on memory database of one embodiment of the invention.
In figure, Reference numeral is expressed as: 1-memory database; 2-instruction transmission and creation module; 3-data query and insert module; 4-physical database; 5-inquiry and output module; 6-license board information acquisition module.
Embodiment
Embodiment 1
As shown in Figure 1, as one embodiment of the present of invention, a kind of information of vehicles method for quickly querying based on memory database, comprises the following steps:
S1: send the instruction that creates question blank, create question blank in memory database, described question blank is for recording the information of vehicles data of deploying to ensure effective monitoring and control of illegal activities.Described memory database can be SQLite memory database.
S2: the information of vehicles of deploying to ensure effective monitoring and control of illegal activities of inquiry physical data library storage, and the information of vehicles data of deploying to ensure effective monitoring and control of illegal activities described in transferring are inserted described question blank storage in memory database.The information of vehicles of deploying to ensure effective monitoring and control of illegal activities can be vehicle crime information, vehicle entitlement information, vehicle model etc.The described information of vehicles of deploying to ensure effective monitoring and control of illegal activities also can be classified by following classification:
(1) franchise information of vehicles data, for recording license plate number and the information of vehicles data with the franchise vehicle that travels;
(2) the information of vehicles data that are suspected of committing a crime, for recording license plate number and the information of vehicles data of the vehicle being suspected of committing a crime
S3: receive vehicle license plate information record that Real-time Obtaining arrives.License board information comprises license plate number, car plate color etc.Obtain vehicle license plate information, the position at the vehicle place that simultaneously also can get according to the license board information acquisition device being arranged on road.
S4: according to the license board information getting, retrieve described question blank, inquire about the information of vehicles of deploying to ensure effective monitoring and control of illegal activities corresponding with license board information in described question blank and also export the positional information at corresponding deploy to ensure effective monitoring and control of illegal activities information of vehicles and vehicle place.And can by the license board information data of obtaining by inquiry deploy to ensure effective monitoring and control of illegal activities information of vehicles data result generate:
(1) white list: inquire about this license plate number no record;
(2) Red List: inquire this car plate and relate to and belong to franchise vehicle;
(3) blacklist: inquire this license plate number and relate to suspicion of crime record
Described a kind of information of vehicles method for quickly querying based on memory database, can reduce unnecessary and interactive operation physical equipment according to above-mentioned steps, and support can significantly improve traffic efficiency by large data query.By transferring the information of vehicles of deploying to ensure effective monitoring and control of illegal activities, and insert in described question blank, to the inquiry of vehicle, only need be by obtaining license plate number data and inquiring about, compare with the internal storage data being stored in internal memory.Can rely on network and inquire about the information of vehicles of deploying to ensure effective monitoring and control of illegal activities, reduce the requirement to network reliability.
As one embodiment of the present of invention, on the basis of above-described embodiment 1, in described step S1, in memory database, create question blank and further comprise:
Create accurate question blank: described in deploy to ensure effective monitoring and control of illegal activities and include the correspondence complete license plate number of vehicle of deploying to ensure effective monitoring and control of illegal activities in information of vehicles;
Create fuzzy query table: described in deploy to ensure effective monitoring and control of illegal activities and include the part license plate number of the corresponding vehicle of deploying to ensure effective monitoring and control of illegal activities in information of vehicles.For example license plate number is " 123456 ", only needs to meet " 123 " and can inquire the deploy to ensure effective monitoring and control of illegal activities information of vehicles of license plate number for " 123456 ".
The fuzzy query table of other querying condition also can be set as required, realize equally object of the present invention.
Described a kind of information of vehicles method for quickly querying based on memory database, accurately question blank can inquire information of vehicles data accurately by license plate number data accurately.Fuzzy query table, stores fuzzy query conditions, only need can inquire the information of vehicles data of deploying to ensure effective monitoring and control of illegal activities by part license plate number coupling, improves search efficiency.
As one embodiment of the present of invention on the basis of above-described embodiment 2, described in also comprising, the information of vehicles of deploying to ensure effective monitoring and control of illegal activities described in described fuzzy query table deploys to ensure effective monitoring and control of illegal activities the car plate length of vehicle (if " capital A123456 " length is exactly 8, some franchise vehicle license plate figure place and conventional license plate number are inconsistent) and described in the deploy to ensure effective monitoring and control of illegal activities car plate color (for example domestic have blue car plate, yellow car plate, black car plate and part special license plate) of vehicle, and all storages separately of each numeral in license plate number.For example " capital A123456 " being split into 8 independent data " capital ", " A ", " 1 ", " 2 ", " 3 ", " 4 ", " 5 ", " 6 " stores.Also the modes such as " capital A ", " 1 ", " 2 ", " 3 ", " 4 ", " 5 ", " 6 " that may be split into are stored and are realized equally object of the present invention.
The fuzzy query table of described a kind of information of vehicles method for quickly querying based on memory database has deploy to ensure effective monitoring and control of illegal activities described in having each license plate number information of vehicle of independent storage space corresponding stored, can realize by the inquiry of selected part license plate number and can obtain the information of vehicles data of deploying to ensure effective monitoring and control of illegal activities, by storage deploy to ensure effective monitoring and control of illegal activities license plate number length and the license plate number color of vehicle, improve the accuracy of inquiry by increasing querying condition.
As one embodiment of the present of invention, on the basis of above-described embodiment 2, the car plate color of the vehicle of deploying to ensure effective monitoring and control of illegal activities described in the information of vehicles of deploying to ensure effective monitoring and control of illegal activities described in described accurate question blank also comprises.
Deploy to ensure effective monitoring and control of illegal activities described in the accurate question blank of described a kind of information of vehicles method for quickly querying based on memory database also the includes car plate color of car plate, improves the accuracy of inquiry by increasing this querying condition of car plate color.
As one embodiment of the present of invention, on the basis of the arbitrary embodiment of above-mentioned 2-4, in step S4, also comprise first the license plate number in the license board information getting is inquired about in described accurate question blank, if inquire record, whether the color of the car plate that then judgement gets is corresponding with the color of the described vehicle license plate of deploying to ensure effective monitoring and control of illegal activities, whether the color that the car plate that gets of judgement is set from the reason of corresponding this step of color of the described vehicle license plate of deploying to ensure effective monitoring and control of illegal activities is: car plate exists the identical and situation that color is different of license plate number, for example: blue car plate " capital A12456 " is private car, yellow car plate " capital A123456 " may be the motor bus of operation.If correspondence is exported Query Result; If inquiry, less than record, is then inquired about the step of fuzzy query table.
Described a kind of information of vehicles method for quickly querying based on memory database is first inquired about accurate question blank, in accurate question blank, inquire about by accurate license plate number and car plate color, can realize the accurate inquiry of the vehicle of deploying to ensure effective monitoring and control of illegal activities, if accurately question blank inquiry is then inquired about fuzzy query table less than record, avoid inquiry to occur omitting.
As one embodiment of the present of invention, on the basis of the arbitrary embodiment of above-mentioned 1-5, in the step of inquiry fuzzy query table, further comprising the steps of:
The step that the length of the car plate getting and the length of the vehicle license plate of deploying to ensure effective monitoring and control of illegal activities are compared.
By the car plate color getting with described in the step that the car plate color of vehicle compares of deploying to ensure effective monitoring and control of illegal activities.
The step that the license plate number of correspondence position in the car plate getting and the license plate number of the vehicle correspondence position of deploying to ensure effective monitoring and control of illegal activities are compared.
Compare in any step the step that stops inquiring about fuzzy query table when inconsistent.
Take the vehicle license plate of deploying to ensure effective monitoring and control of illegal activities as blueness and license plate number are as " capital A123456 " is as example, the length of the car plate getting is 8, meet length comparison result, the car plate color getting is for blue, meet, first four of the license plate number getting is " capital A123 " (car plate may be " capital A123657 "), if only need the car of inquiry " capital A123 " number section, the license plate number license plate number corresponding with the vehicle of deploying to ensure effective monitoring and control of illegal activities of the license plate number correspondence position getting conforms to, and can identify the vehicle that gets license plate number and belong to the vehicle of deploying to ensure effective monitoring and control of illegal activities.
Described a kind of information of vehicles method for quickly querying based on memory database is in above-mentioned steps, the license plate number length that gets of judgement with described in the deploy to ensure effective monitoring and control of illegal activities car plate length of vehicle whether consistent, can filter the license board information of license plate number length violation, whether the car plate color of judgement the car plate color getting and the vehicle of deploying to ensure effective monitoring and control of illegal activities is consistent, can filter the license board information that car plate color is not inconsistent, selected part license plate number is as querying condition, comparison by part license plate number can realize fuzzy query, improves efficiency and the precision of inquiry.
Embodiment 7
As shown in Figure 2, as one embodiment of the present of invention, a kind of information of vehicles quick reference system based on memory database, comprises with lower module:
Instruction transmission and creation module 2: send the instruction that creates question blank, in memory database 1, create question blank, described question blank is for recording the information of vehicles data of deploying to ensure effective monitoring and control of illegal activities.Described memory database can be SQLite memory database.
Data query and insert module 3: the information of vehicles of deploying to ensure effective monitoring and control of illegal activities that inquiry physical database 4 is stored, and the information of vehicles data of deploying to ensure effective monitoring and control of illegal activities described in transferring are inserted described question blank storage in memory database 1.The information of vehicles of deploying to ensure effective monitoring and control of illegal activities can be vehicle crime information, vehicle entitlement information, vehicle model etc.The described information of vehicles of deploying to ensure effective monitoring and control of illegal activities also can be classified by following classification:
(1) franchise information of vehicles data, for recording license plate number and the information of vehicles data with the franchise vehicle that travels;
(2) the information of vehicles data that are suspected of committing a crime, for recording license plate number and the information of vehicles data of the vehicle being suspected of committing a crime
License board information acquisition module 6: receive vehicle license plate information record that Real-time Obtaining arrives.License board information comprises license plate number, car plate color etc.Obtain vehicle license plate information, the position at the vehicle place that simultaneously also can get according to the license board information acquisition device being arranged on road.
Inquiry and output module 5: according to the license board information getting, retrieve described question blank, inquire about corresponding with the license board information information of vehicles export the positional information of corresponding deploy to ensure effective monitoring and control of illegal activities information of vehicles and vehicle of deploying to ensure effective monitoring and control of illegal activities in described question blank.And can by the license board information data of obtaining by inquiry deploy to ensure effective monitoring and control of illegal activities information of vehicles data result generate:
(1) white list: inquire about this license plate number no record;
(2) Red List: inquire this car plate and relate to and belong to franchise vehicle;
(3) blacklist: inquire this license plate number and relate to suspicion of crime record
Described a kind of information of vehicles quick reference system based on memory database, can reduce unnecessary and interactive operation physical equipment according to above-mentioned steps, and support can significantly improve traffic efficiency by large data query.By transferring the information of vehicles of deploying to ensure effective monitoring and control of illegal activities, and insert in described question blank, to the inquiry of vehicle, only need be by obtaining license plate number data and inquiring about, compare with the internal storage data being stored in internal memory.Can rely on network and inquire about the information of vehicles of deploying to ensure effective monitoring and control of illegal activities, reduce the requirement to network reliability.
Embodiment 8
As one embodiment of the present of invention, on the basis of above-described embodiment 7, described question blank further comprises:
(1) accurate question blank: described in deploy to ensure effective monitoring and control of illegal activities and include the correspondence complete license plate number of vehicle of deploying to ensure effective monitoring and control of illegal activities in information of vehicles;
(2) fuzzy query table: described in deploy to ensure effective monitoring and control of illegal activities and include the part license plate number of the corresponding vehicle of deploying to ensure effective monitoring and control of illegal activities in information of vehicles.For example license plate number is " 123456 ", only needs to meet " 123 " and can inquire the deploy to ensure effective monitoring and control of illegal activities information of vehicles of license plate number for " 123456 ".
The fuzzy query table of other querying condition also can be set as required, realize equally object of the present invention.
Described a kind of information of vehicles quick reference system based on memory database, accurately question blank can inquire information of vehicles data accurately by license plate number data accurately.Fuzzy query table, stores fuzzy query conditions, only need can inquire the information of vehicles data of deploying to ensure effective monitoring and control of illegal activities by part license plate number coupling, improves search efficiency.
Embodiment 9
As one embodiment of the present of invention, on the basis of above-described embodiment 8, described in also comprising, the information of vehicles of deploying to ensure effective monitoring and control of illegal activities described in described fuzzy query table deploys to ensure effective monitoring and control of illegal activities the car plate length of vehicle (if " capital A123456 " length is exactly 8, some franchise vehicle license plate figure place and conventional license plate number are inconsistent) and described in the deploy to ensure effective monitoring and control of illegal activities car plate color (for example domestic have blue car plate, yellow car plate, black car plate and part special license plate) of vehicle, and all storages separately of each numeral in license plate number.For example " capital A123456 " being split into 8 independent data " capital ", " A ", " 1 ", " 2 ", " 3 ", " 4 ", " 5 ", " 6 " stores.Also the modes such as " capital A ", " 1 ", " 2 ", " 3 ", " 4 ", " 5 ", " 6 " that may be split into are stored and are realized equally object of the present invention.
The fuzzy query table of described a kind of information of vehicles quick reference system based on memory database has deploy to ensure effective monitoring and control of illegal activities described in having each license plate number information of vehicle of independent storage space corresponding stored, can realize by the inquiry of selected part license plate number and can obtain the information of vehicles data of deploying to ensure effective monitoring and control of illegal activities, by storage deploy to ensure effective monitoring and control of illegal activities license plate number length and the license plate number color of vehicle, improve the accuracy of inquiry by increasing querying condition.
Embodiment 10
As one embodiment of the present of invention, on the basis of above-described embodiment 8, the car plate color of the vehicle of deploying to ensure effective monitoring and control of illegal activities described in the information of vehicles of deploying to ensure effective monitoring and control of illegal activities described in described accurate question blank also comprises.
Deploy to ensure effective monitoring and control of illegal activities described in the accurate question blank of described a kind of information of vehicles quick reference system based on memory database also the includes car plate color of car plate, improves the accuracy of inquiry by increasing this querying condition of car plate color.
Embodiment 11
As one embodiment of the present of invention, on the basis of the arbitrary embodiment of above-mentioned 7-10, in described inquiry and output module 5, also comprise first the license plate number in the license board information getting is inquired about in described accurate question blank, if inquire record, whether the color of the car plate that then judgement gets is corresponding with the color of the described vehicle license plate of deploying to ensure effective monitoring and control of illegal activities, whether the color that the car plate that gets of judgement is set from the reason of corresponding this step of color of the described vehicle license plate of deploying to ensure effective monitoring and control of illegal activities is: car plate exists the identical and situation that color is different of license plate number, for example: blue car plate " capital A12456 " is private car, yellow car plate " capital A123456 " may be the motor bus of operation.If correspondence is exported Query Result; If inquiry, less than record, is then inquired about the step of fuzzy query table.
Described a kind of information of vehicles quick reference system based on memory database is first inquired about accurate question blank, in accurate question blank, inquire about by accurate license plate number and car plate color, can realize the accurate inquiry of the vehicle of deploying to ensure effective monitoring and control of illegal activities, if accurately question blank inquiry is then inquired about fuzzy query table less than record, avoid inquiry to occur omitting.
Embodiment 12
As one embodiment of the present of invention, on the basis of the arbitrary embodiment of above-mentioned 7-11, described inquiry and output module 5, in the process of the described fuzzy query table of inquiry, also comprise:
The length of the car plate getting and the length of the vehicle license plate of deploying to ensure effective monitoring and control of illegal activities are compared.
By the car plate color getting with described in the deploy to ensure effective monitoring and control of illegal activities car plate color of vehicle compare.
The license plate number of correspondence position in the car plate getting and the license plate number of the vehicle correspondence position of deploying to ensure effective monitoring and control of illegal activities are compared.
Compare in any step the step that stops inquiring about fuzzy query table when inconsistent.
Take the vehicle license plate of deploying to ensure effective monitoring and control of illegal activities as blueness and license plate number are as " capital A123456 " is as example, the length of the car plate getting is 8, meet length comparison result, the car plate color getting is for blue, meet, first four of the license plate number getting is " capital A123 " (car plate may be " capital A123657 "), if only need the car of inquiry " capital A123 " number section, the license plate number license plate number corresponding with the vehicle of deploying to ensure effective monitoring and control of illegal activities of the license plate number correspondence position getting conforms to, and can identify the vehicle that gets license plate number and belong to the vehicle of deploying to ensure effective monitoring and control of illegal activities.
Described a kind of information of vehicles quick reference system based on memory database is in above-mentioned comparison, the license plate number length that gets of judgement with described in the deploy to ensure effective monitoring and control of illegal activities car plate length of vehicle whether consistent, can filter the license board information of license plate number length violation, whether the car plate color of judgement the car plate color getting and the vehicle of deploying to ensure effective monitoring and control of illegal activities is consistent, can filter the license board information that car plate color is not inconsistent, selected part license plate number is as querying condition, comparison by part license plate number can realize fuzzy query, improves efficiency and the precision of inquiry.
Obviously, above-described embodiment is only for example is clearly described, and the not restriction to embodiment.For those of ordinary skill in the field, can also make other changes in different forms on the basis of the above description.Here without also giving exhaustive to all embodiments.And the apparent variation of being extended out thus or variation are still among the protection domain in the invention.
Claims (12)
1. the information of vehicles method for quickly querying based on memory database, is characterized in that, comprises the following steps:
S1: send the instruction that creates question blank, create question blank in memory database, described question blank is for recording the information of vehicles data of deploying to ensure effective monitoring and control of illegal activities;
S2: the information of vehicles of deploying to ensure effective monitoring and control of illegal activities of inquiry physical data library storage, and the information of vehicles data of deploying to ensure effective monitoring and control of illegal activities described in transferring are inserted described question blank storage in memory database;
S3: receive vehicle license plate information record that Real-time Obtaining arrives;
S4: according to the license board information getting, retrieve described question blank, inquire about deploy to ensure effective monitoring and control of illegal activities information of vehicles corresponding deploy to ensure effective monitoring and control of illegal activities information of vehicles and the positional information of output corresponding with license board information in described question blank.
2. a kind of information of vehicles method for quickly querying based on memory database according to claim 1, is characterized in that, in described step S1, creates question blank and further comprise in memory database:
Create accurate question blank: described in deploy to ensure effective monitoring and control of illegal activities and include the correspondence complete license plate number of vehicle of deploying to ensure effective monitoring and control of illegal activities in information of vehicles;
Create fuzzy query table: described in deploy to ensure effective monitoring and control of illegal activities and include the part license plate number of the corresponding vehicle of deploying to ensure effective monitoring and control of illegal activities in information of vehicles.
3. a kind of information of vehicles method for quickly querying based on memory database according to claim 2, it is characterized in that, described in the information of vehicles of deploying to ensure effective monitoring and control of illegal activities described in described fuzzy query table also comprises, deploy to ensure effective monitoring and control of illegal activities vehicle car plate length and described in the deploy to ensure effective monitoring and control of illegal activities car plate color of vehicle, and all storages separately of each license plate number in license plate number.
4. a kind of information of vehicles method for quickly querying based on memory database according to claim 2, is characterized in that, the car plate color of the vehicle of deploying to ensure effective monitoring and control of illegal activities described in the information of vehicles of deploying to ensure effective monitoring and control of illegal activities described in described accurate question blank also comprises.
5. according to the arbitrary described a kind of information of vehicles method for quickly querying based on memory database of claim 2-4, it is characterized in that, in step S4, also comprise first the license plate number in the license board information getting is inquired about in described accurate question blank, if inquire record, whether the color of the car plate that then judgement gets is corresponding with the color of the described vehicle license plate of deploying to ensure effective monitoring and control of illegal activities, if correspondence is exported Query Result; If inquiry, less than record, is then inquired about the step of fuzzy query table.
6. according to the arbitrary described a kind of information of vehicles method for quickly querying based on memory database of claim 1-5, it is characterized in that, in the step of inquiry fuzzy query table, further comprising the steps of:
The step that the length of the car plate getting and the length of the vehicle license plate of deploying to ensure effective monitoring and control of illegal activities are compared;
By the car plate color getting with described in the step that the car plate color of vehicle compares of deploying to ensure effective monitoring and control of illegal activities;
The step that the license plate number of correspondence position in the car plate getting and the license plate number of the vehicle correspondence position of deploying to ensure effective monitoring and control of illegal activities are compared;
Compare in any step the step that stops inquiring about fuzzy query table when inconsistent.
7. the information of vehicles quick reference system based on memory database, is characterized in that, comprises with lower module:
Instruction transmission and creation module: send the instruction that creates question blank, create question blank in memory database, described question blank is for recording the information of vehicles data of deploying to ensure effective monitoring and control of illegal activities;
Data query and insert module: the information of vehicles of deploying to ensure effective monitoring and control of illegal activities of inquiry physical data library storage, and the information of vehicles data of deploying to ensure effective monitoring and control of illegal activities described in transferring are inserted described question blank storage in memory database;
License board information acquisition module: receive vehicle license plate information record that Real-time Obtaining arrives;
Inquiry and output module: according to the license board information getting, retrieve described question blank, inquire about deploy to ensure effective monitoring and control of illegal activities information of vehicles corresponding deploy to ensure effective monitoring and control of illegal activities information of vehicles and the positional information of output corresponding with license board information in described question blank.
8. a kind of information of vehicles quick reference system based on memory database according to claim 7, is characterized in that, described question blank further comprises:
(1) accurate question blank: described in deploy to ensure effective monitoring and control of illegal activities and include the correspondence complete license plate number of vehicle of deploying to ensure effective monitoring and control of illegal activities in information of vehicles;
(2) fuzzy query table: described in deploy to ensure effective monitoring and control of illegal activities and include the part license plate number of the corresponding vehicle of deploying to ensure effective monitoring and control of illegal activities in information of vehicles.
9. a kind of information of vehicles quick reference system based on memory database according to claim 8, it is characterized in that, described in the information of vehicles of deploying to ensure effective monitoring and control of illegal activities described in described fuzzy query table also comprises, deploy to ensure effective monitoring and control of illegal activities vehicle car plate length and described in the deploy to ensure effective monitoring and control of illegal activities car plate color of vehicle, and all storages separately of each license plate number in license plate number.
10. a kind of information of vehicles method for quickly querying based on memory database according to claim 8, is characterized in that, the car plate color of the vehicle of deploying to ensure effective monitoring and control of illegal activities described in the information of vehicles of deploying to ensure effective monitoring and control of illegal activities described in described accurate question blank also comprises.
11. according to Claim 8-10 arbitrary described a kind of information of vehicles method for quickly querying based on memory database, it is characterized in that, in described inquiry and output module, also comprise first the license plate number in the license board information getting is inquired about in described accurate question blank, if inquire record, whether the color of the car plate that then judgement gets is corresponding with the color of the described vehicle license plate of deploying to ensure effective monitoring and control of illegal activities, if correspondence is exported Query Result; If inquiry, less than record, is then inquired about fuzzy query table.
12. according to the arbitrary described a kind of information of vehicles quick reference system based on memory database of claim 7-11, it is characterized in that, described inquiry and output module, in the process of the described fuzzy query table of inquiry, also comprise:
The length of the car plate getting and the length of the vehicle license plate of deploying to ensure effective monitoring and control of illegal activities are compared;
By the car plate color getting with described in the deploy to ensure effective monitoring and control of illegal activities car plate color of vehicle compare;
The license plate number of correspondence position in the car plate getting and the license plate number of the vehicle correspondence position of deploying to ensure effective monitoring and control of illegal activities are compared;
Compare and stop inquiring about fuzzy query table when inconsistent in any step.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410083611.7A CN103810298A (en) | 2014-03-07 | 2014-03-07 | Main memory database based rapid vehicle information query method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410083611.7A CN103810298A (en) | 2014-03-07 | 2014-03-07 | Main memory database based rapid vehicle information query method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103810298A true CN103810298A (en) | 2014-05-21 |
Family
ID=50707068
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410083611.7A Pending CN103810298A (en) | 2014-03-07 | 2014-03-07 | Main memory database based rapid vehicle information query method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103810298A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107590628A (en) * | 2017-09-04 | 2018-01-16 | 北京汽车股份有限公司 | The querying method and system of stock's vehicle |
| CN108965759A (en) * | 2018-08-21 | 2018-12-07 | 王俊利 | Comprehensive law enforcement records system |
| CN110716929A (en) * | 2018-07-13 | 2020-01-21 | 杭州海康威视系统技术有限公司 | Control and deployment processing method, device and equipment |
| CN110930707A (en) * | 2019-12-03 | 2020-03-27 | 浙江中核信息科技有限公司 | Non-motor vehicle traffic violation supervision system and supervision method |
| CN111275984A (en) * | 2020-02-20 | 2020-06-12 | 三一重工股份有限公司 | Vehicle detection method and device and server |
| CN112084207A (en) * | 2020-09-23 | 2020-12-15 | 南京感动科技有限公司 | Road network vehicle real-time query speed optimization method |
| CN114038205A (en) * | 2021-10-28 | 2022-02-11 | 浙江大华技术股份有限公司 | Vehicle management method for parking lot, computer device and storage device |
-
2014
- 2014-03-07 CN CN201410083611.7A patent/CN103810298A/en active Pending
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107590628A (en) * | 2017-09-04 | 2018-01-16 | 北京汽车股份有限公司 | The querying method and system of stock's vehicle |
| CN110716929A (en) * | 2018-07-13 | 2020-01-21 | 杭州海康威视系统技术有限公司 | Control and deployment processing method, device and equipment |
| CN110716929B (en) * | 2018-07-13 | 2023-01-24 | 杭州海康威视系统技术有限公司 | Control and deployment processing method, device and equipment |
| CN108965759A (en) * | 2018-08-21 | 2018-12-07 | 王俊利 | Comprehensive law enforcement records system |
| CN110930707A (en) * | 2019-12-03 | 2020-03-27 | 浙江中核信息科技有限公司 | Non-motor vehicle traffic violation supervision system and supervision method |
| CN111275984A (en) * | 2020-02-20 | 2020-06-12 | 三一重工股份有限公司 | Vehicle detection method and device and server |
| CN111275984B (en) * | 2020-02-20 | 2022-04-15 | 三一重工股份有限公司 | Vehicle detection method and device and server |
| CN112084207A (en) * | 2020-09-23 | 2020-12-15 | 南京感动科技有限公司 | Road network vehicle real-time query speed optimization method |
| CN112084207B (en) * | 2020-09-23 | 2022-04-29 | 南京感动科技有限公司 | Road network vehicle real-time query speed optimization method |
| CN114038205A (en) * | 2021-10-28 | 2022-02-11 | 浙江大华技术股份有限公司 | Vehicle management method for parking lot, computer device and storage device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103810298A (en) | Main memory database based rapid vehicle information query method and system | |
| CN103745600B (en) | The implementation method of a kind of radio-frequency (RF) identification and Car license recognition comparison | |
| CN103400500B (en) | Vehicle information data acquisition device and method | |
| CN103778787B (en) | Automobile false deck recognition logic determination methods | |
| CN110837807A (en) | Identification method and system for fake-licensed vehicle | |
| CN106910369B (en) | Roadside Parking management method and system | |
| CN108986530A (en) | Parking stall management method, device and computer readable storage medium | |
| CN104851315A (en) | Parking management method and system, vehicle device and server | |
| CN105678879A (en) | Visitor's vehicle management method and system | |
| CN106875697A (en) | Radio frequency identification and video identification comparison method and system | |
| CN101241644A (en) | Intelligent car license patrol system | |
| CN103544480A (en) | Vehicle color recognition method | |
| CN104408926A (en) | RFID intelligent electronic license plate identification system | |
| CN104299443A (en) | Parking lot vehicle positioning system and method based on low frequency active radio frequency identification technology | |
| CN103914682A (en) | Vehicle license plate recognition method and system | |
| CN108320503A (en) | Vehicle traveling querying method and system based on point identification | |
| CN108281029A (en) | A kind of roadside stall testing apparatus based on vehicle electron identifying | |
| CN106710225A (en) | Identification method and monitoring platform for illegal operation related with vehicle license plate | |
| CN102054358A (en) | Control system and method of electronic license plate | |
| CN102054357A (en) | Vehicle monitoring system and method based on radio frequency identification | |
| CN107146417A (en) | A kind of clone's vehicle decision method and device based on vehicle electron identifying | |
| CN103106400B (en) | A kind of method for detecting human face and device | |
| Deng | Architecture design of the vehicle tracking system based on RFID | |
| CN105448102A (en) | Electronic license plate-based intelligent vehicle inspection system and method | |
| CN103794051A (en) | Cloned vehicle detecting system and corresponding detecting method based on parking information |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20140521 |
|
| RJ01 | Rejection of invention patent application after publication |