Material management system based on data base

Abstract

The invention relates to the technical field of material management, and discloses a material management system based on a data base, comprising a business platform, a data base and a basic module which are in communication connection in sequence. According to the invention, the problems of errors of statistical data of each application module and the like in the prior art are solved.

Description

Technical Field

[0001] The present invention relates to the technical field of material management, in particular to a material management system based on a data base. Background Art

[0002] The traditional supply chain management system is a long chain process composed of multiple parts connected in series. In this process, there are five key links: supplier - manufacturer - distributor - retailer - consumer. Their tasks are sequential, that is, there are complex data dependencies between each link, and each module cannot operate independently. The material supply chain management system with this structure is not suitable for the management mode of large-scale equipment from design, supervision, delivery, logistics, and warehousing.

[0003] The existing supply chain management system does not have a unified data base. To ensure that each module can be used independently, the data in the module is defined independently in the module. For the common data between modules, the data between modules is shared through interfaces and stored separately, resulting in multiple mirroring and backup of data between modules. The data update mechanisms of each business system are different, which can easily cause data inconsistency and errors in the statistical data of each application module. This high coupling of data between modules also makes it difficult to upgrade and maintain each application module. Summary of the invention

[0004] In order to overcome the deficiencies of the prior art, the present invention provides a material management system based on a data base to solve the problems of errors in the statistical data of each application module existing in the prior art.

[0005] The technical solution adopted by the present invention to solve the above problems is:

[0006] A material management system based on a data base comprises a business platform, a data base and a basic module which are communicatively connected in sequence.

[0007] As a preferred technical solution, the data base includes a unified authentication platform, a basic data governance module, and a data model-oriented system integration module. The business platform, the data model-oriented system integration module, the unified authentication platform, and the basic module are communicated and connected in sequence. The business platform, the data model-oriented system integration module, the basic data governance module, and the basic module are communicated and connected in sequence.

[0008] As a preferred technical solution, the data base includes a UMC cloud platform management tool, and the UMC cloud platform management tool and the data model are communicated and connected with the system integration module, the unified authentication platform, and the basic module respectively.

[0009] As a preferred technical solution, the application module includes an expediting module that is communicatively connected to the data model-oriented system integration module.

[0010] As a preferred technical solution, the application module includes a manufacturing supervision module that is communicatively connected to the data model-oriented system integration module.

[0011] As a preferred technical solution, the application module includes a logistics module that is communicatively connected to the data model-oriented system integration module.

[0012] As a preferred technical solution, the application module includes a storage module that is communicatively connected to the data model-oriented system integration module.

[0013] As a preferred technical solution, the basic module includes one or more of the following modules: a personnel module, a personnel authority module, a project module, and a contract module.

[0014] As a preferred technical solution, the unified authentication platform includes one or more of the following modules: a unified user module, a unified authentication module, a unified authorization module, a unified audit module, and a unified application management and control module.

[0015] As a preferred technical solution, the data model is oriented to the system integration module, including a service bus and a data bus. The application module, the service bus, and the unified authentication platform are communicated and connected in sequence. The application module, the data bus, and the unified authentication platform are communicated and connected in sequence. The application module, the service bus, and the basic data governance module are communicated and connected in sequence. The application module, the data bus, and the basic data governance module are communicated and connected in sequence.

[0016] Compared with the prior art, the present invention has the following beneficial effects:

[0017] (1) The present invention adopts a data base method to uniformly encapsulate the shared data and permission management of each application module, realize unified storage and access of shared data, achieve data consistency and security, and enhance system data processing efficiency;

[0018] (2) The present invention reduces the coupling degree of each module. Each module can exist independently and be used alone, or multiple modules can be used simultaneously. The system is easy to maintain and upgrade.

[0019] (3) The present invention aims to break down data silos, ensure the accuracy of source data, promote data sharing, and protect data privacy and security. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] Figure 1 It is a structural schematic diagram of the present invention. DETAILED DESCRIPTION

[0021] The present invention will be further described in detail below in conjunction with embodiments and drawings, but the embodiments of the present invention are not limited thereto.

[0022] Example 1

[0023] like Figure 1 As shown, the purpose of the present invention is to provide a material management system based on a data base. In the material chain management, each module can work independently and can be highly coupled between modules to achieve a cluster effect.

