CN112712257A - Dock logistics data management method based on mysql database - Google Patents
Dock logistics data management method based on mysql database Download PDFInfo
- Publication number
- CN112712257A CN112712257A CN202011608837.6A CN202011608837A CN112712257A CN 112712257 A CN112712257 A CN 112712257A CN 202011608837 A CN202011608837 A CN 202011608837A CN 112712257 A CN112712257 A CN 112712257A
- Authority
- CN
- China
- Prior art keywords
- logistics
- wharf
- area
- planning
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06N—COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS
- G06N3/00—Computing arrangements based on biological models
- G06N3/12—Computing arrangements based on biological models using genetic models
- G06N3/126—Evolutionary algorithms, e.g. genetic algorithms or genetic programming
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/083—Shipping
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- Economics (AREA)
- Theoretical Computer Science (AREA)
- Life Sciences & Earth Sciences (AREA)
- Health & Medical Sciences (AREA)
- Development Economics (AREA)
- Biophysics (AREA)
- General Physics & Mathematics (AREA)
- Entrepreneurship & Innovation (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Operations Research (AREA)
- Marketing (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Educational Administration (AREA)
- Evolutionary Biology (AREA)
- Bioinformatics & Computational Biology (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Genetics & Genomics (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- General Engineering & Computer Science (AREA)
- Computing Systems (AREA)
- Molecular Biology (AREA)
- General Health & Medical Sciences (AREA)
- Evolutionary Computation (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Biomedical Technology (AREA)
- Artificial Intelligence (AREA)
- Physiology (AREA)
- Game Theory and Decision Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention adopts the quantum genetic algorithm to improve the genetic algorithm, analyzes the logistics ship scheduling problem, can not meet the requirement of actual scheduling in the traditional static logistics ship scheduling, and more accords with the reality in the dynamic ship scheduling, and establishes a dynamic ship scheduling mathematical model with delivery time constraint and ship load constraint by taking the minimum transportation cost as an optimization target. On the basis of analyzing the existing wharf logistics system evaluation method, a novel wharf logistics system comprehensive evaluation method based on an analytic hierarchy process and a entropy method is provided, the traditional manual form filling, order handling and information transmission operation modes of wharf enterprises are changed, the wharf yard operation efficiency is improved, and the accuracy of wharf enterprise information transmission is improved. And (3) drawing up a yard resource allocation strategy, wherein in the actual operation process, the wharf yard operation optimization strategy is related to the loading and unloading capacity of wharf yard operation. In the process of realizing yard allocation and control, the steps of allocating areas, matching equipment and yards and optimizing the optimal areas need to be perfected, so that the efficiency of wharf yard operation is improved.
Description
Technical Field
The application belongs to the field of data processing, and particularly relates to a dock logistics data management method based on a mysql database.
Background
With the rapid growth of international trade and multinational operation, international maritime transportation and modern logistics are gradually fused, and a wharf becomes an important hub node of an international sea-land logistics channel, an important link of an international logistics supply chain and an important logistics center; since more than 90% of international trade is accomplished by sea transportation, the demand for multimodal intermodal and comprehensive logistics services is increasing in order to reduce inventory, improve transportation efficiency, and reduce transportation costs. Therefore, the development of the comprehensive logistics service of the wharf becomes a preferred target for the development of business of each wharf and shipping company; the wharf is used as a connection point of marine transportation and land transportation, is a place for transferring, reloading and collecting and distributing goods, and determines that the wharf is closely related to production and manufacturing enterprises, transportation enterprises, storage enterprises and marketing enterprises. In order to fully play the role of the important nodes of the wharf on the modern logistics supply chain, the functions of the wharf are developing from a transportation center, a distribution center to the nodes of the global integrated transportation network of the third generation wharf and the modern integrated logistics center.
Each link of the traditional wharf logistics system is mutually divided and disjointed, the service standards are not unified, the logistics links are multiple, the cost is high, and the efficiency is low; modern wharf logistics emphasizes integration of system logistics resources to achieve rationalization, systematization, integration, standardization and functionalization of logistics service, logistics service efficiency is greatly improved, and logistics service cost is reduced. Therefore, the modern wharf logistics system planning is beneficial to practically converting the management and management modes of wharf enterprises, realizing the resource integration of wharf logistics elements according to the requirements of modern logistics, realizing the logistics management and control by taking customer service as the center and continuously improving the wharf logistics service.
However, in the aspect of operation of the wharf logistics system, the informatization problem of wharf enterprises is emphasized too much, and the integration problem of related enterprise logistics information on a wharf logistics supply chain is ignored; the research of the wharf logistics system planning theory and method based on the supply chain aims to guide practice, scientifically guide wharf logistics system planning, optimize wharf logistics system resource allocation and improve wharf logistics operation efficiency, solve the problems of repeated construction, facility redundancy and service bottleneck of wharf logistics infrastructure, the research method has high academic theoretical value and high practical application value, and the modern scientific and technical theoretical method is fully applied to research and solve the practical problems of wharf logistics system planning and development.
Disclosure of Invention
In order to solve the problem of electronization of the current dock logistics, the application requests protection of a dock logistics data management method based on a mysql database, the method is operated on a system based on Spring + SrpingMVC + MyBatis framework integration development and the mysql database, project management is performed by adopting Maven, and framework configuration mainly comprises six configuration files including a Spring configuration file, a SpringMVC configuration file, a MyBatis configuration file, an internet project configuration file, a database configuration file and a Maven configuration file, and the method is characterized in that:
step 1: carrying out wharf logistics planning and positioning, making a decision on the wharf logistics planning and positioning, making a decision on a wharf logistics chain transfer node distribution center, and optimizing wharf logistics collection and distribution lines and transportation modes;
step 2: determining the scale of wharf logistics facilities, determining the scale of wharf logistics facilities by using a demand berth operation capacity correlation method, analyzing the characteristics of the wharf logistics demands, and performing neural network prediction of the logistics demands and wharf throughput demand combined prediction based on a genetic algorithm;
and step 3: planning a logistics wharf area, wherein the planning comprises the concept of a logistics wharf, redefining the planning range of the wharf area and planning a double-layer system layout design of the logistics wharf area;
and 4, step 4: the wharf logistics system operation processing is carried out, yard management is carried out, the wharf logistics system operation mechanism is analyzed, the wharf logistics information system function structure is analyzed, the wharf logistics information system planning framework is constructed, and the internet of things technology is utilized to collect logistics data.
And 5: and evaluating the wharf logistics system by combining an unexpected event processing decision in the logistics process, establishing a wharf logistics system evaluation index system design, and comprehensively evaluating the wharf logistics system by adopting an analytic hierarchy process.
The invention combines the quantum evolutionary theory and the genetic algorithm, improves the genetic algorithm by adopting the quantum genetic algorithm, analyzes the logistics ship scheduling problem, can not meet the requirement of actual scheduling by the traditional static logistics ship scheduling, and more accords with the reality of dynamic ship scheduling, and establishes a dynamic ship scheduling mathematical model with delivery time constraint and ship load constraint by taking the minimum transportation cost as an optimization target. On the basis of analyzing the existing wharf logistics system evaluation method, a novel wharf logistics system comprehensive evaluation method based on an analytic hierarchy process and a entropy method is provided, the traditional manual form filling, order handling and information transmission operation modes of wharf enterprises are changed, the wharf yard operation efficiency is improved, and the accuracy of wharf enterprise information transmission is improved. And (3) drawing up a yard resource allocation strategy, wherein in the actual operation process, the wharf yard operation optimization strategy is related to the loading and unloading capacity of wharf yard operation. In the process of realizing yard allocation and control, the steps of allocating areas, matching equipment and yards and optimizing the optimal areas need to be perfected, so that the efficiency of wharf yard operation is improved.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are required to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present application and therefore should not be considered as limiting the scope, and for those skilled in the art, other related drawings can be obtained from the drawings without inventive effort.
Fig. 1 is a work flow chart of a dock logistics data management method based on mysql database according to the present invention.
Detailed Description
Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
The invention relates to a wharf logistics data management method based on a mysql database, which is operated on a system based on Spring + SrpingMVC + MyBatis framework integration development and the mysql database, adopts Maven to perform project management, and the framework configuration mainly comprises six configuration files, namely a Spring configuration file, a Spring MVC configuration file, a MyBatis configuration file, an internet project configuration file, a database configuration file and a Maven configuration file, and is characterized in that:
step 1: carrying out wharf logistics planning and positioning, making a decision on the wharf logistics planning and positioning, making a decision on a wharf logistics chain transfer node distribution center, and optimizing wharf logistics collection and distribution lines and transportation modes;
step 2: determining the scale of wharf logistics facilities, determining the scale of wharf logistics facilities by using a demand berth operation capacity correlation method, analyzing the characteristics of the wharf logistics demands, and performing neural network prediction of the logistics demands and wharf throughput demand combined prediction based on a genetic algorithm;
and step 3: planning a logistics wharf area, wherein the planning comprises the concept of a logistics wharf, redefining the planning range of the wharf area and planning a double-layer system layout design of the logistics wharf area;
and 4, step 4: the wharf logistics system operation processing is carried out, yard management is carried out, the wharf logistics system operation mechanism is analyzed, the wharf logistics information system function structure is analyzed, the wharf logistics information system planning framework is constructed, and the internet of things technology is utilized to collect logistics data.
And 5: and evaluating the wharf logistics system by combining an unexpected event processing decision in the logistics process, establishing a wharf logistics system evaluation index system design, and comprehensively evaluating the wharf logistics system by adopting an analytic hierarchy process.
Preferably, the method is operated on a system based on Spring + SrpingMVC + MyBatis framework integration development and mysql database, project management is performed by using Maven, and the framework configuration mainly comprises six configuration files including a Spring configuration file, a SpringMVC configuration file, a MyBatis configuration file, an internet project configuration file, a database configuration file and a Maven configuration file, and specifically comprises the following steps:
the communication link combines the link transmission with the communication vector change on the basis of realizing data updating and control, and combines the data parameter, the matrix radius and the like on the basis of adjusting the matrix parameter, the data transmission and the like. On the basis of realizing the analysis and control of the characteristic vector, the aspects of matrix adoption number, nonnegative characteristic vector and the like are controlled, the link gain matrix is analyzed firstly on the basis of realizing the data transmission and control by combining the change of data parameters, the characteristic value of the maximum real number is calculated, if the optimal power control vector cannot be obtained, all possible combinations of the mobile station are removed, the characteristic value of the subsystem gain matrix is calculated, and the characteristic vector is calculated and analyzed according to the cyclic change of the matrix. According to the requirements of yard management operation, in the process of improving the yard operation by using a mathematical algorithm, under the condition of realizing the yard operation and management, the communication data information is counted according to the yard operation data, so that the information acquisition, transmission and control of the yard management are realized. And (4) selecting an Apriori algorithm, and generating a data mining mechanism of closed detection through the candidate set.
On the basis of analyzing aspects such as communication transmission and link information control, a calculation formula of a link signal-to-noise ratio γ of a user i is shown as a formula (1):
wherein i ≠ j, i ≠ 1,2,3.. Q, j ≠ 1, 2.. Q.
Preferably, the step 1: carry out pier logistics planning location, plan the location and make a decision to the pier logistics, pier logistics chain transfer node distribution center location decision-making, pier logistics collection distribution line and transportation mode optimize, specifically include:
according to the rationalization requirements of the regional logistics system and the wharf building conditions, selecting a position suitable for building a wharf, and enabling the logistics service cost of a wharf radiation region to be the lowest; determining which wharf is selected as a transfer wharf on different wharf logistics chains, so that the cost for a client to receive the wharf logistics chain service is the lowest;
(1) spring profile (application context. xml): setting a scanning javaBean; introducing a database configuration file through a context tag; c3p0 connection pool is set; registering an sqlSessionsFactoryBean, including automatically scanning Mappers. xml files and MyBatis Total configuration file paths; setting an annotation drive; a Mapper interface scanner is provided.
(2) SpringMVC profile (SpringMVC-servlet. xml): setting a packet where a scanning control layer is located; registering an MVC annotation driver, including a JSON converter; setting a setting mode that static resources can be accessed, wherein the setting relates to accessing the static resources such as pictures; setting a view parser; configure file upload parser and upload file size limit.
(3) MyBatis profile (MyBatis-config.xml): its main configuration information is integrated into the Spring framework. Only the POJO alias and the log need be defined.
(4) Internet project profile (web.xml): setting a character messy code filter to solve the problem of post messy code of SpringMVC; setting an operating filter; setting a SpringMVC core controller; setting a mapping mode as ". action"; an adapter Spring container and its configuration file are set.
(5) Database configuration files (db). Setting a JDBC driver; setting JDBC uniform resource locator; setting a database user name; and setting a database user password.
(6) Maven profile (pom. xml), various dependencies used by the setup platform and plug-ins such as: jar packages required by Spring, Spring MVC and MyBatis frameworks; a jar packet required by unit test Junit; jar package required for LOG 4J; plugins plug-ins and the like
Reasonably distributing the object flow to a plurality of wharfs providing logistics service;
establishing a corresponding positioning model for determining one or more wharf positions for providing logistics service;
and (4) minimizing the logistics cost into an objective function, and planning and positioning the wharf logistics by adopting a minimum cost flow method and a double-layer model method.
Preferably, the step 2: determining the scale of wharf logistics facilities, determining the scale of wharf logistics facilities by using a demand berth operation capacity correlation method, analyzing the characteristics of the wharf logistics demands, and performing neural network prediction of the logistics demands and wharf throughput demand combined prediction based on a genetic algorithm, wherein the method further comprises the following steps:
predicting the logistics demand of the wharf according to a scientific method, determining the berth passing capacity according to the relevant technical specification and the average logistics operation efficiency of the domestic and foreign main logistics wharfs, solving the number of berths in a planned wharf area, measuring and calculating the required wharf area warehousing facility area or warehouse capacity, the wharf collection and distribution facility operation area, the wharf logistics park area, the equipment allocation number and the wharf logistics management informatization requirement according to the wharf area plane design technical specification, and finally determining the required wharf area total planning area;
the wharf logistics demand constituent elements comprise wharf logistics demand quantity, time, space, structure and hierarchy elements;
the wharf logistics demand model neural network model structure is three layers, namely an input layer, a hidden layer and an output layer, wherein the number of nodes of the input layer is larger than the number of regional economic variables for forecasting wharf logistics demand, and the number of output points is larger than the number of variables for forecasting logistics demand scale, and the number of the output points can be one or more; analyzing according to economic factors influencing wharf commodity flow, wherein the influencing factors at least comprise regional GDP, three industry added values, foreign trade import and export total amount, regional goods turnover amount and regional social commodity retail total amount indexes; the output layer of the wharf logistics demand prediction model is generally provided with only one node.
Preferably, the step 3: planning the logistics wharf area, including the concept of the logistics wharf, redefining the planning range of the wharf area and the layout design of the double-layer system for planning the logistics wharf area, and further comprising:
a top-down method is adopted, namely, after the planning principle of a logistics code area is determined, core factors related to code logistics function planning are listed and analyzed;
the logistics wharf area is divided into a wharf operation area, a container storage area, a bonded storage area, a dangerous goods storage area, a circulation processing area, a logistics business area and a management service area, each functional area is defined according to practical experience of international logistics wharf planning and combined with the actual logistics requirements of the wharf area obtained through market investigation, corresponding land area is reasonably distributed, and related facilities, equipment and an IT system are introduced;
by applying the basic principle of the plant facility arrangement technology in the IE theoretical technology, the logistics wharf area plane arrangement problem is decomposed into two layers of wharf area whole function block plane arrangement and function block internal plane arrangement, and the wharf area whole function arrangement adopts a correlation analysis method and a material flow analysis method in an SLP method;
predicting and determining the material flow among the functional blocks by using a statistical analysis method, calculating the design capability of each functional block and determining the required occupied area to form a relational network diagram;
secondly, adjusting mutual positions according to the relevance of the functional areas, and replacing nodes in the relational network graph with actual areas to form a spatial relational graph; and finally, local adjustment is carried out according to the actual topographic map and factors of the peripheral roads inside and outside the wharf area to form a plurality of optional schemes, and the optimal functional area layout map is determined after the scheme evaluation ratio is preferred.
Preferably, the step 4: the operation of pier logistics system is handled, carries out the stock dump management, carries out analysis, pier logistics information system functional structure analysis, the construction of pier logistics information system planning frame to the mechanism of pier logistics system operation, utilizes internet of things to gather the commodity circulation data, still includes:
managing the wharf yard management and operation flow, wherein the operations of box dismounting, data transmission or transfer and data management and control are taken as cores, so that the optimization of the wharf yard operation flow is realized;
storing the collected and processed information in a database form, and processing the contract, report and bill business expression modes;
establishing an operation plan, route selection and control evaluation model, detecting the operation condition of the system, establishing a logistics system decision model and assisting management personnel to make a logistics plan;
the operation flow application comprises static data, which mainly comprises attribute information, classification information, specification description, asset information and dynamic data of a wharf container, and mainly comprises container equipment operation data, maintenance management data, flow data, inventory information, yard management information and intermediate data processing data, which comprises various query information processing results, statistical analysis reports and yard operation completion conditions;
a user fills in customer information through terminal software to provide delivery requirements, delivery ship information is collected through the Internet of things technology, a ship scheduling system calls corresponding model modeling and carries out algorithm solving according to the delivery requirement information including delivery time, delivery places and delivery cargo quantity, and the optimal result of the solving is issued to a delivery ship executing a task.
In a yard management and operation flow system, the RFID tag is applied to store and manage related data, and on the basis of realizing data simulation and information control, comprehensive optimization in the aspects of data encryption control, information transmission and the like is realized on the basis of realizing data encryption and information processing through compiling processing and information control.
The radio frequency identification technology is applied to a storage yard management and operation flow system, and on the basis of realizing system function building and control function analysis, comprehensive optimization and control in the aspects of computer networks, readers, radio frequency tags and the like are realized through data simulation, information control and computer communication transmission.
Preferably, the step 5: the wharf logistics system is evaluated by combining an unexpected event processing decision in the logistics process, a wharf logistics system evaluation index system design is established, and the wharf logistics system is comprehensively evaluated by adopting an analytic hierarchy process, and the method further comprises the following steps:
the decision for handling the unexpected event in the logistics process comprises the following steps:
case reasoning, which acquires specific knowledge from the past emergency cases and uses the knowledge to solve the emergency;
regular reasoning, namely regularly describing expert knowledge in the relevant field, constructing an expert rule system, forming a reasoning machine according to the expert rule system, and simulating the reasoning ability of an expert for solving an emergency by utilizing the reasoning machine when the actual emergency is solved;
an emergency resource scheduling algorithm based on a greedy strategy schedules the emergency resource with the nearest distance to the incident place each time according to the quantity of the emergency resources and the distance between the emergency resource point and the incident place determined by an emergency decision scheme, and if the scheduled resource is not enough to the required resource, the resource with the nearest distance to the incident place is scheduled until the required resource is met;
the wharf logistics system evaluation index system comprises quantitative and qualitative indexes, wherein the evaluation of the qualitative index is divided into 9 grades, the grades are scored by adopting experts, and the scores of all indexes are given by combining related data;
and carrying out standardization processing on the indexes.
In case reasoning, a source case with the highest similarity to a target case is retrieved from a case base, and the similarity between the source case (sourceCase) and the target case (targetCase) needs to be calculated, wherein the calculation formula is as follows:
Sim(s，t)＝1-D(s，t) (2)
d (s, t) is the Euclidean distance after the normalization processing of the source case and the target case; k is a search attribute number; n is the total number of retrieval attributes; w is akIs the number k attribute weight; dk(s, t) is the normalized distance between the source case and the target case in the attribute dimension of number k.
The data types of the retrieval attributes are logic type and numerical type, and the two data types Dk(s, t) is calculated as follows:
logic type:
numerical type:
dk(s，t)＝|Psk-Ptk| (6)
wherein, PskIs the attribute value of the source case number k, PtkIs the attribute value of the target case number k; dk(s, t) is the distance between the source case and the target case in the attribute dimension of number k; max k is the maximum value of the attribute value numbered k in the case base, and min k is the minimum value of the attribute value numbered k in the case base.
The emergency resource scheduling algorithm based on the greedy strategy comprises the following steps:
calculating the distance between each resource point and the incident place:
where D represents a distance, n represents a resource number, R represents a resource point, A represents a venue, lng represents longitude, and lat represents latitude
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.
Claims (6)
1. A dock logistics data management method based on a mysql database runs on a system based on Spring + SrpingMVC + MyBatis framework integration development and the mysql database, project management is carried out by adopting Maven, and framework configuration mainly comprises six configuration files including a Spring configuration file, a springMVC configuration file, a MyBatis configuration file, an Internet project configuration file, a database configuration file and a Maven configuration file, and the method is characterized in that:
step 1: carrying out wharf logistics planning and positioning, making a decision on the wharf logistics planning and positioning, making a decision on a wharf logistics chain transfer node distribution center, and optimizing wharf logistics collection and distribution lines and transportation modes;
step 2: determining the scale of wharf logistics facilities, determining the scale of wharf logistics facilities by using a demand berth operation capacity correlation method, analyzing the characteristics of the wharf logistics demands, and performing neural network prediction of the logistics demands and wharf throughput demand combined prediction based on a genetic algorithm;
and step 3: planning a logistics wharf area, wherein the planning comprises the concept of a logistics wharf, redefining the planning range of the wharf area and planning a double-layer system layout design of the logistics wharf area;
and 4, step 4: the wharf logistics system operation processing is carried out, yard management is carried out, the wharf logistics system operation mechanism is analyzed, the wharf logistics information system function structure is analyzed, the wharf logistics information system planning framework is constructed, and the internet of things technology is utilized to collect logistics data.
And 5: and evaluating the wharf logistics system by combining an unexpected event processing decision in the logistics process, establishing a wharf logistics system evaluation index system design, and comprehensively evaluating the wharf logistics system by adopting an analytic hierarchy process.
2. The dock logistics data management method based on the mysql database as claimed in claim 1, wherein:
the step 1: carry out pier logistics planning location, plan the location and make a decision to the pier logistics, pier logistics chain transfer node distribution center location decision-making, pier logistics collection distribution line and transportation mode optimize, specifically include:
according to the rationalization requirements of the regional logistics system and the wharf building conditions, selecting a position suitable for building a wharf, and enabling the logistics service cost of a wharf radiation region to be the lowest; determining which wharf is selected as a transfer wharf on different wharf logistics chains, so that the cost for a client to receive the wharf logistics chain service is the lowest;
reasonably distributing the object flow to a plurality of wharfs providing logistics service;
establishing a corresponding positioning model for determining one or more wharf positions for providing logistics service;
and (4) minimizing the logistics cost into an objective function, and planning and positioning the wharf logistics by adopting a minimum cost flow method and a double-layer model method.
3. The dock logistics data management method based on the mysql database as claimed in claim 1, wherein:
the step 2: determining the scale of wharf logistics facilities, determining the scale of wharf logistics facilities by using a demand berth operation capacity correlation method, analyzing the characteristics of the wharf logistics demands, and performing neural network prediction of the logistics demands and wharf throughput demand combined prediction based on a genetic algorithm, wherein the method further comprises the following steps:
predicting the logistics demand of the wharf according to a scientific method, determining the berth passing capacity according to the relevant technical specification and the average logistics operation efficiency of the domestic and foreign main logistics wharfs, solving the number of berths in a planned wharf area, measuring and calculating the required wharf area warehousing facility area or warehouse capacity, the wharf collection and distribution facility operation area, the wharf logistics park area, the equipment allocation number and the wharf logistics management informatization requirement according to the wharf area plane design technical specification, and finally determining the required wharf area total planning area;
the wharf logistics demand constituent elements comprise wharf logistics demand quantity, time, space, structure and hierarchy elements;
the wharf logistics demand model neural network model structure is three layers, namely an input layer, a hidden layer and an output layer, wherein the number of nodes of the input layer is larger than the number of regional economic variables for forecasting wharf logistics demand, and the number of output points is larger than the number of variables for forecasting logistics demand scale, and the number of the output points can be one or more; analyzing according to economic factors influencing wharf commodity flow, wherein the influencing factors at least comprise regional GDP, three industry added values, foreign trade import and export total amount, regional goods turnover amount and regional social commodity retail total amount indexes;
the output layer of the wharf logistics demand prediction model is generally provided with only one node.
4. The dock logistics data management method based on the mysql database as claimed in claim 1, wherein:
the step 3: planning the logistics wharf area, including the concept of the logistics wharf, redefining the planning range of the wharf area and the layout design of the double-layer system for planning the logistics wharf area, and further comprising:
a top-down method is adopted, namely, after the planning principle of a logistics code area is determined, core factors related to code logistics function planning are listed and analyzed;
the logistics wharf area is divided into a wharf operation area, a container storage area, a bonded storage area, a dangerous goods storage area, a circulation processing area, a logistics business area and a management service area, each functional area is defined according to practical experience of international logistics wharf planning and combined with the actual logistics requirements of the wharf area obtained through market investigation, corresponding land area is reasonably distributed, and related facilities, equipment and an IT system are introduced;
by applying the basic principle of the plant facility arrangement technology in the IE theoretical technology, the logistics wharf area plane arrangement problem is decomposed into two layers of wharf area whole function block plane arrangement and function block internal plane arrangement, and the wharf area whole function arrangement adopts a correlation analysis method and a material flow analysis method in an SLP method;
predicting and determining the material flow among the functional blocks by using a statistical analysis method, calculating the design capability of each functional block and determining the required occupied area to form a relational network diagram;
secondly, adjusting mutual positions according to the relevance of the functional areas, and replacing nodes in the relational network graph with actual areas to form a spatial relational graph; and finally, local adjustment is carried out according to the actual topographic map and factors of the peripheral roads inside and outside the wharf area to form a plurality of optional schemes, and the optimal functional area layout map is determined after the scheme evaluation ratio is preferred.
5. The dock logistics data management method based on the mysql database as claimed in claim 1, wherein:
the step 4: the operation of pier logistics system is handled, carries out the stock dump management, carries out analysis, pier logistics information system functional structure analysis, the construction of pier logistics information system planning frame to the mechanism of pier logistics system operation, utilizes internet of things to gather the commodity circulation data, still includes:
managing the wharf yard management and operation flow, wherein the operations of box dismounting, data transmission or transfer and data management and control are taken as cores, so that the optimization of the wharf yard operation flow is realized;
storing the collected and processed information in a database form, and processing the contract, report and bill business expression modes; establishing an operation plan, route selection and control evaluation model, detecting the operation condition of the system, establishing a logistics system decision model and assisting management personnel to make a logistics plan;
the operation flow application comprises static data, which mainly comprises attribute information, classification information, specification description, asset information and dynamic data of a wharf container, and mainly comprises container equipment operation data, maintenance management data, flow data, inventory information, yard management information and intermediate data processing data, which comprises various query information processing results, statistical analysis reports and yard operation completion conditions;
a user fills in customer information through terminal software to provide delivery requirements, delivery ship information is collected through the Internet of things technology, a ship scheduling system calls corresponding model modeling and carries out algorithm solving according to the delivery requirement information including delivery time, delivery places and delivery cargo quantity, and the optimal result of the solving is issued to a delivery ship executing a task.
6. The dock logistics data management method based on the mysql database as claimed in claim 1, wherein:
the step 5: the wharf logistics system is evaluated by combining an unexpected event processing decision in the logistics process, a wharf logistics system evaluation index system design is established, and the wharf logistics system is comprehensively evaluated by adopting an analytic hierarchy process, and the method further comprises the following steps:
the decision for handling the unexpected event in the logistics process comprises the following steps:
case reasoning, which acquires specific knowledge from the past emergency cases and uses the knowledge to solve the emergency;
regular reasoning, namely regularly describing expert knowledge in the relevant field, constructing an expert rule system, forming a reasoning machine according to the expert rule system, and simulating the reasoning ability of an expert for solving an emergency by utilizing the reasoning machine when the actual emergency is solved;
an emergency resource scheduling algorithm based on a greedy strategy schedules the emergency resource with the nearest distance to the incident place each time according to the quantity of the emergency resources and the distance between the emergency resource point and the incident place determined by an emergency decision scheme, and if the scheduled resource is not enough to the required resource, the resource with the nearest distance to the incident place is scheduled until the required resource is met;
the wharf logistics system evaluation index system comprises quantitative and qualitative indexes, wherein the evaluation of the qualitative index is divided into 9 grades, the grades are scored by adopting experts, and the scores of all indexes are given by combining related data;
and carrying out standardization processing on the indexes.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011608837.6A CN112712257A (en) | 2020-12-29 | 2020-12-29 | Dock logistics data management method based on mysql database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011608837.6A CN112712257A (en) | 2020-12-29 | 2020-12-29 | Dock logistics data management method based on mysql database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112712257A true CN112712257A (en) | 2021-04-27 |
Family
ID=75547203
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011608837.6A Pending CN112712257A (en) | 2020-12-29 | 2020-12-29 | Dock logistics data management method based on mysql database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112712257A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116303731A (en) * | 2023-05-22 | 2023-06-23 | 四川互慧软件有限公司 | Code matching method and device for hospital standard main data and electronic equipment |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130159208A1 (en) * | 2011-12-19 | 2013-06-20 | Byung Jun Song | Shipper-oriented logistics base optimization system |
| CN103902778A (en) * | 2014-04-04 | 2014-07-02 | 天津市市政工程设计研究院 | Microscopic simulation method for matching wharf stockpiling volume and berthing capability |
| CN106815707A (en) * | 2017-01-24 | 2017-06-09 | 大连大学 | A kind of scattered groceries storage yard intelligent dispatching system and method |
-
2020
- 2020-12-29 CN CN202011608837.6A patent/CN112712257A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130159208A1 (en) * | 2011-12-19 | 2013-06-20 | Byung Jun Song | Shipper-oriented logistics base optimization system |
| CN103902778A (en) * | 2014-04-04 | 2014-07-02 | 天津市市政工程设计研究院 | Microscopic simulation method for matching wharf stockpiling volume and berthing capability |
| CN106815707A (en) * | 2017-01-24 | 2017-06-09 | 大连大学 | A kind of scattered groceries storage yard intelligent dispatching system and method |
Non-Patent Citations (2)
| Title |
|---|
| 莫宝民: "《基于供应链的港口物流***规划方法研究》", 《中国优秀博硕士学位论文全文数据库(博士)》 * |
| 蔡胜胜: "《突发事件应急决策与处置平台设计与实现》", 《中国优秀博硕士学位论文全文数据库(硕士)》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116303731A (en) * | 2023-05-22 | 2023-06-23 | 四川互慧软件有限公司 | Code matching method and device for hospital standard main data and electronic equipment |
| CN116303731B (en) * | 2023-05-22 | 2023-07-21 | 四川互慧软件有限公司 | Code matching method and device for hospital standard main data and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112700192B (en) | Wharf logistics business object processing method based on spark Internet of things | |
| Choy et al. | A RFID-based storage assignment system for enhancing the efficiency of order picking | |
| Ji et al. | A mixed integer robust programming model for two-echelon inventory routing problem of perishable products | |
| Gattuso et al. | Advanced methodological researches concerning ITS in freight transport | |
| Gunawardhana et al. | Rule-based dynamic container stacking to optimize yard operations at port terminals | |
| Nagpal et al. | Use of data analytics to increase the efficiency of last mile logistics for ecommerce deliveries | |
| CN112712257A (en) | Dock logistics data management method based on mysql database | |
| Chu et al. | Vessel turnaround time prediction: A machine learning approach | |
| Gharehgozli et al. | Loading and unloading trains at the landside of container terminals | |
| CN116882673A (en) | Coal supply chain system and scheduling method | |
| US20230267400A1 (en) | Artificially intelligent warehouse management system | |
| Zhang et al. | The reliability measures model of multilayer urban distribution network | |
| Chen | Decision-making support for transportation and logistics combining rough set fuzzy logic algorithm | |
| Rouky et al. | Optimization under uncertainty: generality and application to multimodal transport | |
| CN111626666A (en) | Distributed storage yard mode | |
| Makarova et al. | A software module for multi-criteria suppliers’ selection with respect to the spare parts logistic | |
| Cannas et al. | Delay prediction in container terminals: A comparison of machine learning methods | |
| CN117455100B (en) | Intelligent warehouse logistics scheduling method based on global optimization | |
| Wei | Design of Intelligent Transportation Control System Based on Blockchain Technology | |
| Al-Ali | Shipment Containers tracking optimization using Machine Learning | |
| Ker et al. | Uber Freight: Assessment and Determination of Optimal Design Features for a Drop Trailer Service Offering and Network | |
| CN117035469B (en) | Method and device for measuring and calculating land indexes of public and railway intermodal transportation junction functional area construction | |
| Nair et al. | The Impact of Industry 4.0 on Supply Chain Management | |
| Elibal et al. | Maturity Models and Analysis for Industry 4.0 and Logistics 4.0 | |
| Doan et al. | Evaluating Transportation Routes Between China and Vietnam Based on Delphi–CFPR |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210427 |