Service inventory information synchronization method and system and storage medium

Abstract

The invention relates to a business inventory information synchronization method and system and a computer storage medium, and relates to the field of computer information. The method comprises the following steps: acquiring service data information corresponding to each service node from a service process; performing feature extraction on the business data information to obtain business feature information corresponding to the business data information; extracting the service feature information associated with the inventory state of the service data information serial number to obtain inventory associated feature information; and based on the inventory association feature information, updating inventory information in the business data information. The method can quickly respond to the change of the business data, updates the stock state of the serial number in real time, and does not affect the processing efficiency of the existing business document. New business receipt support serial numbers are continuously added subsequently, new businesses influence the stock state of the serial numbers, the stock state calculation configuration table of the serial numbers can be added according to needs, and business logic codes are slightly changed.

Description

Technical Field

[0001] The present invention relates to the field of computer information, and in particular to a method, system and storage medium for synchronizing business inventory information. Background Art

[0002] In today's digital business era, the complexity and dynamism of business operations continue to increase, which poses unprecedented challenges to inventory management. Enterprises not only have to deal with daily business processes such as procurement, sales, returns, inventory counting, location adjustments, warehouse transfers, etc., but also need to adapt to the rapid growth of online business and the production, processing and outsourcing business needs unique to manufacturing companies.

[0003] Traditional inventory management methods mainly rely on periodic inventory counting and manual data entry, which are no longer able to meet the needs of modern enterprises in terms of efficiency and accuracy. With the surge in business volume, enterprises are in urgent need of a more efficient and accurate inventory management solution.

[0004] In the enterprise information management system, various business processes are reflected through electronic business documents. Different business processes correspond to various business documents, such as purchase orders, purchase orders, sales orders, sales orders, sales delivery orders, purchase receipts, finished product receipts, material delivery orders, production and processing orders, inventory orders, transfer orders, retail orders and retail delivery orders. The electronicization of these documents not only improves the speed of data processing, but also reduces the possibility of human errors. However, with the diversification of business forms, the update of serial number status has become more complicated, involving pre-warehouse, in-warehouse, pre-delivery, delivery, transfer, inventory, production and other states.

[0005] Faced with the diversity of multi-business documents and serial number status, and foreseeing the new forms that may be presented by future corporate business, the technical requirements for serial number status updates are becoming more stringent. The inventory management technology of modern enterprise information management systems needs to be able to ensure accuracy, real-time, and have good scalability to adapt to the ever-changing business needs and market environment. Summary of the invention

[0006] Based on this, it is necessary to provide a business inventory information synchronization method, system and storage medium to address the problems of complex inventory data updates and slow processing speeds.

[0007] A method for synchronizing business inventory information, comprising: Obtain business data information corresponding to each business node from the business process; Performing feature extraction on the business data information to obtain business feature information corresponding to the business data information; Extracting the business characteristic information associated with the business data information sequence number inventory status to obtain inventory-related characteristic information; Based on the inventory-related characteristic information, the inventory information in the business data information is updated.

[0008] In one preferred implementation manner, the acquiring of service data information of a corresponding service node from a service process includes: Extract business data information of corresponding business nodes in a multi-threaded asynchronous manner; In one preferred implementation manner, the extracting features from the service data information to obtain service feature information corresponding to the service data information further includes: Performing data cleaning on the business data information to obtain business data information in a unified format; The business data information is screened to obtain and store the screened key fields.

[0009] In one preferred implementation manner, the key fields include: document ID, document detail ID, document type, business type, warehouse, cargo location, commodity, and inbound and outbound directions.

[0010] In one preferred embodiment, the extracting the business characteristic information associated with the business data information sequence number inventory status to obtain the inventory-related characteristic information includes: The business data information is imported into the inventory status calculation model, and the inventory-related feature information is obtained through the inventory status calculation model.

[0011] In a preferred implementation manner, the inventory status calculation model adopts a mapping table mechanism.

[0012] In a preferred embodiment, the inventory status calculation model adopts asynchronous message batch processing.

