CN113780950A - Data processing method, device, server and readable storage medium - Google Patents

Data processing method, device, server and readable storage medium Download PDF

Info

Publication number
CN113780950A
CN113780950A CN202111076820.5A CN202111076820A CN113780950A CN 113780950 A CN113780950 A CN 113780950A CN 202111076820 A CN202111076820 A CN 202111076820A CN 113780950 A CN113780950 A CN 113780950A
Authority
CN
China
Prior art keywords
information
data
identification code
character string
data elements
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202111076820.5A
Other languages
Chinese (zh)
Inventor
吕祥
孟凡庆
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Jingdong Zhenshi Information Technology Co Ltd
Original Assignee
Beijing Jingdong Zhenshi Information Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing Jingdong Zhenshi Information Technology Co Ltd filed Critical Beijing Jingdong Zhenshi Information Technology Co Ltd
Priority to CN202111076820.5A priority Critical patent/CN113780950A/en
Publication of CN113780950A publication Critical patent/CN113780950A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • G06Q10/0875Itemisation or classification of parts, supplies or services, e.g. bill of materials
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/256Integrating or interfacing systems involving database management systems in federated or virtual databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Business, Economics & Management (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Economics (AREA)
  • Development Economics (AREA)
  • Finance (AREA)
  • Accounting & Taxation (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)
  • Software Systems (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The application provides a data processing method, a data processing device, a server and a readable storage medium, wherein the method comprises the following steps: the method comprises the steps of obtaining data elements of a merchant, obtaining a target identification code in a preset identification code interval, identifying the data elements according to the target identification code to obtain identified data elements, and constructing and obtaining the target warehouse network according to the identified data elements. According to the technical scheme, the target identification codes are used for identifying each piece of information in the data elements, and in the warehouse network creating process, different pieces of information can be determined to be associated according to the identification codes of each piece of information, so that data are prevented from being mixed when the association relation among commodities, suppliers and the warehouse network is maintained, and the warehouse network creating efficiency is improved.

Description

Data processing method, device, server and readable storage medium
Technical Field
The present application relates to the field of internet technologies, and in particular, to a data processing method, an apparatus, a server, and a readable storage medium.
Background
The intelligent replenishment and transfer system is divided into two stages of intelligent replenishment and intelligent transfer, can provide intelligent and automatic replenishment and transfer suggestions for merchants, and comprehensively improves the inventory management capability of the merchants. In the intelligent replenishment system, the commodities, the suppliers and the warehouse network have strong relevance, such as logic precedence, and the warehouse network needs to maintain the relevance among the commodities, the suppliers and the warehouse network in the creation process.
In the prior art, in the process of establishing a warehouse network, when maintaining the association relationship among the commodities, the suppliers and the warehouse network, the commodities, the suppliers and the warehouse network are mainly and separately divided into different modules, each module is maintained separately by manpower, and after the maintenance of each module is finished, the internal association relationship among the commodities, the suppliers and the warehouse network is maintained manually.
However, in the maintenance method in the prior art, since the association relationships among the commodities, the suppliers and the warehouse network are linked, the maintenance method is very complex, for novices with less proficient businesses, the maintenance of the association relationships is very tedious and time-consuming, data confusion is easy to occur, and finally the warehouse network creation efficiency is low.
Disclosure of Invention
The application provides a data processing method, a data processing device, a server and a readable storage medium, which are used for solving the problem of low construction efficiency of the existing warehouse network.
In a first aspect, an embodiment of the present application provides a data processing method, including:
acquiring data elements of merchants, wherein the data elements comprise commodity information, merchant information, supplier information, library node information and distribution list information;
acquiring a target identification code in a preset identification code interval, and identifying the data elements according to the target identification code to obtain identified data elements;
and constructing and obtaining a target warehouse network according to the identified data elements, wherein the target warehouse network is used for allocating replenishment to the merchant.
In a possible design of the first aspect, the identifying the data element according to the target identification code to obtain an identified data element includes:
and combining the target identification code with the data element to obtain the identified data element.
In another possible design of the first aspect, the combining the target identification code with the data element to obtain an identified data element includes:
extracting the character string of the merchant information, the character string of the commodity information, the character string of the supplier information, the character string of the library node information and the character string of the distributor information;
and combining the target identification code, the character string of the merchant information, the character string of the commodity information, the character string of the supplier information, the character string of the library node information and the character string of the distributor information to obtain the identified data elements.
In yet another possible design of the first aspect, the combining the target identification code, the character string of the merchant information, the character string of the merchandise information, the character string of the supplier information, the character string of the library node information, and the character string of the sales order information to obtain the identified data element includes:
combining the target identification code, the character string of the merchant information and the character string of the commodity information to obtain first combined data;
combining the target identification code, the character string of the merchant information and the character string of the provider information to obtain second combined data;
combining the target identification code, the character string of the merchant information and the character string of the library node information to obtain third combined data;
combining the target identification code, the character string of the merchant information and the character string of the distribution list information to obtain fourth combined data;
and taking the first combined data, the second combined data, the third combined data and the fourth combined data as the identified data elements.
In yet another possible design of the first aspect, the constructing a target mesh according to the identified data elements includes:
determining the incidence relation among the commodity information, the merchant information, the supplier information, the library node information and the distribution list information according to the target identification code;
and constructing and obtaining the target warehouse network according to the incidence relation, the commodity information, the merchant information, the supplier information, the library node information and the distribution list information.
In yet another possible design of the first aspect, the determining, according to the target identification code, an association relationship between the identified data elements includes:
acquiring the network type of the target warehouse network, wherein the network type of the target warehouse network comprises at least one of a supplier network, a distribution list network and a library node network;
and determining the association relationship among the commodity information, the merchant information, the supplier information, the library node information and the distribution list information according to the target identification code and the network type of the target warehouse network.
In yet another possible design of the first aspect, after the constructing the target mesh according to the identified data elements, the method further includes:
and storing the identified data elements into a preset database.
In yet another possible design of the first aspect, the storing the identified data elements in a preset database includes:
inserting the incidence relations among the commodity information, the merchant information, the supplier information, the library node information and the distribution list information in the identified data elements into corresponding tables respectively;
taking the target identification code as a main key of each table, and performing multi-table cascade connection on each table;
and storing each table after the cascading to the preset database.
In another possible design of the first aspect, after storing each table after the cascading in the preset database, the method further includes:
responding to the data query request, and acquiring a query identification code;
and querying the identified data elements in the preset database according to the query identification code and the target identification code.
In yet another possible design of the first aspect, after the constructing the target mesh according to the identified data elements, the method further includes:
acquiring a data deletion request, and determining data to be deleted in the identified data elements;
and deleting the data to be deleted according to the data deletion request.
In yet another possible design of the first aspect, after the constructing the target mesh according to the identified data elements, the method further includes:
acquiring a data updating request, and determining the updating data and the data to be updated in the identified data elements;
and replacing the data to be updated with the updated data.
In a second aspect, an embodiment of the present application provides a data processing apparatus, including:
the data acquisition module is used for acquiring data elements of merchants, wherein the data elements comprise commodity information, merchant information, supplier information, library node information and distribution list information;
the data identification module is used for acquiring a target identification code in a preset identification code interval, and identifying the data elements according to the target identification code to obtain identified data elements;
and the warehouse network construction module is used for constructing and obtaining a target warehouse network according to the identified data elements, and the target warehouse network is used for allocating the replenishment to the merchant.
In a third aspect, an embodiment of the present application provides a server, including a memory and at least one processor;
the memory stores computer-executable instructions;
the at least one processor executes computer-executable instructions stored by the memory, causing the at least one processor to perform the method as described above.
In a fourth aspect, the present application provides a readable storage medium, in which computer instructions are stored, and when executed by a processor, the computer instructions are used to implement the method described above.
In a fifth aspect, the present application provides a program product including computer instructions, which when executed by a processor implement the method as described above.
According to the data processing method, the data processing device, the server and the readable storage medium, the target identification code is used for identifying each piece of information in the data elements, in the warehouse network creating process, association among different pieces of information can be determined according to the identification code of each piece of information, data are prevented from being mixed up when the association relation among commodities, suppliers and the warehouse network is maintained, and the warehouse network creating efficiency is improved.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and together with the description, serve to explain the principles of the application;
fig. 1 is a schematic view of a scene of a data processing method according to an embodiment of the present application;
fig. 2 is a schematic structural diagram of a warehousing network provided in an embodiment of the present application;
fig. 3 is a schematic flowchart of a first embodiment of a data processing method according to an embodiment of the present application;
fig. 4 is a schematic flowchart of a second data processing method according to an embodiment of the present application;
fig. 5 is a schematic structural diagram of a data processing apparatus according to an embodiment of the present application;
fig. 6 is a schematic structural diagram of a server according to an embodiment of the present application.
With the above figures, there are shown specific embodiments of the present application, which will be described in more detail below. These drawings and written description are not intended to limit the scope of the inventive concepts in any manner, but rather to illustrate the inventive concepts to those skilled in the art by reference to specific embodiments.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are some embodiments of the present application, but not all embodiments. 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 application.
The terms referred to in this application are explained first:
BOD:
the Distribution Bill (BOD) is a hierarchical structure linking nodes inside the enterprise, each node being composed Of locations, thereby forming a Distribution route Of products with different levels defined in advance, and the Distribution flow Of the products inside the enterprise and to the locations Of the dealers and the like is defined.
Fig. 1 is a scene schematic diagram of a data processing method according to an embodiment of the present application. As shown in fig. 1, in the intelligent reconditioning system, when a service person creates a warehouse network, the service person can upload basic data to a server 11 by creating the basic data in a computer 10. The basic data created by the service personnel may specifically include creating a supplier, creating a commodity class, creating commodity master data, associating the commodity with the supplier, and creating a library node (e.g., a plant and Regional Distribution Center (RDC)). After the basic data are created, selecting a warehouse network to be created according to the created basic data, wherein the warehouse network comprises a library node warehouse network and a BOD warehouse network, and the library node warehouse network relates to business operations including commodity management in the library nodes, supplier network configuration and a library node network structure. The BOD cabin network relates to business operations including BOD network configuration and BOD commodity addition. The server 11 allocates the replenishment to the merchant according to the warehouse network created by the service personnel.
For example, fig. 2 is a schematic structural diagram of a warehousing network provided in an embodiment of the present application, as shown in fig. 2, during a replenishment process of a commodity, the commodity needs to be shipped from a supplier or a factory to an area Distribution Center (RDC), or the commodity is delivered from the supplier to a distributor and then sent to the RDC by the distributor. During the process of allocating the commodities, the commodities in the RDC are balanced to each front bin (the front bins should comprise three at least). When a user purchases a certain commodity, the inventory commodity in the front bin is sent to the sorting center, and the inventory commodity is distributed to the user through the distribution station by the sorting center.
In actual life application, when a business person creates a warehouse network of each merchant, basic data needed to be used is many, for example, commodity information specifically may include a commodity code, a commodity name, and a commodity category. The merchant information may specifically include a merchant code, a merchant name. The supplier information may specifically include a supplier code, a supplier name. The library node commodity information may specifically include a commodity name in the library node and a commodity code in the library node. The library node information may specifically include a library node code and a library node name. The BOD information may specifically include BOD code, BOD name. The BOD commodity information may specifically include a BOD commodity code and a BOD commodity name. The basic data have strong relevance, the relevance relation among the commodities of each merchant, the suppliers and the warehouse network needs to be correct, the basic data among different merchants need to be identified and distinguished, and the business processes need to be realized by manual operation of business personnel.
In the prior art, when a business person creates a warehouse network, the association relationship among commodities, suppliers and the warehouse network is generally managed by a single module, the internal relationship among the modules is mainly manually maintained, required data is created and modified in a plurality of pages, and the internal association relationship among the modules is maintained. However, since the association relationship has logic precedence and logic complexity, only experienced workers can complete the association, and therefore, a novice user who is not skilled in business is very prone to make mistakes and the efficiency is low. Meanwhile, even if the data testing is completed by experienced workers, the data may be modified by other testers in the data testing process after the warehouse network is established, so that the association relationship among the commodities, the suppliers and the warehouse network changes, the uniqueness and the correctness cannot be ensured, and the data is interrupted due to the abnormal data in the testing process.
In view of the above problems, embodiments of the present application provide a data processing method, an apparatus, a server, and a readable storage medium, where commodity information, merchant information, provider information, library node information, and BOD information of each merchant are identified by using an identification code, when a merchant creates a warehouse network, an association relationship among the commodity, the provider, and the warehouse network can be determined according to the identification code, thereby avoiding occurrence of data confusion and incorrect association relationship, improving the efficiency of creating the warehouse network, and simultaneously ensuring the identification degree of data by using the identification code, which is convenient for a tester to identify.
The technical solution of the present application will be described in detail below with reference to specific examples. It should be noted that the following specific embodiments may be combined with each other, and the same or similar concepts or processes may not be described in detail in some embodiments.
Fig. 3 is a schematic flowchart of a first embodiment of a data processing method provided in the embodiment of the present application, where the method may be applied to a server, and as shown in fig. 3, the method may specifically include the following steps:
s301, acquiring data elements of the merchant.
Wherein the data elements include commodity information, merchant information, supplier information, library node information, and distribution order information. In this embodiment, the data elements of the merchants may refer to the basic data, and the data elements may be different or the same for different merchants. For example, different merchants may have the same vendor and, for this reason, may be subsequently identified by an identification code.
Illustratively, the commodity information may include commodity category, commodity code, and commodity name. The merchant information includes a merchant code and a merchant name. The vendor information includes a vendor code and a vendor name. The library node information includes commodity codes added in the library nodes, commodity names added in the library nodes, library node codes and library node names. The sales order information includes a sales order code, a sales order name, a sales order commodity code, and a sales order commodity name.
In this embodiment, business personnel may upload data elements of merchants, and after a server acquires a data element of a certain merchant for the first time, the data element of the merchant may be stored. And when the relevant information of the merchant needs to be modified, the stored data elements can be directly read and modified.
S302, acquiring the target identification code in the preset identification code interval, and identifying the data elements according to the target identification code to obtain the identified data elements.
The preset identification code interval can be RN001-RN999, and the target identification code can be any one of RN001-RN999, such as RN 001. When the data elements are identified, the target identification codes can be added into the data elements so as to identify the data elements of different merchants.
As an example, merchant a may be assigned the target identification code RN001 and merchant B may be assigned another identification code RN 002. By adding RN001 to the data elements of the merchant A and adding RN002 to the data elements of the merchant B, the data elements of different merchants can be identified and distinguished. The method and the system prevent business personnel from being confused, can improve the identification degree of basic data and guide the business personnel to determine the association relationship among the commodities, the suppliers and the warehouse network of the merchant.
In some embodiments, when identifying the data element, the data element may be combined with the target identification code to obtain the identified data element.
For example, the target identification code may be used as a suffix to be combined, for example, the merchant information + the target identification code in the data element are combined to obtain the identified merchant information. For example, the target identification code may be used as a prefix, and the target identification code and the provider are combined to obtain the identified data element, for example, the target identification code + the provider are combined to obtain the identified provider information.
In this embodiment, taking the target identification code as RN001, the product information as S, and the supplier information as G, the identified product information is SRN001, and the identified supplier information is GRN001, so that when determining the association relationship between the product and the supplier, the association relationship between the product information S and the supplier G can be determined directly according to the suffix "RN 001", thereby avoiding the occurrence of data confusion caused by the association between the product information and other suppliers. For example, erroneously associating the commodity information S with the supplier K.
And S303, constructing and obtaining the target warehouse network according to the identified data elements.
The target warehouse network is used for allocating replenishment for the merchant. Illustratively, the target mesh may be divided into three types, library node network, provider network + BOD configuration, library node network, and provider network + BOD configuration. The target warehouse network can be any one of the three types, and can be specifically selected by service personnel.
In this embodiment, when creating the target warehouse network, the warehouse network may be created according to the identified data elements, and the association relationship between the data elements in the warehouse-out network is determined by using the target identification code, that is, the identified data elements are bound to the data in the target warehouse network by using the warehouse gateway system processing logic. For example, the target bin network is taken as a library node network, and the library node network comprises an RDC and a plurality of front bins. Wherein, both the RDC and the front bin are identified by the target identification code (for example, RN001), the commodity identified by the target identification code RN001 can be selected from the identified data elements, and added to the RDC or the front bin of the library node, that is, the association relationship between the library node and the commodity is determined.
For example, after the target warehouse network is created, the target warehouse network can be identified by using the target identification code, so that confusion of warehouse networks among different merchants is avoided.
According to the embodiment of the application, the commodity information, the merchant information, the supplier information, the library node information and the distribution list information in the data elements are identified by using the same target identification code, when the association relationship among all information is determined, the target identification code can be directly used for finding the information associated with the information, the condition that a business person associates certain information with wrong information during operation is avoided, and the warehouse network creating efficiency is improved.
Fig. 4 is a schematic flow chart of a second embodiment of the data processing method provided in the embodiment of the present application, and as shown in fig. 4, the step S302 may specifically be implemented by the following steps:
s401, extracting a character string of merchant information, a character string of commodity information, a character string of provider information, a character string of library node information and a character string of sales order information;
s402, combining the target identification code, the character string of the merchant information, the character string of the commodity information, the character string of the supplier information, the character string of the library node information and the character string of the distributor information to obtain the identified data elements.
In the present embodiment, the character string may be an abbreviation, for example, the character string of the merchant information may be sj, the character string of the goods information may be sp, the character string of the supplier information may be gys, the character string of the library node information may be kjd, and the character string of the sales order information may be fxd.
For example, when the target identification code is combined with the character string, the target identification code may be combined with each character string, for example, taking the target identification code as RN001 as an example, combining RN001 as a suffix with the character string of the merchant information to obtain spRN001, combining with the character string of the vendor information to obtain gysRN001, and combining with the character string of the library node information to obtain kjdRN 001.
Further, in some embodiments, the step S402 may be specifically implemented by the following steps:
combining the target identification code, the character string of the merchant information and the character string of the commodity information to obtain first combined data;
combining the target identification code, the character string of the merchant information and the character string of the provider information to obtain second combined data;
combining the target identification code, the character string of the merchant information and the character string of the library node information to obtain third combined data;
combining the target identification code, the character string of the merchant information and the character string of the distribution list information to obtain fourth combined data;
and taking the first combined data, the second combined data, the third combined data and the fourth combined data as identified data elements.
In this embodiment, the merchant information at least includes a merchant name and a merchant code, the provider information at least includes a provider name and a provider code, and the library node information at least includes a library node name and a library node code. Illustratively, the format of the combined data is merchant + data + target identification code. The data in the format refers to the above-mentioned character string of the commodity information, the character string of the supplier information, the character string of the distributor information, and the character string of the library node information.
Illustratively, taking the name of a merchant in the merchant information as welfare as an example, the character string extracted from the name of the merchant is AL, the character string extracted from the name of the merchant in the commodity information is S, the character string extracted from the name of the provider in the information of the provider is GYS, the character string extracted from the name of a library node in the information of the library node is KJD, the target identification code is RN001, when the target identification code RN001 is combined with the character string, the first combined data obtained by combining may be ALSRN001, the second combined data obtained by combining may be ALGYSRN001, and the third data obtained by combining may be ALKJDRN 001.
According to the embodiment of the application, the target identification code and the character string are combined, the data identification degree can be improved, the incidence relation between the data and the data is conveniently determined, the data chaos is avoided, the error condition is caused, and the warehouse network creating efficiency is improved.
In some embodiments, the step S303 may be specifically implemented by the following steps:
determining the incidence relation among the commodity information, the merchant information, the supplier information, the library node information and the distribution list information according to the target identification code;
and constructing and obtaining the target warehouse network according to the incidence relation, the commodity information, the merchant information, the supplier information, the library node information and the distribution list information.
In this embodiment, the commodity information may include commodities and commodity categories, an association relationship may exist between the commodities and the suppliers, and an association relationship may also exist between the library nodes and the commodities. For example, when a supplier associated with a certain commodity is determined, the supplier may be determined directly according to the target identification code RN001, for example, when a certain supplier is identified by the target identification code RN001, the commodity identified by the target identification code RN001 may be searched directly according to the target identification code, that is, the commodity associated with the supplier is determined.
Illustratively, when the constructed target warehouse network is a warehouse node network, a certain warehouse node in the warehouse node network needs to be added with a commodity, and if the warehouse node is identified by the target identification code RN001, the commodity identified by the RN001 can be directly selected and added into the warehouse node. Illustratively, when the constructed target network is configured as provider network + BOD, a certain provider in the provider network needs to add a commodity, and if the provider is identified by the target identification code RN001, the commodity identified by RN001 may be directly selected and added to the provider.
According to the embodiment of the application, the incidence relation among the commodity information, the merchant information, the supplier information, the library node information and the distribution list information can be determined through the target identification code, confusion is avoided when the incidence relation among the commodity, the supplier and the warehouse network is maintained, meanwhile, the uniqueness of the incidence relation can be further ensured, and when the incidence relation between the data and the data is wrong, the target identification code can be rapidly checked out.
Further, on the basis of the above embodiments, in some embodiments, the step of "determining the association relationship between the commodity information, the merchant information, the supplier information, the library node information, and the distribution order information according to the target identification code" may be specifically implemented by the following steps:
acquiring the network type of a target warehouse network;
and determining the association relationship among the commodity information, the merchant information, the supplier information, the library node information and the distribution list information according to the target identification code and the network type of the target warehouse network.
Wherein the network type of the target warehouse network comprises at least one of a supplier network, a distribution list network and a library node network.
In this embodiment, different network types and different association relationships exist, and for example, when the target storage network is a supplier network, the association relationship between the commodity and the supplier, the association relationship between the commodity and the commodity classification, the association relationship between the BOD network and the commodity, and the association relationship between the supplier network and the library node are included. When the library node network is used, the association relationship between the library node and the commodity is included.
In some embodiments, after the target warehouse network is constructed, the identified data elements may be stored in a preset database. Illustratively, the preset database may be a relational database management system Mysql.
In some embodiments, when storing the identified data elements in the preset database, the following steps may be specifically implemented:
respectively inserting the incidence relations among the commodity information, the merchant information, the supplier information, the library node information and the distribution list information in the identified data elements into corresponding tables;
the target identification code is used as a main key of each table, and multi-table cascade connection is carried out on each table;
and storing each table after the cascading to a preset database.
In this embodiment, the Mysql database may be used as a preset database, to store the identified data, and perform single table insertion and multi-table concatenation. Specifically, after the commodity information is identified by the target identification code, the commodity information can be inserted into one table, after the merchant information is identified by the target identification code, the merchant information can be inserted into another table, the supplier information, the library node information, the distribution order information and the like can be respectively inserted into a single table, and all the tables are cascaded by the target identification code.
For example, after single-table insertion and multi-table concatenation are performed, duplicate detection may be performed on the identified data, it is determined whether duplicate data is stored in Mysql, and if so, the duplicate data is deleted.
According to the embodiment of the application, through single-table insertion and multi-table cascading, when a certain column of data in one table is changed, the column of data in other tables cascaded with the certain column of data can be changed, and correctness of relevance between the data and the data is guaranteed.
In some embodiments, the data processing method may further include the steps of:
responding to the data query request, and acquiring a query identification code;
and querying the identified data elements in a preset database according to the query identification code and the target identification code.
When the database is queried, a multi-table query technology can be used, all the inserted data tables associate the main key foreign keys, and all the data elements identified by the target identification codes are directly queried and obtained by using the target identification codes.
Illustratively, the target identification code is any one of the RN001-RN999, and when the query identification code matches the target identification code, the data element identified by the target identification code will be output.
Illustratively, data elements may also be represented in the computer in the form of a table.
According to the data element identification method and device, the data element is identified by using the target identification code, the identified data element can be quickly inquired through the target identification code, and when the incidence relation between the data and the data is wrong, the data with the incidence error can be quickly checked.
For example, in some embodiments, the data processing method may further include the following steps:
acquiring a data deletion request, and determining data to be deleted in the identified data elements;
and deleting the data to be deleted according to the data deletion request.
In this embodiment, the data to be deleted may be at least one of commodity information, merchant information, provider information, library node information, and distribution list information in the data element.
According to the embodiment of the application, the identified data elements are deleted through the data deletion request, so that the target identification code can be recovered, and identification code resources are fully saved.
In some embodiments, the data processing method may further include the steps of:
acquiring a data updating request, and determining the data to be updated in the updated data and the identified data elements;
and replacing the data to be updated with the updated data.
For example, the merchant name may be updated, for example, the format of the identified data element may be merchant + data + target identification code, where the data may refer to a character string of commodity information, a character string of vendor information, a character string of library node information, and a character string of sales order information. When updating is needed, the name of the business can be changed to another business.
Illustratively, taking a character string of a merchant name of merchant information in the data to be updated as AL, a character string of a merchant name in the merchant information in the update data is LN, before the update, the data elements are AL + data + the target identification code, and after the update, the data elements are LN + data + the target identification code.
According to the embodiment of the application, the data is updated, the warehouse network relationship of the original merchant can be reused, the warehouse network does not need to be created again, the association relationship among commodities, suppliers and the warehouse network is maintained, and the resource utilization efficiency is improved.
The following are embodiments of the apparatus of the present application that may be used to perform embodiments of the method of the present application. For details which are not disclosed in the embodiments of the apparatus of the present application, reference is made to the embodiments of the method of the present application.
Fig. 5 is a schematic structural diagram of a data processing apparatus according to an embodiment of the present application, where the data processing apparatus may be integrated on a server, or may be independent of the server and cooperate with the server to implement the present solution. As shown in fig. 5, the data processing apparatus 50 includes a data acquisition module 51, a data identification module 52, and a mesh construction module 53.
The data acquiring module 51 is configured to acquire data elements of a merchant. The data identification module 52 is configured to obtain the target identification code in the preset identification code interval, and identify the data elements according to the target identification code to obtain identified data elements. And the warehouse network construction module 53 is used for constructing and obtaining the target warehouse network according to the identified data elements.
Wherein the data elements include commodity information, merchant information, supplier information, library node information, and distribution order information. And the target warehouse network is used for allocating replenishment for the merchant.
In some embodiments, the data identification module 52 may be specifically configured to:
and combining the target identification code with the data elements to obtain the identified data elements.
Optionally, in some embodiments, the data identification module 52 may be specifically configured to:
extracting a character string of merchant information, a character string of commodity information, a character string of provider information, a character string of library node information and a character string of distributor information;
and combining the target identification code, the character string of the merchant information, the character string of the commodity information, the character string of the supplier information, the character string of the library node information and the character string of the distributor information to obtain the identified data elements.
Optionally, in some embodiments, the data identification module 52 may be specifically configured to:
combining the target identification code, the character string of the merchant information and the character string of the commodity information to obtain first combined data;
combining the target identification code, the character string of the merchant information and the character string of the provider information to obtain second combined data;
combining the target identification code, the character string of the merchant information and the character string of the library node information to obtain third combined data;
combining the target identification code, the character string of the merchant information and the character string of the distribution list information to obtain fourth combined data;
and taking the first combined data, the second combined data, the third combined data and the fourth combined data as identified data elements.
In some embodiments, the aforementioned bin network constructing module 53 may be specifically configured to:
determining the incidence relation among the commodity information, the merchant information, the supplier information, the library node information and the distribution list information according to the target identification code;
and constructing and obtaining the target warehouse network according to the incidence relation, the commodity information, the merchant information, the supplier information, the library node information and the distribution list information.
Optionally, in some embodiments, the mesh warehouse constructing module 53 may be specifically configured to:
acquiring the network type of a target warehouse network, wherein the network type of the target warehouse network comprises at least one of a supplier network, a distribution list network and a library node network;
and determining the association relationship among the commodity information, the merchant information, the supplier information, the library node information and the distribution list information according to the target identification code and the network type of the target warehouse network.
In some embodiments, the data processing apparatus 50 may further include a data storage module, configured to store the identified data elements in a preset database.
Optionally, in some embodiments, the data storage module may be specifically configured to:
respectively inserting the incidence relations among the commodity information, the merchant information, the supplier information, the library node information and the distribution list information in the identified data elements into corresponding tables;
the target identification code is used as a main key of each table, and multi-table cascade connection is carried out on each table;
and storing each table after the cascading to a preset database.
In some embodiments, the data processing apparatus 50 may further include a query module configured to:
responding to the data query request, and acquiring a query identification code;
and querying the identified data elements in a preset database according to the query identification code and the target identification code.
In some embodiments, the data processing apparatus 50 may further include a data deleting module, configured to:
acquiring a data deletion request, and determining data to be deleted in the identified data elements;
and deleting the data to be deleted according to the data deletion request.
In some embodiments, the data processing apparatus 50 may further include a data updating module configured to:
acquiring a data updating request, and determining the data to be updated in the updated data and the identified data elements;
and replacing the data to be updated with the updated data.
The apparatus provided in the embodiment of the present application may be used to execute the method in the above embodiments, and the implementation principle and the technical effect are similar, which are not described herein again.
It should be noted that the division of the modules of the above apparatus is only a logical division, and the actual implementation may be wholly or partially integrated into one physical entity, or may be physically separated. And these modules can be realized in the form of software called by processing element; or may be implemented entirely in hardware; and part of the modules can be realized in the form of calling software by the processing element, and part of the modules can be realized in the form of hardware. For example, the data identification module may be stored in the form of program code in a memory of the apparatus, and a processing element of the apparatus may call and execute the functions of the data identification module. Other modules are implemented similarly. In addition, all or part of the modules can be integrated together or can be independently realized.
For another example, when some of the above modules are implemented in the form of a processing element scheduler code, the processing element may be a general-purpose processor, such as a Central Processing Unit (CPU) or other processor that can call program code. As another example, these modules may be integrated together, implemented in the form of a system-on-a-chip (SOC).
In the above embodiments, the implementation may be wholly or partially realized by software, hardware, firmware, or any combination thereof. When implemented in software, may be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. The procedures or functions according to the embodiments of the present application are all or partially generated when the computer program instructions are loaded and executed on a computer. The computer may be a general purpose computer, a special purpose computer, a network of computers, or other programmable device. The computer instructions may be stored in a computer readable storage medium or transmitted from one computer readable storage medium to another, for example, the computer instructions may be transmitted from one website, computer, server, or data center to another website, computer, server, or data center by wire (e.g., coaxial cable, fiber optic, Digital Subscriber Line (DSL)) or wirelessly (e.g., infrared, wireless, microwave, etc.). The computer-readable storage medium can be any available medium that can be accessed by a computer or a data storage device, such as a server, a data center, etc., that incorporates one or more of the available media. The usable medium may be a magnetic medium (e.g., floppy disk, hard disk, magnetic tape), an optical medium (e.g., DVD), or a semiconductor medium (e.g., Solid State Disk (SSD)), among others.
Fig. 6 is a schematic structural diagram of a server according to an embodiment of the present application. As shown in fig. 6, the server 60 includes: at least one processor 61, memory 62, bus 63, and communication interface 64.
Wherein: the processor 61, communication interface 64 and memory 62 communicate with each other via a bus 63.
A communication interface 64 for communicating with other devices. The communication interface includes a communication interface for data transmission.
The processor 61 is configured to execute the computer-executable instructions stored in the memory 62, and may specifically execute the relevant steps in the method described in the above embodiments.
The processor 61 may be a central processing unit, or an Application Specific Integrated Circuit (ASIC), or one or more Integrated circuits configured to implement an embodiment of the present invention. The server comprises one or more processors, which can be the same type of processor, such as one or more CPUs; or may be different types of processors such as one or more CPUs and one or more ASICs.
And the memory is used for storing computer execution instructions. The memory may comprise high speed RAM memory and may also include non-volatile memory, such as at least one disk memory.
The present embodiment also provides a readable storage medium, in which computer instructions are stored, and when at least one processor of the server executes the computer instructions, the server executes the data processing method provided in the above various embodiments.
The present embodiments also provide a program product comprising computer instructions stored in a readable storage medium. The computer instructions can be read by at least one processor of the server from a readable storage medium, and the computer instructions can be executed by the at least one processor to enable the server to implement the data processing method provided by the various embodiments.
In the present application, "at least one" means one or more, "a plurality" means two or more. "and/or" describes the association relationship of the associated objects, meaning that there may be three relationships, e.g., a and/or B, which may mean: a exists alone, A and B exist simultaneously, and B exists alone, wherein A and B can be singular or plural. The character "/" generally indicates that the former and latter associated objects are in an "or" relationship; in the formula, the character "/" indicates that the preceding and following related objects are in a relationship of "division". "at least one of the following" or similar expressions refer to any combination of these items, including any combination of the singular or plural items. For example, at least one (one) of a, b, or c, may represent: a, b, c, a-b, a-c, b-c, or a-b-c, wherein a, b, c may be single or multiple.
It is to be understood that the various numerical references referred to in the embodiments of the present application are merely for convenience of description and distinction and are not intended to limit the scope of the embodiments of the present application. In the embodiment of the present application, the sequence numbers of the above-mentioned processes do not mean the execution sequence, and the execution sequence of each process should be determined by its function and inherent logic, and should not constitute any limitation to the implementation process of the embodiment of the present application.
Finally, it should be noted that: the above embodiments are only used for illustrating the technical solutions of the present application, and not for limiting the same; although the present application has been described in detail with reference to the foregoing embodiments, it should 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 or all of the technical features may be equivalently replaced; and the modifications or the substitutions do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present application.

Claims (15)

1. A data processing method, comprising:
acquiring data elements of merchants, wherein the data elements comprise commodity information, merchant information, supplier information, library node information and distribution list information;
acquiring a target identification code in a preset identification code interval, and identifying the data elements according to the target identification code to obtain identified data elements;
and constructing and obtaining a target warehouse network according to the identified data elements, wherein the target warehouse network is used for allocating replenishment to the merchant.
2. The method according to claim 1, wherein the identifying the data element according to the target identification code to obtain an identified data element comprises:
and combining the target identification code with the data element to obtain the identified data element.
3. The method of claim 2, wherein combining the object identification code with the data element to obtain an identified data element comprises:
extracting the character string of the merchant information, the character string of the commodity information, the character string of the supplier information, the character string of the library node information and the character string of the distributor information;
and combining the target identification code, the character string of the merchant information, the character string of the commodity information, the character string of the supplier information, the character string of the library node information and the character string of the distributor information to obtain the identified data elements.
4. The method of claim 3, wherein the combining the target identification code, the character string of the merchant information, the character string of the merchandise information, the character string of the supplier information, the character string of the library node information, and the character string of the sales order information to obtain the identified data elements comprises:
combining the target identification code, the character string of the merchant information and the character string of the commodity information to obtain first combined data;
combining the target identification code, the character string of the merchant information and the character string of the provider information to obtain second combined data;
combining the target identification code, the character string of the merchant information and the character string of the library node information to obtain third combined data;
combining the target identification code, the character string of the merchant information and the character string of the distribution list information to obtain fourth combined data;
and taking the first combined data, the second combined data, the third combined data and the fourth combined data as the identified data elements.
5. The method according to claim 1, wherein constructing a target bin network from the identified data elements comprises:
determining the incidence relation among the commodity information, the merchant information, the supplier information, the library node information and the distribution list information according to the target identification code;
and constructing and obtaining the target warehouse network according to the incidence relation, the commodity information, the merchant information, the supplier information, the library node information and the distribution list information.
6. The method of claim 5, wherein determining the association between the merchandise information, merchant information, supplier information, library node information, and the sales order information according to the target identification code comprises:
acquiring the network type of the target warehouse network, wherein the network type of the target warehouse network comprises at least one of a supplier network, a distribution list network and a library node network;
and determining the association relationship among the commodity information, the merchant information, the supplier information, the library node information and the distribution list information according to the target identification code and the network type of the target warehouse network.
7. The method of claim 1, wherein after constructing the target mesh of bins from the identified data elements, further comprising:
and storing the identified data elements into a preset database.
8. The method of claim 7, wherein storing the identified data elements to a predetermined database comprises:
inserting the incidence relations among the commodity information, the merchant information, the supplier information, the library node information and the distribution list information in the identified data elements into corresponding tables respectively;
taking the target identification code as a main key of each table, and performing multi-table cascade connection on each table;
and storing each table after the cascading to the preset database.
9. The method according to claim 8, wherein after storing the tables after the cascading in the preset database, the method further comprises:
responding to the data query request, and acquiring a query identification code;
and querying the identified data elements in the preset database according to the query identification code and the target identification code.
10. The method according to claim 1, wherein after constructing the target mesh according to the identified data elements, further comprising:
acquiring a data deletion request, and determining data to be deleted in the identified data elements;
and deleting the data to be deleted according to the data deletion request.
11. The method according to claim 1, wherein after constructing the target mesh according to the identified data elements, further comprising:
acquiring a data updating request, and determining the updating data and the data to be updated in the identified data elements;
and replacing the data to be updated with the updated data.
12. A data processing apparatus, comprising:
the data acquisition module is used for acquiring data elements of merchants, wherein the data elements comprise commodity information, merchant information, supplier information, library node information and distribution list information;
the data identification module is used for acquiring a target identification code in a preset identification code interval, and identifying the data elements according to the target identification code to obtain identified data elements;
and the warehouse network construction module is used for constructing and obtaining a target warehouse network according to the identified data elements, and the target warehouse network is used for allocating the replenishment to the merchant.
13. A server, comprising a memory and at least one processor;
the memory stores computer-executable instructions;
the at least one processor executing the computer-executable instructions stored by the memory causes the at least one processor to perform the method of any one of claims 1-11.
14. A readable storage medium having stored therein computer instructions, which when executed by a processor, are adapted to implement the method of any one of claims 1-11.
15. A program product comprising computer instructions, characterized in that the computer instructions, when executed by a processor, implement the method of any of claims 1-11.
CN202111076820.5A 2021-09-14 2021-09-14 Data processing method, device, server and readable storage medium Pending CN113780950A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111076820.5A CN113780950A (en) 2021-09-14 2021-09-14 Data processing method, device, server and readable storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111076820.5A CN113780950A (en) 2021-09-14 2021-09-14 Data processing method, device, server and readable storage medium

Publications (1)

Publication Number Publication Date
CN113780950A true CN113780950A (en) 2021-12-10

Family

ID=78843703

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111076820.5A Pending CN113780950A (en) 2021-09-14 2021-09-14 Data processing method, device, server and readable storage medium

Country Status (1)

Country Link
CN (1) CN113780950A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2024098976A1 (en) * 2022-11-09 2024-05-16 北京京东振世信息技术有限公司 Information processing method and apparatus, and device and storage medium.

Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2016206556A1 (en) * 2015-06-25 2016-12-29 阿里巴巴集团控股有限公司 Method of processing warehouse resource information and providing inventory information and device utilizing same
US20190026691A1 (en) * 2016-03-31 2019-01-24 Cainiao Smart Logistics Holding Limited Method, apparatus, and system for scheduling logistic resources
CN109767170A (en) * 2018-02-07 2019-05-17 徐颂 Supply chain data acquisition method and system compatible with standard article codes and server
CN110516990A (en) * 2019-07-18 2019-11-29 浙江子不语电子商务有限公司 A kind of inventory occupies in advance and management system
US10586073B1 (en) * 2014-05-27 2020-03-10 Amazon Technologies, Inc. Preserving customer data privacy for merchant orders
WO2020215558A1 (en) * 2019-04-26 2020-10-29 平安科技(深圳)有限公司 Data storage method, data query method, apparatus and device and storage medium
CN111882275A (en) * 2020-07-24 2020-11-03 浙江商擎达电子商务有限公司 Trade big data management method and system based on industrial identification analysis
CN113343641A (en) * 2021-06-21 2021-09-03 湖北亿咖通科技有限公司 Equipment identification method, device and system and cloud server

Patent Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10586073B1 (en) * 2014-05-27 2020-03-10 Amazon Technologies, Inc. Preserving customer data privacy for merchant orders
WO2016206556A1 (en) * 2015-06-25 2016-12-29 阿里巴巴集团控股有限公司 Method of processing warehouse resource information and providing inventory information and device utilizing same
CN106327114A (en) * 2015-06-25 2017-01-11 阿里巴巴集团控股有限公司 Warehouse resource information processing method and device, and method and device for providing inventory information
US20190026691A1 (en) * 2016-03-31 2019-01-24 Cainiao Smart Logistics Holding Limited Method, apparatus, and system for scheduling logistic resources
CN109767170A (en) * 2018-02-07 2019-05-17 徐颂 Supply chain data acquisition method and system compatible with standard article codes and server
WO2020215558A1 (en) * 2019-04-26 2020-10-29 平安科技(深圳)有限公司 Data storage method, data query method, apparatus and device and storage medium
CN110516990A (en) * 2019-07-18 2019-11-29 浙江子不语电子商务有限公司 A kind of inventory occupies in advance and management system
CN111882275A (en) * 2020-07-24 2020-11-03 浙江商擎达电子商务有限公司 Trade big data management method and system based on industrial identification analysis
CN113343641A (en) * 2021-06-21 2021-09-03 湖北亿咖通科技有限公司 Equipment identification method, device and system and cloud server

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
张进;韩士玉;仇盼敏;李荟霞;: "条码技术在"海月龙宫物流港"缺陷农产品召回中的应用", 中国自动识别技术, no. 06 *
汪家伟等: ""基于区块链的茶叶可信溯源系统的设计与实现"", 《黑龙江八一农垦大学学报》, vol. 32, no. 02, 30 April 2020 (2020-04-30), pages 74 - 81 *
董千里: "《物流工程》", 31 October 2007, 东北财经大学出版社, pages: 265 - 266 *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2024098976A1 (en) * 2022-11-09 2024-05-16 北京京东振世信息技术有限公司 Information processing method and apparatus, and device and storage medium.

Similar Documents

Publication Publication Date Title
CN111459985B (en) Identification information processing method and device
CN108228817A (en) Data processing method, device and system
CN111506559A (en) Data storage method and device, electronic equipment and storage medium
CN107016047A (en) Document query, document storing method and device
CN107092491B (en) Configuration loading method and system
US20170154123A1 (en) System and method for processing metadata to determine an object sequence
CN110543469B (en) Database version management method and server
JP2007264768A (en) System development support program, apparatus and method
US20210334292A1 (en) System and method for reconciliation of data in multiple systems using permutation matching
CN113780950A (en) Data processing method, device, server and readable storage medium
CN111522881B (en) Service data processing method, device, server and storage medium
CN110765100B (en) Label generation method and device, computer readable storage medium and server
US11531706B2 (en) Graph search using index vertices
CN112287027B (en) Database synchronization method, device, equipment and storage medium
CN112204527A (en) Method and system for processing engineering data in a multi-engineering system environment
CN114564501A (en) Database data storage and query methods, devices, equipment and medium
CN115495620A (en) Data management method based on graph structure and related equipment
CN112163024B (en) Configuration information export and import method based on hierarchical association structure
CN111309370B (en) Version number directed graph ordering auditing method and system for multi-project multi-system environment
CN111209304B (en) Data processing method, device and system
CN113934729A (en) Data management method based on knowledge graph, related equipment and medium
CN111736848A (en) Packet conflict positioning method and device, electronic equipment and readable storage medium
US20200192938A1 (en) Graph creation from multiple databases
CN114741577B (en) Service data management method, system, electronic equipment and readable storage medium
CN112000664B (en) Data synchronization method, device, electronic equipment and readable storage medium

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