CN115964356A

CN115964356A - Method, system, terminal and storage medium for establishing part database

Info

Publication number: CN115964356A
Application number: CN202211107920.4A
Authority: CN
Inventors: 曹岩; 姜海鸥; 谢子豪
Original assignee: FAW Bestune Car Co Ltd
Current assignee: FAW Bestune Car Co Ltd
Priority date: 2022-09-13
Filing date: 2022-09-13
Publication date: 2023-04-14

Abstract

The invention discloses a method, a system, a terminal and a storage medium for establishing a part database, which belong to the technical field of automobile parts and comprise the following steps: acquiring finished automobile data and establishing a finished automobile structure template; defining a basic number for each part in the whole vehicle structure template according to a unified part number standard to obtain a part basic number library; defining a special part vehicle type number for each project in the basic numbering library according to a platform, a vehicle type and project attributes of a company to obtain a vehicle type numbering library; the vehicle type numbering library and the basic numbering library are used for obtaining a preliminary part database according to a part numbering standard; and acquiring a product file and design information, and acquiring a finished automobile part large database by the primary part database through the product file and the design information. The invention can carry out transverse comparison analysis of part boundaries and functional modules or system levels among different vehicle types or among multiple vehicle types through the large database, and supports company level decision on the basis of the comparison data.

Description

Method, system, terminal and storage medium for establishing part database

Technical Field

The invention discloses a method, a system, a terminal and a storage medium for establishing a part database, and belongs to the technical field of automobile parts.

Background

Under the condition that the automobile sales market is competitive increasingly, the automobile model development iteration speed of the whole automobile factory is faster and faster, more and more parts are developed, information differences of design schemes, weight, materials, material thickness, cost and the like of the same parts among different automobile models can be frequently used, and a whole automobile level requires system level transverse comparison, so that a whole automobile structure-based part database is established.

Disclosure of Invention

Aiming at the defects of the prior art, the invention provides a part database establishing method, a system, a terminal and a storage medium, which can perform transverse comparison analysis of part boundaries and functional modules or system levels among different vehicle types or multiple vehicle types through a large database, and support company level decision based on the comparison data.

The technical scheme of the invention is as follows:

according to a first aspect of the embodiments of the present invention, there is provided a part database creating method, including:

acquiring finished automobile data and establishing a finished automobile structure template;

defining a basic number for each part in the whole vehicle structure template according to a uniform part number standard to obtain a part basic number library;

defining a special part vehicle type number for each project in the basic numbering library according to a platform, a vehicle type and project attributes of a company to obtain a vehicle type numbering library;

the vehicle type serial number library and the basic serial number library obtain a preliminary part database according to a part serial number standard;

and acquiring a product file and design information, and acquiring a finished automobile part large database by the primary part database through the product file and the design information.

Preferably, the part number includes: basic number, vehicle type number and scheme sequence number.

Preferably, the part base number library includes at least: serial number, grouping, base number, chinese name, and english name.

Preferably, the whole vehicle part large database at least comprises: serial number, grouping, part number, chinese name, design weight, and material.

According to a second aspect of an embodiment of the present invention, there is provided a parts database creating system including:

establishing a whole vehicle structure module for acquiring whole vehicle data and establishing a whole vehicle structure template;

establishing a part basic library module for defining a basic number for each part in the whole vehicle structure template according to a uniform part number standard to obtain a part basic number library;

establishing a vehicle type numbering library module for defining a special part vehicle type number for each project in the basic numbering library according to a platform, a vehicle type and project attributes of a company to obtain a vehicle type numbering library;

establishing a preliminary part database module for obtaining a preliminary part database according to the part number standard by the vehicle type number database and the basic number database;

and establishing a finished automobile part big database module for acquiring product files and design information, and acquiring a finished automobile part big database from the primary part database through the product files and the design information.

According to a third aspect of embodiments of the present invention, there is provided a terminal, including:

one or more processors;

a memory for storing the one or more processor-executable instructions;

wherein the one or more processors are configured to:

the method of the first aspect of the embodiments of the present invention is performed.

