Paper package workshop business data management method, system and device and storage medium

Abstract

The invention discloses a roll and package workshop business data management method, system and device and a storage medium, and belongs to the technical field of roll and package workshop informatization management. Business processes and related business data under each module are sorted out according to a process quality module, a device module and a production module, and then data source information of a related database is configured; a database table structure and data are obtained, a tree-shaped business flow chart is established according to the business flow of each module, then corresponding database tables are associated with business nodes related to the data, and finally association and management and control of the business and the data are achieved. Comprehensive digital management of business data of the roll-to-package workshop is realized, a data barrier between business modules is broken, and intercommunication and sharing of data are realized; communication between business personnel and data management personnel is simplified, and convenience of business data management is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of information management of a packaging workshop, and more specifically, to a method, system, device and storage medium for business data management of a packaging workshop. Background Art

[0002] With the advancement of industrial automation and intelligent manufacturing, the packaging workshop, as the core production department of the tobacco, papermaking and other industries, is facing increasingly severe challenges. The traditional packaging workshop business data management method can no longer meet the needs of modern enterprises, mainly in the following aspects:

[0003] (1) Dispersion of business data: The business data of the packaging workshop is often scattered in different systems, applications, Excel spreadsheets and paper documents. There is a lack of a unified management platform, which leads to problems such as difficulty in finding data, untimely updates, and inconsistent versions.

[0004] (2) Data island phenomenon: Due to historical reasons and technical limitations, the business modules of the wrapping workshop, such as process quality, equipment and production, are relatively independent, forming data islands. Data cannot be shared and communicated, which seriously affects decision-making efficiency and cross-departmental collaboration.

[0005] (3) Poor communication between business personnel and data management personnel: Business personnel usually only focus on the business processes they are responsible for and have little understanding of the data storage location and structure; while developers and data management personnel are familiar with the database, they do not have a good grasp of the specific business processes and business logic. This information asymmetry makes it difficult for both parties to communicate quickly and effectively when dealing with new business needs, which in turn affects project progress and quality.

[0006] In order to solve the above problems, the packaging workshop urgently needs to introduce a new business data management system and method. Summary of the invention

[0007] An object of the present invention is to provide a method, system, device and storage medium for managing business data of a packaging workshop to achieve centralized management, interconnection and efficient collaboration of data.

[0008] According to a first aspect of the present invention, a method for managing business data of a packaging workshop is provided, comprising:

[0009] Collect data related to process quality, equipment, and production business of the packaging workshop, standardize the format of the collected data, and store the standardized data in a database, where the relevant data includes but is not limited to data from the packaging machine, packaging machine, conveyor line, sensor, control system, and manual records;

[0010] Based on the relevant data stored in the database, a business data management platform is established, wherein a volume package business logic tree diagram is constructed in the business data management platform;

[0011] Through the volume-wrapped business logic tree diagram, the business data involved in each business node is queried and managed, where the business data includes but is not limited to database type, server IP, database name, database table structure and involved table data.

[0012] Optionally, the step of establishing a business data management platform based on the relevant data stored in the database includes:

[0013] Complete the configuration of the data source by configuring the database type, database name, server IP, port, user name and password of the database;

[0014] According to the business logic of the three modules of process quality, equipment and production, table tags with tree structure are set up, the corresponding database tables are associated with the business tags involving data storage, and a volume package business logic tree diagram is constructed.

[0015] Optionally, the step of establishing a business data management platform based on the relevant data stored in the database further includes:

[0016] After completing the data source configuration, obtain the table structure and data of each database, customize the query conditions according to business needs, and directly view the table structure and data of each table under each database on the business data management platform.

[0017] Optionally, before constructing the roll packaging business logic tree diagram, the various business logics of the roll packaging workshop are also sorted out, including but not limited to obtaining the overall business process, key business nodes, and the relationship and dependency between businesses.

[0018] Optionally, after the volume package business logic tree diagram is constructed, it is visualized on the business data management platform.

[0019] Optionally, the method for managing business data of a packaging workshop further includes: updating the packaging business logic tree diagram in real time according to changes in actual business requirements, including:

[0020] Adding nodes: For newly added business links, add nodes to the corresponding positions in the tree diagram and associate new database tables with them or modify the existing table structure to support the storage of new data;

[0021] Delete nodes: For outdated business links, delete the corresponding nodes from the tree diagram;

[0022] Modify nodes: For business links that need to be adjusted or optimized, modify the description and properties of the corresponding nodes in the tree diagram, and update the associated database tables or fields to reflect the new business logic.

