Configuration-based BOM solution system and method based on master-slave database

Abstract

The present invention discloses a configuration-based BOM solution architecture, system and method based on a master-slave database, and relates to the technical field of automobile configuration-based BOM solution. The architecture includes a master database, a task scheduling server deployment, and the master database is configured as a main storage database for business data, and the master database is used to receive vehicle model solution requests, task decomposition, result merging, and synchronize business data to a slave database from other systems; the task scheduling server deployment is used to perform decomposition task calls, slave node solution program calls and merge task calls; the slave database is configured as a solution node, and the slave database includes a node registration service, and a registration list database is deployed on one of the slave databases. The present invention can solve the problem of vehicle model solution capacity limitation of a single solution node, support the business development trend of multiple vehicle models and multiple options, and realize that the solution capacity can be infinitely expanded, and completely solve the capacity limitation problem of configuration solution.

Description

Technical Field

[0001] The present invention relates to the technical field of automobile configured BOM (Bill of Material) solution, and in particular to a configured BOM solution system based on a master-slave database, a configured BOM solution method based on a master-slave database, a configured BOM solution verification method based on a master-slave database, and a configured BOM solution extension method based on a master-slave database. Background Art

[0002] With the full promotion and implementation of vehicle configuration management, the current single-node solution computing architecture for configured BOM has become increasingly unsuitable for the development of automobile manufacturers, especially as vehicle configuration management has brought about a large number of differentiated configurations and options. Single-node computing is not only inefficient, but also difficult to meet customers' personalized needs for customized options. Therefore, how to solve the bottleneck of solution and realize flexible expansion of solution capabilities is an urgent problem to be solved. Summary of the invention

[0003] In view of the defects existing in the prior art, the purpose of the present invention is to provide a configurable BOM solution architecture, system and method based on a master-slave database, which can solve the problem of vehicle model solution capacity limitation of a single solution node, support the business development trend of multiple vehicle models and multiple options, and realize unlimited expansion of the solution capacity, completely solving the capacity limitation problem of configuration solution.

[0004] To achieve the above objectives, the present invention provides a configurable BOM solution architecture based on a master-slave database, comprising:

[0005] A master database, which is configured as a main storage database for business data, and is used to receive vehicle model solution requests, task decomposition, result merging, and synchronize business data with slave databases from other systems;

[0006] Task scheduling server deployment, which is used to perform decomposition task calls, slave node solver calls, and merge task calls;

[0007] A plurality of slave databases configured to solve nodes, wherein the slave databases include a node registration service, and a registration list database is deployed on one of the slave databases;

[0008] Among them, all node registration services of the slave database register the node status information to the registration list database for call by the task scheduling service. The slave database is used to synchronize the business data of the main database, and a configured BOM solution program is deployed on the slave database for vehicle model BOM solution of a single solution node.

[0009] The present invention provides a configuration-based BOM solution system based on a master-slave database, which is implemented based on the configuration-based BOM solution architecture described above and includes:

[0010] The master-slave database data synchronization module is used to synchronize business data between the master database and the slave database in real time;

[0011] A node registration module is used to register solution nodes and solution node types, and obtain a list of available solution node registrations for decomposition task calls;

[0012] The decomposition task calling module is used to obtain the available solving nodes and solving node types from the solving node registration list, select the available solving nodes, dynamically allocate tasks, and start the solving tasks on the available solving nodes;

[0013] An over-threshold alarm module is used to set the thresholds for the number of solvable vehicle models for single nodes and multiple nodes of different types of solution nodes, and to detect whether the number of input solution vehicles exceeds the set threshold for the number of solvable vehicle models for multiple nodes;

[0014] A task decomposition module, which is used to split the list of solved models of a single solving node according to the list of solved models, the available solving nodes and the types of available solving nodes in the registration list of available solving nodes, and the solving threshold;

[0015] The node calling module is used to call the configured BOM solving program in the solving node according to the solving vehicle model list of each solving node;

[0016] The configuration BOM calculation module is used to calculate the full BOM data of a single vehicle model based on the configuration information of the single vehicle model, the block configuration expression, the color configuration expression and the calculation rules of the configuration expression;