[0013] In one preferred implementation manner, updating the inventory information in the business data information based on the inventory association feature information includes: storing the inventory-related feature information in a server; The inventory-related feature information is updated to the corresponding database of the business system using batch operations.

[0014] A business inventory information synchronization system, comprising: The business data acquisition module is used to obtain the business data information corresponding to each business node from the business process; A service feature extraction module, used to extract features from the service data information to obtain service feature information corresponding to the service data information; An inventory-related feature extraction module is used to extract the business feature information associated with the business data information sequence number inventory status to obtain the inventory-related feature information; The database updating module is used to update the inventory information in the business data information based on the inventory association characteristic information.

[0015] A computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the above-mentioned method for synchronizing business inventory information is implemented.

[0016] The present invention can quickly respond to changes in business data by executing the above method, and update the serial number inventory status in real time without affecting the processing efficiency of existing business documents. In the future, new business documents will continue to support serial numbers, and new businesses will affect the serial number inventory status. The serial number inventory status calculation configuration table can be added as needed, and the business logic code will be less modified. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] Figure 1 It is a flow chart of a business inventory information synchronization method disclosed in the first preferred embodiment of the present invention; Figure 2 It is a flowchart of subdivided steps of step S20 of a method for synchronizing business inventory information disclosed in the first preferred embodiment of the present invention; Figure 3 It is a flowchart of subdivided steps of step S40 of a method for synchronizing business inventory information disclosed in the first preferred embodiment of the present invention; Figure 4 This is a module diagram of a business inventory information synchronization system disclosed in a second preferred embodiment of the present invention. DETAILED DESCRIPTION

[0018] In order to make the purpose, technical solution and advantages of the present invention more clearly understood, the present invention is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not intended to limit the present invention.

[0019] It should be noted that when an element is referred to as being "disposed on" another element, it may be directly on the other element or there may be a central element. When an element is considered to be "connected to" another element, it may be directly connected to the other element or there may be a central element at the same time. The terms "vertical", "horizontal", "left", "right" and similar expressions used herein are for illustrative purposes only and do not represent the only implementation method.

[0020] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as those commonly understood by those skilled in the art of the present invention. The terms used herein in the specification of the present invention are only for the purpose of describing specific embodiments and are not intended to limit the present invention. The term "and / or" used herein includes any and all combinations of one or more related listed items.

[0021] like Figure 1 As shown, a business inventory information synchronization method disclosed in a first preferred embodiment of the present invention includes: S10: Obtaining business data information corresponding to each business node from the business process; Specifically, in this step, a collection point is built into the business node corresponding to the data that needs to be collected in the business process. For example, data collection points can be set in the business modules such as procurement, sales, and inventory in the business process. These data collection points are mainly used to collect business documents in the corresponding business modules, that is, the business data information mentioned above. In this embodiment, the business data information of the corresponding business node in the corresponding module is extracted in a multi-threaded asynchronous manner. The business data information here can be the above-mentioned business document, or it can be other forms of business data. Generally, in this embodiment, the above-mentioned method for obtaining business data information is to extract data in the try stage of the distributed transaction (TCC) in the document processing. Taking this method for data acquisition can ensure that the data of the original business document and the extracted data are completely consistent.

[0022] S20: Extracting features from the service data information to obtain service feature information corresponding to the service data information.

[0023] Generally, in a business process, there will be a large amount of data information, which will result in the amount of business data information obtained in the above step S10 being very large, and not all business information is the data information required by the method of the present invention. Therefore, this step identifies the acquired business data information to facilitate further processing of the data in subsequent steps.

[0024] In this embodiment, the above step S20 also performs data cleaning on the acquired business data information to ensure that the collected data is in a unified data format and to filter the key fields corresponding to the business data information, so as to facilitate further data processing in subsequent steps. Figure 1 and Figure 2 As shown, the above step S20 specifically includes the following subdivision steps: S21: performing data cleaning on the business data information to obtain business data information in a unified format; S22: Screening the business data information to obtain and store the screened key fields.

