Vehicle bill of material management method, device, equipment and medium

Abstract

The invention relates to a vehicle bill of material management method and device, equipment and a medium, and the method comprises the steps: receiving a warehousing request which comprises a first configuration family and a corresponding first basic configuration value; querying a first vehicle type room and a dotting configuration value matched with the first configuration family based on an engineering configuration table of historical vehicle type rooms; based on a first engineering material list of the first vehicle type room, screening a part combination relation set of the dotting configuration value relative to a first basic configuration value; function position description contained in the part combination relation set is converted into natural language data; taking the dotting configuration value and the natural language data as first high-dimensional vector data and storing the first high-dimensional vector data in a preset vector database; and checking the integrity of the bill of materials based on the vector database. According to the scheme, the part data quality and management efficiency can be improved.

Description

Technical Field

[0001] The present disclosure relates to the technical field of data management, and in particular to a method, device, equipment and medium for managing a vehicle bill of materials. Background Art

[0002] With the rapid development of the automobile industry, the vehicle design and manufacturing process has become increasingly complex. As a key information carrier connecting product design, procurement, production, sales and after-sales service, the Bill of Materials (BOM) plays a vital role in the entire life cycle of a vehicle.

[0003] The existing method of relying on BOM engineers to manually manage BOMs not only has low management efficiency, but also is prone to omissions or errors when processing large-scale, highly complex BOM data due to the wide variety of automotive parts and frequent design changes. This leads to poor data quality and the inability to effectively guarantee BOM integrity checks. Summary of the invention

[0004] In order to solve the above technical problems, the present disclosure provides a vehicle bill of materials management method, device, equipment and medium.

[0005] According to one aspect of the present disclosure, a method for managing a vehicle bill of materials is provided, the method comprising:

[0006] Receive a storage request, wherein the storage request includes: a first configuration family and a first basic configuration value corresponding thereto;

[0007] Based on the engineering configuration table of the historical vehicle model room, query the first vehicle model room and the dot configuration value that matches the first configuration family; wherein the dot configuration value is the configuration value of the first configuration family used to calculate the configuration and part combination relationship in the first vehicle model room;

[0008] Based on the first engineering material list of the first vehicle model room, screening the part combination relationship set of the dot configuration value relative to the first basic configuration value;

[0009] Converting the functional position description contained in the part combination relationship set into natural language data;

[0010] Storing the dot configuration value and the natural language data as first high-dimensional vector data in a preset vector database;

[0011] A completeness check of the bill of materials is performed based on the vector database.

[0012] According to another aspect of the present disclosure, a vehicle bill of materials management device is also provided, the device comprising:

[0013] A storage request module, configured to receive a storage request, wherein the storage request includes: a first configuration family and a first basic configuration value corresponding thereto;

[0014] A vehicle model room query module, used to query the first vehicle model room and the dot configuration value matching the first configuration family based on the engineering configuration table of the historical vehicle model room; wherein the dot configuration value is the configuration value of the first configuration family used to calculate the configuration and part combination relationship in the first vehicle model room;

[0015] A parts combination relationship screening module, for screening a parts combination relationship set of the dot configuration value relative to the first basic configuration value based on the first engineering material list of the first vehicle model room;

[0016] A data conversion module, used for converting the functional position description contained in the part combination relationship set into natural language data;

[0017] A data storage module, used for storing the dot configuration value and the natural language data as first high-dimensional vector data into a preset vector database;

[0018] A list checking module is used to perform a completeness check on the bill of materials based on the vector database.

[0019] According to another aspect of the present disclosure, an electronic device is provided, the electronic device comprising:

[0020] processor;

[0021] a memory for storing processor-executable instructions;

[0022] The processor is used to read executable instructions from the memory and execute the instructions to implement the above-mentioned vehicle material list management method.

[0023] According to another aspect of the present disclosure, a computer-readable storage medium is provided, wherein the storage medium stores a computer program for executing the above-mentioned vehicle bill of materials management method.

[0024] Compared with the prior art, the technical solution provided by the embodiments of the present disclosure has the following advantages:

[0025] The technical solution provided by the embodiment of the present disclosure includes: receiving a warehousing request, the warehousing request including: a first configuration family and its corresponding first basic configuration value; based on the engineering configuration table of the historical vehicle model room, querying the first vehicle model room and the dot configuration value matching the first configuration family; based on the first engineering material list of the first vehicle model room, screening the part combination relationship set of the dot configuration value relative to the first basic configuration value; converting the functional position description contained in the part combination relationship set into natural language data; storing the dot configuration value and the natural language data as first high-dimensional vector data in a preset vector database; and performing an integrity check of the bill of materials based on the vector database.

[0026] In the case where the first configuration family needs to be put into storage, the technical solution first searches for the first vehicle model room suitable for data analysis of the first configuration family based on the engineering configuration table of the historical vehicle model room; then uses the first engineering material list of the first vehicle model room to automatically analyze and summarize the correct parts combination dedicated to a single configuration function, that is, the parts combination relationship set, and converts the functional position description in the parts combination relationship set into natural language data: the first parts combination semantic description string, the first hash code and the first n-dimensional vector data; the above natural language data that is easy for machine processing is converted into the first high-dimensional vector data and saved in the vector database. The above process can use the engineering configuration table and engineering material list of the historical vehicle model room to automatically generate natural language data representing the functional position description for the configuration family that needs to be put into storage. In this way, when faced with complex and uncertain functional configuration changes, the automatic generation of natural language data describing the functional position can be efficiently realized without manual intervention, thereby improving the efficiency of parts data management.

[0027] Moreover, after generating a vector database containing a large amount of natural language data, the vector database can be used to check the integrity of the bill of materials for new projects. While improving the quality of the bill of materials data, it also enhances the intelligence level of the bill of materials inspection and thus improves labor efficiency, ultimately shortening the product development cycle, accelerating the product iteration process, and improving product competitiveness. BRIEF DESCRIPTION OF THE DRAWINGS

[0028] The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present disclosure and, together with the description, serve to explain the principles of the present disclosure.

[0029] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, for ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative labor.