According to a fourth aspect of embodiments of the present invention, there is provided a non-transitory computer-readable storage medium, wherein instructions, when executed by a processor of a terminal, enable the terminal to perform the method according to the first aspect of embodiments of the present invention.

According to a fifth aspect of embodiments of the present invention, there is provided an application program product, which, when running on a terminal, causes the terminal to perform the method of the first aspect of embodiments of the present invention.

The invention has the beneficial effects that:

the patent provides a method, a system, a terminal and a storage medium for establishing a part database, which are used for acquiring vehicle data and establishing a vehicle structure template; defining a basic number for each part in the whole vehicle structure template according to a unified part number standard to obtain a part basic number library; defining a special part vehicle type number for each project in the basic numbering library according to a platform, a vehicle type and project attributes of a company to obtain a vehicle type numbering library; the vehicle type numbering library and the basic numbering library are used for obtaining a preliminary part database according to a part numbering standard; and obtaining product files and design information, wherein the primary part database obtains a whole vehicle part big database through the product files and the design information, and can be used for a whole vehicle enterprise to transversely compare part and system level design information and support enterprise item decision-making.

It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the invention, as claimed.

Drawings

FIG. 1 is a flow diagram illustrating a part database building method in accordance with an exemplary embodiment;

FIG. 2 is a block diagram illustrating the structural schematic of a parts database build system in accordance with an exemplary embodiment;

fig. 3 is a schematic block diagram of a terminal structure shown in accordance with an example embodiment.

Detailed Description

The technical solutions of the present invention will be described clearly and completely with reference to the accompanying drawings, and it should be understood that the described embodiments are some, but not all embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

In the description of the present invention, it should be noted that the terms "center", "upper", "lower", "left", "right", "vertical", "horizontal", "inner", "outer", etc., indicate orientations or positional relationships based on the orientations or positional relationships shown in the drawings, and are only for convenience of description and simplicity of description, but do not indicate or imply that the device or element being referred to must have a particular orientation, be constructed and operated in a particular orientation, and thus, should not be construed as limiting the present invention.

In the description of the present invention, it should be noted that, unless otherwise explicitly specified or limited, the terms "mounted," "connected," and "connected" are to be construed broadly, e.g., as meaning either a fixed connection, a removable connection, or an integral connection; can be mechanically or electrically connected; they may be connected directly or indirectly through intervening media, or they may be interconnected between two elements. The specific meanings of the above terms in the present invention can be understood in specific cases to those skilled in the art.

The embodiment of the invention provides a part database establishing method, which is realized by a terminal, wherein the terminal can be a desktop computer or a notebook computer and the like, and at least comprises a CPU and the like.

Example one

Fig. 1 is a flowchart illustrating a part database building method for use in a terminal according to an exemplary embodiment, the method including the steps of:

step 101, acquiring vehicle data and establishing a vehicle structure template, wherein the specific contents are as follows:

the method comprises the steps of establishing a standardized whole vehicle structure, disassembling a whole vehicle layer by layer according to the functions and assembly of parts, dividing the whole vehicle into systems such as a power assembly, a chassis, an intelligent network connection, an interior trim and an exterior trim, subdividing the systems into subsystems such as an engine, a transmission, exhaust, blankets, a guard plate, a headlamp and the like on the basis, subdividing the systems into functional modules such as the engine, an A column guard plate, a B column guard plate and the like on the basis again, and defining and numbering layer by layer to form the standardized whole vehicle structure. And for the types of parts which are newly increased along with the technical progress, timely addition and deletion adjustment is carried out in the whole vehicle structure.

102, defining a basic number for each part in the whole vehicle structure template according to a unified part number standard to obtain a part basic number library, wherein the specific contents are as follows:

according to a unified part numbering standard, defining a basic number for each part, wherein each basic number represents a part, all parts are corresponding to the function module in the step one, namely, each function module comprises a plurality of subdivided parts under classification, so that a part basic numbering library at least comprises: serial number, grouping, base number, chinese name, and english name. As shown in table 1 below.

Table 1 parts base numbering table

