Production scheduling method and system, electronic equipment and storage medium

Abstract

The production scheduling method comprises the following steps: acquiring original data of a product; process route data of the product is determined based on the original data, the process route data comprises station data of a plurality of stations used for manufacturing the product, and the station data of each station comprises a station identifier, a station type and the position of the station in the process route; wherein the site type comprises a main process site or a non-main process site; determining a main process site among the plurality of sites according to the site type based on the site data of the plurality of sites; generating scheduling data for the product based on the site data of the main process site; and performing production scheduling according to the scheduling data.

Description

Technical Field

[0001] The present disclosure relates to the technical field of production scheduling, and in particular to a production scheduling method, a production scheduling system, an electronic device, a storage medium, and a computer program product. Background Art

[0002] In intelligent production scheduling, the production scheduling system collects various data related to production and manufacturing from various sources and schedules production based on these data. These data include but are not limited to demand data, process route data, etc. However, the collected basic data may not be directly used in the scheduling system for various reasons. Summary of the invention

[0003] Embodiments of the present disclosure provide a production scheduling method, a production scheduling system, an electronic device, a storage medium, and a computer program product.

[0004] According to one aspect of the present disclosure, there is provided a production scheduling method, comprising: acquiring original data of a product; determining process route data of the product based on the original data, wherein the process route data comprises site data of a plurality of sites used to manufacture the product, the site data of each site comprising a site identifier, a site type and a position of the site in the process route, wherein the site type comprises a main process site or a non-main process site; determining a main process site among the plurality of sites according to the site type based on the site data of the plurality of sites; generating scheduling data for the product based on the site data of the main process site; and performing production scheduling according to the scheduling data.

[0005] For example, the method also includes: after determining the main process site, determining the non-main process site corresponding to each main process site according to a preset correspondence between the main process site and the non-main process site; grouping each main process site and the corresponding non-main process site into a group; wherein, generating scheduling data for the product based on the site data of the main process site includes: generating scheduling data for the product based on the site data of the main process site in each group.

[0006] For example, grouping each main process site and the corresponding non-main process site into a group includes: for each main process site, using the site identifier of the main process site as the group identifier; and assigning the group identifier to the main process site and the corresponding non-main process site.

[0007] For example, the original data also includes production data of the multiple sites, and the method also includes: after each main process site and the corresponding non-main process site are grouped together, for the main process site in each group of sites, searching the production data of the non-main process site corresponding to the main process site in the production data of the multiple sites; adding the found production data of the non-main process site to the production data of the main process site; wherein, generating the scheduling data for the product based on the site data of the main process site includes: generating the scheduling data for the product based on the site data and production data of the main process site.

[0008] For example, the production data includes work-in-progress data and takt time data.

[0009] For example, the method further includes: displaying the process route data and group identification of each site; and modifying the group identification of at least one non-main process site to the site identification of the at least one non-main process site according to the received modification instruction.

[0010] For example, generating scheduling data for the product based on the site data of the main process site includes: determining a site whose site identifier is consistent with the group identifier from the multiple sites as the site to be scheduled; and generating scheduling data for the product based on the site data and production data of the site to be scheduled.

[0011] For example, the original data of the product also includes the material data of the product; the method also includes: in response to the lack of process route data of the product in the original data of the product, based on the material data of the product, generating the process route data of the product according to a pre-set correspondence between materials and sites.

[0012] For example, the material data includes multiple materials used to manufacture the product and the hierarchical relationship between the multiple materials; the process route data of the product is generated based on the material data of the product according to the preset correspondence between materials and sites, including: determining multiple materials used to manufacture the product according to the material data of the product; determining the site corresponding to each material according to the preset correspondence between materials and sites; determining the position of the site corresponding to each material in the process route according to the hierarchical relationship between each material; and generating the process route data of the product based on the sites corresponding to the multiple materials and the position of each site in the process route.

[0013] For example, generating the process route data of the product based on the sites corresponding to the multiple materials and the positions of each site in the process route includes: setting the positions of the sites corresponding to the multiple materials in the process route in the order of the levels of the multiple materials from low to high, wherein the site corresponding to the bottom-level material is set as the starting point in the process route.

[0014] For example, when two or more materials correspond to the same site, the position of the corresponding same site in the process route is determined according to the level of one of the two or more materials.

[0015] For example, the method further includes: storing the acquired original data of the product in a temporary database, and storing the generated scheduling data for the product in a basic database.

[0016] For example, the method further includes: generating a data model based on the scheduling data of the product; wherein performing production scheduling according to the scheduling data includes: performing production scheduling based on the generated data model.

[0017] For example, generating a data model based on the scheduling data of the product includes: determining a process route of the product according to the scheduling data of the product, the process route of the product including multiple sites; generating virtual materials for adjacent sites in the process route of the product, the virtual materials carrying the association relationship between the adjacent sites.

[0018] For example, the method further includes: before generating the data model, generating a data snapshot having data version information for the scheduling data of the product; wherein generating the data model includes generating the data model having the data version information based on the data snapshot.

[0019] For example, the method further includes: searching for a data model matching the received data version information among multiple versions of data models according to the received data version information.

[0020] For example, the method further includes: storing the generated data snapshot in a basic database, and storing the generated data model in a modeling transformation database.

[0021] According to another aspect of the present disclosure, an electronic device is provided, including a memory and a processor, wherein the memory stores instructions executable by the processor, and when the instructions are executed by the processor, the processor executes the method of the embodiment of the present disclosure.