[0023] Optionally, the method for managing business data of a packaging workshop further includes a permission management step, including:

[0024] Get the different roles and their responsibilities in the wrapping shop;

[0025] According to the different roles and responsibilities obtained, the permissions are subdivided into different levels of read, write, modify, and delete;

[0026] On the business data management platform, set the mapping relationship between roles and permissions;

[0027] Assign data access rights based on user roles, and refine access control policies based on data attributes.

[0028] Record all user operations on the business data management platform, including but not limited to login, data query, and modification operations.

[0029] According to a second aspect of the present invention, a packaging workshop business data management system is provided, comprising:

[0030] The data acquisition module is used to collect data related to process quality, equipment, and production business of the packaging workshop, standardize the format of the collected data, and store the standardized data in a database. The relevant data includes but is not limited to data from the packaging machine, packaging machine, conveyor line, sensor, control system, and manual records;

[0031] A platform construction module, used to establish a business data management platform based on the relevant data stored in the database, wherein a volume package business logic tree diagram is constructed in the business data management platform;

[0032] The data query and management module is used to query and manage the business data involved in each business node through the volume package business logic tree diagram.

[0033] According to a third aspect of the present invention, there is provided an electronic device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the above-mentioned method for managing business data of a packaging workshop when executing the computer program.

[0034] According to a fourth aspect of the present invention, there is provided a computer-readable storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the steps of the above-mentioned method for managing business data of a packaging workshop.

[0035] The packaging workshop business data management method, system, device and storage medium disclosed in the present invention have the following technical effects:

[0036] A roll-wrapping business logic tree diagram is built in the business data management platform, through which the business data involved in each business node can be queried and managed. It realizes the comprehensive digital management of the roll-wrapping workshop business data and improves the data utilization efficiency; it breaks the data barriers between business modules, realizes the intercommunication and sharing of data, and improves the efficiency of business collaboration; it simplifies the communication between business personnel and data management personnel, and improves the convenience of business data management; it realizes the effective management and maintenance of the roll-wrapping workshop business data and ensures the reliability of the data.

[0037] Further features and advantages of the present invention will become apparent from the following detailed description of exemplary embodiments of the present invention with reference to the attached drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0038] The accompanying drawings, which are incorporated in and constitute a part of the specification, illustrate embodiments of the invention and, together with the description, serve to explain the principles of the invention.

[0039] Figure 1 A schematic diagram of a process flow of a method for managing business data of a packaging workshop provided by an embodiment of the present invention;

[0040] Figure 2 A schematic diagram of the logical composition of a packaging workshop business data management system provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0041] Various exemplary embodiments of the present invention will now be described in detail with reference to the accompanying drawings. It should be noted that the relative arrangement of components and steps, numerical expressions and numerical values ​​set forth in these embodiments do not limit the scope of the present invention unless otherwise specifically stated.

[0042] The following description of at least one exemplary embodiment is merely illustrative in nature and is in no way intended to limit the invention, its application, or uses.

[0043] Technologies, methods, and equipment known to ordinary technicians in the relevant art may not be discussed in detail, but where appropriate, the technologies, methods, and equipment should be considered as part of the specification.

[0044] In all examples shown and discussed herein, any specific values ​​should be interpreted as merely exemplary and not limiting. Therefore, other examples of the exemplary embodiments may have different values.

[0045] In modern industrial production, efficient management of process quality, equipment status and production processes is the key to improving the competitiveness of enterprises. However, traditional management methods often have problems such as unclear business processes, serious data islands, and disconnection between business and data. This application sorts out the business processes and business data involved in each module according to the three modules of process quality, equipment, and production, and then configures the data source information of the database involved, obtains the database table structure and data, and establishes a tree-shaped business process diagram according to the business process of each module, and then associates the corresponding database table with the business nodes involved in the data, and finally realizes the association and control of business and data.

[0046] The present invention proposes an embodiment of a method for managing business data of a packaging workshop. Specifically, Figure 1 shown, including:

[0047] Collect data related to process quality, equipment, and production business of the packaging workshop, standardize the format of the collected data, and store the standardized data in a database, where the relevant data includes but is not limited to data from the packaging machine, packaging machine, conveyor line, sensor, control system, and manual records;