[0025] The above-mentioned data cleaning is to unify the data format of the original data of the business document to facilitate subsequent data processing. In this implementation, the business data information after the above-mentioned unified data format is defined as a serial number detailed account object, and then the data of the above-mentioned serial number detailed account object is screened to obtain the inventory-related key fields required for inputting data in subsequent steps.

[0026] In this implementation, only the key fields in the business data information filtered by the above-mentioned subdivision steps are stored. The key fields obtained after filtering can mainly include: document ID, document detail ID, document type, business type, warehouse, cargo location, commodity, in and out direction, amount, quantity and other information. This can reduce the amount of stored data in the database table. In this implementation, the above-mentioned filtered key fields are abstracted in the document model design stage and are defined in the document public base class to facilitate the initialization and assignment of serial number detail account objects.

[0027] In the above subdivision steps, the business data is cleaned. In this implementation, the serial number ledger is processed in the try phase of the distributed transaction (TCC) of the document processing, so that the consistency of the document data and the serial number ledger data can be guaranteed. The document processing submission and the serial number ledger processing submission are submitted in the commit phase. If an exception occurs in one of the processes, the transaction is rolled back uniformly.

[0028] In this implementation manner, the extracted inventory-related key fields may be the corresponding business feature information.

[0029] S30: extracting the business characteristic information associated with the business data information sequence number inventory status to obtain inventory-related characteristic information.

[0030] In this step, feature extraction is further performed based on the business feature information obtained in S20 above to obtain business feature information associated with the business data information serial number and inventory status, and to obtain inventory-associated feature information.

[0031] In this embodiment, the business data information is imported into the inventory status calculation model, and the inventory-related feature information is obtained through the inventory status calculation model. The inventory status calculation model adopts a mapping table mechanism. The inventory status calculation model adopts asynchronous message batch processing.

[0032] In more detail, query the serial number detailed account data through the document ID related fields in the message body, extract the key field value combination that affects the calculation of the serial number inventory status (document type, business type, inbound and outbound direction, business process, document status), pass it into the status calculation logic, and calculate the latest status of the serial number inventory. The serial number inventory status calculation adopts a mapping table mechanism and provides an extensible mechanism. For newly connected business documents in the future, the serial number inventory status calculation configuration table is directly added.

[0033] S40: Based on the inventory-related characteristic information, update the inventory information in the business data information.

[0034] When receiving the serial number status update message, it is processed using asynchronous multi-threading.

[0035] In the above step S40, combined with Figure 1 and Figure 3 As shown, it specifically includes the following subdivision steps: S41: storing the inventory-related feature information in the server; S42: Update the inventory-related feature information to the database corresponding to the business system in batch operation.

[0036] According to asynchronous message batch processing, the calculated new status of the serial number is temporarily stored in the server memory. In order to ensure the consistency of the serial number status data, batch operations are used to update the database to ensure that the data is updated within a database transaction, dynamically assemble SQL, and put the serial number update statements of the same status into one SQL, thereby reducing the overall SQL string length.

[0037] In the entire serial number status update processing node, the above step S10 is within the distributed transaction of business document processing, which ensures the data consistency between the document data and the serial number detailed account data. The processing of the above steps S20, S30 and S40 is processed in an asynchronous thread. Since the business data of the first two steps have been submitted successfully, the data processing of these two steps can only move forward and must be successful. Failure is not allowed. If it fails, it needs to be automatically retried. Retry logic, use the data body of the message received in step S30, and send the serial number status update message again. This message is a delayed message and has a certain retry frequency; Retry frequency and delay step calculation logic: Retry times n, first n=100 times, retry every 5 seconds, then 200=>n>100 times, retry every 10 seconds, then 400=>n>200 times, retry every 20 seconds, n>400 times, 5 minutes. The total retry time is 700 times, and the cumulative time does not exceed 24 hours. If it exceeds 24 hours, no retry will be done and manual intervention is required. The business inventory information synchronization method disclosed in the above embodiment of the present invention can quickly respond to changes in business data and update the serial number inventory status in real time without affecting the processing efficiency of existing business documents. In the future, new business documents will continue to support serial numbers, and new businesses will affect the serial number inventory status. The serial number inventory status calculation configuration table can be added as needed, and the business logic code will be less modified.