[0022] According to another aspect of the present disclosure, a non-transitory computer-readable storage medium storing computer instructions is further provided, wherein the computer instructions are used to enable the computer to execute the method of the embodiment of the present disclosure.

[0023] According to another aspect of the present disclosure, a computer program product is provided, including a computer program, wherein the computer program implements the method of the embodiment of the present disclosure when executed by a processor.

[0024] According to another aspect of the present disclosure, there is provided a production scheduling system, comprising:

[0025] A stored procedure engine, configured to obtain raw data of a product; determine whether the raw data of the product includes process route data of the product, wherein the process route data includes site data of a plurality of sites for manufacturing the product, the site data of each site including a site identifier, a site type, and a position of the site in the process route, wherein the site type indicates whether the site is a main process site or a non-main process site; in response to the raw data of the product including the process route data of the product, determine a main process site among the plurality of sites according to the site type based on the site data of the plurality of sites; and generate scheduling data for the product based on the site data of the main process site;

[0026] A temporary database for storing the original data of the acquired products;

[0027] a basic database, in communication with the temporary database, for storing the generated scheduling data for the product; and

[0028] The scheduling engine is used to perform production scheduling according to the scheduling data.

[0029] For example, the stored process engine is also used to: in response to the lack of process route data of the product in the original data of the product, generate the process route data of the product based on the material data of the product and according to a preset correspondence between the material and the site.

[0030] For example, the stored procedure engine is further used to generate a data snapshot with data version information for the scheduling data of the product, and generate a data model based on the data snapshot;

[0031] The scheduling engine is also used to perform production scheduling based on the data model;

[0032] The basic database is also used to store the data snapshot with data version information;

[0033] The system also includes a modeling conversion database, which is communicatively connected with the basic database and is used to store the data model. BRIEF DESCRIPTION OF THE DRAWINGS

[0034] Figure 1 A flowchart of a production scheduling method 100 according to an embodiment of the present disclosure is shown.

[0035] Figure 2 A schematic diagram of process route data according to an embodiment of the present disclosure is shown.

[0036] Figure 3 A flowchart of a process of generating scheduling data according to an embodiment of the present disclosure is shown.

[0037] Figure 4A The figure shows the site grouping result according to the embodiment of the present disclosure.

[0038] Figure 4B Another site grouping result according to an embodiment of the present disclosure is shown.

[0039] Figure 5 A schematic diagram of in-service data according to an embodiment of the present disclosure is shown.

[0040] Figure 6 A schematic flowchart of a process for generating process route data for a product according to an embodiment of the present disclosure is shown.

[0041] Figure 7 A schematic diagram of material data according to an embodiment of the present disclosure is shown.

[0042] Fig. 8A and Figure 8B A schematic diagram of a data modeling process according to an embodiment of the present disclosure is shown.

[0043] Fig. 9 A schematic diagram of scheduling data with added data version information according to an embodiment of the present disclosure is shown.

[0044] Fig.10 A schematic diagram of a production scheduling system according to an embodiment of the present disclosure is shown.

[0045] Fig.11 A block diagram of an electronic device suitable for implementing a production scheduling method according to an embodiment of the present disclosure is shown. DETAILED DESCRIPTION

[0046] Although the present disclosure will be fully described with reference to the accompanying drawings containing preferred embodiments of the present disclosure, it should be understood before this description that a person of ordinary skill in the art can modify the disclosure described herein while obtaining the technical effects of the present disclosure. Therefore, it should be understood that the above description is a broad disclosure to a person of ordinary skill in the art, and its content is not intended to limit the exemplary embodiments described in the present disclosure.

[0047] In addition, in the detailed description below, for ease of explanation, many specific details are set forth to provide a comprehensive understanding of the disclosed embodiments. However, it is apparent that one or more embodiments may be implemented without these specific details. In other cases, known structures and devices are embodied in a schematic manner to simplify the accompanying drawings.

[0048] Figure 1 A flowchart of a production scheduling method 100 according to an embodiment of the present disclosure is shown.

[0049] In step S110, original data of the product is obtained.

[0050] For example, the original data may include at least one of sales demand data, process route data, production data and material data. For example, the sales demand data may include sales demand related to one or more products, such as order delivery date, sales and inventory plan, etc. The sales demand is used as the input of the system to clarify how many products need to be produced at what time. The products to be scheduled can be determined based on the sales demand data, and then the original data can be obtained for the products to be scheduled. The process route data of the product includes the site data of multiple sites for manufacturing the product, including but not limited to the site identification, site type and the location of the site in the process route, etc. The material data may include multiple materials used to manufacture the product and the hierarchical relationship between the multiple materials. The production data may include work-in-progress data, cycle time data, etc. In some embodiments, the original data may also include other data related to the production and manufacturing of the product, such as but not limited to the production cycle, semi-finished product inventory information, process yield rate, etc.