Step 103, defining the special part vehicle type number for each project in the basic numbering library according to the platform, the vehicle type and the project attribute of the company to obtain a vehicle type numbering library, which is shown in the following table 2.

TABLE 2 vehicle type numbering table

Serial number	Code	Vehicle serial number	First item number	Vehicle type number
					1	1B	A40	A40FL	1B
2	1D	B40	B40FL	1D
					3	1E	C50	C50FL	1E

And step 104, obtaining a preliminary part database by the vehicle type number library and the basic number library according to the part number standard, wherein the concrete contents are as follows:

according to the part numbering standard, the part number is composed of a basic number, a vehicle type number and a scheme sequence number. When a brand new part is developed in a vehicle type project, a designer needs to apply for creating a part in a system, firstly, the vehicle type project needing to be developed is determined, and a vehicle type number is determined. Then determining the part types, determining the basic part numbers, and determining the scheme numbers according to the information and the existing parts of the system by the system, thereby obtaining a preliminary part database.

105, acquiring a product file and design information, and acquiring a finished automobile part large database by the primary part database through the product file and the design information, wherein the specific contents are as follows:

the designer need fill in the CATIA template when publishing product data write information such as design weight, material and the material thickness of part, can fill in the part when publishing product BOM write information such as part cost, write into preliminary part database with the design information commonly used based on above design file, form full version part information big database, and the big database of whole car part includes at least: serial number, grouping, part number, chinese name, design weight, and materials, as shown in table 3 below.

Table 3 whole vehicle parts big database table

Serial number	Grouping	Part number	Name of Chinese	Design weight	Material
						1	02	1EA0-02000	Engine assembly	216000	Cast iron
3	02	1EA0-02016	Secondary air pump support	535	HT250
						4	03	1EA0-03000	Transmission device	118000
9	04	1BA0-04003	Front axle assembly drawing
						10	04	1BA0-04060	Right front axle assembly	136000	SCM435
11	04	1BA0-04090	Left front axle assembly	148000	SCM435

The basic number, the vehicle type project, the functional module number, the subsystem number, the system number and the part design information corresponding to the part number can be obtained based on the part library, and cross-vehicle type transverse design information comparison of the part, the functional module, the subsystem and the system level part can be carried out on the basis.

Example two

In an exemplary embodiment, there is also provided a parts database creating method, as shown in fig. 2, the design system including:

a whole vehicle structure template establishing module 210 for acquiring whole vehicle data and establishing a whole vehicle structure template;

establishing a part base library module 220, which is used for defining a base number for each part in the whole vehicle structure template according to a uniform part number standard to obtain a part base number library;

establishing a vehicle type numbering library module 230 for defining a special part vehicle type number for each project in the basic numbering library according to a platform, a vehicle type and project attributes of a company to obtain a vehicle type numbering library;

establishing a preliminary part database module 230 for obtaining a preliminary part database according to the part number standard by the vehicle type number database and the basic number database;

and establishing a finished automobile part big database module 250 for acquiring product files and design information, wherein the primary part database acquires a finished automobile part big database through the product files and the design information.

The invention establishes a standardized whole vehicle structure which can be used as a whole vehicle design guide file such as a whole vehicle BOM, whole vehicle data and the like, establishes a universal system file part basic numbering library on the basis, and forms a complete large part database by combining vehicle type items and part design information.

Example four

Fig. 3 is a block diagram of a terminal according to an embodiment of the present application, where the terminal may be the terminal in the foregoing embodiment. The terminal 300 may be a portable mobile terminal such as: smart phones, tablet computers. The terminal 300 may also be referred to by other names such as user equipment, portable terminal, etc.

Generally, the terminal 300 includes: a processor 301 and a memory 302.

The processor 301 may include one or more processing cores, such as a 4-core processor, an 8-core processor, and so on. The processor 301 may be implemented in at least one hardware form of a DSP (Digital Signal Processing), an FPGA (Field-Programmable Gate Array), and a PLA (Programmable Logic Array). The processor 301 may also include a main processor and a coprocessor, where the main processor is a processor for Processing data in a wake state, and is also called a Central Processing Unit (CPU); a coprocessor is a low power processor for processing data in a standby state. In some embodiments, the processor 301 may be integrated with a GPU (Graphics Processing Unit), which is responsible for rendering and drawing the content required to be displayed on the display screen. In some embodiments, the processor 301 may further include an AI (Artificial Intelligence) processor for processing computing operations related to machine learning.