[0030] Figure 1A flowchart of a vehicle bill of materials management method provided in an embodiment of the present disclosure;

[0031] Figure 2 A flow chart of a method for querying car model rooms provided in an embodiment of the present disclosure;

[0032] Figure 3 A schematic diagram of an engineering configuration table for multiple vehicle room types provided in an embodiment of the present disclosure;

[0033] Figure 4 A schematic diagram of an engineering material bill provided for an embodiment of the present disclosure;

[0034] Figure 5 A schematic diagram of the relationship between multiple part row sets provided in an embodiment of the present disclosure;

[0035] Figure 6 A schematic diagram of two sets of parts combination relationships provided in an embodiment of the present disclosure;

[0036] Figure 7 A data schematic diagram of a vector database provided by an embodiment of the present disclosure;

[0037] Figure 8 A flow chart of a method for checking the integrity of a bill of materials provided in an embodiment of the present disclosure;

[0038] Fig. 9 A schematic diagram of a process for determining different configuration families provided by an embodiment of the present disclosure;

[0039] Fig.10 A schematic diagram of format conversion provided by an embodiment of the present disclosure;

[0040] Fig.11 A schematic diagram of an integrity check result provided by an embodiment of the present disclosure;

[0041] Fig.12 A schematic diagram of solving a second engineering material bill provided by an embodiment of the present disclosure;

[0042] Fig.13 A schematic diagram of a plurality of fourth part combination semantic description character strings provided in an embodiment of the present disclosure;

[0043] Fig.14 Another schematic diagram of integrity check results provided by an embodiment of the present disclosure;

[0044] Fig.15 A structural block diagram of a vehicle bill of materials management device provided in an embodiment of the present disclosure;

[0045] Fig.16 It is a schematic diagram of the structure of the electronic device described in the embodiment of the present disclosure. DETAILED DESCRIPTION

[0046] In order to more clearly understand the above-mentioned objectives, features and advantages of the present disclosure, the scheme of the present disclosure will be further described below. It should be noted that the embodiments of the present disclosure and the features in the embodiments can be combined with each other without conflict.

[0047] In the following description, many specific details are set forth to facilitate a full understanding of the present disclosure, but the present disclosure may also be implemented in other ways different from those described herein; it is obvious that the embodiments in the specification are only part of the embodiments of the present disclosure, rather than all of the embodiments.

[0048] The traditional manual BOM management method can no longer meet the efficiency and accuracy requirements of the modern automobile manufacturing industry. At the same time, with the development of science and technology, automobile manufacturing technology has been continuously improved, making automobiles more flexible for personalized options. In addition, in the fierce market competition, in order to attract consumers and increase sales, many automobile manufacturers have begun to provide a rich variety of optional configurations. In summary, the increasing diversification of automobile personalized options has increased the complexity of managing the material costs of optional packages in the process of automobile product development to market sales.

[0049] The existing BOM management methods have the following main problems when dealing with large-scale and highly complex BOM data:

[0050] 1. BOM integrity problem: Due to the wide variety of automotive parts and frequent design changes, manual maintenance of BOM is prone to omissions or errors, resulting in the inability to effectively ensure the integrity of BOM. This not only affects the vehicle cost management of the entire life cycle of the automotive product development process, but also affects the accuracy of the vehicle production plan in the manufacturing process, and also increases inventory costs and supply chain risks.

[0051] 2. Insufficient intelligence: Most current BOM management systems rely on fixed rules for verification and lack intelligent analysis capabilities. When faced with complex logical judgments and abnormal situations, additional manual intervention is often required, which increases the workload and poses data quality risks.

[0052] Which factory-level parts each car should contain is affected by many factors such as functional configuration, technical solutions, vehicle layout, appearance, supply model, manufacturing process, etc., and there is a great deal of uncertainty. Currently, it mainly relies on manual inspection by experienced BOM engineers, which is inefficient. At the same time, due to frequent changes in products and designs and high rates of change, it is difficult to identify related changes, resulting in repeated inspections and reviews, which is inefficient. Once the BOM has quality risks of multiple or missing parts, it will hinder the development of business in various fields.

[0053] At the same time, in order to improve product competitiveness and provide consumers with sales version options with different configuration gradients, multiple versions with different configuration gradients will be developed simultaneously for the same model during the development stage. The configuration differences between different versions are large, which increases the difficulty of BOM integrity checking.

[0054] In view of the above problems, the present disclosure provides a method, device, equipment and medium for managing a vehicle bill of materials. For ease of understanding, the following describes an embodiment of the present disclosure.

[0055] Figure 1 In an embodiment of the present disclosure, a method for managing a vehicle bill of materials is provided, which can be executed by a vehicle bill of materials management device, which can be implemented by software and / or hardware. The method for managing a vehicle bill of materials may include the following steps.

[0056] Step S100: receiving a storage request, wherein the storage request includes: a first configuration family and its corresponding first basic configuration value.

[0057] In this embodiment, a request from a user to enter the warehouse is received, and the request to enter the warehouse includes the first configuration family to be entered into the warehouse and the first basic configuration value corresponding to the first configuration family; taking "CA00, CA01" as an example, CA00 represents the first configuration family: air suspension, and CA01 represents the corresponding first basic configuration value: no air suspension.

[0058] According to the storage request, the first configuration family and its corresponding first basic configuration value are recorded in a preset configuration range table, which is used to record all configuration families requested to be stored and their corresponding basic configuration values. The configuration range table is specifically a database table of "checkable configuration range".

[0059] Step S200, based on the engineering configuration table of the historical vehicle model room, query the first vehicle model room and the dot configuration value that matches the first configuration family; wherein the dot configuration value is the configuration value of the first configuration family in the first vehicle model room used to calculate the configuration and parts combination relationship.

[0060] In this embodiment, the engineering configuration table of all historical vehicle room is obtained by querying the preset engineering configuration table database, and then referring to Figure 2 and Figure 3 According to the logical process shown in S210-S250 below, the engineering configuration table of each historical vehicle model room is judged in turn to screen out the code of the first vehicle model room suitable for historical data analysis of the above-mentioned first configuration family.