[0017] The merge task calling module is used to monitor the completion status of the solution task of each solution node, and drive the multi-node merge module to work when the solution task of the solution node is completed;

[0018] The multi-node merging module is used to write the node result data of the solving nodes that have completed the solving task to the merged database, and when the node result data of all the solving nodes are written to the merged database, write the merged database to the interface for other systems to read.

[0019] Based on the above technical solutions,

[0020] The master-slave database data synchronization module includes a master-slave database operating system, database software and a data synchronization component;

[0021] The data synchronization component is a log-based structured replication software that obtains data changes by capturing the online redo log or archive log of the master database to form a queue file, and then transmits the queue file to the slave database through a network protocol, so that the slave database parses the queue file, thereby completing the real-time synchronization of business data between the master database and the slave database.

[0022] Based on the above technical solutions,

[0023] The node registration module includes a non-relational database, a solution node list unit, a solution node registration unit and a solution node monitoring agent unit;

[0024] The non-relational database is a key-value database, and the non-relational database is stored in a high-speed cache to store a registration list of solution nodes, and the registration list of solution nodes includes solution node data source information;

[0025] The solution node list unit is used to store data source information of the solution nodes, and the data source information includes configuration of the solution nodes, the number of solution nodes, operation status of the solution nodes and data consistency of the solution nodes;

[0026] The solution node monitoring agent unit is used to refresh the data source information of the current solution node and synchronize it with the data source information of other solution nodes.

[0027] Based on the above technical solutions,

[0028] The over-threshold alarm module includes a threshold value setting unit and an over-threshold alarm unit;

[0029] The solution threshold setting unit is used to set the thresholds of the number of vehicle models that can be solved for single nodes and multiple nodes of different types of solution nodes;

[0030] The over-threshold alarm unit is used to detect whether the number of input solved vehicle models exceeds the set multi-node solvable vehicle model number threshold, and to issue an alarm message when the threshold is exceeded.

[0031] The present invention provides a configuration-based BOM solution method based on a master-slave database, which is implemented based on the configuration-based BOM solution system described above and specifically includes the following steps:

[0032] The task scheduling service receives the solution request of the vehicle model list and calls the decomposition task program of the main database;

[0033] The main database evenly distributes the vehicle model list to the available solution nodes according to the vehicle model list to realize the distribution of solution tasks;

[0034] The task scheduling service schedules the corresponding solution nodes to start the configured BOM solution program according to the solution tasks assigned by the main database;

[0035] The task scheduling service monitors the execution status of the solution task of each solution node, and calls the merge task service when the solution task of the solution node is completed;

[0036] The merge task service merges the node result data of the solved nodes and writes them to the interface so that other systems can obtain the BOM data of the vehicle model requested in the solution request from the interface.

[0037] Based on the above technical solution, the task scheduling service receives the solution request of the vehicle model list and calls the decomposition task program of the main database at the same time. The specific steps include:

[0038] The task scheduling service receives the solution request of the vehicle model list, checks the node status of the registered solution nodes, and calls the decomposition task program.

[0039] On the basis of the above technical solution, the master database evenly distributes the vehicle model list to the available solution nodes according to the vehicle model list, and the specific steps include:

[0040] The master database evenly distributes the vehicle model list to the available solving nodes according to the vehicle model list, the threshold value of the number of solvable vehicle models of the registered solving nodes, and the number of available solving nodes.

[0041] The present invention provides a configuration-based BOM solution verification method based on a master-slave database, which is used to verify the configuration-based BOM solution method described above, and specifically includes the following steps:

[0042] Based on the configured BOM solution architecture, a preset number of solution nodes are newly constructed;

[0043] Simulate node abnormalities to verify the availability of the solution function and the operation status of the alarm mechanism of the newly built solution node;

[0044] Test the single-node performance of the newly constructed solving node to set the single-node solving threshold of the newly constructed solving node;

[0045] Test the node integration performance of the newly constructed solving node to set the multi-node solving threshold of the newly constructed solving node;

[0046] Synchronize production data to the test environment to test the integration performance of the newly built solving nodes, and check the consistency of the single-node and multi-node solving data of the newly built solving nodes, and judge the solving function of the newly built solving nodes based on the test and verification results;