[0051] The original data can be obtained by the production scheduling system from other business systems. For example, the production scheduling system can obtain sales demand information (such as order delivery, sales and inventory plans, etc.) from the Order Management System (OMS), obtain data related to product or semi-finished product inventory information from the Enterprise Resource Planning (ERP) system, obtain data related to material demand and supply planning from the Material Requirement Planning (MRP) system, obtain data related to production processes from the PLM (Product Lifecycle Management) / MDS (Master Data Management) integrated system, obtain process route data from the Manufacturing Execution System (MES), and obtain data related to revenue, profit or cost planning from the Business Planning and Consolidation (BPC) system. Data exchange can be realized between the above systems. For example, for the MRP system, in addition to providing data related to material demand and supply plan to the production scheduling system, the MPS system can obtain the corresponding production plan from the APS system, obtain the bill of material (BOM) information from the PLM / MDM integrated system, obtain data related to material inventory from the ERP system, and provide material procurement information (such as purchase requisition PR) to the ERP system. Based on the data exchange function between the above systems, the production scheduling system can regularly (or irregularly) obtain the original data of the product for subsequent production scheduling.

[0052] In step S120, it is determined whether the original data of the product includes the process route data of the product. If yes, step S130 is executed.

[0053] The process route data may include site data of multiple sites used to manufacture the product, and the site data of each site includes site identification, site type, and the position of the site in the process route. Taking product X as an example, Figure 2 The process route data of product X is shown. Figure 2 As shown, the process route data of product X includes the site identifiers, site types, and positions of each site in the process route (i.e. Figure 2 ). From Figure 2It can be seen that the process route C1 of product X involves multiple sites, which are represented by site identifiers M10, M21, M11, M20, and M12. When the product passes through the process route, it passes through each site in the order indicated by the site location. For example, Figure 2 In the example, the product is manufactured by passing through sites M10, M21, M11, M20, and M12 in sequence. The product referred to here can refer to a production object, including but not limited to a finished product and a semi-finished product. The site type indicates whether the site is a main process site or a non-main process site. For example, in Figure 2 In the figure, Y represents the main process site, and N represents the non-main process site.

[0054] In step S130, based on the site data of the plurality of sites, a main process site is determined among the plurality of sites according to the site type. Figure 2 In the example, combined with the above description, it can be determined according to the site type that sites M10 and M20 are main process sites, and sites M21, M11, and M12 are non-main process sites.

[0055] In step S140 , scheduling data for the product is generated based on the site data of the main process site.

[0056] For example, according to the preset correspondence between the main process site and the non-main process site, the non-main process site corresponding to each main process site can be determined, and each main process site and the corresponding non-main process site can be grouped together. Through this grouping method, the non-main process site corresponding to each main process site can be attributed to the main process site, so that the relevant data of the main process site can be extracted based on this affiliation to generate scheduling data.

[0057] In step S150, production scheduling is performed according to the scheduling data. For example, after grouping is completed in step S140, scheduling data for the product may be generated based on the site data of the main process sites in each group.

[0058] In some embodiments, if it is determined in step S120 that the original data of the product does not include the process route data of the product, step S160 may be executed. In step S160, the process route data of the product may be generated based on the material data of the product according to the pre-set correspondence between the material and the site. After the process route data is generated, the process may return to step S130 to generate scheduling data based on the generated process route data and perform production scheduling.

[0059] As mentioned above, the original data contains a lot of information. Taking the process route data as an example, the MES system that provides the process route data controls the entire production process, including the main process site of the product, the sampling inspection site, the measurement site, and the reprocessing (rework) site, etc., but the data of some of these sites are not the data that production scheduling needs to pay attention to. If all the site data collected from the MES system are involved in the scheduling, on the one hand, the scheduling process will be very time-consuming, and on the other hand, the scheduling results will contain a large amount of site data that users do not care about at all, such as some non-bottleneck site data. The embodiment of the present disclosure can determine the main process site from many sites based on the site type in the process route data, and generate scheduling data based on the process route data of the main process site, so that the scheduling data no longer includes a large amount of site data that production scheduling does not need to pay attention to, which is conducive to shortening the scheduling time and improving the scheduling efficiency. At the same time, it also avoids the scheduling results containing a large amount of unnecessary redundant information to cause additional work burden to users.

[0060] Figure 3 A flow chart of a process of generating scheduling data according to an embodiment of the present disclosure is shown. The process is applicable to the production scheduling method of any of the above embodiments, for example, to step S140 of the above production scheduling method 100.

[0061] In step S1401, after the main process site is determined, the non-main process site corresponding to each main process site can be determined according to the preset correspondence between the main process site and the non-main process site. The correspondence between the main process site and the non-main process site can be preset or obtained by analyzing the original data, which is not limited in the present disclosure. Figure 2 Among the various sites shown, it can be determined, for example, by looking up a table that the main process site M10 corresponds to the non-main process sites M11 and M12 , and the main process site M20 corresponds to the non-main process site M21 .

[0062] In step S1402 , each main process site and the corresponding non-main process site may be grouped into one group.

[0063] For example, for each main process site, the site identifier of the main process site may be used as a group identifier, and the group identifier may be assigned to the main process site and the corresponding non-main process site. Figure 4A An example of site grouping results is shown. Figure 4A As shown, in Figure 2A group identifier is added to each site based on the process route data. For example, the group identifiers of the main process site M10 and its corresponding non-main process sites M11 and M12 are all set to the site identifier M10 of the main process site M10, and the group identifiers of the main process site M20 and its corresponding non-main process site M21 are all set to the site identifier M20 of the main process site M20. In this way, the non-main process sites M11 and M12 are attributed to the main process site M10, and the non-main process site M21 is attributed to the main process site M20. Since the site data is extracted as the scheduling data based on the group identifier when the scheduling data is subsequently generated, the site data of the main process sites M10 and M20 will participate in the scheduling as part of the scheduling data, while the site data of the non-main process sites M11, M12 and M21 will not participate in the scheduling as part of the scheduling data.