[0038] like Figure 4 As shown, the second preferred embodiment of the present invention discloses a business inventory information synchronization system 100 , which includes a business data acquisition module 110 , a business feature extraction module 120 , an inventory association feature extraction module 130 and a database update module 140 .

[0039] The business data acquisition module 110 is used to acquire business data information corresponding to each business node from the business process.

[0040] Specifically, the business data acquisition module 110 has built-in collection points in the business nodes corresponding to the data that needs to be collected in the business process. For example, data collection points can be set in the business modules such as procurement, sales, inventory, etc. in the business process. These data collection points are mainly used to collect business documents in the corresponding business modules, that is, the business data information mentioned above. In this embodiment, the business data information of the corresponding business nodes in the corresponding modules is extracted in a multi-threaded asynchronous manner. The business data information here can be the above-mentioned business documents, or it can be other forms of business data. Generally, in this embodiment, the above-mentioned method for obtaining the business data information is to extract data in the try stage of the distributed transaction (TCC) in the document processing. Taking this method for data acquisition can ensure that the data of the original business document and the extracted data are completely consistent.

[0041] The service feature extraction module 120 is used to extract features from the service data information to obtain service feature information corresponding to the service data information.

[0042] Generally, in a business process, there will be a large amount of data information, which will lead to the fact that the amount of business data information acquired by the above-mentioned business feature extraction module 120 is also very large, and not all business information is the data information required by the method of the present invention. Therefore, this step identifies the acquired business data information to facilitate further processing of the data in subsequent steps.

[0043] In this embodiment, the business feature extraction module 120 also performs data cleaning on the acquired business data information to ensure that the collected data is in a unified data format and to filter the key fields corresponding to the business data information, so as to facilitate further data processing in subsequent steps. Figure 2As shown, the above-mentioned business feature extraction module 120 specifically also includes a data cleaning unit 121 and a data screening unit 122: the data cleaning unit 121 performs data cleaning on the business data information to obtain business data information in a unified format; the data screening unit 122 performs data screening on the business data information to obtain and store the filtered key fields.

[0044] The above-mentioned data cleaning is to unify the data format of the original data of the business document to facilitate subsequent data processing. In this implementation, the business data information after the above-mentioned unified data format is defined as a serial number detailed account object, and then the data of the above-mentioned serial number detailed account object is screened to obtain the inventory-related key fields required for inputting data in subsequent steps.

[0045] In this implementation, only the key fields in the business data information filtered by the above-mentioned subdivision steps are stored. The key fields obtained after filtering can mainly include: document ID, document detail ID, document type, business type, warehouse, cargo location, commodity, in and out direction, amount, quantity and other information. This can reduce the amount of stored data in the database table. In this implementation, the above-mentioned filtered key fields are abstracted in the document model design stage and are defined in the document public base class to facilitate the initialization and assignment of serial number detail account objects.

[0046] The data cleaning unit 121 cleans the business data. In this embodiment, the serial number ledger processing is performed in the try phase of the distributed transaction (TCC) of the document processing, so that the consistency of the document data and the serial number ledger data can be guaranteed. The document processing submission and the serial number ledger processing submission are in the commit phase. If an exception occurs in one of the processes, the transaction is rolled back uniformly.

[0047] In this implementation manner, the extracted inventory-related key fields may be the corresponding business feature information.

[0048] The inventory-related feature extraction module 130 is used to extract the business feature information associated with the business data information sequence number inventory status to obtain the inventory-related feature information; The database updating module 140 is used to update the inventory information in the business data information based on the inventory association characteristic information.

[0049] The business inventory information synchronization system disclosed in the above embodiment of the present invention can quickly respond to changes in business data and update the serial number inventory status in real time without affecting the processing efficiency of existing business documents. In the future, new business documents will continue to support serial numbers, and new businesses will affect the serial number inventory status. The serial number inventory status calculation configuration table can be added as needed, and the business logic code will be less modified.