Memory 302 may include one or more computer-readable storage media, which may be tangible and non-transitory. Memory 302 may also include high-speed random access memory, as well as non-volatile memory, such as one or more magnetic disk storage devices, flash memory storage devices. In some embodiments, a non-transitory computer readable storage medium in memory 302 is used to store at least one instruction for execution by processor 301 to implement a parts database creation method provided herein.

In some embodiments, the terminal 300 may further optionally include: a peripheral interface 303 and at least one peripheral. Specifically, the peripheral device includes: at least one of radio frequency circuitry 304, touch display screen 305, camera 306, audio circuitry 307, positioning component 308, and power supply 309.

The peripheral interface 303 may be used to connect at least one peripheral related to I/O (Input/Output) to the processor 301 and the memory 302. In some embodiments, processor 301, memory 302, and peripheral interface 303 are integrated on the same chip or circuit board; in some other embodiments, any one or two of the processor 301, the memory 302 and the peripheral interface 303 may be implemented on a single chip or circuit board, which is not limited by the embodiment.

The Radio Frequency circuit 304 is used for receiving and transmitting RF (Radio Frequency) signals, also called electromagnetic signals. The radio frequency circuitry 304 communicates with a communication network and other communication devices via electromagnetic signals. The rf circuit 304 converts an electrical signal into an electromagnetic signal to transmit, or converts a received electromagnetic signal into an electrical signal. Optionally, the radio frequency circuit 304 comprises: an antenna system, an RF transceiver, one or more amplifiers, a tuner, an oscillator, a digital signal processor, a codec chipset, a subscriber identity module card, and so forth. The radio frequency circuitry 304 may communicate with other terminals via at least one wireless communication protocol. The wireless communication protocols include, but are not limited to: the world wide web, metropolitan area networks, intranets, various generations of mobile communication networks (2G, 3G, 4G, and 5G), wireless local area networks, and/or WiFi (Wireless Fidelity) networks. In some embodiments, the radio frequency circuit 304 may further include NFC (Near Field Communication) related circuits, which are not limited in this application.

The touch display screen 305 is used to display a UI (User Interface). The UI may include graphics, text, icons, video, and any combination thereof. The touch screen display 305 also has the ability to capture touch signals on or above the surface of the touch screen display 305. The touch signal may be input to the processor 301 as a control signal for processing. The touch screen display 305 is used to provide virtual buttons and/or a virtual keyboard, also referred to as soft buttons and/or a soft keyboard. In some embodiments, the touch display screen 305 may be one, providing the front panel of the terminal 300; in other embodiments, the touch display screens 305 may be at least two, respectively disposed on different surfaces of the terminal 300 or in a folded design; in still other embodiments, the touch display 305 may be a flexible display disposed on a curved surface or on a folded surface of the terminal 300. Even more, the touch screen display 305 may be arranged in a non-rectangular irregular pattern, i.e., a shaped screen. The touch Display screen 305 may be made of LCD (Liquid Crystal Display), OLED (Organic Light-Emitting Diode), and the like.

The camera assembly 306 is used to capture images or video. Optionally, camera assembly 306 includes a front camera and a rear camera. Generally, a front camera is used to implement a video call or self-timer shooting, and a rear camera is used to implement a picture or video shooting. In some embodiments, the number of the rear cameras is at least two, and each of the rear cameras is any one of a main camera, a depth-of-field camera and a wide-angle camera, so that the main camera and the depth-of-field camera are fused to realize a background blurring function, and the main camera and the wide-angle camera are fused to realize a panoramic shooting function and a VR (Virtual Reality) shooting function. In some embodiments, camera assembly 306 may also include a flash. The flash lamp can be a monochrome temperature flash lamp or a bicolor temperature flash lamp. The double-color-temperature flash lamp is a combination of a warm-light flash lamp and a cold-light flash lamp, and can be used for light compensation at different color temperatures.