[0024] The system includes basic modules such as personnel, personnel authority, projects, contracts, and application modules such as expediting, supervision, logistics, and warehousing. After the basic module data passes through IDM (unified authentication platform: unified user, unified authentication, unified authorization, unified audit, and unified application management and control) and MDM (basic data governance), it provides data to the ESB (data model for system integration) module. Using the UMC cloud platform management tool, IDM, MDM, ESB, and UMC modules together serve as the data base to provide basic data and business data for the application modules, manage the entire platform, and realize the integrated operation of enterprise data. The UMC cloud platform management tool is responsible for maintaining basic data governance to ensure the accuracy and integrity of the data. At the same time, the UMC cloud platform management tool is also responsible for cloud platform management to ensure the stable operation and efficient service of the cloud platform.

[0025] The system uses projects as management units. Projects can be assigned to personnel, and personnel's rights can be assigned to the projects to which they belong. The rights of each project are organized according to application modules such as delivery expediting, production supervision, logistics, and warehousing.

[0026] In the contract module of the basic module, basic data can be imported through the basic data template to generate basic data and application module data. The template includes fixed columns for projects and contracts. Application modules such as expediting, supervision, logistics, and warehousing occupy corresponding columns. However, if the personnel do not have permission for this project or have not filled it in, the data of the corresponding application module will not be generated.

[0027] The expediting module includes functions such as expediting work, engineer dynamics, expediting work modification records, overdue statistics, contract status statistics, login records, work arrangements, etc.

[0028] The delivery expediting work includes information such as contract status, warning status, arrival date, engineer, next step, advance warning days, etc. The contract status includes not started, in progress, and completed. The warning status includes normal, about to expire, and expired. The system automatically modifies the warning status at a regular interval.

[0029] Engineer dynamics include related contracts, current location, and next step. The current location is the location of the engineer when he modifies the collection work.

[0030] The modification record includes the modification time and modification content, and can record the changes made by personnel to the expedited delivery work.

[0031] Overdue statistics include the number of contracts that are about to expire and the number of contracts that have expired.

[0032] Contract status statistics include the number of contracts that have not yet started, are in progress, and have been completed.

[0033] Login records include login records and login time.

[0034] The work is arranged by the leader and confirmed by the engineer.

[0035] The supervision module includes supervision work, engineer dynamics, supervision work modification records, overdue statistics, contract status statistics, login records, work arrangements and other functions.

[0036] The supervision work includes information such as contract status, warning status, expected completion date, engineer, advance warning days, etc. The contract status includes not started, in progress, and completed. The warning status includes normal, about to expire, and expired. The system automatically modifies the warning status at a regular interval.

[0037] Engineer dynamics include relevant contracts, location, and work content. The location is the location where the engineer is when modifying the supervision work.

[0038] The modification record includes the modification time and modification content, which can record the changes made by personnel to the supervision work.

[0039] The content of overdue statistics includes the number of contracts that are about to expire and the number of contracts that have expired.

[0040] Contract status statistics include the number of contracts that have not yet started, are in progress, and have been completed.

[0041] Login records include login records and login time.

[0042] The work is arranged by the leader and confirmed by the engineer.

[0043] The logistics module has functions such as route planning, real-time supervision, and deviation alarm. It can plan special routes for large-scale transportation, intelligently avoid traffic peaks, and plan reasonable driving speeds. The logistics module uses Beidou positioning to display vehicle driving trajectory, speed and other information in real time, and can set up virtual electronic fences. When a vehicle deviates from the driving area, it will alarm in real time. Managers can correct the driver's wrong behavior in time and effectively control transportation timeliness and transportation costs.

[0044] The logistics module uses a heuristic search algorithm, which combines the actual distance from the starting point to the current node and the estimated distance from the current node to the target point in the path search to select the next node to explore. In logistics path planning, the actual distance from the starting point to the current node can be calculated based on factors such as transportation cost and travel time, and the estimated distance from the current node to the target point can be estimated using simple methods such as straight-line distance and Manhattan distance. The formula is: f(n) = g(n) + h(n), where f(n) is the total estimated cost from the starting point through node n to the target point, g(n) is the actual cost from the starting point to node n, and h(n) is the estimated cost from node n to the target point.

[0045] The vehicle scheduling of the logistics module adopts genetic algorithm to achieve the optimal scheduling plan. First, a set of initial vehicle scheduling plans are randomly generated as the population, and then the population is continuously evolved through operations such as selection, crossover and mutation, so that the scheduling plan in the population is gradually optimized. In the design of the fitness function, factors such as the vehicle's driving distance, transportation time, and vehicle utilization are comprehensively considered. For example, the fitness function Fitness = w1×total_distance+w2×total_time+w3×vehicle_utilization, where w1, w2, and w3 are weight coefficients, total_distance is the total distance traveled by the vehicle, total_time is the total transportation time, and vehicle_utilization is the vehicle utilization rate.