[0064] In some embodiments, the grouping result may also be adjusted based on the in-service data, which will be described below in conjunction with steps S1403 to S1404.

[0065] In step S1403, for each main process site in each group of sites, production data of the non-main process sites corresponding to the main process site are searched in the production data of the plurality of sites.

[0066] The production data may include at least one of in-process data and beat data. Figure 5 Taking the work-in-progress data of product X shown in the figure as an example, it can be seen that Figure 4A Among the non-main process sites M11, M12 and M21, sites M21 and M12 have work-in-progress data, which means that the number of work-in-progress of sites M21 and M12 is 360, while site M21 has no work-in-progress data.

[0067] In step S1404, the found production data of the non-main process site is added to the production data of the main process site.

[0068] Likewise Figure 5 Taking the in-service data shown in the figure as an example, this addition can be achieved by changing the group identifier. Since it is determined in step S1403 that sites M21 and M12 have in-service data, Figure 4A In the example, the group ID of site M21 is changed from "M20" to "M21", and the group ID of site M12 is changed from "M10" to "M21" and "M12", and the following is obtained: Figure 4BThe grouping result is shown. In this way, when the site data is subsequently extracted based on the group identifier, the in-service data of sites M21 and M12 will be extracted together with the in-service data of site M20 as part of the scheduling data. For example, the scheduling data of the product can be generated based on the site data and production data of the main process site. In this way, the production data of the non-main process site and its corresponding main process site are all involved in the scheduling.

[0069] In some embodiments, the user may also be allowed to modify the grouping result, which will be described below in conjunction with steps S1405 to S1406.

[0070] In step S1405, the process route data and group identification of each site are displayed. For example, the user interaction interface can be used to display Figure 4A or Figure 4B The grouping results are shown.

[0071] In step S1406, according to the received modification instruction, the group identifier of at least one non-main process site is modified to the site identifier of the at least one non-main process site. For example, the user's modification instruction can be received through a user interaction interface, and the group identifier can be modified according to the user's modification instruction, so as to achieve the purpose of modifying the group. For example, the user can manually modify the group identifier through the user interaction interface. Figure 4B The grouping identifier of site M11 in is changed from "M10" to "M11".

[0072] After the grouping is completed, the relevant data of the site can be extracted based on the grouping identifier to generate the scheduling data. The following will refer to steps S1407 to S1408 for explanation.

[0073] In step S1407, a site whose site identifier is consistent with the group identifier is determined from the plurality of sites as a site to be scheduled. Figure 4B Taking the grouping result shown as an example, the site identifiers of sites M10, M12, M20 and M21 are consistent with their corresponding group identifiers, and therefore they are identified as sites to be scheduled.

[0074] In step S1408, the scheduling data of the product is generated based on the site data and production data of the site to be scheduled. Figure 4B Taking the grouping result shown as an example, the scheduling data of product X is generated based on the site data and production data of sites M10, M12, M20 and M21.

[0075] Figure 6 A schematic flow chart of a process for generating process route data of a product according to an embodiment of the present disclosure is shown. The process is applicable to the production scheduling method of any of the above embodiments, for example, to step S160 of the above production scheduling method 100.

[0076] In step S1601, a plurality of materials used to manufacture the product are determined based on the material data of the product.

[0077] For example, if the product to be scheduled is indicated in the sales demand data as product Y, but the process route data of product Y cannot be found in the original data of product Y, then in this case, process route data can be generated for product Y based on the material data of product Y for subsequent scheduling. Figure 7 From the material data of product Y shown, it can be determined that the materials used to manufacture product Y include materials B1, B2 and B3. Material B1 is located at the 2nd level in the material hierarchy, material B2 is located at the 3rd level in the material hierarchy, and material B3 is located at the 4th level in the material hierarchy, that is, at the bottom level of the material hierarchy, and the material at the top level is product Y.

[0078] In step S1602, the site corresponding to each material is determined according to the preset correspondence between materials and sites. The correspondence between materials and sites can be set in the form of a data table, and the site corresponding to each material can be determined by looking up the table. Figure 7 For materials in, it can be determined that material B3 corresponds to site M3, material B2 corresponds to site M2, material B1 corresponds to site M1, and the final finished product (i.e. product Y) corresponds to site M0. For example, in the material data of a certain product, the material identifiers of the raw materials consumed by the product are 44-8551 and 44-9530, and the material corresponding to 44-8551 is a polarizer, and the material corresponding to 44-9530 is a backlight. Based on the known relationship between materials and sites, it can be determined that the polarizer corresponds to an OC process site, and the backlight corresponds to an ASSY process site. Therefore, process route data including OC process sites and ASSY process sites can be generated for the product.

[0079] In step S1603, the position of the site corresponding to each material in the process route is determined according to the hierarchical relationship between the materials.

[0080] For example, the positions of the sites corresponding to the multiple materials in the process route can be set in the order of the layers of the multiple materials from low to high, wherein the site corresponding to the bottom material is set as the starting point in the process route. Figure 7 For example, the site M3 corresponding to the material B3 at the bottom layer (the 4th layer) will be the starting point of the process route, the site M2 corresponding to the material B2 at the 3rd layer will be located after the site M3, the site M1 corresponding to the material B1 at the 2nd layer will be located after the site M2, and the site M0 corresponding to the product Y at the top layer will be located after the site M1. That is, the sites M3, M2, M1, and M0 are arranged in this order to form a process route.