[0061] Step S210, taking each historical vehicle model room as the current vehicle model room one by one.

[0062] Step S220, determine whether the first basic configuration value exists in the engineering configuration table of the current model room. Continuing with the above example of "CA00, CA01", determine whether the first basic configuration value CA01 exists in the engineering configuration table of the current model room. If not, for example Figure 3 If the engineering configuration table of the model room 1 is not found, it is determined that the current model room is not suitable for data analysis of the first configuration family, and the next historical model room is used as the new current model room, and step S220 is re-executed. On the contrary, if the engineering configuration table of the current model room contains the first basic configuration value CA01, the following S230 is executed.

[0063] In addition, for Figure 3 In the engineering configuration table of the rooms of various models, when a function is standard or optional for the current version, a dot will be marked under the version. The dot mark is, for example: "S" represents that the version has a standard function, "O" represents that the version has an optional function; and "-" represents that the version does not have a certain function.

[0064] Step S230: If the first basic configuration value exists, determine whether the first basic configuration value has a dot in at least one vehicle version. Figure 3 The engineering configuration table of vehicle model room 2 contains the first basic configuration value CA01. It is determined that the first basic configuration value CA01 has no dot in each vehicle version in the engineering configuration table, that is, the marks of version 1, version 2 and version 3 are all "-". Therefore, when the first basic configuration value has no dot in all vehicle versions, it is determined that the current vehicle model room is not suitable for data analysis of the first configuration family, and the next historical vehicle model room is used as the new current vehicle model room, and the process returns to the above step S220.

[0065] In another case, referring to Figure 3 In the engineering configuration table of vehicle model room 3, vehicle model room 4 and vehicle model room 5, there is a first basic configuration value CA01 in the above engineering configuration table. By judgment, in the engineering configuration table, the first basic configuration value CA01 is marked in at least one vehicle version. Specifically, in the engineering configuration table of vehicle model room 3, the marks of version 1, version 2 and version 3 are all "S", indicating that the first basic configuration value CA01 is marked in the three vehicle versions of version 1, version 2 and version 3. In this case, the following step S240 is executed.

[0066] Step S240: If there is a dot, determine whether there is at least one other configuration value in the engineering configuration table of the current vehicle model room in addition to the first basic configuration value, and whether at least one other configuration value has a dot in at least one vehicle version.

[0067] After determining that the first basic configuration value is marked in at least one vehicle version, determine whether there is at least one other configuration value in the engineering configuration table of the current vehicle model room in addition to the first basic configuration value. Figure 3 In the engineering configuration table of vehicle model room 3, there are no other configuration values ​​except the first basic configuration value. In this case, it is determined that the current vehicle model room is not suitable for data analysis of the first configuration family, and the next historical vehicle model room is used as the new current vehicle model room, and the process returns to the above step S220.

[0068] Reference Figure 3 In the engineering configuration table of vehicle model room 4, the engineering configuration table of vehicle model room 5, and the engineering configuration table of vehicle model room 6, in addition to the first basic configuration value, there is at least one other configuration value, such as CA03 and CA04; in this case, it is determined whether the above other configuration values ​​are marked in at least one vehicle version. This step is similar to the above step S230. In the engineering configuration table of vehicle model room 4, the other configuration value CA03 has no dots in all vehicle versions. At this time, it is determined that the current vehicle model room is not suitable for data analysis of the first configuration family, and the next historical vehicle model room is used as the new current vehicle model room, and the process returns to the above step S220.

[0069] In the engineering configuration table of vehicle model room 5 and vehicle model room 6, other configuration value CA03 is dotted in at least one vehicle version. In this case, the following step S250 is executed.

[0070] Step S250, if there is at least one other configuration value with a dot in at least one vehicle version, determine that the current vehicle model room is the first vehicle model room matching the first configuration family; and determine at least one other configuration value as a dotted configuration value under the first configuration family for calculating the configuration and parts combination relationship.

[0071] After determining that in addition to the first basic configuration value in the engineering configuration table of the current vehicle model room, there is at least one other configuration value, and at least one other configuration value is dotted in at least one vehicle version, it is determined that the current vehicle model room is the first vehicle model room matching the first configuration family, such as vehicle model room 5; and at least one other configuration value (ie, CA03 and CA04) is determined as the dotted configuration value for calculating the configuration and parts combination relationship under the first configuration family CA00.

[0072] Through the above steps, the first vehicle model room suitable for data analysis of the first configuration family is screened out, and the configuration values ​​with dots (S or O) in at least one version except the corresponding first basic configuration value under the first configuration family are obtained. These configuration values ​​are the configuration values ​​that can be used to calculate the configuration and parts combination relationship in the first vehicle model room, which are called dotted configuration values ​​in this embodiment.

[0073] Step S300, based on the first engineering material list of the first vehicle model room, filter the part combination relationship set of the dot configuration value relative to the first basic configuration value.

[0074] This embodiment may include the following steps S310 and S320:

[0075] Step S310, obtaining a first engineering material list of a first vehicle type room; wherein the first engineering material list includes: configuration variables, function location codes and BOM line identifiers.

[0076] During implementation, the preset EBOM (Engineering Bill of Materials) database table can be queried according to the first model room to obtain the first engineering bill of materials in the latest state of the first model room. The above EBOM database table is used to record all engineering bills of materials. The engineering bill of materials is developed and improved based on the BOM (Bill of Materials). The engineering bill of materials is more detailed and accurate. It not only contains detailed information about the parts, but also includes the assembly structure, version control, and replacement parts information of the product, which is used to guide a series of subsequent activities such as manufacturing, procurement, and quality control.

[0077] Reference Figure 4 For example, the first engineering bill of materials may include information such as hierarchy, part number, function location code, function location description, configuration variant, part type, and BOM line identifier.

[0078] Step S320, based on the configuration variables, the function location codes and the BOM line identifiers, respectively filter the first target part line set containing the first basic configuration value and the second target part line set containing the dot configuration value in the first engineering bill of materials.

[0079] The specific implementation process of this step S320 can refer to the following content.

[0080] Step S321, screening a first set of part rows to be analyzed in the first project bill of materials.

