Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A vehicle failure data management system based on ACCESS

An invalid data and management system technology, applied in the field of data management, can solve problems such as not being able to adapt to the rapid development needs of enterprises, and achieve the effects of easy maintenance and management, easy use, and simple data storage methods

Inactive Publication Date: 2019-03-22
JIANGLING MOTORS
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In addition, due to the wide variety of auto parts, the large differences in service environments, and the various failure forms, accounting alone is far from being able to meet the rapid development needs of enterprises.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A vehicle failure data management system based on ACCESS
  • A vehicle failure data management system based on ACCESS

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0020] see figure 1 , figure 2 , the vehicle failure data management system based on ACCESS in the present invention is mainly composed of a part feature information management module, a user information management module, an existing case management module, a failure information query module and a new case entry module.

[0021] The system adopts object-oriented programming technology, uses the Microsoft Windows operating platform as the system development environment on the operating system, and uses the ACCESS 2016 database as the data container for storing failure cases. The interface layer uses Visual Studio 2017 with SQL statements to retrieve and add data. It is suitable for the management of failed parts information by passenger car, commercial vehicle OEMs and auto parts factories. in,

[0022] Part feature classification management module, formulate feature keywords and build a database framework according to different systems, and manage failure feature informat...

Embodiment 2

[0028] see figure 1 , figure 2 , the vehicle failure data management system based on ACCESS in this embodiment, the database structure diagram is as follows figure 1 As shown, the operating platform of Microsoft Windows is selected as the system development environment on the operating system, the interface layer uses Visual Studio2017 equipped with SQL statements to realize the retrieval and addition of data, and the ACCESS 2016 database is used as the data container for storing failure cases. The statement when calling the verified database data through SQL is as follows:

[0029] Search the database precisely by entering the field name = 'field value': Edit "SELECT * from verified database where part number = 'AAA'" to retrieve the failure information of the part number 'AAA' in the existing database ;

[0030] Perform a fuzzy search on the database by entering a field name like 'field value': edit "SELECT * from verified database where macro fracture description like '...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The present invention relates to data management techniques. The invention relates to a vehicle failure data management system based on ACCESS, which is composed of a part feature information management module, a user information management module, an existing case management module, a failure information inquiry module and a new case input module. Among them, the part feature classification management module, according to different systems to develop feature keywords and build a database framework to manage the automotive parts of the failure feature information; User information management module, by assigning different rights to engineers, so that engineers can log in different parts of the system; Existing case management module, through building the failure database framework, editingSQL statements to input failure cases to achieve the data management of existing cases; Manage failure case information that has occurred and has been validated; Invalidation information query module, through editing the SELECT statement to achieve the query of the existing invalidation data, and the query results are sorted and output according to the requirements; New case input module, throughthe UNION command to achieve the new validation case warehousing management.

Description

technical field [0001] The invention relates to data management technology, in particular to an ACCESS-based vehicle failure data management system. Background technique [0002] With the continuous popularization of automobiles and the frequent occurrence of mechanical equipment accidents, the safety and reliability of automobiles have gradually become the focus of attention. The technical status of auto parts will gradually change with the use of parts. When they break and lose the functions specified in the original design, engineers will carry out failure analysis, propose improvement measures and conduct follow-up verification. [0003] In order to improve the efficiency of failure analysis, it is objectively required that enterprises must summarize and strengthen management of the failure cases that have occurred. In addition, due to the wide variety of auto parts, the large differences in service environments, and the various failure forms, accounting alone is far fr...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/22G06F16/242G06F16/2458
Inventor 王丽芬李彬张瑞峰
Owner JIANGLING MOTORS
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com