[0046] The logistics module also uses a cargo tracking and prediction algorithm to implement an alarm for cargo deviation from the plan. The cargo tracking and prediction uses the Kalman filter algorithm, which is based on the system's dynamic model and observation model, and continuously estimates and updates the system's state based on the current observation value. Its core formula includes the state prediction formula and the state update formula. The state prediction formula is: in is the predicted state at time k, is the optimal estimated state at time k-1, A is the state transfer matrix, B is the control input matrix, and uk is the control input at time k. The state update formula is in is the optimal estimated state at time k, K k is the Kalman gain, zk is the observation value at time k, and H is the observation matrix.

[0047] The storage module has functions such as warehousing management, outbound management, equipment assembly management, and inventory balance statistics. The storage module has an online environmental monitoring and video system to ensure that the temperature and humidity of the storage and assembly of materials in the warehouse meet the design requirements, and monitor the horizontal and vibration status of the equipment, and monitor whether the impact force of the equipment during the assembly process meets the design standards, to ensure assembly accuracy and ensure the safety of the equipment.

[0048] The present invention uses a unified input model for basic data such as authority management, personnel, projects, contracts, etc. to lead to a data base, which performs abstract clustering and data governance for data access by the business platform.

[0049] Each application module of the present invention exists independently, and the operation data does not depend on other application modules.

[0050] In the present invention, the module has expansion capability, and the later modules can add design, installation, operation and other modules to achieve the full life cycle management of equipment from design, manufacturing, transportation, storage, installation, operation, and scrapping.

[0051] The present invention has the following advantages:

[0052] 1. Real-time positioning and tracing of personnel in the management system facilitates the deployment of personnel between projects and reduces travel costs;

[0053] 2. Solve the problem of low automation due to incomplete image data;

[0054] 3. Solve the problems of difficult supervision and low intelligence level due to lack of big data analysis capabilities, inability to automatically deduce the risks of construction delay caused by each link through big data learning, and inability to provide early warning;

[0055] 4. Realize the function of digital warehouse management, realize the efficient combination of warehousing, transportation and on-site delivery, and use data to analyze inventory status.

[0056] As described above, the present invention can be preferably implemented.

[0057] All features disclosed in all embodiments in this specification, or steps in all methods or processes implicitly disclosed, except for mutually exclusive features and / or steps, can be combined and / or expanded or replaced in any manner.

[0058] The above description is only a preferred embodiment of the present invention and does not limit the present invention in any form. According to the technical essence of the present invention, within the spirit and principles of the present invention, any simple modification, equivalent replacement and improvement made to the above embodiment still falls within the protection scope of the technical solution of the present invention.

Claims

1. A material management system based on a data base, characterized in that: It includes a business platform, a data base and basic modules which are connected in sequence.

2. A material management system based on a data base according to claim 1, characterized in that: The data base includes a unified authentication platform, a basic data governance module, and a data model-oriented system integration module. The business platform, the data model-oriented system integration module, the unified authentication platform, and the basic module are communicated and connected in sequence. The business platform, the data model-oriented system integration module, the basic data governance module, and the basic module are communicated and connected in sequence.

3. A material management system based on a data base according to claim 2, characterized in that: The data base includes the UMC cloud platform management tool, which communicates and connects with the data model facing the system integration module, unified authentication platform, and basic module respectively.

4. A material management system based on a data base according to claim 2, characterized in that: The application module includes an expediting module which is communicatively connected with the data model-oriented system integration module.

5. A material management system based on a data base according to claim 2, characterized in that: The application module includes a manufacturing supervision module which is communicatively connected with the data model-oriented system integration module.

6. A material management system based on a data base according to claim 2, characterized in that: The application module includes a logistics module that is communicatively connected with the data model-oriented system integration module.

7. A material management system based on a data base according to claim 2, characterized in that: The application module includes a storage module that is communicatively connected with the data model-oriented system integration module.

8. A material management system based on a data base according to claim 2, characterized in that: The basic module includes one or more of the following modules: personnel module, personnel authority module, project module, and contract module.

9. A material management system based on a data base according to claim 2, characterized in that: The unified authentication platform includes one or more of the following modules: unified user module, unified authentication module, unified authorization module, unified audit module, and unified application management and control module.

10. A material management system based on a data base according to any one of claims 2 to 9, characterized in that: The data model is oriented to the system integration module, including the service bus and data bus. The application module, service bus, and unified authentication platform are communicated and connected in sequence. The application module, data bus, and unified authentication platform are communicated and connected in sequence. The application module, service bus, and basic data governance module are communicated and connected in sequence. The application module, data bus, and basic data governance module are communicated and connected in sequence.

Images