[0081] Specifically, according to the actual data analysis requirements, the first part row set to be analyzed is filtered in the first engineering bill of materials. Exemplarily, this embodiment only needs to analyze the functional configuration and the combination relationship of the factory-level functional parts. This part of the part combination relationship is represented by the level number "1" and has nothing to do with the non-factory-level sub-components and standard fasteners. Based on this, in the first engineering bill of materials, the part rows with a level other than "1" are filtered out, and the part rows with a part type of "STD" (representing fasteners) are filtered out, and the first part row set to be analyzed is output.

[0082] Step S322, filtering the second part row set including the first basic configuration value and the dot configuration value in the first part row set according to the configuration variable.

[0083] The configuration variable is used to indicate the specific code of the configuration value; according to the code of the configuration value recorded in this column of the configuration variable, the table rows containing any one or more of the first basic configuration value (CA01) and the dot configuration value (CA03 and CA04) are filtered out in the first part row set, and these filtered table rows constitute the second part row set.

[0084] Step S323, deduplicate the second part row set according to the function position code to obtain a third part row set.

[0085] Specifically, the attribute value of the "function location code" column of all rows in the second part row set may be obtained, and the second part row set may be deduplicated according to the function location code to obtain the third part row set.

[0086] Step S324, judging whether the part row data of the third part row set is more than the part row data of the second part row set according to the BOM row identifier.

[0087] For example, refer to Figure 5 The relationship diagram of the first part row set, the second part row set and the third part row set is shown. After the second part row set and the third part row set are screened out, the "BOM row identifier" can be used as the key value to determine whether the part row data of the third part row set is more than the part row data of the second part row set.

[0088] Step S325: If there are more than, the configuration variables of the redundant part row data in the third part row set are processed, and the processed third part row set is used as the fourth part row set.

[0089] When the part row data of the third part row set is more than the part row data of the second part row set, the redundant part row data in the third part row set is screened out, and then the "configuration variables" of these part rows are processed. The processing method is to change the original configuration variables of these part rows to the combination of the original configuration variables and the first basic configuration value and each dot configuration value, that is: (original configuration variable) & (first basic configuration value | dot configuration value 1 | dot configuration value 2 | ...). For example, if the original configuration variable is AA14 & KX03, the processed configuration variable is (AA14 & KX03) & (CA01 | CA03 | CA04).

[0090] The processed third part row set is used as the fourth part row set, or in other words, the part row data after the configuration variables in the third part row set are processed and added to the second part row set to form the fourth part row set.

[0091] Step S326: If the part row data of the third part row set is not more than the part row data of the second part row set, the third part row set is used as the fourth part row set.

[0092] Step S327, according to the configuration variables, respectively filter the first target part row set containing the first basic configuration value and the second target part row set containing the dotting configuration value in the fourth part row set.

[0093] Exemplarily, the first basic configuration value (CA01) is used to filter the first target part row set including CA01 in the "configuration variables" of the fourth part row set; similarly, the dot configuration values ​​(CA03 and CA04) are used to filter the second target part row set including CA03 and the second target part row set including CA04 in the "configuration variables" of the fourth part row set.

[0094] Step S330, based on the first target part row set and the second target part row set, calculate a part combination relationship set of the dotting configuration value under the first configuration family relative to the first basic configuration value.

[0095] First, according to the function position code, the first function position code set corresponding to the first basic configuration value is screened in the first target part row set, and the second function position code set corresponding to the dot configuration value is screened in the second target part row set. In the specific example, the first function position code set corresponding to CA01 is screened in the first target part row set corresponding to the first basic configuration value CA01, and the first function position code set is a set after deduplication according to the "function position code" attribute value; similarly, the second function position code set corresponding to CA03 is screened in the second target part row set corresponding to the dot configuration value CA03, and the second function position code set corresponding to CA04 is screened in the second target part row set corresponding to the dot configuration value CA04.

[0096] Secondly, the second function position code set is subtracted from the first function position code set, and combined with the function position description represented by the function position code, the part combination relationship set of the dot configuration value under the first configuration family is obtained. For example, the part combination relationship set corresponding to the configuration dot configuration value CA03 = "the second function position code set of CA03" - "the first function position code set of CA01"; the part combination relationship set corresponding to the configuration dot configuration value CA04 = "the second function position code set of CA04" - "the first function position code set of CA01".

[0097] The part combination relationship set calculated according to the above embodiment includes at least two pieces of data: the function position code and its corresponding function position description. Figure 6As shown, the part combination relationship sets of the dot configuration values ​​CA03 and CA04 under the first configuration family CA00 are respectively displayed in table form.

[0098] Step S400: converting the functional position description contained in the part combination relationship set into natural language data.

[0099] In one embodiment, the part combination relationship set may be sorted in ascending order according to the “function position code” to obtain a regularly sorted function position description, for example: Figure 6 Results shown.

[0100] exist Figure 6 In the table, the functional position descriptions recorded at different positions, such as air suspension controller, left front displacement sensor, and left rear displacement sensor, are words, phrases, and phrases in human-oriented natural language. These natural languages ​​need to be converted into meaningful symbols and relationships that machines can understand and process, that is, natural language data; the natural language data may include formats such as strings, codes, and vectors. To better understand the solution, the following provides several solutions for converting the functional position descriptions contained in the part combination relationship set into natural language data.

[0101] The function position description contained in the part combination relationship set is converted into a first part combination semantic description string; the first part combination semantic description string includes the dot configuration value and its corresponding function position description; the first part combination semantic description string is natural language data. Specifically, the above ordered function position description is converted into a first part combination semantic description string in text format, wherein the first part combination semantic description strings corresponding to the dot configuration values ​​CA03 and CA04 are as follows:

[0102] CA03: air suspension controller, left front displacement sensor, left rear displacement sensor, left rear air spring, right rear air spring, front air tank air line, rear air tank air line, air suspension compressor assembly, left rear air suspension air tank, right rear air suspension air tank, suspension adjustment switch, inertial measurement unit;

