CN112215553A - Distributed control method and system for logistics database - Google Patents
Distributed control method and system for logistics database Download PDFInfo
- Publication number
- CN112215553A CN112215553A CN202011140292.0A CN202011140292A CN112215553A CN 112215553 A CN112215553 A CN 112215553A CN 202011140292 A CN202011140292 A CN 202011140292A CN 112215553 A CN112215553 A CN 112215553A
- Authority
- CN
- China
- Prior art keywords
- library
- logistics
- area
- database
- 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.)
- Granted
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/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/083—Shipping
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Economics (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Development Economics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the invention provides a distributed control method and a distributed control system for a logistics database, wherein the method comprises the following steps: separating logistics data of each library area from a database shared by the library areas according to attribute information of the library areas in the logistics system; respectively constructing a database of each reservoir area according to the separated logistics data of each reservoir area; respectively controlling the databases of each library area by using different management software; wherein each management software is respectively deployed on different servers. The embodiment of the invention realizes the distribution control of the logistics information of each storage area, is independent from each other, does not interfere with each other, and has stable data, thereby meeting the use requirements of the logistics system and improving the data analysis capability of the logistics server and the stability of the logistics system.
Description
Technical Field
The invention relates to the technical field of database management, in particular to a distributed control method and system for a logistics database.
Background
In a logistics system, a plurality of warehouse areas commonly share one server, when a manager of one warehouse area cannot be connected with a main service, the server needs to be restarted, so that normal operation of other warehouse areas is influenced, coordination work is needed, operation of the other two warehouse areas is suspended, current faults can be solved, and the solution efficiency is low.
Meanwhile, as the equipment runs for years and components are aged, the logistics server usually reports hardware faults. The failure of the logistics server in one storage area can affect the normal operation of other two storage areas, so that the hidden trouble of affecting production exists, and the problems of operation delay and the like caused by the failure of the server continuously occur in the use process.
In summary, in the prior art, a plurality of library areas related to production scheduling, inventory information, instructions and the like are concentrated in one server, and when an abnormal condition occurs in one library area, the server needs to be restarted to affect the other two library areas, so that the production rhythm of a workshop cannot be met.
Disclosure of Invention
The embodiment of the invention provides a distributed control method and a distributed control system for a logistics database, which are used for solving the defect that in the prior art, due to the fact that a plurality of library areas share one server, one library area is abnormal, and other library areas are affected, and realizing distributed control over the logistics database of each library area.
The embodiment of the invention provides a distributed control method for a logistics database, which comprises the following steps:
separating logistics data of each library area from a database shared by the library areas according to attribute information of the library areas in the logistics system;
respectively constructing a database of each reservoir area according to the separated logistics data of each reservoir area;
respectively controlling the databases of each library area by using different management software; wherein each management software is respectively deployed on different servers.
According to the distributed control method of the logistics database, the logistics data of each library area are separated from the database shared by the library areas according to the attribute information of the library areas in the logistics system; the step of respectively constructing the database of each library area according to the separated logistics data of each library area comprises the following steps:
for the table data of each user in the logistics system, separating the logistics data of each library area from each table data according to the attribute information of each library area;
respectively constructing a table according to the logistics data of each library area separated from each table data;
and constructing a database of each library area according to the newly constructed table of each library area.
According to the distributed control method of the logistics database in one embodiment of the present invention, the step of separating the logistics data of each library area from the database shared by the plurality of library areas according to the attribute information of the plurality of library areas in the logistics system further includes:
separating the table structure, the storage process, the view, the trigger and the table data of the logistics data of each library area according to the attribute information of a plurality of library areas in the logistics system;
correspondingly, the step of controlling the database of each library area by using different management software respectively further comprises the following steps:
and controlling the table structure, the storage process, the view, the trigger and the table data of the logistics data of each library area by using the management software corresponding to each library area.
According to the distributed control method of the logistics database in one embodiment of the invention, the step of controlling the database of each library area by using different management software respectively comprises the following steps:
when each library area is put in storage, the management software corresponding to each library area is used for modifying the database corresponding to each library area;
and when each library area is exported, modifying the database corresponding to each library area by using the management software corresponding to each library area.
According to the distributed control method of the logistics database in one embodiment of the invention, the step of controlling the database of each library area by using different management software respectively comprises the following steps:
if the quantity of the articles to be delivered from any storage area is smaller than the reserved quantity of the articles to be delivered from the database of the storage area, calculating the difference between the reserved quantity of the articles to be delivered and the quantity of the articles to be delivered;
if the reserved quantity of the articles to be delivered from the warehouse in the other warehouse areas except the warehouse area in the logistics system is not zero, distributing the articles to be delivered from the warehouse in the databases of the other warehouse areas to the database of the warehouse area according to the difference value based on the management software corresponding to the other warehouse areas, so that the reserved quantity of the articles to be delivered from the warehouse in the database of the warehouse area is larger than or equal to the reserved quantity of the articles to be delivered from the warehouse in the database of the warehouse area.
The embodiment of the present invention further provides a distributed control system for a logistics database, including:
the separation module is used for separating the logistics data of each library area from a database shared by the library areas according to the attribute information of the library areas in the logistics system;
the construction module is used for respectively constructing a database of each library area according to the separated logistics data of each library area;
the control module is used for controlling the databases of each library area by using different management software respectively; wherein each management software is respectively deployed on different servers.
According to the logistics database distributed control system of one embodiment of the invention, the separation module is specifically used for:
for the table data of each user in the logistics system, separating the logistics data of each library area from each table data according to the attribute information of each library area;
correspondingly, the building module is specifically configured to:
respectively constructing a table according to the logistics data of each library area separated from each table data;
and constructing a database of each library area according to the newly constructed table of each library area.
According to the logistics database distributed control system of one embodiment of the invention, the separation module is further configured to:
separating the table structure, the storage process, the view, the trigger and the table data of the logistics data of each library area according to the attribute information of a plurality of library areas in the logistics system;
accordingly, the control module is further configured to:
and controlling the table structure, the storage process, the view, the trigger and the table data of the logistics data of each library area by using the management software corresponding to each library area.
The embodiment of the present invention further provides an electronic device, which includes a memory, a processor, and a computer program stored in the memory and capable of running on the processor, wherein the processor implements the steps of any one of the above logistics database distributed control methods when executing the program.
Embodiments of the present invention further provide a non-transitory computer readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the steps of the logistics database distributed control method according to any one of the above.
According to the logistics database distributed control method and system provided by the embodiment of the invention, the logistics data of each library area is separated from the original database shared by a plurality of library areas according to the attribute information of each library area, a database is independently constructed for each library area according to the logistics data of each library area, and the database of each library area is controlled by using different management software, so that the logistics information of each library area is distributed and controlled, is independent from each other, does not interfere with each other, is stable in data, meets the use requirement of a logistics system, and improves the data analysis capability of a logistics server and the stability of the logistics system.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and those skilled in the art can also obtain other drawings according to the drawings without creative efforts.
Fig. 1 is a schematic flow chart of a distributed control method for a logistics database according to an embodiment of the present invention;
fig. 2 is a schematic structural diagram of a distributed control system of a logistics database according to an embodiment of the present invention;
fig. 3 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
A distributed control method for a logistics database according to an embodiment of the present invention is described below with reference to fig. 1, where the method includes: s101, separating logistics data of each library area from a database shared by the library areas according to attribute information of the library areas in the logistics system;
the logistics system can be a workshop logistics system for manufacturing cut tobacco and comprises a formula overhead warehouse area, a semi-finished product warehouse area and a finished product warehouse area. The present embodiment is not limited to such a logistics system. The attribute information of the library area includes the number and name of the library area, and the like. The logistics data of the original plurality of storage areas are stored in a data warehouse as a whole. For example, the logistics data of the semi-finished product warehouse area and the finished product warehouse area are stored together. According to the attribute information of each library area, the logistics data of each library area is separated from the original data warehouse.
S102, respectively constructing a database of each reservoir area according to the separated logistics data of each reservoir area;
after the logistics data of a plurality of warehouse areas in the logistics system are separated, a database of each warehouse area is constructed according to the separated logistics data of each warehouse area.
S103, controlling the databases of each library area by using different management software respectively; wherein each management software is respectively deployed on different servers.
Besides separating the logistics information of each library area, the management software for controlling the database of the library area is also separated. And controlling the databases of each library area by using management software respectively. The management software controls the database of the library area, including the operations of updating, adding and modifying the database.
According to the embodiment, the logistics data of each library area is separated from the original database shared by a plurality of library areas according to the attribute information of each library area, a database is independently constructed for each library area according to the logistics data of each library area, and the database of each library area is controlled by using different management software, so that the logistics information of each library area is subjected to distribution control, the distribution control is independent of each other, the mutual interference is avoided, the data is stable, the use requirements of a logistics system are met, and the data analysis capability of a logistics server and the stability of the logistics system are improved.
On the basis of the above embodiment, in this embodiment, according to the attribute information of a plurality of library areas in the logistics system, the logistics data of each library area is separated from the database shared by the plurality of library areas; the step of respectively constructing the database of each library area according to the separated logistics data of each library area comprises the following steps: for the table data of each user in the logistics system, separating the logistics data of each library area from each table data according to the attribute information of each library area; respectively constructing a table according to the logistics data of each library area separated from each table data; and constructing a database of each library area according to the newly constructed table of each library area.
Specifically, since the plurality of library areas use the same set of table data of the same user, when the logistics data are separated, the logistics data and other related information of each library area are separated from the whole set of table data according to the attribute information of each library area. For example, the original finished tobacco shred storage area and the semi-finished tobacco shred storage area use the same set of table data of the same user, and the original data warehouse is separated into two independent databases of the semi-finished tobacco shred storage area and the finished tobacco shred storage area.
On the basis of the foregoing embodiment, in this embodiment, the step of separating the logistics data of each library area from the database shared by the library areas according to the attribute information of the library areas in the logistics system further includes: separating the table structure, the storage process, the view, the trigger and the table data of the logistics data of each library area according to the attribute information of a plurality of library areas in the logistics system; correspondingly, the step of controlling the database of each library area by using different management software respectively further comprises the following steps: and controlling the table structure, the storage process, the view, the trigger and the table data of the logistics data of each library area by using the management software corresponding to each library area.
Specifically, since the original database shared by multiple library areas is an integral, this embodiment separates the logistics information of multiple library areas in the original database, and also separates the related information of the table structure, the storage process, the view, the trigger, the table data, and the like of the logistics information of each library area. And then, the management software corresponding to each library area is used for carrying out separation control on the related information of each library area.
On the basis of the foregoing embodiments, in this embodiment, the step of controlling the database of each library area by using different management software includes: when each library area is put in storage, the management software corresponding to each library area is used for modifying the database corresponding to each library area; and when each library area is exported, modifying the database corresponding to each library area by using the management software corresponding to each library area.
Specifically, when the library area is put in storage, the modification of the database in the library area includes adding a new record or updating the original logistics data in the database. When the library area is exported, the modification of the database of the library area comprises deleting a new record or updating the original logistics data in the database.
On the basis of the foregoing embodiments, in this embodiment, the step of controlling the database of each library area by using different management software includes: if the quantity of the articles to be delivered from any storage area is smaller than the reserved quantity of the articles to be delivered from the database of the storage area, calculating the difference between the reserved quantity of the articles to be delivered and the quantity of the articles to be delivered; if the reserved quantity of the articles to be delivered from the warehouse in the other warehouse areas except the warehouse area in the logistics system is not zero, distributing the articles to be delivered from the warehouse in the databases of the other warehouse areas to the database of the warehouse area according to the difference value based on the management software corresponding to the other warehouse areas, so that the reserved quantity of the articles to be delivered from the warehouse in the database of the warehouse area is larger than or equal to the reserved quantity of the articles to be delivered from the warehouse in the database of the warehouse area.
Specifically, besides separating the logistics information of each library area, the independence of each library area is realized, and the data sharing of a plurality of library areas can be realized under special conditions. For example, the finished product warehouse area and the semi-finished product warehouse area realize data sharing and mutually transmit the cut tobacco boxes under special conditions. And when the quantity of the tobacco shred boxes needing to be delivered out of the finished product warehouse area is insufficient, the tobacco shred boxes need to be transported from the semi-finished product tobacco shred warehouse to the finished product tobacco shred warehouse, and at the moment, the program of the semi-finished product tobacco shred warehouse is modified, so that the management software of the semi-finished product warehouse area distributes the tobacco shred boxes in the database of the semi-finished product warehouse area to the database of the finished product warehouse area. And when the quantity of the cut tobacco boxes needing to be delivered out of the semi-finished product warehouse area is not enough, the cut tobacco boxes need to be transported from the finished product cut tobacco warehouse to the semi-finished product cut tobacco warehouse, and at the moment, the program of the finished product cut tobacco warehouse is modified, so that the management software of the finished product warehouse area distributes the cut tobacco boxes in the database of the finished product warehouse area to the database of the semi-finished product warehouse area.
The logistics database distributed control system provided by the embodiment of the invention is described below, and the logistics database distributed control system described below and the logistics database distributed control method described above can be referred to correspondingly.
As shown in fig. 2, the logistics database distributed control system in this embodiment includes a separation module 201, a construction module 202, and a control module 203, where:
the separation module 201 is configured to separate logistics data of each library area from a database shared by multiple library areas according to attribute information of the multiple library areas in the logistics system;
the logistics system can be a workshop logistics system for manufacturing cut tobacco and comprises a formula overhead warehouse area, a semi-finished product warehouse area and a finished product warehouse area. The present embodiment is not limited to such a logistics system. The attribute information of the library area includes the number and name of the library area, and the like. The logistics data of the original plurality of storage areas are stored in a data warehouse as a whole. According to the attribute information of each library area, the logistics data of each library area is separated from the original data warehouse.
The construction module 202 is configured to respectively construct a database of each library area according to the separated logistics data of each library area;
after the logistics data of a plurality of warehouse areas in the logistics system are separated, a database of each warehouse area is constructed according to the separated logistics data of each warehouse area.
The control module 203 is used for controlling the databases of each library area by using different management software respectively; wherein each management software is respectively deployed on different servers.
Besides separating the logistics information of each library area, the management software for controlling the database of the library area is also separated. And controlling the databases of each library area by using management software respectively. The management software controls the database of the library area, including the operations of updating, adding and modifying the database.
According to the embodiment, the logistics data of each library area is separated from the original database shared by a plurality of library areas according to the attribute information of each library area, a database is independently constructed for each library area according to the logistics data of each library area, and the database of each library area is controlled by using different management software, so that the logistics information of each library area is subjected to distribution control, the distribution control is independent of each other, the mutual interference is avoided, the data is stable, the use requirements of a logistics system are met, and the data analysis capability of a logistics server and the stability of the logistics system are improved.
On the basis of the foregoing embodiment, in this embodiment, the separation module is specifically configured to: for the table data of each user in the logistics system, separating the logistics data of each library area from each table data according to the attribute information of each library area; correspondingly, the building module is specifically configured to: respectively constructing a table according to the logistics data of each library area separated from each table data; and constructing a database of each library area according to the newly constructed table of each library area.
On the basis of the foregoing embodiment, in this embodiment, the separation module is further configured to: separating the table structure, the storage process, the view, the trigger and the table data of the logistics data of each library area according to the attribute information of a plurality of library areas in the logistics system; accordingly, the control module is further configured to: and controlling the table structure, the storage process, the view, the trigger and the table data of the logistics data of each library area by using the management software corresponding to each library area.
On the basis of the foregoing embodiments, the control module in this embodiment is specifically configured to: when each library area is put in storage, the management software corresponding to each library area is used for modifying the database corresponding to each library area; and when each library area is exported, modifying the database corresponding to each library area by using the management software corresponding to each library area.
On the basis of the foregoing embodiments, the control module in this embodiment is specifically configured to: if the quantity of the articles to be delivered from any storage area is smaller than the reserved quantity of the articles to be delivered from the database of the storage area, calculating the difference between the reserved quantity of the articles to be delivered and the quantity of the articles to be delivered; if the reserved quantity of the articles to be delivered from the warehouse in the other warehouse areas except the warehouse area in the logistics system is not zero, distributing the articles to be delivered from the warehouse in the databases of the other warehouse areas to the database of the warehouse area according to the difference value based on the management software corresponding to the other warehouse areas, so that the reserved quantity of the articles to be delivered from the warehouse in the database of the warehouse area is larger than or equal to the reserved quantity of the articles to be delivered from the warehouse in the database of the warehouse area.
Fig. 3 illustrates a physical structure diagram of an electronic device, which may include, as shown in fig. 3: a processor (processor)310, a communication Interface (communication Interface)320, a memory (memory)330 and a communication bus 340, wherein the processor 310, the communication Interface 320 and the memory 330 communicate with each other via the communication bus 340. The processor 310 may invoke logic instructions in the memory 330 to perform a logistics database distributed control method comprising: separating logistics data of each library area from a database shared by the library areas according to attribute information of the library areas in the logistics system; respectively constructing a database of each reservoir area according to the separated logistics data of each reservoir area; respectively controlling the databases of each library area by using different management software; wherein each management software is respectively deployed on different servers.
In addition, the logic instructions in the memory 330 may be implemented in the form of software functional units and stored in a computer readable storage medium when the software functional units are sold or used as independent products. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
In another aspect, an embodiment of the present invention further provides a computer program product, where the computer program product includes a computer program stored on a non-transitory computer-readable storage medium, the computer program includes program instructions, and when the program instructions are executed by a computer, the computer can execute the logistics database distributed control method provided by the above-mentioned method embodiments, where the method includes: separating logistics data of each library area from a database shared by the library areas according to attribute information of the library areas in the logistics system; respectively constructing a database of each reservoir area according to the separated logistics data of each reservoir area; respectively controlling the databases of each library area by using different management software; wherein each management software is respectively deployed on different servers.
In still another aspect, an embodiment of the present invention further provides a non-transitory computer-readable storage medium, on which a computer program is stored, where the computer program is implemented by a processor to execute the logistics database distributed control method provided in the foregoing embodiments, and the method includes: separating logistics data of each library area from a database shared by the library areas according to attribute information of the library areas in the logistics system; respectively constructing a database of each reservoir area according to the separated logistics data of each reservoir area; respectively controlling the databases of each library area by using different management software; wherein each management software is respectively deployed on different servers.
The above-described system embodiments are merely illustrative, and the units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware. With this understanding in mind, the above-described technical solutions may be embodied in the form of a software product, which can be stored in a computer-readable storage medium such as ROM/RAM, magnetic disk, optical disk, etc., and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the methods described in the embodiments or some parts of the embodiments.
Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (10)
1. A distributed control method for a logistics database is characterized by comprising the following steps:
separating logistics data of each library area from a database shared by the library areas according to attribute information of the library areas in the logistics system;
respectively constructing a database of each reservoir area according to the separated logistics data of each reservoir area;
respectively controlling the databases of each library area by using different management software; wherein each management software is respectively deployed on different servers.
2. The distributed control method of logistics databases of claim 1, wherein logistics data of each library area is separated from the database shared by a plurality of library areas in the logistics system according to the attribute information of the library areas; the step of respectively constructing the database of each library area according to the separated logistics data of each library area comprises the following steps:
for the table data of each user in the logistics system, separating the logistics data of each library area from each table data according to the attribute information of each library area;
respectively constructing a table according to the logistics data of each library area separated from each table data;
and constructing a database of each library area according to the newly constructed table of each library area.
3. The distributed control method for logistics databases of claim 1, wherein the step of separating logistics data of each library area from the database shared by a plurality of library areas in the logistics system according to the attribute information of the library areas further comprises:
separating the table structure, the storage process, the view, the trigger and the table data of the logistics data of each library area according to the attribute information of a plurality of library areas in the logistics system;
correspondingly, the step of controlling the database of each library area by using different management software respectively further comprises the following steps:
and controlling the table structure, the storage process, the view, the trigger and the table data of the logistics data of each library area by using the management software corresponding to each library area.
4. The distributed control method for the logistics database according to any one of claims 1 to 3, wherein the step of controlling the database of each library section by using different management software respectively comprises:
when each library area is put in storage, the management software corresponding to each library area is used for modifying the database corresponding to each library area;
and when each library area is exported, modifying the database corresponding to each library area by using the management software corresponding to each library area.
5. The distributed control method for the logistics database according to any one of claims 1 to 3, wherein the step of controlling the database of each library section by using different management software respectively comprises:
if the quantity of the articles to be delivered from any storage area is smaller than the reserved quantity of the articles to be delivered from the database of the storage area, calculating the difference between the reserved quantity of the articles to be delivered and the quantity of the articles to be delivered;
if the reserved quantity of the articles to be delivered from the warehouse in the other warehouse areas except the warehouse area in the logistics system is not zero, distributing the articles to be delivered from the warehouse in the databases of the other warehouse areas to the database of the warehouse area according to the difference value based on the management software corresponding to the other warehouse areas, so that the reserved quantity of the articles to be delivered from the warehouse in the database of the warehouse area is larger than or equal to the reserved quantity of the articles to be delivered from the warehouse in the database of the warehouse area.
6. A distributed control system for logistics databases, comprising:
the separation module is used for separating the logistics data of each library area from a database shared by the library areas according to the attribute information of the library areas in the logistics system;
the construction module is used for respectively constructing a database of each library area according to the separated logistics data of each library area;
the control module is used for controlling the databases of each library area by using different management software respectively; wherein each management software is respectively deployed on different servers.
7. The distributed logistics database control system of claim 6, wherein the separation module is specifically configured to:
for the table data of each user in the logistics system, separating the logistics data of each library area from each table data according to the attribute information of each library area;
correspondingly, the building module is specifically configured to:
respectively constructing a table according to the logistics data of each library area separated from each table data;
and constructing a database of each library area according to the newly constructed table of each library area.
8. The logistics database distributed control system of claim 6, wherein the separation module is further configured to:
separating the table structure, the storage process, the view, the trigger and the table data of the logistics data of each library area according to the attribute information of a plurality of library areas in the logistics system;
accordingly, the control module is further configured to:
and controlling the table structure, the storage process, the view, the trigger and the table data of the logistics data of each library area by using the management software corresponding to each library area.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the steps of the logistics database distributed control method of any one of claims 1 to 5 when executing the program.
10. A non-transitory computer readable storage medium having a computer program stored thereon, wherein the computer program when executed by a processor implements the steps of the logistics database distributed control method of any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011140292.0A CN112215553B (en) | 2020-10-22 | 2020-10-22 | Distributed control method and system for logistics database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011140292.0A CN112215553B (en) | 2020-10-22 | 2020-10-22 | Distributed control method and system for logistics database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112215553A true CN112215553A (en) | 2021-01-12 |
| CN112215553B CN112215553B (en) | 2023-01-31 |
Family
ID=74054937
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011140292.0A Active CN112215553B (en) | 2020-10-22 | 2020-10-22 | Distributed control method and system for logistics database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112215553B (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102033889A (en) * | 2009-09-29 | 2011-04-27 | 熊凡凡 | Distributed database parallel processing system |
| CN105335448A (en) * | 2014-08-15 | 2016-02-17 | 中国银联股份有限公司 | Distributed environment-based data storage and processing system |
| CN105512843A (en) * | 2015-12-08 | 2016-04-20 | 上海电器科学研究院 | Asset operation and maintenance spot inspection method applicable to a number of assets and warehouse spare parts |
| CN106408228A (en) * | 2016-08-26 | 2017-02-15 | 无锡卓信信息科技股份有限公司 | Warehouse cargo searching and positioning control system based on RF technology |
| CN108469786A (en) * | 2018-01-26 | 2018-08-31 | 西安电子科技大学 | Extensive intelligent storage distribution radio frequency |
| CN110909077A (en) * | 2019-11-05 | 2020-03-24 | 四川中讯易科科技有限公司 | Distributed storage method |
| CN111767345A (en) * | 2020-06-30 | 2020-10-13 | 中国平安财产保险股份有限公司 | Modeling data synchronization method and device, computer equipment and readable storage medium |
-
2020
- 2020-10-22 CN CN202011140292.0A patent/CN112215553B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102033889A (en) * | 2009-09-29 | 2011-04-27 | 熊凡凡 | Distributed database parallel processing system |
| CN105335448A (en) * | 2014-08-15 | 2016-02-17 | 中国银联股份有限公司 | Distributed environment-based data storage and processing system |
| CN105512843A (en) * | 2015-12-08 | 2016-04-20 | 上海电器科学研究院 | Asset operation and maintenance spot inspection method applicable to a number of assets and warehouse spare parts |
| CN106408228A (en) * | 2016-08-26 | 2017-02-15 | 无锡卓信信息科技股份有限公司 | Warehouse cargo searching and positioning control system based on RF technology |
| CN108469786A (en) * | 2018-01-26 | 2018-08-31 | 西安电子科技大学 | Extensive intelligent storage distribution radio frequency |
| CN110909077A (en) * | 2019-11-05 | 2020-03-24 | 四川中讯易科科技有限公司 | Distributed storage method |
| CN111767345A (en) * | 2020-06-30 | 2020-10-13 | 中国平安财产保险股份有限公司 | Modeling data synchronization method and device, computer equipment and readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112215553B (en) | 2023-01-31 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9594801B2 (en) | Systems and methods for allocating work for various types of services among nodes in a distributed computing system | |
| CN105956481B (en) | A kind of data processing method and its device | |
| CN103473636A (en) | System data components for collecting, analyzing and distributing internet business information | |
| CN110661660B (en) | Alarm information root analysis method and device | |
| CN112416456B (en) | Configuration file processing method, device, equipment, storage medium and system | |
| CN109413125A (en) | The method and apparatus of dynamic regulation distributed system resource | |
| CN111897643B (en) | Thread pool configuration system, method, device and storage medium | |
| CN113448685A (en) | Pod scheduling method and system based on Kubernetes | |
| CN114116774B (en) | Log data query method and device | |
| CN101046822B (en) | Centralized management of data nodes | |
| CN112215553B (en) | Distributed control method and system for logistics database | |
| CN110555600B (en) | Method, device, equipment and storage medium for preventing forbidden components in modular BOM from being misused | |
| US11263264B2 (en) | Management of graphs using secondary index vertices | |
| CN104317660A (en) | Bank parameter managing system | |
| CN110011971B (en) | Manual configuration method of network security policy | |
| CN109388668B (en) | Method for exchanging data between engineering tools of engineering system and engineering system | |
| CN110942372B (en) | Butt joint method and gateway of business end and ERP system | |
| CN109033134A (en) | A kind of message treatment method, device, storage medium and computer equipment | |
| CN109391489B (en) | Network element configuration data storage processing method and device | |
| CN112163024B (en) | Configuration information export and import method based on hierarchical association structure | |
| CN113162782B (en) | Data center network configuration method and device | |
| CN101552694B (en) | Network topology loading method, device and network management system | |
| CN109857749A (en) | Method of data synchronization and device based on configuration data change record | |
| US8775505B2 (en) | Optimized event routing in distributed data management | |
| CN113626406A (en) | Information acquisition method and device based on building site, building and component relation model |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |