CN109508345A - Database index querying method based on automobile VIN search - Google Patents
Database index querying method based on automobile VIN search Download PDFInfo
- Publication number
- CN109508345A CN109508345A CN201811181642.0A CN201811181642A CN109508345A CN 109508345 A CN109508345 A CN 109508345A CN 201811181642 A CN201811181642 A CN 201811181642A CN 109508345 A CN109508345 A CN 109508345A
- Authority
- CN
- China
- Prior art keywords
- vin
- index
- code
- wmi
- database
- 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
- 238000000034 method Methods 0.000 title claims abstract description 21
- 230000002776 aggregation Effects 0.000 claims abstract description 13
- 238000004220 aggregation Methods 0.000 claims abstract description 13
- 239000003016 pheromone Substances 0.000 claims abstract description 12
- 238000004458 analytical method Methods 0.000 claims abstract description 4
- 238000012545 processing Methods 0.000 claims abstract description 4
- 230000015572 biosynthetic process Effects 0.000 claims description 3
- 238000004519 manufacturing process Methods 0.000 claims description 3
- 230000000694 effects Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000032696 parturition Effects 0.000 description 1
- 230000001737 promoting effect Effects 0.000 description 1
- 238000004064 recycling Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of database index querying methods based on automobile VIN search, and this method includes following processing step: step 1: the VIN number code that analysis needs are inquired obtains the WMI number and VDS number of the VIN number code；Step 2: the WMI number of acquisition and VDS number being split as major key, then pass through relevant VIN number code in nonclustered index lock database；Step 3: will need to inquire unique corresponding position of VIN number code in step 2 in the related VIN number code that the VIN number code inquired be needed to lock by aggregat ion pheromones locking.The database index querying method of VIN can effectively be optimized through the invention, promote search speed, reduce period of reservation of number, reduce server cost.
Description
Technical field
The present invention relates to database technical field more particularly to a kind of database index inquiries based on automobile VIN search
Method.
Background technique
Vehicle identification number (Vehicle Identification Number) is also referred to as cycle serial number, and abbreviation VIN is one
Group is by 17 English arrays at unique number on automobile can identify manufacturer, the engine, chassis of automobile
The data such as serial number and other performances.Wherein, to avoid obscuring with 1, the 0 of number, English alphabet " I ", " O ", " Q " will not be made
With.GB7258-2012 regulation: " automobile, motorcycle, semitrailer and central axle trailer should have unique Vehicle Identification Number.
VIN technical standard includes different details branch, and the meaning that the coding site in each details branch represents has nuance,
VIN number code is made of three parts: WMI (manufacturer, the world identifies code name), VDS (vehicle declaratives), (vehicle refers to VIS
Show part)
The search of VIN, be widely used in vehicle it is offline after links, such as the registration of automobile, insurance, annual test, maintenance
And maintenance, until recycling or scrapping.The most common application category is the vehicle that automobile is matched by search VIN, to obtain vehicle
The spare and accessory parts for repairing this vehicle, the data such as EPC figure can be matched to after type in turn.Common VIN search database can all incite somebody to action
VIN number code is set to major key, and the database table correspondence of major key is tree, i.e. balancing tree structure, in other words, as entirely
Table has reformed into an index, that is, so-called " aggregat ion pheromones ".Only one general major key of one table, corresponds to only one
Aggregat ion pheromones, because the effect of major key is exactly that the Data Format Transform of " table " is put at the format of " aggregat ion pheromones (balanced tree) "
It sets.In existing technology, common VIN search database is that database designer establishes, in database designer's eye
In, VIN code is only common coding, and VIN number code can only be regarded as to common coding and retrieved, when encountering big number
Magnitude, search efficiency will gradually reduce when VIN number code as other such as tera-scale, and search time will greatly increase.
Summary of the invention
It is an object of the present invention to provide a kind of database index querying methods based on automobile VIN search, can effectively add
Fast search speed reduces search time.
To realize the purpose, a kind of database index querying method based on automobile VIN search is provided, this method includes
Following processing step:
Step 1: the VIN number code that analysis needs are inquired obtains the WMI number and VDS number of the VIN number code；
Step 2: the WMI number of acquisition and VDS number being split as major key, then pass through nonclustered index lock database
In relevant VIN number code；
Step 3: will be locked in the related VIN number code for needing the VIN number code inquired to lock in step 2 by aggregat ion pheromones
Need to inquire unique corresponding position of VIN number code.
Preferably, in step 2, with the 1st of No. WMI, the 2nd, the 3rd in conjunction with the 4th of No. VDS, the 5th position
As major key.
Preferably, described No. WMI the 1st is production country code, and No. WMI the 2nd is automaker's code,
No. WMI the 3rd is car category code, wherein by by the 1st of No. WMI, the 2nd, the 3rd bit combination generation in the brand of part
Code indicates the brand；The 4th of No. VDS and the 5th is respectively engine model and braking and speed changer model.
Preferably, in step 2, nonclustered index is in data base management system to the WMI number and VDS in database
Number the 4th and the 5th respectively plus index, multiple independent index structures are formed, wherein each index structure, that is, non-agglomerated
Index, there is no associations from each other.
Preferably, as soon as every formation new index structure, the data in corresponding field replicate portion and come out, for generating
Index.
Preferably, nonclustered index is all made of data structure of the balanced tree as index as aggregat ion pheromones.
Preferably, in step 3, by needing the VIS for the VIN number code inquired in the related VIN number locked in step 2
The unique corresponding position of VIN number code for needing to inquire by aggregat ion pheromones positioning in code.
Compared with prior art, the present invention the beneficial effect is that:
It is searched in the present invention by automobile VIN and professional standard, so as to effectively optimize the database index inquiry of VIN
Method promotes search speed, reduces period of reservation of number, reduces server cost.It through the invention being capable of effective guarantee search
Correctness and stability.
Detailed description of the invention
Fig. 1 is flow diagram of the invention.
Specific embodiment
Below with reference to embodiment, the invention will be further described, but does not constitute any limitation of the invention, any
In the modification for the limited times that scope of the invention as claimed is made, still in scope of the presently claimed invention.
As shown in Figure 1, a kind of database index querying method based on automobile VIN search, this method includes following processing
Step:
Step 1: the VIN number code that analysis needs are inquired obtains the WMI number and VDS number of the VIN number code；
Step 2: the WMI number of acquisition and VDS number being split as major key, then pass through nonclustered index lock database
In relevant VIN number code；
Step 3: will be locked in the related VIN number code for needing the VIN number code inquired to lock in step 2 by aggregat ion pheromones
Need to inquire unique corresponding position of VIN number code.
In step 2, it is combined as leading with the 4th of No. VDS, the 5th position with the 1st of No. WMI, the 2nd, the 3rd
Key.Described No. WMI the 1st is production country code, and No. WMI the 2nd is automaker's code, and No. WMI the 3rd is
Car category code, wherein by the way that the 1st of No. WMI, the 2nd, the 3rd bit combination code are indicated the brand in the brand of part,
That is, being combined as major key with the 4th of No. VDS, the 5th position by 3 before the brand of part.So as to form multiple major keys.
The 4th of No. VDS and the 5th is respectively engine model and braking and speed changer model.
In step 2, nonclustered index is in data base management system to the WMI number and the 4th of No. VDS the in database
Position forms multiple independent index structures respectively plus index with the 5th, wherein each index structure, that is, nonclustered index, mutually
There is no associations between phase.As soon as every formation new index structure, the data in corresponding field replicate portion and come out, for giving birth to
At index.Nonclustered index is all made of data structure of the balanced tree as index as aggregat ion pheromones.
In step 3, by needing the VIS for the VIN number code inquired to lead in the related VIN number code locked in step 2
The unique corresponding position of VIN number code that overbunching index positioning needs to inquire.
In the present embodiment, nonclustered index and aggregat ion pheromones index each node in tree construction in same database
It is worth the index field in database table.If the name name field to user user table adds index, then indexing
It is exactly made of the value in name field, when data change, DataBase management system can safeguard always index structure
Correctness.If to, plus index, just will appear multiple independent index structures, often to multiple fields in database table
There is no associations from each other for a index (nonclustered index).To pass through non-agglomerated needed for the foundation of data base management system
Index can effectively find all VIN number codes comprising corresponding major key field, so that passing through input
The VIN number yardage magnitude that VIN number code further positions substantially reduces, so that search speed greatly promotes, reduces search time.
Existing technology does not use the professional standard meaning of VIN number code, can only regard VIN number code as common
Coding is retrieved, it is assumed for example that has 100,000,000 VIN number codes, default piecemeal is assumed to be 10, decimal system classification, then level is just
It is 8 levels, thus the volume VIN number code searched for required for being inquired after 8 times.When encountering the big order of magnitude (trillion ranks)
Search efficiency will gradually reduce when VIN number code.The professional standard of VIN number code is carried out the retrieval of nonclustered index by the present invention, will
The recall precision for promoting 5-10 times or more solves the problems, such as the VIN number code of search big data quantity.
The above is only the preferred embodiment of the present invention, it should be pointed out that for those skilled in the art, is not taking off
Under the premise of from structure of the invention, several modifications and improvements can also be made, these all will not influence the effect that the present invention is implemented
And patent practicability.
Claims (7)
1. a kind of database index querying method based on automobile VIN search, which is characterized in that this method includes following processing step
It is rapid:
Step 1: the VIN number code that analysis needs are inquired obtains the WMI number and VDS number of the VIN number code；
Step 2: the WMI number of acquisition and VDS number being split as major key, then pass through phase in nonclustered index lock database
The VIN number code of pass；
Step 3: needs will be locked by aggregat ion pheromones in the related VIN number code for needing the VIN number code inquired to lock in step 2
Inquire unique corresponding position of VIN number code.
2. a kind of database index querying method based on automobile VIN search according to claim 1, which is characterized in that
In step 2, major key is combined as with the 4th of No. VDS, the 5th position with the 1st of No. WMI, the 2nd, the 3rd.
3. a kind of database index querying method based on automobile VIN search according to claim 2, which is characterized in that
Described No. WMI the 1st is production country code, and No. WMI the 2nd is automaker's code, and No. WMI the 3rd is vapour
Vehicle type code, wherein by the way that the 1st of No. WMI, the 2nd, the 3rd bit combination code are indicated the brand in the brand of part；
The 4th of No. VDS and the 5th is respectively engine model and braking and speed changer model.
4. a kind of database index querying method based on automobile VIN search according to claim 2, which is characterized in that
In step 2, nonclustered index be data base management system in database WMI number with the 4th and the 5th of No. VDS
Position plus index, forms multiple independent index structures respectively, wherein each index structure, that is, nonclustered index, from each other not
There are associations.
5. a kind of database index querying method based on automobile VIN search according to claim 4, which is characterized in that
As soon as every formation new index structure, the data in corresponding field replicate portion and come out, for generating index.
6. a kind of database index querying method based on automobile VIN search according to claim 1 or 2 or 4, feature
It is, nonclustered index is all made of data structure of the balanced tree as index as aggregat ion pheromones.
7. a kind of database index querying method based on automobile VIN search according to claim 1, which is characterized in that
In step 3, by needing the VIS for the VIN number code inquired in the related VIN number code locked in step 2 by aggregation rope
Draw the unique corresponding position of VIN number code that positioning needs to inquire.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811181642.0A CN109508345A (en) | 2018-10-11 | 2018-10-11 | Database index querying method based on automobile VIN search |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811181642.0A CN109508345A (en) | 2018-10-11 | 2018-10-11 | Database index querying method based on automobile VIN search |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109508345A true CN109508345A (en) | 2019-03-22 |
Family
ID=65746486
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811181642.0A Pending CN109508345A (en) | 2018-10-11 | 2018-10-11 | Database index querying method based on automobile VIN search |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109508345A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110147371A (en) * | 2019-05-15 | 2019-08-20 | 北京信息科技大学 | A kind of Vehicle Identification Number management method |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120041968A1 (en) * | 2010-08-10 | 2012-02-16 | Zak Jr Kenneth R | Vehicle identification number decoder |
| CN102930000A (en) * | 2012-10-26 | 2013-02-13 | 马涛 | System and method for carrying out searching match on automobile component products by using VIN (Vehicle Identification Number) |
| CN103049498A (en) * | 2012-12-07 | 2013-04-17 | 王志欣 | Method for recognizing vehicle type through vehicle identification number (VIN) |
| CN105786886A (en) * | 2014-12-25 | 2016-07-20 | 上海通用汽车有限公司 | Vehicle maintenance directory system |
| CN106095785A (en) * | 2016-05-27 | 2016-11-09 | 大连楼兰科技股份有限公司 | DTC based on decision tree classification diagnosis vehicle work item and spare part search method |
| CN107491776A (en) * | 2017-07-04 | 2017-12-19 | 江苏迪纳数字科技股份有限公司 | The method and device configured by passenger car VIN code automatic identifications vehicle |
| CN107491777A (en) * | 2017-07-04 | 2017-12-19 | 江苏迪纳数字科技股份有限公司 | The method and device whether matched by passenger car VIN code automatic identification OBD vehicle devices |
| CN107590178A (en) * | 2017-07-31 | 2018-01-16 | 杭州大搜车汽车服务有限公司 | A kind of vehicle matching process based on VIN codes, electronic equipment, storage medium |
-
2018
- 2018-10-11 CN CN201811181642.0A patent/CN109508345A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120041968A1 (en) * | 2010-08-10 | 2012-02-16 | Zak Jr Kenneth R | Vehicle identification number decoder |
| CN102930000A (en) * | 2012-10-26 | 2013-02-13 | 马涛 | System and method for carrying out searching match on automobile component products by using VIN (Vehicle Identification Number) |
| CN103049498A (en) * | 2012-12-07 | 2013-04-17 | 王志欣 | Method for recognizing vehicle type through vehicle identification number (VIN) |
| CN105786886A (en) * | 2014-12-25 | 2016-07-20 | 上海通用汽车有限公司 | Vehicle maintenance directory system |
| CN106095785A (en) * | 2016-05-27 | 2016-11-09 | 大连楼兰科技股份有限公司 | DTC based on decision tree classification diagnosis vehicle work item and spare part search method |
| CN107491776A (en) * | 2017-07-04 | 2017-12-19 | 江苏迪纳数字科技股份有限公司 | The method and device configured by passenger car VIN code automatic identifications vehicle |
| CN107491777A (en) * | 2017-07-04 | 2017-12-19 | 江苏迪纳数字科技股份有限公司 | The method and device whether matched by passenger car VIN code automatic identification OBD vehicle devices |
| CN107590178A (en) * | 2017-07-31 | 2018-01-16 | 杭州大搜车汽车服务有限公司 | A kind of vehicle matching process based on VIN codes, electronic equipment, storage medium |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110147371A (en) * | 2019-05-15 | 2019-08-20 | 北京信息科技大学 | A kind of Vehicle Identification Number management method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104636478B (en) | Information query method and equipment | |
| CN103810212B (en) | Automated database index creation method and system | |
| US20060101000A1 (en) | Selection of a set of optimal n-grams for indexing string data in a DBMS system under space constraints introduced by the system | |
| CN107169033A (en) | Relation data enquiring and optimizing method with parallel framework is changed based on data pattern | |
| WO2002061613A2 (en) | Database system and query optimiser | |
| CN109471929B (en) | Method for semantic search of equipment maintenance records based on map matching | |
| CN102193922A (en) | Method and device for accessing database | |
| CN104252507B (en) | A kind of business data matching process and device | |
| CN107491476B (en) | Data model conversion and query analysis method suitable for various big data management systems | |
| CN103778185A (en) | SQL statement parsing method and system used for database auditing system | |
| CN101458692A (en) | Strategic material industry knowledge base platform and construct method thereof | |
| US9053207B2 (en) | Adaptive query expression builder for an on-demand data service | |
| CN109344227A (en) | Worksheet method, system and electronic equipment | |
| US7640266B2 (en) | Computer program product and associated methods for searching a database of objects, connecting objects in such a database, and exporting data from at least one arbitrary database | |
| WO2023125718A1 (en) | Data query method and system based on knowledge graph, and device and storage medium | |
| CN109508345A (en) | Database index querying method based on automobile VIN search | |
| CN111984673B (en) | Fuzzy retrieval method and device for tree structure of power grid electric energy metering system | |
| Isele et al. | Active learning of expressive linkage rules for the web of data | |
| US20060136388A1 (en) | Method for calculating distributed joins in main memory with minimal communicaton overhead | |
| CN107180024A (en) | A kind of multi-source heterogeneous data entity recognition methods of center connected subgraph and system | |
| CN110941831A (en) | Vulnerability matching method based on fragmentation technology | |
| CN111221967A (en) | Language data classification storage system based on block chain architecture | |
| CN106933844A (en) | Towards the construction method of the accessibility search index of extensive RDF data | |
| CN108536819A (en) | Integer arranges method, apparatus, server and the storage medium with character string comparison | |
| CN110147396A (en) | A kind of mapping relations generation method and device |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190322 |
|
| RJ01 | Rejection of invention patent application after publication |