[0081] In some embodiments, when two or more materials correspond to the same site, the position of the corresponding same site in the process route is determined according to the level of one of the two or more materials. Figure 7 In the material data shown, assuming that the product corresponds to site M0, material B2 corresponds to site M1, and materials B1 and B3 both correspond to site M2, the position of site M2 in the process route can be determined based on material B3, which is at a lower level among materials B1 and B3. That is, site M2 is set as the bottom-level material site, which is located at the starting point of the process route, site M1 is set after site M2, and site M0 corresponding to product Y is set after site M1, thereby obtaining the process route: M2→M1→M0.

[0082] In step S1604, process route data of the product is generated based on the sites corresponding to the multiple materials and the position of each site in the process route.

[0083] For example, it is determined through step S1603 that the process route of product Y includes sites M0, M1, M2, and M3, and the sites in the process route are M3, M2, M1, and M0 in order from the starting point to the end point. Then, a similar Figure 2 The process routing data is shown.

[0084] In some embodiments, after the process route of a product is generated, the generated process route data can be displayed through a user interaction interface to allow the user to select the required process route data for production scheduling as needed.

[0085] In some embodiments, based on the generated process route data, the above-mentioned generation process of scheduling data can be returned to be executed, so as to generate scheduling data based on the newly generated process route data and perform subsequent scheduling processes accordingly.

[0086] The data source of sales demand of the production scheduling system is the ERP system, and the sales demand data is the demand data for a certain product in the future. It is possible that this product has not yet been put into production, and even the corresponding material number has not yet been generated in the MES system. In this way, there will be a situation where there is demand for a certain product, but there is no process route data. If such data is directly handed over to the production scheduling system for production scheduling, then the product without process route data will definitely not be delivered on time, and the scheduling result will not meet the needs of users. The embodiments of the present disclosure are aimed at such products without process route data. With the help of the material data of the product and the correspondence between the material and the site, process route data can be generated for the product. Thereby avoiding the problem of normal scheduling due to the lack of corresponding process route data for the product in the sales demand.

[0087] In some embodiments, after the scheduling data is generated, a data model may be generated based on the product scheduling data, and then production scheduling may be performed based on the generated data model. For example, the product process route may be determined based on the product scheduling data, and the product process route includes multiple sites. Then, virtual materials are generated for adjacent sites in the product process route. The virtual materials carry the association relationship between the adjacent sites. Fig. 8A As shown, according to the scheduling data, a process route is determined to include multiple stations M10, M20, M30 and M40. The material B10 provided to the process route can be processed in sequence through stations M10, M20, M30 and M40 to obtain material (also known as the product of the process route) B40. Figure 8B As shown, a virtual material B1020 can be established for adjacent sites M10 and M20, and the virtual material B1020 carries the relationship between sites M10 and M20. For example, the material identification of the virtual material B1020 can be obtained by combining the site identification of site M10 and the site identification of site M20, or the material identification of the virtual material B1020 can be stored in association with the site identifications and site locations of sites M10 and M20, so that the virtual material B1020 can carry the association relationship between sites M10 and M20. In a similar manner, a virtual material B2030 can be established for adjacent sites M20 and M30, and a virtual material B3040 can be established for adjacent sites M30 and M40, so as to obtain the following: Figure 8B The process route data model shown. The process route data in the business system usually only has a series of sites, and the input and output are only reflected at the beginning and end of the process route, which will cause great trouble to users when analyzing scheduling results, because users cannot see the input and output of the intermediate sites. To address this problem, the embodiment of the present disclosure adds a virtual material number automatically generated by the system to each non-last process site during data modeling, so that the process route data can reflect the input and output of the intermediate sites, which is more convenient for users to view and analyze.

[0088] In some embodiments, before generating the data model, a data snapshot with data version information may be generated for the product scheduling data, and then a data model with the data version information may be generated based on the data snapshot. Fig. 9As shown, in a certain scheduling process, the scheduling data FLOW of product X is first generated, data version information 001 is added to the scheduling data FLOW of the product, and a data snapshot is generated based on the scheduling data FLOW with data version information 001 added, thereby obtaining a data snapshot with data version information 001. Then a data model is generated based on the data snapshot, so that the data model carries data version information 001, and then scheduling is performed based on the data model. In the next scheduling, the scheduling data FLOW of the product is generated again. The scheduling data FLOW at this time may be changed relative to the previous one, so data version information 002 is set for the scheduling data FLOW, and a data snapshot is generated based on the scheduling data with data version information 002 added. Then, a data model is generated based on the data snapshot, so that the data model carries data version information 002. Then, scheduling is performed based on the data model with data version information 002. In a similar manner, scheduling data with data version information of 003, 004 and 005 are generated. Since the data model has data version information, when using each data model for production scheduling, the user can use the operation interface to search for the corresponding version of the data model in the database according to the data version information. For example, the user can input the required data version information through the operation interface, and the system can search for a data model that matches the received data version information among multiple versions of the data model based on the received data version information.

[0089] According to the method of the embodiment of the present disclosure, various data generated during the execution process can be stored in corresponding databases respectively. For example, the original data of the acquired product can be stored in a temporary database, and the generated scheduling data for the product can be stored in a basic database, thereby isolating the original data from the scheduling data. This not only avoids the mutual influence between the modules, but also reduces the development and maintenance costs of the system. In some embodiments, the generated data snapshot can be stored in the basic database, and the generated data model can be stored in the modeling conversion database.