[0048] Specifically, the data of the cigarette rolling machine is to record the key parameters in the cigarette manufacturing process, such as cigarette length, weight, and draw resistance; the data of the packaging machine is to monitor various indicators in the packaging process, such as packaging speed, packaging quality (such as whether there is leakage, whether it is misaligned), etc.; the conveyor line data is to track the efficiency and stability of material flow, including failure time, maintenance records, etc.; sensor data includes real-time collection of environmental parameters such as ambient temperature, humidity, vibration, etc., to monitor the production environment; control system data includes production instructions, execution status and feedback information recorded by the automated control system; manually recorded data includes inspection records, fault reports, operation logs, etc.

[0049] The format standardization of the collected data includes data cleaning (removing duplicate and invalid data), format conversion (unifying timestamps and data types), data integration (integrating related data into a unified format), etc., to ensure data consistency and manageability.

[0050] Based on the relevant data stored in the database, a business data management platform is established, wherein a roll-packing business logic tree diagram is constructed in the business data management platform; specifically, the business data management platform integrates data visualization, query, analysis, and management functions. The roll-packing business logic tree diagram displays the entire production process from raw materials entering the factory to finished products leaving the warehouse in a tree structure, and each node represents a business link or equipment unit, such as a roll-joining machine, a packaging machine, a conveyor line, etc.

[0051] Through the volume package business logic tree diagram, the business data involved in each business node is queried and managed, where the business data includes but is not limited to database type, server IP, database name, database table structure and table data involved. The business data management platform supports further analysis of the queried data, such as generating reports, drawing trend charts, performing anomaly detection, etc., to help users better understand the business status and discover potential problems. Users can perform operations such as adding, deleting, modifying and querying data on the business data management platform, such as updating equipment status, recording maintenance information, modifying process parameters, etc., to achieve real-time synchronization and management of data.

[0052] In an embodiment of the present invention, the step of establishing a business data management platform based on the relevant data stored in the database includes:

[0053] Complete the configuration of the data source by configuring the database type, database name, server IP, port, user name, and password of the database; specifically, select the appropriate database type according to business requirements and data characteristics, such as relational databases (such as MySQL, Oracle) or non-relational databases (such as MongoDB, Redis). Enter the user name and password for database access and perform identity authentication. This is an important measure to protect data security and prevent unauthorized access.

[0054] According to the business logic of the three modules of process quality, equipment, and production, table tags with a tree structure are set, and the corresponding database tables are associated with the business tags involving data storage to build a volume package business logic tree diagram. Specifically, dividing the system into modules such as process quality, equipment, and production helps reduce system complexity and improve maintainability. Within each module, a tree structure is used to organize table tags. When it is necessary to query or modify data, the platform can quickly locate the corresponding database table based on the business tag and perform the corresponding operation. The entire business logic tree diagram is displayed through a graphical interface, making the business logic more intuitive and easy to understand. This facilitates communication and collaboration between business personnel and technical personnel and improves development efficiency.

[0055] In the embodiment of the present invention, the step of establishing a business data management platform based on the relevant data stored in the database further includes: after completing the data source configuration, obtaining the table structure and data of each database, customizing the query conditions according to business needs, and directly viewing the table structure (including table name, field name, data type, etc.) and data of each table under each database on the business data management platform. Users can select a specific table according to their needs, define filtering conditions (such as field value range, keyword search, etc.), as well as sorting and paging options, so as to accurately obtain the required data set.

[0056] In an embodiment of the present invention, before constructing the logic tree diagram of the coil packaging business, it also includes sorting out the various business logics of the coil packaging workshop, including but not limited to obtaining the overall process of the business, key business nodes, and the relationship and dependency between the businesses. First, it is necessary to clarify the overall operation process of the coil packaging workshop, including all links from raw material warehousing, production plan formulation, production task allocation, production processing, quality control, finished product packaging to final delivery. In the overall process, identify the key nodes that have a significant impact on production progress, quality control, cost control, etc., such as raw material inspection, key process operation, finished product testing, etc., and use data analysis (such as failure points and bottleneck links in statistical historical data), expert review, simulation testing and other means to accurately locate the key nodes. Understand and sort out the complex relationships between various business activities such as the order of precedence, parallel relationship, conditional dependency, etc., to ensure logical coherence and rationality. Use tools such as flow charts and relationship diagrams to visualize the logical relationship between businesses.

[0057] In an embodiment of the present invention, after the volume package business logic tree diagram is constructed, it is visualized on the business data management platform. The business data management platform adopts a graphical interface design, and presents the volume package business logic tree diagram through visual elements such as tree diagrams, which can dynamically display the hierarchy and association of data, allowing users to easily browse and navigate. Visual display makes the business data management platform more intuitive and easy to use. Visual display also promotes collaboration and communication among team members. Employees from different departments can share information and knowledge by viewing the same visual report, thereby breaking down departmental barriers and information islands.