Audio circuitry 307 is used to provide an audio interface between a user and terminal 300. Audio circuitry 307 may include a microphone and a speaker. The microphone is used for collecting sound waves of a user and the environment, converting the sound waves into electric signals, and inputting the electric signals to the processor 301 for processing or inputting the electric signals to the radio frequency circuit 304 to realize voice communication. The microphones may be provided in plural numbers, respectively, at different portions of the terminal 300 for the purpose of stereo sound collection or noise reduction. The microphone may also be an array microphone or an omni-directional pick-up microphone. The speaker is used to convert electrical signals from the processor 301 or the radio frequency circuitry 304 into sound waves. The loudspeaker can be a traditional film loudspeaker and can also be a piezoelectric ceramic loudspeaker. When the speaker is a piezoelectric ceramic speaker, the speaker can be used for purposes such as converting an electric signal into a sound wave audible to a human being, or converting an electric signal into a sound wave inaudible to a human being to measure a distance. In some embodiments, audio circuitry 307 may also include a headphone jack.

The positioning component 308 is used to locate the current geographic Location of the terminal 300 for navigation or LBS (Location Based Service). The Positioning component 308 may be a Positioning component based on the Global Positioning System (GPS) in the united states, the beidou System in china, or the galileo System in russia.

The power supply 309 is used to supply power to the various components in the terminal 300. The power source 309 may be alternating current, direct current, disposable batteries, or rechargeable batteries. When the power source 309 includes a rechargeable battery, the rechargeable battery may be a wired rechargeable battery or a wireless rechargeable battery. The wired rechargeable battery is a battery charged through a wired line, and the wireless rechargeable battery is a battery charged through a wireless coil. The rechargeable battery may also be used to support fast charge technology.

Example four

In an exemplary embodiment, a computer-readable storage medium is also provided, on which a computer program is stored, which when executed by a processor implements a part database building method as provided by all inventive embodiments of the present application.

Any combination of one or more computer-readable media may be employed. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.

A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.

Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

Computer program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, smalltalk, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).

EXAMPLE five

In an exemplary embodiment, an application product is also provided, which includes one or more instructions executable by the processor 301 of the apparatus to perform a parts database creation method as described above.

While embodiments of the invention have been disclosed above, it is not intended to be limited to the uses set forth in the specification and examples. It can be applied to all kinds of fields suitable for the present invention. Additional modifications will readily occur to those skilled in the art. It is therefore intended that the invention not be limited to the exact details and illustrations described and illustrated herein, but fall within the scope of the appended claims and equivalents thereof.

Claims

1. A parts database creation method, comprising:

defining a basic number for each part in the whole vehicle structure template according to a unified part number standard to obtain a part basic number library;

the vehicle type numbering library and the basic numbering library are used for obtaining a preliminary part database according to a part numbering standard;

2. The part database building method according to claim 1, wherein the part number includes: basic number, vehicle type number and scheme sequence number.

3. The parts database building method according to claim 2, wherein the parts base number library at least comprises: serial number, grouping, base number, chinese name, and english name.

4. The part database building method according to claim 3, wherein the finished vehicle part big database at least comprises: serial number, grouping, part number, chinese name, design weight, and material.

5. A parts database creation system, comprising:

establishing a part base library module for defining a base number for each part in the whole vehicle structure template according to a unified part number standard to obtain a part base number library;

and establishing a finished automobile part big database module for acquiring product files and design information, and acquiring a finished automobile part big database through the product files and the design information by the primary part database.

6. A terminal, comprising:

one or more processors;

a memory for storing the one or more processor-executable instructions;

wherein the one or more processors are configured to:

a parts database creation method as claimed in any one of claims 1 to 4 is performed.

7. A non-transitory computer readable storage medium, wherein instructions in the storage medium, when executed by a processor of a terminal, enable the terminal to perform a parts database creation method as claimed in any one of claims 1 to 4.