[0050] Another embodiment of the present invention discloses a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, the above-mentioned method for synchronizing business inventory information is implemented.

[0051] It should be noted that the computer storage medium mentioned above in the present disclosure may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, 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), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present disclosure, a computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, device or device. In the present disclosure, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, which carries a computer-readable program code. This propagated data signal may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. Computer readable signal media may also be any computer storage medium other than computer readable storage media, which may send, propagate or transmit a program for use by or in conjunction with an instruction execution system, apparatus or device. The program code contained on the computer storage medium may be transmitted using any appropriate medium, including but not limited to: wires, optical cables, RF (radio frequency), etc., or any suitable combination of the above.

[0052] In some embodiments, the client and the server may communicate using any currently known or future developed network protocol such as HTTP (Hyper Text Transfer Protocol), and may be interconnected with any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), an internet (e.g., the Internet), and a peer-to-peer network (e.g., an ad hoc peer-to-peer network), as well as any currently known or future developed network.

[0053] The computer storage medium may be included in the electronic device, or may exist independently without being installed in the electronic device.

[0054] The computer storage medium carries one or more programs. When the one or more programs are executed by the electronic device, the electronic device: The technical features of the above-described embodiments may be arbitrarily combined. To make the description concise, not all possible combinations of the technical features in the above-described embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0055] The above-mentioned embodiments only express several implementation methods of the present invention, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the invention patent. It should be pointed out that, for ordinary technicians in this field, several variations and improvements can be made without departing from the concept of the present invention, and these all belong to the protection scope of the present invention. Therefore, the protection scope of the patent of the present invention shall be subject to the attached claims.

Claims

1. A method for synchronizing business inventory information, characterized in that: include: Obtain business data information corresponding to each business node from the business process; Extracting features from the service data information to obtain service feature information corresponding to the service data information; Extracting the business characteristic information associated with the business data information sequence number inventory status to obtain inventory-related characteristic information; Based on the inventory-related characteristic information, the inventory information in the business data information is updated.

2. A method for synchronizing business inventory information according to claim 1, characterized in that: The obtaining of business data information corresponding to each business node from the business process includes: Extract business data information of corresponding business nodes in a multi-threaded asynchronous manner.

3. A method for synchronizing business inventory information according to claim 1, characterized in that: The extracting features of the service data information to obtain service feature information corresponding to the service data information also includes: Performing data cleaning on the business data information to obtain business data information in a unified format; The business data information is screened to obtain and store the screened key fields.

4. A method for synchronizing business inventory information according to claim 3, characterized in that: The key fields include: document ID, document detail ID, document type, business type, warehouse, cargo location, commodity, and inbound and outbound directions.

5. A method for synchronizing business inventory information according to claim 1, characterized in that: The extracting the business characteristic information associated with the business data information sequence number inventory status to obtain inventory-related characteristic information includes: The business data information is imported into the inventory status calculation model, and the inventory-related feature information is obtained through the inventory status calculation model.

6. A method for synchronizing business inventory information according to claim 5, characterized in that: The inventory status calculation model adopts a mapping table mechanism.

7. A method for synchronizing business inventory information according to claim 5, characterized in that: The inventory status calculation model adopts asynchronous message batch processing.

8. A method for synchronizing business inventory information according to claim 1, characterized in that: The updating of the inventory information in the business data information based on the inventory association characteristic information includes: storing the inventory-related feature information in a server; The inventory-related feature information is updated to the corresponding database of the business system using batch operations.

9. A business inventory information synchronization system, characterized in that: include: The business data acquisition module is used to obtain the business data information corresponding to each business node from the business process; A service feature extraction module, used to extract features from the service data information to obtain service feature information corresponding to the service data information; An inventory-related feature extraction module is used to extract the business feature information associated with the business data information sequence number inventory status to obtain the inventory-related feature information; The database updating module is used to update the inventory information in the business data information based on the inventory association characteristic information.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, a method for synchronizing business inventory information according to any one of claims 1 to 8 is implemented.

Images