[0058] In an embodiment of the present invention, the method for managing business data of a packaging workshop further includes: updating the packaging business logic tree diagram in real time according to changes in actual business requirements, including:

[0059] Adding nodes: For newly added business links, add nodes to the corresponding positions in the tree diagram and associate new database tables with them or modify the existing table structure to support the storage of new data;

[0060] Delete nodes: For outdated business links, delete the corresponding nodes from the tree diagram;

[0061] Modify nodes: For business links that need to be adjusted or optimized, modify the description and properties of the corresponding nodes in the tree diagram, and update the associated database tables or fields to reflect the new business logic.

[0062] By modifying nodes, you can adjust and optimize business processes and improve the efficiency and accuracy of business processing. The optimized business logic and interface design can enhance user operating experience and satisfaction.

[0063] In an embodiment of the present invention, the method for managing business data of a packaging workshop further includes a permission management step, including:

[0064] Obtain the different roles and responsibilities of the packaging workshop; such as process quality manager, equipment maintenance engineer, production planner, etc. Each role should have different access and management permissions to business data.

[0065] According to the different roles and responsibilities obtained, the permissions are subdivided into different levels of read, write, modify, and delete;

[0066] On the business data management platform, set up the mapping relationship between roles and permissions to ensure that each role can automatically obtain the corresponding permissions, and support dynamic adjustment of permissions, including adding roles, deleting roles, modifying role permissions, etc.;

[0067] Assign data access rights based on user roles, and refine access control policies based on data attributes.

[0068] Record all user operations on the business data management platform, including but not limited to login, data query, and modification operations.

[0069] Intelligent algorithms are used to monitor users’ abnormal behavior patterns, such as frequent attempts to access unauthorized data, to promptly identify and address potential security risks.

[0070] The present invention also provides an embodiment of a business data management system for a packaging workshop, specifically, as follows Figure 2 As shown, including:

[0071] The data acquisition module is used to collect data related to process quality, equipment, and production business of the packaging workshop, standardize the format of the collected data, and store the standardized data in a database. The relevant data includes but is not limited to data from the packaging machine, packaging machine, conveyor line, sensor, control system, and manual records;

[0072] A platform construction module, used to establish a business data management platform based on the relevant data stored in the database, wherein a volume package business logic tree diagram is constructed in the business data management platform;

[0073] The data query and management module is used to query and manage the business data involved in each business node through the volume package business logic tree diagram.

[0074] It should be noted that the information interaction, execution process and other contents between the above-mentioned modules are based on the same concept as the method embodiment of the present application, and are a system corresponding to the above-mentioned wrapping workshop business data management method. All implementation methods in the above-mentioned method embodiment are applicable to the embodiment of the system. Its specific functions and the technical effects brought about can be found in the method embodiment part, which will not be repeated here.

[0075] The present invention collects, stores, processes and analyzes various business data (such as production progress, equipment status, raw material consumption, product quality, etc.) in a roll-wrapping workshop in real time, presents the operation status of the workshop in digital form, and realizes the refinement, intelligence and efficiency of workshop management. An efficient database system is constructed to centrally store and manage the collected data. The processed data is presented to management personnel in the form of visual charts, reports, etc. to assist them in making decisions, and at the same time simplifies the communication between business personnel and data management personnel. The business process of the roll-wrapping workshop is comprehensively combed, and a business logic tree diagram is constructed according to the combing results of the business process. Through the structural navigation of the tree diagram and rich data query functions, the data management process is simplified and the work efficiency is improved. Through the business logic tree diagram, the query and management of the business data involved in each business node are realized, the data barriers between business modules are broken, the intercommunication and sharing of data are realized, and the business collaboration efficiency is improved. The table structure and data of each table under each database can be directly viewed on the data management platform to realize the effective management and maintenance of business data, including regular backup and recovery testing of data to ensure the security and availability of data in unexpected situations.

[0076] The present invention also provides an embodiment of an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the above-mentioned method for managing business data of a packaging workshop when executing the computer program.

[0077] The present invention also provides an embodiment of a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the steps of the above-mentioned method for managing business data of a packaging workshop are implemented.

[0078] The computer-readable medium shown in the present invention 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 invention, 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 invention, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, in which a computer-readable program code is carried. 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-readable 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-readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, optical cable, RF, etc., or any suitable combination of the above.