[0103] CA04: air suspension controller, left front acceleration sensor, left front displacement sensor, left rear displacement sensor, right front displacement sensor, right rear displacement sensor, left rear air spring, right rear air spring, rear air tank air line, left rear airbag air line, right rear airbag air line, right front airbag air line, left front airbag air line, air suspension air tank, air suspension compressor assembly, suspension adjustment switch.

[0104] Then, the first hash code corresponding to the semantic description string of the first part combination is calculated; the first hash code includes the hash code of the dot configuration value and its corresponding functional position description; the first hash code is the natural language data. Specifically, the first hash code corresponding to the semantic description string of the first part combination is calculated, and the first hash code is the SHA256 code. The first hash codes corresponding to the semantic description strings of the first part combination of the above-mentioned dot configuration values ​​CA03 and CA04 are respectively expressed as follows:

[0105] CA03: 173b94c18f1de65ebdbf4038ec93fbe16cd12d16d12848a61e4df9bba293f556;

[0106] CA04:d305d1c0e61ed22e58e267949ec61641e7609a1d97c9ffab9c87f1b242fac44d.

[0107] Next, a scalar search can be performed in the preset vector database to determine whether the first hash code exists in the vector database. If not, it means that the first coded data is new data that has not been stored in the database, so the subsequent steps are continued. If it exists, the complete data including the first hash code can be directly obtained from the vector database, and there is no need to repeatedly generate new vector data.

[0108] In this embodiment, the first n-dimensional vector data of the first part combination semantic description string is generated according to the vector model; the first n-dimensional vector data is natural language data. Specifically, the vector model can be called to generate 768-dimensional vector data of the first part combination semantic description string.

[0109] Furthermore, the above-mentioned first part combination semantic description character string, first hash code and first n-dimensional vector data are all used as machine-oriented natural language data.

[0110] Step S500: storing the dot configuration value and the natural language data as first high-dimensional vector data in a preset vector database.

[0111] According to the above embodiment, the data of all the car models and rooms that meet the conditions are stored in the vector database according to the above steps. The data stored in the vector database can be referred to Figure 7 As shown, it includes configuration code, configuration description, first hash code (ie, SHA256 code), first part combination semantic description string and 768-dimensional vector data.

[0112] The above-mentioned vector data is a numerical array, which represents a point in a multidimensional space; in natural language processing, the meaning of a word, phrase or sentence can be represented by vector data. The first high-dimensional vector data in this embodiment is used to use a numerical array to represent the functional position description contained in the dot configuration value and the part combination relationship set.

[0113] Step S600: performing integrity check of the bill of materials based on the vector database.

[0114] Reference Figure 8 In this embodiment, the method for checking the integrity of the bill of materials based on the vector database may include the following steps S610-S640:

[0115] Step S610, receiving an inspection request, the inspection request including: a second vehicle model room to be inspected. Specifically, receiving a user's request to inspect BOM integrity, the inspection request including a second vehicle model room to be inspected.

[0116] Step S620: based on the engineering configuration table of the room of the second vehicle type, filter a target configuration family set within a preset configuration range.

[0117] Specifically, the engineering configuration table of the second vehicle model room can be queried in the engineering configuration table database to obtain all configuration families contained in the engineering configuration table of the second vehicle model room to form a configuration family set; the configuration family set is, for example, {AA00, AC00, BA00, CA00, KX00, MC00…}. One or more configuration families within a preset configuration range in the configuration family set are screened out; the preset configuration range is, for example, the aforementioned "checkable configuration range"; the screened multiple configuration families form a target configuration family set, for example, {AC00, BA00, CA00, KX00…}.

[0118] Step S630: determining a second configuration family and a third configuration family in the target configuration family set that need to be checked and have different checking methods.

[0119] Reference Fig. 9 This embodiment provides the following method for determining a second configuration family and a third configuration family in a target configuration family set that need to be inspected and have different inspection methods.

[0120] Step S631, for the current configuration family in the target configuration family set, determine whether other configuration values ​​of the current configuration family other than the basic configuration value are marked in at least one vehicle version in the engineering configuration table of the second vehicle model room. If not, determine that the current configuration family does not need to be checked.

[0121] Step S632, if other configuration values ​​of the current configuration family except the basic configuration value are marked in at least one vehicle version, it is determined that the current configuration family needs to be checked, and it is determined whether the basic configuration value of the current configuration family is marked in at least one vehicle version.

[0122] Step S633: If the basic configuration value of the current configuration family is dotted in at least one vehicle version, the current configuration family is determined as the second configuration family using the first checking method.

[0123] Step S634: if the basic configuration value of the current configuration family has no dot in all vehicle versions, the current configuration family is determined as the third configuration family using the second checking method.

[0124] Step S640 , based on the vector database and the second engineering material list of the second vehicle model room, different checking methods are used to perform integrity checks on the material lists of the second configuration family and the third configuration family respectively.

[0125] For ease of understanding, the integrity check process of the bill of materials of the second configuration family and the third configuration family is described below respectively.

[0126] In one embodiment, based on the vector database and the second engineering bill of materials for the second vehicle model room, a bill of materials integrity check is performed on the second configuration family, including:

[0127] Step S641-1, based on the second engineering material list, generate second high-dimensional vector data corresponding to the second configuration family; the second high-dimensional vector data includes: a second part combination semantic description string, a second hash code, and a second n-dimensional vector data. The implementation process of this step can refer to steps S200 to S400 in the aforementioned embodiment, and the specific description is not expanded.

[0128] Step S641 - 2 , querying in the vector database whether there is a second hash code.

[0129] Step S641 - 3 : If it exists, it is determined that the second configuration family check has passed.

[0130] Step S641-4: if it does not exist, then use the second n-dimensional vector data and a preset similarity algorithm to search in the vector database for a third part combination semantic description character string that is closest to the second part combination semantic description character string.

[0131] In specific implementation, the "configuration code" is first used to narrow the range of vector data to be compared in the vector database, and then the second n-dimensional vector data to be checked is used and a similarity algorithm (such as a cosine distance algorithm) is used to search the vector database to obtain the third n-dimensional vector data with the closest similarity distance, and the part combination semantic description string corresponding to the third n-dimensional vector data is determined as the third part combination semantic description string. It can be understood that the third part combination semantic description string determined in the above manner is the historical part combination semantic description string that is closest to the second part combination semantic description string.