[0090] Fig.10 FIG. 1 is a schematic diagram of a production scheduling system according to an embodiment of the present disclosure. Fig.10 As shown, the production scheduling system 900 includes a stored process engine 901 , a scheduling engine 902 , a temporary database 903 and a basic database 904 .

[0091] The stored process engine 901 can generate the scheduling data of the product in the manner of any of the above embodiments. For example, the stored process engine 901 can obtain the original data of the product; determine whether the original data of the product includes the process route data of the product; in response to the original data of the product including the process route data of the product, determine the main process site among the multiple sites according to the site type based on the site data of multiple sites in the process route data; and generate the scheduling data for the product based on the site data of the main process site. The stored process engine 901 can also generate the process route data of the product based on the material data of the product according to the pre-set correspondence between materials and sites in response to the lack of process route data of the product in the original data of the product.

[0092] The temporary database 903 stores the acquired original data of the product.

[0093] The basic database 904 is in communication with the temporary database 903 and can store the generated scheduling data for the product.

[0094] The scheduling engine 902 can perform production scheduling based on the scheduling data. In some embodiments, the scheduling engine 902 is connected to the stored process engine 901 through a gateway 908. The scheduling engine 902 can be a T3SupplyNet scheduling engine, which is a background program for production scheduling, which can be used for example but not limited to basic data verification, production plan simulation, plan report analysis, factory capacity utilization analysis, etc.

[0095] In some embodiments, the stored process engine 901 can also generate a data snapshot with data version information for the scheduling data of the product, and generate a data model based on the data snapshot. In this case, the scheduling engine 902 can perform production scheduling based on the generated data model.

[0096] In some embodiments, the basic database 904 may also store data snapshots with data version information as described above. In some embodiments, the system further includes a modeling transformation database 905, which is connected to the basic database communication 904 and may store the data model as described above.

[0097] The temporary database 503 can be used to store scheduling data obtained from data sources such as legacy systems. The stored process engine 501 can supplement the scheduling data in the temporary database 503 in the manner described above. In some embodiments, at least part of the scheduling data can be obtained in real time. In some embodiments, at least part of the scheduling data can be obtained manually. The scheduling data in the temporary database 503 may not have data version information. The basic database 504 is communicated with the temporary database 503 and is used to store data snapshots. The modeling transformation database 505 is communicated with the basic database 504 and is used to store data models.

[0098] According to an embodiment of the present disclosure, the above-mentioned production scheduling system may further include a scheduling database 906. The scheduling database 906 is in communication with the modeling conversion database 905 and is used to store data used by the scheduling engine 902. In some embodiments, the scheduling database 906 may also be used to store data from the scheduling engine 902, such as various data generated by the scheduling engine 902 during processing.

[0099] According to an embodiment of the present disclosure, the above-mentioned production scheduling system may further include an optimizer engine 909 and an optimizer database 910. The optimizer database 910 is in communication with the modeling conversion database 905 and is used to store data used by the optimizer engine 909. In some embodiments, the optimizer database 910 may also be used to store data from the optimizer engine 909, such as various data generated by the optimizer engine 909 during processing.

[0100] According to an embodiment of the present disclosure, the above-mentioned production scheduling system may further include a manager 907, a user database 911 and a user interaction engine 912. The user interaction engine 912 is used to implement human-computer interaction, and in some embodiments may be implemented as a user interaction interface (UI, User Interface) or a terminal device with a user interaction interface display function, such as a client. For example, the user interaction engine 912 is used to receive configuration information input by a user. The user database 911 is communicatively connected with the user interaction engine 912 and the basic database 904, and is used to store user information and user permissions. The manager 907 is used to perform the highest authority operation in the production scheduling system.

[0101] In some embodiments, during the execution of the scheduling task, the optimizer engine 909 and the scheduling engine 902 can work together. For example, the optimizer engine 909 can be used to perform preliminary scheduling, and then the scheduling engine 902 can be used to perform fine scheduling, so as to improve the accuracy of the scheduling results.

[0102] According to an embodiment of the present disclosure, the present disclosure also provides an electronic device, a readable storage medium and a computer program product.

[0103] Fig.11 A block diagram of an electronic device suitable for implementing a production scheduling method according to an embodiment of the present disclosure is shown.

[0104] like Fig.11 As shown, the electronic device 1000 according to an embodiment of the present disclosure includes a processor 1001, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 1002 or a program loaded from a storage part 1008 into a random access memory (RAM) 1003. The processor 1001 may include, for example, a general-purpose microprocessor (e.g., a CPU), an instruction set processor and / or a related chipset and / or a special-purpose microprocessor (e.g., an application-specific integrated circuit (ASIC)), etc. The processor 1001 may also include an onboard memory for caching purposes. The processor 1001 may include a single processing unit or multiple processing units for performing different actions of the method flow according to an embodiment of the present disclosure.

[0105] In RAM 1003, various programs and data required for the operation of electronic device 1000 are stored. Processor 1001, ROM 1002 and RAM 1003 are connected to each other via bus 1004. Processor 1001 performs various operations of the method flow according to the embodiment of the present disclosure by executing the program in ROM 1002 and / or RAM 1003. It should be noted that the program can also be stored in one or more memories other than ROM 1002 and RAM 1003. Processor 1001 can also perform various operations of the method flow according to the embodiment of the present disclosure by executing the program stored in the one or more memories.