[0079] The computer-readable medium may be included in the electronic device described in the above embodiment; or it may exist independently without being assembled into the electronic device. The above computer-readable medium carries one or more programs. When the above one or more programs are executed by the electronic device, the electronic device implements the method for managing business data of a packaging workshop as described in the above embodiment.

[0080] The above describes in detail the structure, features and effects of the present invention based on the embodiments shown in the drawings, but the above is only a preferred embodiment of the present invention. It should be noted that the technical features involved in the above embodiments and their preferred methods can be reasonably combined and matched into a variety of equivalent schemes by those skilled in the art without departing from or changing the design ideas and technical effects of the present invention; therefore, the present invention is not limited to the scope of implementation shown in the drawings, and all changes made in accordance with the concept of the present invention, or modifications to equivalent embodiments with equivalent changes, which still do not exceed the spirit covered by the specification and drawings, should be within the protection scope of the present invention.

Claims

1. A method for managing business data of a packaging workshop, characterized in that: include: Collect data related to process quality, equipment, and production business of the coiling and packaging workshop, standardize the format of the collected data, and store the standardized data in a database, where the relevant data includes but is not limited to data from coiling machines, packaging machines, conveyor lines, sensors, control systems, and manual records; Based on the relevant data stored in the database, a business data management platform is established, wherein a volume package business logic tree diagram is constructed in the business data management platform; Through the volume-wrapped business logic tree diagram, the business data involved in each business node is queried and managed, where the business data includes but is not limited to database type, server IP, database name, database table structure and involved table data.

2. The method for managing business data of a packaging workshop according to claim 1, characterized in that: The step of establishing a business data management platform based on the relevant data stored in the database includes: Complete the configuration of the data source by configuring the database type, database name, server IP, port, user name and password of the database; According to the business logic of the three modules of process quality, equipment and production, table tags with tree structure are set up, the corresponding database tables are associated with the business tags involving data storage, and a volume packaging business logic tree diagram is constructed.

3. The method for managing business data of a packaging workshop according to claim 2, characterized in that: The step of establishing a business data management platform based on the relevant data stored in the database also includes: After completing the data source configuration, obtain the table structure and data of each database, customize the query conditions according to business needs, and directly view the table structure and data of each table under each database on the business data management platform.

4. The method for managing business data of a packaging workshop according to claim 1, characterized in that: Before constructing the roll packaging business logic tree diagram, it also includes sorting out the various business logics of the roll packaging workshop, including but not limited to obtaining the overall business process, key business nodes, and the relationship and dependency between businesses.

5. The method for managing business data of a packaging workshop according to claim 4, characterized in that: After the volume package business logic tree diagram is built, it is visualized on the business data management platform.

6. The method for managing business data of a packaging workshop according to claim 1, characterized in that: Also includes: According to the changes in actual business needs, the volume package business logic tree diagram is updated in real time, including: Adding nodes: For newly added business links, add nodes to the corresponding positions in the tree diagram and associate new database tables with them or modify the existing table structure to support the storage of new data; Delete nodes: For outdated business links, delete the corresponding nodes from the tree diagram; Modify nodes: For business links that need to be adjusted or optimized, modify the description and properties of the corresponding nodes in the tree diagram, and update the associated database tables or fields to reflect the new business logic.

7. The method for managing business data of a packaging workshop according to any one of claims 1 to 6, characterized in that: It also includes permission management steps, including: Get the different roles and their responsibilities in the wrapping shop; According to the different roles and responsibilities obtained, the permissions are subdivided into different levels of read, write, modify, and delete; On the business data management platform, set the mapping relationship between roles and permissions; Assign data access rights based on user roles, and refine access control policies based on data attributes. Record all user operations on the business data management platform, including but not limited to login, data query, and modification operations.

8. A business data management system for a packaging workshop, characterized in that: include: The data acquisition module is used to collect data related to process quality, equipment, and production business of the packaging workshop, standardize the format of the collected data, and store the standardized data in a database. The relevant data includes but is not limited to data from the packaging machine, packaging machine, conveyor line, sensor, control system, and manual records; A platform construction module, used to establish a business data management platform based on the relevant data stored in the database, wherein a volume package business logic tree diagram is constructed in the business data management platform; The data query and management module is used to query and manage the business data involved in each business node through the volume package business logic tree diagram.

9. An electronic device, characterized in that: The method comprises a memory, a processor and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, the steps of the method for managing business data of a packaging workshop as claimed in any one of claims 1 to 7 are implemented.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method for managing business data of a packaging workshop as described in any one of claims 1 to 7 are implemented.

Images