[0132] Step S641 - 5 , converting the second part combination semantic description character string and the third part combination semantic description character string into the part combination to be checked and the most recent part combination in history, respectively.

[0133] Reference Fig.10 , convert the second part combination semantic description string to obtain a table-style part combination to be checked; convert the third part combination semantic description string to obtain a table-style historically most recent part combination. The above-mentioned part combination to be checked can also be called a part combination of XXX configuration value to be checked, and correspondingly, a historically most recent part combination can also be called a part combination with the most similar XXX configuration value history.

[0134] Step S641 - 6 , for any functional location description, if any functional location description exists in both the part combination to be checked and the most recent part combination in history, it is determined that any functional location description has passed the check.

[0135] Specifically, it is determined whether any functional position description in the part combination to be checked exists in the most recent part combination in history, and it is determined whether any functional position description in the most recent part combination in history exists in the part combination to be checked.

[0136] If any functional location description exists in both the part combination to be checked and the most recent part combination in history, it is determined that any functional location description has passed the check.

[0137] Step S641-7: If any functional position description does not exist in the part combination to be checked, then the integrity check result of any functional position description is determined to be missing part.

[0138] For example Fig.11 If it is determined that the functional position description of the "suspension adjustment switch" does not exist in the part combination to be checked, but exists in the most recent part combination in history, then the integrity check result of the functional position description of the "suspension adjustment switch" is determined to be missing parts.

[0139] Step S641-8: If any functional location description does not exist in the most recent historical parts combination, then the integrity check result of any functional location description is determined to be redundant parts.

[0140] For example Fig.11 If it is determined that the functional position description of the "left front suspension coil spring" exists in the part combination to be checked and does not exist in the most recent part combination in history, then the integrity check result of the functional position description of the "left front suspension coil spring" is determined to be redundant parts.

[0141] In one embodiment, based on the vector database and the second engineering bill of materials for the second vehicle model room, a completeness check of the bill of materials for the third configuration family is performed, including:

[0142] Step S642-1, solve the second engineering material list and output the parts list of a single vehicle model. Fig.12 , use the engineering configuration table of the second vehicle model room to be checked, call the preset method to solve the second engineering material list of the second vehicle model room, and output the parts list of a single vehicle version; wherein each vehicle version corresponds to a parts list.

[0143] Step S642-2, taking the parts list of each vehicle version as the current parts list one by one; checking the configuration values ​​in the current parts list that are simultaneously present in the third configuration family, and taking the checked configuration values ​​as the configuration values ​​to be checked.

[0144] For example Fig.12 In the example, the CA04 configuration value of version 3 is dotted, and its configuration family CA00 is in the third configuration family using the second inspection method, so the configuration value is determined to be a pending configuration value that needs to be further inspected.

[0145] Step S642-3, query the vector database for a fourth part combination semantic description string that matches the configuration value to be checked.

[0146] Step S642-4: when there is only one string of the fourth part combination semantic description string, the fourth part combination semantic description string is used as a necessary parts list of the configuration value to be checked.

[0147] Step S642-5: when there are multiple fourth part combination semantic description character strings, the intersection of the multiple fourth part combination semantic description character strings is used as the necessary parts list of the configuration value to be checked.

[0148] Specifically, refer to Fig.13, when there are multiple fourth part combination semantic description strings, take the intersection of the functional position descriptions of the multiple fourth part combination semantic description strings (using lighter text descriptions), including: air suspension controller, left rear air spring, right rear air spring, rear air tank air line, left rear airbag air line, right rear airbag air line, air suspension compressor assembly, suspension adjustment switch; use the above intersection as the necessary parts list for the configuration value to be checked.

[0149] Step S642-6, check whether the necessary parts list of the configuration value to be checked exists in the current parts list.

[0150] Step S642-7, if it exists, confirm that the inspection is passed, if it does not exist, generate a mark indicating that the part is missing. Fig.14 The suspension adjustment switch corresponding to 4EC-1003A does not exist in the currently inspected parts combination, and the inspection result is determined to be missing parts.

[0151] In summary, the vehicle bill of materials management method provided by the embodiment of the present disclosure includes: receiving a warehousing request, the warehousing request including: a first configuration family and its corresponding first basic configuration value; based on the engineering configuration table of the historical vehicle model room, querying the first vehicle model room and the dot configuration value matching the first configuration family; based on the first engineering bill of materials of the first vehicle model room, screening the part combination relationship set of the dot configuration value relative to the first basic configuration value; converting the functional position description contained in the part combination relationship set into natural language data; storing the dot configuration value and the natural language data as first high-dimensional vector data in a preset vector database; and performing an integrity check of the bill of materials based on the vector database.

[0152] In the case where the first configuration family needs to be put into storage, the technical solution first searches for the first vehicle model room suitable for data analysis of the first configuration family based on the engineering configuration table of the historical vehicle model room; then uses the first engineering material list of the first vehicle model room to automatically analyze and summarize the correct part combination dedicated to a single configuration function, that is, the part combination relationship set, and converts the functional position description in the part combination relationship set into natural language data: the first part combination semantic description string, the first hash code and the first n-dimensional vector data; converts the above natural language data that is easy for machine processing into the first high-dimensional vector data and saves it in the vector database. The above process can use the engineering configuration table and engineering material list of the historical vehicle model room to automatically generate natural language data representing the functional position description for the configuration family that needs to be put into storage. In this way, when faced with complex and uncertain functional configuration changes, the automatic generation of natural language data describing the functional position can be efficiently realized without manual intervention, thereby improving the quality of part data and management efficiency.

[0153] Moreover, after generating a vector database containing a large amount of natural language data, when a new project needs to check the integrity of the bill of materials, if these configuration functions are also included in the engineering configuration table, the configuration and part combination relationship of the vehicle model are also converted into high-dimensional vector data, and then searched in the above vector database to confirm whether there is an identical part combination scheme or return the most similar part combination scheme. By comparing the differences of similar schemes, problems such as redundant parts and missing parts in the bill of materials are identified, and the quality of the bill of materials data is improved. At the same time, the intelligence level of the bill of materials inspection is enhanced, thereby improving labor efficiency, ultimately shortening the product development cycle, accelerating the product iteration process, and improving product competitiveness.