[0047] Conduct joint debugging tests to verify whether the newly built solution node is operating normally by actually connecting to the interface.

[0048] The present invention provides a configuration-based BOM solution extension method based on a master-slave database, which is used to extend the configuration-based BOM solution system described above, and specifically includes the following steps:

[0049] Prepare solution node resources that match the current configured BOM solution architecture, install and configure the master-slave data synchronization service to synchronize data to the newly added solution nodes;

[0050] Install the application container, deploy and configure the node registration service and email reminder service.

[0051] Compared with the prior art, the advantages of the present invention are: by setting up master-slave database data synchronization, node registration, decomposition task call, over-threshold alarm, task decomposition, node call, configured BOM solution, merged task call, and multi-node result merging, the problem of vehicle model solution capacity limitation of a single solution node is solved, the business development trend of multiple vehicle models and multiple options is supported, and the solution capacity can be infinitely expanded, which completely solves the capacity limitation problem of configuration solution. BRIEF DESCRIPTION OF THE DRAWINGS

[0052] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings required for use in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0053] Figure 1 It is a structural diagram of a configurable BOM solution architecture based on a master-slave database in an embodiment of the present invention;

[0054] Figure 2 It is a detailed diagram of the configurable BOM solution architecture;

[0055] Figure 3 A schematic diagram of the data flow of the configurable BOM solution architecture;

[0056] Figure 4 A detailed flowchart of the configured BOM solution method. DETAILED DESCRIPTION

[0057] In order to make the purpose, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments.

[0058] See also Figure 1 As shown, an embodiment of the present invention provides a configurable BOM solution architecture based on a master-slave database, including a master database, a task scheduling server deployment and multiple slave databases.

[0059] The master database is configured as the main storage database for business data. The master database is used to receive vehicle model solution requests, task decomposition, result merging from other systems, and synchronize business data to the slave database; the task scheduling server is deployed to perform decomposition task calls, slave node solution program calls and merge task calls; the slave database is configured as a solution node, and the slave database includes a node registration service, and a registration list database is deployed on one of the slave databases.

[0060] All node registration services of the slave database register the node status information to the registration list database for call by the task scheduling service. The slave database is used to synchronize the business data of the master database, and a configured BOM solution program is deployed on the slave database for vehicle model BOM solution of a single solution node.

[0061] An embodiment of the present invention also provides a configured BOM solution system based on a master-slave database, which is implemented based on the above-mentioned configured BOM solution architecture. The configured BOM solution system includes a master-slave database data synchronization module, a node registration module, a decomposition task calling module, an over-threshold alarm module, a task decomposition module, a node calling module, a configured BOM solution module, a merged task calling module and a multi-node merge module.

[0062] The master-slave database data synchronization module is used to synchronize the business data between the master database and the slave database in real time, so as to ensure the consistency of the solution input data of each solution node; the node registration module is used to register the solution nodes and the solution node types, and obtain the available solution node registration list for decomposition task calling; the decomposition task calling module is used to obtain the available solution nodes and solution node types from the solution node registration list, select the available solution nodes, dynamically allocate tasks, and start the solution task on the available solution nodes; the over-threshold alarm module is used to set the threshold value of the number of single-node and multi-node solvable vehicle models of different types of solution nodes, and detect whether the number of input solution models exceeds the set multi-node solvable vehicle model threshold; the task decomposition module is used to calculate the number of available solution nodes and available solution nodes in the solution model list, the available solution node registration list, and the available solution node registration list. The solution node type and the solution threshold are used to split the solution vehicle list of a single solution node; the node calling module is used to call the configured BOM solution program in the solution node according to the solution vehicle list of each solution node; the configured BOM solution module is used to calculate the full BOM data of a single vehicle model according to the configuration information, block configuration expression, color configuration expression and the operation rules of the configuration expression of a single vehicle model; the merge task calling module is used to monitor the completion status of the solution task of each solution node, and drive the multi-node merging module to work after the solution task of the solution node is completed; the multi-node merging module is used to write the node result data of the solution node that completes the solution task to the merged database, and when the node result data of all solution nodes are written to the merged database, the merged database is written to the interface for other systems to read. The single node in the present invention refers to a single solution node working alone, and the multi-node refers to multiple solution nodes working simultaneously.