[0106] According to an embodiment of the present disclosure, the electronic device 1000 may further include an input / output (I / O) interface 1005, which is also connected to the bus 1004. The electronic device 1000 may further include one or more of the following components connected to the I / O interface 1005: an input portion 1006 including a keyboard, a mouse, etc.; an output portion 1006 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage portion 1008 including a hard disk, etc.; and a communication portion 1009 including a network interface card such as a LAN card, a modem, etc. The communication portion 1009 performs communication processing via a network such as the Internet. A drive 1010 is also connected to the I / O interface 1005 as needed. A removable medium 1011, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 1010 as needed, so that a computer program read therefrom is installed into the storage portion 1008 as needed.

[0107] The present disclosure also provides a computer-readable storage medium, which may be included in the device / apparatus / system described in the above embodiments; or may exist independently without being assembled into the device / apparatus / system. The above computer-readable storage medium carries one or more programs, and when the above one or more programs are executed, the method according to the embodiment of the present disclosure is implemented.

[0108] According to an embodiment of the present disclosure, a computer-readable storage medium may be a non-volatile computer-readable storage medium, for example, may include but is not limited to: a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination thereof. In the present disclosure, a computer-readable storage medium may be any tangible medium containing or storing a program, which may be used by or in combination with an instruction execution system, an apparatus or a device. For example, according to an embodiment of the present disclosure, a computer-readable storage medium may include the ROM 1002 and / or RAM 1003 described above and / or one or more memories other than ROM 1002 and RAM 1003.

[0109] The embodiment of the present disclosure also includes a computer program product, which includes a computer program, and the computer program contains program code for executing the method shown in the flowchart. When the computer program product is run in a computer system, the program code is used to enable the computer system to implement the production scheduling method provided by the embodiment of the present disclosure.

[0110] The above functions defined in the system / device of the embodiment of the present disclosure are performed when the computer program is executed by the processor 601. According to the embodiment of the present disclosure, the system, device, module, unit, etc. described above can be implemented by a computer program module.

[0111] In one embodiment, the computer program may rely on tangible storage media such as optical storage devices, magnetic storage devices, etc. In another embodiment, the computer program may also be transmitted and distributed in the form of signals on a network medium, and downloaded and installed through the communication part 1009, and / or installed from the removable medium 1011. The program code contained in the computer program may be transmitted using any appropriate network medium, including but not limited to: wireless, wired, etc., or any suitable combination of the above.

[0112] In such an embodiment, the computer program can be downloaded and installed from the network through the communication part 1009, and / or installed from the removable medium 1011. When the computer program is executed by the processor 1001, the above functions defined in the system of the embodiment of the present disclosure are performed. According to the embodiment of the present disclosure, the system, device, means, module, unit, etc. described above can be implemented by a computer program module.

[0113] According to an embodiment of the present disclosure, the program code for executing the computer program provided by the embodiment of the present disclosure can be written in any combination of one or more programming languages. Specifically, these computing programs can be implemented using high-level process and / or object-oriented programming languages, and / or assembly / machine languages. Programming languages ​​include, but are not limited to, Java, C++, python, "C" language or similar programming languages. The program code can be executed entirely on the user computing device, partially on the user device, partially on the remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device can be connected to the user computing device through any type of network, including a local area network (LAN) or a wide area network (WAN), or can be connected to an external computing device (for example, using an Internet service provider to connect through the Internet).

[0114] The flow charts and block diagrams in the accompanying drawings illustrate the possible architecture, functions and operations of the systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each box in the flow chart or block diagram can represent a module, a program segment, or a part of a code, and the above-mentioned module, program segment, or a part of a code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in a different order from the order marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram or flow chart, and the combination of the boxes in the block diagram or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0115] It will be appreciated by those skilled in the art that the features described in the various embodiments and / or claims of the present disclosure may be combined and / or combined in a variety of ways, even if such combinations and / or combinations are not explicitly described in the present disclosure. In particular, the features described in the various embodiments and / or claims of the present disclosure may be combined and / or combined in a variety of ways without departing from the spirit and teachings of the present disclosure. All of these combinations and / or combinations fall within the scope of the present disclosure.

[0116] The embodiments of the present disclosure are described above. However, these embodiments are only for illustrative purposes and are not intended to limit the scope of the present disclosure. Although the embodiments are described above separately, this does not mean that the measures in the various embodiments cannot be used in combination to advantage. The scope of the present disclosure is defined by the attached claims and their equivalents. Without departing from the scope of the present disclosure, those skilled in the art may make a variety of substitutions and modifications, which should all fall within the scope of the present disclosure.

Claims

1. A production scheduling method, comprising: Get the original data of the product; Determining process route data of the product based on the original data, wherein the process route data includes site data of a plurality of sites used to manufacture the product, and the site data of each site includes a site identifier, a site type, and a position of the site in the process route, wherein the site type includes a main process site and a non-main process site; Based on the site data of the plurality of sites, determining a main process site among the plurality of sites according to site type; Generate scheduling data for the product based on site data of the main process site; Production scheduling is performed according to the scheduling data.

2. The method according to claim 1, further comprising: After determining the main process site, According to the preset correspondence between the main process site and the non-main process site, determine the non-main process site corresponding to each main process site; Group each main process site and the corresponding non-main process site into one group; The generating the scheduling data for the product based on the site data of the main process site includes: generating the scheduling data for the product based on the site data of the main process site in each group.