[0154] Corresponding to the above method embodiment, the present invention also provides a vehicle bill of materials management device, such as Fig.15 As shown, the device comprises:

[0155] The storage request module 710 is used to receive a storage request, wherein the storage request includes: a first configuration family and a first basic configuration value corresponding thereto;

[0156] The vehicle model room query module 720 is used to query the first vehicle model room and the dot configuration value that matches the first configuration family based on the engineering configuration table of the historical vehicle model room; wherein the dot configuration value is the configuration value of the first configuration family used to calculate the configuration and part combination relationship in the first vehicle model room;

[0157] A parts combination relationship screening module 7730 is used to screen a parts combination relationship set of the dot configuration value relative to the first basic configuration value based on the first engineering material list of the first vehicle model room;

[0158] A data conversion module 740, used to convert the functional position description contained in the part combination relationship set into natural language data;

[0159] A data storage module 750 is used to store the dot configuration value and the natural language data as first high-dimensional vector data into a preset vector database;

[0160] The bill checking module 760 is used to perform integrity check of the bill of materials based on the vector database.

[0161] The vehicle bill of materials management device provided in this embodiment has the same implementation principle and technical effects as those of the aforementioned vehicle bill of materials management method embodiment. For the sake of brief description, for matters not mentioned in the device embodiment, reference may be made to the corresponding contents in the aforementioned vehicle bill of materials management method embodiment.

[0162] Fig.16 The structure diagram of an electronic device provided by the embodiment of the present disclosure is shown in FIG. Fig.16 As shown, the electronic device 800 includes one or more processors 801 and a memory 802 .

[0163] The processor 801 may be a central processing unit (CPU) or other forms of processing units having data processing capabilities and / or instruction execution capabilities, and may control other components in the electronic device 800 to perform desired functions.

[0164] The memory 802 may include one or more computer program products, which may include various forms of computer-readable storage media, such as volatile memory and / or non-volatile memory. The volatile memory may include, for example, random access memory (RAM) and / or cache memory (cache), etc. The non-volatile memory may include, for example, read-only memory (ROM), hard disk, flash memory, etc. One or more computer program instructions may be stored on the computer-readable storage medium, and the processor 801 may run the program instructions to implement the vehicle bill of materials management method of the embodiment of the present disclosure described above and / or other desired functions. Various contents such as input signals, signal components, noise components, etc. may also be stored in the computer-readable storage medium.

[0165] In one example, the electronic device 800 may further include: an input device 803 and an output device 804, and these components are interconnected via a bus system and / or other forms of connection mechanisms (not shown).

[0166] In addition, the input device 803 may also include, for example, a keyboard, a mouse, etc.

[0167] The output device 804 can output various information to the outside, including the determined distance information, direction information, etc. The output device 804 can include, for example, a display, a speaker, a printer, a communication network and a remote output device connected thereto, and the like.

[0168] Of course, to simplify, Fig.16 Only some of the components related to the present disclosure in the electronic device 800 are shown, and components such as a bus, an input / output interface, etc. are omitted. In addition, according to specific application situations, the electronic device 800 may also include any other appropriate components.

[0169] Furthermore, this embodiment also provides a computer-readable storage medium, wherein the storage medium stores a computer program, and the computer program is used to execute the above-mentioned vehicle material list management method.

[0170] A computer program product of a vehicle bill of materials management method, device, electronic device and medium provided in the embodiments of the present disclosure includes a computer-readable storage medium storing program code. The instructions included in the program code can be used to execute the methods described in the previous method embodiments. The specific implementation can be found in the method embodiments, which will not be repeated here.

[0171] It should be noted that, in this article, relational terms such as "first" and "second" are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the existence of other identical elements in the process, method, article or device including the elements.

[0172] The above description is only a specific embodiment of the present disclosure, so that those skilled in the art can understand or implement the present disclosure. Various modifications to these embodiments will be apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present disclosure. Therefore, the present disclosure will not be limited to the embodiments described herein, but will conform to the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A method for managing a vehicle bill of materials, characterized in that: The method comprises: Receive a storage request, wherein the storage request includes: a first configuration family and a first basic configuration value corresponding thereto; Based on the engineering configuration table of the historical vehicle model room, query the first vehicle model room and the dot configuration value that matches the first configuration family; wherein the dot configuration value is the configuration value of the first configuration family used to calculate the configuration and part combination relationship in the first vehicle model room; Based on the first engineering material list of the first vehicle model room, screening the part combination relationship set of the dot configuration value relative to the first basic configuration value; Converting the functional position description contained in the part combination relationship set into natural language data; Storing the dot configuration value and the natural language data as first high-dimensional vector data in a preset vector database; A completeness check of the bill of materials is performed based on the vector database.

2. The method according to claim 1, characterized in that The engineering configuration table based on the historical vehicle model room, querying the first vehicle model room and the dot configuration value matching the first configuration family, includes: Use each historical model room as the current model room one by one; Determine whether the first basic configuration value exists in the engineering configuration table of the current vehicle type room; If the first basic configuration value exists, determining whether the first basic configuration value has a dot in at least one vehicle version; If there is a dot, determine whether there is at least one other configuration value in the engineering configuration table of the current vehicle model room in addition to the first basic configuration value, and the at least one other configuration value has a dot in at least one vehicle version; If there is at least one other configuration value that is dotted in at least one vehicle version, the current vehicle model room is determined to be the first vehicle model room matching the first configuration family; and the at least one other configuration value is determined as a dotted configuration value under the first configuration family for calculating the configuration and parts combination relationship.

3. The method according to claim 1, characterized in that: The first engineering material list based on the first vehicle model room, screening the part combination relationship set of the dot configuration value relative to the first basic configuration value, comprises: Obtain a first engineering material list for the room of the first vehicle type; wherein the first engineering material list includes: configuration variables, function location codes and BOM line identifiers; Based on the configuration variable, the function position code and the BOM line identifier, respectively selecting a first target part line set including the first basic configuration value and a second target part line set including the dot configuration value in the first engineering bill of materials; Based on the first target part row set and the second target part row set, a part combination relationship set of the dotting configuration value under the first configuration family relative to the first basic configuration value is calculated.