[0063] In an embodiment of the present invention, a master-slave database data synchronization module includes a master-slave database operating system, database software and a data synchronization component; the data synchronization component is a log-based structured replication software, which obtains data changes by capturing the online redo log or archive log of the master database to form a queue file, and then transmits the queue file to the slave database through a network protocol, so that the slave database parses the queue file, thereby completing the real-time synchronization of business data between the master database and the slave database.

[0064] In an embodiment of the present invention, a node registration module includes a non-relational database, a solution node list unit, a solution node registration unit and a solution node monitoring agent unit; the non-relational database is a key-value database, and the non-relational database is stored in a cache to store a registration list of solution nodes, and the registration list of solution nodes includes solution node data source information; the solution node list unit is used to store the data source information of the solution node, and the data source information includes the configuration of the solution node, the number of solution nodes, the operating status of the solution node and the data consistency of the solution node; the solution node monitoring agent unit is used to refresh the data source information of the current solution node and synchronize it with the data source information of other solution nodes.

[0065] In an embodiment of the present invention, the over-threshold alarm module includes a solution threshold setting unit and an over-threshold alarm unit; the solution threshold setting unit is used to set the thresholds for the number of single-node and multi-node solvable vehicle models of different types of solution nodes; the over-threshold alarm unit is used to detect whether the number of input solution vehicle models exceeds the set threshold for the number of multi-node solvable vehicle models, and to issue an alarm message when the threshold is exceeded.

[0066] See also Figure 2As shown, it is a specific schematic diagram of the configured BOM solution architecture in the present invention. AppSrv is an application server deployed based on JBoss, which is used to intercept all database operations and write database operation transactions into the main database transaction registration queue; DB (Master) is a BOM data master database built based on Oracle database, which is used to store all product data and manufacturing data required for solution and database operation transaction queue; the transaction registration queue is an entity table in the database, which is used to store all database operation transactions issued by AppSrv; OGG is a comprehensive software package provided by Oracle for real-time data integration and replication, which is used in the present invention to synchronize the data of the master database to the slave database in real time, to ensure the consistency of the master-slave data, thereby ensuring the consistency of the BOM solution results. In particular, in the present invention, only the data required for configuration solution is synchronized. MQ (AMQ Cluster) is an open source, Java-based message middleware provided by Apache. In this implementation case, it is used to synchronize the database operation transactions intercepted by AppSrv to the slave database through the message queue; CCAgent is a Java application deployed based on TOMCAT, which is used to synchronize the database operation transactions of the master database from the message queue to the slave database, and read the database operation transactions synchronized by OGG, compare the consistency of the two, and write the comparison status (consistent / inconsistent) to the calculation node list of the Redis cache; Cache (Redis Cluster) is a cache database deployed based on Redis, which is used to store node data source information; PI is a task scheduler deployed based on JBoss, which is used to read the node information registered in the cache and assign calculation tasks (car model list) to available nodes; after the task is decomposed to the slave database, the configured BOM solver in the slave database calculates each car model to form a single car model BOM.

[0067] See also Figure 3 As shown, it is a schematic diagram of the data flow of the configured BOM solution architecture in the present invention. Figure 3 In , List means list.

[0068] The embodiment of the present invention further provides a configuration-based BOM solution method based on a master-slave database, which is implemented based on the configuration-based BOM solution system described above. The configuration-based BOM solution method specifically includes the following steps:

[0069] S1: The task scheduling service receives the solution request of the vehicle model list and calls the decomposition task program of the main database;

[0070] S2: The main database evenly distributes the vehicle model list to the available solution nodes according to the vehicle model list to realize the distribution of solution tasks;

[0071] S3: The task scheduling service schedules the corresponding solution nodes to start the configured BOM solution program according to the solution tasks assigned by the main database;

[0072] S4: The task scheduling service monitors the execution status of the solution task of each solution node, and calls the merge task service when the solution task of the solution node is completed;

