CN107066431A - The storage method and storage processing equipment of a kind of model data - Google Patents
The storage method and storage processing equipment of a kind of model data Download PDFInfo
- Publication number
- CN107066431A CN107066431A CN201710326784.0A CN201710326784A CN107066431A CN 107066431 A CN107066431 A CN 107066431A CN 201710326784 A CN201710326784 A CN 201710326784A CN 107066431 A CN107066431 A CN 107066431A
- Authority
- CN
- China
- Prior art keywords
- type configuration
- automobile type
- configuration table
- model data
- field
- 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
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/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- 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/22—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/151—Transformation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Software Systems (AREA)
- Artificial Intelligence (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of storage method of model data and storage processing equipment, methods described includes：S1：The automobile type configuration table of non-Microsoft Excel form is converted to the automobile type configuration table of Microsoft Excel form, the non-Microsoft Excel form includes picture format or PDF format；S2：The automobile type configuration table of Microsoft Excel form is stored in database；S3：The automobile type configuration literary name section of the automobile type configuration table stored in database and field value are exported to carry out collecting arrangement；S4：Set up the relation dictionary of automobile type configuration literary name segment value and standard word segment value；S5：Automobile type configuration literary name segment value is converted to by standard word segment value according to relation dictionary, and the standard word segment value after conversion is imported in model data storehouse.The automobile type configuration table that the present invention can issue different automobile production producers is incorporated into model data storehouse, can effectively improve the matching efficiency between database, improves matching precision.
Description
Technical field
The present invention relates to Data Analysis Services technical field, and in particular at a kind of storage method of model data and storage
Manage equipment.
Background technology
With the fast development of Chinese Automobile Industry ', Chinese automobile volume of production and marketing occupies the first in the world for years, with
It is corresponding be that the automobile product species of China Auto Market increases year by year, major automobile production producers have new product to push away every year
Go out, the species of automobile type configuration is also not quite similar with title, how by the Data Enter model data storehouse in automobile type configuration table just into
Problem.Country model data storehouse Data Enter mode is manual examination and verification automobile type configuration table content, this mode efficiency at present
Relatively low and easy error, and elapse over time, these mistakes are difficult to find that foundation is corrected.
Therefore, the typing of data message and Integration Mode still have many improved necessity in existing database.
The content of the invention
To solve the deficiencies in the prior art, the invention provides a kind of storage method of model data, comprise the following steps：
S1：The automobile type configuration table of non-Microsoft Excel form is converted to the automobile type configuration table of Microsoft Excel form, it is described
Non- Microsoft Excel form includes picture format or PDF format, and the conversion method is included by picture and text identification facility or artificial careful
Core is put in storage mode；
S2：The automobile type configuration table of Microsoft Excel form is stored in database；
S3：The automobile type configuration literary name section of the automobile type configuration table stored in database and field value export is whole collect
Reason；
S4：Set up the relation dictionary of automobile type configuration literary name section and criteria field, and automobile type configuration literary name segment value and standard
The relation dictionary of field value；Using relation dictionary by by each identical of automobile type configuration literary name section and automobile type configuration literary name segment value and
Difference field carries out Corresponding matching, to be converted to automobile type configuration table criteria field and automobile type configuration table standard word segment value, as a result
Audited and be stored in database；
S5：Criteria field and field value after conversion is stored in model data storehouse.
Wherein, the model data storage method also includes：
S6：By the automobile type configuration table criteria field and standard word segment value that import in model data storehouse and the output on service line
It is connected.
Invention additionally provides a kind of storage processing equipment of model data, including memory, processor and storage
The computer program run in the memory and on the processor,
Described in the computing device following steps are realized during computer program：
S1：The automobile type configuration table of non-Microsoft Excel form is converted to the automobile type configuration table of Microsoft Excel form, it is described
Non- Microsoft Excel form includes picture format or PDF format, and the conversion method is included by picture and text identification facility or artificial careful
Core is put in storage mode；
S2：The automobile type configuration table of Microsoft Excel form is stored in database；
S3：The automobile type configuration literary name section of the automobile type configuration table stored in database and field value export is whole collect
Reason；
S4：Set up the relation dictionary of automobile type configuration literary name section and criteria field, and automobile type configuration literary name segment value and standard
The relation dictionary of field value；Using relation dictionary by by each identical of automobile type configuration literary name section and automobile type configuration literary name segment value and
Difference field carries out Corresponding matching, to be converted to automobile type configuration table criteria field and automobile type configuration table standard word segment value, as a result
Audited and be stored in database；
S5：Criteria field and field value after conversion is stored in model data storehouse.
Wherein, following steps are also realized during computer program described in the computing device：
S6：By the automobile type configuration table criteria field and standard word segment value that import in model data storehouse and the output on service line
It is connected.
The storage method and equipment for the model data that the present invention is provided, the vehicle that can issue different automobile production producers are matched somebody with somebody
Put table to be incorporated into model data storehouse, the matching efficiency between database can be effectively improved, improve matching precision.
Embodiment
Further understand to have to technical scheme and beneficial effect, the following detailed description of the present invention's
Technical scheme and its beneficial effect of generation.
The invention provides a kind of storage method of model data, comprise the following steps：
S1：The automobile type configuration table of non-Microsoft Excel form is converted to the automobile type configuration table of Microsoft Excel form, it is described
Non- Microsoft Excel form includes picture format or PDF format；1 specifically is shown in Table, is that one in one embodiment of the invention is in
The automobile type configuration table of Microsoft Excel form.In the present invention, the automobile type configuration table of non-Microsoft Excel form is converted into EXCEL tables
The method of case form include but is not limited to picture and text identification facility change or manual examination and verification by way of.
Table 1：An automobile type configuration table in Microsoft Excel form in one embodiment of the invention
S2：The automobile type configuration table of Microsoft Excel form is stored in database.
S3：The automobile type configuration literary name section of the automobile type configuration table stored in database and field value export is whole collect
Reason.
S4：Set up the relation dictionary of automobile type configuration literary name section and criteria field, and automobile type configuration literary name segment value and standard
The relation dictionary of field value；The configuration field and field value of different manufacturers are different, such as ESP electric stabilizing systems, ESP dynamic stabilities
Control system, VSC vehicle body stabilizing control systems, refer to table 2, are the corresponding automobile type configuration literary name section of one embodiment of the present of invention
With the relation dictionary of criteria field, by the ESP electric stabilizing systems, ESP dynamic stability control systems, VSC cars of the different manufacturers
The criteria field that body stabilizing control system corresponds in model data storehouse.
Table 3 is referred to, is the relation of the corresponding automobile type configuration literary name segment value of one embodiment of the present of invention and standard word segment value
The field symbols indicated in dictionary, different allocation lists are different, by the mark in the distinct symbols indicated correspondence model data storehouse
Quasi- field value.
Table 2：Automobile type configuration literary name section and criteria field relation dictionary
Table 3：The relation dictionary of automobile type configuration literary name segment value and standard word segment value
Relation dictionary is recycled by by each identical and difference word of automobile type configuration literary name section and automobile type configuration literary name segment value
Duan Jinhang Corresponding matchings, to be converted to automobile type configuration table criteria field and automobile type configuration table standard word segment value, are as a result examined
Core is simultaneously stored in database；Refer to table 4 and table 5, respectively automobile type configuration field and configuration words segment value conversion table and standard
Field and standard word segment value conversion table.
Table 4：Automobile type configuration field and configuration words segment value conversion table
| Configuration field | Configuration words segment value |
| ESP electric stabilizing systems, ESP dynamic stability control systems | ● |
| ESP dynamic stability control systems | S |
| VSC vehicle body stabilizing control systems | ■ |
Table 5：Vehicle criteria field and standard word segment value conversion table
| Criteria field | Standard word segment value |
| Vehicle body stability contorting (ESC/ESP/DSC etc.) | 1 |
Criteria field and standard word segment value is the main configurations needed for vehicle storehouse and Valuation Modelling, and the present invention is in specific implementation
When, it is necessary to corresponding relation dictionary between periodic maintenance automobile type configuration literary name section and field value and criteria field and field value, with
Reach configuration field and field value Auto-matching criteria field and field value and the purpose for improving efficiency and accuracy rate.
S5：Criteria field after conversion and field value are imported in model data storehouse.
S6：By the automobile type configuration table criteria field and standard word segment value that import in model data storehouse and the output on service line
It is connected.
Therefore, the present invention is using modes such as a point table, Fen Ku, distributed contrast contings, by the theory of some ripe frameworks
And technology, optimized with reference to the database characteristics of the present invention, ultimately form a set of new technical system.Reach fast
Speed, stable data conversion output.
Meanwhile, the method that the vehicle initial data that the present invention is provided stores single table output using multilist passes through automobile type configuration
Model data and the conversion of model data storehouse Plays field in table, improve the efficiency and accuracy of data conversion.
Invention additionally provides a kind of storage processing equipment based on above-mentioned storage method, including memory, processor
And it is stored in the computer program run in the memory and on the processor, it is characterised in that
Described in the computing device following steps are realized during computer program：
S1：The automobile type configuration table of non-Microsoft Excel form is converted to the automobile type configuration table of Microsoft Excel form, it is described
Non- Microsoft Excel form includes picture format or PDF format, and the conversion method is included by picture and text identification facility or artificial careful
Core is put in storage mode；
S2：The automobile type configuration table of Microsoft Excel form is stored in database；
S3：The automobile type configuration literary name section of the automobile type configuration table stored in database and field value export is whole collect
Reason；
S4：Set up the relation dictionary of automobile type configuration literary name section and criteria field, and automobile type configuration literary name segment value and standard
The relation dictionary of field value；Using relation dictionary by by each identical of automobile type configuration literary name section and automobile type configuration literary name segment value and
Difference field carries out Corresponding matching, to be converted to automobile type configuration table criteria field and automobile type configuration table standard word segment value, as a result
Audited and be stored in database；
S5：Criteria field and field value after conversion is stored in model data storehouse；
S6：By the automobile type configuration table criteria field and standard word segment value that import in model data storehouse and the output on service line
It is connected.
The storage method and equipment by model data that the present invention is provided, the vehicle that different automobile production producers can be issued
Allocation list is incorporated into model data storehouse, can effectively improve the matching efficiency between database, improves matching precision.
To sum up, the storage method for the model data that the present invention is provided and storage processing equipment, can be by different auto producers
The automobile type configuration table of family's issue is incorporated into model data storehouse, can effectively improve the matching efficiency between database, improves matching
Precision.
Although the present invention is illustrated using above-mentioned preferred embodiment, so it is not limited to protection model of the invention
Enclose, any those skilled in the art are not being departed within the spirit and scope of the present invention, various become is carried out with respect to above-described embodiment
It is dynamic still to belong to the scope that the present invention is protected with modification, therefore protection scope of the present invention is by being defined that claims are defined.
Claims (4)
1. a kind of storage method of model data, it is characterised in that comprise the following steps：
S1：The automobile type configuration table of non-Microsoft Excel form is converted to the automobile type configuration table of Microsoft Excel form, it is described non-
Microsoft Excel form includes picture format or PDF format, and the conversion method includes passing through picture and text identification facility or manual examination and verification
Mode；
S2：The automobile type configuration table of Microsoft Excel form is stored in database；
S3：The automobile type configuration literary name section of the automobile type configuration table stored in database and field value are exported to carry out collecting arrangement；
S4：Set up the relation dictionary of automobile type configuration literary name section and criteria field, and automobile type configuration literary name segment value and criteria field
The relation dictionary of value；Using relation dictionary by by each identical and difference of automobile type configuration literary name section and automobile type configuration literary name segment value
Field carries out Corresponding matching, to be converted to automobile type configuration table criteria field and automobile type configuration table standard word segment value, as a result carries out
Audit and be stored in database；
S5：Criteria field and field value after conversion is stored in model data storehouse.
2. the storage method of model data as claimed in claim 1, it is characterised in that also include：
S6：Automobile type configuration table criteria field and standard word segment value and the output phase on service line in model data storehouse will be imported
Even.
3. a kind of storage processing equipment of model data, it is characterised in that including memory, processor and be stored in described deposit
The computer program run in reservoir and on the processor,
Described in the computing device following steps are realized during computer program：
S1：The automobile type configuration table of non-Microsoft Excel form is converted to the automobile type configuration table of Microsoft Excel form, it is described non-
Microsoft Excel form includes picture format or PDF format, and the conversion method includes passing through picture and text identification facility or manual examination and verification
Storage mode；
S2：The automobile type configuration table of Microsoft Excel form is stored in database；
S3：The automobile type configuration literary name section of the automobile type configuration table stored in database and field value are exported to carry out collecting arrangement；
S4：Set up the relation dictionary of automobile type configuration literary name section and criteria field, and automobile type configuration literary name segment value and criteria field
The relation dictionary of value；Using relation dictionary by by each identical and difference of automobile type configuration literary name section and automobile type configuration literary name segment value
Field carries out Corresponding matching, to be converted to automobile type configuration table criteria field and automobile type configuration table standard word segment value, as a result carries out
Audit and be stored in database；
S5：Criteria field and field value after conversion is stored in model data storehouse.
4. the storage processing equipment of model data as claimed in claim 3, it is characterised in that counted described in the computing device
Following steps are also realized during calculation machine program：
S6：Automobile type configuration table criteria field and standard word segment value and the output phase on service line in model data storehouse will be imported
Even.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710326784.0A CN107066431A (en) | 2017-05-10 | 2017-05-10 | The storage method and storage processing equipment of a kind of model data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710326784.0A CN107066431A (en) | 2017-05-10 | 2017-05-10 | The storage method and storage processing equipment of a kind of model data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107066431A true CN107066431A (en) | 2017-08-18 |
Family
ID=59597655
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710326784.0A Pending CN107066431A (en) | 2017-05-10 | 2017-05-10 | The storage method and storage processing equipment of a kind of model data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107066431A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110194178A (en) * | 2019-06-06 | 2019-09-03 | 驭势科技（北京）有限公司 | Automatic Pilot control method, device, electronic equipment and computer-readable medium |
| CN110427382A (en) * | 2019-08-09 | 2019-11-08 | 安徽工业大学 | A kind of method that nonuniformity EXCEL table is converted into relation database table |
| CN111339084A (en) * | 2020-02-15 | 2020-06-26 | 河北唐宋大数据产业股份有限公司 | Data processing method and system |
| CN111367988A (en) * | 2020-03-31 | 2020-07-03 | 中国建设银行股份有限公司 | Data import method and device |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080320023A1 (en) * | 2005-02-03 | 2008-12-25 | Fong Joseph S P | System and method of translating a relational database into an xml document and vice versa |
| CN102023979A (en) * | 2009-09-09 | 2011-04-20 | 中国工商银行股份有限公司 | Meta-data management method and system |
| CN103020162A (en) * | 2012-11-26 | 2013-04-03 | 中国电力科学研究院 | Method for converting and importing CC2000 model into D5000 system |
| CN103309907A (en) * | 2012-03-16 | 2013-09-18 | 上海安捷力信息***有限公司 | Method and system for standardized processing of service data from different sources |
| CN104657430A (en) * | 2015-01-28 | 2015-05-27 | 武汉烽火众智数字技术有限责任公司 | Method and system for data acquisition |
| CN105786912A (en) * | 2014-12-25 | 2016-07-20 | 远光软件股份有限公司 | Data acquisition and transformation method and device |
-
2017
- 2017-05-10 CN CN201710326784.0A patent/CN107066431A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080320023A1 (en) * | 2005-02-03 | 2008-12-25 | Fong Joseph S P | System and method of translating a relational database into an xml document and vice versa |
| CN102023979A (en) * | 2009-09-09 | 2011-04-20 | 中国工商银行股份有限公司 | Meta-data management method and system |
| CN103309907A (en) * | 2012-03-16 | 2013-09-18 | 上海安捷力信息***有限公司 | Method and system for standardized processing of service data from different sources |
| CN103020162A (en) * | 2012-11-26 | 2013-04-03 | 中国电力科学研究院 | Method for converting and importing CC2000 model into D5000 system |
| CN105786912A (en) * | 2014-12-25 | 2016-07-20 | 远光软件股份有限公司 | Data acquisition and transformation method and device |
| CN104657430A (en) * | 2015-01-28 | 2015-05-27 | 武汉烽火众智数字技术有限责任公司 | Method and system for data acquisition |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110194178A (en) * | 2019-06-06 | 2019-09-03 | 驭势科技（北京）有限公司 | Automatic Pilot control method, device, electronic equipment and computer-readable medium |
| CN110194178B (en) * | 2019-06-06 | 2021-04-16 | 驭势科技（北京）有限公司 | Automatic driving control method, device, electronic equipment and computer readable medium |
| CN110427382A (en) * | 2019-08-09 | 2019-11-08 | 安徽工业大学 | A kind of method that nonuniformity EXCEL table is converted into relation database table |
| CN111339084A (en) * | 2020-02-15 | 2020-06-26 | 河北唐宋大数据产业股份有限公司 | Data processing method and system |
| CN111367988A (en) * | 2020-03-31 | 2020-07-03 | 中国建设银行股份有限公司 | Data import method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107066431A (en) | The storage method and storage processing equipment of a kind of model data | |
| CN107204184A (en) | Audio recognition method and system | |
| CN106156239B (en) | Table extraction method and device | |
| CN103324609A (en) | Text proofreading apparatus and text proofreading method | |
| CN101430714B (en) | Content structuring process method and system based on model | |
| CN110263311B (en) | Method and device for generating network page | |
| CN104624509A (en) | Automatic sorting system and automatic sorting method for express delivery | |
| US20140046899A1 (en) | Method and Apparatus of Implementing Navigation of Product Properties | |
| CN102662969A (en) | Internet information object positioning method based on webpage structure semantic meaning | |
| CN103268362A (en) | Auxiliary design method of virtual terminals on basis of general template and key character matching | |
| CN104142912A (en) | Accurate corpus category marking method and device | |
| CN103150298A (en) | Customizable complicated form generation method for river basin water diversion business based on Web | |
| CN102207946A (en) | Knowledge network semi-automatic generation method | |
| CN106933691A (en) | A kind of recognition methods and system for abnormity point in seasonal time series data sequence | |
| CN110019224A (en) | A kind of crosstab head generation method based on tree search | |
| CN115630648A (en) | Address element analysis method and system for man-machine conversation and computer readable medium | |
| CN103914540A (en) | Processing method for flexibly configuring ammeter specifications for ammeter reading | |
| CN103235757B (en) | Several apparatus and method that input domain tested object is tested are made based on robotization | |
| CN103049524B (en) | Synonym result for retrieval presses meaning of a word automatic clustering method | |
| CN108563647A (en) | A kind of automobile Method for Sales Forecast method based on comment sentiment analysis | |
| CN105335459A (en) | XBRL intelligent report platform based statement consolidation data extraction method | |
| CN110929509B (en) | Domain event trigger word clustering method based on louvain community discovery algorithm | |
| CN103309888A (en) | Method and device for verifying data of electronic map | |
| CN113535938B (en) | Standard data construction method, system, equipment and medium based on content identification | |
| CN102236708B (en) | Method for converting topographic map data format to overhead line format |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170818 |