4. The method according to claim 3, characterized in that The method of selecting a first target part row set including the first basic configuration value and a second target part row set including the dot configuration value in the first engineering bill of materials based on the configuration variable, the function position code and the BOM line identifier includes: Filtering a first set of part rows to be analyzed in the first engineering bill of materials; Filtering a second part row set including the first basic configuration value and the dotting configuration value in the first part row set according to the configuration variable; De-duplicate the second part row set according to the function position code to obtain a third part row set; Determining, according to the BOM row identifier, whether the part row data of the third part row set is greater than the part row data of the second part row set; If more than, processing the configuration variables of the redundant part row data in the third part row set, and using the processed third part row set as the fourth part row set; If not more than, the third part row set is used as the fourth part row set; According to the configuration variables, a first target part row set including the first basic configuration value and a second target part row set including the dotting configuration value are respectively screened in the fourth part row set.

5. The method according to claim 1, characterized in that: The step of converting the functional position description contained in the part combination relationship set into natural language data includes: Converting the functional position description contained in the part combination relationship set into a first part combination semantic description character string; Calculate a first hash code corresponding to the first part combination semantic description string; Generate first n-dimensional vector data of the first part combination semantic description string according to the vector model; The first part combination semantic description string, the first hash code and the first n-dimensional vector data are used as natural language data.

6. The method according to claim 1, characterized in that The integrity check of the bill of materials based on the vector database includes: receiving an inspection request, wherein the inspection request includes: a room of a second vehicle type to be inspected; Based on the engineering configuration table of the room of the second vehicle type, a target configuration family set within a preset configuration range is screened; Determine a second configuration family and a third configuration family in the target configuration family set that need to be checked and have different checking methods; Based on the vector database and the second engineering material list of the second vehicle model room, different checking methods are used to perform integrity checks on the material lists of the second configuration family and the third configuration family respectively.

7. The method according to claim 6, characterized in that The determining of the second configuration family and the third configuration family in the target configuration family set that need to be checked and have different checking methods includes: For the current configuration family in the target configuration family set, determining whether other configuration values ​​of the current configuration family other than the basic configuration value are marked in at least one vehicle version in the engineering configuration table of the second vehicle model room; If not, determining that the current configuration family does not need to be checked; If yes, determining that the current configuration family needs to be checked, and determining whether the basic configuration value of the current configuration family has a dot in at least one vehicle version; If yes, the current configuration family is determined as the second configuration family using the first checking method; if no, the current configuration family is determined as the third configuration family using the second checking method.

8. The method according to claim 6, characterized in that Based on the vector database and the second engineering material list of the second vehicle model room, a material list integrity check is performed on the second configuration family, including: Generate second high-dimensional vector data corresponding to the second configuration family based on the second engineering material list; the second high-dimensional vector data includes: a second part combination semantic description string, a second hash code, and a second n-dimensional vector data; Querying whether the second hash code exists in the vector database; If so, determining that the second configuration family check passes; If it does not exist, using the second n-dimensional vector data and a preset similarity algorithm, searching the vector database for a third part combination semantic description string that is closest to the second part combination semantic description string; Convert the second part combination semantic description string and the third part combination semantic description string into a part combination to be checked and a part combination with the most recent history, respectively; For any functional location description, if the any functional location description exists in both the part combination to be checked and the most recent part combination, it is determined that the any functional location description passes the check; If any of the functional position descriptions does not exist in the part combination to be checked, determining that the integrity check result of any of the functional position descriptions is that the part is redundant; If any of the functional location descriptions does not exist in the most recent historical part combination, it is determined that the integrity check result of any of the functional location descriptions is that the part is missing.

9. The method according to claim 6, characterized in that Based on the vector database and the second engineering material list of the second vehicle model room, a material list integrity check is performed on the third configuration family, including: Solving the second engineering material list and outputting a parts list for a single vehicle version; Taking the parts list of each vehicle version as the current parts list one by one; checking the configuration values ​​in the current parts list that are simultaneously present in the third configuration family, and taking the checked configuration values ​​as the configuration values ​​to be checked; Querying the vector database for a fourth part combination semantic description character string that matches the configuration value to be checked; In the case that the fourth part combination semantic description string is one, the fourth part combination semantic description string is used as a necessary parts list of the configuration value to be checked; In the case where there are multiple fourth part combination semantic description character strings, an intersection of the multiple fourth part combination semantic description character strings is used as a necessary parts list for the configuration value to be checked; Check whether the necessary parts list of the configuration value to be checked exists in the current parts list; If it exists, the check is confirmed to pass, if it does not exist, a mark indicating that the part is missing is generated.

10. A vehicle bill of materials management device, characterized in that: The device comprises: A storage request module, configured to receive a storage request, wherein the storage request includes: a first configuration family and a first basic configuration value corresponding thereto; A vehicle model room query module, used to query the first vehicle model room and the dot configuration value matching the first configuration family based on the engineering configuration table of the historical vehicle model room; wherein the dot configuration value is the configuration value of the first configuration family used to calculate the configuration and part combination relationship in the first vehicle model room; A parts combination relationship screening module, for screening a parts combination relationship set of the dot configuration value relative to the first basic configuration value based on the first engineering material list of the first vehicle model room; A data conversion module, used for converting the functional position description contained in the part combination relationship set into natural language data; A data storage module, used for storing the dot configuration value and the natural language data as first high-dimensional vector data into a preset vector database; A list checking module is used to perform a completeness check on the bill of materials based on the vector database.

11. An electronic device, characterized in that: The electronic device comprises: processor; a memory for storing instructions executable by the processor; The processor is used to read the executable instructions from the memory and execute the instructions to implement the vehicle material list management method described in any one of claims 1-9.

12. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores instructions, and when the instructions are executed on a terminal device, the terminal device implements the vehicle bill of materials management method as described in any one of claims 1-9.

Images