3. The method according to claim 2, wherein: The step of grouping each main process site and the corresponding non-main process site into one group includes: for each main process site, Using the site identifier of the main process site as the group identifier; The group identifier is assigned to the master process site and the corresponding non-master process site.

4. The method according to claim 3, wherein: The original data also includes production data of the plurality of sites. The method further includes: after grouping each main process site and the corresponding non-main process site into a group, For a main process site in each group of sites, searching the production data of the plurality of sites for production data of a non-main process site corresponding to the main process site; Add the production data of the non-main process site found to the production data of the main process site; The generating the scheduling data for the product based on the site data of the main process site includes: generating the scheduling data for the product based on the site data of the main process site and production data.

5. The method according to claim 4, wherein: The production data includes in-process data and takt time data.

6. The method according to any one of claims 2 to 5, further comprising: Display process route data and group identification for each site; According to the received modification instruction, the group identifier of at least one non-main process site is modified to the site identifier of the at least one non-main process site.

7. The method according to any one of claims 3 to 6, wherein: The generating of the scheduling data for the product based on the site data of the main process site includes: Determine, from the plurality of sites, a site whose site identifier is consistent with the group identifier as a site to be scheduled; Based on the site data and production data of the site to be scheduled, the scheduling data of the product is generated.

8. The method according to claim 1, wherein: The original data of the product also includes the material data of the product; The method further includes: in response to the lack of process route data of the product in the original data of the product, generating the process route data of the product based on the material data of the product and according to a preset correspondence between the material and the site.

9. The method according to claim 8, wherein: The material data includes a plurality of materials used to manufacture the product and a hierarchical relationship between the plurality of materials; The step of generating the process route data of the product based on the material data of the product according to a preset correspondence between the material and the site includes: Determining, based on the material data of the product, a plurality of materials used to manufacture the product; Determine the site corresponding to each material based on the pre-set correspondence between materials and sites; Determine the location of the station corresponding to each material in the process route based on the hierarchical relationship between the materials; Based on the sites corresponding to the multiple materials and the position of each site in the process route, the process route data of the product is generated.

10. The method according to claim 9, wherein: The generating the process route data of the product based on the sites corresponding to the multiple materials and the position of each site in the process route includes: The positions of the sites corresponding to the multiple materials in the process route are set in the order of the levels of the multiple materials from low to high, wherein the site corresponding to the bottom-level material is set as the starting point in the process route.

11. The method according to claim 10, wherein: In the case where two or more materials correspond to the same site, the position of the corresponding same site in the process route is determined according to the level of one of the two or more materials.

12. The method according to any one of claims 1 to 11, further comprising: The acquired original data of the product is stored in a temporary database, and the generated scheduling data for the product is stored in a basic database.

13. The method according to any one of claims 1 to 12, further comprising: generating a data model based on the scheduling data of the product; The performing of production scheduling according to the scheduling data includes: performing production scheduling based on the generated data model.

14. The method of claim 13, wherein generating a data model based on the scheduling data of the product comprises: Determine a process route of the product according to the scheduling data of the product, wherein the process route of the product includes a plurality of stations; A virtual material is generated for adjacent sites in the process route of the product, and the virtual material carries the association relationship between the adjacent sites.

15. The method according to claim 13 or 14, further comprising: Before generating the data model, generating a data snapshot with data version information for the scheduling data of the product; The generating the data model includes generating a data model having the data version information based on the data snapshot.

16. The method according to claim 16, further comprising: According to the received data version information, a data model matching the received data version information is searched among multiple versions of data models.

17. The method according to claim 15 or 16, further comprising: The generated data snapshot is stored in the basic database, and the generated data model is stored in the modeling transformation database.

18. An electronic device comprising a memory and a processor, wherein the memory stores instructions executable by the processor, and when the instructions are executed by the processor, the processor executes the method according to any one of claims 1 to 17.

19. A non-transitory computer-readable storage medium storing computer instructions, wherein: The computer instructions are used to cause the computer to execute the method according to any one of claims 1 to 17.

20. A computer program product comprising a computer program which, when executed by a processor, implements the method according to any one of claims 1 to 17.

21. A production scheduling system comprising: Stored procedure engine, used to obtain the original data of the product; Determining whether the original data of the product includes process route data of the product, wherein the process route data includes site data of a plurality of sites used to manufacture the product, the site data of each site including a site identifier, a site type, and a position of the site in the process route, wherein the site type indicates whether the site is a main process site or a non-main process site; in response to the original data of the product including the process route data of the product, determining a main process site among the plurality of sites according to the site type based on the site data of the plurality of sites; and generating scheduling data for the product based on the site data of the main process site; A temporary database for storing the original data of the acquired products; A basic database, which is in communication with the temporary database and is used to store the generated scheduling data for the product; as well as The scheduling engine is used to perform production scheduling according to the scheduling data.

22. The production scheduling system according to claim 21, wherein: The stored procedure engine is also used to: in response to the lack of process route data of the product in the original data of the product, generate the process route data of the product based on the material data of the product and according to a preset correspondence between the material and the site.

23. The production scheduling system according to claim 21 or 22, wherein: The stored procedure engine is further used to generate a data snapshot with data version information for the scheduling data of the product, and generate a data model based on the data snapshot; The scheduling engine is also used to perform production scheduling based on the data model; The basic database is also used to store the data snapshot with data version information; The system also includes a modeling conversion database, which is communicatively connected with the basic database and is used to store the data model.

Images