CN111966679A - Storage transportation database cache management method and device - Google Patents
Storage transportation database cache management method and device Download PDFInfo
- Publication number
- CN111966679A CN111966679A CN202010680932.0A CN202010680932A CN111966679A CN 111966679 A CN111966679 A CN 111966679A CN 202010680932 A CN202010680932 A CN 202010680932A CN 111966679 A CN111966679 A CN 111966679A
- Authority
- CN
- China
- Prior art keywords
- data
- transportation
- shelf
- warehouse
- coding
- 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
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24552—Database cache management
-
- 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
-
- 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/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Economics (AREA)
- Tourism & Hospitality (AREA)
- Finance (AREA)
- Strategic Management (AREA)
- Operations Research (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Quality & Reliability (AREA)
- Accounting & Taxation (AREA)
- Entrepreneurship & Innovation (AREA)
- Development Economics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application provides a storage transportation database cache management method and a storage transportation database cache management device, wherein the method comprises the following steps: classifying and coding shelf data to obtain a corresponding first coding region, classifying and coding warehouse data to obtain a corresponding second coding region, classifying and coding product data to obtain a corresponding third coding region, classifying and coding transportation data to obtain a corresponding fourth coding region; establishing a plurality of cache regions for the data table partitions in the warehousing and transportation database according to the first coding region, the second coding region, the third coding region and the fourth coding region, and caching a code corresponding to shelf data, a code corresponding to warehouse data, a code corresponding to product data and a code corresponding to transportation data; when a data query request of a client is received, querying is carried out in one of the cache regions according to the data type in the data query request.
Description
Technical Field
The application relates to the technical field of databases, in particular to a storage, transportation and database cache management method and device.
Background
Warehousing plays a crucial role in the whole supply chain of an enterprise, and if correct feeding and inventory control and delivery cannot be guaranteed, the management cost is increased, the service quality is difficult to guarantee, and the competitiveness of the enterprise is affected. Traditional simple and static warehousing management cannot guarantee efficient utilization of various resources of enterprises. The warehouse operation and the inventory control operation are complicated and diversified, and the time and the labor are wasted, the mistakes are easy to make, and huge losses are brought to enterprises only by manual memory and manual input.
At present, the information management by using a warehousing and transportation database is more and more common. The warehousing and transportation data included in the warehousing and transportation database are various in types, and various data query can be performed on the access of the warehousing and transportation database. If the warehousing and transportation database is frequently inquired, the connection of the warehousing and transportation database is occupied, the access speed is slow, the warehousing and transportation data in the warehousing and transportation database are directly inquired, and the inquiry efficiency is low.
Disclosure of Invention
The application aims to provide a storage, transportation and transportation database cache management method and device so as to effectively overcome the technical defects of low speed and low query efficiency of accessing the storage, transportation and transportation database.
The invention is realized by the following technical scheme:
in a first aspect, an embodiment of the present application provides a storage, transportation, and database cache management method, where the method is applied to storage and transportation of products in a warehouse, and the method includes: classifying and coding shelf data to obtain a corresponding first coding region, classifying and coding warehouse data to obtain a corresponding second coding region, classifying and coding product data to obtain a corresponding third coding region, classifying and coding transportation data to obtain a corresponding fourth coding region; establishing a plurality of cache regions for the data table partitions in the warehousing and transportation database according to the first coding region, the second coding region, the third coding region and the fourth coding region, and caching a code corresponding to shelf data, a code corresponding to warehouse data, a code corresponding to product data and a code corresponding to transportation data; when a data query request of a client is received, querying is carried out in one cache region of the plurality of cache regions according to the data type in the data query request.
With reference to the first aspect, in a first possible implementation manner, the classifying and coding shelf data to obtain a corresponding first coding region, classifying and coding warehouse data to obtain a corresponding second coding region, classifying and coding product data to obtain a corresponding third coding region, and classifying and coding transportation data to obtain a corresponding fourth coding region includes: classifying and coding the shelf according to first volume data which is used for representing storage space of the shelf in the shelf data, and storing a code corresponding to the shelf data in a first coding region; classifying and coding the warehouse according to the corresponding relation between the warehouse data and the shelf data, and storing codes corresponding to the warehouse data in a second coding region; classifying and coding the products according to the product classification codes in the product data, and storing codes corresponding to the product data in a third coding region; and classifying and coding the transport vehicles for transportation according to second volume data used for representing the transportation space in the transportation data, and storing codes corresponding to the transportation data in a fourth coding region.
With reference to the first aspect, in a second possible implementation manner, when a data query request of a client is received, querying in one cache region of a plurality of cache regions according to a data type in the data query request includes: when a data query request of a client is received, judging the data type of the data query request, generating a corresponding code according to the data type of the data query request, determining a cache region matched with the code generated by the data type of the data query request from a plurality of cache regions, and querying data in the cache region.
With reference to the second possible implementation manner of the first aspect, in a third possible implementation manner, the method further includes: establishing a first corresponding relation between shelf data and warehouse data, establishing a second corresponding relation between the shelf data and product data, establishing a third corresponding relation between the shelf data and transportation data, and uploading the shelf data, the warehouse data, the product data and the transportation data to a warehousing and transportation database; and when the data query in the cache region fails, sending the data query request to the warehousing and transportation database, acquiring a new query result according to the first corresponding relation, the second corresponding relation and the third corresponding relation, and storing the new query result in the cache region.
With reference to the third possible implementation manner of the first aspect, in a fourth possible implementation manner, establishing a first corresponding relationship between shelf data and warehouse data, establishing a second corresponding relationship between shelf data and the item data, establishing a third corresponding relationship between shelf data and transportation data, and uploading the shelf data, the warehouse data, the product data, and the transportation data to a warehousing and transportation database includes: establishing a first corresponding relation between the shelf data and the warehouse data according to warehouse size data in the warehouse data and shelf type data in the shelf data; establishing a second corresponding relation between the shelf data and the product data according to the first volume data in the shelf data and the product classification codes in the product data; according to first volume data in shelf data and second volume data in transportation data, establishing a third corresponding relation between the shelf data and the transportation data, uploading shelf data, warehouse data, product data, the transportation data, codes corresponding to the shelf data, codes corresponding to the warehouse data, codes corresponding to the product data and codes corresponding to the transportation data to a warehousing and transportation database for classified storage, wherein warehouse size data is used for representing the length, width, height and volume of a warehouse, and the warehousing and transportation database is used for representing a set of the first corresponding relation, the second corresponding relation and the third corresponding relation.
In a second aspect, an embodiment of the present application provides a storage, transportation, and database cache management apparatus, where the apparatus includes: the encoding module is used for classifying and encoding the shelf data to obtain a corresponding first encoding region, classifying and encoding the warehouse data to obtain a corresponding second encoding region, classifying and encoding the product data to obtain a corresponding third encoding region, and classifying and encoding the transportation data to obtain a corresponding fourth encoding region; the cache module is used for establishing a plurality of cache regions for the data table partitions in the warehousing and transportation database according to the first coding region, the second coding region, the third coding region and the fourth coding region, and caching a code corresponding to the shelf data, a code corresponding to the warehouse data, a code corresponding to the product data and a code corresponding to the transportation data; and the processing module is used for inquiring in one cache region of the plurality of cache regions according to the data type in the data inquiry request when receiving the data inquiry request of the client.
With reference to the second aspect, in a first possible implementation manner, the encoding module is further configured to: classifying and coding the shelf according to first volume data which is used for representing storage space of the shelf in the shelf data, and storing a code corresponding to the shelf data in a first coding region; classifying and coding the warehouse according to the corresponding relation between the warehouse data and the shelf data, and storing codes corresponding to the warehouse data in a second coding region; classifying and coding the products according to the product classification codes in the product data, and storing codes corresponding to the product data in a third coding region; and classifying and coding the transport vehicles for transportation according to second volume data used for representing the transportation space in the transportation data, and storing codes corresponding to the transportation data in a fourth coding region.
With reference to the second aspect, in a second possible implementation manner, the processing module is further configured to: when a data query request of a client is received, judging the data type of the data query request, generating a corresponding code according to the data type of the data query request, determining a cache region matched with the code generated by the data type of the data query request from a plurality of cache regions, and querying data in the cache region.
With reference to the second possible implementation manner of the second aspect, in a third possible implementation manner, the processing module is further configured to: establishing a first corresponding relation between shelf data and warehouse data, establishing a second corresponding relation between the shelf data and product data, establishing a third corresponding relation between the shelf data and transportation data, and uploading the shelf data, the warehouse data, the product data and the transportation data to a warehousing and transportation database; and when the data query in the cache region fails, sending the data query request to the warehousing and transportation database, acquiring a new query result according to the first corresponding relation, the second corresponding relation and the third corresponding relation, and storing the new query result in the cache region.
With reference to the third possible implementation manner of the second aspect, in a fourth possible implementation manner, the processing module is further configured to: establishing a first corresponding relation between the shelf data and the warehouse data according to warehouse size data in the warehouse data and shelf type data in the shelf data; establishing a second corresponding relation between the shelf data and the product data according to the first volume data in the shelf data and the product classification codes in the product data; according to first volume data in shelf data and second volume data in transportation data, establishing a third corresponding relation between the shelf data and the transportation data, uploading shelf data, warehouse data, product data, the transportation data, codes corresponding to the shelf data, codes corresponding to the warehouse data, codes corresponding to the product data and codes corresponding to the transportation data to a warehousing and transportation database for classified storage, wherein warehouse size data is used for representing the length, width, height and volume of a warehouse, and the warehousing and transportation database is used for representing a set of the first corresponding relation, the second corresponding relation and the third corresponding relation.
The invention has the beneficial effects that: the method comprises the steps of classifying and coding the warehousing and transportation data in the warehousing and transportation database, then caching in regions according to the classification coding result, when receiving a data query request of a client, on one hand, querying in a cache region firstly, querying in the warehousing and transportation database after query failure, and using a caching technology, so that the direct interaction times with the database during query can be reduced, the pressure of the warehousing and transportation database is reduced, and the retrieval efficiency is improved; on the other hand, the warehousing and transportation data in the warehousing and transportation database are classified and coded, and the regional cache is carried out according to the classified and coded results, so that a cache region can be determined in a plurality of cache regions according to the data type in the data query request, and the data matched with the data query request is queried in the cache region, so that the query result can be obtained more quickly, and the query efficiency 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 of the present application 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 that those skilled in the art can also obtain other related drawings based on the drawings without inventive efforts.
Fig. 1 is a schematic flowchart of a method for managing a storage transportation database cache according to an embodiment of the present disclosure;
fig. 2 is a schematic structural diagram of a warehousing and transportation database cache management device according to an embodiment of the present disclosure.
Detailed Description
The technical solutions in the embodiments of the present application will be described below with reference to the drawings in the embodiments of the present application.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, it need not be further defined and explained in subsequent figures. Meanwhile, in the description of the present application, the terms "first", "second", and the like are used only for distinguishing the description, and are not to be construed as indicating or implying relative importance.
Referring to fig. 1, an embodiment of the present application provides a method for managing a storage, transportation, and storage database cache, where the method is applied to storage and transportation of products in a warehouse, and the method includes: step S11, step S12, and step S13.
Step S11: classifying and coding shelf data to obtain a corresponding first coding region, classifying and coding warehouse data to obtain a corresponding second coding region, classifying and coding product data to obtain a corresponding third coding region, classifying and coding transportation data to obtain a corresponding fourth coding region;
step S12: establishing a plurality of cache regions for the data table partitions in the warehousing and transportation database according to the first coding region, the second coding region, the third coding region and the fourth coding region, and caching a code corresponding to shelf data, a code corresponding to warehouse data, a code corresponding to product data and a code corresponding to transportation data;
step S13: when a data query request of a client is received, querying is carried out in one cache region of the plurality of cache regions according to the data type in the data query request.
Step S11: the shelf data are classified and coded to obtain a corresponding first coding region, the warehouse data are classified and coded to obtain a corresponding second coding region, the product data are classified and coded to obtain a corresponding third coding region, and the transportation data are classified and coded to obtain a corresponding fourth coding region.
The warehousing transportation data in the warehousing transportation database are various in types, namely, the warehousing transportation database contains various types of data, and the warehousing transportation database comprises shelf data, warehouse data, product data and transportation data. And respectively coding according to the types of the data in the warehousing and transportation database. In detail, the steps of classifying and coding shelf data to obtain a corresponding first coding region, classifying and coding warehouse data to obtain a corresponding second coding region, classifying and coding product data to obtain a corresponding third coding region, and classifying and coding transportation data to obtain a corresponding fourth coding region include: classifying and coding the shelf according to first volume data which is used for representing storage space of the shelf in the shelf data, and storing a code corresponding to the shelf data in a first coding region; classifying and coding the warehouse according to the corresponding relation between the warehouse data and the shelf data, and storing codes corresponding to the warehouse data in a second coding region; classifying and coding the products according to the product classification codes in the product data, and storing codes corresponding to the product data in a third coding region; and classifying and coding the transport vehicles for transportation according to second volume data used for representing the transportation space in the transportation data, and storing codes corresponding to the transportation data in a fourth coding region.
By classified coding, data in multiple formats can be coded into data in the same format, so that the speed is higher during query. Through classification, various data can have structural hierarchy, and quick query is facilitated.
Step S12: and establishing a plurality of cache regions for the data table partitions in the warehousing and transportation database according to the first coding region, the second coding region, the third coding region and the fourth coding region, and caching the codes corresponding to the shelf data, the codes corresponding to the warehouse data, the codes corresponding to the product data and the codes corresponding to the transportation data.
The codes are stored in the cache region, so that the cache region can be inquired preferentially when data request inquiry is carried out, and the inquiry speed of the cache region is higher than that of the warehouse transportation database. The cache types are diverse and include CDN caches, Redis caches, and Memcache caches. In the embodiment of the present application, a Redis cache is employed. Redis caching has the advantages of fast read response requests, support of rich data types and atomicity of operations.
The method includes the steps of caching a plurality of coding areas in a plurality of cache areas, specifically, dividing the cache area into a plurality of cache areas, and storing codes corresponding to data in the cache areas according to data types. One cache region can store codes corresponding to one data type, and one cache region can store codes corresponding to multiple data types. Optionally, in this embodiment of the present application, the storage manner is that one cache area stores one code corresponding to one data type. The storage mode can facilitate query, when the data query request is carried out, the data type in the data query request can be judged according to the corresponding relation between the cache region and the codes corresponding to different data types, and then the data query request is carried out quickly according to the judgment result.
Step S13: when a data query request of a client is received, querying is carried out in one cache region of a plurality of cache regions according to the data type in the data query request
In detail, when a data query request of a client is received, the data type of the data query request is judged, a corresponding code is generated according to the data type of the data query request, a cache region matched with the code generated corresponding to the data type of the data query request is determined from a plurality of cache regions, and data query is carried out in the cache region.
After step S13, the method for managing the buffer of the warehouse transportation database further includes: establishing a first corresponding relation between shelf data and warehouse data, establishing a second corresponding relation between the shelf data and product data, establishing a third corresponding relation between the shelf data and transportation data, and uploading the shelf data, the warehouse data, the product data and the transportation data to a warehousing and transportation database; and when the data query in the cache region fails, sending the data query request to the warehousing and transportation database, acquiring a new query result according to the first corresponding relation, the second corresponding relation and the third corresponding relation, and storing the new query result in the cache region.
Establishing a first corresponding relation between the shelf data and the warehouse data according to warehouse size data in the warehouse data and shelf type data in the shelf data; establishing a second corresponding relation between the shelf data and the product data according to the first volume data in the shelf data and the product classification codes in the product data; according to first volume data in shelf data and second volume data in transportation data, establishing a third corresponding relation between the shelf data and the transportation data, uploading shelf data, warehouse data, product data, the transportation data, codes corresponding to the shelf data, codes corresponding to the warehouse data, codes corresponding to the product data and codes corresponding to the transportation data to a warehousing and transportation database for classified storage, wherein warehouse size data is used for representing the length, width, height and volume of a warehouse, and the warehousing and transportation database is used for representing a set of the first corresponding relation, the second corresponding relation and the third corresponding relation.
The shelf data are used for representing information related to the shelf, and comprise the type of the shelf, the volume size of the shelf and the number of the shelf, the volume size of the shelf can be used for representing the size of a storage space of the shelf, the volume size of the shelf can be divided in a range, the shelf is numbered by different identification symbols according to different volume size ranges, and therefore the volume size of the shelf can be judged according to the identification symbols of the shelf. The size requirements of the shelves with different volume sizes on the warehouse are different, so that the warehouse data can be determined according to the volume sizes of the shelves in the shelf data. The size range of the products stored on the goods shelf can be judged in advance according to the size, so that the size of the products can be judged in advance according to the product classification codes in the product data, and the goods shelf is matched with the products according to the storage space of the goods shelf judged in advance. In the transportation process, in order to maximize the transportation efficiency, the storage space of the transportation vehicles needs to be reasonably configured, and what type of transportation vehicle is most suitable to be used can be predicted according to the volume size in the shelf data, wherein the transportation spaces of different types of transportation vehicles are different. Therefore, product data, warehouse data, and transportation data related to the shelf data can be predicted from the shelf data. Therefore, when the query in the cache area fails, the data query request is sent to the warehousing and transportation database, when the query is carried out in the warehousing and transportation database, the data related to the shelf data can be searched according to the shelf data, and the obtained new query result is stored in the cache area, so that the query efficiency is improved.
It should be noted that if the result of the query in the warehousing and transportation database is null, that is, null, the new query result, that is, null, is also stored in the cache area, and the new query result is returned to the client.
Referring to fig. 2, an embodiment of the present application provides a warehousing and transportation database cache management device 100, where the warehousing and transportation database cache management device 100 includes:
the encoding module 110 is configured to encode the shelf data in a classified manner to obtain a corresponding first encoding region, encode the warehouse data in a classified manner to obtain a corresponding second encoding region, encode the product data in a classified manner to obtain a corresponding third encoding region, and encode the transportation data in a classified manner to obtain a corresponding fourth encoding region.
The cache module 120 is configured to establish a plurality of cache regions for the data table partitions in the warehousing and transportation database according to the first coding region, the second coding region, the third coding region and the fourth coding region, and cache a code corresponding to the shelf data, a code corresponding to the warehouse data, a code corresponding to the product data, and a code corresponding to the transportation data.
The processing module 130 is configured to, when a data query request of a client is received, query in one of the cache regions according to a data type in the data query request.
The encoding module 110 is further configured to: classifying and coding the shelf according to first volume data which is used for representing storage space of the shelf in the shelf data, and storing a code corresponding to the shelf data in a first coding region; classifying and coding the warehouse according to the corresponding relation between the warehouse data and the shelf data, and storing codes corresponding to the warehouse data in a second coding region; classifying and coding the products according to the product classification codes in the product data, and storing codes corresponding to the product data in a third coding region; and classifying and coding the transport vehicles for transportation according to second volume data used for representing the transportation space in the transportation data, and storing codes corresponding to the transportation data in a fourth coding region.
The processing module 130 is further configured to: when a data query request of a client is received, judging the data type of the data query request, generating a corresponding code according to the data type of the data query request, determining a cache region matched with the code generated by the data type of the data query request from a plurality of cache regions, and querying data in the cache region.
The processing module 130 is further configured to: establishing a first corresponding relation between shelf data and warehouse data, establishing a second corresponding relation between the shelf data and product data, establishing a third corresponding relation between the shelf data and transportation data, and uploading the shelf data, the warehouse data, the product data and the transportation data to a warehousing and transportation database; and when the data query in the cache region fails, sending the data query request to the warehousing and transportation database, acquiring a new query result according to the first corresponding relation, the second corresponding relation and the third corresponding relation, and storing the new query result in the cache region.
The processing module 130 is further configured to: establishing a first corresponding relation between the shelf data and the warehouse data according to warehouse size data in the warehouse data and shelf type data in the shelf data; establishing a second corresponding relation between the shelf data and the product data according to the first volume data in the shelf data and the product classification codes in the product data; according to first volume data in shelf data and second volume data in transportation data, establishing a third corresponding relation between the shelf data and the transportation data, uploading shelf data, warehouse data, product data, the transportation data, codes corresponding to the shelf data, codes corresponding to the warehouse data, codes corresponding to the product data and codes corresponding to the transportation data to a warehousing and transportation database for classified storage, wherein warehouse size data is used for representing the length, width, height and volume of a warehouse, and the warehousing and transportation database is used for representing a set of the first corresponding relation, the second corresponding relation and the third corresponding relation.
To sum up, the embodiment of the present application provides a method for managing a storage, transportation and storage database cache, where the method includes: classifying and coding shelf data to obtain a corresponding first coding region, classifying and coding warehouse data to obtain a corresponding second coding region, classifying and coding product data to obtain a corresponding third coding region, classifying and coding transportation data to obtain a corresponding fourth coding region; establishing a plurality of cache regions for the data table partitions in the warehousing and transportation database according to the first coding region, the second coding region, the third coding region and the fourth coding region, and caching a code corresponding to shelf data, a code corresponding to warehouse data, a code corresponding to product data and a code corresponding to transportation data; when a data query request of a client is received, querying is carried out in one cache region of the plurality of cache regions according to the data type in the data query request.
The above description is only for the specific embodiments of the present application, but the scope of the present application is not limited thereto, and any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present application, and shall be covered by the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.
Claims (10)
1. A warehousing and transportation database cache management method is applied to warehousing and transportation of products in a warehouse, and is characterized by comprising the following steps:
classifying and coding shelf data to obtain a corresponding first coding region, classifying and coding warehouse data to obtain a corresponding second coding region, classifying and coding product data to obtain a corresponding third coding region, classifying and coding transportation data to obtain a corresponding fourth coding region;
establishing a plurality of cache regions for data table partitions in the warehousing and transportation database according to the first coding region, the second coding region, the third coding region and the fourth coding region, and caching a code corresponding to the shelf data, a code corresponding to the warehouse data, a code corresponding to the product data and a code corresponding to the transportation data;
when a data query request of a client is received, querying is carried out in one of the cache regions according to the data type in the data query request.
2. The warehouse transportation database cache management method according to claim 1, wherein the step of classifying shelf data to obtain a corresponding first coding region, classifying warehouse data to obtain a corresponding second coding region, classifying product data to obtain a corresponding third coding region, and classifying transportation data to obtain a corresponding fourth coding region comprises the steps of:
according to first volume data which is used for representing storage space of the shelf and is in the shelf data, classifying and coding the shelf, and storing codes corresponding to the shelf data in the first coding region; classifying and coding the warehouse according to the corresponding relation between the warehouse data and the shelf data, and storing the codes corresponding to the warehouse data in the second coding region; classifying and coding the products according to the product classification codes in the product data, and storing codes corresponding to the product data in the third coding region; and according to second volume data used for representing a transportation space in the transportation data, classifying and coding the transportation vehicles used for transportation, and storing codes corresponding to the transportation data in the fourth coding region.
3. The warehousing and transportation database cache management method according to claim 1, wherein when receiving a data query request from a client, querying in one of the cache regions according to a data type in the data query request comprises:
when a data query request of a client is received, judging the data type of the data query request, generating a corresponding code according to the data type of the data query request, determining a cache region matched with the code generated by the data type of the data query request from a plurality of cache regions, and querying data in the cache region.
4. The warehouse shipping database cache management method of claim 3, wherein the method further comprises:
establishing a first corresponding relation between the shelf data and the warehouse data, establishing a second corresponding relation between the shelf data and the product data, establishing a third corresponding relation between the shelf data and the transportation data, and uploading the shelf data, the warehouse data, the product data and the transportation data to a warehousing and transportation database;
and when the data query in the cache region fails, sending the data query request to the warehousing and transportation database, acquiring a new query result according to the first corresponding relation, the second corresponding relation and the third corresponding relation, and storing the new query result in the cache region.
5. The warehousing and transportation database cache management method according to claim 4, wherein the establishing a first correspondence between the shelf data and the warehouse data, a second correspondence between the shelf data and the product data, a third correspondence between the shelf data and the transportation data, and the uploading the shelf data, the warehouse data, the product data, and the transportation data to a warehousing and transportation database comprises:
establishing the first corresponding relation between the shelf data and the warehouse data according to warehouse size data in the warehouse data and shelf type data in the shelf data; establishing the second correspondence between the shelf data and the product data according to the first volume data in the shelf data and the product classification code in the product data; establishing a third corresponding relation between the shelf data and the transportation data according to the first volume data in the shelf data and the second volume data in the transportation data, uploading the shelf data, the warehouse data, the product data, the transportation data, codes corresponding to the shelf data, codes corresponding to the warehouse data, codes corresponding to the product data and codes corresponding to the transportation data to the warehousing and transportation database for classified storage, wherein the warehouse size data is used for representing the length, the width, the height and the volume of the warehouse, and the warehousing and transportation database is used for representing a set of the first corresponding relation, the second corresponding relation and the third corresponding relation.
6. A warehousing and transportation database cache management apparatus, the apparatus comprising:
the encoding module is used for classifying and encoding the shelf data to obtain a corresponding first encoding region, classifying and encoding the warehouse data to obtain a corresponding second encoding region, classifying and encoding the product data to obtain a corresponding third encoding region, and classifying and encoding the transportation data to obtain a corresponding fourth encoding region;
the cache module is used for establishing a plurality of cache regions for the data table partitions in the warehousing and transportation database according to the first coding region, the second coding region, the third coding region and the fourth coding region;
and the processing module is used for inquiring in one of the cache regions according to the data type in the data inquiry request when receiving the data inquiry request of the client.
7. The warehousing and transportation database buffer management device of claim 6, wherein the encoding module is further configured to: according to first volume data which is used for representing storage space of the shelf and is in the shelf data, classifying and coding the shelf, and storing codes corresponding to the shelf data in the first coding region; classifying and coding the warehouse according to the corresponding relation between the warehouse data and the shelf data, and storing the codes corresponding to the warehouse data in the second coding region; classifying and coding the products according to the product classification codes in the product data, and storing codes corresponding to the product data in the third coding region; and according to second volume data used for representing a transportation space in the transportation data, classifying and coding the transportation vehicles used for transportation, and storing codes corresponding to the transportation data in the fourth coding region.
8. The warehousing and transportation database cache management device of claim 6, wherein the processing module is further configured to: when a data query request of a client is received, judging the data type of the data query request, generating a corresponding code according to the data type of the data query request, determining a cache region matched with the code generated by the data type of the data query request from a plurality of cache regions, and querying data in the cache region.
9. The warehousing transportation database cache management device of claim 8, wherein the processing module is further configured to: establishing a first corresponding relation between the shelf data and the warehouse data, establishing a second corresponding relation between the shelf data and the product data, establishing a third corresponding relation between the shelf data and the transportation data, and uploading the shelf data, the warehouse data, the product data and the transportation data to a warehousing and transportation database;
and when the data query in the cache region fails, sending the data query request to the warehousing and transportation database, acquiring a new query result according to the first corresponding relation, the second corresponding relation and the third corresponding relation, and storing the new query result in the cache region.
10. The warehousing transportation database cache management device of claim 9, wherein the processing module is further configured to: establishing the first corresponding relation between the shelf data and the warehouse data according to warehouse size data in the warehouse data and shelf type data in the shelf data; establishing the second correspondence between the shelf data and the product data according to the first volume data in the shelf data and the product classification code in the product data; establishing a third corresponding relation between the shelf data and the transportation data according to the first volume data in the shelf data and the second volume data in the transportation data, uploading the shelf data, the warehouse data, the product data, the transportation data, codes corresponding to the shelf data, codes corresponding to the warehouse data, codes corresponding to the product data and codes corresponding to the transportation data to the warehousing and transportation database for classified storage, wherein the warehouse size data is used for representing the length, the width, the height and the volume of the warehouse, and the warehousing and transportation database is used for representing a set of the first corresponding relation, the second corresponding relation and the third corresponding relation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010680932.0A CN111966679B (en) | 2020-07-15 | 2020-07-15 | Storage transportation database cache management method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010680932.0A CN111966679B (en) | 2020-07-15 | 2020-07-15 | Storage transportation database cache management method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111966679A true CN111966679A (en) | 2020-11-20 |
| CN111966679B CN111966679B (en) | 2022-09-30 |
Family
ID=73360702
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010680932.0A Active CN111966679B (en) | 2020-07-15 | 2020-07-15 | Storage transportation database cache management method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111966679B (en) |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101535954A (en) * | 2006-09-29 | 2009-09-16 | 英国电讯有限公司 | Information processing system and related method |
| CN101792050A (en) * | 2010-01-28 | 2010-08-04 | 肖友泉 | Dynamic warehouse management method and system |
| US20120041970A1 (en) * | 2010-08-12 | 2012-02-16 | Cdnetworks Co., Ltd. | Distributed data cache for on-demand application acceleration |
| CN104978639A (en) * | 2014-04-09 | 2015-10-14 | 阿里巴巴集团控股有限公司 | Method and device for showing inventory |
| CN105096083A (en) * | 2015-07-30 | 2015-11-25 | 中国石油化工股份有限公司 | Information system for warehouse |
| US20180046972A1 (en) * | 2016-08-10 | 2018-02-15 | Label Insight | Information management system for product ingredients |
| CN109118137A (en) * | 2018-08-01 | 2019-01-01 | 北京极智嘉科技有限公司 | A kind of order processing method, apparatus, server and storage medium |
| CN109299140A (en) * | 2018-10-18 | 2019-02-01 | 航天科工智能机器人有限责任公司 | The storage processing system and method for automatic labeling machine working traffic |
| CN110968603A (en) * | 2019-11-29 | 2020-04-07 | 中国银行股份有限公司 | Data access method and device |
| CN111125557A (en) * | 2019-12-26 | 2020-05-08 | 北京每日优鲜电子商务有限公司 | Resource screening method and device, computer equipment and storage medium |
| CN111382142A (en) * | 2020-03-04 | 2020-07-07 | 海南金盘智能科技股份有限公司 | Database operation method, server and computer storage medium |
-
2020
- 2020-07-15 CN CN202010680932.0A patent/CN111966679B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101535954A (en) * | 2006-09-29 | 2009-09-16 | 英国电讯有限公司 | Information processing system and related method |
| CN101792050A (en) * | 2010-01-28 | 2010-08-04 | 肖友泉 | Dynamic warehouse management method and system |
| US20120041970A1 (en) * | 2010-08-12 | 2012-02-16 | Cdnetworks Co., Ltd. | Distributed data cache for on-demand application acceleration |
| CN104978639A (en) * | 2014-04-09 | 2015-10-14 | 阿里巴巴集团控股有限公司 | Method and device for showing inventory |
| CN105096083A (en) * | 2015-07-30 | 2015-11-25 | 中国石油化工股份有限公司 | Information system for warehouse |
| US20180046972A1 (en) * | 2016-08-10 | 2018-02-15 | Label Insight | Information management system for product ingredients |
| CN109118137A (en) * | 2018-08-01 | 2019-01-01 | 北京极智嘉科技有限公司 | A kind of order processing method, apparatus, server and storage medium |
| CN109299140A (en) * | 2018-10-18 | 2019-02-01 | 航天科工智能机器人有限责任公司 | The storage processing system and method for automatic labeling machine working traffic |
| CN110968603A (en) * | 2019-11-29 | 2020-04-07 | 中国银行股份有限公司 | Data access method and device |
| CN111125557A (en) * | 2019-12-26 | 2020-05-08 | 北京每日优鲜电子商务有限公司 | Resource screening method and device, computer equipment and storage medium |
| CN111382142A (en) * | 2020-03-04 | 2020-07-07 | 海南金盘智能科技股份有限公司 | Database operation method, server and computer storage medium |
Non-Patent Citations (3)
| Title |
|---|
| MEHMETALTINEL等: "Cache Tables: Paving the Way for an Adaptive Database Cache", 《VLDB "03: PROCEEDINGS OF THE 29TH INTERNATIONAL CONFERENCE ON VERY LARGE DATA BASES》 * |
| 张杰: "基于物联网的智能化仓库信息管理系统的研究", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
| 李齐鸣: "SY公司仓储管理系统的设计与实现", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111966679B (en) | 2022-09-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107103445B (en) | Information processing method and device | |
| US9965500B2 (en) | Mixed join of row and column database tables in native orientation | |
| CN103647813B (en) | The method and apparatus of Internet of Things unifying identifier code parsing | |
| US20160378813A1 (en) | Hybrid Database Table Stored as Both Row and Column Store | |
| US20200043080A1 (en) | Order processing method and device, server, and storage medium | |
| CN102609488B (en) | Client, data query method of client, server and data query system | |
| TW201530328A (en) | Method and device for constructing NoSQL database index for semi-structured data | |
| RU2005129003A (en) | LONG-TERM STORAGE OF TYPES AND INSTANCES OF .NET DATA | |
| CN102739622A (en) | Expandable data storage system | |
| US20070094101A1 (en) | System and method for efficient storage destination determination in a storage facility | |
| WO2016138879A1 (en) | Method and system of sharing recyclable logistics apparatus | |
| CN112581061A (en) | Three-dimensional warehouse management method and device based on artificial intelligence | |
| CN107644017A (en) | The querying method and device of journal file | |
| CN111966679B (en) | Storage transportation database cache management method and device | |
| CN113157692B (en) | Relational memory database system | |
| US8566342B2 (en) | In-memory data optimization system | |
| CN110543627B (en) | Report configuration information storage method and system | |
| CN112837008A (en) | Bar code reading method, device, equipment and storage medium | |
| CN105760911A (en) | Method and device for applying associated identification codes | |
| CN101452486A (en) | System data management method for [inscriptions on bones or tortoise shells and apparatus thereof | |
| CN102761617A (en) | Workflow queue server and workflow scheduling system and method | |
| CN115600955A (en) | Wisdom storage management system | |
| CN110910058A (en) | Method and device for managing materials | |
| JP2006343988A (en) | Commodity information retrieval system | |
| CN113297207B (en) | Data processing method, device and equipment |
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 |