[0073] S5: The merge task service merges the node result data of the solved nodes and writes them to the interface so that other systems can obtain the BOM data of the vehicle model requested in the solution request from the interface.

[0074] In an embodiment of the present invention, the task scheduling service receives a solution request for a vehicle model list and simultaneously calls a decomposition task program of a main database. The specific steps include: the task scheduling service receives a solution request for a vehicle model list, checks the node status of a registered solution node, and simultaneously calls the decomposition task program.

[0075] In an embodiment of the present invention, the main database evenly distributes the vehicle model list to the available solving nodes according to the vehicle model list. The specific steps include: the main database evenly distributes the vehicle model list to the available solving nodes according to the vehicle model list, the threshold value of the number of solvable vehicle models of the registered solving nodes, and the number of available solving nodes.

[0076] The configured BOM solving method based on the master-slave database in the embodiment of the present invention solves the problem of vehicle model solving capacity limitation of a single solving node by setting master-slave database data synchronization, node registration, decomposition task call, over-threshold alarm, task decomposition, node call, configured BOM solving, merged task call, and multi-node result merging, supports the business development trend of multiple vehicle models and multiple options, and realizes unlimited expansion of the solving capacity, completely solving the capacity limitation problem of configuration solving.

[0077] See also Figure 4 As shown, it is a detailed flow chart of the configured BOM solving method of the present invention.

[0078] The embodiment of the present invention further provides a configuration-based BOM solution verification method based on a master-slave database, which is used to verify the configuration-based BOM solution method described above. The configuration-based BOM solution verification method specifically includes the following steps:

[0079] A: Based on the configurable BOM solution architecture, a preset number of solution nodes are newly constructed; specifically, the number of newly constructed solution nodes may be 3.

[0080] B: Simulate node abnormalities to verify the availability of the solution function and the operation status of the alarm mechanism of the newly built solution node;

[0081] C: Test the single-node performance of the newly constructed solving node to set the single-node solving threshold of the newly constructed solving node;

[0082] D: Test the node integration performance of the newly constructed solving node to set the multi-node solving threshold of the newly constructed solving node;

[0083] E: Synchronize production data to the test environment to detect the integrated performance of the newly built solving nodes, and check the consistency of the single-node and multi-node solving data of the newly built solving nodes, and judge the solving function of the newly built solving nodes based on the detection and verification results;

[0084] F: Conduct joint debugging test to verify whether the newly built solution node is running normally by actually connecting to the interface.

[0085] In the present invention, the node integration performance test of the newly built solution node is carried out, and the test process is as follows: set the network abnormality, and test the availability of 1 solution node, 2 solution nodes, and 3 solution nodes respectively. The goal to be achieved is: the available solution node is successfully registered, and the available solution node can be solved normally if the threshold is not exceeded. If the threshold is exceeded, an email reminder is sent and no solution is performed;

[0086] The node integration performance test of the newly built solution node also includes: simulation request, the number of vehicle models is 30, 50, 70, and 100 respectively, and the threshold is set for parallel solution at each stage. The goals to be achieved are: main database task decomposition, 3 solution nodes complete the solution normally, and the main database completes the merger and sends the BOM solution completion to the interface.

[0087] The single-node performance test of the newly built solving node is carried out in the following process: taking the solving performance of the production environment as the goal, the real vehicle model data of the production environment is used on the single node of the test environment to solve the 100, 200, 300, 500, and 600 vehicle models respectively, and the performance of the solving nodes with different performance is optimized. The goals to be achieved are: 1. The solving performance of the physical server is consistent with that of the production environment; 2. The performance of the virtual node reaches the expected goal.

[0088] The node integration performance test and tuning of the newly built solving nodes are as follows: the 3 solving nodes are used to solve in parallel with 1500 car models of production environment data. The goal to be achieved is that the parallel solving performance of the 3 solving nodes is equal to the sum of the solving performance of each solving node.

