CN109508332A - A kind of vehicle disablement data management system based on ACCESS - Google Patents
A kind of vehicle disablement data management system based on ACCESS Download PDFInfo
- Publication number
- CN109508332A CN109508332A CN201811338167.3A CN201811338167A CN109508332A CN 109508332 A CN109508332 A CN 109508332A CN 201811338167 A CN201811338167 A CN 201811338167A CN 109508332 A CN109508332 A CN 109508332A
- Authority
- CN
- China
- Prior art keywords
- database
- case
- failure
- data
- management
- 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
Abstract
The present invention relates to data management techniques.A kind of vehicle disablement data management system based on ACCESS is made of part feature information management module, subscriber information management module, existing case management module, fail message enquiry module and newly-increased case recording module；Wherein, part feature Classification Management module formulates characteristic key words according to different systems and builds database framework, manages the failure characteristics information of auto parts；Subscriber information management module, by distributing different permissions to engineer, so that engineer logs in different pts systems；Existing case management module, by building fail data library frame, editor's SQL statement typing failure case realizes the data management of existing case；Management has occurred and by the failure case information of verifying；Fail message enquiry module realizes the inquiry to existing fail data, and output of sorting as required to query result by editor's SELECT statement；Newly-increased case recording module realizes the stock management to new verifying case by UNION order.
Description
Technical field
The present invention relates to data management techniques, more particularly, to a kind of vehicle disablement data management system based on ACCESS
System.
Background technique
Constantly universal and mechanical equipment accident with automobile takes place frequently, and the safety and reliability of automobile is increasingly becoming people
Focus of attention.The technology status of auto parts and components can gradually change with the use process of components, when its generation
Fracture, after losing the former function of designing defined, engineer can carry out failure analysis, proposition corrective measure is gone forward side by side, and line trace is tested
Card.
To improve the efficiency of failure analysis, objectively require enterprise that must carry out concluding always to the failure case occurred
It ties and strengthens management.In addition, since auto parts and components are many kinds of, there are larger difference, failure mode are a variety of more for Service Environment
Sample can not much adapt to the fast-developing demand of enterprise only according to flowing water book keeping operation.
Therefore, it is necessary to vehicle disablement data management system be established, to reduce throwing of the enterprise in terms of data management cost
Enter, improves the safety and reliability of automobile.
Summary of the invention
The present invention is in view of the shortcomings of the prior art, propose a kind of vehicle disablement data management system based on ACCESS.It is applicable in
In the management of passenger car, commercial vehicle main engine plants and auto parts and components factory to failure parts information.
The technical solution adopted by the present invention:
A kind of vehicle disablement data management system based on ACCESS, using object-oriented programming technology, in operation system
It selects the operating platform of Microsoft Windows as system development environment on system, is made using 2016 database of ACCESS
For the data capsule of storage failure case, boundary layer carries SQL statement using Visual Studio2017 to realize the tune of data
It takes and adds, system is mainly by part feature information management module, subscriber information management module, existing case management module, mistake
Imitate information inquiry module and newly-increased case recording module composition；Wherein,
Part feature Classification Management module formulates characteristic key words according to different systems and builds database framework, manages vapour
The failure characteristics information of vehicle part；
Subscriber information management module, by distributing different permissions to engineer, so that engineer logs in different pts systems；
So that effectively managing user information, guarantee engineer respectively take charge of its duty, screen the fail message for oneself being responsible for part system；
Existing case management module, by building fail data library frame, editor's SQL statement typing failure case realizes existing case
The data management of example；Management has occurred and by the failure case information of verifying；
Fail message enquiry module realizes the inquiry to existing fail data by editor's SELECT statement, and to query result
Sequence output as required；Using fuzzy query mode and accurate inquiry mode, fuzzy query mode is according to a certain feature degree of correlation
Sequence output from high in the end, for failure analysis, personnel provide thinking；
Newly-increased case recording module realizes the stock management to new verifying case by UNION order.
Invention the utility model has the advantages that
1, the present invention is based on the vehicle disablement data management systems of ACCESS is applicable in using object-oriented programming technology
In the management of passenger car, commercial vehicle main engine plants and auto parts and components factory to failure parts information.It selects on an operating system
The operating platform of Microsoft Windows is lost as system development environment, using 2016 database of ACCESS as storage
Imitate the data capsule of case.Boundary layer carries SQL statement using Visual Studio2017 to realize transferring and adding for data
Add.
2, the present invention is based on the vehicle disablement data management systems of ACCESS, and compared with prior art, interface is more intuitive, soft
Part operation is more stable, system structure is more flexible, written in code is simple, uses convenient for failure analysis personnel.In addition, the number of this system
Simple according to storage mode, easy to maintain and management can reduce investment of the enterprise in terms of data management cost.
Detailed description of the invention
Fig. 1 is that the present invention is based on the vehicle disablement data management system database structure schematic diagrames of ACCESS；
Fig. 2 is that the present invention is based on the vehicle disablement data management system part feature taxonomy model figures of ACCESS.
Specific embodiment
Below by specific embodiment, technical solution of the present invention is described in further detail.Following embodiment
It is merely to illustrate the present invention, limiting the scope of the present invention should not be constituted.Those skilled in the art are in prior art model
In enclosing, simple combination is carried out using the displacement of conventional techniques and with the prior art, all without departing from the scope of the present invention.
Embodiment 1
Referring to Fig. 1, Fig. 2, the present invention is based on the vehicle disablement data management systems of ACCESS, mainly by part feature information management
Module, subscriber information management module, existing case management module, fail message enquiry module and newly-increased case recording module group
At.
System uses object-oriented programming technology, selects the behaviour of Microsoft Windows on an operating system
Make data capsule of the platform as system development environment, using 2016 database of ACCESS as storage failure case.Boundary layer
SQL statement is carried using Visual Studio2017 to realize transferring and adding for data.Suitable for passenger car, commercial car owner
The management of machine factory and auto parts and components factory to failure parts information.Wherein,
Part feature Classification Management module formulates characteristic key words according to different systems and builds database framework, manages vapour
The failure characteristics information of vehicle part；
Subscriber information management module, by distributing different permissions to engineer, so that engineer can log in different parts
System；Both it can guarantee that engineer respectively takes charge of its duty, screening oneself rapidly and efficiently with system effectively managing user information in this way
It is responsible for the fail message of part.The use scope that the system can be expanded simultaneously, is not only limited to carry on a shoulder pole during failure analysis
The engineer of one role of Ren is conducive to the management of vehicle part failure analysis information；
Existing case management module, by building fail data library frame, editor's SQL statement typing failure case realizes existing case
The data management of example；Management has occurred and has had verified that database and competing by the failure case information of verifying, including enterprises
Product have verified that database；Wherein enterprises have verified that database is that enterprise is completed failure analysis and tests by subsequent road test
The case of card；Competing product have verified that database is the case that failure analysis is completed in the competing product vehicle of domestic and international mainstream；
Fail message enquiry module realizes the inquiry to existing fail data by editor's SELECT statement, and to query result
Sequence output as required；Using fuzzy query mode and accurate inquiry mode, wherein fuzzy query mode is according to a certain feature phase
Guan Du sorts output from high in the end, and for failure analysis, personnel provide thinking；
Newly-increased case recording module realizes the stock management to new verifying case by UNION order.Newly-increased case recording module
It is a part very crucial in entire database, only reinforces being failure analysis to the management talent of kainogenesis case fail message
A large amount of data basis is provided, the efficiency of failure analysis is improved.
Embodiment 2
Referring to Fig. 1, Fig. 2, the vehicle disablement data management system based on ACCESS of the present embodiment, database structure figure such as Fig. 1
It is shown, select the operating platform of Microsoft Windows as system development environment on an operating system, boundary layer uses
Visual Studio2017 carries SQL statement to realize transferring and adding for data, using 2016 database conduct of ACCESS
The data capsule of storage failure case.It is as follows that sentence when having verified that database data is transferred by SQL:
Accurately searched by input field name=' field value ' database: " SELECT * from has verified that number to editor
According to library where dash number=' AAA ' " realize to dash number in existing database be ' AAA ' part fail message tune
It takes；
Pass through input field name like ' field value ' fuzzy search is carried out to database: " SELECT * from has verified that editor
Database where macrofracture describes like ' * fatigue * ' " realize to macrofracture description in include " fatigue " printed words zero
Part fail message is transferred；
Be ranked up inquiry to database by top screening: " 10 * from of SELECT top has verified that database to editor
Where heat treatment process=' quenched ' " realizes the fail message sorting query of modifier treatment part；
Have verified that database to new generation case library remittance by editor's UNION sentence: " SELECT * FROM is newly generated editor
Case library UNION SELECT * FROM has verified that database " realize database addition.
The present invention is based on the vehicle disablement data management systems of ACCESS, formulate characteristic key words simultaneously according to different systems
Establish Database field；Since the characteristic information paid close attention to when the part failure of different Service Environments is analyzed has a certain difference,
So by part according to using position to be divided into body parts, chassis part, power assembly part, interior trim part, exterior trim part, electricity
7 device part, fastener systems.Part feature taxonomy model is as shown in Figure 2.
By taking chassis part as an example, since the carrying of chassis part is larger, most of part needs to improve through Overheating Treatment
Its intensity, in failure analysis other than paying close attention to general characteristics, it is also necessary to pay close attention to its heat treatment process and skin decarburization situation.Institute
The entitled part name of Database field, dash number, manufacturing process, failure operating condition, material board to formulate chassis system part
Number, the description of material type, heat treatment process, macrofracture, macrofracture photo, metallographic decarburization photo, failure mode, reason point
Analysis, conclusion, corrective measure.
Claims (4)
1. a kind of vehicle disablement data management system based on ACCESS is being operated using object-oriented programming technology
Select the operating platform of Microsoft Windows as system development environment in system, using 2016 database of ACCESS
As the data capsule of storage failure case, boundary layer carries SQL statement using Visual Studio2017 to realize data
It transfers and adds, it is characterised in that: system is mainly by part feature information management module, subscriber information management module, existing case
Example management module, fail message enquiry module and newly-increased case recording module composition；Wherein,
Part feature Classification Management module formulates characteristic key words according to different systems and builds database framework, manages vapour
The failure characteristics information of vehicle part；
Subscriber information management module, by distributing different permissions to engineer, so that engineer logs in different pts systems；
So that effectively managing user information, guarantee engineer respectively take charge of its duty, screen the fail message for oneself being responsible for part system；
Existing case management module, by building fail data library frame, editor's SQL statement typing failure case realizes existing case
The data management of example；Management has occurred and by the failure case information of verifying；
Fail message enquiry module realizes the inquiry to existing fail data by editor's SELECT statement, and to query result
Sequence output as required；Using fuzzy query mode and accurate inquiry mode, fuzzy query mode is according to a certain feature degree of correlation
Sequence output from high in the end, for failure analysis, personnel provide thinking；
Newly-increased case recording module realizes the stock management to new verifying case by UNION order.
2. the vehicle disablement data management system according to claim 1 based on ACCESS, it is characterised in that: pass through SQL
Sentence realizes that the lookup and addition of database, the lookup of database are added and transfer sentence when having verified that database data such as
Under:
Database is accurately searched by input field name=' field value ':
" SELECT * from has verified that database where dash number=' AAA ' " is edited to realize in existing database zero
Part number is that the fail message of the part of ' AAA ' is transferred；
Pass through input field name like ' field value ' fuzzy search is carried out to database:
" SELECT * from has verified that database where macrofracture describes like ' * fatigue * ' " is edited to realize to macro
The part failure information comprising " fatigue " printed words transfers in sight fracture description；
Inquiry is ranked up to database by top screening:
Editor " 10 * from of SELECT top has verified that database where heat treatment process=' quenched ' " realize quenched place
Manage the fail message sorting query of part；
Database is had verified that new generation case library remittance by editor's UNION sentence:
It edits " SELECT * FROM newly generates case library UNION SELECT * FROM and has verified that database " and realizes data
The addition in library.
3. the vehicle disablement data management system according to claim 1 or 2 based on ACCESS, it is characterised in that: part
In tagsort management module, due to different Service Environments part failure analysis when the characteristic information paid close attention to there are certain differences
It is different, by part according to using position to be divided into body parts, chassis part, power assembly part, interior trim part, exterior trim part, electricity
7 device part, fastener systems；And characteristic key words are formulated according to different systems and establish Database field.
4. the vehicle disablement data management system according to claim 3 based on ACCESS, it is characterised in that: according to difference
System formulate and characteristic key words and establish Database field, for chassis part, since the carrying of chassis part is larger, big portion
Part is divided to need to improve its intensity through Overheating Treatment, in failure analysis other than paying close attention to general characteristics, it is also necessary to pay close attention to it
Heat treatment process and skin decarburization situation, so formulating the entitled part name of Database field of chassis system part, part is compiled
Number, manufacturing process, failure operating condition, material trademark, material type, heat treatment process, macrofracture description, macrofracture photo,
Metallographic decarburization photo, failure mode, the analysis of causes, conclusion, corrective measure.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811338167.3A CN109508332A (en) | 2018-11-12 | 2018-11-12 | A kind of vehicle disablement data management system based on ACCESS |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811338167.3A CN109508332A (en) | 2018-11-12 | 2018-11-12 | A kind of vehicle disablement data management system based on ACCESS |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109508332A true CN109508332A (en) | 2019-03-22 |
Family
ID=65747999
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811338167.3A Pending CN109508332A (en) | 2018-11-12 | 2018-11-12 | A kind of vehicle disablement data management system based on ACCESS |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109508332A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140280300A1 (en) * | 2013-03-15 | 2014-09-18 | Aktiebolaget Skf | Guided data collection management system |
| US20150081729A1 (en) * | 2013-09-19 | 2015-03-19 | GM Global Technology Operations LLC | Methods and systems for combining vehicle data |
| CN106021521A (en) * | 2016-05-24 | 2016-10-12 | 北京科技大学 | Sharing method of material failure cases |
| CN106096259A (en) * | 2016-06-07 | 2016-11-09 | 上汽通用汽车有限公司 | Materials failure analysis method |
| CN107480230A (en) * | 2017-08-04 | 2017-12-15 | 南京国电南自电网自动化有限公司 | A kind of power automatic device failure analysis Database Management System Design method |
| CN108717463A (en) * | 2018-05-28 | 2018-10-30 | 江铃汽车股份有限公司 | A kind of Materials failure analysis database building method |
-
2018
- 2018-11-12 CN CN201811338167.3A patent/CN109508332A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140280300A1 (en) * | 2013-03-15 | 2014-09-18 | Aktiebolaget Skf | Guided data collection management system |
| US20150081729A1 (en) * | 2013-09-19 | 2015-03-19 | GM Global Technology Operations LLC | Methods and systems for combining vehicle data |
| CN106021521A (en) * | 2016-05-24 | 2016-10-12 | 北京科技大学 | Sharing method of material failure cases |
| CN106096259A (en) * | 2016-06-07 | 2016-11-09 | 上汽通用汽车有限公司 | Materials failure analysis method |
| CN107480230A (en) * | 2017-08-04 | 2017-12-15 | 南京国电南自电网自动化有限公司 | A kind of power automatic device failure analysis Database Management System Design method |
| CN108717463A (en) * | 2018-05-28 | 2018-10-30 | 江铃汽车股份有限公司 | A kind of Materials failure analysis database building method |
Non-Patent Citations (1)
| Title |
|---|
| 刘鹏鹏 等: ""汽车用金属材料数据库的开发及应用"", 《汽车实用技术》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Jiménez-Ruiz et al. | Safe and economic re-use of ontologies: A logic-based methodology and tool support | |
| Yuan et al. | A graph-search based approach to BPEL4WS test generation | |
| Tracz et al. | A domain-specific software architecture engineering process outline | |
| WO1996023266A1 (en) | End user query facility | |
| Bell et al. | Software design for reliability and reuse: A proof-of-concept demonstration | |
| CN109508332A (en) | A kind of vehicle disablement data management system based on ACCESS | |
| Soós | The indicators of local democratic governance project: concepts and hypotheses | |
| Huang et al. | Text mining with application to engineering diagnostics | |
| US20090271701A1 (en) | Method for Systematically Identifying Technology-Based Solutions | |
| Savković et al. | MAGIK: managing completeness of data | |
| Barnett et al. | Design and development of a classification system for knowledge management tools and methods | |
| Nicolle et al. | Multi-data models translations in interoperable information systems | |
| Al Saiyd et al. | Semantic-based retrieving model of reuse software component | |
| Gao | Design and implementation of cloud computer room management system based on cloud computing data center | |
| Xue et al. | Similarity spreading: a unified framework for similarity calculation of interrelated objects | |
| Liu et al. | Entity centric query expansion for enterprise search | |
| Campbell et al. | A conceptual graphs approach to information systems design | |
| Fadnis et al. | NL2PDDL: A Conversational Interface for Model Generation and Iteration | |
| Cafeo et al. | Capturing Lessons Learned for Variation Reduction in an Automotive Assembly Plant. | |
| US20060136362A1 (en) | Systems and methods for data conversion | |
| Graedel et al. | Multiscale life-cycle assessment | |
| Morgan et al. | The general-motors variation-reduction adviser | |
| Liberal et al. | PHOTOVOLTAIC SYSTEMS AND BIM INTEGRATION: TRENDS AND POSSIBILITIES | |
| Deng et al. | A novel design methodology for fixed-shaft hybrid powertrain with a single-motor | |
| Song et al. | Identifying patent precedents for engineering design: an iterative heuristic method of mining text, citation and inventor information |
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 |