[0089] The newly built solving nodes are tested in parallel. The testing process is as follows: synchronize the vehicle model requests from the production environment to the test environment every day, solve the production environment and the test environment synchronously, and compare the solving time and the solving result data difference. The goals to be achieved are: 1. The parallel solving function of the three solving nodes is normal; 2. The parallel solving time and the calculation time of the single solving node meet the performance parameters; 3. The solving results of the two are completely consistent.

[0090] For the joint debugging test of the newly built solution node, the test process is: the docking system sends a vehicle model request to the test environment every night, and its goal is to ensure that the docking system receives data normally.

[0091] The embodiment of the present invention further provides a configuration-based BOM solution extension method based on a master-slave database, which is used to extend the configuration-based BOM solution system described above. The configuration-based BOM solution extension method specifically includes the following steps:

[0092] a: Prepare solution node resources that match the current configured BOM solution architecture (cloud hosts or physical servers can be used, according to the operating system and database, such as cloud hosts can be directly cloned from template machines), install and configure the master-slave data synchronization service to synchronize data to the newly added solution nodes;

[0093] b: Install the application container, deploy and configure the node registration service and email reminder service.

[0094] The configuration-based BOM solution expansion method of the present invention can achieve unlimited expansion of solution resources in theory, and can quickly and elastically scale computing resources according to changes in the number of vehicle models as the business develops.

[0095] In the description of the present application, it should be noted that the terms "upper", "lower", etc. indicate orientations or positional relationships based on the orientations or positional relationships shown in the accompanying drawings, and are only for the convenience of describing the present application and simplifying the description, rather than indicating or implying that the device or element referred to must have a specific orientation, be constructed and operated in a specific orientation, and therefore cannot be understood as a limitation on the present application. Unless otherwise clearly specified and limited, the terms "installed", "connected", and "connected" should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection, or it can be an indirect connection through an intermediate medium, or it can be a connection between the two elements. For those of ordinary skill in the art, the specific meanings of the above terms in the present application can be understood according to the specific circumstances.

[0096] It should be noted that, in this application, 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.

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

Claims

1. A configured BOM solution system based on a master-slave database, implemented according to a configured BOM solution architecture based on a master-slave database, characterized in that: include: The master-slave database data synchronization module is used to synchronize business data between the master database and the slave database in real time; A node registration module is used to register solution nodes and solution node types, and obtain a list of available solution node registrations for decomposition task calls; The decomposition task calling module is used to obtain the available solving nodes and solving node types from the solving node registration list, select the available solving nodes, dynamically allocate tasks, and start the solving tasks on the available solving nodes; An over-threshold alarm module is used to set the thresholds for the number of solvable vehicle models for single nodes and multiple nodes of different types of solution nodes, and to detect whether the number of input solution vehicles exceeds the set threshold for the number of solvable vehicle models for multiple nodes; A task decomposition module, which is used to split the list of solved models of a single solving node according to the list of solved models, the available solving nodes and the types of available solving nodes in the registration list of available solving nodes, and the solving threshold; The node calling module is used to call the configured BOM solving program in the solving node according to the solving vehicle model list of each solving node; The configuration BOM calculation module is used to calculate the full BOM data of a single vehicle model based on the configuration information of the single vehicle model, the block configuration expression, the color configuration expression and the calculation rules of the configuration expression; The merge task calling module is used to monitor the completion status of the solution task of each solution node, and drive the multi-node merge module to work when the solution task of the solution node is completed; A multi-node merging module is used to write the node result data of the solving nodes that have completed the solving task to the merged database, and when the node result data of all the solving nodes are written to the merged database, write the merged database to the interface for other systems to read; The configured BOM solution architecture includes: A master database, which is configured as a main storage database for business data, and is used to receive vehicle model solution requests, task decomposition, result merging, and synchronize business data with slave databases from other systems; Task scheduling server deployment, which is used to perform decomposition task calls, slave node solver calls, and merge task calls; A plurality of slave databases configured to solve nodes, wherein the slave databases include a node registration service, and a registration list database is deployed on one of the slave databases; Among them, all node registration services of the slave database register the node status information to the registration list database for the task scheduling service to call. The slave database is used to synchronize the business data of the master database, and a configurable BOM solution program is deployed on the slave database for the vehicle model BOM solution of a single solution node; in, The master-slave database data synchronization module includes a master-slave database operating system, database software and a data synchronization component; The data synchronization component is a log-based structured replication software, which obtains data changes by capturing online redo logs or archive logs of the master database to form a queue file, and then transmits the queue file to the slave database through a network protocol, so that the slave database parses the queue file, thereby completing the real-time synchronization of business data between the master database and the slave database; in, The node registration module includes a non-relational database, a solution node list unit, a solution node registration unit and a solution node monitoring agent unit; The non-relational database is a key-value database, and the non-relational database is stored in a high-speed cache to store a registration list of solution nodes, and the registration list of solution nodes includes solution node data source information; The solution node list unit is used to store data source information of the solution nodes, and the data source information includes configuration of the solution nodes, the number of solution nodes, operation status of the solution nodes and data consistency of the solution nodes; The solution node monitoring agent unit is used to refresh the data source information of the current solution node and synchronize it with the data source information of other solution nodes.

2. A configurable BOM solution system based on a master-slave database as claimed in claim 1, characterized in that: The over-threshold alarm module includes a threshold value setting unit and an over-threshold alarm unit; The solution threshold setting unit is used to set the thresholds of the number of vehicle models that can be solved for single nodes and multiple nodes of different types of solution nodes; The over-threshold alarm unit is used to detect whether the number of input solved vehicle models exceeds the set multi-node solvable vehicle model number threshold, and to issue an alarm message when the threshold is exceeded.

3. A configuration-based BOM solution method based on a master-slave database, implemented based on the configuration-based BOM solution system of claim 1, characterized in that: The specific steps include: The task scheduling service receives the solution request of the vehicle model list and calls the decomposition task program of the main database; The main database evenly distributes the vehicle model list to the available solution nodes according to the vehicle model list to realize the distribution of solution tasks; The task scheduling service schedules the corresponding solution nodes to start the configured BOM solution program according to the solution tasks assigned by the main database; The task scheduling service monitors the execution status of the solution task of each solution node, and calls the merge task service when the solution task of the solution node is completed; The merge task service merges the node result data of the solved nodes and writes them to the interface so that other systems can obtain the BOM data of the vehicle model requested in the solution request from the interface.

4. A configuration-based BOM solution method based on a master-slave database as claimed in claim 3, characterized in that: The task scheduling service receives the solution request of the vehicle model list and calls the decomposition task program of the main database at the same time. The specific steps include: The task scheduling service receives the solution request of the vehicle model list, checks the node status of the registered solution nodes, and calls the decomposition task program.

5. A configuration-based BOM solution method based on a master-slave database as claimed in claim 4, characterized in that: The master database evenly distributes the vehicle model list to available solution nodes according to the vehicle model list, and the specific steps include: The master database evenly distributes the vehicle model list to the available solving nodes according to the vehicle model list, the threshold value of the number of solvable vehicle models of the registered solving nodes, and the number of available solving nodes.

6. A configuration-based BOM solution verification method based on a master-slave database, used to verify the configuration-based BOM solution method of claim 3, characterized in that: The specific steps include: Based on the configured BOM solution architecture, a preset number of solution nodes are newly constructed; Simulate node abnormalities to verify the availability of the solution function and the operation status of the alarm mechanism of the newly built solution node; Test the single-node performance of the newly constructed solving node to set the single-node solving threshold of the newly constructed solving node; Test the node integration performance of the newly constructed solving node to set the multi-node solving threshold of the newly constructed solving node; Synchronize production data to the test environment to test the integration performance of the newly built solving nodes, and check the consistency of the single-node and multi-node solving data of the newly built solving nodes, and judge the solving function of the newly built solving nodes based on the test and verification results; Conduct joint debugging tests to verify whether the newly built solution node is operating normally by actually connecting to the interface.

7. A configuration-based BOM solution expansion method based on a master-slave database, used to expand the configuration-based BOM solution system described in claim 1, characterized in that: The specific steps include: Prepare solution node resources that match the current configured BOM solution architecture, install and configure the master-slave data synchronization service to synchronize data to the newly added solution nodes; Install the application container, deploy and configure the node registration service and email reminder service.

Images